Tableau at Jaguar Land Rover

  • Tableau Server migration of on-premises Tableau cluster to Google Virtual Private Cloud. Design of high performance ‘Self-Serve’ architecture in Google VPC. Migration of 200 projects and 4000 users to the new platform.
  • Tableau Server Cluster implementation serving 6000 users located across the world.
  • Design and delivery of Vehicle Financing BI solution using SAP Business Objects, SAP Data Services and Oracle technologies. Management of onshore and offshore team.

BI Report Building for HMG

  • 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.

HP Service Manager Metrics for HMG

  • 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 execution of automated test scripts.
  • The creation of Oracle MI schema build scripts.

Agile XI31 at Sun Life of Canada

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 Objects components.
  • Demonstration and training to senior stakeholders.

Business Objects XIR2 and XI31 at Zurich Financial Services

  • Migration and conversion of Full Client documents from Business Objects version 6.5 to both XIR2 and XI31.
  • The main challenges in this project were the multiple platforms and environments in existence at this client, the fact that the user base was geographically distributed throughout the UK, Europe and the US, and the complexity of the migrated reports.

Business Objects XIR2 and Oracle EBS Financials at Cardiff University

  • 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 packages and and other database objects; comprehensive unit and system testing and defect resolution; post implementation support including user training, workshops and trouble shooting.
  • Redesign existing Business Objects infrastructure to incorporate enterprise features including: BOE failover; increased resilience; https and SSL; LDAP over SSL; web server deployment and application server optimization. This project included the design, documentation, deployment, testing and migration from the old to the new system.
  • Provided a consultancy service for client’s implementation of Business Objects involving the use of all Business Objects modules at all stages of the development cycle. Included complex universe development on an OLTP student record database (SITS) and complex report development.
  • Developed a scheduling application using Oracle PL/SQL packages and the Business Objects infrastructure to allow non-technical staff to run and schedule various database jobs, freeing database administrators for more complex tasks.
  • Skill transfer to client through a process of ‘best practice’ guidance, mentoring and documentation of Business Objects knowledge, training course delivery and user workshops.
  • Universe design and build. Report writing.

Business Objects XIR2 Upgrade at HMRC

  • 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.

Business Objects XIR2 Upgrade, Oracle and Teradata at Vodafone UK

  • 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 business users for requirements capture, training and post implementation support.
  • Design, build, implementation and support of a highly complex Oracle / Business Objects reporting solution used to report on Clarify CRM data. Database included partitioned tables, multiple star schemas, summary tables and indexes for reporting (inc. bitmap). Universes contained multiple contexts, aggregate awareness, multiple star schemas, complex objects and aliases. Provided comprehensive documentation including design specification, test plan and results, and a detailed implementation plan. Performed extensive System Test and supported UAT using Test Director to manage defects and fixes.
  • Designed star schema data marts using dimensional modelling techniques from customer requirements and source system documentation. The designs facilitated efficient data retrieval using auto-generated SQL and included summary fact tables and multiple fact tables at different grains.
  • Developed reporting solutions for Clarify CRM, E.Piphany Real-time Marketing and Unica Campaign Management programmes giving operational and strategic managers the ability to access and report on business critical data.
  • Responsible for comprehensive support to over 4500 users in accordance with defined SLAs covering the following areas: Business Objects (including complex reports with macros), Designer, Supervisor, Web Intelligence, Broadcast Agent, Publisher, Auditor, Repository database maintenance, multiple repositories, user migration, software installation, version migration.
  • Designed and implemented Business Objects security domain for over 4500 users with multiple levels of access for users, designers and supervisors, incorporating 1st line support desks and separation of the development and support functions.
  • Tuned Business Objects Repository (Oracle) to reduce Publisher login time from 5 minutes to 5 seconds for over 3000 Publisher users.
  • Developed and delivered business relevant user training and workshops.