SUMMARY:

• Senior ETL test analyst with over 9 years of experience in software testing including all stages of Software Development Life Cycle SDLC and Software Testing Life Cycle STLC . Which includes around 6 years of onsite experience in USA and have experience working as offshore test lead, Experience includes testing ETL applications developed using Informatica and Reports developed using BO, Cognos. Expertise includes creating and executing SQL queries. Experience includes Integration, Functional, Regression, System Testing, UAT Testing, Black Box, GUI testing and White box testing.
• Experience with Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Experience querying and testing RDBMS such as Oracle, MS SQL Server, Teradata and Netezza using SQL, PL/SQL for data integrity.
• Experience in SQL and UNIX shell scripting. Experience in preparing Test plan and test scripts.
• Experience in using HP Quality Center for Bug Tracking and Defect Reporting.
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports.
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.

TECHNICAL SKILLS: Operating systems Windows XP/NT, UNIX Testing Tools Quality Center, QTP RDBMS Oracle, Teradata, SQL server, Netezza Reporting Tools Business objects, Cognos, SSRS ETL Tools Abinitio, Informatica, SQL SERVER DTS PROFESSIONAL EXPERIENCE: Confidential , Los Angeles, CA Sr. ETL Test Analyst

• Analyzing the functional requirements document and technical design document and business data dictionary.
• Confidential had a merger with MUFG of Japan,The project deals with the reports generated to be sent to the Japanese regulators,The data regarding the different modules will be pulled from the source systems and leaded to Raw and clean tables and then to the BDW and to the data mart and reports
• Involved in preparing the test plan and test scenarios and test cases.
• Involved in setting up of the test environment.
• Involved in creating executing SQL commands and UNIX shell scripts. Involved in testing the initial and incremental load. Involved in testing fact. Dimension and lookup tables. Involved in performance and security testing of the reports. Involved in assigning defects to developers and regression testing the defects once the defect is fixed, then closing the defect.
• Used Mercury Quality Center as test management tool.

Environment: Informatica, Quality Center, Greenplum and QTP. Senior ETL Test Analyst

• Analyzing the Business requirements and planning Tests, Estimation, and test case creation. Involved in analyzing the mappings and the transformations in the CDMA mapping doc and prepared the SQL queries Involved in testing the business intelligence reports developed using cognos Involved in Creating executing SQL queries and UNIX shell scripts. Validated all the dimension, fact tables and lookup tables for the accuracy of the data loaded. Involved in assigning defects to developers and regression testing the defects once the defect is fixed, then closing the defect. Responsible for Test Reports and Test Execution Summary to the management. Used rational quality manager to update and execute the test cases
• Confidential provides health insurance to customers, As a part of new affordable federal health care policy, New changes have been proposed to the existing health care policy being offered the customers of CDPHP,In order to reflect the changes new proposal is made to enhance and change the existing code and implement the new policy,As part of this changes are made to the facets front end application and the backend EDW application to get the functionality added as part of health care affordable act

Environment: Informatica, Rational quality manager, oracle, Tidal, Linux.

Senior ETL Test Analyst Confidential is one of the world's leading suppliers of the fast-moving consumer goods, the project deals with the testing of the data warehouse applications built for the business intelligence Analyzing the Business requirements and planning Tests, Estimation, and test case creation. Tested Initial load delta load to make sure updates are happening accurately from source to target and validated history tables. Involved in Creating executing SQL queries and UNIX shell scripts. Involved in manual and automation testing of the web applications developed for front end. Validated all the dimension, fact tables and lookup tables for the accuracy of the data loaded. Involved in Testing of SSRS reports generated by verifying the measures generated, font, header, footer, page layout, graphs, dashboards, charts, and filter, conditions, breaks, sorting, Drill Down and hyper links. Involved in performance and security testing of the reports generated using SSRS. Involved in assigning defects to developers and regression testing the defects once the defect is fixed, then closing the defect. Providing the daily testing status to the client at the end of the business day through teleconference.

• Used Mercury Quality Center as test management tool to manage and organize Requirements Coverage, Test Case Management, Test Execution and Defect Management.
• Environment: Informatica Quality Center, Teradata, SSRS, SQL server, QTP, UNIX.

Sr. ETL Test Analyst

• Analyzing the functional requirements document and technical design document and business data dictionary.
• The project deals with the testing of the data warehouse applications built for the business intelligence purpose.
• Involved in preparing the test plan and test scenarios.
• Involved in setting up of the test environment.
• Involved in creating executing SQL commands and UNIX shell scripts. Involved in testing the initial and incremental load. Involved in testing fact. Dimension and lookup tables. Involved in performance and security testing of the BI reports. Involved in assigning defects to developers and regression testing the defects once the defect is fixed, then closing the defect.
• Used Mercury Quality Center as test management tool.

Environment: Confidential Test Analyst Allstate provides Auto, home, life and commercial insurance, Project deals with the end to end testing of a large scale data warehouse built for the business intelligence purpose, involved the whole testing life cycle for the various modules of the application. System, Integration, Acceptance, regression and Functional/Black-Box testing and testing of oracle financial applications. Involved in the Requirement gathering from the Business team. Developed Test Plan, Test scenarios, test cases. Involved in assigning the tasks to the team members. Involved in ETL Extract, Transform and Load testing. Verified data quality by employing SQL and PL/SQL queries for data integrity. Involved in the testing of Oracle financial modules. Involved in testing of reports generated using Cognos. Responsible for Test Reports and Test Execution Summary to the management. Environment: Informatica, Crystal reports, Quality Center, Oracle. QA Analyst Confidential is the 7th largest Confidentialcommercial insurer and the 13th largest Confidential. property casualty insurer which provide insurance protection to more than 1 million businesses and professionals in the Confidential. and internationally. Project deals with the end to end testing of a large scale Data Warehouse built for the Business Intelligence purpose, involved the whole testing life cycle for the various modules of the application. System, Integration, Acceptance, regression and Functional/Black-Box testing. Participation in planning Tests, Estimation, and Execution. Designing Test Scenarios and Test Cases. Involved in ETL Extract, Transform and Load testing. Review of Test plan, Scenarios and Test cases. Involved in automation testing of web applications. Involved in the testing of Oracle financial modules. Involved in testing of reports generated. Defect Management, Reporting and Tracking to closure. Test results, Status updating and quality deliverables to the client. Environment: Informatica, Business Objects Quality Center, Oracle. ETL QA Analyst First Marblehead provides student loan services to different banks in US, Project deals with the origination of loans and servicing of loans and securitization of loans and the data required for the capital markets and improving the Loan Services ETL environment associated with ODS and Data Warehouse and reporting purpose and testing of web applications developed for Pricing and involved testing of oracle financial applications. Involved in the Requirement gathering from the Business team. Developed Test Plan, Test scenarios, test cases. Involved in assigning the tasks to the team members. Involved in ETL Extract, Transform and Load testing. Verified data quality by employing SQL and PL/SQL queries for data integrity. Involved in the testing of Oracle financial modules. Involved in testing of reports generated using Cognos. Responsible for Test Reports and Test Execution Summary to the management. Environment: Informatica, BO, Quality Center, Oracle. ETL QA Analyst Project deals with the testing of data warehouse for the sales analysis purpose, warehouse developed using informatica and business objects as reporting tool, Involved in the Requirement gathering from the Business team. Developed Test Plan, Test scenarios, test cases. Involved in assigning the tasks to the team members. Involved in ETL Extract, Transform and Load testing. Verified data quality by employing SQL and PL/SQL queries for data integrity. Involved in the testing of Oracle financial modules. Involved in testing of reports generated using Cognos. Responsible for Test Reports and Test Execution Summary to the management. Environment: Informatica, BO, Quality Center, Oracle.Teradata Database Test Analyst Project deals with the origination of loans and servicing of loans and securitization of loans and the data required for the capital markets and improving the Loan Services ETL environment associated with ODS and Data Warehouse and reporting purpose and testing of web applications developed for Pricing Developed a road map by understanding the business logic and User Requirements for Test execution. Designing Test Scenarios and Test Cases.Analyzing the AbInitio graph Error log files to find out the specific error if graph fails. Balancing all the counts and Balances of Account files in different stages of Data Migration like Source, Pre AbInitio, Post AbInitio, Data load to ODS and Data warehouse. Copying Input data files from ACS to UNIX test server and Pre-Prod server using FTP and validating the Data. Involved in testing of reports generated. Defect Management, Reporting and Tracking to closure. Test results, Status updating and quality deliverables to the client. Environment: AbInitio, Test director, Crystal Reports, SQL Server.