Nupur Sachdeva

Email: ac8mk3@r.postjobfree.com

Cell: 682-***-****

1

Objective

To be a part of a growing organization as an ETL Tester and aid in accomplishment of organizational objectives by utilizing my knowledge in ETL Processes.

Experience Summary

• Over 7 years of experience in IT industry with expertise in ETL processes

• Ensuring process compliance and process improvements in the projects

• Analyzing Business Requirements and converting them into code

• Preparing test plans and test cases to ensure effective quality assurance testing and a fully functional application

• Preparing test summary reports

• Good experience in all phases of Software Development Lifecycle (SDLC) such as development, testing, migrating and production support

• Remarkable experience in designing ETL processes and developing source to target mappings

• Proven experience in utilizing databases like Teradata, SQL

• Analyzing requirements and providing work effort estimates

• Creating design specification and operational documents

• Developing test cases and planning to complete unit testing

• Exhaustive experience in SDLC, specialization in design and development of ETL solutions

• Supporting production and maintain applications

• Expertise in developing, testing and deploying ETL solutions

• Good amount of experience working in Data Masking projects performing Data masking through Informatica

• Profound knowledge about Data Masking transformation in Informatica and Data Masking in general

• Designing and developing various complex mappings to move data from multiple sources into common target area such as Data Marts and Data Warehouses using Lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator and Update Strategy from varied transformation logics in Informatica

• Performing Unit Testing/ SIT Testing and prepared testing documents are per the Client requirement

• Strong experience in Enterprise Data Warehouse environment with Informatica and Teradata combination and extensive work with Slowly Changing Dimensions (SCD)

• Expertise in developing user guides, manuals, checklists, guidelines and other documents for the end users

• Good exposure in writing client deliverables such as User Manuals and SDLC documents

• Designed and prepared Project Profiles and Project Plans for projects related to different domains

• Certified in Integrated Project Management Systems (IPMS) for Project Leaders

• Trained in integrated Quality Management Systems (IQMS) Skills Summary

• Excellent analytical, problem solving skills

• Superior communication, interview and presentation abilities

• Expertise in MS Office

• Experience in Retail, Manufacturing and Assurance domains

• Ability to meet rigorous deadlines

• Learning agility

• Self-motivated and hard working

Nupur Sachdeva

Email: ac8mk3@r.postjobfree.com

Cell: 682-***-****

2

Technical Skills

ETL Tools Informatica 9.6.1/9.5.1, Maven

DB Tools Toad

Programs MS Word, PowerPoint, Excel

Database Teradata 14/13/12

Reporting Tools Business Objects, Quality Center, Control-M, Unix, Selenium Languages PL/SQL, SQL, Java/J2EE

Operating System Windows

Professional Experience

CVSHealth, USA

QA Lead April 2018- Present

• The daily activities involve regular meetings with the CVS personnel to gather requirements, review designs, discuss and dissolve technical issues and change requests.

• Perform Functional, Smoke, Integration, System, Back-end and User Acceptance testing.

• Review the architecture and functional requirement documents.

• Review the technical design document and unit test plan so as to ensure proper testing.

• Prepare test plans and test cases to ensure effective quality assurance testing and a fully functional application.

• Generating Test scripts using any Automation Tool like LoadRunner or RPT

• Deriving Test Scenarios and Documenting Test Cases in HP QC tool

• Review of regression test cases and application landscape.

• Manage multiple projects and schedule the timeline for testing process.

• Write complex PL/SQL testing queries for User Acceptance Testing.

• Involvement in Selenium Environment setup for Test Automation

• Provide support to various testing groups on test data setup for new functionality, existing functionality and triaging test environment issues in various phases of testing (System, Integration, User Acceptance)

• Delivering projects with complexity at scale, meeting business goals and objectives working with cross- functional teams using technologies Java/J2EE, Angular JS, Maven, RabbitMQ

• Propose adoption of new fast track models of SDLC like Structured Iterative, Agile, Extreme Programming

• Grouping Test cases and generating detailed Test reports using TestNG

• Follow-up with customers on satisfaction of analysis, if a defect is raised then follow it till the closure of the defect and ensure proper route for it close, monitor or slotting for future release.

• Prepare and share Daily & Weekly status report with Client personnel. Wolters Kluwer, USA

Systems Engineer Nov 2017- April 2018

• Highly skilled in analyzing business requirements and converting business requirements into code

• Extensive knowledge of creating Business requirement and Technical documents

• Seasoned in all phases of Software Development Lifecycle (SDLC) such as development, testing, migrating, administrating and production support

Nupur Sachdeva

Email: ac8mk3@r.postjobfree.com

Cell: 682-***-****

3

• Preparing test plans and test cases to ensure effective quality assurance testing And a fully functional application

• Performing application testing as well as front end testing

• Preparing test summary report

• Defect Reporting using Test Management Tool Quality Center

• Imported various Application sources, created Targets and Transformations using Informatica Power Center 9.6.1. Designer (Source Analyzer, Transformation Developer, Mapplet Designer and Mapping Designer).

• Developed masking routines using Informatica mappings using different masking rules and Data Masking transformation

• Developed various complex mapping using multiple sources and targets in different databases, flat files and loading them into Teradata

• Write complex PL/SQL testing queries for User Acceptance Testing.

• Involvement in Selenium Environment setup for Test Automation

• Formatting and Technical Review of all the Client Deliverables in order to ensure that the quality of the documents is not compromised

• Strictly adhering to the Client provided templates (if any), else preparing and providing templates to the projects in order to ensure consistency in formatting and writing styles

• Face to face discussions with various Project Owners and team members about the quality of the documents prepared by the corresponding team members. Causal Analysis was carried out particularly for the teams that received a low Customer Satisfaction Index (CSI) in terms of documentation.

• Ensuring timely feedback from the Client as well as Project Owners upon the improvements made and working upon it

• Worked both individually and collaboratively, usually under no supervision

• Proven experience under changing environments with changing priorities and under alarming deadlines

• Received Best Faculty award for conducting Client Communication for the team members; recognized for making the soft skills training sessions interactive and learning at the same time Assurance Infra Testing, TCS India Apr 2014 - Dec 2015 ETL Tester

• Working closely with Development and Design team in order to understand Business Requirements

• Documented Business Requirements and assessed changes required to existing processes and procedures

• Translated Business Requirements into Data Warehouse design

• Good understanding on applying rules of Data Masking transformation using Informatica PowerCenter and loading the data into targets

• Worked on various sources like Flat Files, Teradata and SQL Server

• Worked on complex transformations like Data Masking Transformation, Lookup Transformation, and Expression Transformation etc.

• Responsible for capturing Unit and Integrated test results

• Responsible for updating QC with proper update for the raised ticket

• Created reusable transformations, mapplets, worklets using Transformation Developer, Mapplet Designer and Worklet Designer

• Handled Post-production issues and delivered all assignments/ projects within specified timelines Nupur Sachdeva

Email: ac8mk3@r.postjobfree.com

Cell: 682-***-****

4

• Maintaining several documents related to PMR and audit of the project

• Developing Project Profile and Project Plan for the project

• Organized, edited and maintained technical records and files according to set standards for order, clarity, conciseness, style and terminology

CVS Caremark, Gurgaon, TCS India Oct 2011- March 2014 Production Support Executive

• Working closely with Development and Design teams to understand Business Requirements

• Performed major role in designing and masking the data

• Imported various Application sources, created Targets and Transformations using Informatica PowerCenter 9.6.1. Designer (Source Analyzer, Transformation Developer, Mapplet Designer and Mapping Designer).

• Developed masking routines using Informatica mappings using different masking rules and Data Masking transformation

• Created Informatica PowerCenter mappings, sessions, workflows and worklets

• Used Expression, Connected/Unconnected Lookup, Router and Data Masking transformations to create mappings

• Performed Debugger testing and Unit testing for Informatica mappings

• Developed and scheduled Workflows using Task Developer, Worklet Designer and Workflow Designer in Workflow Manager and monitored the workflows in Workflow Monitor

• Wrote Teradata queries to unit test Data Masking applications

• Carrying out data masking activities by triggering jobs in Informatica and monitoring these jobs

• Analyzing the job failure issues and reporting to the onsite team

• Identifying and analyzing the issue if a particular workflow failed and looking for the possible workarounds

• Suggesting solutions for the failed jobs to the onsite team and working with them for troubleshooting

• Preparing several documents like Performance Data sheet for the jobs triggered reporting their status

(succeeded/ failed) and other statistics related to the onsite team

• Maintaining several documents related to PMR and audit of the project

• Developing Project Profile for the project

• Setting up meetings with onsite team to understand Client expectations

• Defect Reporting using Test Management Tool, Quality Center Education

• B. Tech in Electrical Engineering from Rajasthan Technical University, Kota, Rajasthan in India

• Certification in Informatica PowerCenter Foundation in October 2015

• Certification in Software Testing Skills in October 2014

• Certified in Integrated Project Management Systems (IPMS)

• Trained in Integrated Quality Management Systems (IQMS)

• Received On the Spot award and Employee of the month award twice Nupur Sachdeva

Email: ac8mk3@r.postjobfree.com

Cell: 682-***-****

5

Certifications

Certificate in Software Testing Skills:

Digital: BigData and Hadoop Ecosystems:

is awarded to

Nupur Sachdeva

(Employee No 536124) for successfully completing

the TCS Internal Certification

BDA : Certificate in Software Testing Skills

on 14-Oct-2015 .

BDA Head - Domain

is awarded to

Nupur Sachdeva

(Employee No 536124) for successfully completing

the TCS Internal Certification

Digital: BigData and Hadoop Ecosystems_RCPG Noah's Ark_Foundation

on 15-Jul-2016.

Debtanu Paul

Head - CLP Technology

Nupur Sachdeva

Email: ac8mk3@r.postjobfree.com

Cell: 682-***-****

6

Informatica Powercentre_foundation:

is awarded to

Nupur Sachdeva

(Employee No 536124) for successfully completing

the TCS Internal Certification

Digital: BigData and Hadoop Ecosystems_RCPG Noah's Ark_Foundation

on 15-Jul-2016.

Debtanu Paul

Head - CLP Technology

Contact this candidate