Implementation of restructured APDRP during 11 th Five year plan – Base Line Data Collection System

1. Implementation of restructured APDRPduring 11th Five year plan – Base Line Data Collection System APDRP Group

2. APDRP proposed in 11th Plan The schemes shall be executed in two parts – Part-A : • Part-A of the scheme shall consist of projects for establishment of baseline Energy & Revenue data including IT applications for Energy Accounting/Auditing, Customer care solutions and SCADA (Large cities). Part-B : • Part-B of the scheme shall consist of projects for distribution system strengthening and up-gradation works.

3. Challenges Faced during 10th Plan • Utilities are lacking the domain knowledge in IT. • IT industry is not having the domain expertise of the Distribution business – Resultant : trying to push off the shelf, ill conceived solutions available with them. • The utilities adopted piecemeal standalone solutions, difficult to integrate on common platform. • Utilities did not carry out business process re-engineering / made process IT worthy, essentially required for sustaining IT enablement. • Resistance to change

4. Implementation Methodology • Utility has to identify no. of towns to be proposed for inclusion in APDRP of 11th plan for subsequent preparation of detailed project reports. • For implementation of Baseline data collection system of the Scheme, utility shall be provided a Comprehensive Bid document covering Technical specification and contract conditions, which is to be customized to meet utility specific requirements based on existing business processes and assets in position. The Bid document is under preparation and likely to be available immediately after sanction of the scheme by Govt. • As per requirement of the utility they may appoint one of the consultants from empanelled accredited consultants for utility specific customization of the document and handholding from concept to commissioning of baseline data collection system. • Utility shall also be provided a list of IT firms, who are capable of taking up such complex IT projects and they may choose one of these IT firms for implementation of the project through a process of competitive bidding.

5. Stepped Approach to create IT infrastructure • Under 11th plan APDRP collection of baseline data without human intervention and creation of GIS based indexing of assets and customer is proposed to be mandatory for utility, which will enable energy audit and accounting and setting up of single window customer care center. • Considering above SRS template proposes to create centralized data center where database and application server will reside and necessary IT infrastructure will be established at the areas covered under APDRP scheme for collecting base line data and also creates IT backbone in the area of distribution business process to capture the benefits of the investments on sustainable basis. • The proposed facilities at data centre are scalable and utility will have a option to cover the entire area at a later date with least incremental cost .

6. Scope of work-SRS

7. Hardware Architecture • Modular design • Scaleable • Expandable • Adherence to industry standards • Vendor neutral & technology independent • Data storage at central server • Data backup & archiving facility

9. Data center architecture • Fault tolerant tier IV data center infrastructure with simultaneous active distribution paths. All hardware with duplicate power supply and separate UPS with N+1 redundancy • Data base and main application servers shall be enterprise level SMP RISC / Itanium processor based UNIX systems • Data base servers shall be deployed in cluster fail over mode and application servers in scale out mode • Data center shall be connected to other utility offices through VPN WAN

10. Data center architecture- Cont • The Data base servers shall have access to the common single database on an external central storage through a switched Fiber Channel Storage Area Network (SAN). • The central storage shall support hardware based (host independent) data replication to a remote DR site and bi-directional data copy • To achieve zero performance impact backup, backup server will back up from the mirror copy of the database • Additionally the robotic controlled tape library shall be central library of tapes for all the servers offered in the system.

11. WAN • Creation of WAN Backbone, capable of carrying data and voice and through secure VPN tunnel via internet. • The Router shall have ISDN BRI Card for ISDN connectivity in case of link failure. • There will not be any connectivity in office hierarchy. All utility offices shall be connected directly to the Data centre. • Minimum 2 Mbps VPN link for connection between Data center and Utility HQ ( If data center is not located inside HQ premises ) and subdivision offices. Other offices shall be connected through 512 Kbps VPN link. • Provision for upgrading band width • Datacenter to have 2 Mbps internet leased line for web server

12. IT infrastructure at other offices • All Subdivisions shall have data acquisition server fitted with front end processor for data acquisition from Feeder/ DT/ HT consumer meters at pre defined interval. • All offices shall have a LAN connected to switches and Router for upward connectivity to data center.

13. IT infrastructure at S/s and DTs • All Substations shall have a data logger PC which will collect all S/s Meter data through RS 485 port of the meters through a RS 485/ RS 232 data converter unit. • The data logger data to be transmitted to data acquisition server at sub division over GSM/CDMA/ PSTN lines. • Data logger at substation will have on screen display of the S/s SLD and energy balance and losses at Bus bar and Transformers ( Both instantaneous and aggregated Value) Moreover data logger will display voltage, current and demand ( both maximum and minimum) . • DTs and selected HT consumers (HT consumers of mixed feeder) shall have meters with RS-232 ports and data acquisition server at Subdivision shall poll meter data at regular interval through GSM/ CDMA modems retrofitted on meter RS 232 or optical port itself. • All the Sub division servers shall push the entire incremental meter data to data center during off-peak hours for aggregation and MIS generation as per various hierarchical requirement of the utility.

14. Application packages • The application packages designed for defining the various business processes of the utility have been categorized in three parts in SRS Template- • Part-A (Modules essentially required by most of the Utilities, since they do not possess these IT enabled systems, like GIS based Consumer indexing, Asset mapping and Network Analysis, Meter Data Acquisition, Energy Audit, Customer care center, New connection, Dismantling & disconnection, MIS ) • Part-B (M,B,C) - If M,B,C and other standalone software solutions are in place, the bidder has to integrate the same with the offered solution including design and supply of necessary middleware. However, he shall supply necessary software solution for M,B,C also, if the same is not available with the utility or the existing system is not integratable with offered solution. • Part-C (Optional packages of Asset Mgmt. & Maintenance Mgmt.)

15. (Facilities to be created by owner) Basic infrastructure and facilities for Data Center : • All civil works of the Building, (data center/ Call center etc) approx. area 500 Sq.Mt for data center or as per requirement of bidder • Precision Air Conditioning & ventilation system, Fire fighting, access control system, Internal and External electrification of data center building as per bidder’s requirement • Disaster recovery and Business continuity plan • Supply of meters and development of web portal

16. Interfaces between separate systems (internal & external) shall be message based. • Integration technologies must be industry proven standards, scalable and shall provide for extensive functionality. • Web based Message oriented middleware and Object Request Broker middleware technologies shall be the preferred for integration of desperate applications and databases within n-tier architectures. • It shall be possible to set various options and logics of the system from a central location to ease the system administration work.

17. GIS based Customer and Asset indexing and mapping • Implementation of enterprise GIS based application integrated with other business process application such as energy audit, billing, Network analysis, Customer care center, SCADA/ DMS etc. • Creation of indexed customer and asset data base and mapping on GIS platform. • Satellite imagery shall be used as base map and physical survey map using DGPS/ Total Station shall be geo referenced and digitized to create accurate representation of utilities assets and customers.

18. Application Packages for Business processes of utility The application packages designed for defining the various business processes of the utility have been categorized in three parts in SRS, Section: G-2 - • A: Modules essentially required by most of the Utilities, since they do not possess these IT enabled systems, like GIS based Consumer indexing, Asset mapping and Network Analysis, Meter Data Acquisition, Energy Audit, Customer care center, New connection, Dismantling & disconnection, MIS • B: (M,B,C) - If M,B,C and other standalone software solutions are in place, the bidder has to integrate the same with the offered solution including design and supply of necessary middleware. However, he shall supply necessary software solution for M,B,C also, if the utility so desires. • C: Optional packages of Asset and Maintenance Mgmt.

19. Thank You