A Centralized Data Warehouse of Clients
"The development of a consolidate customer information information system enabled the front-office staff at Raiffeisenbank to solve the basic tasks of customer identification and identification of customer products online at any branch of Raiffeisenbank", - Enyutin Sergey, chief of the Office of Information Technologies of Raiffeisenbank.
2. Information about the Client
3. The problem
4. Project goals
5. Project tasks
6. Project implementation
7. Результаты проекта
8. Why RDTEX?
9. Why Oracle?
Client: Close corporation "Raiffeisenbank".
Information about the Client
Raiffeisenbank is a subsidiary of Raiffeisen International Bank-Holding AG (Raiffeisen International). Raiffeisenbank is the largest foreign bank in Russia, and ranks seventh 7th in assets assets (1Q 2008 results, Interfax-TSEA). The bank ranks 8th in Russia for the size of it corporate loan portfolio, 4th in volume of private deposits and 6th in the volume of loans to individuals.
Raiffeisen International Bank-Holding AG (Raiffeisen International) manages one of the largest banking networks in Central and Eastern Europe. The bank has a presence in 17 markets in the region with affiliated banks, leasing companies, and other financial institutions. More than 14 million customers are served in more than 3000 branches. Raiffeisen International is a subsidiary of Raiffeisen Centralbank Austria AG (RTSB), which owns 68.5 percent of the shares. The rest of the shares are openly traded on the Vienna Stock Exchange. It is a major corporate and investment bank and the leading bank in Austria.
After completing the legal process of acquisition of Impexbank by Raiffeisenbank Austria, all offices and branches of the combined bank began to work under the name Raiffeisenbank. Because of this a solution was needed to consolidate the client information from the two banks.
Automation of business processes associated with customer service, using the combined client base from Raiffeisenbank Austria and Impexbank.
The system is designed to create a single database of clients of the combined bank and reduce the labor cost in accessing customer information.
- Create a centralized data warehouse of information about customers and their profiles.
- Develop a mechanism for loading and regular updating of information in the data warehouse from the source systems.
- Develop a system of user access restrictions.
- Develop software to allow the bank employees, in accordance with the access privileges granted to them, to search and display the necessary information from the warehouse.
- Develop reports on the downloading of information into the warehouse and regularly keep them up to date.
- Develop a procedure for handling errors, including error classification.
- Develop support procedures for the centralized data warehouse.
- Prepare documentation for the system (user manual, administrative guide), to train key users.
"The Consolidated Client Information Data Warehouse was deployed on a tight schedule using Oracle Database 10g platform, a system for downloads into the data warehouse, as well as a user interface based on Apache Tomcat and user access controls. Preliminary experience with the system confirms the correctness of the solution we have chosen" says Sergey Enyutin, chief of the Office of Information Technologies at Raiffeisenbank.
The work took 3 months. The solution was implemented with the three tier architecture: web browser - Oracle Application Server - Oracle Database Server, based on Oracle 10g Release 2 Enterprise Edition.
In the first phase a survey was conducted to clarify the composition and structure of information in the data warehouse system. Then methods were defined for download and the software development platform was chosen. This was followed by the development of the data warehouse, the program "loader", user interfaces, reports on downloading, user access restrictions, installing software on the customer's server and testing, including testing data downloads using file exchange, functional and load testing.
The consolidated customer information system was designed for 1500 simultaneously connected users and supports role-based access to the functions of the system (search, display forms, reports, etc.) and the possibility of restricting access on the basis of customer attributes (VIP-clients, corporate clients, by clients offices, etc.).
Project results :
As a result of deploying the central data warehouse, staff costs were reduced and customer service was improved.
"We are sincerely proud of the fact that we helped to unify the bank's customer information on schedule, and that the results of our work will contribute to supporting high standards of customer service at Raiffeisenbank," - said the head of RDTEX's Division of Application Optimization Alexander Usachev, manager of the project.
Following the decision to merge the two banks the need emerged for a company to provide services for the development of information systems and technical support and consulting, since the task of unification of information systems includes not only the development of the data warehouse, but also advice on migration Oracle database to the new version and technical support.
"During our work on the design, development and maintenance of the system, RDTEX has proved its good faith and competence," - said Sergei Enyutin, Head of Information Technology at Raiffeisenbank.
Historically, Impeksbank has used Oracle for the development of information systems, while Raiffeisenbank used other software products. When deciding on DBMS technology for a unified data warehouse there are multiple evaluation criteria: reliability, scalability, speed and quality of the development environment, availability and qualifications of developers in the domestic market of Russia, support for solutions after deployment. In addition, work to create a unified data warehouse should be part of the information systems of two banks. As a result, the choice was made in favor of Oracle.