R-APDRP Coverage

jazzydoeSoftware and s/w Development

Oct 30, 2013 (3 years and 10 months ago)

98 views

DY.CE/Information Technology

In Collaboration with M/s SPANCO Ltd.

Presentation

On

In PSPCL

……Save Electricity For Prosperity of The Nation…....Waste of Electricity can cut your Income…....Energy Saved is Energy Gener
ate
d…….…Electricity Theft Destroy the Economy of your State….

Powering Punjab, Enriching Lives.

The

Power

Ministry

has

released

Rs

1
,
284
.
24

crore

under

Re
-
structured

Accelerated

Power

Development

and

Reform

Programme

(R
-
APDRP)
.



Out

of

this

Rs

1
,
259
.
24

crore

has

been

sanctioned

as

loan

to

Power

Finance

Corporation

(PFC)

for

disbursal

to

utility

companies

and

Rs

25

crore

as

grant

to

rolling

advance

against

fee

to

the

nodal

agency
.

The

Ministry

has

approved

1
,
283

projects

at

the

cost

of

Rs

4
,
730
.
38

crore

for

22
states
.



The

states

that

have

been

covered

under

the

program

are
:

Andhra

Pradesh,

Bihar,

Chhattisgarh,

Goa,

Gujarat,

Haryana,

Himachal

Pradesh,

Jharkhand,

Karnataka,

Madhya

Pradesh,

Maharashtra,

Punjab,

Rajasthan,

Sikkim,

Tamil

Nadu,

Uttrakhand
,

Uttar

Pradesh,

West

Bengal,

Assam,

Kerala,

Tripura

and

Jammu

&

Kashmir

are

however

yet

to

get

the

disbursal

amount

from

the

Ministry
.



The

Re
-
structured

APDRP

for

11
th

Plan

was

approved

in

2008

as

a

central

sector

scheme

which

focuses

on

actual,

demonstrable

performance

in

terms

of

AT&C

(administrative,

technical

and

commercial)

loss

reduction
.

The

programme

size

for

R
-
APDRP

is

Rs

51
,
577

crore

R
-
APDRP

INFRASTRUCTURE

r
-
ApdRp

R
-
APDRP COVERAGE

GoI

Nodal Agency
/
PFC
(Power Finance
Corporation)

Consultants/
Vendors

Process
Consultants

PSPCL

IT Consultants

IT
Implementation

Agency

SCADA /DMS
Consultants

SCADA

Implementation
Agency


Steering Committee (
GoI,MoP,PFC

Representative Utility)


Third Party Independent
Evaluating Agency

RELATIONSHIP DIAGRAM

GoI

IT Advisor to
set up WEB
Portal

Nodal Agencies
(PFC/SPV)

Process
Consultants

PSPCL

Third Party
Independent
Evaluation
Agencies(TPIEAS)

M/S WEBCOS

M/s
SPANCO LTD
.
IT
Implementation
Agency (Part
-
A
)

M/S WIPRO LTD.

IT
Consultants (Part
-
A
)

Critical
Success Factors

IT
I
mplementation

Senior
Management
Commitment
&
Involvement

Readiness to
Change

Training

Project
Management

Able
Implementa
tion

Partner

Sound

Methodology

Project
review &
Audit

Infrastructure

Availability

End
-
User
Empowerment

Scope
Management

Communi
-
cations

R
-
APDRP Coverage: Part A


Establishment of Baseline data




Consumer Indexing



GIS (Geographical Information System ) mapping


DT,HT Consumers , Feeders of S/
Stns.

, Metering (AMR)

IT Enabling of Distribution System


Data Centre + DR Site (Hardware, Network, Software, FMS, GIS based CI etc)


IT enabled Metering, Billing & Collection


Energy Accounting & Auditing


MIS (Management Information System)


Automatic Meter Reading (AMR)


Asset mapping of the entire Distribution Network


IT enabled Customer Care Centers


SCADA

&

DMS

(supervisory control and data acquisition &
Distr.Mgmt.system
)

Project Management , Training and
FMS

(
Facility Mgmt. Services
)
.


*

R
-
Apdrp

coverage part
-
c

Focus on enhancing skills of utility personnel at various levels

Training of staff under various training themes

Capacity building of utility staff to upgrade

IT skills and understand the latest tools and techniques

Miscellaneous Activities like Workshops, Conferences, Project Specific Evaluation etc.

Services of Nodal Agency, Verification of Base Line Data,

Advisors and Project

Management Consultants.

Pilot projects for adopting new innovations

Standardization of specifications of equipments and

Contractual documents

Preparaions

at
utility level
-

pSPCL

Key ASPECTS OF Preparation

SCOPE OF WORK



Meter

Data Acquisition
System (MDAS)

Supply

of

necessary

hardware,

software

and

communication

equipment

in

the

Substations,

DTs

and

select

consumers

in

the

towns

for

the

purpose

of

centralized

meter

data

logging
.

GIS
SYSTEM SOFTWARE & MAPS


Supply

,

installation,

commissioning

and

maintenance

of

GIS

software

and

latest

satellites

imagery

maps

for

GIS

based

customer

indexing

and

asset

mapping

in

the

specified

town
.

The

successful

bidder

shall

provide

the

maps

along

with

the

certificate

and

rights

in

favour

of

owner

from

the

source

that

these

are

the

latest

as

on

date

of

purchase

which

should

be

later

to

award

date,

.

The

bidder

should

specify

clearly

the

licensed

software

he

purpose

to

use

for

the

package
.

(Geographic information system)



40
seater

,(expandable),
CCC to attend call
-
in
-
complaints of
consumers from all
over Punjab


To

work

round

the

clock



single

telephone

number

with

multiple

channels
.

Consumer

Care

Centres

to

be

set

up

in

47

Towns

with

Divisions

as

Head

Quarter
.


CCC

(Consumer

Care

Centres

)

shall

take

care

of

walk
-
in
-
complaints

CCC/NCCC

to

be

controlled

by

consumer

relation

management

system

software

To

automatically

generate

reports

under

supply

code

and

send

to

concerned

offices
.

Existing

Electrical

Call

Centre

and

Consumer

Care

Centre

will

be

merged

into

the

coming

CCCC

CENTRALISED
CUSTOMER
CARE CENTRE LUDHIANA



DISASTER RECOVERY CENTRE AT
JALANDHAR

Replica of Data Centre to be set at Patiala.



SAP Overall
Inegrated

System

Meter Reading for HT
Consumers & DT
\

Meters recorded and
shared



All Legacy Systems
data such as
collection details and
bill details are
shared.



All consumers Billing,
metering details
shared and
complaints taken



All consumers and
Network related
information shared
and updated.


Centralized data base for consumers, Networking and transactional information . All business processes will be run in this sy
ste
m.



NSP Scope

The

scope

of

work

covers

supply

,

installation

,

commissioning

and

maintenance

of

LAN

at

data

center,

Customer

Care

Centers,

Sub

Division

,

Division

,Circle

,

Head

Quarter

and

any

other

office

of

the

utitlity

as

per

their

requirement

along

with

creation

of

VPN/MPLS

based

WAN

solution

.

The

vendor

shall

also

provide

the

necessary

drawings

and

plan

for

installation

,

sizing

cabling

and

connectivity

and

the

bill

of

material

for

the

networking

of

all

the

locations

specified

herein
.

Network Service Provider

INTEGRATION of it Infrastructure


INTEGRATION OF THE ENTIRE

IT Infrastructure under the scope of this document as well as legacy systems , if any.

Setup the
Local Area Network (LAN)
&
Wide Area Network(WAN)

Data

servers


All

the

data

relating

to

consumers

,

Distribution

Offices,

Stores

,

T/F,

S/
Stns
.
,

LT

Consumers

will

be

available

through

servers

installed

in

Data

Centre
.


VPN

connectivity


All

the

Offices

under

R
-
APDRP

&

Non
-
R
-
Apdrp

areas

to

connected

through

VPN

connectivity
.




Creation of necessary IT Infrastructure including LAN for identified Subdivision , Division
,Circle ,Headquarter offices ,Data centre , DR Centre and customer care centers.

Supply

,

installation,

commissioning

and

maintenance

of

all

necessary

hardware

and

networking

equipments

and

its

connectivity

as

specified

in

the

detailed

Specification
.

As

a

part

of

the

project

.

The

vender

should

procure

the

required

hardware

and

build

the

infrastructure

as

detailed

in

the

Specifications

.

The

vendor

shall

take

the

responsibility

to

install

the

servers,

switches

,

routers

,backup

and

tape

devices
,

Workstation

PCs

,

and

other

necessary

hardware/software

at

the

sites

defined

in

bid

proposal

sheet
.


The

vendor

shall

give

the

time

frame

for

procuring

and

delivering

all

necessary

hardware
.

Though

the

scope

covers

establishment

of

a

common

data

center

&

DR

center

along

with

associated

hardware

and

software

for

selected

towns

.

the

bidder

shall

design

and

provide

the

hardware

at

data

center

&

Disaster

Recovery

Center

with

suitable

expandability

for

covering

the

entire

utility

area

at

a

later

date

(Utility

will

specify

the

total

consumer

and

asset

base)

along

with


7
.
5
%

per

annum

growth

in

consumer

and

asset

base

for

next

five

years
.



The

scope

of

work

covers

supply,

installation

,

commissioning

and

maintenance

of

LAN

at

Data

Center

,Customer

Care

Centers

,

Sub

divisions

,Circles

,Head

Quarter

and

any

other

office

of

the

Utility

as

per

their

requirement

along

with

creation

of

VPN/MPLS

based

WAN

solution
.


The

vendor

shall

also

provide

the

necessary

drawings

and

plan

for

installation,

sizing

,

cabling

and

connectivity

and

the

bill

of

material

for

the

networking

of

all

the

locations

specified

herein
.




DGPS Survey & Consumer
Indexing Work

Carrying out the
necessary DGPS survey
and creation of GIS based
customer indexing

& asset database as
specified in detailed
specification.

DGPS (
Differential Global Positioning System
)

Softwares

Supply installation and commissioning of Operating Systems at Server/Desktops, Database and application software along
with source code (only for customized software solutions) and functionalities covering application modules like Energy Audit,

Data Acquisition, New Connection, Disconnection, Vigilance and Dismantling, MIS, GIS network management module with
electrical network diagram of system further as detailed in the bid proposal sheet. The vendor has to supply necessary
software solution for metering, billing collection (MBC) if the same is not available with the utility. In case the required
MBC

&
other standalone software solutions are already in place, the vendor has to integrate the same with the offered solution
including design and supply of necessary middleware.




Moreover the vendor has to link the GIS based customer index created by him to the existing
customers etc. The bidder shall quote the unit price for additional licenses for database,
standard application software, antivirus solution etc. (whether per processor license basis or
per user license basis) for meeting the future requirement of utility.

Softwares



Web Portal of Utility

Automatic
Token
Dispenser
Machine

Supply,

installation

and

commissioning

of

automatic

token

dispenser

machine

and

intelligent

display

management

at

customer

care

centers
.

Touch Panel
Based KIOSK

Supply,

installation

and

commissioning

of

Touch

Panel

based

KIOSK

for

furnishing

information

on

billing,

payment,

duplicate

bills

etc
.

at

customer

care

centers
.


Cash/
cheque

Collection Kiosk

Supply,

instillation

and

commissioning

of

cash/
cheque

collection

Kiosk

for

automatically

accepting

cash

and

cheque

payments

from

customers,

to

be

installed

at

utility

offices,

customer

care

centers

and

any

other

location

as

per

the

requirement
.


Cheque

Reader&
Bar Code Reader

Supply

and

installation

Point

of

the

State

(
PoS
)

terminate

along

with

suitable

cheque

reader

and

bar

code

reader

and

application

software

to

be

deployed

at

payment

collection

centers
.


The scope includes the Development of Web portal of utility for real time customer services.



Facility
Management Services For
IT

Facility management
services for IT
infrastructure created
for a period of 5 years

&

Annual Management
Contract of 2 years
after expiry period of
3 years by the
consortium partner /
equipment supplier.


Bidders Offers for Project Components

Bidders
Offers for
Project
Components

The

bidder

shall

submit

offers

for

project

components

on

turn

key

basis

for

continuous

and

successful

operation

of

the

offered

solution
.

Enable
Required
Interfaces

The

proposed

solution

must

efficiently

enable

all

required

interfaces

and

integration,

including

integration

with

the

existing

software

as

detailed

in

existing

IT

infras

functional requirements


The proposed solution must also consider the
following overarching functional requirements,
analytical tools and capabilities
:

Workflow
Management
.

Document
Management

Data
Warehousing..

Business
intelligence.


Integration
Middleware.

RTO & RPO Based Disaster Recovery Center

The

vendor

has

to

establish

a

disaster

recovery

center

at

the

location

specified

by

utility

which

should

operate

based

on

RTO

&

RPO

defined

in

detailed

technical

specification
.





SYSTEM DESIGN AND ENGINEERING

The

bidder

shall

be

responsible

for

detailed

design

and

engineering

of

overall

system,

sub
-
systems,

elements,

system

facilities,

equipments,

services,

including

systems

application

software

etc
.

It

shall

include

proper

definition

and

execution

of

all

interfaces

with

systems,

equipment,

material

and

services

of

Owner

for

proper

and

correct

design,

performance

and

operation

of

the

project
.

Bidder

shall

provide

complete

engineering

data,

drawing,

reports,

manuals

and

service

offered

etc
.

for

Owner’s

review,

approval

and

records
.




SCADA / DMS



Jalandhar

Amritsar & Ludhiana
cities are to be covered under
SCADA.


M/s North Delhi Power
Ltd(NDPL), New Delhi selected
as consultant for DMS/SCADA
implementation
-
appointed.


DPRs prepared by consultant
i
-
e
M
/
s

North Delhi Power Limited.
(
NDPL
),
New Delhi.

(Supervisory Control & Data Acquisition / Distribution Management System
)

STATUS OF IMPLEMENTATION…



Non R
-
APDRP Sites


Zones


Ci rcl es

Sub Di vi sional
Offi ces.

Other Offi ces

Total

Patiala

4

77

7

84

Jalandhar

5

95

13

108

Ludhiana

1

21

4

25

Bathinda

4

68

5

75

Amritsar

3

66

8

74

Total

17

327

37

366

34


Punjab R
-
APDRP




Snapshot of Current Status.




Detailed Status of Project Tracks.




Key Issues & Challenges

Agenda

35


Build Phase Completed


Integration testing Phase
-
1 Completed


Functional testing by PSPCL Process owners will start from 18
th

July
2011


Data Migration Process in
-
progress (60 % completed for pilot)

SAP

Systems ,Applications and Products in data
processing


Software customization and development is completed


Integration testing Phase
-
1 Completed


Material received at warehouse for field work


Modem Installation work for Pilot will start in this week (Substation
and HT meters)

MDAS

Meter Data Acquisition Solutions


Software customization and development is completed


Integration testing Phase
-
1 Completed


Survey in Pilot and 3 more Town is completed . Work is in progress in
16 towns.


Engagement of more vendors for entire Punjab is in Progress

GIS

Geographical Information System



Designs & Site Survey Completed


Ordering of bought
-
out items Completed


Networking equipment and passive cabling completed at DC


Work at SDO & Other office is in progress


Servers and Storage installation is in progress

NSP

Neighborhood Stabilization
Programme


36

Sl.
No.

Activity

Status

Completion Date /
Target Closure Date

1

Authorization & Initiation of SAP License
Procurement

COMPLETED

30
th

June 2010

2

SAP Utilities Solution Introductory Workshop

COMPLETED

1
st

July 2010

3

Development Environment Set
-
Up in
Spanco’s

Office

-

Hardware servers installed

-

OS configured

-

SAP Licenses Acquired

-

SAP Configuration Done & Access provided to
PSPCL

COMPLETED

6
th

Aug 2010

4

As
-
Is Study Workshops

COMPLETED

12
th

-

27
th

Aug ‘10

5

Kick Off workshop for “To Be Phase”

COMPLETED

9
th

Sep 2010

6

As
-
Is Sign
-
Off

COMPLETED

17
th

Sep 2010

7

SAP CRM Configuration done at Development
environment and access given to PSPCL

COMPLETED

29
th

Sep 2010

8

To
-
Be Design and Workshops

COMPLETED

25
th

Oct to 29
th

Oct

Note
: Scope for SAP covers the following modules


MBC, NC/DC, Energy Audit, Asset & Maintenance Management

Sl.
No.

Activity

Status

Completion Date /
Target Closure
Date

9

Incorporation of feedbacks received during To
-
Be workshops and submission of the updated
documents

COMPLETED

8
th

Nov 2010

10

To
-
Be Design Sign Off

COMPLETED

3
rd

Dec 2010

11

Build Phase

COMPLETED

15
th

June 2011

12

Integration Testing


Phase
-
1

COMPLETED

30
th

June 2011

13

Integration Testing


Phase
-
2

Will start with
PSPCL Process
Owners

08th Aug, 2011

14

Data Migration

IN PROGRESS

Pending

15

Training & Change Management

To Start from
25
th

July 2011

05
th

August
(Patiala)

16

User Acceptance Testing

Not Started

30
th

August 2011

17

System Go Live (Pilot)

15
th

Sep., 2011

Note
:
Scope for SAP covers the following modules


MBC,
NC/DC, WSS, MIS,
Energy Audit, Asset & Maintenance Management

S.
N
o.

Module
Name

%

Completion
with target
Go Live

%
Compl
etion
stand
alone

Interdependen
cy on External
System

Remarks

1.

Metering

75%

95%

MDAS for AMR

Completion of Integration testing
phase 2 will mark 100
% completion

2.

Billing

70%

90%

-
do
-

3.

Collection

80%

95%

EasyBill
,
Suvidha
,

KIOSK, Bill Desk

Collection

module can run
independently i.e. no dependency on
external system but periodic inputs
required from external payment
system for synchronization.

4.

New
Connection

75%

90%

Completion of Integration testing
phase 2 will mark 100
% completion

5.

Disconnection
& Dismantling

75%

90%

-
do
-

6.

Energy Audit

80%

90%

MDAS, GIS/NA

-
do
-

7.

Asset

Mgmt.

80%

90%

GIS

-
do
-

8.

Maintenance
Mgmt

80%

95%

GIS

-
do
-

39

40

S.N
o.

Module
Name

%

Completion
with target
Go Live

%
Completion
standalone

Interdep
endency
on
External
System

Remarks

9.

MIS

50%

50%

On all SAP
modules

This will be completed with IT 2

10

WSS

85%

85%

On all SAP
modules

Fine tuning is being done.

11.

Identity and
Access

Management
System

75%

75%

Completion of Integration testing phase 2
will mark 100
% completion

12

Integration
Middleware

70%

70%

One round of interface testing completed..

EasyBill

not participating in integration
though repeated follow up done.

13

Data
Migration

60%

60%

DOEACC,
GIS,

PSPCL

2 Mock run have been done. MOCK
3
pending due to dependency on DOEACC
data. DOEACC is restricting the frequency
of giving the data.
Spanco

has already
provided the frequency till Go Live.

41

Training Strategy

42

Sl.
No.

Activity

Status

Completion Date / Target Closure
Date

1

Site Survey Format Approved

COMPLETED

9
th

July Formally 23
rd

July 2010

2

Site Survey In Project Area Patiala

COMPLETED

27
th

August 2010

3

Site Survey at Patiala &
Jalandhar

Town

COMPLETED

10
th

September 2010

4

LLD & HLD of CCC (Final document
submitted on 22
nd

Oct)

COMPLETED

Approved on 4
th

Dec 2010. Additional
details submitted and accepted on 11
th

Feb 2011.

5

DC/DR related (Design) (Final
document submitted on 22
nd

Oct)

COMPLETED

Approved on 4
th

Dec 2010. Additional
details submitted and accepted on 11
th

Feb 2011.

6

LLD & HLD for SDO & Other Offices
(Final document submitted on 22
nd

Oct)

COMPLETED

Approved on 4
th

Dec 2010. Additional
details submitted and accepted on 11
th

Feb 2011.

7

Equipment details related to DC/DR
design submitted to PSPCL
(dimension/weight/load etc.)

COMPLETED

16
th

August 2010

43

Sl.
No.

Activity

Status

Completion Date / Target
Closure Date

8

Site Survey Report of Patiala (Pilot
Town) and
Jallandhar

COMPLETED

1
st

September 2010

9

Site Survey


Completed in 47 R
-
APDRP Towns and Submitted to
PSPCL (signed copies by nodal
officers)

COMPLETED

Soft copies submitted on 15
th

Dec
2010

Hard copies submitted on 31
st

Jan
2011

10

Site Survey


Completed in 17 Non R
-
APDRP circles and Sign off WIP

COMPLETED

Sign off WIP

11

Installation of Network Racks at DC
and DR

COMPLETED

25
th

March at DC and 7
th

April 2011
at DR

12

Installation of IBM server Racks

COMPLETED

20
th

June 2011

13

Passive cabling at DC & DR

COMPLETED

20
th

June 2011

14

Mounting & Installation of IBM Servers
at DC

COMPLETED

18
th

July 2011

15

Connectivity of Data Center with
Spanco

Patiala (Application Servers)

COMPLETED

29 June 2011

44

Sl.
No.

Activity

Status

Completion Date / Target
Closure Date

16

Installation of wall mount Racks
at SDO and other offices (Pilot)

In Progress

10
th

Aug, 2011

17

Passive Cabling work at SDO and
Other offices (Pilot)

In Progress

10
th

Oct., 2011

18

Installation of Operating System
on servers at DC

Will initiate after server
mounting

10
th

Aug.,2011

19

Installation of wall mount Racks
at SDO and other offices (Rest of
Punjab)

Will initiate after Patiala
completion with multiple
teams

30
th

Oct., 2011

20

Passive Cabling work at SDO and
Other offices (Rest of Punjab)


Will initiate after Patiala
completion with multiple
teams

30
th

November 2011


45


Satellite Imagery

Received for all towns.


Coding, Survey Formats,
Data Model & Application
Development

Coding,

Survey

Formats

Finalized

and

Approved



Completed

1
st

Oct,
2010

Draft

of

data

model

and

Application

for

PDA/Rover



Completed

1
st

Nov,
2010

Design

of

GIS

Application

and

Network

Analysis



Completed

3
rd

Nov

,
2010

Application

Development



Build

Phase

Completed

Integration

Testing

with

SAP



Phase

-
1

Completed

Pole

Painting

format

finalization



Completed

Pole

Painting



Will

start

after

approval

of

Network

Survey

from

PSPCL

GIS Project Track

Activities
Completed/Ongoing

GIS
Project Track

Activities
Completed/Ongoing

(Electrical Network Survey)


47

GIS Project Track


Activities Completed/Ongoing

Base

Map

Creation
:


Completed : 40 Towns

In Progress: 07 Towns

GCP

Collection


Completed : 47 Towns


GCP
marking

Completed 100% (47 Towns)


GCP
(General Control Point)
Collection & Base Maps

48

Pilot Town
(Patiala


6
Substations)

Network
Survey :
Completed

Consumer
Survey :
Completed

Amritsar:

Network
survey has
been
completed
for 8
substations
out of 17

Bathinda:

Network
survey has
been
completed
for 5 s/s out
of 9 s/s

Jallandhar:



Network survey
has been
completed for 8
s/s out of 15 s/s

Consumer Survey
started and
covered 20000
consumers

Ludhiana:

Network
survey
has been
completed
for 3 s/s
out of 28
s/s

Team
mobilization
and work
started

Mohali
: Network
(Completed),
Consumers (50 %
Completed)

Rajpura
: Completed

Sirhind
: Complete

Dhuri
: Network
(100% complete

Dhuri
: Network
(100% complete)

Nakodar
:
Network (100%
complete)

Gurdaspur
:
Completed

Asset & Consumer Survey:

GIS Project Track


Activities Completed/Ongoing

49

Tarn
Taran

MalerKotla

Kharar

Pathankot


Batala

Barnala

Amritsar

Network In Progress

Asset & Consumer Survey:

GIS Project Track


Activities Completed/Ongoing

Nakodar

Patti

Gurdaspur

Gidderbaha

Nawanshahr

Mansa

Jalandhar

Cantt

GobindGarh

Mohali

Dhuri

Network Completed

50

Manpower Deployment

GIS Project Track


Activities Completed/Ongoing

Sn

Town

On field


Back end


1


Patiala

18

50

2

Bathinda


9

10

3

Jallandhar

45

20

4

Ludhiana

107

15

5

Rajpura

2

10

6

Dhuri


6

2

7

Mohali


32

10

8

Gurdaspur

21

5

9

Sirhind

2

2

10

Barnala

5

2

11

Gidderbaha

9

2

12

Gobindgarh

42

13

Pathankot

5

2

14

NawanShahr

5

2

Total

308

132

IESL has started mobilization and agreed to add 500 resources in 30
-
40 days in various towns

51

Sl.
No.

Activity

Status

Completion Date /
Target Closure
Date

1

Procurement of Satellite Imageries
through NRSC

COMPLETED

Received Images of all 47
Towns

Imagery received in
lots over Sep and Oct.
Images of the pending
2 towns also received

2

GIS Application Development Partner
(
Rolta
) Finalized

COMPLETED

8
th

July 2010

3

Detailed Plan/Approach for GIS
Implementation submitted to PSPCL

COMPLETED

24
th

August 2010

4

GIS Solution Demo/Proof
-
of
-
Concept in
PSPCL Patiala (
Note
: Demonstrated GIS
Software, network mapping, indexing,
DGPS equipment etc.)

COMPLETED

30
th

August 2010

5

GIS Application Development Team
Mobilization

COMPLETED

31
st

August 2010

6

Coding, Survey Formats Finalized and
Approved

COMPLETED

1
st

October 2010

7

Base Map Creation of Patiala

COMPLETED

20
th

October 2010

GIS Project Track


Activities Completed/Ongoing

52

Sl.
No.

Activity

Status

Completion
Date / Target
Closure Date

8

Detailed Methodology for GIS Implementation
Submitted to PSPCL

COMPLETED

3
rd

November 2010

9

Submission of SRS and design document of GIS
and Network analysis

COMPLETED

3
rd

November 2010

10

GCP Collection of Patiala , Ludhiana,
Bhatinda
,
Jalandhar
,
Khanna

and
Jagran
.

COMPLETED

4
th

November 2010

11

Network Analysis Software Procurement

COMPLETED

8
th

October 2010

12

Field Survey (Assets attributes collection &
Consumer survey) Completion for Patiala town

COMPLETED

30
th

June 2011

13

Application Customization/Development

IN PROGRESS

GIS Application


97% Completed

Network Analysis


95%
Completed

15
th

July 2011

14

Integration Testing

Phase


I Completed

Phase


II (
Will start with PSPCL
Process Owners
)

30
th

July 2011

GIS Project Track


Activities Completed/Ongoing

53

Sl.
No.

Activity

Status

Completion Date /
Target Closure Date

1

Proof
-
of
-
Concept and Submission of
Report

COMPLETED

14
th

June 2010

2

Finalization of agreement with MDAS
Solution Partner

COMPLETED

26
th

July 2010

2

MDAS Development Servers
Installation in Spanco’s Patiala Office

COMPLETED

6
th

August 2010

3

Procurement of APIs of Meters from
PSPCL

COMPLETED

26
th

August 2010

4

Survey of Substations (Pilot Town


Patiala)

COMPLETED

26
th

August 2010

5

Survey of HT Consumers (Pilot Town


Patiala)

COMPLETED

15
th

September 2010

6

Sample survey of DTs (Pilot Town


Patiala)

COMPLETED

30 December 2010

GIS Project Track


Activities Completed/Ongoing

54

Sl.
No.

Activity

Status

Completion Date / Target
Closure Date

7

MDAS Software Installation in
Development
Env
.

COMPLETED

6
th

September 2010

8

As
-

Is and To
-

Be design documents

COMPLETED

15
th

November 2010

9

Pre


Dispatch Inspection

COMPLETED

1
st

Lot on 18
th

Dec, 10

2
nd

Lot on 30
th

January

3
rd

Lot on 4
th

March
2011

10

Software Customization and
Development

Integrator = 98%

SOMAC = Completed

15
th

July 2011

11

Integration Testing with SAP

Phase


I Completed

15
th

June 2011

12

Installation of Modems on Substation and
HT meters at Pilot town (Patiala)

SIMs are available

Activation will happen in
this week

31
st

July 2011

13

Installation of Modems on DT meters

Can be done after meter
installation from PSPCL
side

31
st

July 2011


GIS Project Track


Activities Completed/Ongoing

55


KEY ISSUES
&


CHALLENGES

56



Lack of DT Metering in project areas is an
acknowledged issue for implementation of the
Meter Data Acquisition Solution.


80% of ordered modems are required to be installed on
DTs


which are currently unmetered.

Issue



The delay can impact the overall implementation
schedule.


Impact



PSPCL initiated the process for installing
Dt

Meters Cubical through out sourcing for Pilot
Patiala and committed to complete by 31th Oct.
2011.

Current
Status

Issue #1


Lack of DT Metering

KEY ISSUES &

CHALLENGES

57


Approximately 90% of sites surveyed by
Spanco

lack
earthing


Earthing

is not in the scope of the ITIA as per the RFP, but is a
prerequisite for the sites



Network components could not be commissioned without
proper earthing at site



PSPCL started earthing at Patiala at completed and is in
progress in
Sirhind

&
Rajpura

towns . Committed to complete
all the towns by 31
st

Oct,2011.


Issue #2


Lack of Earthing at Sites

KEY ISSUES &

CHALLENGES

58


Several

site

offices

lack

the

electrical

cabling

required

for

equipment

such

as

switches,

routers,

UPS

etc
.


15
A

sockets

are

not

available

and

in

several

instances

fresh

cabling

needs

to

be

done

from

the

mains
.

Issue


Will delay the readiness of the sites for installation of
equipment.


Impact


All

the

Er
-
In
-
Chiefs

/Chief

Engineers

have

been

requested

to

provide

the

15
A

Sockets

and

other

Earthing

Cables

where

ever

required

,

during

a

Meeting

on

3
rd

Aug,
2011

chaired

by

Director

/Distribution

at

TTI,

Patiala


Current
Status

Issue #3


Lack of adequate Electrical/Power Cabling at Sites

KEY ISSUES &

CHALLENGES

59


DOEACC is not very co
-
operative in sharing data
at required frequency and in formats by SPANCO


Data quality is also not satisfactory

Issue


The delay can impact the overall implementation
schedule.


Impact


SPANCO shared all pre
-
defined formats with PSPCL


PSPCL Commercial Directorate needs to provide data to
SPANCO.


Current
Status

Issue #4


Data Migration from DOEACC

KEY ISSUES &

CHALLENGES

BENEFITS OF THE R
-
APDRP

UNDER R
-
APDRP (PART
-
A) FOR IT IMPLEMENTATION

NODAL OFFICERS


CENTRAL LEVEL
NODAL OFFICERS
(
Dy

CE/INFORMATION TECHNOLOGY
)





The

Nodal

officers

shall

be

the

nodal

point

of

interface

between

the

System

Integrator

(M/s

Spanco

Ltd
.
)

along

with

their

partners

(GIS,

Meter

Data

Acquisition,

Network

Bandwidth

&

Network

Service

Provider)

and

the

end

users

of

each

project

area
.

They

shall

also

interact

&

co
-
ordinate

with

the

concerned

field

officers/

officials

of

PSPCL

&

the

Central

project

Office

(SE

/

IT)for

performance

of

the

duties

pertaining

to

the

area

falling

under

their

jurisdiction

during

execution

of

field

work

as

per

ITIA

Work

Order

No
.

361

dated

29
.
4
.
2010

NODAL OFFICERS (APPOINTED BY SE/OPERATION)



The

IT

Implementation

project

under

R
-
APDRP

(Part
-
A)

being

implemented

by

the

office

of

SE/

IT

through

M/s

SPANCO
-

the

ITIA,

has

the

domains

of

Software

Installation

(Application

&

System)

&

Hardware

Installation

(System

&

Network)
.
The

design

&

Development

work

of

both

the

domains

is

being

carried

out

at

the

central

level

for

which

specific

project

teams

have

been

formed

under

the

overall

supervision

of

SE/

IT
.

However

for

the

field

level

implementation,

mainly

in

the

domain

of

Hardware

installation

(Network

&

system),

the

services

of

Nodal

Officers

as

appointed

by

various

SEs/

Operation,

shall

be

utilized

by

the

central

project

office

(SE

/

IT)
.


DUTIES OF THE NODAL OFFICERS


UNDER R
-
APDRP (PART
-
A) FOR IT IMPLEMENTATION



Finalizing

the

offices

covered

under

town/

area

DPR

for

IT

Implementation

as

per

RFP/

field

requirement

(Execution

Agency

-

SI)
.




a)

Provision

of

Bandwidth

connectivity

at

the

office

locations

so

identified

(Execution

Agency

-

NSP/

NBSP's/

SI)
.

b)

Provision

of

LAN/

WAN

in

the

offices

(Execution

Agency

-

NSP/

NBSP's)
.

c)

To

extend

supply

to

UPS

being

installed

Ascertaining

the

availability

of

hardware

(PCs,

printers,

UPS

etc
.
)

during

field

survey

of

PSPCL

offices

by

SI/

NSP

(Execution

Agency

-

NSP/

NBSP's)
.



a)

To

Co
-
ordinate

with

all

offices

for

taking

over

the

material

/hardware

being

installed
.


Ascertaining

the

requirement

of

additions/

modifications

in

civil

amenities

including

electronics

earthing

for

the

buildings

housing

IT

equipment

(Execution

Agency



SI/

NSP/

NBSP's)
.


a)

Providing

details

of

Distribution

Transformers,

H
.
T
.

consumers

and

sub

station

feeder

&

the

details

of

meters

(make,

capacity,

voltage

and

current

ratio)

thereon
.

b)

Provision/

Installation

of

meters

by

PSPCL
.

DUTIES OF THE NODAL OFFICERS


UNDER R
-
APDRP (PART
-
A) FOR IT IMPLEMENTATION

Installation

of

Meter

Data

Acquisition

System,

Hardware

at

DTs,

HT

consumers

and

sub

stations

as

required

(Execution

Agency

-

MDASP)
.

a)

To

provide

co
-
operation

to

contractor

for

installation

of

DT

Meter

Cubicles
.

b) To direct DS Offices for proper
resealing of HT consumers after
installation of Modem.

c
) To direct s/
stn.

Staff to
associate in DCWs installation at
sub stations.

GIS

survey

of

existing

and

new

consumers

&

infrastructure/

electrical

assets

and

preparation

of

single

line

diagrams

by

the

SI

(Execution

Agency

-

GISSP)
.

a)

Supervision

of

storage

and

installation/

commissioning

of

Hardware/

Software

at

sub

division

and

other

offices

(Execution

Agency

-

SI)
.

b)

Getting

sign

offs

/

preparing

joint

verification

reports

with

concerned

field

officers

after

installation

and

system

testing

of

equipment

in

various

field

offices
.

c)

Validation

of

data

on

priority,

submitted

by

GIS

vendor
.

Suggesting

names

of

officials

in

various

offices

of

Powercom

for

training

(Execution

Agency

-

SI

&

Partners)
.


THANK YOU !

se
-
it@pspcl.in

Power Saved is Power Generated.