Projects Our Projects

IBM BDW and Cognos BI at the State Savings Bank of Ukraine

At the biggest state-owned retail bank in Ukraine were implemented IBM Banking DataWarehouse and Management Information System on Cognos BI using IBM Infosphere tools. Key project drivers were regulatory compliance to World Bank reporting in the credit risk area and to requirements of the National Bank of Ukraine for implementation of International Financial Reporting Standards (IAS 39, IFRS 9, IFRS 8).
 
Apart IBM BDW and Cognos BI the following analytical applications were developed: fund transfer pricing (FTP) and yield curves module, financial balance sheet and income statement module, management balance and income statements based on FTP, customer segmentation and customer analysis module, provision calculation according to IAS 39 module, competitors bank analysis. In addition, Data Warehouse control and lifecycle management system was developed. MIS reporting based on IBM BDW has comprised:
 
Management Board reports
  • 3 Dashboards: Competitors Analysis, Retail Business and Corporate Business
  • 10 top management reports
Business Reporting
  • Sales volumes by branches
  • Client information
Accounting and Management Accounting
  • Financial Balance Sheet and Income Statement
  • Management Balance Sheet and Income Statement
  • Corporate Client profitability
  • Branch profitability
  • Operational Segments profitability
  • Fees and commission analysis
  • Interest income analysis
  • Administrative expenses analysis
Risk Management Reports
  • Credit portfolio analysis
  • Deposit portfolio analysis
  • Projected Liquidity
  • Interest rate GAP
  • Spread analysis and yield curves
  • NBU regulatory reports
  • Internal audit reports
Operations
  • Cash limits control in outlets & ATM
  • Customer search by name, passport and other ID data
The first project release was implemented within 12 months with the total budget to the tune of USD 6 million. The main economic benefit from IBM BDW implementation was:
  • Target interest margin protection due to FTP model implementation
  • General Ledger centralisation (from 26 core banking systems)
  • Credit and deposit portfolios centralisation
  • Assets & Liabilities as well as liquidity risk centralisation
  • Bank dictionaries synchronisation
  • Reduction of time and manual work for reports generation (from several days up to 1-45 seconds per report)
  • Data Governance and Data Quality improvement
Current DWH&MIS metrics are presented below:
DWH Size
  • Size of SOR & DM: 12 ТВ
  • Number of DWH tables: 1400+ (SOR&DM 240+)
  • Rows number in tables: 117+ billion
DWH entities
  • Number of clients, accounts, arrangements, million: 25+, 60+, 35+
  • Number of transactions per month, million: 55+
  • Number of tables which growths 20+ million per day: 7
Data Marts
  • Number of Summary + Profiles: 47 entities + 5 SCD + 10 DIM
  • Number of Analysis areas: 10+ star schemas
  • Number of Feedback area: 4 star schemas
  • Data Marts size: 6 TB
  • Data population period: daily, monthly, quarterly, yearly
Time
  • Data download to SOR: 3 hours
  • Time of Dimensions calculation: 2 hours
  • Total time for Data Marts calculation: 3 hours
ETL metrics
  • Source systems: 30+
  • ETL processes: 600+
  • ETL processes run per day: 8000+ 
  • ETL data volume data per day (8 hours): 2 TB+
  • Metadata repositorу: 35000+
  • IBM Information Server 9.1.2, IBM POWER 770 (20 Core) Memory 128GB
BI reports
  • Number of reports in Report Studio: 70
  • Number of reports in Query Studio (Cognos Packages): 14
  • Time for report generation (max, min): 3 - 40 seconds
  • Number of Cognos BI users: 260
Backup
  • Full backup and incremental backup size: 3,8 TB and 300 GB
  • Full backup and incremental backup time: 3,8 hours and 2 hours