Power Theft Intranet Drop Your Complaints Tenders Payments Details SPDCL email Careers

       
  Company Information l Best Practices   HOME
 
 
Consumer Analysis Tool
Utility Customer Information Management

Background :

101 Private Accounting Agencies perform the billing activity for Discom.

Almost every agency works on a different platform and process for doing the billing.

The exceptional reports are generated and distributed only at local level leaving no tool with management to monitor the exceptions at the field.

The Discom needs to shelter PAA s for any reports or for doing any analysis on sales trends & consumption patterns.
 

In order overcome the above challenges Consumer Analysis Tool (CAT) is designed to:

Gather and Consolidate the information available with the PAA into a central database.

Validations are performed to the data and then the database is brought to an common format (Mining).

Information thus consolidated is used to create necessary reports.

Generate Reports and provide to the management and field personnel for taking necessary action
 

Now CAT has been decentralized at Circle level for easy data handling and for early processing of data thereby reducing the time lags for taking the necessary actions

CAT database is extended and is used as Sales Database

Common Billing System

CBS – Background Behind its Birth:

101 Private Accounting Agencies perform the billing operations for Discom.

 Electricity Revenue Offices receives payments and processes billing exceptions

PAA s use different software platforms like COBOL, dBase, FoxPro, Oracle etc
Software used by majority of the PAA s are outdated and generating reports from these programs is a cumbersome process

There is no uniform data structure maintained at PAA s

There is no standardized procedure adopted for report generation

Poor quality of data maintenance by PAA s

Little provision in the database to meet future requirements.

There are no validations to cross-check quality of data.

Robust data backup procedure is not being followed by all PAA s.

PAA s are dependent on programmers for any modification of procedures and generation of new reports. This causes inconvenience as most PAA s do not have in-house programmer support.

Due to non-availability of consumer database at ERO s, consumer grievances are not attended in time.
 

CBS is a user friendly, highly secure GUI based application which enables the billing agency (PAA s) to prepare consumer bills and generate required reports.

Customer Service Centre

The CSC is a Single Window Solution for all customer - facing activities, the center would provide better service and convenience to the customers through a “Customer Friendly Environment” and extended working hours will be from 8 am to 8 pm

New service connections

Meter related Complaints / requests

Billing related complaints / requests

Disconnections & dismantlement related complaints / requests

Supply related complaints / requests

Other customer related complaints / requests

Electricity Call Centre

Electricity Call Centre is established with the motto of providing a round the clock service in the least possible time

Complaints handled at ECC can be broadly classified into two:

  • Supply Related.

  • Meter Related.

Computerized Collection Centre

TOP

EROs give manual receipts for payments

Collection information from EROs are entered into PAA database

The C C C initiative, being piloted at Guntur, aims at computerizing the entire collection process
 

Spot - Billing

Previous readings are loaded in the device.

Meter readers feed current meter reading into the device.

Bills are generated, printed and issued to the consumers on the spot.
 

… leading to reduction in billing errors & cycle time
 

E-Seva

E-Seva is an AP government initiative related to collections for power, water, telephones etc.

Billing data is loaded into e-Seva servers on a daily basis.

Collection status is provided online through the e-Seva Website.
 

…making payments easier for the customers

Exceptions Handling

TOP

Operations
    T I M S (Transformer Information Management System)

Commercial
    CAT (Consumer Analysis Tool)
    FIR Index (First Information Report Index)
 

 T I M S Concept:

A Technology Solution to Manage Distribution Transformers.

Enables effective tracking of transformers throughout their life-cycle.

Identify Structures for Load enhancement.

Help Management in Vendor Analysis on Transformers Performance
 

T I M S Objective

Effective tracking, utilization & maintenance of DTRs

Better customer service
    Deployment
    Exception handling (in case of failures)

Greater visibility leading to improved decision making for the management
 

CAT Concept:

In order overcome the above challenges Consumer Analysis Tool (CAT) is designed to:

Gather and Consolidate the information available with the PAA into a central database.

Validations are performed to the data and then the database is brought to an common format (Mining).

Information thus consolidated is used to create necessary reports.

Generate Reports and provide to the management and field personnel for taking necessary action
 

Now CAT has been decentralized at Circle level for easy data handling and for early processing of data thereby reducing the time lags for taking the necessary actions

CAT database is extended and is used as Sales Database

 FIR Index (First Information Report Index)

On-line FIR Index Process.

Quick retrieval process of FIR Data.

On-line report process.

Identification of second offence.
 

Management Information System

C P M R S .

Employee Database.

Inventory Management System.

TOP

Circle Performance Management & Reporting System. (C P M R S)
History:
  • Manual consolidation of performance parameters were being collected from all circles
  • Figures that were submitted once were changed subsequently on many occasions
  • Time spent in consolidation, verification and analysis was very high
  • Effort for follow up of information was also high
C P M R S – The Solution:
  • C P M R S is aimed at consolidation of the performance parameters from all the circles
  • Data is collected in a central database
  • Reports required for management and others are being generated easily
  • Information once submitted can be changed only by the administrator (who does so after approval)
     
Key Features, Uses & Advantages
  • No effort spent in consolidation
  • No rework required in correcting the reports
  • More time spent in analysis than in consolidation
  • Reduced time in follow-up for information
  • For any information requirements a central database is available to take shelter
  • Performance reviews of all circles are being conducted using C P M R S reports
     
Employee Database
Back Ground:
  • Staff transfer scheme was to be implemented as a part of the reforms programmed.
  • Central database of employees across the state to identify the achievements, track the disciplinary cases, salaries structure etc was unavailable.
  • No tool to help in categorizing the employees across various circles, designations, departments etc.
     
The Solution
  • Assist in implementation of staff transfer scheme
  • Update status on training administration
  • Address employees-related queries by management team
  • Help the field administration staff by providing an automated tool to track HR processes.
Inventory Management System
Functionality Levels:
  • At Corporate Level
  • At Circle Level
  • At District Stores Level
Functionalities at Corporate Level
  • Better control over all materials
  • Centralized PO process with delivery at stores level
  • Tracking of deliveries made after scheduled date
  • Stock status at any point of time across various stores
  • Settlement of bills on centralized POs
  • Understand stock movement details
  • Identify fast, slow moving and dormant materials
At Circle level
  • Can place local Purchase Orders
  • Settlement of bills against local Purchase Orders
  • Tracking of deliveries made after scheduled date
At District Stores End
  • Receipt of items corresponding to either centralized PO or local PO
  • Send the stock status report to circle office
  • Issue material based on the request raised by field engineers
  • Handle stock transfer between the stores
  • For each material issued keep track of the work orders and to whom it is issued
  • Handling of the material returned to the store
Key Benefits
  • Control business transactions through a single window
  • Access key information from anywhere, at any point of time
  • Reduce total cost of ownership
  • Improve efficiencies by eliminating effort duplication
 
   

 

       

      TOP