*.* yrs experience in ETL Testing

EXPERIENCE SUMMARY

IT professional with an experience of 5 years 11 months in ETL /BI/Database testing.

Extensive experience in Datawarehousing and Business Intelligence (BI).

Experience in ETL Testing,BI Testing,Database or Backend testing,Report testing.

Experience in System Testing,End to End testing, Functional testing,Blackbox testing .

Has good knowledge on Software Test Life Cycle.

Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and in Defect Management to ensure Quality Assurance and to test all the business requirements.

Good exposure to Oracle Database and Micosoft SQL server2008 R2.

Expert in SQL and forming complex queries

Proficient in troubleshooting database issues and making test data.

ETL Testing experience using Datastage 7.5/8.7(Director) and Informatica 9.1 (Monitor).

Has good knowledge of HPQC(ALM),JIRA and Rally dev.

Worked for AT&T,Barclays,Allergan and Merck projects.

Worked on Agile Projects and communicates with client and offshore and onsite team members effectively.

Good Ability to read and understand Functional Requirements & Design Documents.

Hardworking, good communication and presentation skills, quick learner,flexible.

Currently working in Cognizant Technology Solutions(India).

ACADEMICS

B.E. (Electronics & Telecommunication) from St. Vincent Pallotti College of Engineering and Technology, Nagpur(University -Rashtrasant Tukadoji Maharaj Nagpur University) in 2011 with an aggregate of 71% marks.

TECHNICAL SUMMARY

Language - SQL,basics of unix

Testing - ETL Testing,BI Testing, Database testing,Functional testing, System Integration testing, End to end testing, Regression testing.

Tools - JIRA,HPQC-ALM,Rally dev,toad,tidal,Hive

ETL/BI Tool - Datastage Tool(7.5 version and 8.7 version) and Informatica(9.1),SSRS

Databases - Worked on Oracle SQL developer, Microsoft SQL Server - SSMS(SQL Server Management Studio)

Operating Systems - Windows 7, Vista, XP,Unix

Packages - MS Office (MS Word, MS Excel, PowerPoint)

WORK HISTORY

1.Organization – Cognizant Technology Solutions.

Role – Senior Test Analyst

Duration – From 4 Aug 2014 to tilldate

2.Organization – Tech Mahindra Ltd

Role – Test Engineer

Duration – From 27 May 2011 to 25 july 2014

PROJECT EXPERIENCE

1.Project : Nitro

Duration: 20 March 2017 to Present

Domain:Lifesciences

Client:Sanofi

Environment: Oracle,Unix,Informatica,Hive

Project Description: Under this project,there are two flows inbound and outbound.

In Inbound flow the data is gathered from nitro source and after transformation it is sent to Veeva and then Veeva updates missing information and pass it back to RCM.Under outbound flow,User in Veeva can manipulate data in profiles for both HCP/HCA by adding additional data to existing customers, creating new profiles and submitting change requests. This data needs to flow to MDM for it to be master and approve.

Inbound flow -

Source raw files -> Oracle tables ->Delta table ->Purpose Zone ->Veeva ->Veeva response ->Final/History table

Roles/Responsibilities: As a Team member

Reading & understanding Mapping Documents .

Preparation of Test Cases based on Requirements

Test Cases Reviews .

Data Loading.

Execution of Test cases on SIT environment.

Data setup as per scenario.

Raising defects.

Maintaining evidences on sharefolder.

Defect tracking and retesting and regression testing.

Communicate test results, as well as any errors or issues discovered during testing to developers / Clients.

Completing the required task within time limits.

Coordinate with onsite and offshore team members

Need to send Daily status report to all the stake holders.

Areas worked in :-

ETL Jobs testing

Validating data between different layers

Hive

Data Validation between oracle tables and hive files/tables

2.Project : Symphony

Duration: 12 Dec 2016 to 19 Mar 2017

Domain:Lifesciences

Client:Sanofi

Environment: Oracle,Unix,Informatica,Hive

Project Description: Under this project the data is gathered from various sources and after transformation it is sent to Veeva and then Veeva updates missing information and pass it back to Quantum DSS.

Source raw files -> Oracle tables ->Delta table ->Purpose Zone ->Veeva ->Veeva response ->Final/History table

Roles/Responsibilities: As a Team member

Reading & understanding Mapping Documents .

Preparation of Test Cases based on Requirements

Test Cases Reviews .

Data Loading.

Execution of Test cases on SIT environment.

Data setup as per scenario.

Raising defects.

Maintaining evidences on sharefolder.

Defect tracking and retesting and regression testing.

Communicate test results, as well as any errors or issues discovered during testing to developers / Clients.

Completing the required task within time limits.

Coordinate with onsite and offshore team members

Need to send Daily status report to all the stake holders.

Areas worked in :-

ETL Jobs testing

Validating data between source and target tables.

Unix

File Validation

Archieving of files

Data Validation between Files and Database

3.Project : Quantum – Liquid Hub Data Integration for Sarilumab/Dupilumab(Sanofi)

Duration: 1 Aug 2016 to 11 Dec 2016

Domain:Lifesciences

Client:Sanofi

Environment: Oracle,Unix,Informatica,tidal

Project Description:

As part of Sarilumab(Kevzara) and Dupilumab product launches, Sanofi needs the LH data integration process set up built similar to existing Praluent data integration.

oBuild new Process Similar to Praluent

oAbility to handle both Full and Delta loading of data.

oAbility to set up new market with minimal changes with No change in source file layout

Roles/Responsibilities: As a Team Lead

Reading & understanding Mapping Documents .

Preparation of Test Cases based on Requirements

Test Cases Reviews .

Data Loading.

Execution of Test cases on SIT environment.

Data setup as per scenario.

Raising defects.

Maintaining evidences on sharefolder.

Defect tracking and retesting and regression testing.

Communicate test results, as well as any errors or issues discovered during testing to developers / Clients.

Completing the required task within time limits.

Coordinate with onsite and offshore team members

Need to send Daily status report to all the stake holders.

Preparation of Test Closure Document.

Areas worked in :-

ETL testing

Validating data between source and target tables.

Data loading at different layers.

Unix

File Validation

Archieving of files

Data Validation between Files and Database

4.Project :Japan Smart Compass Phase 1.0

Duration: 4 Jun 2016 to 25 Jul 2016

Domain:Lifesciences

Client :Merck

Environment: Oracle,Unix,Informatica

Project Description:

Smart Compass will be the aggregated metrics tool.

It will be a set of selected metrics for MR for quick reference

and confirm their own sales and activity data.

The data would be moved from the PUB Layer to an

Application Interface Layer to the final Data Mart.

Different Layers:

Veeva(Source)->AIL(tables)->PUB->AIL(Views csv files

Roles/Responsibilities: As a Team Lead

Reading & understanding Mapping Documents .

Preparation of Test plan and Strategy Document.

Preparation of Test Cases based on Requirements

Test Cases Reviews(internal and external) .

Data Loading.

Execution of Test cases on ST environment.

Data setup as per scenario.

Raising defects.

Maintaining evidences on teamspace.

Defect tracking and retesting and regression testing.

Communicate test results, as well as any errors or issues discovered during testing to developers / Client.

Completing the required task within time limits.

Coordinate with client and multiple internal team members

Need to send Daily status report to all the stake holders.

Preparation of Test Closure Document.

Guide the other testing team members

Areas worked in :-

ETL testing

Validating data between source and target tables.

Data Loading.

Unix

File Validation

Archieving of files

Data Validation between Files and Database

5.Project : Allergan Partner Privileges 2.0 (Allergan)

Duration: 2 April 2016 to 8 Jun 2016

Domain:Lifesciences

Environment: Oracle,Unix,Datastage

Project Description:

ALLERGAN PARTNER PRIVILEGES®is an ALLERGAN®Aesthetics Portfolio rebate program.

When physicians purchase select Allergan products, they earn points, which translate to both

ALLERGAN PARTNER PRIVILEGES® member levels and product tiers. Their points may contribute to 3 different, additive benefits:

1. The ALLERGAN PARTNER PRIVILEGES®Member Rebate

2. The Growth Reward Year End Kicker

3. Instant Product Savings

As a part of this project new programs like Growth Kicker,Alerts and combo tier is implemented.

Roles/Responsibilities: As a Team Member

Reading & understanding Business Documents and FRS.

Preparation of Test Cases based on Requirements

Test Cases Reviews(internal and external) .

Execution of Test cases on ST environment.

Data setup as per scenario.

Raising defects.

Maintaining evidences on teamspace.

Defect tracking and retesting and regression testing.

Communicate test results, as well as any errors or issues discovered during testing to developers.

Completing the required task within time limits.

Coordinate with client and multiple internal team members (offshore and onsite)

Areas worked in :-

ETL testing

Validating data and various transformation logic used between source and target tables.

Data Loading.

Scheduling

6.Project: Group Treasury Balance Sheet

Duration : 4 Aug 2014 to 1 April 2016

Domain- Banking

Client: Barclays

Environment: SQL Server,Informatica and Unix

Project Description:

Provide a central source of treasury balance sheet data (Banking Book only) with a reporting facility.

Provide an automated feed of data to QRM for the purpose of treasury balance sheet projections

Allow production of summary reports required for regulatory submission sign off meetings.

We are preparing a balance sheet for treasury and for this we are building datawarehouse and data comes from different source -files,teradata and XML’s and is loaded to Landing area and after that the data goes to staging and then to star schema i.e., facts and dimensions.

Agile methodology is implemented for this project.

Roles/Responsibilities: As a Team member

Reading & understanding Mapping Documents.

Understanding workflow.

Preparation of Test Cases based on Requirements

Test Cases Reviews(internal and external) .

Execution of Test cases on ST environment.

Raising defects on JIRA.

Maintaining evidences on sharepoint.

Defect tracking and retesting and regression testing.

Communicate test results, as well as any errors or issues discovered during testing to developers / BA’s.

Completing the required task within time limits.

Coordinate with client and multiple internal and external team members ( Onsite and offshore)

Have to attend Scrum calls and give status to Client(Barclays).

Areas worked in :-

ETL testing

Validating data between source and target tables at different layers.

Data Loading.

Unix

Files validation

Data Loading

7.Project: CFD (Cross Funtional Dashboard)

Duration : Dec 2013 to 25 July 2014

Domain: Telecom

Client : AT&T

Environment: Oracle SQL developer and Unix

Project Description:

This new Customer Status Dashboard for our Enterprise Business Customers will provide a One AT&T face to the customer by providing a consolidated, single interface to obtain current order status information across transactions for all of their products and services which does not exist today.

Agile methodology is implemented for this project.

Roles/Responsibilities: As a Team member

Reading & understanding Design Documents (HLD’s)

Attended HLD review calls.

Understanding workflow.

Preparation of Test Cases and Test plan based on Requirements

Test Cases Reviews(internal and external)

If got any review comments then the same needs to be tracked on JIRA.

After Test Cases approval,uploading it on QC and Rally dev.

Execution of Test cases on ST environment i.e on Oracle SQL developer and Unix platform.

Maintaining the evidences on QC and Rally dev.

Raising valid defects on QC and Rally dev.

Defect tracking and retesting and regression testing.

Communicate test results, as well as any errors or issues discovered during testing to developers / Designers

Completing the required task within time limits.

Coordinate with client and multiple internal and external team members ( Onsite and offshore)

Have to attend Scrum calls and give status to Client(ATT).

Areas worked in :-

ETL testing

Validating data between source and target tables

Data Loading.

Unix scripts testing

Checking Alarms.

Data Loading.

8.Project: Service Express Platform (SXP)

Duration: 2 March 2013 to 25 Nov 2013

Domain-Telecom

Client : AT&T

Environment: Oracle SQL developer,Datastage,Unix

Project Description:

SXP-Tapestry projects belongs to AT&T.

Tapestry is a project which provides AT&T Customer and Sales communities a Service Delivery dashboards for order status tracking and alarming and task automation for the AT&T Enterprise Solutions Service Delivery organization.

This dashboard is known as IOS dashboard where IOS stands for Integrated Order Status.

solution approach provides a three layer structure, starting with the Functional Applications (Layer 1) providing data to the Data Layer (Layer 2) and the Web Based GUI (Layer 3) accessing data from the Data Layer.

Data Layer (Layer 2) :-The data comes from different sources(Layer 1) and then transformation is done on that data as per the requirement and it is passed to target database(SXP) from it goes to IOS(Layer 3) through golden gate(GG)

wherein we have dashboards and reports which is shown to customers.

Roles/Responsibilities: As a Team member

Reading Functional Requirements & Design Documents (HLD’s)

Attended HLD review calls.

Understanding workflow.

Preparation of Test Cases based on Requirements

Test Cases Reviews(internal and external)

If got any review comments then the same needs to be tracked on JIRA.

After Test Cases approval uploading it on QC.

Execution of Test cases on ST environment and maintaining the evidences on QC.

Raising valid defects on QC.

Defect tracking and retesting and regression testing.

Handled tickets and CR’s raised on production environment.

Communicate test results, as well as any errors or issues discovered during testing to developers / Designers

Also we have to perform Pair wise Testing.

Completing the required task within time limits.

Coordinate with multiple internal team members ( Onsite and offshore)

Guiding new team members.

Areas worked in Testing:

oETL/BI testing

Validating tables of Two layers mainly

1.Source - Order_Stage and

2.Target - Order_Sxp

9.Project: Millicom BI

Duration: Aug 2011 to 1 March 2013

Domain-Telecom

Environment: Microsoft SQL Server 2008 R2,

Project Description:

Millicom has partnered with TechM to implement EDW(Enterprise Datawarehouse) through building DWH blue print and roll out in 5 countries of operations.

Implement EDW at the following locations:

Millicom Ghana

Millicom Tanzania

Millicom DRC

Millicom Chad

Millicom Rwanda

Roles/Responsibilities: As a Team member

Reading and understanding Functional Requirements & Design Documents

Understanding workflow.

Preparation of Test Cases based on Requirements.

Test Cases Reviews

Execution of Test cases on different environment(CST, SIT)

Raising valid defects on JIRA.

Handled Defect Management calls

Bug Management - Reporting and tracking defects and Updating

Communicate test results, as well as any errors or issues discovered during testing to developers / Designers

Defect retesting

Extracting Defect from Defect Tracker tool (JIRA)and circulating to the entire Team (Test, Development, Design,DBA )

Completing the required task within time limits.

Coordinate with multiple internal team members ( Onsite and offshore)

Guiding new team members

Areas worked in ETL/BI Testing:

ETL testing

All layers from Source to Destination i.e, Landing, Staging, ODS, EDW.

Report testing

Cubes(OLAP) testing

Achievements:

Got “Cookies” award for FY 13-14 Q1 at techM.

Got EIM Award for FY 2015 Q1 at Cognizant.

Personal Profile:

Name

Pooja Bhimgade

Nationality

Indian

Date of Birth

18th may 1990

Gender & Marital Status

Female, Single.

Hobbies

Gardening, Watching TV, hanging out with friends,Collecting Fishes

Languages Known

English, Hindi, Marathi

Contact Details:

E-mail Address: ac0d9j@r.postjobfree.com, ac0d9j@r.postjobfree.com

Cell Number: +91-959*******

Present Address: Flat no 28, Building number- A-11, Aditya Shagun-Comfort Zone, Baner-Balewadi Road,Balewadi,Pune-411045.

Contact this candidate