SUMMARY:

• Pursued Master’s degree in Computer Science at University of Illinois Springfield.
• 5 years of Data warehouse testing experience.
• Good Experience with Test Plans, Test Cases, Test Scripts, Test Execution and defect status report through HP ALM/Quality Center.
• Used DataStage Director and SSIS and Informatica for monitoring ETL job status and reviewing log files.
• Involved in extensive DATA validation using SQL queries and back - end testing.
• Wrote complex SQL queries to test fact and dimension tables.
• 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.
• Experience developing Requirements Traceability Matrix ( RTM ) and capturing and updating Change Requests.
• Extensive use of TWS for scheduling jobs and loading temporary tables, fact and dimensional tables
• Significant experience with SQL queries involving DDL, DML, Joins, Set operators and Case statements.
• Experience with UNIX commands, VI Editor and FTP tools like Putty and Ultra Edit.
• Developed test cases, scripts and assigned defects to developers through HP ALM.
• Experience with System, Integration, Regression, Performance and User Acceptance Testing (UAT).
• Validated Cognos reports using SQL queries.
• Tested SSRS report cosmetics like font, color and headers.
• Executed SSIS packages and loaded target tables in SQL Server.
• Validated Stored Procedures using SQL queries involving joins and set operators
• Well Acquainted with software development methodologies including agile iterative development and scrum.
• Excellent written and verbal communication skills.
• Extensive experience with data warehouse concepts and technologies like OLTP, OLAP, Normalization, De-normalization, ETL, Data Models and Data marts.
• Experience with Microsoft office applications such as Word, Excel, Access, Outlook, PowerPoint.
• Experienced with White box testing, and Black box testing .

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/, Teradata 14/13, SQL Server 2008/2005, MySQL.

Testing Tools: ALM, Quality Center 10/9.2, TFS.

Programming: SQL, PL/SQL.

ETL Tools: Informatica 9/8, DataStage Director, SSIS.

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

Other Tools: Tivoli Work scheduler, ITG Request and Services, Profisee.

Reporting Tools: Cognos, OBIEE

Operating Systems: UNIX, LINUX, Windows.

PROFESSIONAL EXPERIENCE:

QA Analyst

Confidential, Phoenix, AZ

• Analyzed business requirements and developed test cases and test scripts.
• Involved in Capacity and resource planning and assigning tasks to the team.
• Experience working in an agile environment with bi- weekly sprint ad daily scrums.
• Created complex SQL scripts from scratch for testing ETL tables and Reports.
• Prepared Test Plan and Test scripts for the Business/Functional requirements.
• Wrote complex SQL queries to test fact and dimension tables.
• Upload test scripts to TFS.
• Performed smoke testing to ensure the stability of different QA environments.
• Created complex SQL scripts involving JOINS, FILTERS, Data type Conversion, CASE statements.
• Extensive experience with data warehouse concepts and technologies like OLTP, OLAP, Normalization, De-normalization, ETL, Data Models and Data marts.
• Performed End to end testing flow from source to Stage to Pstage(Common format) to Profisee(golden record) to Views to downstream Target files.
• Tested Views to check for the metadata, orphans and data validation to align with the underlying tables.
• Tested the golden provider data in PROFISEE UI to check if the data is mastered as per requirements.
• Report defects after reviewing test results and Track discovered defects and defect resolution in TFS.
• Validated Stored Procedures using SQL queries involving joins and set operators.
• Scheduling Defect Call with project team.
• Preparing Test data and reviewing with business for the test execution.
• Complete and submit Test summary report to the project team at the end of the test execution.
• Review and obtain test results sign off.

QA Lead/Data Analyst

Confidential, Pittsburgh, PA

• Participate in an analysis of Business and functional requirements.
• Provide estimates for the functional requirements.
• Monitoring team efforts offshore and daily status call reviews.
• Preparing Test Plan and Test scripts for the Business/Functional requirements.
• Upload test scripts to HP ALM.
• Validated Stored Procedures using SQL queries involving joins and set operators.
• Scheduling Defect Call with project team.
• Wrote complex SQL queries to test fact and dimension tables.
• Performed smoke testing to ensure the stability of different QA environments.
• Experienced in data integration, metadata management, ETL, data modeling tool sets.
• Performed regression testing, negative testing and assisted in UAT testing.
• Used TFS for bug tracking and reporting, also followed up with the development team to
• Verify bug fixes and update bug status.
• Tested the ETL Informatica mappings using complex SQL queries.
• Tested the performance of ETL jobs for several incremental loads.
• Performed smoke testing to ensure the stability of different QA environments.

ETL Tester/Data Analyst

Confidential

Eden Prairie, MN

• Developed test plans and test cases for functional testing based on the functional requirement documents.
• Used DataStage Director for monitoring ETL job status and reviewing log files.
• Wrote complex SQL queries to test fact and dimension tables.
• Performed smoke testing to ensure the stability of different QA environments.
• Experienced in data integration, metadata management, ETL, data modeling tool sets.
• Performed regression testing, negative testing and assisted in UAT testing.
• Used JIRA for bug tracking and reporting, also followed up with the development team to
• Verify bug fixes and update bug status.
• Used DataStage Director for monitoring ETL job status and reviewing log files.
• Used sub version repository (SVN) Tortoise to maintain the QA code hub.
• Performing data quality checks in source files like delimiters and date formats.
• Experience with various UNIX Commands for checking and manipulating files.
• Tested Cognos reports using complex SQL queries.
• Tested cosmetics in Cognos reports like font, size and color.
• Experience with scheduling of jobs using TWS (Tivoli work scheduler) to load the data into the test environment.
• Validates the data and reports the defects/issues thru JIRA tracking tool.
• Tested several data mart tables in the Oracle database using SQL and PL/SQL queries.
• Used Toad to query and validate the data loaded into Oracle tables.
• Executed ETL jobs and tested dimension and fact tables in the semantic layer.
• Experienced with querying Hadoop tables using Hive SQL queries.
• Experienced with testing big data and Hadoop tables.
• Developed test cases and SQL queries for validating ODI mappings.
• Executed ODI jobs and tested target tables in the Oracle database.
• Validated Stored Procedures using SQL queries involving joins and set operators.
• Used VI editor in Unix for creating and manipulating files.
• Developed shell script in UNIX and automated repeatable and regression test cases.
• Tested several data mart tables in the Oracle database using SQL and PL/SQL queries.
• Involved in extensive data validation using SQL queries and back-end testing
• Developed test cases and SQL queries for OBIEE reports and dashboards.
• Submitted weekly test execution and defect reports from ALM to project team.

Assistant Systems Engineer/ETL Analyst

Confidential

• Writing test plans and test scripts and complex SQL queries.
• Performed Requirement Traceability Matrix (RTM).
• Involved in functional, system, integration and performance testing.
• Tested the ETL Informatica mappings using complex SQL queries.
• Tested the performance of ETL jobs for several incremental loads.
• Performed smoke testing to ensure the stability of different QA environments.
• Used SQL Assistant to write and execute queries in the Teradata database.
• Developed test cases, scripts and assigned defects to developers through HP ALM.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Worked on both Data Migration and Data Integration project.
• Performed data quality checks in source files like delimiters and date formats.
• Used Informatica Power Center Workflow Manager to run Workflows.
• Tested flat file to table data validation in UNIX by running commands like wc, head and tail.
• Compared data between 2 UNIX files using diff command.
• Involved in interacting with UNIX Shell scripts.
• Used SQL commands like nvl, case and set operators.
• Used Toad for Oracle for querying Oracle database tables.
• Used Informatica Workflow Monitor to monitor workflows and review session log.
• Reported periodic project status and updates to the QA Lead and QA Manager.