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 Analystsand 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 RFPThe initial project was completed in 12 months, within budgetDelivered a legacy without dependency by embedding the newly developed processes into the businessThe client saved 48% compared to the solution with their existing consultancyAfter successful delivery, Hydrogen was retained to provide a second phase