Shabbier Vempallli E-Mail: ac3guz@r.postjobfree.com

Test Engineer Mobile Number: +91-988*******

Objective :

To establish a long term professional relationship with a firm where there is scope for organizational development and individual growth.

Professional Summary

Currently working as a Test Engineer in Accenture Services India Pvt. Ltd JAN 2015 to Till.

Having around 3.6 years of experience in ETL Testing.

Hands on experience in identifying Test Scenarios, Preparing Test cases, Test Execution and documenting the Test results.

Worked on Workflow manager, Workflow monitor in Informatica ETL tool.

Experience in SQL and worked with database Oracle.

Preparing SQL queries according to the defined transformation rules.

Knowledge in Unix commands.

Experienced in client interactions during different phases of the projects, worked with teams on multiple engagements and has good knowledge on Requirements Understanding, Test Design, Test Execution and Defect Reporting.

Expertise in Defect Management related activities like analyzing software problems, providing clear defect reports and following defect tracking practices based on internal QA standards and processes.

Defect management and Defect Life Cycle definition using QC Good exposure in Software Test Life Cycle (STLC).

Work Experience

Currently working as TestEngineer in Accenture Services India Pvt. Ltd JAN 2015 to Till

Worked as test engineer in BHILWARA INFO TECHNOLOGY from April 2014 to Dec 2014

Education

BTECH(ELECTRONICS AND COMMUNICATION ENGINEERING) FROM SANTHIRAM ENGINEERING

COLLEGE,NANDYAL.

Technical Skills

Testing : DWH/ETL TESTING

Database : Oracle 10g

ETL tool : Informatica

Test Management &Other Tools : QC 10.0, Tidal, TOAD 9.7.2,UNIX

Projects

Project # 1

Project Title : Commercial Banking portal DWH (CBP)

Client : DCB

Duration : April 2016 to Till

Environment : Oracle 10g, Informatica 8.6, Windows, Tidal, UNIX.

Role : Tester

Description :

THE BANK OF DCB in the U.S, serving a wide range of clients from small businesses to professional services, to analyze transactions across finance, marketing, risk, collections, and consumer relations. The scope of this project was to provide the bank with timely reports based on their performance, profitability, revenue, notifications of key business issues and many more that will help identify the profitability of the institution at various levels.

Involved in functional study of the application

Running the Jobs/Workflow for ETL process

Verifying the data in target database after ETL process

Prepared test data for testing

Verifying the data which is loaded into target database

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status report

Developed, Reviewed & Executed Test Scripts and Designed test data

Identified Test Scripts for Regression testing

Project # 2

Project Title : Safeway Data Warehouse

Duration : JAN 2015 to MAR 2016

Client : Safeway, US

Environment : Oracle 10g, Informatica 8.6,QC 10.0

Role : Tester

Description:

Safeway, which is one of the organization that sells various number of products. Safeway have various stores, which maintains database that contains historical data. The aim of sales data warehouse is to help analyze sales of major brands varying with different promotional schemes.

The data warehouse plays a major role in enabling various stores to view the data at a lowest level and help them to make decisions to bring more revenues to company with new.

Roles :

Involved in functional study of the application

Running the Jobs/Workflow for ETL process

Verifying the data in target database after ETL process

Prepared test data for testing

Verifying the data which is loaded into target database

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status report

Identified Test Scripts for Regression testing

Project # 3

Project Title : Sainsbury,s data Warehouse

Duration : April 2014 to Dec 2014

Client : Sainsbury’s, UK

Role : Test Analyst

Environment: Oracle 10g, Informatica 8.6, Windows, Tidal, UNIX, Agile.

Description:

Sainsbury’s Stores, which is one of the organization that sells various numbers of products.

sainsbury’s have various stores across UK, which maintains Sales, Profits with lots of historical data. This project was to create Sales Data Warehouse and generate reports using Reporting services. The aim of sales data Warehouse is to analyze the sales and profit in month wise and year wise. The data gets refreshed yearly and is maintained historically. This Data warehouse plays a major role in enabling various stores to view the data at a lowest level and help them to make decision to bring more revenue to company with new policies.

Responsibilities:

Understanding the customer requirements

Designed High level test scenarios and test cases

Executed test cases in QC

Run the Informatica Workflows for ETL Process

Validated data in Target database according to business rules

Prepared SQL queries and executed to validate the ETL processed data in target database.

Verifying the column mapping between source and target databases

Worked closely with Dev team

Declaration: I hereby declare that the above-furnished information is true and correct to the best of my knowledge.

(V Shabbier)

Contact this candidate