The Design And Realization Of Bank Custom Relationship Management System

After the end of the protection period of entering into the WTO, foreign Banksbegan to enter the domestic banking industry; it follows the result that is thecompetition between domestic banks and foreign banks. Especially，high-end customerresources, was limited for Banks, will become more shortage. These customer resourcesis the most main source to bank’s profit, and is also the main market target which attractbanks’ most attention.In the present banking, the competition to business share haspushed a secondary, high-quality customer resources,came back from behind, becomethe banks’ compete goal. Each bank is trying its best to attract and retain the high-endcustomers by better service and innovative products. So, the management systemsaccording to bank customers come into being.Based on the Analytical Custom Relationship Management(ACRM) system ofChina construction bank head office, as the background of the specific business of abranch, this article designs the key function realize part of ACRM branch according tobank’s specific needs and actual business processes.First, it introduces the whole system needs.It does needs analysis from such threemain aspects as: management goals and requirements of ACRM system, its functionalneeds of the system and its data needs.Second, it states the most important problem in the realization process of thebranch bank.Mainly includes:(1) the design of technical architecture. Wholly describesthe ACRM system of China construction bank head office, determines the designprinciples. In order to deploy the technical architecture of branch bank rationally, thedesign of branch bank’ technical architecture must be as the basis for the wholeframework of head office.(2) The design of ETL (Extract Transform Load).ETL is thecore module of ACRM system, mainly to realize the continuity of data warehouse andACRM analysis function modules, and it also realizes the data sharing between the headoffice and the branches.(3) The design of characteristic services. Do a multi-dimensiondata analysis to the data of branch itself, make the decision makers can make decisionsaccording to the results of analysis. And to develop new products, to provide new services, launch branch features of their own business. Finally, the realization of entiresystem is described.