Design And Implementation Of Bank Audit Information System Of Commercial Bank

Now, with the advent of the era of information explosion, the world bank in a variety of business and service more and more dependent on IT.The financial industry also ushered in the change, a lot of all e-commerce data.In our country, a lot of artificial banking audit data, data monitoring system has been mature but audit system also has the very big development space, many of which data needs to be regulatory scrutiny, now review system obviously can’t meet the increasing demand.First of all, the thesis study of relevant audit development model at home and abroad under the premise of the audit method is analyzed, the concept of project management audit, and IT has been studied.To subdivide the audit project management into project audit, audit preparation, project implementation.In the process of project management. And in the process of project management and audit business commonly used methods are studied and summarized, the audit project implementation process in the organization, guidance, planning, supervision and control.Second, the main research how to go from a lot of, in the audit information potential of a large number of useful business data desultorily, found that classifying data, make the results more clearly. Comprehensive consideration in different medium, different coding and collecting original data in the database of database types of different business system, and convert them. Based on the data source, under the condition of obtaining and transforming the requirements of the actual business environment needed for auditing system are analyzed and the data Extraction, Transformation and Loading mode of segmentation is put forward, complete the ETL module design and implementation. In the process of data transformation, because involves a large amount of data in the operation, through the optimization rules to enhance the execution efficiency of SQL stored procedure.Finally, the thesis completed the core functions of bank audit system, including audit Analysis tool (DAP, Data Analysis and Process) and the design and implementation of the audit project management system. DAP through data analysis and processing functions, the realization of the audit specific data. According to the latest audit model, meet the auditor directly using the DAP secondary development needs.Main work of this paper is based on the research of project management mode, combined with work experience, has established a set of control bank auditing information system audit risk. At the same time, puts forward the reasonable bank auditing information system design and development plan, function design and implementation.