Case studyDWH EFFICIENCY EXCELLENCE

Our client, a large Russian bank, was losing annually large sums due to inefficient DWH set up. The impact was on all departments of the bank: risk, fraud, finance… The focus of the project was on reviewing the IT architecture and the business needs, elaborating a new architecture, creating a roadmap for the implementation of it and initiating the implementation.

 

Issues Identified:

  • Inefficient IT set up.
  • General perception „IT does not work well“
  • No focus on improvements

 

ABC Actions

 

1

Target Architecture

We prepared the target functional architecture based on business requirements and prepared the roadmap for gradual development of each individual component.

2

Business Process Review

Our team prepared detailed specification for business requirements and assessed the current data availability and quality.

3

New Organization

As Organizational structure identified as major wakens, ABC team revised new structure of responsibilities and processes for the new Business Intelligence Competence Centre taking into consideration client requirements for future development.

4

Business Case

In order to improve management ability to decide as well as to justify the expanses we prepared business case calculation methodology as well as calculated the business case for the new DWH structure

Results

 

  • IT efficiency measurement set up
  • Faster DWH time to market and improvement of development quality
  • As a consequence of the previous points, increased data quality which led to better client scoring, optimized provisioning, decreased interest rate and liquidity risks hedging costs