The Application Of Automated Test In Bank Receipt Transfer

With the development of the computer technology, the commercial banking is eager to establish a new centralized business to process the customer and account information cross various regions in worldwide and enhance their competitiveness in the industry in the meantime. During the implementation of the new core banking system, the major problem is how to ensure the data conversion is accurate and the result can be verified in a very short period after new system switched on. This can lead the whole conversion process into a success or failure result.CDF-Comma Delimiter File:<(translated) with a Comma as the delimiter data processing data f ile> is to use the automated test scripts to generate the general ledger data conversion reports, non-financial reports and MIS reports. These reports can help customers to complete data conversion results validate in a short time in an effective way. It’s not only reduces the system operator effort and significantly reduces or avoid human error during testing, and it is also a good tool help developers find our data transplantation error during conversion.CDF can be used in conversion validation throughout the core banking system. The goal of the system is to fulfill below two major functions:1. To implement the data extraction function which extract the before and after conversion data from new and old core banking system separately. CDF system can base on business needs together with data conversion rules, to extract the key banking financial and customer information. This provide a good foundation for the data validation, and give the convenience to generate the various data analysis reports according to the business requirements, and it helps on the operational readiness of new system cutover.2. To achieve the data cooperation function between the old and new system. The CDF provides field-level system database comparison according to the import data, and provide a straightforward data comparison reporting which allows user to access the data conversion result rapidly and correctly. Four CDF major functions are able to help users to do data conversion result testing and validation, which includes Data import module, Accounting report module, Non-financial report module and MIS report module. CDF applied for three layer system architects which are User Interface, Business logic layer, and Data access layer. CDF fulfill the data extract via the IBM Mainframe by using the batch files developed by the COBOL script. All the data a extract via the VSAM and QSAM module and visit DB. When CDF generate the import file, it has sorted out the data before and after conversion data via the system conversion logical which make sure the data has been remapped with the same format before import to CDF DB. The system efficiency is improved a lot by doing this. The Application install in the Client is designed via VB script, plus the ADO technology which make the system can visit the CDF DB faster and better.