Designing And Implementation Of A System For The Open-ended Funds Sales

Nowadays, economic globalization brought the more vast development space for intermediate business of commercial banks. With the development of financial market and bank business innovations, intermediate business has become new growth areas for commercial banks, and open-ended funds sales is a very important member of intermediate business. For orienting to the development of financial market, improve the business service level, one domestic commercial bank of china decided to develop an advanced system of open-ended funds sales.This paper mainly introduced the system for open-ended funds sales in a domestic commercial bank. The author had the honor to participate in the system designing and developing project. This paper focused on elaborating the structure designing, function designing and implementation of the system.By many years of the technological level development, the domestic commercial bank has founded a technological platform which based on z/OS mainframe system, DB2 database and CICS online transaction processing system. z/OS is an operating system which can be set up on IBM z/Series mainframe, it can provide secure, steady and continuing running environments for mainframe. DB2 is a database system which was developed by IBM company, it has good compatibility, usability and robustness. CICS(Custom Information Control System) is an Online Transaction Processing system which was developed by IBM company, it is widely used on mainframe platform.As a part of core business system of the domestic commercial bank, the open-ended funds sales system do not need to finish all the business transaction processing along, there are some other systems of the domestic commercial bank can help. Financial accounting system helps to provide bank teller management, corporate accounts banking; retail banking system helps to provide retail banking function; open-ended funds sales system get and update customer information trough the interface provided by customer information system; card system provides every kind of cards to funds sales system and capital settlement system helps to settle the funds.The open-ended funds sales system is an very important subsystem of the intermediate business system, it can provide various services of funds business for the customers. The system unify the data interface to every open-ended funds company according to the standards of China Securities Regulatory Commission, it also supports many banking ways such as counter banking, telephone banking, online banking and auto telling machine. The system provides customers higher quality open-ended funds sales services, it provides auto investment, fund transfer, fund custodian transfer, dividends way setting etc. The system sends the apply data to funds companies and get confirm data everyday.The whole open-ended funds sales system consists of mainframe and TA preposition part.The mainframe part provides funds business transactions to customer through many ways such as counter, online, telephone and so on, it also provide query transaction such as balance query, net value query and details query, and it can provides funds business statistical statement.The TA preposition part gets application data from mainframe part and sent them to open-ended fund companies according to the format standards of China Securities Regulatory Commission, it also gets confirm data from funds companies and transfer them to mainframe part. The TA proposition part can provide business statistical statement for open-ended sales register center of the domestic commercial bank to query. So, the TA preposition part just likes a bridge between mainframe part and funds companies.The mainframe part is the core unit of the open-ended funds sales system, the author of this paper mainly worked on it, so this paper mainly introduced the mainframe part.The mainframe part consists of online processing subsystem and batch processing subsystem. Online processing subsystem faced to customers directly, it provides many kinds of friendly, intuitionistic interface and real time fund transactions for the customers, it mainly provides the functions below:1. normal fund transaction business, including fund subscription, apply to purchase, redemption, auto investment, fund transfer, fund custodian transfer etc.2. query business, including fund account query, balance query, detail query and printing.3. agent TA account business, including TA account opening and closing, customer information updating.4. 24 hours fund business support.5. particular fund business of the domestic commercial bank, including fund combo, fund foam.Batch processing subsystem non-real-time processes the customer business data from database into binary files after business time is over, it mainly provides the functions below:1. transfer the data files to TA preposition subsystem by FTP.2. get confirmation binary files from TA preposition subsystem, and then handles the money and funds of customers with the data in confirmation files.The open-ended funds sales system of the domestic commercial bank, which is multiple functional, business plentiful, is the best one in same kind of funds sales system in China, also it is internationally advanced one. By putting the open-ended funds sales system into production, the domestic commercial bank improves its fund services effectively, customers praised the bank for it, the system helps the bank to take advantage in domestic market.