April 2001

Oracle and Business Objects at NPower

Re-engineered manual SQL database load and transformation scripts to use automated PL/SQL packages. Packages included complex exception handling and restart procedures. Constrained by an overnight operational runtime window and CPU resource, much of the work was concerned with code and database optimisation. Resulting code halved the load time and saved the department considerable computing re-charge costs. Developed a PL/SQL auditing… Read MoreOracle and Business Objects at NPower »