Summary

• Over 7 years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server environments, Web based applications, Data Warehousing and Business Intelligence solutions.
• Excellent working knowledge of System Development Life Cycle SDLC , Software Testing Life Cycle STLC and Defect Life Cycle.
• Experienced in Functional testing, System testing, Application testing, Performance testing, Load testing, Integration testing, Regression testing, Black Box testing, Stress Testing, Smoke testing, Recovery testing, Reports testing, browser compatibility testing, UAT and GUI testing.
• Expertise in writing Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases, Test scripts, RTMs, Defect status reports, Test Summary report.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Center and Rational Clear Quest.
• Expert in writing complex SQL queries for back-end and Reports data validations.
• Have solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus and SQL Developer.
• Have tested several complex Reports generated by IBM Cognos, Business Objects, including Dashboards, Summary reports, Master detailed, Drill down and Score cards.
• Experience in testing the reports for both cosmetic static content and data validations as per Report specification documents.
• Experience on UNIX commands for file validation.
• Experience in Data Analysis, Data Cleansing Scrubbing , Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center DVO, DataStage, Ab Initio and SSIS ETL tools.
• Have experience in testing reconcile initial and delta daily loads.
• Experienced in using the Oracle SQL Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Knowledge on the phases of agile methodology and scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

Technical Skills

Professional Experience

Confidential

Sr. QA Tester/DWH ETL Tester/BI Tester

The data warehousing project of the group comprised of getting source data from NMS CQS Consolidated Quote System and OPRA Option Price Reporting Authority . National Market System exchange-listed, OTC and UTP securities with the Consolidated Tape Association Confidential and Consolidated Quotation CQ which Plans govern quote and trade dissemination for exchange-listed securities

Responsibilities:

• Understood the ETL Informatica mapping document and created the test ware.
• Run cross platform testing using SDLC Method: Waterfall, agile
• Performed the Extract Transform and Load ETL : source to target, utilizing Informatica Power center and Data Validation Option DVO .
• Develop and execute integration and regression test cases and scripts for each specific product group
• Wrote various documents describing DVO functionality, and how DVO should be used by group based on discussions with team lead.
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses
• Provide reporting of tests and test results from regular builds to the test lead
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Log and assign defects and keep track of the defect status
• Tested several data migration application for security, data protection and data corruption during transfer.
• Implemented Data Validation Option DVO for understanding on how to run tests, and evaluated the test results.
• Communicate and interact with different project teams and work on two different testing efforts in parallel.
• Created Data Driven tests using SOAP UI to test the web services with different inputs
• Tested data migration to ensure that integrity of data was not compromised
• Extensively used SQL queries/Unix commands for data verification and backend testing.
• Work with programmers during test summary and status calls to resolve defects
• Wrote Complex SQL queries to validate the standard reports, Dashboards and Business objects Universes.
• Prepare the Traceability Matrix for mapping the Requirements with the Test Cases via Navigator
• Responsible for bug reproduction cases and scenario

Environment: ETL Informatica DVO, BI Business Objects, HP Quality Center/ ALM, Oracle 11g, MS SQL Server 2008, SQL Server Management Studio, SSIS and SSRS.

Confidential

QA Tester/Backend Tester/Automation Tester

Responsibilities:

• Interacting with Business Analysts for Business Requirements, testing scope reviews, inspections and test planning.
• Designed DVO informatica test cases for source and target Database validation.
• Prepared Tractability matrix and prioritized test cases.
• Involved in creating Test Plans, Test Scenarios, Test Scripts based on business Requirements, Use cases and Functional Specifications in Test plan tab of Quality Center tool
• Create and maintain a Requirements Traceability Matrix
• Performed extensive Data Integrity testing by executing SQL Statements on Oracle SQL database
• Coordinated with the Developers regarding the Defects raised and Retested them against the application.
• Developed and executed automated test scripts in Informatica DVO
• Analyzed the data mapping and developed scenarios to verify the data migration from different data sources.
• Wrote and executed complex SQL queries including JOINS to validate Back-end data.
• Tested reports developed by Business Objects Universes for both Adhoc Canned Reporting users of Business Objects XI R3.1
• Experience in Testing data conversions and transformations.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Prepared extensive set of validation test cases to verify the data
• Performed Defect Management by prioritizing the issues and communicated the issues to the developer.
• Planned, coordinate and execute Business Objects deployment for End-users and documented the entire project
• Checking the integrity of UI data with the database using SQL queries, checking executing of stored procedures with the input values taken from the database.
• Executed the Test cases, Test Scenarios in Test lab tab of Quality Center.
• Worked with data reconciliation for the entire data migration project for both target system and rejected re-cords.
• Created Test metrics and participated in status meetings and reported the progress to the manager.

Environment: Informatica DVO, Oracle 10g, SOAP, SOAPUI, Web Services, Business Objects, fToad,DB2, Mainframe, AS/400, MS Office tools, SQL Query Analyzer, UNIX, Clear Quest, UNIX Scripting.

Confidential

ETL Tester QA Tester

Responsibilities

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Prepared Regression Test Plans, Requirements Traceability Metrics RTM , positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Worked on testing data migration, data integration and data transformation.
• Responsible in testing Initial and daily loads of ETL jobs.
• Validated various Ab Initio graphs according to functional requirements.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA's.
• Extensively used Rational Clear Quest to track defects and managed them.
• Running SQL queries and extracting data from Oracle and DB2 for data migration
• Extensively tested several MicroStrategy Reports for data quality, fonts, headers, footers, and cosmetics.
• Tested Informatica mappings for various ETL functions.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for in-depth knowledge of data, processes or applications in their specific area of responsibilities
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: Mercury Quality Center, Informatica, MicroStrategy, Rational ClearCase, Rational ClearQuest, Rational RequisitePro, TOAD, Perl, Oracle 10g/9i, SQL Server 2005, Unix, Win XP