ETL TESTING SAMPLE RESUME

                                                                     

AKHIL REDDY

                                                                             Mobile:   +91 9440592994

                                                                             Email:   akhilreddyhyd@gmail.com                                   

Professional Summary

ü       Having 2.9 years of overall experience in Data Warehousing application testing

ü       Having good knowledge on ETL Testing process.

ü       Ample exposure on domains like Health insurance and Retail

ü         Expertise in Agile Testing Methodology/Techniques.

ü       Experience in writing Test cases and SQL queries to validate the data that has been loaded into QA direct, test execution and defect reporting using HP-QC test management tool.

ü       Hands on experience in Data Migration Testing, batch job testing process (inbound and Outbound testing) and Report testing

ü         Hands on Experience in SCD Type 1 and SCD Type2 Testing.

ü       Strong knowledge on Data warehouse concepts like Data warehouse architecture, Star schema, Snowflake schema, Data Marts, Dimensional and Fact tables.

ü       Having Good knowledge in Oracle and Teradata.

ü       Good Interpersonal, Communication skills and Leadership abilities.

Software skills

            Test Management Tools        : Quality Center(HP-QC).

            Environment                           : Unix/Linux, Windows XP, Main frames

            Databases                               : Oracle10g, Teradata 12.0.

            Languages                              : Sql.

            Scheduling Tools                    : Control M

Work experience

ü       Worked as a System Engineer for Tata Consultancy Services From Sep-2010 to Till date

 Educational Qualifications

ü        Master of Computer Application with Distinction from JNTU

Project Experience Summary

Project #1

            Title                : App-Support

            Client              : GE-HealthCare

            Role                : ETL Tester.

            Environment   : HP-QC, Oracle 10g, Teradata, UNIX.

            Team                           : 5

            Description:

The Functional scope of 1GLA BI apps is that it has General ledger and sub ledger transactions for GLPROD, BIOPROD and PROD ERP sources and design to brings in the Inventory (WIP) and Inter-company (GL) tables into the ODS environment for retirement of the existing Prep prod oracle code.The concept of 1GLA system is to streamline all the transaction data (General Ledger (GL) and Sub-Ledger (SL)) from various ERP systems in GEHC.

            Responsibilities:

ü       Understanding the Business requirements and map these to the Solution design.

ü       Create test cases and perform manual testing as per requirements.

ü       Preparation of the test data scenario/request for the functional testing.

ü       Validations are done to Data Extraction logic /Validate Data loading

ü       Test end to end data flow from source to Target.

ü         Involved in SCD Type 1 and SCD Type2 Testing.

ü       Check for accuracy, completeness (missing data, invalid data) and inconsistencies

ü       Co-ordination with onshore and offshore counter parts/Deriving Test Metrics from Execution Results.

ü       Well known of Executing the test cases through HP-QC and evaluating the outcome to check and ensure the application functionalities are working fine and raising defects in HP-QC.

Project #2:

            Title                : Parts at Risk Sourcing

            Client              : GE-HealthCare

            Role                : ETL Developer.

            Environment   : HP-QC, Oracle 10g, Teradata, Cronacle, UNIX.

            Team                           : 2

Description:
                        The Finger chart Data Tool will obtain data for calculation and display directly from the PAR Support Central Workflow Process, Manual Data Input, and the Data Warehouse(s) which provide periodic static views of the data from the Material Work systems(s), as determined by the definition of each data item.   Data feeds should be updated daily, unless the refresh rate of the data does not warrant updating daily (i.e. if the data refreshes weekly in a data warehouse there is no value in updating it daily, it should match the refresh period for the data source).

            The Finger chart Data Tool will provide for manual data input/control mechanisms as specified, where data cannot be provided by or is not usable when obtained from the Material Work systems(s).  This data will be used to replace/override data obtained from the Material Work systems(s)

            Responsibilities:

ü       Understood the business requirements.

ü       Extensively used Informatica Power Center for loading the data from various sources involving flat file and Oracle tables.

ü       Data Extraction, Transformation and Loading using Informatica for fact and dimension tables.

ü       Developed mappings, sessions and workflows as per new requirements.

ü       Most of the transformations were used like Source qualifier, Aggregators, expression, lookups, Router, Sequence Generator and Update strategy.

ü       Worked on Informatica client tools – Data warehousing designer, Workflow manager, and Workflow Monitor and Repository manager.

ü       Creation of unit test cases and unit test data.

Project #3:

            Title                : ADW Shipments

            Client              : Procter and Gamble, USA 

            Role                : ETL Tester.

            Environment   : Informatica Power Center 8.6, Oracle 10g, UNIX.

            Team                           : 4

            Description:

            Procter & Gamble (P&G) headquartered out of US is a largest manufacturer of product ranges including   personal care, household cleaning, laundry detergents and prescription drugs. With the increased volume of shipments originating from Gillette transactions, existing distributed Central Data Warehouse platform did not have capacity to meet required SLA. Project involved activities required to migrate P&G shipments to the new Atomic Data Warehouse (ADW) platform thereby enhancing Shipment Service line capability to provide combined P&G and Gillette Shipment reporting from ADW. This is being achieved by executing design, build, validation and deliveries of daily &monthly ETL for complete Shipment data from multiple geographic regions into ADW, followed by Analytics

  Responsibilities:

ü       Understanding and analysis of the business and functional specifications of Order Interface application and its related components.

ü       Develop/Execute ETL Test cases to validate business requirements.

ü       Data validation per business requirements.

ü       Take and implement initiatives for test process improvements and quality of work.

ü       Involved in SCD Type 1 Testing.

ü       Provide timely updates on tasks to project lead/management teams.

ü       Drive meetings/walkthrough session/group meetings.

Project #4:

Title                : Data Warehouse of Retail Sales Analysis.

            Client              : Decorize Stores Limited, Newzealand.

            Role                : ETL Developer.

            Environment   : Informatica Power Center 8.6, Oracle 10g, UNIX.

            Team                           : 6

            Description:

                        This project is for Retail Business covering the consumer products. Data Warehouse designed for the purpose of Sales Analysis that basically helps the decision makers to analyze the sales patterns using the following business angles or dimensions. Product Wise, Branch Wise, Promotion Wise, Customer Wise, Supplier Wise, Time Wise, Region wise. 

Responsibilities:

ü       Requirement gathering and Analysis of the same.

ü       Involved in both development and Testing.

ü       Extraction, Transformation and loading of data from Oracle sources into Target database.

ü       Created ETL Mappings that extract data from the source system and loaded into the Data Mart.

ü       Extensively used different transformations like Source Qualifier, filter, Aggregator, Expression, Sequence Generator, Router and Update Strategy.

ü       Extensively worked on Informatica Designer, Workflow Manager and Workflow Monitor.

ü       Creation of unit test cases and unit test data.