SUMMARY

• Extensive experience with development of test cases and test scripts and test execution.
• Experience with backend testing, database testing and data warehouse testing.
• Experience with defect management, test execution report and defect status report thru HP ALM/Quality Center.
• 6+ years of experience in RDBMS technologies like Oracle, Teradata V2R6, DB2 and MS SQL Server.
• Excellent experience with SQL queries involving DDL, DML, Joins, Set operators and Case statements.
• Extensive experience with data warehouse concepts and technologies like OLTP, OLAP, Normalization, De - normalization, ETL, Data Models and Data marts.
• Good experience with Software Development Life Cycle methodologies waterfall and agile.
• Extensive experience with database utility tools TOAD for Oracle, SQL Server Management Studio, SQL Developer and SQL Assistant.
• Experienced with ETL tools - Informatica Power Center and Data stage.
• Experience with Reporting tools Crystal Reports, Business Objects and Micro Strategy.
• Experience with UNIX commands, VI Editor and FTP tools Putty and WinSCP.
• Experience developing Requirements Traceability Matrix (RTM) and capturing and updating Change Requests.
• Experienced with System, Integration, Regression, Performance and User Acceptance Testing (UAT).
• Experience with Microsoft office applications such as Word, Excel, Access, Outlook, PowerPoint and Project.
• Experienced with White box testing, and Black box testing.
• Experience with testing Dashboards and Drilldown, Cross Tab, Summary and Detail reports
• Good experience with Teradata utilities SQL Assistant, Bteq, Fast load and Multi load.
• Experience with programming languages SQL, PL/SQL, C and Java.
• Excellent problem solving, interpersonal, and communication skills.
• Good experience with large amount of data and large databases.

TECHNICAL EXPERTISE:

Testing Tools: ALM, Quality Center 10/9.2, JIRA, Clear Quest

ETL Tools: Informatica 9/8, Data Stage 8

Databases: Oracle 11g/10g/9i, Teradata 14/13, V2R6, SQL Server 2008/2005, MySQL, Hadoop

Utility Tools: TOAD 8.5, SQL Assistant, BTEQ, Fast Load, Multi Load, SQL Server Management Studio, SQL* Plus, SQL* Loader, SQL Developer

MS Office: Excel, PPT, Word, Access, Outlook, Project

Reporting Tools: Cognos, Business Objects XIR2, OBIEE

Programming: SQL, Hive, PL/SQL, T-SQL, C, Java

Operating Systems: Windows, Linux and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. QA Lead

Responsibilities:

• Written Test Script, Test Cases, Reported bugs and tracked defects using ALM/Quality Center.
• Used Informatica Power Center workflow manager for executing sessions and workflows.
• Used Informatica workflow monitor for monitoring workflows and reviewing session logs.
• Experienced in data integration, metadata management, ETL, data modeling tool sets
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Collected requirements and tested several business reports generated from Cognos.
• Extensively test the reports for data accuracy and universe related errors.
• Used Toad to query and validate the data loaded into Oracle tables.
• Developed test cases and SQL queries for validating ODI mappings.
• Executed ODI jobs and tested target tables in Oracle database.
• Used Toad for data analysts and SQL server Management Studio to query SQL server.
• Report defects after reviewing test results and Track discovered defects and defect resolution in Quality Center.
• Based on user requirements documented the test cases in Quality center.
• Generated test plans, test cases and test steps in Quality Center for Automated Testing
• Created and managed issues thru JIRA tracking tool.
• Discussed QA Testing requirements in QA Team walk through meetings.
• Used VI editor in Unix for creating and manipulating files.
• Validated table data using flat file by running Unix commands.
• Developed shell script in UNIX and automated repeatable and regression test cases.
• Developed complex SQL queries for testing several ETL transformations.
• Executed ETL jobs and tested dimension and fact tables in semantic layer.
• Experienced with Mark logic NoSQL database.
• Experienced with querying Hadoop tables using Hive SQL queries.
• Experienced with testing Big data and Hadoop tables.
• Experienced with testing Medicare and Medicaid claims.
• Experienced with validating edi transactions, in network and out of network claims.
• Tested the reports like Drilldown, Drill up and pivot reports generated from Cognos.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Tested several data mart tables in Oracle database using SQL and PL/SQL queries.
• Involved in extensive data validation using SQL queries and back-end testing
• Submitted weekly test execution and defect reports from ALM to project team.

Environment: Informatica Power Center 8.1, Windows NT 4.0, Oracle 9i, SQL Server 2008, ODI, ALM, Quality Center 10, JIRA, SQL, TOAD, Hadoop, Hive, Big Data, Mark Logic, NoSQL, Cognos, MS Access, Flat Files.

Confidential, Denver, CO

Sr. ETL QA

Responsibilities:

• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for ETL Data Validation and Report testing.
• Developed validation steps and SQL using business requirements and rules.
• Updated test lead on change requests, test cases, SQL, execution and defect status.
• Scheduled and executed ETL jobs using Data stage Director.
• Analyzed the log file for an ETL job in Data stage Director and reported to developer.
• Interacted with DBA for setting up test environment in Oracle database.
• Executed SQL queries using Quest TOAD to validate ETL jobs.
• Developed and executed SQL queries in WinSQL tool for querying DB2 database.
• Tested Dimension and Fact tables in DB2 database using SQL queries.
• Written complex SQL queries and queried the Oracle database to test data stage ETL code.
• Involved in Regression, Functional, Integration and User Acceptance Testing.
• Performed database validation using SQL according to the business rules and specifications.
• Tested several complex reports generated by Cognos including Dashboard, Drill Down and Pivot.
• Created test data to test the functionality of the data stage jobs.
• Used VI Editor to access and manipulate files in UNIX.
• Used Unix Diff command to compare two text files.
• Experienced with UNIX commands like GREP, PS, WC and CHMOD.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Worked with Users to develop Test cases for user acceptance testing.
• Validated business reports like Drilldown and Crosstab reports developed by Cognos.
• Created and managed defects in Clear Quest tool.
• Used SQL Assistant tool to access Teradata database tables.
• Performed integration and performance testing on data stage ETL jobs.
• Used Database links in SQL for Querying the Oracle database.
• Involved in preparation of Defect Report using Clear Quest.
• Attended daily project status meetings and weekly QA status meetings.

Environment: Oracle 10g, Data stage 8, Quest TOAD, Teradata, SQL Assistant, Clear Quest, DB2, WinSQL, SQL, PLSQL, Cognos 8.0, UNIX, Windows XP.

Confidential, SFO, CA

ETL/BI Tester

Responsibilities:

• Performed data quality checks in source files like delimiters and date formats.
• Tested Informatica job schedules and execution in UC4 client.
• Developed test cases and scripts in Quality Center.
• 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.
• Tested the performance of ETL jobs for several incremental loads.
• Created excel Pivot reports for reporting the metrics and analyzing Data Quality.
• Used SQL Assistant to write and execute queries in Teradata database.
• Used Teradata utilities Fast Load and Multi Load for loading data from file to table.
• Written and executed BTEQ scripts for dumping data from Teradata table to flat files.
• Worked with complex SQL queries involving Joins, Sub Queries, Case statements and Set Operators.
• Created and tracked issues thru JIRA.
• Used SQL Assistant to import data from flat files to Teradata table.
• Used UNIX environment for accessing and validating source files.
• Performed data quality checks against Teradata tables like checking for natural key duplicates and checking decimal and timestamp precision.
• Created complex SQL scripts involving JOINS, FILTERS, Data type Conversion, CASE statements.
• Used Toad for Data Analysts for comparing data between Oracle and Teradata.
• Developed test cases and SQL queries for OBIEE reports and dashboards.
• Worked on multiple projects each running parallel with the other and with tight deadlines.
• Worked on both Data Migration and Data Integration projects.
• Tested font, color and headers in OBIEE summary and detailed reports.

Environment: Oracle 10g/11g, SQL Server 2008, TOAD 9.0, Windows 7, SQL, OBIEE, Putty, Informatica 9.0, MS Office

Confidential, Denver, CO

ETL/BI Tester

Responsibilities:

• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for ETL Data Validation and Report testing.
• Developed validation steps and SQL using business requirements and rules.
• Updated test lead on change requests, test cases, SQL, execution and defect status.
• Scheduled and executed ETL jobs using Data stage Director.
• Analyzed the log file for an ETL job in Data stage Director and reported to developer.
• Interacted with DBA for setting up test environment in Oracle database.
• Executed SQL queries using Advanced Query Tool to validate ETL jobs.
• Written complex SQL queries and queried the Oracle database to test Data stage ETL code.
• Involved in Regression, Functional, Integration and User Acceptance Testing.
• Performed database validation using SQL according to the business rules and specifications.
• Tested several complex reports generated by Business Objects including Drilldown and Pivot.
• Created test data to test the functionality of the data stage jobs.
• Written complex SQL queries to query DB2 database.
• Used VI Editor to access and manipulate files in UNIX.
• Used UNIX Diff command to compare two text files.
• Experienced with UNIX commands like GREP, PS, LS and CHMOD etc.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Worked with Users to develop Test cases for user acceptance testing.
• Validated business reports like Drilldown and cross Tab reports developed by Business Objects.
• Maintained the test logs, test reports, test issues, defect tracking using Clear Quest.
• Involved in preparation of Defect Report using Clear Quest.
• Performed integration and performance testing on data stage ETL jobs.
• Used Database links in SQL for Querying the Oracle database.
• Attended daily project status meetings and weekly QA status meetings.

Environment: Oracle 10g, Data stage 8.0, DB2, Clear Quest, SQL, PLSQL, Business Objects, UNIX, Windows XP.

Confidential

QA Tester

Responsibilities:

• Developed test cases in Test Plan module in Test Director tool.
• Testing Data stage ETL jobs using complex SQL queries.
• Used Data stage Director to run and monitor the ETL job status.
• Reviewed log files for ETL jobs in Data stage Director.
• 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 Test Director tool to document and manage defects.
• Participated in Defect Meetings which included Project Management, QA and Development teams.
• Used DDL commands for loading expected data into temporary tables.
• Used DML commands for customizing source data for testing mockup scenarios.
• Used SQL Minus operator for comparing data from source to target.
• Experienced with SQL queries involving joins, set operators and case statements.
• 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.
• Coordinated with the developers to resolve defects.
• Documenting test results in excel spreadsheet.
• Involved in documentation in order to maintain and run scripts for future enhancements.
• Participate in weekly meeting with the management team and walkthroughs.
• Created test execution and defect reports from Test Director.

Environment: Oracle 9i,Windows NT/XP/2000, Data Stage 6.0, SQL Server 2000, Test Director, MS Office Suite, SQL