Colvir Data Warehouse

Data Warehouse is an information system designed for accumulation, storage and provision of management, regulatory, financial and statistical information and reporting.

Product advantages

Unified Structure

Creation and support of a controlled and managed structured data storage system. Consolidation of data from different sources in the customer’s landscape. Conversion of data coming from diverse systems to a single storage format.

Intelligent automation

Procedure automation for data collection and loading, data mart generation. BI report creation from DWH data leveraging either the Report Generator provided with the system, or third-party BI tools.

Performance

Reduced loading of the OLTP system. Immediate access to stored information to perform calculations and data analysis, decision making support, report generation.

Reliability and Security

Secure storage and access to data (leveraging the single security subsystem of the Colvir platform).

Colvir CBS modules using Data Warehouse capabilities:

Credit Risks (Provision Calculation)
Regulatory Reporting
Management Accounting
Tax Accounting
Credit Register Interface
Credit Reference Bureau Interface
Offline AML module components

implemented projects

Aloqabank

What has been done

Regulatory Reporting, Credit Risks, Credit Register Interface, Credit Reference Bureau Interface modules have been installed and implemented within the CBS replacement project scope.

What benefits have accrued to the customer

A state-of-the-art and user-friendly information storage system with full automation of data collection and loading procedures.

Outcome

Data Saving
Daily enrichment of DWH data from the OLTP system leveraging Informatica products.
Report Generation
Reports are generated based on the DWH database leveraging customized Colvir client application.
Data Currency
Timely provision of management, regulatory, financial and statistical information and reports.