SUMMARY:

• 14 years of experience in Software Testing on Data Warehouse (ETL/BI), Web - based, Client-Server, Desktop and e-Commerce Applications using Agile and Waterfall methodologies.
• 10 years of experience as Test Lead (ETL & Functional) and Defect Manager, and handled testing teams up to 12 members (onshore and offshore).
• Expert in Data Migration Testing. Handled 4 large data migration projects testing.
• Experience in ETL/Big Data Testing Automation (QuerySurge).
• Excellent software testing background with experience in coordinating and leading ETL/BI Testing, System Testing, System Integration Testing, Regression/Re-testing, End-2-End Testing and UAT Testing while interacting with business stakeholders and project team members to collect test requirements, identify risks and determine testing scope.
• Expert in writing SQL queries using databases like Oracle, SQL Server, Teradata, Netezza, DB2 and Informix to validate data between Source systems to Staging database to Target database to Reports specially using Minus SQLs. Experience in FLAT files data validations.
• Involved in Data Analysis, Data Validation, Data Cleansing, Data Verification, preparing Test Data using SQLs.
• Expertise in extended validation of reports developed using Microstrategy/Business Objects/FLEX by writing SQL queries at the backend.
• Extensive experience testing websites in a Java/J2EE, Dot Net environment across multiple browsers, backend processing and data validation.
• Experience in ETL test process consisting of dimension modeling, data transformation, sourcing, mapping, conversion, loading.
• Experience in leading the team in Test Planning, Test Strategy, Test Plan & Strategy execution and communication of Test Results ( Test Summary Reports, Test Metrics and Bug Documentation) to the Scrum team.
• Experience in Test estimation, Resource estimation & allocation for project testing, preparing and executing the test schedules for different releases of the projects.
• Strong experience of Quality Center, MTM (Microsoft Test Manager) and TFS (Team Foundation Server); extensively used as Test Management Tools.
• Experience in developing Test Cases using Business Requirements, Functional Requirements, Technical Requirements, Use Cases, User Stories and Design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.
• Experience in leading Defect Triage Meetings.
• Expert in creating/maintaining the Regression Test Bed with each release while ensuring all projects complete Regression Testing in Pre-Production, as applicable, before deploying to Production.
• Verifying and Validating Application Software and Documentation based on standards for Software Development and effective test implementation in all phases of Software Development Life Cycle (SDLC).

TECHNICAL SKILLS:

Testing: ETL/DataWarehouse, System & Integration, Regression/Retesting, End-2-End, Usability, Exploratory & Ad-hoc, UAT Testing, Mobile Testing, Multi Browser testing, Upgrade Testing, Performance Testing

Tools & Software: Datastage, Informatica PowerCenter, Microstrategy, Business Objects, Control-M, SQL Developer, Teradata SQL Assistant, TOAD, Rapid SQL, Quality Center, Microsoft Test Manager, QTP, Load Runner (Vugen, Analyser, Performance Center), MS Office, WinSCP, Putty

Operating Systems: Linux, UNIX, Windows

Databases: Oracle, SQL Server, Teradata, Netezza, DB2, Informix

Bug Tracking Tools: Quality Center, Microsoft Test Manager, JIRA, JAMA, Mantis, Bugzilla

Version Control Systems: TFS (Team Foundation Server), SVN, CVS, VSS, Team City

Domains: Retail, Banking, Media & Entertainment

PROFESSIONAL EXPERIENCE:

Confidential

ETL Test Lead

Responsibilities:

• Worked on a very large Data Migration/Conversion project testing.
• Test Planning & Strategy, test script preparation, test execution & documentation to include: ETL testing, Functional and Regression testing, Live support/defect testing, UAT testing/co-ordination with market representatives, Environment and data management, System Integration, Retesting, Usability, Exploratory and Ad-hoc Testing using Positive & Negative Test approaches.
• Data Analysis, Data Validation, Data Cleansing, Data Verification, preparing Test Data using SQLs.
• Develop Test Cases (ETL, Business Objects Reports, Functional, and UAT) for the project using data mapping sheets, BRD.
• Prioritizing test requirements and test cases, executing test plans, and the evaluating test results.
• Develop complex SQL queries to validate data between different layers (Source to Staging to Target databases).
• Test data creation using SQL/XML/JSON.
• Prepared Regression Test Bed with each release while ensuring all projects complete Regression Testing in Pre-Production, as applicable, before deploying to Production.
• Participate in test planning sessions to ensure that test plans and scenarios deliver high quality solutions that satisfy business requirements.
• Derive test scenarios in accordance with testing plan and risk based test methodology.
• Ensure traceability back to requirements, and ensures quality in the representation of defects for correction and during regression/retest.
• Participate in Change Management, keep track of scope and requirements changes, assesses the impact on the test management deliverables.
• Participate in key initiatives as assigned to implement best practices in testing and quality.
• Act on and suggest initiatives improving testing efficiency and effectiveness.
• QA of development/data testing effectiveness and propose reasoned improvements to help the full total test effort.
• Prepare Test Summary Reports, Test Traceability Matrix and Defect Reports.

Environment: Informatica PowerCenter, SQL Server 2012, Oracle 11g, Dot Net, Microsoft Visual Studio, Microsoft Test Manager, JAMA, XML, RapidSQL, NetSender, Splunk, Business Objects, Informatica PowerCenter, MS Office, BizTalk

BI Test Lead

Responsibilities:

• Defining the test approach, test strategy and test scope for migration project
• Writing the test plan and test cases for migration project
• Extensively using MS excel for data comparison between Microstrategy and Business Objects reports.
• Used Advanced MS Excel skills.
• Test Management using Quality Center

Environment: Teradata, Microstrategy, Business Objects, Informatica PowerCenter, MS Office, Quality Center, Teradata SQL Assistant

Confidential, Cincinnati, OH

ETL Test Lead

Responsibilities:

• Built a team of 4 testers from scratch for the project.
• Perform complex testing tasks, where the items under test include technology components comprised of Datawarehouse (Oracle 11g) and Exadata, SharePoint (as a Portal), MicroStrategy (MSTR), and .Net in a multi-tier platform based architecture.
• Analysis of the key architectural components with senior test support & contribute to effort estimates, test pre-requisites & agile test process considerations for Sprints.
• Test Planning & Strategy, test script preparation, test execution & documentation to include: Big data and ETL testing, Localization and Configuration testing, Functional and Regression testing, Live support / defect testing, Performance Testing, UAT testing / co-ordination with market representatives, Environment and data management, Non-functional, System & System Integration, Retesting, Usability, Exploratory, Ad-hoc and UAT Testing using Positive & Negative Test approaches.
• Experience in ETL/Big Data Testing Automation (QuerySurge).
• Data Analysis, Data Validation, Data Cleansing, Data Verification, preparing Test Data using SQLs
• Develop Test Cases (ETL, MSTR & Flex Reports, Functional, and UAT) for the project.
• Prioritizing test requirements and test cases, executing test plans, and the evaluating test results.
• Develop complex SQL queries to validate data between different layers.
• Prepared Regression Test Bed with each release while ensuring all projects complete Regression Testing in Pre-Production, as applicable, before deploying to Production.
• Performing ETL testing, System & Integration, Regression/Re-testing, End-2-End, UAT, Multi browser (Safari, Chrome, Firefox, IE, Opera etc.) and Multi language testing.
• Participate in test planning sessions to ensure that test plans and scenarios deliver high quality solutions that satisfy business requirements.
• Derive test scenarios in accordance with testing plan and risk based test methodology.
• Ensure traceability back to requirements, and ensures quality in the representation of defects for correction and during regression/retest.
• Participate in Change Management, keep track of scope and requirements changes, assesses the impact on the test management deliverables.
• Participate in key initiatives as assigned to implement best practices in testing and quality.
• Act on and suggest initiatives improving testing efficiency and effectiveness.
• QA of development/data testing effectiveness and propose reasoned improvements to help the full total test effort.
• Prepare Test Summary Reports, Test Traceability Matrix and Defect Reports.
• Performance Testing, Upgrade Testing

Environment: .Net, MTM, TFS, Visual Studio, Oracle 11G, Oracle Exadata, Java Script, HTML, XML, MS Office

Confidential

Sr. ETL Tester

Responsibilities:

• Data Analysis, Data Validation, Data Cleansing, Data Verification, preparing Test Data using SQLs
• Develop Test Cases (ETL, Business Objects Reports, Functional, and UAT) for the project.
• Prioritizing test requirements and test cases, executing test plans, and the evaluating test results.
• Develop complex SQL queries to validate data between different layers.
• Prepared Regression Test Bed with each release while ensuring all projects complete Regression Testing in Pre-Production, as applicable, before deploying to Production.
• Performing ETL testing, System & Integration, Regression/Re-testing, End-2-End, UAT, Multi browser (Safari, Chrome, Firefox, IE, Opera etc.) and Multi language testing.
• Participate in test planning sessions to ensure that test plans and scenarios deliver high quality solutions that satisfy business requirements.
• Derive test scenarios in accordance with testing plan and risk based test methodology.
• Ensure traceability back to requirements, and ensures quality in the representation of defects for correction and during regression/retest.
• Participate in Change Management, keep track of scope and requirements changes, assesses the impact on the test management deliverables.
• Participate in key initiatives as assigned to implement best practices in testing and quality.
• Act on and suggest initiatives improving testing efficiency and effectiveness.
• QA of development/data testing effectiveness and propose reasoned improvements to help the full total test effort.
• Prepare Test Summary Reports, Test Traceability Matrix and Defect Reports.

Environment: Dot Net, Microsoft Visual Studio, Microsoft Test Manager, JAMA, XML, SQL Server 2012, Oracle 11g, RapidSQL, NetSender, Splunk, Business Objects, Informatica PowerCenter, MS Office, BizTalk

Confidential, Hoffman Estates, IL

Sr. Test Lead/Manager - ETL & Functional

Responsibilities:

• Responsible for writing the Test Plans & Strategy document, Testing Scope for different releases of the projects
• Created mapping sheet between source and target databases.
• Developed Test Cases (ETL, Reports, Functional/UI and UAT) for the project.
• Developed Complex SQL queries (Netezza, Teradata, Oracle, SQL Server, Informix) to validate the data between Source to Staging to Target databases to Reports.
• Microstrategy Reports testing, Functional/UI testing for GameOn portal across multiple browsers (IE, Firefox, Chrome, Safari), backend processing and data validation.
• Involved in Data Analysis, Data Validation, Data Cleansing, Data Verification, preparing Test Data using SQLs.
• Involved in extended validation of reports developed using Microstrategy by writing SQL queries at the backend.
• Involved in ETL test process consisting of dimension modeling, data transformation, sourcing, mapping, conversion and loading.
• Prepared Regression Test Bed with each release while ensuring all projects complete Regression Testing in Pre-Production, as applicable, before deploying to Production.
• Organized the testing kick-off meeting, define the Strategy, arrange the Hardware and software requirement for the Test Setup
• Identified Training requirements and forward it to the Project Manager, arranging/providing training to the team members
• Managed a team of 2 to 8 testers (onshore & offshore), assigned/verified tasks to all testing team members
• Ensured content and structure of all Testing documents / artifacts are documented and maintained
• Document, implement, monitor, and enforce all processes for testing as per standards defined by the client/organization
• Reviewed the Test Cases documents, keep track of the new requirements / change in requirements of the Project
• Organized the status meetings and send the Status Report (Daily, Weekly etc.) to the Project/Client Manager
• Track and prepare the report of testing activities like test results, test case coverage, required resources, defects discovered and their status, performance baselines etc
• Ensured the timely delivery of different testing milestones
• Prepared / updated the metrics dashboard at the end of a phase or at the completion of project
• Obtained customer acceptance on the test cases, test specification, test approach, test report, test specification, defect report
• Ensured tests are conducted as per test specification, report status to the project/client manager
• Ensured that complete defect life process is followed in the project
• Verified the correctness of the priority/severity assigned by the testers, involved with development/onsite team to define defect priority
• Ensured that all the defects have enough information to reproduce it, all necessary evidences are captured
• Defined the test approach, test strategy, test scope for data migration testing
• Responsible for writing the test plans and test cases for data migration project
• Developed SQL queries to validate the data between Netezza and Teradata
• Managed a team of 12 testers (onshore & offshore)
• Extensively used MS excel for data comparison between Netezza and Teradata
• Tested the complete data model between Netezza and Teradata
• Performed pre-migration and post-migration testing
• Performed smoke testing on daily basis for data load
• Defect Management
• Created an automation UNIX tool with the help of team member for table to table comparison
• Defined the test approach, test strategy, test scope for data migration testing
• Responsible for writing the test plans and test cases for data migration project
• Developed SQL queries to validate the data between Netezza and Teradata
• Extensively used MS excel for data comparison between Netezza and Teradata
• Managed a team of 4 testers, assigned task to all testing team members
• Tested the complete data model between Netezza and Teradata
• Performed pre-migration and post-migration testing
• Performed smoke testing on daily basis for data load
• Verified data between Business Objects and Microstrategy Reports
• Defect Management

Environment: Netezza, Teradata, SQL Server, DB2, Oracle, Informix, .Net, Microstrategy, Business Objects, UNIX, Control-M, InformaticaPowerCenter, Datastage, .Net, Citrix, Putty, WinSCP

Sr. QA Analyst

Confidential

Responsibilities:

• Prepared Test Plan, Test Cases using based on the functional requirement documents, Test Summary Report, Test Traceability Matrix and Defect Report.
• Actively involved in System Testing, Regression/Retesting and Database Testing for different Releases.
• Involved in tracking, reviewing, analyzing and comparing defects using the Quality Center.
• Involved extensively in doing back-end testing of the data quality by writing SQL queries.

Environment: Java/J2EE, Linux, Windows XP/Windows 2K, Unix, XML, Oracle 9i

QA Analyst

Confidential

Responsibilities:

• Prepared Test Plan, Test Cases using based on the functional requirement documents, Test Summary Report, Test Traceability Matrix and Defect Report.
• Actively involved in System Testing, Regression/Retesting and Database Testing for different Releases.
• Involved in tracking, reviewing, analyzing and comparing defects using the Quality Center.
• Involved extensively in doing back-end testing of the data quality by writing SQL queries.

Environment: Java/J2EE, LINUX RHES3/ RHFC-3, jdk 1.5 (JSP, Servlets) tomcat 5.18, Oracle 9i, Perl 5.8.0, Bugzilla