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.

Wednesday, September 19, 2007

How to get accurate GPS

In implementing new Customer Information System for Utility companies, data gathering is often required to complete the data that are lacking. Identifying the data that will be gathered is important before going to the field. Additional data can be added since the cost of adding additional data during field campaign less.

GPS coordinate of properties or customers become an important data for the company. The main issue is how to get accurate GPS during field gathering. You can take a look at how the GPS work before designing any activities of GPS gathering in the field.

There are many ways to be considered to get GPS accuracy but from my experiences, the most important is to implement PDOP value in your application. PDOP as defined by GPS Glossary of UIOWA.EDU:

"PDOP: Percent Dilution of Position. Measure of the geometrical strength of the GPS satellite configuration. The amount of error in your position. PDOP less than 4 gives the best accuracy (under 1 meter). Between 4 and 8 gives acceptable accuracy. Greater than 8 gives poor accuracy."


In simple words, the PDOP is an indicator that tell you whether your GPS coordinate that you will take is having enough satellite, enough signal strengths, good satellite positions, etc. The lower the value of PDOP, the better.,

If you want to buy the GPS HHU, ask your vendor if they have PDOP module also installed. If you have bought the GPS HHU, try googling to find PDOP .dll or modules that you can integrate in your HHU applications.

Once you have this module installed, you can always remind your surveyors to get GPS coordinates while the PDOP values shown is as small as possible. This will give you another reminders like:
- avoid too close to tall buildings.
- avoid too close to tress or other obstacles.
- avoid too close to surveyors' body. Yes, your body can block the signal as well.
- and other strategies.

If you want to have better accuracy of GPS, you can even plan the time to do GPS data gathering. All satellites are rotating following their orbits, so you can estimate the best time in your area to have more satellites with more strength. This schedule of satellites are recorded by Almanac. To simplify the discussion, you can try the planning software by Trimble. It is free to try.

I will try to post most of my techniques based on my experiences in GPS gathering in my next post. I hope this can help you. Feel free to leave comments if you have questions or suggestions on how to improve the GPS accuracy during data gathering.

Tuesday, September 18, 2007

Report any abuses in your project implementation

Since the project implementation life cycle is mostly short, the monitoring done by the project manager often loose. Authoritarian project manager is focussed on the end product without much participation. Due to this, you will encounter many abuses by the project team members. The most common is by claiming the work that was not done by himself/herself. This could be done with or without the knowledge of the person doing the job. How unfair the world is, right?

Even if the person knows that his/her task was claimed by another team member, he/she just kept quite because he/she does not want to ruin the relationship with the team member who claimed the work. Well, if you have the same experience and afraid to report, you might try informing your boss using Anonymous Email. Be sure that you put enough evidences. I am sure your boss will appreciate that. If you do not want to make it obvious, you can link it with different cases not related to your case. The main point is to teach the lessons to the abuser, right?

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.

Sunday, September 16, 2007

Project Hobby – Learn to play Piano

Aside from my busy days in project implementation of electricity system, I like to spend my time doing my hobbies. At least, it will my day relax after spending time in the office. I like music especially when piano plays involved.

I like to hear my friend playing piano during weekends. She is one talented girl who can just come up with the cords to play with. She always told me that it is not too late to start learning to play Piano. “Yeah right”… I said to myself, “with my age?” To my surprise, I recently read an article linked by Piano Chords Blog that was showing a 94 year old man is learning piano.

Well, either it is too late or not, I tried before when I was a kid and it seemed that my talent is not there. For you that are still wandering if you have a talent for playing piano, you might try some lessons. I found many free piano lessons online available.

Saturday, September 15, 2007

Roles of IT Personnel in UNIX Related System

Customer Information System implemented in Electricity companies requires a huge platform to handle all transactions and data in the system. Some of the companies chose UNIX system to deal with better stability. Thus, Roles of IT personnel are important to keep the system running smoothly.

The fundamental role of IT with regards to UNIX related system is to provide support to ensure that the operating environment is running with sufficient reliability and availability. The operating environment includes all HW and SW components which includes PCs, operating systems, databases, servers, routers, switches, hubs, and the network (LAN/WAN) itself that connects these components together.

Backup and Recovery
IT will be responsible for the backup of SYSTEM server files, applications and databases. It is their job to ensure that in the event of machine failure or disaster, there is an up-to-date data and accurate data which SYSTEM can be restored from.

Provides Adequate Service Level to Users
Response times and system availability must be within a set tolerable limit defined by the users. IT must ensure that these service levels are being met.

Ensure Information Security
It is the job of the IT organization as a whole to ensure that the company’s information is not made accessible to unauthorized users.

New IT Positions
The implementation of SYSTEM will mean the creation of new tasks for within the IT department. The qualifications of the current company’s employees will be reviewed and these new tasks will be assigned to them based on their skills. SYSTEM will have need of the following positions:
• Technical Support Staff
• UNIX Administrator
• Network Administrator
• Database (Oracle) Administrator
• Batch Operator

The UNIX Administrator will be responsible for maintaining the environment in which the SYSTEM database and server runs on.

The Network Administrator will be responsible for maintaining network components and configurations like routers, switches, hubs and LAN/WAN connections.

The Database Administrator will be responsible for administration and maintenance of SYSTEM database. He will ensure that table statistics, table indexes, and database spaces are optimized for efficient performance. The database administrator will also be responsible for the daily backup of the SYSTEM database.

The Technical Support Staff will be responsible for maintenance of PCs, deployment of application and perform general support for the system.

Batch Operators will run and monitor the batch process, ensure that the batch process finishes and perform troubleshooting if necessary. The batch operators will be running the batch at night.

It will be necessary to have at least two (2) batch operators working alternately. Having to ensures that the other operator will be there to run the batch if one is sick or on holiday. Batch operation is not a very technical job. The operators will be trained to run the SYSTEM batch, troubleshoot common errors and report major ones to the administrators.

At least one person should be dedicated to the support and maintenance of SYSTEM, this person will need to have UNIX and Oracle administration skills, a working knowledge of networking will be helpful but not essential. The network administrator and general technical support staff need not be dedicated to the maintenance of SYSTEM. Network administration and general technical support duties are merely additional tasks to be performed by existing COMPANY IT staffs. It would also be beneficial that someone else from IT will have a working knowledge of UNIX, Oracle and SYSTEM to do temporary support in instances that the person dedicated to SYSTEM administration is sick or on holiday.

Friday, September 14, 2007

Communication is the Key for Project Manager

I think this is not a secret anymore that communication is important in project management. In my blog post now, I would like to discuss the media of communication. I am not going to talk about the communication strategy. But as simple as the media itself and how to reduce the cost for communication.

Maybe some of you have been using internet phone to reduce the communication cost, but this can be done (of course) if only you have the internet connection. Most of the time in the project, you are mobile and you do not have internet connection in most of the area. That is why I am going to discuss about global phone card.

One company that offer the services is Pingo. With this virtual card, you can save your international call up to 90%. And what I like most is that they are plain and simple. No hidden costs. I used other company before and I was shocked when the credits run out so fast. After some queries, I found out that there are additional fees that were not mentioned in their home page before. I just found out in some small fonts appeared in the long agreement statements.

Well, If you think that I exaggerate things, you can try it yourself for the international calling card and get 5 hours of free International calls during your sign up. You can put also a coupon code “ppp3” to get $3 rebate from Pingo. In total, you get $25 worth of calls for just $17.

Customer Service Defined In Electricity Company

There are many ways to defined good customer service. In electricity company, the customer service should be define to achieve the main goal, which is to provide uninterrupted electricity supply to customers. This main goal will result into several aspects that the company should pay attention for.

1. Giving best services to paying customers. Obviously, these customers deserve better services that non-paying customer. It is important that the company implements Customer Rating giving better rating for those who are paying the bills on time.

2. Warn about the disconnection. Non-paying customers are eligible for disconnection. However, the warning should be given before disconnection. Detailed company policies should be defined about non-paying customers. Special campaign can be launched to socialize the policies to customers. Non-paying customers are also have the right to be warned before any disconnections because electricity is one of the major necessities for daily life.

3. Find fraud connection and act immediately. Electricity fraud connection can result into network interruptions because of overload. Thus, company should find away to continuously find of customers with fraud connections, such as double connection and meter bypass. This step is to ensure that no network interruptions for paying customer because these illegal fraud connections.


Visitors