SUMMARY

• Over 11 years of experience in IT as Quality Assurance Analyst. Proficient in Manual/Automation Testing of Client/Server and Web based applications using Mercury Interactive Test Suite - Test Director, Win Runner, Quick Test Pro and Load Runner.
• Domain competency includes Healthcare, Finance, Mortgage and Insurance sectors.
• Experience leading teams on various projects including Onsite and Offshore teams.
• Expertise in writing Test Plans, Test Strategies, Test Cases, Test Scripts, Test Scenarios, Test Reports and Defect Metrics.
• Involved in various stages of Software Development Life Cycle (SDLC) implementing Waterfall, V-Model and Agile methodologies.
• Strong understanding of QA Principles, QA Process, Use Cases, and Software Development Life Cycle.
• Extensive experience in developing Test Procedures and Test Strategy for Web and Client/Server applications.
• Sound knowledge of Black Box, White Box, System, Regression, Integration, Functionality and User Acceptance Testing.
• Experience in testing on enterprise wide applications with multiple databases.
• Proven experience with the development, and implementation of large-scale, enterprise data warehouse and reporting solutions.
• Extensive experience in HP Test Suite, Rational Clear Quest, Clear case and Remedy.
• Good Knowledge of ETL tools like Informatica 9.1 / 8.6.1/7.1.2 , Data Stage, SSIS.
• Experience in Business Intelligence in generating various reports using business Intelligence tools like Cognos 10 / 8, SAS, SSRS, Micro strategy, Business Objects XI R2/XI/6.5.
• Interacted with the developers on various technical issues and resolved the reported bugs.
• Excellent understanding of the Software Development Life Cycle and role of QA.
• Extensive experience performing ETL/Data warehouse and database testing.
• Worked with all stages of testing namely Integration Testing, System Testing and User Acceptance testing manually as well as using automated test tools.
• Back-end testing using SQL, PL-SQL, Unix.
• Conducted review sessions with the Business Analysts and Subject Matter Experts to understand the systems, process and impacts.
• Set up best practices across projects for QA.
• Created Center Of Excellence for QA on multiple projects.
• Well versed in testing Methodologies, Web testing, and software Deployment/Release processes.
• Very Strong skills, including the use of nested table expressions, unions, Multi-table joins and outer joins.
• Experience facilitating meetings, war room sessions with Users during UAT.
• Supported the defect resolution process by prioritizing the severity level of defects.
• Assisted managements in Talent Acquisition and Resource Management.
• Self-Motivated, Team Oriented with ability to handle multiple tasks and efficient in meeting deadlines.
• Possess excellent communication skills along with verbal and written skills.

TECHNICAL SKILLS

Operating Systems: Windows 2003/2000/XP, UX-HP, Solaris, MS DOS

Internet: ASP, HTML DHTML, XML, Web Services

Business Modeling Tools: Rational Rose, MS Visio

Languages: C#, C++, C, VB.Net, VBScript, JavaScript, VB 5/VB 6, SQL, PL/SQL

Testing Tools: QTP8.x/9.2/9.5/10, ALM, Quality center 10.0/9.2/8.2 , WinRunner 7.5/7.0/6.0, LoadRunner9.0/8.x, Test Director

Office Tools: MS Office, MS Project

Databases: MS SQL Server 2000, Oracle 8i/9i, TeradataV2R6/R5, DB2, Sybase

ETL/ Reporting Tools: Informatica, Datastage, Ab Initio, Crystal Reports, SSIS, SSRS

Configuration Management: MS Visual Source Safe, SOS, Clear Case, Share Point Portal, Doors, Rational Test Manager

PROFESSIONAL EXPERIENCE

Confidential, St Paul, MN

ETL Test Lead/Test Manager

Responsibilities:

• Created on-boarding documentation for QA resources.
• Reviewed and documented the Test Management Tools and presented them to the Leadership for decision making.
• Determined the Test Management Tool for the organization and worked with the vendor for contract and setup.
• Setup the Test Management tool for the project and conducted walk through sessions for the QA Staff and other competency leads.
• Create and maintain folder structure in QA Symphony / QTest.
• Defined best practices for QA and lead the QA Center of excellence.
• Provided QA training for HealthEast employees and interns.
• Created High Level Test Plan and Test Strategy documents for the project.
• Created and reviewed various testing artifacts like templates to load test cases and defects into ALM / QC.
• Created and socialized various testing artifacts to help the other teams on the project.
• Responsible for training the project team and Users on required tools.
• Participated in meetings with the Source Teams to understand the data and applied the outcomes of the meetings to testing.
• Worked with the Subject Matter Experts to understand and analyze impacts of various data acquisitions.
• Coached the QA team in AGILE Methodology.
• Assisted the Scrum Master in planning sprints and creating tasks for testing.
• Participated in the weekly sprint planning to define tasks and provide effort estimates.
• Participated in daily Agile / Scrum calls to review / update burn down of QA Tasks.
• Responsible for creating Testing User Stories in JIRA.
• Responsible for reviewing Use cases with the SMEs and align the test scenarios accordingly.
• Responsible for reviewing Test Cases prepared by the QA team.
• Created SQL scripts and Reviewed test scripts prepared by other QA resources and assisted the team on test script tuning.
• Conducted Defect Triage calls to review and track down defects on a daily basis.
• Responsible for leading efforts on UAT and to coordinate between the Users and the Design / Development teams on issues during UAT.
• Responsible for reporting status of various testing activities to the Management.
• Responsible for creating and maintaining the QA SharePoint and Shared Drive for the project.
• Provided Testing sign off documents for various deployments on the project on an as needed basis.
• Facilitate QA meetings with the business and source owners to mitigate risks and resolve issues.
• Facilitated UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.
• Worked as single point of contact for all activities on the Test Management Tool (Training and Administration).

Environment: EPIC Caboodle, MS SQL Server 2012, SSIS, SSRS, CUBES, Teradata TD 12, Cognos 10, Flat Files, SQL, PL/SQL, HP Application Lifecycle Management ( ALM 11 ), QA Symphony / Qtest, Microsoft Office Suite 2013, Windows 7, MS Outlook, Qlik

Confidential, Eden Prairie, MN

ETL Test Lead/Test Manager

Responsibilities:

• Prioritized activities for the QA Team.
• Setup Testing Suite for the project.
• Create and maintain folder structure in ALM (Application Lifecycle Management).
• Defined best practices and acted as the lead for QA Center of excellence.
• Responsible for talent acquisition and resource management on the QA team
• Created Test Plan and Test Strategy documents for the project.
• Created and socialized various artifacts to help the other teams on the project.
• Responsible for training the project team and Users on required tools.
• Worked with the Subject Matter Experts to understand and analyze impacts of various data acquisitions.
• Responsible for reviewing Use cases with the Business Analysts and align the test scenarios accordingly.
• Responsible for reviewing Test Cases prepared by the QA team.
• Created the reporting module in ALM to reflect test progress, defect tracking etc.
• Reviewed test scripts (SQL) and assisted the team on test script tuning.
• Co-ordinated the onsite and offshore teams handshakes on day to day activities.
• Conducted Defect Triage calls to review and track down defects for each release.
• Responsible for leading efforts on UAT and to coordinate between the Users and the Design / Development teams on issues during UAT.
• Worked with the project teams on process improvements.
• Responsible for reporting status of various testing activities to the Management.
• Responsible for creating and maintaining the QA SharePoint for the project.
• Facilitate QA meetings with the business and source owners to mitigate risks and resolve issues.
• Organize daily triage calls with the testing team and the development teams to facilitate progress review, defect discussion and issue resolutions.
• Facilitated UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.
• Provided Testing sign off documents for various deployments on the project on an as needed basis.

Environment: Informatica 9.1, SSIS, Teradata TD 12, SQL Server 2008, Cognos 10, Flat Files, Teradata SQL Assistant, TOAD, SQL, PL/SQL, HP Application Lifecycle Management ( ALM 11 ), QTP, UNIX, Microsoft Office Suite 2010, Windows 7, MS Outlook.

Confidential, Cranston, RI/Medford, MA

ETL Test Lead/Test Manager

Responsibilities:

• Initiated the Test Activity Planning and Test Resource Management on the project.
• Created Test Plan and Test Strategy documents for the project.
• Worked with the SMEs of various source systems to understand the project requirements.
• Involved in the creation of use cases and verifying them with the project team.
• Worked with the onsite and offshore testing teams to identify gaps and resolve them to closure.
• Responsible for designing test scenarios for the project based on the requirements and use cases.
• Involved in base lining Test Scenarios, Test Cases and Test Scripts.
• Responsible for maintaining Test Reports and Defect Metrics.
• Developed and validated SQL scripts for both ETL and DataMart testing.
• Conducted peer reviews with the offshore testing team to finalize the test cases, test scripts for ETL and Cube validations.
• Conducted sessions with the Development team to verify any additional testing scenarios required based on the ETL specs.
• Responsible for creating projects in Quality Center / ALM and maintaining project folders and structures.
• Used Quality Center/ ALM to load the test cases, track execution against the plan during the testing phase.
• Responsible for tracking defects in QC / ALM from validating the defect, assigning the defects to the development team and closing the defect after successful retesting.
• Verified Test cases scripts based on the functional specifications and maintained traceability with the requirements.
• Validated SSIS reports after ETL and Cube deployments to make sure the values in the database tie out to the reports.
• Responsible for maintaining repository for testing activities for future use.
• Interact with the users to walk them through the functionality of the reports that they request before UAT.
• Conduct war room sessions with the users for UAT.
• Co-ordinate the UAT efforts between the Business and Development teams for efficient defect tracking and closure.
• Conducted daily status calls during IT and UAT for test execution and defect tracking.
• Responsible for maintaining the QA SharePoint for projects.
• Conducted knowledge transfer sessions for new hires and get them to speed on the projects.
• Communicate testing activities to the project teams and high level management on a daily basis including the test execution progress, defect summary and burn down charts.
• Responsible for setting up databases for the QA environment and working with DBA’s to assign proper privileges for the testing team for testing.
• Facilitate meetings with the business and source owners to mitigate risks and resolve issues.
• Organize daily triage calls with the testing team and the development teams to facilitate progress review, defect discussion and issue resolutions.
• Attended daily status meetings for Data quality issues and also technical review meetings.
• Schedule UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.

Environment: Data Stage 8.5 / 9.1, Teradata, SQL Server, MDM, Informix, Flat Files, XML Files, SAS, Teradata SQL Assistant, TOAD, SQL, PL/SQL, HP Application Lifecycle Management ( ALM ), QTP, UNIX, Microsoft Office Suite 2010, Windows 7, MS Outlook.

Confidential, Austin, TX

Data warehouse/ETL Test Lead

Responsibilities:

• Created Test Plan and Test Strategy documents for various projects..
• Worked with the business analyst to understand the requirements.
• Writing use cases and verifying them with the project team.
• Responsible for designing test scenarios for the project based on the requirements and use cases.
• Involved in base lining Test Scenarios, Test Cases and Test Scripts.
• Responsible for maintaining Test Reports and Defect Metrics.
• Developed and validated SQL scripts for both ETL and CUBE testing.
• Validated the Fact and Dimension relationship in the data warehouse.
• Designed and tested the slowly changing dimensions based on the ETL Specs.
• Conducted peer reviews with the offshore testing team to finalize the test cases, test scripts for ETL and Cube validations.
• Conducted sessions with the Development team to verify any additional testing scenarios required based on the ETL specs.
• Responsible for creating projects in Quality Center / ALM and maintaining project folders and structures.
• Used Quality Center/ ALM to load the test cases, track execution against the plan during the testing phase.
• Responsible for tracking defects in QC / ALM from validating the defect, assigning the defects to the development team and closing the defect after successful retesting.
• Verified Test cases scripts based on the functional specifications and maintained traceability with the requirements.
• Validated SSIS reports after ETL and Cube deployments to make sure the values in the database tie out to the reports.
• Responsible for maintaining repository for testing activities for future use.
• Interact with the users to walk them through the functionality of the reports that they request before UAT.
• Conduct war room sessions with the users for UAT.
• Co-ordinate the UAT efforts between the Business and Development teams for efficient defect tracking and closure.
• Conducted daily status calls during IT and UAT for test execution and defect tracking.
• Responsible for maintaining the QA SharePoint for projects.
• Conducted knowledge transfer sessions for new hires and get them to speed on the projects.
• Communicate testing activities to the project teams and high level management on a daily basis including the test execution progress, defect summary and burn down charts.
• Responsible for setting up databases for the QA environment and working with DBA’s to assign proper privileges for the testing team for testing.
• Performed debugging on stored procedures that fetch the data into the reports.
• Attended daily status meetings for Data quality issues and also technical review meetings.

Environment: Informatica 8.6.1 / 9.1, Informatica MDM, SQL Server, Teradata, SAP MM, SAP HR, SAP BW, SAS Reporting, SSIS, SSRS, TOAD, SQL, PL/SQL, HP Quality Center 10.0 / HP Application Lifecycle Management ( ALM ), QTP, Clear case, TFS, UNIX, Microsoft Office Suite 2010, Windows XP, MS Outlook.

Confidential, McLean, VA

Data warehouse/ETL Test Lead

Responsibilities:

• Worked as a System Analyst and a Data warehouse/ ETL tester.
• Worked with the business teams to understand and interpret the project requirements.
• Involved in writing Test Plan and Test Strategy for the project and getting signoffs from the relevant project members.
• Monitored the Test Scenario Creation, assisted in the Test Case and Test Script development.
• Developed SQL scripts and used Rapid Sql query tool to run the SQL scripts from Sybase and SQL Server databases.
• Monitored the activities in Quality Center including executing the test cases, track execution against the plan during testing and managing defects from inception to resolution.
• Created Test cases scripts from the functional specifications and maintained traceability with the requirements.
• Created SQL queries to fetch data and validate application against the database
• Performed functional, performance, regression and black-box testing on the payment and billing applications.
• Creating the test batch data file by FTP thru UNIX.
• Created Test execution, Defect Metrics for daily status meetings
• Validated XML files for the web services triggered by the Java based application (OUS).
• Tested reports developed using Business Objects and Crystal Reports.
• Tested web intelligence reports developed from BO Universe.
• Verified the BO reports as per the UAT document.
• Validated data between different web applications and documented the test results.
• Communicate testing activities and findings in oral and written formats.
• Ran Sql queries to check if the data is loaded correctly into the database for the backend testing.
• Responsible for maintaining RTM in DOORS.
• Trained end users on the new application and conducted knowledge transfer sessions on the project.
• Attended daily status meetings for Data quality issues and technical review meetings.

Environment: Sybase, SQL Server, Teradata V2R6, Java, .Net, Informatica 8.6.1, BO XI 3.0,Embarcadero’s Rapid SQL, XML, Lotus Notes 7.1.1, Clear case, Clear quest, UNIX, MS Excel 2007, MS word 2007, Windows XP, Unix, Quality Center 9.2, QTP 10/9.5, SOAPUI, IBM DOORS.

Confidential, New York

Senior Data warehouse/ETL Test Lead

Responsibilities:

• Working with the business team to gather requirements.
• Creating and executing test cases based on test plans.
• Performed report validation of the securities system, which are generated, on Cognos8.0.
• Developing SQL scripts and used TOAD to run the SQL scripts from Oracle and SQL server databases.
• Experience in testing using Teradata utilities like BTEQ and exposure to FastLoad, MultiLoad, FastExport, Tpump, and SQL Assistant.
• Extensively tested data from flat files, Oracle, Teradata database.
• Worked extensively with the Teradata Queryman to interface with the Teradata.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Tested reports developed using Business Objects and Crystal Reports.
• Tested the Business Objects reports for joins and filters.
• Used TOAD to connect to Oracle Database to validate data that was populated by ETL applications.
• Involved in backend testing for different environments like System Testing and User Acceptance Testing.
• Tested web intelligence reports developed from BO Universe based on parameters.
• Perform Functional testing, System testing, Smoke testing and Regression testing.
• Documenting the test results.
• Modifying UNIX shell scripts.
• Tested internal and high-level business reports.
• Running Sql queries to check if the data is loaded correctly into the database and into the reports subsequently.
• Checking the job flows in Informatica.
• Used Quality Center for executing the test cases and defects tracking.
• Scheduling Autosys jobs and running the job flows.
• Attended weekly status meetings for reporting the testing updates.
• Participating in review meetings on a periodic basis.

Environment: Quality Center 9.2, Oracle, SQL Server, Teradata V2R5, Toad, Informatica 8.1, XML, Java, BO XI R3, MS Outlook, Autosys, MS Excel, MS word, Windows XP, Unix and DOORS.

Confidential, McLean, VA

Senior Data warehouse/ETL Tester

Responsibilities:

• Worked as a Data warehouse / ETL tester.
• Worked with the business team to gather requirements.
• Used TOAD SQL browser to write SQL queries for validating constraints, indexes.
• Used TOAD schema browser to check the characteristics of the schema objects(tables, synonyms etc)
• Performed Positive testing, Negative testing, Functional testing, Navigational testing, System Testing and Regression Testing in different phases
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
• Extensively worked on understanding the business requirements and designing BO applications.
• Tested reports developed using Business Objects and Crystal Reports.
• Tested web intelligence reports developed from BO Universe.
• Performed quality control analysis and validates results of conversion programs. Used extensive SQL query. Evaluated actual data load results. Involved with high volume testing.
• Developed SQL scripts and used Rapidsql query tool to run the SQL scripts from Sybase and DB2 databases.
• Performed Functional testing, System testing, Smoke testing, Regression testing and UAT.
• Documented the test results.
• Verified the BO reports as per the requirements document.
• Created and modified UNIX shell scripts
• Communicate testing activities and findings in oral and written formats.
• Ran Sql queries to check if the data is loaded correctly into the database.
• Responsible for maintaining RTM in DOORS.
• Used Quality Center for executing the test cases and defects tracking.
• Created the Naming conventions document and documented management plan.
• Attended daily status meetings for Data quality issues and technical review meetings.

Environment: Quality Center 9.2, Sybase, DB2, Rapid SQL, Data stage, BO XI R2, XML, Lotus Notes 7.1.1, Clear case, Clear quest, UNIX, MS Excel, MS word, Windows XP, Unix and DOORS.

Confidential, IL

Data warehouse/ETL Tester

Responsibilities:

• Wrote Test Plans and Test Cases pertaining to data validation and integrity testing for data loading, data validation and integrity check testing.
• Wrote test cases and executed them on the Billing System.
• Developed a detailed Test Plan for the testing effort of the User Interface
• Involved in requirement analysis
• Performed security testing manually and writing sql queries against the database
• Maintained requirement traceability matrix.
• Extensively used Mercury Quality Center (TEST DIRECTOR) and Created Test Cases in the TEST PLAN according to the specifications.
• Used TEST LAB to run the Test cases.
• Reported Defects and prioritized outstanding defects using Test Director/Quality Center.
• Ran the Informatica ETL Sessions for Claims in different stages Source to Stage & Staging to Data mart and Data mart to Business Objects and BO to Dashboard using Informatica Server Manager
• Maintain Object repository
• Created TSL Scripts files as per the test plan requirements.
• Tracked the defects in Test Director.
• Validated data feed into the data warehouse for DWH implementation and also tested front end application where massaged data was presented in report formats.
• Involved in Integration testing, UI, User Acceptance Test (UAT), Functionality testing & Performance testing.
• Performed database testing to verify the rates as per the large accounts
• Executed SQL Queries to verify the dataflow from the backend
• Involved in validating the reports, both Data and their layouts
• Bug reporting, tracking and documentation on the Bug tracking System using Test Director
• Weekly Status meeting with Development and Management teams to discuss bugs and other issues.

Environment: Test Director 7.2, QTP 8.2, Flat files, Informatica 7.1, SQL Loader, Oracle 8i/9i, TOAD, UNIX, Windows

Confidential

Data Analyst

Responsibilities:

• Performed requirements gathering & analysis by actively soliciting, analyzing and negotiating customer requirements while leading the technical requirements analysis, driving the system design and construction.
• Developed reports using SQL and Crystal Reports. Developed various reports to display the sales orders, deliveries pending bills from customers shipped orders and outstanding dues.
• Involved in writing source code using SQL.
• Communicated with the Database team and other programmers to guide them with the reports integration to implement Crystal Reports in web based applications.
• Worked on SQL and PL/SQL for modifying Stored Procedures, Packages, Functions and Database Triggers.
• Created Test Plan and Test Cases based on Functionality, Business rules.
• Implemented the standards for the reports that need to be developed.

Environment: Windows 2000, Visual Basic, HTML, ASP.NET, VB Script, JavaScript, Visual Studio 1.1, MS Office, Crystal Reports 8.5/9.0, Oracle 8.i, SQL, PL/SQL.