SUMMARY

• 7 + years of IT experience in analyzing business requirements, development and execution of test cases and defect management.
• Experience with test plans, test cases, test scripts and customizing test data.
• Extensive experience with RDBMS technologies Teradata V2R6, Oracle 11i/10g/9i, IBM DB2 and MS SQL Server.
• Excellent experience with SQL concepts like DDL, DML, subqueries, joins, set operators and conditional expressions.
• Extensive experience with ETL tools Informatica Power Center, IBM Datastage and Ab Initio.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in writing and executing SQL and PL/SQL statements.
• Experience in testing Business Intelligence reports generated by various BI Tools like Micro Strategy, Cognos and Business Objects.
• Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS).
• Experience in developing Requirement Traceability Matrix.
• Experienced in Manual and Automated testing using QTP, Win runner.
• Extensively used Quick Test Pro methods to create automated scripts.
• Created object repository, common library and application specific library functions using VB Script for automation in QTP and modified as per framework and design changes.
• Experience with bug tracking tools like Quality Center and Clear Quest.
• Extensive experience with testing transformations like joiner, filter and look up.
• Experience with testing reports like Drilldown and Cross - Tab reports.
• Extensive experience in Functional Testing, System Testing, Integration Testing, Regression Testing, Performance testing and User Acceptance Testing.
• Involved in all the phases of Software Testing Life Cycle.
• Experience in UNIX commands and shell scripting.
• Exceptional ability to quickly master new concepts, very co-operative team player, fluent communicational skills, and interpersonal skills, innovative and self-motivated.

TECHNICAL SKILLS

Operating Systems: Windows Vista/XP/NT/2003/2000, Linux and UNIX

Databases: Oracle 11i/10g/9i/8i, MS SQL Server 2008/2005/2000 , IBM DB2 8.1, Teradata V2R6, MS Access 2008

Database Utilities: Toad, SQL Assistant, SQL Server Management Studio, SQL* Plus, SQL Developer

ETL Tools: Informatica Power Center 8.5, Ab Initio, Datastage

Languages: SQL, PL/SQL,Unix Shell Script, C

Testing Tools: Quality Center 9.2, Test Director, Rational Clear Quest

Reporting Tools: Micro Strategy 8.0, Cognos, Business Objects XIR2

PROFESSIONAL EXPERIENCE

Confidential, Oakbrook, IL

ETL QA Tester

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Participated in workflow migration from development to QA and to UAT environments as required.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drilldown and Crosstab reports.
• Developed test cases and scripts for ETL rules in Quality Center Test Plan.
• Interacted with DBA for setting up QA environment.
• Developed Test scripts for Functional, Regression and Data Driven Tests Using QTP.
• Performed enhancements to QTP scripts.
• Executed SQL queries using SQL Assistant to validate data mart tables.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Used Informatica Power Center Workflow Manager to run Workflows.
• Used Informatica Workflow Monitor to monitor workflows and review session log.
• Tested the ETL Informatica mappings using complex SQL queries.
• Extensively tested several OBIEE reports for data quality, fonts, headers & cosmetic
• Involved in testing the OBIEE reports by writing complex SQL queries.
• Worked with Users to develop Test cases for user acceptance testing.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Used Toad for Data Analysts to compare Oracle and Teradata databases
• Created Unix Shell Scripts for Data Centric applications
• Written several complex SQL queries for validating OBIEE Reports.
• Validated target table after extracting the data from source tables by running SQL queries using TOAD.
• Attended daily QA status and defect meetings.

Environment: Informatica Power Center 8.5, Teradata V2R6, Oracle 11i, TOAD for Data Analysts, Teradata SQL Assistant 6.0, MLOAD, SOAPUI AGILE, Java, J2EE, XML, Window NT/XP, JSP, JDBC, HTML,, SQL Assistant 6.0,QTP, SQL Server 2005, HP Quality Center 9.2, SQL/PLSQL, OBIEE, UNIX, Agile, Windows XP

Confidential, MN

ETL QA Tester

Responsibilities:

• Conducted and participated in the Business requirements meetings, Design review meetings and Quality Assurance.
• Wrote and executed Test Plan, Test Scripts/Test Cases.
• Performed the functional testing, integration testing, system testing and regression testing on the application thoroughly executing the manual/automation testing scripts/test cases.
• Organize, prioritize, and handle multiple tasks/assignments/projects.
• Wrote and updated as Requirements Tractability Matrix (RTM) as per the changes and requirements.
• Developed automated test script using Object Repository using QTP for Functionality and Regression tests.
• Developed and modified QTP test scripts using both a keyword driven approach as well as scripting using VBScript.
• Developed Requirement Traceability Metrics (RTM) using Quality Center.
• Converted the manual test cases to automated scripts using QTP stored in Team Foundation Server (TFS).
• Extensively worked on Descriptive Programming and Regular Expression to handle the Dynamic objects.
• Parameterized property values for objects and checkpoints in QTP.
• Logged defects in TFS. Actively involved in the resolution of defects with the development teams.
• Experienced in export/import the data from TFS to MS-Excel/Word and vice versa.
• Worked on TFS for requirements management, planning, scheduling, running tests, defect tracking, manage the defects and executing the test cases.
• Conducted cross browser testing to check the compatibility of the AUT with different Browser’s (IE, Mozilla).
• Participated in the team meetings to discuss the issues arising during the various stages of testing.
• Opened and Updated defect status in Quality Center.
• Wrote and executed SQL queries to create data, extract data and validate the process.
• Followed Agile Methodologies.

Environment: Java, Hibernate, Spring, SOAPUI AGILE, Java, J2EE, XML, Window NT/XP, JSP, JDBC, HTML, Team Foundation Server (TFS), Quality Center, QTP, Unix, Oracle, Toad, Load Runner.

Confidential, Minneapolis, MN

QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Written the SQL scripts to validate ETLs developed by Informatica.
• Testing Datastage ETL jobs using complex SQL queries.
• Used Datastage Director to run and monitor the ETL job status.
• Reviewed log files for ETL jobs in Datastage Director.
• Experience in preparing the traceability matrix, test scenarios and test cases.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics,
• Defect Report and requirement traceability using Test Director.
• Reviewed the test cases written based on the Change Request document.
• Tested data migration to ensure that integrity of data was not compromised.
• Experienced in writing complex SQL queries for testing data in oracle targets.
• Worked on issues with migration from development to testing.
• Prepared test data to validate ETL rules wherever necessary.
• Accessed source files from UNIX environment.
• Written several complex SQL queries for validating Business Objects Reports.
• Write SQL to validate Drilldown and Cross-Tab reports developed by Business Objects.
• Validated reports cosmetic like color, size in Business Objects reports.
• Reviewed the test cases written based on the Change Request document.
• Preparation of System Test Results after Test case execution.
• Developed SQL* loader scripts to load the data into the custom tables.

Environment: Oracle 10g, Datastage 7.0, QTP,Test director, SQL, Quality Center,Unix, Toad, Business Objects, MS Office, Windows XP

Confidential, Baltimore MD

QA Tester

Responsibilities:

• Created Test Case documents in MS Excel template from the Test Plan, and the Business Requirements documents.
• Validated Informatica ETL mappings using Source to Target mapping document.
• Experienced with Informatica Power Center workflow manager and workflow monitor.
• Used Informatica workflow monitor to monitor workflows and review session log files.
• Validated ETL jobs using SQL and PL/SQL queries.
• Validated referential integrity between dimension and fact tables.
• Exported Manual Test Cases from MS Excel to Mercury Test Director and executed Test Cases in Test Director with Pass/Fail.
• Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.
• Participated in frequently held Defect Meetings which included Project Management, QA and Development
• Performed Functional, Regression, Data Integrity, and User Acceptance Testing.
• Used UNIX to access the log files and parameter files.
• Performed the back end testing by using SQL Queries and verified the data integrity.
• Validated cosmetics like font, color, size in Cognos reports.
• Written SQL queries to validate the data in Cognos reports.
• Validated DrillDwon and CrossTab reports developed by Cognos.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.
• Participated in weekly meeting with the management team and walkthroughs.

Environment: Informatica Power Center 7.0, Oracle 9i,Windows NT/XP/2000, SQL Server 2000, Test Director, Cognos, MS Office Suite, SQL