ZAO Raiffeisenbank, SAS Russia/CIS and OOO Irbicon have successfully completed a global joint project to optimise a massive, 30 terabyte corporate bank database. The database will ensure timely generation of mandatory, executive and analytical reporting for the Head Office and 14 branches, as well as technological support for a wide range of the bank’s business lines.
The key driver for launching the project to optimise the database was the rapid growth of Raiffeisenbank’s business in recent years and expansion of the bank’s product range. With the rapid growth, the corporate database used for the last seven years could no longer meet the needs of the larger scale business. Moreover, the system for protecting data from unauthorised access had become much more sophisticated. Thus, the optimal solution was to build a database on a new process platform rather than to carry out another facelift improvement.
Following optimisation, information regarding all reports and upload processes was fully centralised and upload time was reduced by 60%. The upgraded system allows the bank to flexibly manage data flows through graphic interfaces, as well as to linearly expand productivity by connecting additional hardware capacity without productivity losses.
The project was jointly implemented by Raiffeisenbank, SAS Russia/CIS and its silver partner OOO Irbicon.
Currently, the SAS repository carries out critical business tasks covering many spheres of the bank’s activities: reporting for the headquarter company, IFRS reporting, and executive reporting. Moreover, information stored in the database is the basis for calculating and analysing risk broken down by business lines, analysing product sales figures, and conducting various scoring functions (Application, Behavioural, Collection), among other things.
«The capacity of the upgraded SAS database is sufficient to ensure technological support for several years in the future. We successfully achieved our key objective of ensuring timely availability of reports for all database users. We are satisfied with the cooperation with our partners in the scope of this project and intend to continue implementing the approved development strategy for the corporate database» says Sergei Enutin, head of Raiffeisenbank’s IT department.
«The SAS 9.2 platform is not limited to more rapid upload processes. Very significantly, it is more adaptable and reliable in everyday use. Thus, on this platform the bank can build solutions of much greater scale than previously possible» points out Sergei Lobov, Sales Director of SAS Russia/CIS.
«Raiffeisenbank’s responsible approach to the project was very important to us» explains Pavel Britov, Business Development Director for Irbicon. «This ensured that we were able to complete the database optimisation project without interrupting development, and users were virtually unaware of the ongoing process».
The bank achieved success through repository migration to a scalable SAS 9.2 platform on an IBM p-Series server powered by AIX OS.
The SAS repository architecture optimisation project was implemented intwo stages of six months each. The first stage comprised migration of data and ETL-processes to SAS 9.2, and the definition of regulations and standards for the development and support of the database with the use of tools new to bank employees. The SAS Data Integration Server was implemented as a tool to develop and execute ETL-processes; the SAS Metadata Server was utilised as a centralised tool to operate all meta-data of the SAS database. The second stage comprised gradual implementation of new regulations and standards in commercial operations, employee training, data quality verification and (as necessary) refinement of upload processes.
ZAO Raiffeisenbank is a subsidiary of Raiffeisen Bank International AG. Raiffeisenbank ranks 9th among the Russian banks in terms of assets, based on 2010 results (Interfax-CEA). According to the same Interfax-CEA data, ZAO Raiffeisenbank ranked 6th in terms of private deposits and 8th with regard to consumer lending.
Raiffeisen Bank International AG regards both Austria, where it is a leading corporate and investment bank, and Central and Eastern Europe (CEE) as its home market. In CEE, RBI operates an extensive network of subsidiary banks, leasing companies and a range of other specialised financial service providers in 17 markets. More than 59,000 employees service about 15 million customers through around 3,000 business outlets, the great majority of which are located in CEE. RBI is the only Austrian bank with a presence in both the world’s financial centres and in Asia, the group’s further geographical area of focus. Raiffeisen Bank International is a fully-consolidated subsidiary of Raiffeisen Zentralbank Oesterreich AG (RZB). RZB indirectly owns around 78.5 per cent of the common stock, which is listed on the Vienna Stock Exchange; the remainder is in free float. RZB is the central institution of the Austrian Raiffeisen Banking Group, the country’s largest banking group, and serves as the group head office of the entire RZB Group, including RBI.