| Loan business management system is the core system of every financial institution, improve service, risk prevention, regulate and promote business development plays a key role. I am the Provincial Association of information technology because of starting late, slow development, has greatly restricted the development of the business. Therefore, the guiding ideology of the Provincial Association put forward "for the agricultural letter society force to provide security" for information technology construction, have launched the design and development, the two generation of core system loan business management system project.I am the Provincial Association since 2005, the successful launch of a new core system(CCIS), counter business gradually from the manual, business data concentrated to the center of the province, but the loan business the still mainly manual based, low efficiency, service level is not high, the risk can not effectively control. In order to better meet the needs of future long-term development and market competition, comprehensively enhance the overall service level, strengthen risk management capabilities, to meet the needs of the development of future business, competition and management, combine me the province is actual business development, research and development for the loan business management system in our province is a pressing matter of the moment business development needs of the work at present.This paper mainly in the aspect of data warehouse, real-time query, data platform, enterprise data model are studied. Through the ETL, data warehouse technology, build a business data of the T+1 platform, and enterprise data model specification system data exchange.The system includes system management, debt service management, loan management, query management components, to achieve the CCIS, loan management system, risk monitoring system data interaction. Through the application of control, business process and data model of risk, loan and collection of related data, provides the advanced technology platform and tools as a union of loan management. The system uses Power Builder 9 as the development environment, program development based on C/S structure, database using the current mainstream database ORACLE.The system has been carried out in Zunyi County Rural Credit Cooperatives, effectively improve the credit management personnel’s working efficiency, shortening the processing time of loan approval, loans, the repayment of the principal and settlement, reduced credit management personnel’s work burden. With the further promotion and operation system, the function of the system is improved and consummated constantly. |
