Business Objects developer MIS reports to Rolls Royce staff users. The main technologies used were Oracle and Business Objects. Work included the building of complex universes and reports, PL/SQL packages, SQL query tuning and capturing user requirements.
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 »
Business Objects Technical Consultant for Reuters Information Systems (RIS) worldwide. Part of small team acting as ‘gurus’ to the rest of Reuters concerned with Business Objects Infrastructure, how to deliver functionality to over 1200 users, establishing ‘best practice’ guidelines and liaising with Business Objects Corporation. Tasked with build and maintenance of European Repository with over 1200 users. Included user training… Read MoreBusiness Objects and Oracle at Reuters »
Conversion of a FOCUS M/F based MIS to a three-tier system comprising Business Objects V3/V4, an Oracle Gateway and DB2 database. Design, build, test and implementation of major enhancements to BA’s customer performance tracking and incentive system based around BA’s sales data warehouse (Teradata).
Data warehouse and data mart development at all parts of the development and testing life cycle.