Customer Management System

There are tons of systems out there trying to improve business processes of utility companies in general or electric companies in specific.

The key is still doing the re-engineering process well and the application system will just a tool to follow the processes. I put some of my thoughts about Electric Management System in this blog. Feel free to read and comment.
Showing posts with label electric utility system. Show all posts
Showing posts with label electric utility system. Show all posts

Wednesday, February 13, 2008

Benefits of Electricity Digital Panel Meter

Electricity Digital Panel Meter or for short Digital Meter has been available in the market by different vendors. The question arises for Electricity or other utility companies in general if they need to invest in digital meters.

Digital meters are NOT all Automatic Meter Reading (AMR). Digital meter is just like analog meters but displaying measures in digital, while AMR is sending the meter reading data to reading center periodically using communication technology like internet, network LAN, GPRS, etc.

In this article, we will discuss only Digital Meters. If digital meters are just like analog meter, so what the benefits to migrate to digital meters? Below are some benefits that electricity companies can have by using digital meters:

# Digital Meter can measure electricity consumption more accurately and reliably. With the digital technology, the problem of meter brakes that could happen in meter analog will not going to be encountered. This way, electricity company will charge the bill to customer more fair. The company can even decides to be as accurate as decimal points in term of electricity consumption.
# Related to previous point, since the mechanical parts are less, the maintenance period becomes less as well. The age of digital meter can be longer than ordinary mechanical/analog meters.
# Most digital meters are designed to be AMR ready. Electricity company has option to read this meter using conventional meter readers or through AMR (network LAN, etc).
# Most digital meters are equipped with probe or scanning device. This is used to transfer reading in semi automatic way. Why semi automatic? because reader should go to the meter with Hand Held Unit / Pocket PC and connect to pocket PC probe to digital meter probe. The digital meter will then transfer all the reading information to Pocket PC. This will be a good way to ensure that the readers are visiting the property instead of doing cheating by inputting reading in "coffee shop".
# Reduce cases of meter tampering. Digital meter is more difficult to tamper, if bypass meter is done, the short circuit can send signal to meter that possible tampering is done.

Before deciding if it is necessary to migrate to digital meters, a feasibility study needs to be done. Simple survey to ask within the company department should be carry out:
1. Does currently the company and client concern about more accurate reading? If the tariff price is high, this could be an issue. If the tariff is very small, it will not make a big difference by having 1-2 kW consumption.
2. Does currently the company spend big budget to maintain mechanical meters?
3. Does currently the company experience a lot of meter tampering cases?
4. Etc.

The feasibility study will decide whether the investment will give more benefits in term of tangible and intangible for future.

Currently, several companies that are producing digital meters are: Centron, GE, GANZ, IKRA, EMH, etc.

Wednesday, January 23, 2008

Attention to Utility Company: When your meter data is not reliable

In some utility company, the meter information stored in billing system is not reliable. This situation could happen when utility company pays too much attention of customer ID or service ID or property ID or other ID to locate and identify the service. It means that when doing meter reading, the readers tends to look for those IDs instead of meter information. If your company is guilty of doing this activity, try to look on how many anomalies or exception related to meter reading. Either, the consumption is too high, too low, or considered as many meter turn overs. If the statistics show that the number of anomalies related to meter reading is high, most probably your utility company has no meter information updated in billing system.

One action to correct the meter information is by doing data gathering to obtain updated meter information. To make it worst is that only readers know how to locate the property based on ID. And most of the time, you will not want to allocate your readers to do data gathering that could take time as compared to normal reading. This can sacrifice the billing period that your company has set. Not to mention if the house is locked and the reader needs to wait.

One solution is to use other resources as surveyors and they will do sweeping the whole area. In order to make the sweeping efficient and they could link all the meter info to correct customer ID or other ID, a preliminary campaign should be done. A reader when doing normal reading should put sticker near the meter info and write related customer ID or whatever ID that the company wants to relate to. This way, the surveyor could link all the meter info gathered to the ID used in billing system.

Train the surveyor effectively so that the method of sweeping is done correctly and surveyor know the meter information to gather.

Take note on meter exchange done during the data gathering period. All meter exchange activities should be monitored and integrated with data gathering data to make sure that the data is always updated.

Tuesday, November 13, 2007

Online Payment 24/7 for Billing System

Online payment for billing system in general or utility billing system in specific requires a defined business process to ensure all financial statements are correct and good data integrity.

Online payment could be handled in several ways, namely:
- Online payment through website. This requires coordination for any payment gateways or banks to receive payments using credit card and/or bank transfer.
- Online payment through ATM. A collaboration with banks is needed.
- Online payment through cell phone. A collaboration with mobile service providers are needed.
- Etc.

One of the benefits of online payments methods above is that customers can pay at their convenience and they can do it 24 hours a day, 7 days a week. However, All payments mentioned above should be treated “offline” by billing system. What does it mean? Why Online payment should be treated “offline”? What I mean is that outside or third party should NOT be allowed to access and updated the billing system online/directly. This is important to ensure billing system data integrity and security.

All online payments should be stored in a file or separated database for further processing during batch process. Thus, these payments are treated “offline” similar like payments in the offices that do not access/LAN to billing system.

Tuesday, November 06, 2007

Knowledge Management in Project Implementation

Project Implementation, especially in Utility System Project Implementations, requires specialist consultants to do the tasks. Each consultant has his/her role and responsibility to carry out the project implementation. Mostly, there is no overlap knowledge to minimize the cost of consultants in the project.

The situation like above creates a fragile project environment if a one consultant is absent due to any reasons. The project could be affected or worst it could be stopped temporarily if the consultant who are absent has the knowledge that could create a bottle neck in the project implementation.

This is where knowledge management should be considered in project implementation. There should be another person or consultant that could handle the task if a certain consultant is absent. Of course the result could not be maximum as the replacement consultant is a current consultant working on the project implementation handling other area. Knowledge management could be implemented by assigning a buddy consultant (from different area) to each consultant (say consultant A). The buddy consultant should attend all meetings attended by the consultant A to make sure he/she knows the progress and some tasks done by consultant A. This ways, a buddy consultant could handle temporary some tasks if consultant A is absent temporarily?

Another question is that... how if consultant A is absent permanently because of resigning? Well, a good human resource department in a company should require 1 month advance notice for a consultant to resign. This time could be enough for a company to hire another consultant with the same or similar profile.

Sunday, September 30, 2007

Standard Reports for Customer Management System in Utility Company

The module “Reporting or Management Information System” should provide comprehensive information concerning the Commercial activities necessary for the company’s management. The functions “Alarms” and “Inquiries” can serve this purpose.

Alarms serve to monitor selected indexes, which are important for the company’s management. The indexes have flag-shaped labels, whose colour changes depending on the reached index value according to pre-set limits. These alarms make it possible for the responsible employees to quickly establish what Commercial areas are trouble-free and, on the contrary, which ones present an unfavourable development allowing them to take the necessary measures.

Inquiries display comprehensible information about the selected Commercial management area of the Distribution Company and can be displayed in text or graphic form. Selecting information can be restricted to specific periods, query types and other conditions (the different types of queries are described later in this chapter).

To provide the necessary information, the module should use of the following queries:

1. METER READING PROGRESS
This query displays information about the service point-readings that have to be or have been processed by the readings module within the selected period. This query displays the number of service points planned for reading in the selected period, the number of service points for which a theoretical reading date has been Generated, the number of already read service points, as well as the ratio Readings – theoretical reading date, and the ratio Performed readings – total number of planned readings.

2. METER READING QUALITY
This query displays the results of the readings performed in a specific period of time. The first to appear is the total number of readings with the respectively Generated theoretical reading date. It also specifies the number of real and exceptional readings, of not-performed readings due to customer absence, and the total number of not-performed readings.

3. DAILY AND MONTHLY BILLING
This query displays the daily billing course, namely the number of billed supplies as of a specific day, billed amount usage, the advance billed amount, the ratio Supply billed by usage estimation – total billed usage.

4. MONTHLY BILLING
This query displays the following monthly billing information: number of billed supplies, total billed usage in local currency, volume of billed technical units in local currency. This query has two windows. The second one contains the billing details: the total arrears/overpayments, the usage billed amount, the billed fixed charge, the billed miscellaneous charges, the VAT included in the prices and the advance billed amount.

5. ANALYSIS OF REALISED BILLING
This query allows viewing the information once the billing has taken place. This information includes the total number of processed supplies, the number of supplies billed according to reading and according to estimation, the number of exception bills, the total billed usage, the total billed amount and the billed advances.

6. ANALYSIS BY TYPE OF BILLING OF ISSUED PD
This query displays all the information concerning the types of bill rules other than energy usage bills, indicates temporary supply bills, contract charges, frauds, miscellaneous charges, instalments, advance collection, deposits, etc. within a specific period.

7. BILLING EXCEPTIONS PROGRESS
This query display the exceptions registered in a specific period of time, their settlement and the average settlement time.

8. ANALYSIS OF REALISED PAYMENTS
This query displays the initial (at the beginning of the monitored period) amount of the outstanding bills, of the bills sent for collection in the course of the period, of the bills collected in the course of the period, as well as the outstanding bills balance at the end of the monitored period.

9. COLLECTION LENGTH
This query allows monitoring the duration of the different collection stages for the different bill types in days.

10. DEBT ANALYSIS I.
This query allows monitoring the outstanding claims (debts) in the different bad payers management stages, namely as for their number, percentile constitution or amounts in local currency within a specific period of time.

11. DEBT ANALYSIS II.
This query allows monitoring the percentile development (growth or reduction) of claims, namely as for their number and amounts in local currency within a specific period of time.

12. DELINQUENT ACCOUNT ANALYSIS
This query allows monitoring the bad payers management process and its effects, i.e. the number of disconnection notices, disconnections, reconnections, bad claims, legal recoveries and deprecations.

13. COMMERCIAL CYCLE LENGHT

This query displays the average duration of the whole “reading, billing, sending for collection and collection” Commercial cycle within a specific period of time.

14. CONTACTS ANALYSIS
This query allows monitoring the development of the number of contacts as for their settlement time, speed, type (justified and unjustified) and their duration.

15. SERVICE ORDERS PROGRESS
This query displays the number of service orders, specifying the number of unsettled orders at the beginning of the monitored period, the increase of new orders, the amount of orders settled and canceled within the period, as well as the promptness of their settlement and their duration.

16. REQUESTS PROGRESS

This query displays information concerning the supply requests within a specific period of time. The issue here is, for instance, the following information: number of unsettled requests at the beginning of the period; number of filed, settled and cancelled requests within this period; the average number of settlement days and the duration of the requests in the system, as well as the number of unsettled requests at the end of the period.

17. CONTRACTS PROGRESS MONITORING
This query displays information about the number of valid power supply contracts available in the system at the beginning of the monitored period; the number of contracts created, edited and terminated within this period, and the number of valid contracts at the end of the period.

18. STATISTICS OF BUSINESS ACTIVITY
This query provides information about the amount on-line operations performed at the different Commercial offices, monitoring the different types of Commercial activities both in absolute and percentile expression.

Wednesday, August 01, 2007

Failing Rate of Project Implementation

Implementing Electric Utility System is quite similar like implementing IT Projects. The rate of failure projects is quite high.

Based on the study done on IT Projects quoted from CIO.com

n 1994, the researchers found that 31 percent of the IT projects were flat failures. That is, they were abandoned before completion and produced nothing useful. Only about 16 percent of all projects were completely successful: delivering applications on time, within budget and with all the originally specified features.

"As of 2006, the absolute failure rate is down to 19 percent," Johnson says. "The success rate is up to 35 percent." The remaining 46 percent are what the Standish Group calls "challenged": projects that didn't meet the criteria for total success but delivered a useful product.


This rate should aware us everytime we are going to start the project. Typical reasons in implementing the Electric Utility System is lack of knowledge of project scope. Or maybe... misunderstanding of project scope from both parties.

Marketing people at the starts tries to sell the project with no clear definitions of the project. Or the client as well sometimes did not see on the details. Thus, when the project starts it is difficult to implement strict milestones to close some stages. Protocol of acceptance becomes difficult to sign and vendors becomes more lenient to give some modifications. When modifications are given, the client does not stop asking for more modifications.

Thus, before starting the project both parties should know in details and agree upon the scope. When the project starts, many project management tools or methodologies can be use to monitor critical path and problems arises that can hinder the objective of the project.


Visitors