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 data audit. Show all posts
Showing posts with label data audit. Show all posts

Monday, September 17, 2007

Project Methodology Explained - Data Gathering Sweeping

Today, I was discussing with the client about the methodology of how to sweep the area using map in data gathering. This data gathering is about taking information of meters and GPS position of the properties.

The discussion was going very well and a lot of ideas and comments were interchanged. The hardest part in the data gathering sweeping using maps is during planning. During planning, we need to visit the area and divide the area into smaller areas to work on. Base on the smaller area define, the maps will be printed and the sweeping direction should be defined on the map.

Estimation of how many days to finish the small area should be determined. The end results of this planning will be:
- Printed maps with sweeping direction defined. All these maps should be properly named so that we can easily identify the relation with the big map that we are going to post on the wall.
- Estimated schedule to finish sweeping the area. This could be the basis to compare the progress and performance of the surveyors.
Of course we have other tools to monitor the performance and do the auditing of data quality gathered by surveyors.

Take note that good planning is the important for the data gathering. As much as possible, we do not let the surveyor to make a decision in the field. All guides should be clear from the beginning. All sweeping directions should be defined clearly in the maps.

Friday, August 10, 2007

Simple Data Gathering Audit: Using Excel

A good Data Gathering Management System enable the system to track the time when data is gathered in the field. Of course this time stamp is obtained if only the surveyors are using hand held / HHU / PDA / TPA / Pocket PC during data gathering. Based on this information, the supervisor can extract the data together with its time stamp. Daily the supervisor should check the time stamp.

Example of data:
Data Date&Time
1,S:John D:Data1 T:Jul 28 2007 10:10AM
2,S:John D:Data2 T:Jul 28 2007 10:13AM
3,S:John D:Data3 T:Jul 28 2007 10:16AM
4,S:John D:Data4 T:Jul 28 2007 10:18AM
5,S:John D:Data5 T:Jul 28 2007 10:22AM
etc...

Supervisor can check the time of first data gathered, last data gathered, and all data in between. This can give better reasons for supervisor to question the surveyors with poor performance. Questions like:
1. Why you reach the first property/data in 2 hours?
2. Why you take a looooooong break during lunch?
3. Why you did not come directly to the office after finishing the last property/data?


Visitors