Data Warehouse

Building of business information management systems

20% Reducing IT costs
3-5 months to implement quick win business-relevant tasks
MIN Errors minimization in management and operational reporting
  • Building of the brand new sole analytic bank data vault
  • Сonsolidation of several banking data vaults into the one data vault
  • Expanding of functionality, developing an existing data vault

Our approach as a Business Integrator

Functions and Tasks in the project

We are a Business Integrator

  • Minimal efforts by the businessOur business analytics will hold an interview, prepare business requirements and coordinate them with you
  • Reducing efforts of a Bank’s IT serviceYour IT service will be able to get an optimal solution for your Bank together with our system analysts and system architects.
  • Optimal solution for your taskChoose an optimal solution for your Bank together with our experts, specializing in the basic modern platforms and systems
  • We undertake functionality testingOur specialists will test a developed solution in compliance with both functional and business requirements

Solution structure

The central banking data vault is a “Single Source of Truth”

Solution technologies

We cover the whole project cycle of the development of a banking data vault

  • DB/2, Sybase, Oracle, SAS , MS SQL, PostgreSQL, SAP Hana, HP Vertica
  • SAS BI, SAP BO, QlickView, RB Dashboards, Oracle BI, IBM Cognos
  • Data modelIBM BDW, SAS Banking DDS, Oracle OFSAA, Sybase DDS
  • SAS DI + SAS MDS, SAP DS, IBM Datastage, Clover ETL
  • Data Governance & MDMIBM DGFW, IBM Infosphere, SAP BusinessObjects Data Services, Oracle MDM
  • AgileAgile-approach in the project management

Implementation stages

Project Example

  • The single data vault was created in UniCredit Bank on the basis of SAS solution in 2012-2013. A new banking system was offered in 2016.
  • 98 business requirements have been gathered and grouped into the tasks. The full list of all business tasks of the Bank (53 tasks) has been formed.
  • The evaluation of the importance and difficulty of every task realization was carried out, and an implementation plan, split into 3-4 months periods, was created on this basis.
  • Data marts for the first priority tasks have been implemented (Factoring, Analytical CRM) without central data vault usage
  • By the same time a new SAS data structure has been build and implemented
  • The processes of data gathering, cleansing and enrichment have been built. The process of data quality control has been implemented.
  • The implemented data marts have been switched to the central data vault

Our advantages

We are experts in the banking business

32

Business analytics with the real working experience on the key positions in TOP10 banks

Large-scale “turnkey” projects with the further guarantee and support

56

Projects from business ideas to an implementation with the amount of more than 700 person-days

Got questions?

Konstantin Zubov Chief architect