SUMMARY

• Over 7+ years of experience in testing Data Warehouse ETL and Reporting tools with extensive knowledge in ETL and OLAP processes.
• Extensive experience in Mercury Quality Centre(QC),TFS and Clear Quest
• Used for logging the defects, tracking the defects and resolving the defects QC,TFS,CQ
• Worked with SDLC process like water fall model, AGILE methodology
• Worked Web based .Net, Java application testing.
• Expertise in Testing Data Marts and ETL, OLAP, Reporting and Documentation.
• Involved in leading and participating in the full software life cycle for testing activities
• Experience of ETL testing process including Type1 and Type2 and Type 3 changes
• Worked with Database migration Testing experience in different versions of Informatica
• Worked closely with business analysts, programmers, and end users in a cross functional team
• Experience in coordinating efforts between development teams and offshore enterprise test team
• Created test plans, test data for extraction and transformation processes and resolved data issues following the data standards
• Hands on experience with DW - ETL Testing, BI Reporting tools Business ObjectsCognos and Microstrategy
• Experience in Preparation of Test Plans, Test Scenarios, Test Cases and Test Data from requirements and Use Cases
• Strong OLTP and OLAP Testing experiencegood knowledge on Star schema and Snow flex schema
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities
• Experience theETLBatch jobs sessions and workflows
• Good knowledge of Data Modeling and ER Modeling, Star Schema and Snowflake schema Strong experience on Report testing Cognos and Business objects
• Good knowledge on Star schema, snowflake schema, Fact tables and Dimension tables
• Good Experience in peer review of test cases and Preparing Test Reports
• Good experience in UNIX and Windows platform, experience with Unix Batch processesand Shell Scripting
• Expertise in Testing ETL application using tools Informatica, Data stage and Abinitio
• Expertise in Testing BI Reporting using tools Business Objectsand Cognos and knowledge on Microstrategy
• Good Experience in review of test cases and Preparing Test Reports

TECHNICAL SKILLS

Testing Tools: HP Quality Center (QC), TFS, Test Director, Jira

Databases: Oracle 8i/9i, 10g, SQL Server, Teradata

ETL Tools: Informatica, Data stage, Abinitio

Reporting Tools: Cognos, Business Objects and Microstrategy

Scripting Languages: Java Script, Shell Script, Perl Script

Languages: C, C++, Java,.Net, VB

GUI Tools: Erwin, TOAD, Teradata SQL Assistant

Operation Systems: Windows, UNIX, Linux, Solaris.

PROFESSIONAL EXPERIENCE

Confidential, NY

QA Tester

Responsibilities:

• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Responsible for creating Test cases, Test data based on functional and non-functional requirements (i.e. Interfaces) to test the graphs
• Wrote Complex SQL queries to verify report data with the source and target system (data warehouse)
• Preparing the SQL queries to fetch the data from databases.
• Involved in BA walkthroughs and ETL Specification Document.
• Working with Fact and Dimension tables and Surrogate keys and version numbers
• Assisted business users to execute UAT test scenarios and test data as part of JVT (Joint Validation Testing)
• Effectively learnt all modules and trained new resources.
• Preparation of test scenario’s and test cases based on Mapping documents
• Worked with DDL, DML and DCL commands for creating and updating data into database
• Validated the Summary and detail reports with drill down options
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.
• Validating the data against staging tables and warehouse
• Find report defects and subsequently validating the fix, repeating the process until done.
• Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
• Perform system testing to ensure the validity of the Report requirements and mitigation of risks prior to formal acceptance.
• Working with Clear Quest and Quality center for logging the defects, tracking the defects and resolving the defects
• Performed Interface and Integration(SIT) Testing
• Extensively use SQL queries for data validation and back end testing.
• Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Track Sheet Maintenance and map the use case to requirement.
• Monitor Testing Activities within the team and report regular progress to the Test Manager.
• Work closely with the software engineers to ensure successful, high quality releases.
• Preparing the SQL queries to fetch the data from databases.

Environment: Agile Test Methodology, Oracle 10g, TOAD, Informatica 8.6, HP Quality Center 10.0, SQL,T-SQL, PL/SQL, Cognos 8.0 Series, SQL server 2008, JIRA, Microsoft TFS, MS Suite, UNIX, Shell Scripting

Confidential, Minneapolis, MN

QA Tester

Responsibilities:

• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Worked with Enterprise Tax Management (ETM) V2.2
• Involved in leading and participating in the full software life cycle for testing activities
• Responsible for creating Test Plans, Test cases, Test data based on functional and non-functional requirements (i.e. Interfaces) to test the Cognos reports
• Generated reports from Cognos data warehouse system and used HP Quality Center for test cases execution and defect tracking.
• Work closely with the software engineers to ensure successful, high quality releases.
• Responsible for ETL batch jobs execution using IBM Tivoli application to load data from core database ( ETM database) to Staging and Data mart tables.
• Wrote Complex SQL queries to verify report data with the source and target system (data warehouse) data.
• Assisted business users to execute UAT test scenarios and test data as part of JVT (Joint Validation Testing)
• Effectively learnt all modules and trained new resources.
• Preparation of test scenario’s and test cases based on FD and TD documents
• Execution of Generating and validating the Cognos reports based on functionality
• Validated the Cognos Reports against Data warehouse
• Worked with DDL, DML and DCL commands for creating and updating data into database
• Verifying the Cognos Report functionality and Layout specifications based on report requirement document
• Validated the Summary and detail reports with drill down options
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.
• Validating the data against staging tables and warehouse
• Find report defects and subsequently validating the fix, repeating the process until done.
• Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
• Perform system testing to ensure the validity of the Report requirements and mitigation of risks prior to formal acceptance.
• Performed Interface and Integration(SIT) Testing
• Extensively use SQL queries for data validation and back end testing.
• Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Track Sheet Maintenance and map the use case to requirement.
• Monitor Testing Activities within the team and report regular progress to the Test Manager.
• Work closely with the software engineers to ensure successful, high quality releases.
• Preparing the SQL queries to fetch the data from databases.

Environment: Informatica 8.6.1, SQL Server 2005, Quality Center 10.2, QTP, Auto sys, DTS, TSQL,SQL, Teradata V2R6, TOAD, SQL Assistant 6.0, PL/SQL, Cognos ReportNet8.0, Microsoft Visio 2003

Confidential, Rochester, MN

Sr Tester

Responsibilities:

• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Provided review comments on Test Scenarios and Test Cases based on Functional Requirement specifications
• Prepared Test Cases and Test Scenarios based on Functional Specification Document, Use Cases.
• Performed Sanity Testing, Data Driven Testing & Ad-hoc testing as required.
• Performed System Testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.
• Performed Interface and End to End Testing
• Performed User Acceptance Testing with UAT test scenarios.
• Extensively used SQL queries for data validation and back end testing.
• Found and reported defects and subsequently validated the fix, repeating the process until done.
• Involved in Build deployment activities and participated in design (spec) reviews with the Core team.
• Worked closely with the software engineers to ensure successful, high quality releases.

Environment: Informatica 8.1, Oracle 11g, SQL Server 2005, HP Quality Center 9.2, SQL/PLSQL, Business Objects XIR2, TOAD, XML, XSLT, XML Spy 2008, Korn Shell Scripts, UNIX, Windows XP.

Confidential, Chicago, IL

QA ANALYST

Responsibilities:

• Involved in leading and participating in the full software life cycle for testing activities - from test planning, test execution to test monitoring, status reporting, documentation and data validation.
• Reviewed requirements documented (mapping document) by Business Analyst for thorough understanding of the application.
• Validated the data thru various stages of data movement from staging to Data Store to Data Warehouse tables.
• Created Test Cases using the SDLC procedures and reviewed them with the Test lead.
• Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
• Validated the external data source by connecting through Oracle heterogeneous services and joining them to existing tables and reporting the anomalies in the data.
• Tests included System Testing, Regression and Business Objects reports testing.
• Provided flexible & high quality support to wider Testing strategies on key regular deliverables & ad-hoc reporting issues.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validated the reporting objects in the reporter against the design specification document.
• Validated the data files from source to make sure correct data has been captured to be loaded to target tables.
• Validated the load process of ETL to make sure the target tables are populated according the data mapping providing it satisfied the transformation rules.
• Validated the Archive process to purge the data that met the defined business rules.
• ETL validation, Data Model Validation.

Environment: Informatica 7.1.4 and 8.1 Power Center, Oracle 8i, DB2, Toad, UNIX, Mercury Quality Center

Confidential

QA Tester

Responsibilities:

• Involved in test planning, writing test cases/scripts, test case automation and test execution.
• Documented test scenarios and test cases.
• Prepared ETL and SQL routines/code for performance ETL testing (system and
• Integration testing).
• Verified report data with source, field level data verification.
• Familiar with defect management systems
• Read and understood data model.
• Participated in Full Lifecycle Development on large projects.
• Understood Unit, Functional, System, Performance, Technical and Operational testing and the tools utilized.
• Knowledge of software development life cycle principles and awareness of Agile practices.
• Experienced with data migration testing, data validation testing.
• ETL tool testing & data integrity testing.

Environment: Informatica 8.1, oracle 9i, PL/SQl Developer, UNIX.