A SIM card bill intelligent management and control method and system based on power business

Abstract

The present invention discloses a SIM card bill intelligent management and control method based on power business, including the following steps: S1, according to the power user's identity authentication protocol, the initial bill information of the SIM card bound to the power user's identity information is obtained from the network interface of the telecommunications operator, and the bill information is imported into the business bill database; S2, the bill standard format generation module obtains the bill information from the business bill database to obtain the standard bill information in a unified format; S3, the bill verification module removes the abnormal information of the standard bill to obtain the SIM card valid information list; S4, the SIM card valid information list is displayed through the bill display module. By unifying the data format and eliminating abnormal information in the import, calculation and export links of the bill data, the verification efficiency of the SIM card bill is greatly improved, and the user satisfaction is further improved.

Description

Technical Field

[0001] The present invention relates to the technical field of power marketing, and in particular to a method and system for intelligent management and control of SIM card bills based on power services. Background Art

[0002] The terminals of power business are equipped with SIM cards, which are used to identify and authenticate the terminals of power business. At the same time, they can communicate with the remote management center to understand the usage information of the terminals of power business. The construction and application of strong smart grid and ubiquitous power Internet of Things are closely related to the management and control of SIM cards; remote meter reading, power quality monitoring, big data mining and utilization, measurement anomaly analysis, remote power outage and restoration, and power demand forecasting are all realized by the information exchange function of SIM cards.

[0003] The SIM cards currently in use are all provided by the three major operators (China Mobile, China Unicom and China Telecom), and various lists and bills are also provided by the operators. SIM card bills cannot be directly obtained within the company system; the power department lacks fast and effective verification methods, and the three major operators are not subordinate to each other and operate independently. The bills they provide are varied, resulting in difficulties for financial personnel in entering, comparing and screening various lists and bills.

[0004] At present, the power system faces the following difficulties in checking and counting SIM card bills for power services:

[0005] (1) It takes a long time for operators to change the status of SIM cards: To change the status of a SIM card, you must apply to the operator in advance, and then the operator will review and approve the change. The entire process takes a long time, and the accuracy of the list provided cannot be guaranteed.

[0006] (2) Slow feedback on abnormal SIM card inquiries: After receiving the abnormal SIM card information inquiry application from the power department, the operator still needs to go through internal approval before feedback can be given, resulting in a long time to obtain the abnormal SIM card list;

[0007] (3) Bill verification takes a long time: There are three steps to complete bill verification. The first step is to verify the bills of various SIM cards. The second step is to verify whether there are any SIM cards that should be cancelled but have not been cancelled. The third step is to verify whether there are any SIM cards with zero traffic for consecutive months. The last step is to provide the operator with a list of duplicate billing cards, eligible zero-traffic cards, and cards that should be cancelled. It is precisely because of the large number of bills and the long feedback time that SIM card bill verification is difficult and takes a long time.

[0008] The current marketing system only has the asset management function for SIM cards. Important information such as SIM card activation time, card cancellation time, package category, and tariff details cannot be directly imported into the marketing system. The marketing system cannot use computer algorithms to screen SIM card big data, let alone query and export abnormal SIM card information. Summary of the invention

[0009] The purpose of the present invention is to solve the problem of low efficiency in checking SIM card bills for power business, and proposes a SIM card bill intelligent management and control method system based on power business. By unifying the data format and eliminating abnormal information in the import, calculation and export links of bill data, the verification efficiency of SIM card bills is greatly improved, and user satisfaction is further improved.

[0010] In order to achieve the above technical objectives, the present invention provides a technical solution, which is a method for intelligent management and control of SIM card bills based on power services, comprising the following steps:

[0011] S1. According to the power user's identity authentication protocol, the initial bill information of the SIM card bound to the power user's identity information is obtained from the telecommunications operator's network information interface, and the bill information is imported into the service bill database;

[0012] S2. The bill standard format generation module obtains bill information from the business bill database to obtain standard bill information in a unified format;

[0013] S3, the bill checking module removes abnormal information from the standard bill to obtain a list of valid SIM card information;

[0014] S4. Display the SIM card valid information list through the bill display module.

[0015] In this solution, the efficiency of SIM card bill verification is greatly improved by unifying the data format and eliminating abnormal information in the import, calculation and export of bill data.

[0016] Preferably, the source of the initial bill information includes telecom SIM card bills, mobile SIM card bills and Unicom SIM card bills in different billing formats; since the initial formats of telecom SIM card bills, mobile SIM card bills and Unicom SIM card bills are not unified, the SIM card bill intelligent management and control system needs to unify the initial format of the SIM card bills after obtaining the above information to facilitate the reading of bill data.

[0017] Preferably, the format of standard billing information includes data information such as: operator name, card number, package fee, actual fee, application type, card activation time, standard traffic, actual traffic, card status information, and the unified traffic unit is MB; the status type is defined as "0" for disabled, "1" for in use, and "2" for new card inventory; the application type is defined as "1" for low-voltage acquisition, "2" for high-voltage special transformer, "3" for public transformer assessment, "4" for online monitoring, "5" for PDA, "6" for fault reporting, and "7" for video surveillance.

[0018] Preferably, the bill checking module removes abnormal information from the standard bill including the following steps:

[0019] SIM card information of duplicate billing cards is eliminated through the duplicate checking mechanism; in order to prevent duplicate billing SIM card information from being repeatedly imported into the SIM card bill intelligent management and control system, the bill is automatically checked for duplicates during the import operation (specifically, the unique card number information of the SIM card is checked for duplicates to ensure that the information of each card is only read once). If duplicate SIM card information appears, the specific duplicate card information can be prompted and the duplicate card can be eliminated;

[0020] By comparing the SIM card monthly bills month by month, we obtained the actual card cancellation list;

[0021] Compare the actual card cancellation list with the card cancellation application information to obtain a list of cards that should be cancelled but have not been cancelled;

[0022] Export the list of SIM cards with zero traffic for multiple months. Based on the actual monthly traffic data of each SIM card, select the list of SIM cards with zero actual traffic for six consecutive months or more;

[0023] The whitelist module is used to identify the non-abnormal information in the monthly zero-flow card list information; the identified non-abnormal card information is re-imported into the SIM card valid information list as normal card information;

[0024] Send the list of cards that should be cancelled but have not been cancelled and the list of cards with zero traffic for multiple months after screening to the telecom operator for SIM card cancellation.

[0025] As a preference, the whitelist module is used to identify non-abnormal information in the monthly zero-flow card list information, and the non-abnormal information includes the following situations:

[0026] Scenario 1: The mobile operation terminal with unactivated card;

[0027] Scenario 2: Faulty inspection equipment causes a decrease in the success rate of SIM card information collection;

[0028] Scenario 3: The terminal equipment of a dual-power customer happens to switch to another power metering device in the same month;

[0029] Scenario 4: A suspended customer in the marketing operation status who happens to resume electricity use in the month when the card is suspended;

[0030] In order to avoid erroneous operations when SIM is removed, situations one to four are added to the whitelist module as a screening mechanism to identify non-abnormal information in the monthly zero-flow card list information.

[0031] In this solution, before submitting the exported multi-month zero-flow card list to the operator for shutdown processing, some non-abnormal situations in the multi-month zero-flow card list were not taken into consideration, which led to customer complaints and reduced customer satisfaction. According to customer telephone complaint feedback, non-abnormal situations were used as the basis for auxiliary identification, and non-abnormal situations were divided into four situations: Scenario 1: The collection success rate decreased due to the deactivation of the SIM card; After investigation and analysis, it was found that most of the alarming SIM cards came from mobile operating terminals that were not activated by the card holder; Scenario 2: The failure of the fault inspection equipment caused the success rate of SIM card information collection to decrease; Scenario 3: The terminal equipment of dual-power customers happened to switch to another power metering device in the current month; Scenario 4: A suspended customer from the marketing operation status, who happened to resume electricity use in the month when the card was suspended; In order to prevent the recurrence of misoperation, a whitelist module is added to the SIM card bill intelligent management and control system to assist the bill verification module in identifying non-abnormal information in the monthly zero-flow card list information.

[0032] A SIM card bill intelligent management and control system based on power business, comprising: a PC and a network interface connected to the business layer of a telecom operator, wherein the PC imports the SIM consumption data bill of the power user into the business bill database through the network interface, and the PC is also provided with a bill standard format generation module, a bill verification module and a bill display module; the bill standard format generation module is used to standardize the bill information obtained from different telecom operators into a unified format; the bill verification module is used to eliminate abnormal information in the SIM card account information, generate a list of cards that should be cancelled but have not been cancelled and a list of zero-flow cards for multiple months after screening, and send them to the telecom operator for SIM card cancellation operation;

[0033] The bill display module is used to display the SIM card valid information list information.

[0034] Preferably, a whitelist module is also included for coordinating with the bill checking module, and the whitelist module is used to identify non-abnormal information in the multi-month zero-flow card list generated by the bill checking module.

[0035] Preferably, the whitelist module sets the following situations for identifying non-abnormal information in the multi-month zero-flow card list:

[0036] Scenario 1: The mobile operation terminal with unactivated card;

[0037] Scenario 2: Production failure inspection equipment;

[0038] Scenario 3: The terminal equipment of a dual-power customer happens to switch to another power metering device in the same month;

[0039] Scenario 4: A suspended customer in marketing operation status, who happens to resume electricity use in the month when the card is suspended.

[0040] Beneficial effects of the present invention: The present invention designs a method and system for intelligent management and control of SIM card bills based on power services, which unifies the whole process management and control of SIM cards, ensures the consistency between SIM card bills and physical objects, strengthens the management and control of SIM cards by asset management personnel and financial personnel, greatly reduces the phenomenon of hoarding SIM cards in power supply stations, optimizes inventory configuration, and reduces the burden on managers in various links. It realizes data sharing and promotes business integration, provides comprehensive support for various links of SIM card management, realizes the connection of production, marketing and other link processes and data, effectively achieves accurate analysis of abnormal situations, innovates a new model of power marketing management, and makes positive contributions to objectively measuring the business development performance of enterprises and improving the level of lean management, becoming a new engine for power supply enterprises to improve quality and efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Figure 1 The present invention is a flow chart of a method for intelligently managing and controlling SIM card bills based on electric power services. DETAILED DESCRIPTION

[0042] In order to make the objectives, technical solutions and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific implementation method described herein is only an optimal embodiment of the present invention, which is only used to explain the present invention and does not limit the scope of protection of the present invention. All other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.

[0043] Example: Figure 1 As shown, a flow chart of a SIM card bill intelligent management and control method based on power business includes the following steps:

[0044] S1. According to the power user's identity authentication protocol, the initial bill information of the SIM card bound to the power user's identity information is obtained from the telecommunications operator's network information interface, and the bill information is imported into the service bill database;

[0045] S2. The bill standard format generation module obtains bill information from the business bill database to obtain standard bill information in a unified format;

[0046] S2. The bill checking module removes abnormal information from the standard bill to obtain a list of valid SIM card information;

[0047] S4. Display the SIM card valid information list through the bill display module.

[0048] The sources of the initial bill information include China Telecom SIM card bills, China Mobile SIM card bills and China Unicom SIM card bills in different bill formats.

[0049] As shown in Table 1, the format of standard bill information includes data information such as: operator name, card number, package fee, actual fee, application type, card activation time, standard flow, actual flow, card status information, and the unified flow unit is MB; in the definition status type, "0" is deactivated, "1" is in use, and "2" is new card inventory; in the application type, "1" is low-voltage acquisition, "2" is high-voltage special transformer, "3" is public transformer assessment, "4" is online monitoring, "5" is PDA, "6" is fault repair, and "7" is video surveillance;

[0050] Table 1. Standard billing information

[0051]

[0052] The bill checking module removes abnormal information from standard bills, including the following steps:

[0053] Eliminate SIM card information of duplicate billing cards through duplicate checking mechanism;

[0054] By comparing the SIM card monthly bills month by month, we obtained the actual card cancellation list;

[0055] Compare the actual card cancellation list with the card cancellation application information to obtain a list of cards that should be cancelled but have not been cancelled;

[0056] Export the list of SIM cards with zero traffic for multiple months. Based on the actual monthly traffic data of each SIM card, select the list of SIM cards with zero actual traffic for six consecutive months or more;

[0057] The whitelist module is used to identify the non-abnormal information in the monthly zero-flow card list information; the identified non-abnormal card information is re-imported into the SIM card valid information list as normal card information;

[0058] Send the list of cards that should be cancelled but have not been cancelled and the list of cards with zero traffic for multiple months after screening to the telecom operator for SIM card cancellation.

[0059] The whitelist module is used to identify non-abnormal information in the monthly zero-flow card list information. Non-abnormal information includes the following situations:

[0060] Scenario 1: The mobile operation terminal with unactivated card;

[0061] Scenario 2: Production failure inspection equipment;

[0062] Scenario 3: The terminal equipment of a dual-power customer happens to switch to another power metering device in the same month;

[0063] Scenario 4: A suspended customer in marketing operation status, who happens to resume electricity use in the month when the card is suspended.

[0064] In this embodiment, before the exported multi-month zero-flow card list is submitted to the operator for shutdown processing, some non-abnormal situations in the multi-month zero-flow card list are not taken into consideration, which leads to customer complaints and reduced customer satisfaction. According to customer telephone complaint feedback, non-abnormal situations are used as the basis for auxiliary identification, and non-abnormal situations are divided into four situations: Scenario 1: The collection success rate decreases due to the deactivation of the SIM card; After investigation and analysis, it is found that most of the alarming SIM cards are from mobile operating terminals that are not activated by the card holder; Scenario 2: The failure of the fault inspection equipment causes the success rate of SIM card information collection to decrease; Scenario 3: The terminal equipment of the dual-power customer happens to switch to another power metering device in the current month; Scenario 4: The suspended customer from the marketing operation status happens to resume electricity use in the month when the card is suspended; In order to prevent the recurrence of misoperation, a whitelist module is added to the SIM card bill intelligent management and control system to assist the bill verification module in identifying non-abnormal information in the monthly zero-flow card list information.

[0065] An intelligent management and control system for SIM card bills based on power business, comprising: a PC and a network information interface connected to the business layer of a telecom operator, wherein the PC imports the SIM consumption data bills of power users into a business bill database through the network information interface, and the PC is also provided with a bill standard format generation module, a bill checking module, a bill display module, and a white list module coordinating with the bill checking module;

[0066] The bill standard format generation module is used to standardize the bill information obtained from different telecom operators into a unified format;

[0067] The bill verification module is used to remove abnormal information in the SIM card account information, generate a list of cards that should be cancelled but have not been cancelled and a list of zero-flow cards for multiple months after screening, and send them to the telecom operator for SIM card cancellation operations;

[0068] The bill display module is used to display the valid information list of the SIM card;

[0069] The whitelist module is used to identify non-abnormal information in the multi-month zero-flow card list generated by the bill verification module.

[0070] The whitelist module sets the following scenarios for identifying non-abnormal information in the multi-month zero-flow card list:

[0071] Scenario 1: The mobile operation terminal with unactivated card;

[0072] Scenario 2: Production failure inspection equipment;

[0073] Scenario 3: The terminal equipment of a dual-power customer happens to switch to another power metering device in the same month;

[0074] Scenario 4: A suspended customer in marketing operation status, who happens to resume electricity use in the month when the card is suspended.

[0075] Through the intelligent management and control method and system of SIM card bills based on power business designed in this embodiment, the SIM card bill data of power business in Jinhua, Zhejiang Province was checked. From August to November 2019, a total of 10,296 abnormal SIM cards were checked and 30,004.2 yuan of funds were recovered. Table 2 shows the results of the SIM card bill data check:

[0076] Table 2. SIM card bill data check results

[0077]

[0078]

[0079] The specific implementation described above is a preferred implementation of a method and system for intelligent management of SIM card bills based on power services of the present invention, and is not intended to limit the specific implementation scope of the present invention. The scope of the present invention includes but is not limited to this specific implementation. All equivalent changes made to the shape and structure of the present invention are within the protection scope of the present invention.

Claims

1. A method for intelligent management and control of SIM card bills based on power services, characterized in that: The steps include: S1. According to the power user's identity authentication protocol, the initial bill information of the SIM card bound to the power user's identity information is obtained from the telecommunications operator's network information interface, and the bill information is imported into the service bill database; S2. The bill standard format generation module obtains bill information from the business bill database to obtain standard bill information in a unified format; S3, the bill checking module removes abnormal information from the standard bill to obtain a list of valid SIM card information; S4. Display the valid information list of the SIM card through the bill display module; The bill checking module removes abnormal information from standard bills, including the following steps: Eliminate SIM card information of duplicate billing cards through duplicate checking mechanism; By comparing the SIM card monthly bills month by month, we obtained the actual card cancellation list; Compare the actual card cancellation list with the card cancellation application information to obtain a list of cards that should be cancelled but have not been cancelled; Export the list of SIM cards with zero traffic for multiple months. Based on the actual monthly traffic data of each SIM card, select the list of SIM cards with zero actual traffic for six consecutive months or more; Use the whitelist module to identify non-abnormal information in the monthly zero-flow card list information; The identified non-abnormal card information is re-imported into the SIM card valid information list as normal card information; Send the list of unsold cards and the identified multi-month zero-flow cards to the telecom operator for SIM card cancellation; The whitelist module is used to identify non-abnormal information in the monthly zero-flow card list information, including the following steps: Scenario 1: The mobile operation terminal with unactivated card; Scenario 2: Faulty inspection equipment causes a decrease in the success rate of SIM card information collection; Scenario 3: The terminal equipment of the dual power user happens to switch to another power metering device in the same month; Scenario 4: A suspended user in the marketing operation status, who happens to resume electricity use in the month when the card is suspended; In order to avoid erroneous operations when SIM is removed, situations one to four are added to the whitelist module as a screening mechanism to identify non-abnormal information in the monthly zero-flow card list information.

2. According to claim 1, a method for intelligent management and control of SIM card bills based on power services is characterized in that: The sources of the initial bill information include China Telecom SIM card bills, China Mobile SIM card bills and China Unicom SIM card bills in different bill formats.

3. According to claim 1, a method for intelligent management and control of SIM card bills based on power services is characterized in that: The format of standard billing information includes data information such as: operator name, card number, package fee, actual fee, application type, card activation time, standard traffic, actual traffic, card status information, and the unified traffic unit is MB; in the defined status type, "0" is disabled, "1" is in use, and "2" is new card inventory; in the application type, "1" is low-voltage acquisition, "2" is high-voltage special transformer, "3" is public transformer assessment, "4" is online monitoring, "5" is PDA, "6" is fault reporting, and "7" is video surveillance.

4. A SIM card bill intelligent management and control system based on power business, applicable to the SIM card bill intelligent management and control method according to claim 1, characterized in that: It includes: a PC and a network interface connected to the business layer of the telecom operator. The PC imports the SIM consumption data bill of the power user into the business bill database through the network interface. The PC is also provided with a bill standard format generation module, a bill verification module and a bill display module; The bill standard format generating module is used to standardize the bill information obtained from different telecommunications operators into a unified format; The bill checking module is used to remove abnormal information in the SIM card account information, generate a list of cards that should be cancelled but have not been cancelled and a list of zero-flow cards for multiple months after screening, and send them to the telecom operator for SIM card cancellation operation; The bill display module is used to display the SIM card valid information list information.

5. According to claim 4, a SIM card bill intelligent management and control system based on power business is characterized in that: It also includes a whitelist module that coordinates with the bill checking module, and the whitelist module is used to identify non-abnormal information in the multi-month zero-flow card list generated by the bill checking module.

6. The SIM card bill intelligent management and control system based on power business according to claim 5 is characterized by: The whitelist module sets the following situations for screening non-abnormal information in the multi-month zero-flow card list: Scenario 1: The mobile operation terminal with unactivated card; Scenario 2: Production failure inspection equipment; Scenario 3: The terminal equipment of the dual power user happens to switch to another power metering device in the same month; Scenario 4: A suspended user in marketing operation status, who happens to resume electricity use in the month when the card is suspended.

Images