Customers: Life Financial group Moscow; Financial services, investments and audit Contractors: RDTECH Product: Oracle Data Integrator Enterprise Edition 11gНа базе: Oracle Data Integration Project date: 2012/08
|
Short technical characteristics of DWH — the data warehouse on Oracle, the calculation engine on OFSAA PFT, the reporting on Oracle Business Intelligent. The reporting on profits and losses is formed on each making group unit: on banks, divisions, departments and managers. All banks of group are integrated into KHD, at the same time six of seven banks load detailed primary information: clients, transactions, accounts, postings, issue documents and so forth. A system provides function of comparison of the management reporting to the reporting under RAS. There was an opportunity to automatically control quality of the reporting.
The storage is based on a hardware platform of IBM, using Oracle RDBMS Enterprise Edition DBMS. Data loading is performed by means of Oracle Data Integrator; measure calculation of the reporting (allocations of costs, calculation of subscription fees of indirect services, setup of adjustments, maintaining reference books of the CFD and articles of UU, etc.) is Oracle Financial Services Analytical Applications Profitability Management.