Post Job Free

Resume

Sign in

Senior Consultant - Utilities

Location:
Los Angeles, CA
Posted:
July 02, 2013

Contact this candidate

Original resume on Jobvertise

Resume:

RESUME

PERSONAL DETAILS

* ****: Debsankar Pramanik

* **** ** *****: 08-Feb-1980

* ******* **********: Infosys Limited [working since 26-Jul-2004]

* ******* *********** *** ******: Senior Consultant [since 01-Oct-2011]

5 Overall Experience (as of 01-Jun-2013): 8.8 years

6 Skill-wise Experience (as of 01-Jun-2013): .NET (2.5 yr), QA-testing +

consulting (6.3 yr)

7 Present Location: Glendora, CA, USA

8 Base Location: Bhubaneswar, India

9 Contact Number (USA): 858-***-****

10 Contact Email: abz7m6@r.postjobfree.com;abz7m6@r.postjobfree.com

11 Contact Address: 408 WEST GLADSTONE ST APT 67, GLENDORA, CA, 91740

12 Passport details: E8020859 [Expiry date: 12-Sep-2014]

13 Visa details: H1 Extension for USA Valid till 09-Jun-2014

14 Competencies:

Domain Utilities, specifically Advanced Metering Infrastructure

(AMI), Advanced Meter Reading (AMR), Meter Data

Management System (MDMS) [Utility industry's 2 leading

MDMS applications - a) Itron's Itron Enterprise Edition

[v5.3, 6.0, 7.0], b) Aclara's Energy Vision [v8.8.5.1

HF8 SC9, v8.9.1 HF3 SC4]], Demand Response, Smart Meter

Implementation, HeadEnd [STAR NCC v7.3.9, v7.5.2 - a

Collection System application of Aclara Inc.]

Technical Functional Testing, System Testing, Integration Testing,

UAT Testing, Performance Testing, ASP.NET 3.5, C#.NET,

VB.NET

15 Roles played in Consulting/QA-testing:

. Strong experience in AMI/MDM testing. I have led the offshore QA-

testing team of IEE (Itron Enterprise Edition), a MDM Product of Itron

Inc., one of the leading utilities of USA. I have handled coordination

activities with client and offshore teams and have delivered projects

on time with very high quality [tenure: 2 years].

. I have been onsite to Raleigh, NC, USA for Itron for "Sustaining"

team. My role was testing the critical production defects after

fixing, performance testing for several scenarios reported by customer

etc [tenure: 7 months].

. I have been part of offshore lead and later, test engineer at onsite

to Raleigh, NC, USA for Itron for IEE-SAP Integration Project. I have

tested the interfaces between Itron Enterprise Edition (IEE) and SAP

IS-U [a newer version of its Net weaver IS-U for Utilities] [tenure: 3

months].

. I have been in a testing project working as an offshore module-lead

for testing Silver Spring Network's head-end system, UIQ [UtilityIQ],

used by FPL [Florida Power and Lights]. I was leading the team and my

scope of work involved Requirements gathering, identifying the

relevant transactions, Preparing System Test Script, Interaction with

client and clarifying issues etc., System Testing in Test Environment,

UAT testing, co-coordinating with client with daily status, re-testing

the fixed defects, capturing the test result in the test result

document, uploading in client SharePoint location, updating the

progress/defect tracker etc. [tenure: 4 months].

. I was involved in a testing project working as "MDMS QA Tester" at

onsite to San Diego, CA, USA for SDG&E [San Diego Gas and Electric]

for "MDMS" team. The project was about executing integration testing

the different interfaces, through which the MDM [Meter Data

Management] data, coming from CISCO [Customer information System],

gets stored in MDMS [Meter Data Management System]. As part of

testing, I needed to do detail field-by-field MDMS validation and

ensure that the data is proper in MDMS. If there were any

discrepancies, I raised the corresponding defects. So, the overall

involvement of mine was mostly limited to integration testing,

validation and documentation of the test result validation. I was also

playing the onsite coordinator role leading a team of 7 people [4 at

onsite + 3 at offshore] [tenure: 22 months].

. I am presently involved in Advanced Meter project working as "Systems

Analyst" in Sys Ops - Software (HE and MDMS Application Team) at

onsite to Los Angeles, CA, USA for SoCalGas (Southern California Gas

Company). The project is about implementing Smart Meter rollout in

SoCalGas, both in Collection System and MDMS perspective. I have been

involved in Functional (System) Testing [Test Case Preparation +

Execution + Defect Management] and Implementation of Aclara HeadEnd

and MDMS systems, 'End-to-End' Integration Test Case Preparation and

Execution, maintenance of custom interfaces from HE/MDMS to SCG's

legacy system [CIS, MyAccount, EnergyPrism], Liaison with HE/MDMS end

users for troubleshooting and issue resolution for all production

issues. Presently, I am working for the 2 upcoming Releases:

o Release F2 [go-live on 07/31/2013 - Enhancement of HeadEnd and

MDMS Applications] - identifying the scope, identifying the

deferred defects of the previous releases (A3 and C1), gathering

the requirements, doing Requirement Analysis and documenting in

DRI (Detailed Requirement Inventory) document, Preparing Test

Outline + Test Case document, Executing System Test Cases

through HPQC, Documenting System Test Results, Defect Triage

through HPQC, Test Execution Reporting;

o Release F3 [go-live on 09/26/2013 - Extracting meter usage

information from MDMS by Aclara's Consumer Engagement (CE) for

calculating alerts for registered customer] - Preparing Test

Outline + Test Case document, Executing System Test Cases

through HPQC, documenting System Test Results, MDMS Support for

Release F3 team for String Testing (May), Integration Testing

(June-July), Defect Triage through HPQC, Test Execution

Reporting

[Tenure: Jan 2012 till now].

1. Advanced Meter:

Project Advanced Meter

Name

Client SoCalGas (Southern California Gas Company), a

subsidiary of Sempra Energy Inc.

Description of the project

The project is about implementing Smart Meter rollout in

SoCalGas, both in Collection System and MDMS perspective. To

enhance control over natural gas consumption and cost, from

late 2012 - 2017, SCG has started the process of upgrading 6

million gas meters with wireless communication devices to

automate recording and transmitting of gas usage information

to the customer service and billing center.

Role Systems Analyst in Advanced Meter Systems Operation

- Software (HE and MDMS Application Team),

Responsibi Requirements Analysis, coming up with DRI(Detailed

lity Requirement Inventory) document

Smoke + Sanity Testing of Aclara's HE and MDMS

application, for each release, and each new

version, in different environments (DEV + INT + QA)

Creation of all Rollout/Migration documentation

Preparing Test Outline + Test Case document

Executing System Test Cases through HPQC

Documenting System Test Results

Defect Triage through HPQC,

Implementation of Aclara HeadEnd and MDMS systems

Maintenance of custom interfaces from HE/MDMS to

SCG's legacy system

'End-to-End' Integration Test Case Preparation and

Execution

Implementation Readiness

Deployment (Roll-out) Plan

Storm Support Plan

PAC (Production Acceptance Criteria) document for

support turn over

Production Support - Liaison with HE/MDMS end users

for troubleshooting and issue resolution for all

production issues

Duration From: January 2012 To: Till Date

Software Aclara's STAR NCC v7.3.9, v7.5.2 (HeadEnd),

Aclara's Energy Vision v 8.8.5.1, v 8.9.1 HF3 SC4

(MDMS), HPQC, TOAD

2. MDMS Integration Testing:

Project MDMS Integration Testing

Name

Client SDG&E [San Diego Gas and Electric] a subsidiary of

Sempra Energy Inc.

Description of the project

The project is about executing integration testing the

different interfaces, through which the MDM [Meter Data

Management] data, coming from CISCO [Customer information

System], gets stored in MDMS [Meter Data Management System].

Apart from testing, we need to do detail field-by-field MDMS

validation and ensure that the data is proper in MDMS. If

there are any discrepancies, we raise the corresponding

defects, to keep a track of it. So, the overall involvement of

the team is mostly limited to integration testing, validation

and documentation of the test result validation.

Role MDMS QA Tester + Consultant

Responsibi Integration Testing

lity Validation

Preparing validation Test Result document

Interaction with client and other stakeholder

[Itron] and clarifying issues etc.

All Documentation work related to the testing

process.

Duration From: March 2010 To: Dec 2011

Software IEE (A MDM product of Itron)

3. UIQ Functional Testing:

Project UIQ Functional Testing

Name

Client FPL [Florida Power and Lights]

Description of the project

The project aims to prepare the system test script for the

related end-to-end transactions involving CIS [Customer

Information System], UIQ [Utility IQ], IEE [Itron Enterprise

Edition], and CALLS [Call Center], FPL.com. UtilityIQ is an

Advanced Metering and Network Management Application used to

read, manage, store, export utility usage data from

electric/gas/water meters, and other integrated devices.

Role Test-lead

Responsibi Requirements gathering

lity Identifying the relevant transactions

Preparing System Test Script

Interaction with client and clarifying issues etc.

System Testing

UAT Testing

Configuration Controller (CC)

Duration From: November 2009 To: Feb 2010

Hardware

Software IEE, UIQ, CIS

4. IEE - SAP Integration Project

Project IEE - SAP Integration Project

Name

Client Itron Inc.

Description of the project

The project aims to develop the interface components to

integrate SAP and IEE MDM systems. There is no existing

interface between Itron Enterprise Edition (IEE) and SAP IS-U.

Role Developer + Test-lead + Onsite-Coordinator

Responsibil Requirements gathering

ity Analysis

Preparing Unit Test Plan

Unit Test Plan Review and Unit Test Plan Rework

Unit Testing

Preparing Integration Test Script

Integration Testing

Configuration Controller (CC)

Coordinating with SAP team, Itron and offshore

team to resolve issues

Duration From: January 2009 To: Mar 2009

Software .NET framework 3.5, C#.NET, Microsoft Visual

Studio 2008, Oracle 10G Release2, SOAP UI tool

5. Itron Enterprise Edition(IEE) Sustaining Work

Project Itron Enterprise Edition(IEE) Sustaining Work

Name

Client Itron Inc.

Description of the project

This project aims at fixing the existing production defects

that went through for various IEE [Itron Enterprise Edition, a

MDM product of Itron] product versions, testing after fixing,

performance testing for several scenarios reported by customer

and delivering the defects fixes through HotFix [HF] to the

Itron clients.

Role Developer + Tester

Responsibi Requirements gathering

lity Analysis

Coding + self-testing

Testing with HF installer in Testing machine

Updating Clear Quest [Defect tracking tool of

Itron]

Duration From: May 2008 To: December 2008

Software .NET framework 1.1, .NET framework 2.0, NET

framework 3.0, C#.NET, Oracle10G Release2, SQL

Server 2005, TOAD, Microsoft Visual Studio 2005

6. Itron Enterprise Edition(IEE) QA-testing

Project Itron Enterprise Edition(IEE) QA-testing

Name

Client Itron Inc.

Description of the project

This project aims at functional testing of several modules of

IEE in a new release using both SQL server 2005 and Oracle.

During the testing, whatever defects that are detected, are

logged in Clear Quest with proper description. Along with

this, the testing of the defects [CQ] is also done.

Role Offshore "QA-testing" Module-lead

Responsibi Preparing Functional Test Script with estimated

lity effort

Functional Test Script Review and Functional Test

Script Rework

Functional Test Execution + Defect Management in

Clear Quest [Defect tracking tool of Itron]

Duration From: August 2007 To: April 2008

Software .NET framework 1.1, .NET framework 2.0, NET

framework 3.0, C#.NET, Oracle10G Release2, SQL

Server 2005, TOAD, Microsoft Visual Studio 2005



Contact this candidate