Data Transformation project for a UK Retail & Commercial Bank

The challenge:

Following an acquisition, our client, a UK Retail & Commercial Bank, needed to build a new in-house data warehouse for management information and reporting across the whole organisation. Due to dissatisfaction with the service from their existing technology provider and a need to cut spending, they required a partner who could reduce costs and deliver the specialist expertise to implement this.

Our solution:

To provide a team of expert consultants capable of delivering a fully functioning data warehouse. Data sources were to be staged in Teradata with IBM Information Services toolset used to Extract, Transform & Load for the new data warehouse.

We delivered a team of 32 locally based data warehouse specialists, including:

  • 1 Technical Delivery Lead,

  • 1 Lead Data Architect,

  • 4 Project/Release Managers,

  • 14 ETL Developers,

  • 8 Data Modellers/Data Analysts

  • and 4 Test Analysts.

A robust data governance framework was put in place. Due to the project’s success, a second phase was established to develop the capabilities of the data warehouse and train staff to maintain and develop it.

The outcome:

  • The internal team were on site within just four weeks of receiving the RFP

  • The initial project was completed in 12 months, within budget

  • Delivered a legacy without dependency by embedding the newly developed processes into the business

  • The client saved 48% compared to the solution with their existing consultancy

  • After successful delivery, Hydrogen was retained to provide a second phase