Sr ETL QA

JYOTI KUMAR [ETL TESTER with * years’ Experience]

CELL # 214-***-****

EMAIL # ****************@*****.***

PROFILE

Over 8 years of experience in Testing, Team Leading, System study, Design & Development.

Result-driven Quality Assurance professional with solid knowledge in ETL Testing, DWH Testing, Database Testing, BI Testing, shell script testing and Application Testing.

Good Exposure to Unit Testing, Integration Testing, System Testing, Application Testing, Functional Testing, Regression Testing, GUI Testing and User Acceptance Testing.

Wide Experience in Testing using both Black Box Testing and White Box Testing methodology.

Exposure to Healthcare, Telecom, Publishing, and Agricultural sector industry domains.

Proven expertise in Test Design, Test Development, and QA of cost-effective enterprise level application systems that exceed client's Business Requirements and expectations.

Proficient in writing Test Plans, Test Strategies, Test Cases, Test Scripts, Test Summary Reports and Test Closer Reports.

Exposure to ETL tool – Informatica and DataStage.

Good Exposure to DataBases - SQL Server, Oracle, Toad, TeraData.

Knowledge of UNIX Platform, TWS (Tivoli Work Scheduler) and Dot Net Applications.

Good Experience in Defect management and Bug Tracking & Reporting.

Experience in using HP Quality Centre, Quick place, Share Point, RPM and RTC (Rational Team Concert), Beyond Compare etc.

Exposure to Test Automation tool – LoadRunner.

Experience in Analyzing Project requirements, creating Test Case, Test Scripts and performing Unit testing, Integration testing, System testing and UAT testing.

Experience in Estimation, scope preparation and effort calculation along with risks & assumptions

Experience in working with large scale projects with teams spread globally with Excellent client interaction skills and team management skills.

Good knowledge and experience of Complete SDLC & STLC including both Agile and Waterfall models

Excellent Communication with the development team and with Business Analyst for requirement understanding, and problem solving.

Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.

SKILL SET

ETL Testing: HP Quality Center, Beyond Compare, Tivoli WorkLoad Scheduler (TWS), Informatica, DataStage, SharePoint

Operating Systems: UNIX, Windows

Databases: TeraData, Oracle, Microsoft SQL Server

Scripting Language: VB Script, Shell Script, Pearl Script

Others tools: Toad, Putty, MS office, DotNeT, LoadRunner

EXPERIENCE

Client: Mckesson, Carrolton, TX OCT’16 - Till Date

Role: SR Quality Analyst

Testing Type: Manual - Web Application Testing and ETL testing

Environment: Quality Center ALM, MS Office, Oracle 10g, SQL, Manual & Web Application Testing, DataBase Testing, Toad, ETL Testing, TWS

Description: Mckesson is a pharmaceutical distributing health care company which provide health information technology, medical supplies, and care management tools.

Responsibilities:

• Extensive experience in reviewing and understanding of Business & functional requirements and writing detailed Test Plans, Test Cases, and Test Scripts for Web and Client/Server applications.

• Working knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing.

• Conducted Business Requirements meets to identify and business requirements And Developed various Test Plan Documents for complete coverage of all business requirements

• Responsible for conducting various Walk through of Business Requirement Documents, Functional Specification Documents, BA verification Documents and Mapping Documents.

• Responsible for managing the system requirement documents along with test plan documents and Requirements Traceability Matrix.

• Responsible for Executing the test cases and test scripts for manual and web testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.

• Worked with ETL source system and target system (ETL mapping document) for writing test cases and test scripts.

• Responsible for Test execution of ETL Processes based on business rules. Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

• Developed complex SQL queries for querying data against different data bases for data verification process and also performed backend database testing.

• Tested complex ETL mappings and sessions based on business user requirements and business rules to load data from source flat files and stage tables to target tables.

• Prepared Test data, Performed Test execution and captured the Test Results.

• Responsible for Running and Monitoring TWS jobs for Data loading to various stages of DB.

• Expertise in writing complex SQL queries for fetching the data for testing and analysis purpose.

• Responsible for analyzing/preparing technical specifications and ensuring appropriate quality assurance testing is completed.

• Performing Functionality testing and analyze the test results.

Provided interim reports as well as a final report that summarized results to senior management.

• Ensure that all the test cases are updated in the QC along with Master test plan and test results.

• Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting tight timeline.

• Responsible for Testing all the scripts in UAT and Productions Environments.

• Involved in client calls and weekly status meetings.

Client: Oaks Software Labs,TX JUL’15 - SEP’16

Role: SR Quality Analyst

Testing Type: ETL testing, Database testing, Manual Testing

Environment: QC, Tera Data, SQL, Manual Testing, ETL Testing, DataBase Testing, MSoffice, TWS

Responsibilities:

• Analyze business and technical requirements to create detailed test cases/scenario’s.

• Prepared detailed Test Plan and Test cases based on Business and Functional Requirements.

• Prepared Test data, Performed Test execution and captured the Test Results.

• Interacted with development team and discussed about reported bugs and supported the dev team.

• Involved in test scenario walkthrough with client and Onsite team members

• Manual test cases were prepared based on functional spec and Technical design document.

• Worked with ETL source system and target system (ETL mapping document) for writing test cases and test scripts.

• Responsible for Test execution of ETL Processes based on business rules. Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

• Responsible for the validation of data on each layer with Mapping Document. Capturing the details test results with each of the test case.

• Responsible for the testing of data from Extraction to Transformation and finally loading of data to the Data Warehouse [DWH].

• Reviewed the test scenario and test cases written by team members.

• Execution of test cases and logging the defects in Defect log.

• Functional testing with Smoke and Regression test methods.

• Integration testing which involves implementation of new functionalities.

• Written Positive and Negative test cases for entire systems.

• Provided the management with weekly QA documents like test metrics, reports, and MTPs.

• Responsible for Logging of defects, Re-testing and follow up till closure of defects assigned to team.

• Documented test results, as well as provide regular status to team lead.

• Executed performance tests on applications to assure capacity.

• Communicated performance testing results.

• Responsible for Onshore offshore status calls and handover meetings.

Client: OPTUM, Noida India AUG’13 – JUN’15

Project: Unified Data Warehouse [UDW] – Financial Claims

Role: Sr. IT Quality Analyst

Technology: QC, TeraData, Informatica, UNIX, & ETL Testing, TWS.

Description: The primary objective of the Unified Data Warehouse (UDW) is to provide a single, consolidated analytics environment and database to create the foundation for delivering world-class business intelligence capabilities to all UnitedHealth Group business segments. The UDW process is designed to intake different delivery mechanism followed by different source systems (Table, Flat File & Message). Data is loaded using TWS jobs Load Process. Landing zone for all this is the Physical file system on UNIX directory. The Various Layers of UDW are:

• Pre stage: Data will be loaded temporally

• Stage : Staging is an intermediate storage area between the sources of information and the data warehouse (DW) or Data mart (DM). Will have actual data.

• Source Repository

• Comman Format

• UDW Base

Testing Scope includes Testing of Data from PreStage to Base Layer.

Responsibilities:

Responsible for the Planning and Development of TeraData Test Scripts as per BA mappings, Functional Specification and Design document.

ETL Testing - Testing of Data in each layer of the system to check its availability, accuracy and authenticity of the data.

Execution of the Test cases and Bug & Defect Management in QC.

Prepare all Test Documentation like – TPS, Test Scripts, Test Results, Test Closure Summary [TCS], MTP [Master Test Plan] etc.

Handling Daily Test status calls with onshore and delivering daily test status of offshore team.

Client: T-Mobile, Noida India Jul’12 – Jul’13

Project: TMO SAP – COMMISSIONS Module

Role: Test Analyst

Technology: QC, SQL server, TOAD, Oracle, Informatica, UNIX, Web & ETL Testing.

Description: Client was T-Mobile USA - a Telecom Giant, A national provider of wireless voice, messaging, and data services capable of reaching over 293 million Americans. T-Mobile sells its products & services through 40,000 independent sales partners and process about 2 Million commission transactions per month. This commission may either be a percentage of the value of the transaction, or a flat amount. To calculate this Commission T-Mobile has a separate Module called COMMISSIONS. Where there is an ACS/ICS System and Sales Commission Management System [SMCS] which calculates the actual commissions. But now it is being replaced by a new Varicent System. So we Commissions Team is involved in the Testing of this new developed commission calculating system SCMS Adapter and Varicent.

SCMS Adapter is a Data Acquisition system which pulls subscriber and reference data from different data sources into a series of databases destined for the Commission Landing system. It is envisioned that this data will be used by T-Mobile’s ACS and ICS Commissions Systems for the purpose of paying commissions to T-Mobile Retail and B2B employees and Dealers.

Responsibilities:

Reviewing the Business and Functional Specific Requirements as per the project needs, Analysis of Defect & RCA and Maintaining, Following Defect lifecycle and Implementation of Delivery plan.

Understanding requirements & technical specifications; access system in order to identify test cases which are feasible for testing.

Responsible for the Development of Test Plan, Test Cases, Test Data and Test Scripts.

Closely Worked on SQL scripts to load data in the tables And their validations & authentication.

Created Test Cases in Quality Center and mapped those Test Cases with the Requirements in QC for Requirement coverage.

Reviewing Test Cases and procedures to ensure coverage of and conformance to business and functional requirements.

Execution of the Test cases and Bug & Defect Management in QC.

Data Base - ETL Testing, Testing of Data in each layer of the system to check its availability, accuracy and authenticity of the data.

Updating & maintaining the Results of Execution as Evidence in QC for all the Test sets.

Ensure the successful delivery of a solution according to business requirements on time, within the budget, and to the appropriate quality bar.

Web Testing and Application Testing.

Maintaining QAT daily status Reports.

Client: Portugal Telecom May’11 – Jul’12

Project: Portugal Telecom System Information [PTSI]

Role: Test ENGINEER

Technical Details: SQL Server, Toad, Dot Net Application, Quality Center

Description: Portugal Telecom is the leading telecommunications services provider in Portugal. It Operates in the areas of fixed, mobile and multimedia communications, information systems, research and development, satellite communications and international investments. Applications in testing scope was classified in 4 main technological domains i.e. SAP, CRM, Web Portals and Portal SFA. I was working with Portal SFA. Portal SFA is a Sales Force Automation eBusiness Application. Where user have various products, promotions, schemes, campaigns and packages for PT Telecom Clients. For various telecom products available in application/software the client places the orders and the sales is made to them for corresponding items. There are various options to upgrade their Packages and Plans etc. The Portal SFA application was developed in .NET technology using SQL Server.

Responsibilities:

Analyzed Business, Functional requirements and Developed Test plans, Test cases and generated test scripts for both positive and negative scenarios.

Reviewing Test Cases and procedures to ensure coverage of and conformance to business requirements.

Responsible for preparing software test status reports and update the status to management.

Involved in Application Testing, Unit/Integration testing and Black Box Testing of Web Portal

Designing SQL queries while performing database testing.

Updating and maintaining the results of Execution in Quality Center for all the Test Case and defects found during testing and follow up the bug life cycle.

Execution of Regression Testing by repeated execution of recorded Test Scenarios to identify errors in each modified build in the process of Testing.

Preparation of understanding documents and TID’s [Test information Document] with all the evidences.

Performed Functional testing. Ensuring that content and structure of all testing documents/artifacts is documented and maintained.

Responsible for performing load testing of the web application.

Involved in management activities like Lean Implementation, Expense tracking etc.

LSIPL, Bangalore India OCT’07- APR'11

Project: NHB Interactive

Role: Developer /Tester

Technical Details: Web Testing, Dot Net, SQL server, UNIX, QC

Description: NHB Interactive provides a mechanism for Customer and user to apply online for the Subsidy of their New Projects. It also provides an option to track the status of their applied application which are submitted to NHB through a Project Reference No. provided by the system during the online submission of application form. However applicants can also apply through physical application Form. Along with these online features, there is a complete integrated backend application for Tracking and Management System, that has been developed for the NHB Officers located in various States at their Nodal Offices and the HQ throughout the INDIA. The solution developed helps National Horticulture Board in providing a start-of-the-art facility to the farmers and entrepreneurs to apply and track LOI applications online.

Responsibilities:

Analysing the problems functionally and technically and devising solutions thereof

Coding, Technical Documentation, Unit Testing.

Design and development of Application.

Analysis of data for various reports.

Performed Database Testing while Executing SQL Queries.

Involved in Unit and Integration Testing [White box Testing] and Functional Testing.

Communication with Client and End User.

EDUCATION/HIGHEST DEGREE Masters in Computer Applications [MCA] - June 2007

REFERENCES Available upon request.

Contact this candidate