SUMMARY OF QUALIFCATIONS:

• Seven+ years of total IT experience in Testing of Data Warehouse (ETL/BI) applications
• Strong experience in preparing test strategy, designing test plans, writing test cases, developing test scripts by decomposing business requirements and develop test scenarios to support quality deliverables.
• Experienced in Agile/ Sprints, Waterfall and V-Model Process.
• Experience in different types of testing which includes System Testing, Integration Testing, Regression Testing, Performance Testing, UAT Testing.
• Sound knowledge in Data warehousing concepts and processes
• Strong knowledge of working with different dimensional modeling's i.e. Star Schema and Snowflake Schema
• Experience of using ETL tools like Informatica power center / IBM Datastage/ Microsoft SSIS and Reporting tools like IBM Cognos/ SAP Business objects etc.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• Experience in testing/validating the Source, Stage and Target (End-to-End)
• Proficient in Data Warehouse testing like Control Mechanism of batch loads, Error/ rejected records processing, testing of SCD implementations and process dependencies.
• Experience of using different databases like Oracle/DB2/SQL Server/Netezza
• Excellent analytical and SQL writing skills to address different business scenarios.
• Experienced in validating the reports generated based on the reporting tools like SAP Business Objects and IBM Cognos
• Well experienced in working with test management tool HP Quality Center (QC)/ Team foundation Serve (TFS)used in different phases of testing.
• Good experience in working Windows and UNIX environment
• Responsible for conducting walk-through meetings and test plan, test case, defect status review meetings with development team and business team.
• Responsible for creating weekly status reports and effort estimates for testing activities.
• Good sense of teamwork, leadership quality, integrity, aptitude to learn and ability to put in sustained quality effort consistently.

TECHINCAL SKILL SET:

• ETL Tools: Informatica Power Center 9.1/8.6.1/7.1, IBM Datastage 7.0/Microsoft SSIS 2005/2008
• Business Intelligence Tools: IBM Cognos 8.1.1, Business Objects XI R3/R2,
• Databases: Oracle 10g/9i/8i, IBM DB2, IBM Netezzza, MS SQL Server 2008
• Testing Tools: HP Quality Center 10.0/9, Test Director, Team Foundation Server (TFS)
• Programming Languages: SQL, PL/ SQL, UNIX Shell Scripting
• Operating Systems: UNIX, Linux, Windows XP/2000/98/95
• Other Tools: Microsoft Suite (Excel, Word, Power Point, Visio), VSS, PVC, SQL*Loader and TOAD for Oracle /DB2

Educational Qualifications:

• Bachelor of Engineering inComputer Science.

PROFESSIONAL EXPERIENCE:

Client: Confidential, Austin, Texas
Duration: Aug '10 - Till Date
Role: Sr.ETL / BI QA Test Analyst /Lead

• Designed & Created High level test plan
• Referred Technical Design document, Source to Target Detailed mapping document & Transformation rules document to derive test cases for functional testing.
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Involved in verifying the readiness of the system before starting process
• Focused on Data Quality issues and problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Worked with Data Completeness, Data Transformation, Data Quality and Integration Testing for different line of feeds.
• Worked with developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Involved in extensive end to end DATA validation and back-end testing using SQL queries.
• Developed test data to satisfy all business rules
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Used TOAD GUI tool for querying oracle database.
• Tested Business Objects Reports functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
• Validated all the jobs and successfully system tested the jobs.
• Involving in Functional testing, End to End testing and Regression Testing.
• Used HP Quality Center to store Requirements, Test Cases, and Test results and Defect management.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

Environment: Informatica Power Center 8.6.1, Microsoft SSIS 2008, Oracle11g,Netezza, SQL, SAP Business Objects XI, TOAD for Oracle 10, SQL Server 2008, HP Quality Center 10,Team Foundation Server (TFS)

Client: Confidential, McLean, VA
Duration: Oct '08 - June ‘10
Role: ETL/Reports Test Analyst

• Worked as a Quality Assurance Analyst in order to create test plan and test cases for manual and automated testing from the business requirements to match the project\'s initiatives.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify my test cases. Created and executed detailed test cases with step by step procedure and expected result. Maintained the test logs, test reports, test issues, defect tracking using Quality center 9.2.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Test Director. Perform black box testing by designing and constructing test cases, test data and test execution.
• Verify defects and Perform database functional, integration and regression testing as needed to minimize defects. Responsible for gathering requirements from the Subject Matter Expert (SME).
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Involved in the entire software development Life Cycle of the projects from Initiation to Implementation.
• Participate in weekly meeting with the management team and walkthroughs
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Tracked bugs using Test Director and generated the defect reports for review by the client and the management teams.
• Strong knowledge in Data Warehousing concepts, Data Modeling.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing (Informatica Power Center) of the flow and the logic for the Data warehouse project.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Performed execution phased: Executing test cases, identified products issues, wrote detailed bug reports and participated in bug review during the product development stages.
• Participated in Risk Management to help determine best use of development and testing resources. Used Quality center, to manage the entire process and log in defects. Provide update to management on testing status and some other issues
• Carried out and oversee test execution for Business scenario, User acceptance and Regression testing. Performed database validation according to the business logic by comparing the source to the target. Tested Data Warehousing application on Oracle Database.
• Tested the Reports generated by the Cognos and validated the data on the Reports
• (Cognos Cubes, Reports (Standard Reports / Adhoc Reports / Drill through Reports)
• Written several complex SQL queries for validating Cognos Reports.
• Expertise in validating Tested Complex Reports & Cognos Cubes by writing Complex SQL's according to business rules
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

Environment: Informatica 8.6, Oracle9i/10g, MS SQL Server 2005,Teradata, Quality center 9.2, Windows 9x/NT/2000/XP, UNIX, Cognos 8.1.3

Client: Confidential, New Jersey
Duration: April '07 - Sept'08
Role: ETL Tester

• Involved in the entire software development Life Cycle of the projects from Initiation to Implementation.
• Create test plan and test cases for manual and automated testing from the business requirements to match the project\'s initiatives.
• Created and executed detailed test cases with step by step procedure and expected result. Maintained the test logs, test reports, test issues, defect tracking using Quality center 9.2.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify my test cases. Verify defects and Perform database functional, integration and regression testing as needed to minimize defects. Responsible for gathering requirements from the Subject Matter Expert (SME).
• Performed execution phased: Executing test cases, identified products issues, wrote detailed bug reports and participated in bug review during the product development stages.
• Participated in Risk Management to help determine best use of development and testing resources. Used Quality center, to manage the entire process and log in defects. Provide update to management on testing status and some other issues
• Carried out and oversee test execution for Business scenario, User acceptance and Regression testing. Performed database validation according to the business logic by comparing the source to the target. Tested Data Warehousing application on Oracle Database.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Tested the data which loads from Source to staging.
• Involved in SCD2 type dimension testing with start date and end date logic.
• Test the data which loads Weekly and Monthly.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD/Exceed.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• Tracked bugs using Quality Center and generated the defect reports for review by the client and the management teams.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Participate in weekly meeting with the management team and walkthroughs
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

Environment:IBM Datastage 7.0, DB2 8.0, Oracle 9i, Quality center, Windows 9x/NT/2000/XP, UNIX Shell scripting.

Client: Confidential, India
Duration: June '05 - Mar '07
Role: ETL Tester

• Prepared test cases for System Integration Testing
• Responsible to find out different DDL Issues and Report to DBA's using Test Director
• Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
• Developed SQL procedures to ensure compliance with standards and lack of redundancy, business rules and functionality requirement into ETL procedures.
• Participated in bug triage meetings with developers to validate the severity of the bug and responsible for tracking of the bug life cycle using TestDirector
• Communicated and Discussed with Developers about the status of each Data Quality Issues
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Assist with the user testing of systems (User Acceptance testing) developing and maintaining quality procedures, and ensuring the appropriate document is in place.
• Perform data driven testing and validated the test results.
• Used TestDirector to Report bugs and Data Quality Issues on each check sum and field validation Tests completed.

Environment: Informatica Power Center 6.2, Oracle 8/9, Test Director, Windows XP