Design And Development Of Sme Customer Service Management System

Today’s small and medium enterprises in order to meet the social needs of its business operations and market business development, customer base must meet their needs and provide services to its more appropriate, the development of enterprises, the company’s performance can be guaranteed.The main contents of this topic is a service commissioner, sales staff and management to use according to SME customers by understanding business needs and actual proof industry, collecting customer information and the corresponding aggregated data warehouse technology to design and develop a set of has a customer information management, data analysis SME customer service management system. With this system provides the customer information management, basic information such as customer acquisition, the problem of record demand information and product subscription information management; analysis also provides three types of data, such as customer characteristics, problem analysis and advice for decision-making and leadership sales provide a reference staff. The system was developed using MVC technology infrastructure, traffic flow and data storage is completely isolated, not only to enhance the efficiency of project development, and improve the software’s ease of use. In the data the application level, the system through SQL Server 2005 database based on a more comprehensive and complete information on the basis of the application, the data warehouse is used to support the leadership of decision analysis. Data warehouse to store various types of customer data for analysis, sampling categorize, analysis model, data processing, and ultimately meet customer application needs. Data and Information Management based on the data block, the system is fully optimized to improve the management and control of data information. Not support the use of on-line analytical processing data warehouse multidimensional data analysis, but also can select a subset of the data warehouse, so as to achieve customer analysis requirements of different applications. Through in-depth analysis of the data warehouse to provide the appropriate analysis for data users and decision-makers support.The thesis technical architecture selection, business needs analysis, system functions and data structure design to system implementation and to demonstrate the actual test session. The system uses an advanced design concepts and some mainstream technology. MVC J2 EE technology-based systems and Web technologies to achieve. Establish the actual business application model to meet customer workflow design is completed applications to meet customer demand, wherein the system using data warehouse technology to help analyze, collect and record data, which will organically integrated systems and services, providing customers with multi-level, personalized, diversified services.