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