“The Renaissance the Capital” has received the analytical data store| 17.09.2009
Thursday, September 17, company Data Integration Software, a regional office of Informatica Russia and CIS countries, announced the completion of several projects related to the creation of the Bank
“Renaissance Capital” (provides services under the brand name “Renaissance Credit”) analytic data warehouse and filling it with information.
As reported by an IT company, with business development (this was in 2007), the Bank was faced with the need for a powerful and effective tool to collect data on the credit operations to assess the performance and
reporting to the business. As a result, management of the Bank decided on the establishment of analytical corporate data store. Wherein the integration component was
selected single, comprehensive platform, the Informatica PowerCenter.
Data Integration Software has started implementation of this project in 2007. In the first phase of the project, the contractor engaged in the creation of the processes unloading the data from the two banking systems in the corporate
datastore. Thus was developed the functionality to integrate data with an intermediate quality control in operational, and then the historical data store.
After that, the company developed data Mart for reporting to top management of the Bank. Here Integration Software established six relational data marts, each designed
for the formation of data warehouse reporting in various areas:
Financial information on credit operations;
Information about overdue debts on loans;
Data on applications for a loan;
Information about Bank’s clients;
The data on repayment of loans;
Data on sales of loan products.
According to IT company, currently in the corporate store are downloaded every day to the Bank in the amount of about 20-25 GB. Based on consolidated data warehouse implemented
the possibility of formation of needed business reports in the context of clients, credit operations, payments, outstanding loans, etc.