Project Test

Avisek Sen

Email: **********@*****.**.**, Phone: +91-983*******

Have a total IT Testing Experience of 4 years and 8 months. Have worked in both Waterfall and Scrum (or sprint) based software delivery models. Have worked in wide variety of industry domains.

History of Employment:

Organization

Tenure of work

Designation

Domains worked on

Cognizant Technology Solutions

From 30/12/2010 till date

Consultant - CRM

Insurance

Life Science

Pharmacy Business

Management(PBM)

Healthcare

MDM Tool Test experience :

IBM Infosphere MDM

Informatica MDM

Summary of Experience:

ETL & MDM Testing : A large Life Science organization, USA

oWorked as Sr. Tester in the project

oInvolved in test planning and strategizing, analysing and highlighting risks

oInvolved in requirement analysis, test design, data preparation, execution, raising and retesting defects and closure, execution and defect status reporting

oCo-ordinating with offshore team of other location and with onshore on a regular basis

oCoordinating with Mainframe, Informatica ETL and Informatica MDM development teams at offshore and onshore whenever required

oManaging Test deliverables

MDM Testing : A large healthcare organization, USA

oWorked as Test Lead in the project

oInvolved in test planning and strategizing, analysing and highlighting risks

oInvolved in requirement analysis, test design, data preparation, execution, raising and retesting defects and closure, execution and defect status reporting

oCo-ordinating with offshore team of other location and with onshore on a regular basis

oCoordinating with Mainframe, ETL and IBM Infosphere (WCC) development teams at offshore and onshore whenever required

oManaging Test deliverables

MDM Testing : A large Life Science organization, USA

oWorked as Test Lead in the project

oInvolved in test planning and strategizing, analysing and highlighting risks

oInvolved in requirement analysis, test design, data preparation, execution, raising and retesting defects and closure, execution and defect status reporting

oCo-ordinating with offshore team of other location and with onshore on a regular basis

oCoordinating with Informatica development teams at offshore and onshore whenever required

oManaging Test Deliverables

MDM Testing : A large healthcare organization, USA

oInvolved in test planning and strategizing, analysing and highlighting risks

oInvolved in requirement analysis, test design, data preparation, execution, raising and retesting defects and closure, execution and defect status reporting

oCo-ordinating with offshore team of other location and with onshore on a regular basis

oCoordinating with ETL and WCC development teams at offshore and onshore whenever required

oManaging Test deliverables from Kolkata location

MDM Testing : A large Insurance Organization, USA

oInvolved in requirement analysis, test design, data preparation, execution, raising and retesting defects and closure, execution and defect status reporting

o

ETL & MDM Testing : A large PBM Organization, USA

oTest Design(Test Scenarios and Test Cases),preparation of test data and validation of various functionalities like Survivorship, delta updates, match rules, auto and manual collapse, cleansing and standardization activities as part of testing the entire application [IBM WCC, Datastage, Quality Stage and DB2].Quality Center 9.2 was used as the test management tool.

MDM Testing : A large Life Science Organization, USA

oRequirement Analysis, Understanding document, Test Design(Test Scenarios and Test Cases),preparation of test data and validation of various functionalities like Survivorship, delta updates, match rules, cleansing and standardization activities as part of testing the entire application [Informatica MDM is used].

Additional Responsibilities:

Have worked for the development of the Practice (i.e. Horizontal)

* Prepared technical reference materials on WCC

* Conducted project related and other technical trainings

* Managing Quality Review ( Audit ) for all projects of practice

* Supervision of learning and certification of multiple resources of practice

* Have taken interview of many experienced personnel

* Have taken part in Quality Review of other projects

* Prepared project specific document on the approach of testing performed

* Organized many events within Organization

Career Objective:

To work in challenging assignments wherein I will be able to acquire knowledge, enhance my acquired technical and leadership skills, add value to my profile and also add in best-in-class services to the organization.

Educational Details:

Bachelor of Engineering (Electronics and Communication Engineering) from Techno India College of Technology, Kolkata (Deemed University)

Professional Certifications - External:

Name of Certification

Date of Completion

ISTQB Fundamentals

4th September, 2012

Oracle SQL Expert

1st December, 2012

First Time Lead

March, 2015

Certifications - Internal:

Cognizant Certified Professional in ISTQB

Cognizant Certified Professional in Pharmacy Benefits Management L0

Cognizant Certified Professional in Fundamentals of CSP Testing

Cognizant Certified Professional in Informatica MDM 9.1.0 for Learners

Cognizant Certified Professional in General Insurance

Cognizant Certified Professional in Software Testing L0

Cognizant Certified Professional in CSP Testing CCP

Cognizant Certified Professional in Manlog L0

Cognizant Certified Professional in Retail L0

Technical Skills:

Below is a list of important hardware, software products, tools and methods that I have worked with.

Area

Skill sets

Operating systems

Windows NT 4.0/2000/XP

Languages Known

SQL

Databases

Oracle 10g, DB2, SQL Server 2008

Tools

HP QC9.2, HP QC 10, IBM WCC 7, IBM WCC 9, IBM WCC 10.1, IBM Rational Quality Manager, IBM Rational Clear Quest [Web Version], MS Office 2003, MS Office 2007, MS Office 2010,

Altova XML spy, Ultra Edit 32

Utilities

Putty, WinSCP, SQL*Plus, Notepad++, SOAP UI

Domain Knowledge:

Below is a list of all the different domains in which I have worked -

Area

Experienced on

Business Domains

Have worked in the following industry domains :-

Life Science,

Insurance,

PBM,

Healthcare

PROJECT DETAILS

Project # 1

ETL & MDM Testing

Customer

A large Life Science Org, USA

Period

June 2015 – Till date

Description

The aim of this project is to test the newly implemented business mapping and functionalities in SIT

Role

Sr. Test Analyst – ETL & MDM

Responsibilities

oManaging project deliverables from Kolkata location

oAssisted the other members of the team to understand ETL and MDM concepts at the initial phase and facilitated the overall testing delivery with my Testing experience and expertise

oPrincipal responsibilities were Requirement analysis; Preparation of Test Plan, Test Approach, Test design, assigning tasks to team members, execution, raising and retesting defects and closure, execution, defect status reporting, Test Closure.

oIdentified and highlighted the project risks in various calls or other forums as applicable

oQuality control related activities and facing audits

oCo-ordination with offshore development team and with onshore on a regular basis

Solution Environment

Windows 7

Tools and Applications

Informatica ETL, Informatica MDM, Oracle, IDD & HP ALM

Project # 2

MDM Testing

Customer

A large Health Care Org, USA

Period

November 2013 – May 2015

Description

The aim of this MDM project is to test the newly implemented functionalities and perform SIT and UAT

Role

MDM Test Lead

Responsibilities

oLeading and managing project deliverables from Kolkata location

oAssisted the other members of the team to understand the MDM concepts at the initial phase and facilitated the overall testing delivery with my MDM Testing experience and expertise

oPrincipal responsibilities were Requirement analysis; Preparation of Test Plan, Test Approach, Test design, assigning tasks to team members, execution, raising and retesting defects and closure, execution, defect status reporting, Test Closure.

oIdentified and highlighted the project risks in various calls or other forums as applicable

oQuality control related activities and facing audits

oCo-ordination with offshore development team and with onshore on a regular basis

Solution Environment

Windows 7

Tools and Applications

IBM Infosphere (WCC) MDM, DB2, SOAP UI, DSUI

Project # 3

MDM Testing

Customer

A large Life Science Org, Canada

Period

September 2013 – November 2013

Description

The aim of this project is to test the newly implemented functionalities and perform a regression test on the existing functionalities in MDM

Role

MDM Test Lead

Responsibilities

oLeading and managing project deliverables from Kolkata location

oAssisted the other members of the team to understand the MDM concepts at the initial phase and facilitated the overall testing delivery with my MDM Testing experience and expertise

oPrincipal responsibilities were Requirement analysis; Preparation of Test Plan, Test Approach, Test design, assigning tasks to team members, execution, raising and retesting defects and closure, execution, defect status reporting, Test Closure.

oIdentified and highlighted the project risks in various calls or other forums as applicable

oQuality control related activities and facing audits

oCo-ordination with offshore development team and with onshore on a regular basis

Solution Environment

Windows 7, Unix

Tools and Applications

Informatica MDM, SQL Developer

Project # 4

MDM Testing

Customer

A large Life Science Org, Delaware, USA

Period

June 2013 – August 2013

Description

The Pharmaceutical Company is switching to MDM system (Informatica MDM), where in the existing golden copy of records would be migrated to other environments where data processing based on business logic is applied.

Role

MDM Test Analyst

Responsibilities

oManaging project deliverables from Kolkata location

oAssisted the other members of the team to understand the MDM concepts at the initial phase and facilitated the overall testing delivery with my MDM Testing experience and expertise

oPrincipal responsibilities were Requirement analysis; test design, data preparation, execution, raising and retesting defects and closure, execution and defect status reporting

oIdentified and highlighted the project risks in various calls or other forums as applicable

oQuality control related activities and facing audits

oCo-ordination with offshore development team and with onshore on a regular basis

Solution Environment

Windows 7

Tools and Applications

Informatica MDM, SOAP UI, SQL Developer & GUI

Project # 5

MDM Testing

Customer

A large Healthcare Org, New Jersey, USA

Period

Oct 2012 – May 2013

Description

The aim is to test the data migration from 7 different existing legacy source systems to the MDM hub.

There is also a major MDM Upgrade project, wherein WCC 7.0.1 was upgraded to MDM 10.1.

Role

MDM Test Analyst - Offshore

Responsibilities

oManaging project deliverables from Kolkata location

oAssisted the other members of the team to understand the MDM concepts at the initial phase and facilitated the overall testing delivery with my MDM Testing experience and expertise

oPrincipal responsibilities were Requirement analysis; test design, data preparation, execution, raising and retesting defects and closure, execution and defect status reporting

oIdentified and highlighted the project risks in various calls or other forums as applicable

oQuality control related activities and facing audits

oCo-ordination with offshore team of other location and with onshore on a regular basis

oCo-ordination with ETL and WCC development teams at offshore and onshore whenever required

oHave built query repository single-handedly to drive the database validation of persistence of records

Solution Environment

Windows 7

Tools and Applications

IBM WCC 7.0.1, IBM InfoSphere MDM Server 10.1, IBM RQM, IBM CQ, SOAP UI, UltraEdit, IBM DB2 Adminclient, SQL SERVER 2008

Project # 6

MDM Testing

Customer

A large Insurance Co., New Jersey, USA

Period

May 2012 – Oct 2012

Description

Testing the migration of the current mainframe data management system into MDM

Role

Offshore Tester

Responsibilities

oActing as offshore test analyst and managing a team of 7 resources

oAnalyzing the requirements from out of various interface design documents and other subsidiary documents related to the existing mainframe system and the MDM System under development, as there is no updated BRD or any other documents wherein the current business or functional requirements have been captured

oInterfacing with client on behalf of the entire offshore team with queries during various KT Sessions delivered by client

oWeekly status reporting to higher management of my industry practice

oInterfacing with Onshore Counterparts on a daily basis

oProviding suggestions or inputs to the team regarding their work, explaining them the system, complex requirements or any inputs received from onshore counterpart

oHighlighting risks, challenges and suggesting probable mitigation plans to every stakeholders concerned(practice or vertical managers, onsite managers or client) whenever required

oPerformed Test Design, Test Execution, Defect Management activities

Solution Environment

Windows 7

Tools and Applications

IBM Infosphere MDM Hub 9.0, IBM Datastage, IBM Quality Stage, Oracle, HP Quality Center 9.2, Toad

Project # 7

MDM Testing

Customer

A large Pharmacy Benefit Management Organization, NJ, USA

Period

Aug 2011 – May 2012

Description

Worked for the below modules –

NPI DEA Release

PMA Acredo Release

Full Prescriber Release

Patient Release – Test Design

Have worked both in Waterfall Model and Scrum Based Delivery Model during the entire project tenure.

Have acted as tester for various small scrum projects under Medco MDM engagement.

Role

Offshore tester

Responsibilities

oActing as offshore Tester for various modules,

oAnalyzing the Requirements (received either through BRD or User Stories)

oDesigning Test Artifacts(Test Scenarios and Test Cases)

oPreparation of test data

oPerforming Test execution (including Regression Testing)

oDefect management

oDaily and weekly status reporting to higher management

oInterfacing with Onshore Counterparts on a daily basis

oAttending Sprint kick-offs, Scrum Meetings and/or other status calls as applicable

oInvolvement in decision making as and when required

Solution Environment

Windows 7

Tools and Applications

IBM MDM Infosphere 9.0, Datastage, Quality Stage, DB2, Putty, DB Visualizer, FileZilla, IBM Rational ClearQuest [web version]

Project # 8

MDM Testing

Customer

A large Life Science based Organization, NJ, USA

Period

Apr 2011 – Aug 2011

Description

Worked as a functional test analyst

Role

Offshore Team Member

Responsibilities

oFunctional Requirement Analysis

oAnalyzing BRD

oWriting and executing test cases and test scripts

oPerforming Regression and High Level Regression Testing

oDefect status follow-up and closure

Solution Environment

Windows XP

Tools and Applications

SQL Server, MS Office, Informatica MDM, Siperian Hub

Personal Details

Date of Birth

04.08.1986

Nationality

Indian

Permanent Address

A – 4/5 Karunamayee Housing Estate Saltlake

Kolkata - 700091

Sex

Male

Blood Group

A +ve.

Marital Status

Single

Contact No

(M) 91-983*******, (H) : 033-****-****

Passport Details

Name as on passport

Passport Number

Date of Issue

Expiry Date

Place of Issue

Avisek Sen

J4855170

28 January, 2011

27 January, 2021

Kolkata, India

Contact this candidate