Challenge
There was a strong need to verify the information from the reports, clarify the business needs about the reporting systems, and improve the data warehouse architecture to reach a smooth and consistent workflow. The challenge was to develop and integrate a data warehouse, to implement a liquidity risk management system for cooperation with the European Bank for Reconstruction and Development. The final goal was to get a “golden source” and develop the main analytical and reporting dashboards. Technical challenges In a very short period, we had to build a new design for data warehouse architecture, the managerial reporting system. The challenge was to develop ETL processes for extracting, transforming, and loading the data from the 15 source systems to a warehouse.
Solution
We have developed and implemented a process of regular control and analysis of the core banking operations based on Oracle UBS FLEXCUBE in partnership with the International Advisory Services Frankfurt School of Finance & Management. We built a data warehouse with 15 integrated systems, reporting systems for credit and deposit portfolios. We run multiple tests and delivered the project on time. Key features Advanced DWH A comprehensive data warehouse was built and based on the own information model with the data marts for all the operational workflow of the bank. Bank-specific business measures BI deliverables include improved risk review model, better credit scoring, and customer segmentation. Improved business processes They resulted in reduced load on commercial transaction systems and paved the way for optimized integrations. Multi-level reports A new multi-level reporting system is based on Oracle BI, and it provides the opportunity to track each operation and transaction. User-friendly interface Consistent and unified information source for scalable and reliable reporting. An interface provides users with easy-to-navigate elements.
Results
Value to our client 15 integrated source systems. These tools provide extra functionality, including robust reporting dashboards and BI deliverables. New data model for the deep analysis, strategical planning, forecasting. The main data “golden source”.
Want fresh marketing stories in your inbox?
Get the weekly email that makes you a marketing genius.
Stay informed and inspired, for free.