| With the advent of the era of information explosion, the financial industry hasalso ushered in the change, the bank’s various businesses and services are increasinglydependent on IT. A huge number of business data is stored in the computer. A lot ofdata is subject to audit. The current audit is mainly done by hand (Data monitoringsystem has matured，however, the audit system, there is still much room fordevelopment) This obviously does not meet the growing demand audit. Theestablishment of a high quality and high efficiency of information technology auditsystem is imminent.To build the audit information system as the goal, by combing the point ofbanking risks and project management mode, with reference to relevant experience, toput forward a more reasonable the bank audit information system design, andcomplete the entire audit systemthe overall architecture and functional design.This paper starts with the audit model development in particular, the concept ofproject management audit IT. In the analysis of domestic and international auditingpractices under the premise, focuses on the integration of project management theoryand audit, put forward the concept of project management as the core to buildinformation systems. After the study and summary of commonly used method ofproject management and auditing business process. In connection with audit projectimplementation process to plan, organize, direct, control and oversight. Divide auditmanagement process with project approval, audit preparation, audit implementation,and audit end.Followed by papers completes the designs of the core function of bank auditsystem,that is,Project Management System, and Data Analysis and Process.Completed the DAP data analysis and processing functions. Specific data audit, aswell as directly to the needs of the secondary development for the updated auditmodel audit staff use of DAP.Finally, the paper on the basis of the audit business information research, focusingon how to find to be potentially useful audit information and classified so as to makethe results more clearly, disorganized mass of business data. Considering the differentmedia in different business systems, different coding, different database types in thedatabase collected raw data into accurate and effective, and the system can identifythe audit data to get through the "bottleneck". Obtaining the status of the data source,according to the audit system the actual business environment needs, and arenecessary for the conversion analysis, proposed subdivision of the data extraction, transformation and loading, and build a business based data extraction, transformation,and loading (ETL Extraction-Transformation-Loading) model, the completion of theDesign and Implementation of ETL module. Additional，In the process，as it relates to theoperation of the large amount of data, several optimization rules to improve theefficiency of the implementation of the SQL stored procedure. |
