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 package to control the data loads, ensure data consistency and integrity, automate manual checks on database jobs and provide a formal run control structure thus saving staff considerable time.