Six Sigma Methodology's Application And Research On Commercial Bank's Data Warehouse System Management

The data warehouse system of China Construction Bank has been built in 2006.It is currently in a new phase to full-line service to customer. With the growing business requirements, the data warehouse system's management is facing great pressure.Therefore, the voice of the system's users and managers to build the data warehouse's management framework is urgently. This is necessary for them to ensure timely delivering the data warehouse's new application to customer. This is also essential for them to satisfy the user growing information requirements by improving the data quality. This is indispensable for them fully to support the business's development by maintaining a stable architecture of the data warehouse, effectively controlling the risk of occurring in developing the data warehouse system, ensuring the system safely, efficiently and stably operating.The Six Sigma management is a process innovation approach to improve customer satisfaction while reducing operating costs and cycle. It is not only a management pattern that can enhance the corporate profitability by improving the core process's operating quality, but also is a business strategy which can raise its competitiveness and sustainable development capacity in the new economic environment. Recently, more and more corporations use Six Sigma management. Especially Six Sigma management also extends to the areas of IT management.This thesis explores how to building a data warehouse management system of China Construction Bank with the Design for Six Sigma, focusing on the management process of the data warehouse system.Firstly, base on Design for Six Sigma (DFSS) methodology, it introduced the theory of DFSS, and the process of DFSS, and the tools commonly used in DFSS.Then, according to the basic theory of DFSS, we carried out the design of the data warehouse management processes in each of the five phases of DFSS (Define, Measure, Analyze, Improve and Control). In the definition phase, a customer survey used to gather the Voice of Customer (VOC). Then the Critical to Quality (CTQ) defined. Then the CTQs were associated with the VOC. In the measurement phase, the functions of the Data Warehouse Management System were determined. Then the CTQ requirements would allocated to each function as a design goal of the data warehouse management processes. In the Analysis phase, the high-level design and detailed-design of the process carried out. In addition, the ability of design would evaluate. In the improvement phase, testing and pilot production carried out by measuring the ability of the process if it meets the design requirements. In the control phase, the design would deploy. Moreover, the control plan developed to monitor the processes. The whole process of DFSS, two important tools for Six Sigma, Quality Function Deployment(QFD) and Failure Mode and Effects Analysis, were the main line and CTQ would be tracked and broken down from the begin to the end.Finally, we summarized the whole design process and determined the follow-up action plan which improving the process of data warehouse management system with the improvement method for Six Sigma.