Customer archive data management method and system based on data owner system

Abstract

The invention relates to the technical field of data management, and discloses a customer archive data management method and system based on a data owner system. The method comprises the following steps: S1, carding a business process to determine a data source; s2, connecting cities and counties to identify data owners; s3, associating external data to construct a data board, introducing government gridding data, constructing a data verification rule based on a Hash verification algorithm, and realizing three-level drill-down display of abnormal data details and government reference; and S4, performing air-drying treatment effect and normal closed-loop management and control, and constructing an air-drying platform, thereby facilitating management and control of data treatment progress of each unit, discovering common problems, and performing targeted treatment. According to the technical scheme, the data owner system is realized according to the principle that who generates the data and who takes charge, so that the data source is clear, the responsibility is clear, and the accuracy and the reliability of the data can be improved; and meanwhile, external data and a hash check algorithm are introduced, so that abnormal data can be effectively identified and processed, and the integrity and consistency of the data are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of data management, and in particular to a customer profile data management method and system based on data master system. Background Art

[0002] In the information age, data has become one of the core assets of enterprises. For public utility companies such as power companies, the accuracy and completeness of customer file data are of vital importance to ensuring service quality, optimizing resource allocation, and improving operational efficiency.

[0003] As an important basic data resource of State Grid Dongying Power Supply Company, the accuracy and completeness of customer files are of vital importance to ensuring power supply, optimizing resource allocation, and improving service efficiency. Customer file anomalies mainly refer to errors, missing or duplications in file information caused by human factors. Customer file anomalies have caused great inconvenience to the business development and customer service of Dongying Power Supply Company, and brought great difficulties to operation and management.

[0004] At present, there are two prominent problems in customer file management: First, the data of new customer names, addresses, unified social credit codes, etc. in the marketing department this year are inaccurate and missing. This business line involves a small number of personnel and a large workload. During the management process, the interface needs to be switched frequently, and there is no effective external reference data, which reduces the accuracy of the file data; second, the names and contact phone numbers of existing customers in Marketing 2.0 do not match the actual ones, and it is impossible to obtain customer contact information in a timely and accurate manner, which seriously affects the collection of electricity bills and power supply repairs. Summary of the invention

[0005] The present invention provides a customer profile data management method and system based on a data owner system, which can timely discover abnormal data in new and existing customer data for modification, and identify the data owner in order to discover problems.

[0006] The present invention provides a customer profile data management method based on data master system, comprising the following steps: S1. Sort out the business process to determine the data source, and coordinate with relevant departments through the Digitalization Department to determine the correspondence between business and data; S2. Connect the city and county levels to identify the data owner, follow the principle of "whoever generates, whoever is responsible", and clarify the basic information such as the data source, purpose, and scope of each field; S3. Associate external data to build a data dashboard, introduce government grid data, build data verification rules based on hash verification algorithms, and realize three-level drill-down display of abnormal data details and governance references; S4. The effectiveness of drying data management, normal closed-loop control, and construction of a drying data platform will facilitate the control of the data management progress of each unit, identify common problems, and carry out targeted management.

[0007] Preferably, step S1 further comprises: S11. Electricity customers are divided into three categories: high voltage, low voltage residential, and low voltage non-residential; S12. Sort out the information entry methods according to categories and determine the online application method; S13. Detailed sorting and determination of business processes according to different business scenarios; S14. Divide the identified business processes into modules; S15. Integrate these modules into 3 main business flows; S16. Sort out the correspondence between business flows and data; S17. Identify authoritative data sources, clarify responsibilities, and ensure the clarity of data sources.

[0008] Preferably, step S2 further includes: S21: Sort out the customer file data of companies at the municipal and county levels, clarify the data source, purpose, and scope of each field, and determine the number of production owners, management owners, and business owners by category; S22: Implement the assignment of positions and responsibilities for field-level data, regularly hold customer file anomaly management promotion meetings based on the data owner system, and identify the data owner as the business department or position personnel directly related to the user name, address, and ID card data fields.

[0009] Preferably, step S4 further comprises: S41: Build a governance and drying platform, based on abnormal data of customer files, combined with government grid data, to verify data items such as user name, address, ID card, etc., to achieve abnormal management of customer file data; S42: Integrate the data ownership system into customer service business scenarios, and through summaries by data owners at all stages and in all professions, form a dual list of customer file management, namely a "problem list" and a "task list", to clarify the direction and key tasks of customer file quality management.

[0010] Preferably, step S3 further includes: establishing a good communication mechanism with the Municipal Bureau of Industry and Information Technology, the Development and Reform Commission and other units, breaking through data barriers and bottlenecks in various links between government departments, unblocking data links, and realizing normal acquisition of grid data.

[0011] Preferably, step S3 further includes a verification rule for existing customer data: Pre-process customer file data and government grid data, remove useless blank characters and format errors, and format data to ensure that all data is in a unified format; Match the customer file data with the ID card data in the government grid data. If the ID card numbers match, proceed to the next step. Select the telephone number and address in the customer file data as key character segments for splicing; Use the SHA-256 hash algorithm to calculate the hash value of the concatenated key character segment; The telephone number and address data in the government grid data are selected as key character segments for splicing; Use the SHA-256 hash algorithm to calculate the hash value of the concatenated key character segment; Match the two calculated hash values. If the hash values ​​do not match, it is considered abnormal data. The telephone and address data in the retrieved government grid data will replace the abnormal data stored in the customer file data.

[0012] Preferably, step S3 further includes verification rules for newly added customer data: Pre-process new customer abnormal data, customer file data and government grid data, remove useless blank characters and format errors, and format data to ensure that all data is in a unified format; Match the newly added customer abnormal data with the ID card data in the government grid data. If the ID card numbers are the same, proceed to the next step. Retrieve telephone and address data from government grid data; Match the customer profile data with the newly added customer abnormal data by account number. If the account numbers are the same, proceed to the next step. The telephone and address data in the retrieved government grid data will replace the abnormal data stored in the customer file data.

[0013] Preferably, step S3 further includes: recording the hash value matching process and matching results of each abnormal existing customer data, retrieving the production owner, management owner, and business owner of each abnormal existing customer data, generating a report, providing a detailed analysis of data matching, and realizing a three-level drill-down display of abnormal data details and governance references.

[0014] A customer profile data management system based on data master system, characterized by comprising: a. Data governance module, used to execute the customer profile data governance method described above; b. Data verification module, used to verify customer file data using external data; c. Data monitoring module, used to monitor the progress and effect of data governance; d. Data feedback module, used to collect and analyze feedback information on data governance.

[0015] A computer device comprises a memory and a processor, wherein the memory stores a computer program, and wherein the processor implements any step of a customer profile data management method based on data master system when executing the computer program.

[0016] It can be seen from the above technical solutions that, 1. Since the embodiment of the present invention adopts the principle of "whoever generates, whoever is responsible" to realize data ownership, it ensures that the source of data is clear and the responsibility is clear, which helps to improve the accuracy and reliability of data.

[0017] Since the embodiments of the present invention can effectively manage and control data input and reduce errors and redundancy by sorting out business processes and determining authoritative data sources, the digitalization department takes the lead and coordinates with relevant departments to promote cross-departmental communication and cooperation, which helps to form unified data governance standards and processes.

[0018] Since the embodiment of the present invention introduces external data and hash verification algorithm, abnormal data can be effectively identified and processed, and the integrity and consistency of data can be improved. The use of hash algorithm can compare and verify data without leaking personal privacy, which helps to improve data security.

[0019] Since the implementation of the present invention constructs a data dashboard and drying platform, the progress and effect of data governance can be displayed intuitively, which is convenient for monitoring and evaluation. Through normal closed-loop management and control and regular promotion meetings, the effect of data governance can be continuously tracked, and problems can be discovered and solved in a timely manner. At the same time, by collecting feedback information and analyzing it, the data governance process can be continuously optimized and the quality of data governance can be improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0021] Figure 1 It is a flow chart of a customer file data management method based on data master system of the present invention; Figure 2 The present invention discloses a customer profile data management method based on data master system and a data verification rule diagram based on hash verification algorithm. DETAILED DESCRIPTION

[0022] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0023] An embodiment of the present invention provides a customer profile data management method based on a data master system, and an embodiment of the present invention also provides a corresponding call processing system, which are described in detail below.

[0024] Embodiment 1 See also Figure 1 , a customer profile data governance method based on data master system, comprising the following steps: S1. Sort out the business process to determine the data source, and determine the correspondence between business and data through the Digital Department, which takes the lead and coordinates with relevant departments; first, sort out the business logic, and sort out the information entry channels such as visits to business halls, online State Grid, iShandong, and public accounts according to the three categories of electricity users: high-voltage, low-voltage residents, and low-voltage non-residents. Determine the business process in detail by scene and module, and sort out 3 business flows and more than 20 modules of customer file logic; second, determine the authoritative data source. The Digital Department takes the lead and coordinates the Marketing Department, Power Supply Center, and Power Supply Station to carry out fault-finding activities. According to the authoritative source determination principle of "identify the scene, see the flow direction, identify the system, clarify the interaction, determine the flow, and trace the source", determine the correspondence between the business and the data, and determine 4 authoritative data tables and 184 fields in total, so that the responsibility is clearly defined and the data source is clear; S2. Connect the city and county levels to identify data owners, follow the principle of "whoever produces, whoever is responsible", and clarify the basic information such as the data source, purpose, and scope of each field; first, establish and improve the data owner system at the city and county levels, sort out the customer file data of companies at the city and county levels, and clarify the basic information such as the data source, purpose, and scope of each field. A total of 642 production owners, 142 business owners, and 66 management owners have been sorted out; second, realize the fixed position and responsibility of field-level data, promote cross-professional and cross-departmental collaboration, and hold customer file abnormality management promotion meetings based on the data owner system on a regular basis. The data owner is identified as the business department or position personnel directly related to the data fields such as user name, address, and ID card, and the "data position" association matching is realized; S3. Associate external data to build a data dashboard, introduce government grid data, build data verification rules based on hash verification algorithm, and realize three-level drill-down display of abnormal data details and governance reference; first, open up external data links, establish a good communication mechanism with the Municipal Bureau of Industry and Information Technology, Development and Reform Commission and other units, break through data barriers and bottlenecks in various links between government departments, smooth data links, and realize the regular acquisition of grid data of 2.2 million residents and 5,000 enterprises in Dongying, with a cumulative data volume of 188G, and realize the regular update in the data middle platform; second, store / increase data According to the management, for the abnormal data of new households registered this year, the field information such as "household number" and "ID number" is used to realize the effective association between customer file data and the abnormal data of new households registered this year, and the government grid data and the abnormal data of new households registered this year, and track the changes in the number of abnormal new households registered this year to provide a reliable reference; for the abnormal data of existing customer files, the field information such as "mobile phone number" and "ID number" is used to realize the effective association between customer file data and government grid data, track the changes in the number of abnormal data of existing customer files, and conduct statistics at the city, county and station levels; S4. Show the effectiveness of governance, normal closed-loop control, and build a drying platform to facilitate the control of the progress of data governance of each unit, discover common problems, and carry out targeted governance; first, build a governance drying platform, based on abnormal data of customer files, combined with government grid data, verify data items such as user name, address, and ID card, realize abnormal governance of customer file data, and realize the three-level drill-down display of county (power supply center)-power supply station-abnormal data details, which is convenient for controlling the progress of data governance of each unit, discover common problems, and carry out targeted governance; second, integrate the closed-loop control mechanism. Integrate the data master system in the customer service business scenario to realize the closed-loop operation of "discovery-acknowledgement-rectification-evaluation", and form a management model with full coverage of data governance links and traceable responsibilities. Through the summary of each link and each professional data master, form a double list of "problem list" and "task list" for customer file governance, and clarify the direction and key tasks of customer file quality governance.

[0025] Embodiment 2 See also Figure 2, step S3 further includes verification rules for existing customer data: pre-processing customer file data and government grid data, removing useless blank characters and format errors, and formatting data to ensure that all data adopts a unified format; matching the ID card data in the customer file data and the government grid data, if the ID card number matches, proceed to the next step; selecting the telephone number and address data in the customer file data as key character segments for splicing; using the SHA-256 hash algorithm to calculate the hash value of the spliced ​​key character segment; selecting the telephone number and address data in the government grid data as key character segments for splicing; using the SHA-256 hash algorithm to calculate the hash value of the spliced ​​key character segment; matching the two calculated hash values, if the hash values ​​do not match, it is considered to be abnormal data; replacing the abnormal data stored in the customer file data with the telephone number and address data in the retrieved government grid data; Step S3 further includes verification rules for newly added customer data: pre-processing the newly added customer abnormal data, customer file data and government grid data, removing useless blank characters and format errors, and formatting the data to ensure that all data uses a unified format; matching the newly added customer abnormal data with the ID card data in the government grid data, if the ID card numbers are the same, proceed to the next step; retrieving the telephone number and address data in the government grid data; matching the customer file data with the newly added customer abnormal data by account number, if the account numbers are the same, proceed to the next step; replacing the abnormal data stored in the customer file data with the retrieved telephone number and address data in the government grid data.

[0026] Embodiment 3 Step S3 further includes: recording the hash value matching process and matching results of each abnormal existing customer data, retrieving the production owner, management owner, and business owner of each abnormal existing customer data, generating a report, providing a detailed analysis of data matching, and realizing a three-level drill-down display of abnormal data details and governance references.

[0027] Embodiment 4 A customer profile data management system based on data master system, including: a data management module for executing the customer profile data management method described above in the present invention; b. Data verification module, used to verify customer file data using external data; c. Data monitoring module, used to monitor the progress and effect of data governance; d. Data feedback module, used to collect and analyze feedback information on data governance; A computer device includes a memory and a processor. The memory stores a computer program. When the processor executes the computer program, it implements any step of a customer profile data management method based on data master system.

[0028] It should be noted that, since the information interaction, execution process, etc. between the units in the above-mentioned devices and systems are based on the same concept as the embodiments of the method of the present invention, the specific contents can be found in the description of the embodiments of the method of the present invention and will not be repeated here.

[0029] A person skilled in the art can understand that all or part of the steps in the various methods of the above embodiments can be completed by instructing related hardware through a program, and the program can be stored in a computer-readable storage medium, which can include: read-only memory, random access memory, disk or CD, etc.

[0030] The above is a detailed introduction to a customer profile data management method and system based on the data master system provided by an embodiment of the present invention. Specific examples are used in this article to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea; at the same time, for general technical personnel in this field, according to the idea of ​​the present invention, there will be changes in the specific implementation method and application scope. In summary, the content of this specification should not be understood as a limitation on the present invention.

Claims

1. A customer profile data management method based on data master system, characterized in that: The following steps are involved: S1. Sort out the business process to determine the data source, and coordinate with relevant departments through the Digitalization Department to determine the correspondence between business and data; S2. Connect the city and county levels to identify data owners, follow the principle of "whoever generates, whoever is responsible", and clarify basic information such as the data source, purpose, and scope of each field; S3. Associate external data to build a data dashboard, introduce government grid data, build data verification rules based on hash verification algorithms, and realize three-level drill-down display of abnormal data details and governance references; S4. The effectiveness of drying data management, normal closed-loop control, and construction of a drying data platform will facilitate the control of the data management progress of each unit, identify common problems, and carry out targeted management.

2. According to the method for managing customer archive data based on data master system in claim 1, it is characterized in that: Step S1 further includes: S11. Electricity customers are divided into three categories: high voltage, low voltage residential, and low voltage non-residential; S12. Sort out the information entry methods according to categories and determine the online application method; S13. Detailed sorting and determination of business processes according to different business scenarios; S14. Divide the identified business processes into modules; S15. Integrate these modules into 3 main business flows; S16. Sort out the correspondence between business flows and data; S17. Identify authoritative data sources, clarify responsibilities, and ensure the clarity of data sources.

3. The method for managing customer profile data based on data master system according to claim 1, characterized in that: Step S2 further includes: S21: Sort out the customer file data of companies at the municipal and county levels, clarify the data source, purpose, and scope of each field, and determine the number of production owners, management owners, and business owners by category; S22: Implement the assignment of positions and responsibilities for field-level data, regularly hold customer file anomaly management promotion meetings based on the data owner system, and identify the data owner as the business department or position personnel directly related to the user name, address, and ID card data fields.

4. The method for managing customer profile data based on data master system according to claim 1, characterized in that: Step S4 further includes: S41: Build a governance and drying platform, based on abnormal data of customer files, combined with government grid data, to verify data items such as user name, address, ID card, etc., to achieve abnormal management of customer file data; S42: Integrate the data ownership system into customer service business scenarios, and through summaries by data owners at all stages and in all professions, form a dual list of "problem list" and "task list" for customer file management, clarifying the direction and key tasks of customer file quality management.

5. The method for managing customer profile data based on data master system according to claim 1, characterized in that: Step S3 further includes: establishing a good communication mechanism with the Municipal Bureau of Industry and Information Technology, the Development and Reform Commission and other units, breaking through data barriers and bottlenecks in various links between government departments, unblocking data links, and realizing the normal acquisition of grid data.

6. The method for managing customer profile data based on data master system according to claim 1, characterized in that: Step S3 further includes verification rules for existing customer data: Pre-process customer file data and government grid data, remove useless blank characters and format errors, and format data to ensure that all data is in a unified format; Match the customer file data with the ID card data in the government grid data. If the ID card numbers match, proceed to the next step. Select the telephone number and address in the customer file data as key character segments for splicing; Use the SHA-256 hash algorithm to calculate the hash value of the concatenated key character segment; The telephone number and address data in the government grid data are selected as key character segments for splicing; Use the SHA-256 hash algorithm to calculate the hash value of the concatenated key character segment; Match the two calculated hash values. If the hash values ​​do not match, it is considered abnormal data. The telephone and address data in the retrieved government grid data will replace the abnormal data stored in the customer file data.

7. The method for managing customer profile data based on data master system according to claim 1, characterized in that: Step S3 further includes verification rules for newly added customer data: Pre-process new customer abnormal data, customer file data and government grid data, remove useless blank characters and format errors, and format data to ensure that all data is in a unified format; Match the newly added customer abnormal data with the ID card data in the government grid data. If the ID card numbers are the same, proceed to the next step; Retrieve telephone and address data from government grid data; Match the customer profile data with the newly added customer abnormal data by account number. If the account numbers are the same, proceed to the next step. The telephone and address data in the retrieved government grid data will replace the abnormal data stored in the customer file data.

8. A customer profile data management method based on data master system according to claim 1 or 6, characterized in that ,Step S3 further includes: recording the hash value matching process and ,matching results of each abnormal existing customer data, retrieving the production owner, management owner, and ,business owner of each abnormal existing customer data, generating a report, providing a detailed ,analysis of data matching, and realizing a three-level drill-down display of abnormal ,data details and governance reference.

9. A customer profile data management system based on data master system, characterized in that: include: a data management module for executing the customer profile data management method according to any one of claims 1-7; b. Data verification module, used to verify customer file data using external data; c. Data monitoring module, used to monitor the progress and effect of data governance; d. Data feedback module, used to collect and analyze feedback information on data governance.

10. A computer device comprising a memory and a processor, wherein a computer program is stored in the memory, wherein: When the processor executes the computer program, it implements the steps of any one of the customer profile data management methods based on data ownership.

Images