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