Dashboard and report building service using Hyperion Interactive Reporting and Oracle PL/SQL. All the usual BI tools were utilised including PL/SQL packages, table functions, views, synonyms and JavaScript scripting. Automation of several key reports resulting in significant time savings for the customer as well as supply of general Business Intelligence best practice advice.

Oracle MI development for a HP Service Manager and Asset Manager enterprise-wide implementation project. Oracle and Hyperion used to deliver business critical MI reports for multiple business units. The build, test and implementation of PL/SQL packages using table functions to build ‘on-the-fly’ history and snapshot tables with complex runtime transformation logic. The creation of views and synonyms. The build and… Read MoreHP Service Manager Metrics for HMG »

Business Objects development using Agile methodology. We delivered a working MI system in 6 weeks that provided key metrics about pension product sales activity and performance. Activities included: The design, development, implementation and support of the entire Business Objects Enterprise component including server build, presentation database design (Kimball methodology), security model, universes, reports and dashboards. Extensive use of all Business… Read MoreAgile XI31 at Sun Life of Canada »

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 »