Categories

Huw John Williams - Business Intelligence Specialist

Hello. My name is Huw John Williams. I am a professional contractor specialising in Business Intelligence with over 16 years experience designing and developing data warehouses, data marts and associated reporting applications using Business Objects, Oracle and related technologies.

Over the years I’ve worked for many different clients including Vodafone, Business Objects, BT, British Airways and Reuters.

To hire me, contact me by email huw@huwjohnwilliams.com or telephone +44 7768 291217.

Agile XI31 at Sun Life of Canada

At Sun Life of Canada, I was the lead Business Objects developer in a project team 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 XI31 / XIR2 Services

Utilise over 16 years of Business Objects experience – I can supply the following services on a fixed price or per day basis:

  • Universe Creation
    Most of my projects have involved Universe creation. You can read more about them here.

  • Report Writing and Dashboard Creation
    Most of my projects have involved report and dashboard creation or conversion using Web Intelligence, Desktop Intelligence and Xcelsius. Read more about them here.

  • Business Objects Enterprise Installation and Configuration
    I have installed and configured  BOE XI31 and XIR2 systems for large organisations. Read more about where here and here.
  • CMC and Security Model Setup and Administration
    I can setup and configure your CMC and security model to industry standards using recognised best practice. Read where I have done this before here and here.

To find out more or for an informal chat, please email me at huw@huwjohnwilliams.com or call +447768 291217

Business Objects XIR2 and XI31 at Zurich Financial Services

  • At Zurich, I was responsible for the migration and conversion of Full Client documents from Business Objects version 6.5 to both XIR2 and XI31. During this project I made extensive use of the Import Wizard and the Report Conversion Tool, as well as the Web Intelligence Rich Client in the XI31 environments. I was able to achieve a 100% conversion rate of complex 6.5 Full Client documents to Web Intelligence reports, not least because of the enhanced functionality of Web Intelligence that is available in XI31 SP2.
  • 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

  • At Cardiff University I have undertaken a number of projects, some of which are detailed below.
  • 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 approximately12 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.
  • Acting as the technical architect, I redesigned the 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 a transactional 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.