Oracle EBS Reporting – a challenging project that involved the design, build and implementation of a Business Objects and Oracle reporting solution that provided management information reports from an Oracle EBS R12 Financials system. There were many parts to this project which ran for approximately 12 months and included: complex universes for an OLTP schema; complex Web Intelligence reports; PL/SQL… Read MoreBusiness Objects XIR2 and Oracle EBS Financials at Cardiff University »
Migration of multiple mixed version Business Objects legacy deployments to a single XIR2 enterprise system incorporating over 5000 users and approximately 8000 documents. All migration activities but particularly Workflow Assistant script creation, Personal Document migration, trouble shooting and post migration support.
Design and build a reporting system used to provide KPI and management reports about an operational help desk system. The main technologies used were Business Objects XIR2 and Microsoft SQL Server.
Business Objects Upgrade – upgrade, migration and consolidation of Vodafone’s entire UK Business Objects reporting system. This involved the upgrade of mixed version 5 and 6 deployments with over 4500 users and associated content to XIR2. Business Objects universe and report development, testing and implementation on a variety of databases including Oracle, Teradata and SQL Server. Frequent liaison with key… Read MoreBusiness Objects XIR2 Upgrade, Oracle and Teradata at Vodafone UK »
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.