SUMMARY:

• 8 years of IT experience in Software Quality Assurance and Testing using Data Warehouse, ETL, Client/Server applications.
• Experience in preparing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Experienced in Functional testing, System testing, Application testing, Performance testing, Integration testing, Regression testing, Black Box testing, Stress Testing, Smoke testing, browser compatibility testing, UAT and GUI testing.
• Proficient in validating Source to Target mapping documents including the transformation rules. Ability to interact with the developers to resolve issues using Defect Tracking tools.
• Good skills and understanding of SQA methodologies and practice
• Effectively manage multiple work assignments and priorities.
• Excellent understanding and expertise in writing complex SQL queries to perform back - end testing.
• Well-versed using UNIX commands and shell scripting. Experience in testing jobs on schedulers like Autosys
• Worked with wide variety of sources like Relational Databases, Flat Files.
• Worked with HP Quality Center for Test Management and defect tracking.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.
• Excellent problem solving, interpersonal, and communication skills.

TECHNICAL SKILLS:

ETL Tools: Datastage 9.x, InfoSphere - 11.5

Testing Tools: Quality Center, ALM 12.01

Database: Oracle, SQL Server

Tools: Sql Developer, TOAD

Operating Systems: Windows 7/XP.

Languages: SQL, UNIX, PL SQL.

SDLC/STLC: Agile, Waterfall.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

QA Lead Analyst

Responsibilities:

• Involved in requirement analysis, user documentation and technical documentation.
• Designing test cases.
• Test case execution and test report generation.
• Tracking and analyzing the defects and recording the variation between the Expected and Actual results.
• Testing the application from end to end. Executed the test cases in different Operating Systems (Windows 10) and related Browsers (IE 11, IE Edge Browser).
• Extensively involved in review meetings, test plan.
• Worked as a lead to resolve issues during critical phase of projects and guide junior testers and even played the role of a mentor whenever required
• Designed test plans and defined test cases for functional, integration system, and UAT.
• Tracking and analyzing the defects and recording the variation between the Expected and Actual results.
• Coordinated with the Developers regarding the Defects raised and Retested them against the application
• Reported bugs using HP ALM 12.01.
• Attended weekly defect report meetings and presented progress updates.
• Attend the knowledge sharing session on application from development team.
• Preparing status reports (Daily, Weekly), traceability matrix.
• Responsible for reviewing Test cases
• Utilized Quality Center for Tracking and Reporting Defects, which are assigned to developers.
• Designed and developed Test Scripts and Test Cases in HP ALM.
• Involved in blackbox testing in QA .
• Defects were tracked, reviewed, analysed and reported using ALM.

Environment: ASP.Net 4.0, C#.net, Sql Server 2012, HP ALM 12.01

ETL Tester/QA Lead Analyst

Responsibilities:

• Involved in all phases of Software Testing Life Cycle (STLC).
• Created Test Plans, Test Cases, and Test Scripts for SIT and support for UAT tests.
• Reviewed mappings and test cases before delivering to the Client.
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete.
• Validating the Archive process to purge the data that meet the defined business rules.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server and Oracle.
• Managed and conducted System testing, Integration testing and Functional testing.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Interacted with developers, Business & Management Teams and End Users.
• Participated in regular project status meetings.

Environment: InfoSphere - 11.5, Oracle 12g, SQL Server 2012, PL/SQL, UNIX, HP ALM, Netezza, Autosys,

ETL Tester

Responsibilities:

• Involved in all phases of Software Testing Life Cycle (STLC).
• Created Test Plans, Test Cases, and Test Scripts for SIT and support for UAT tests.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Reviewed mappings and test cases before delivering to the Client.
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete.
• Validating the Archive process to purge the data that meet the defined business rules.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server and Oracle.
• Managed and conducted System testing, Integration testing and Functional testing.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Interacted with developers, Business & Management Teams and End Users.
• Participated in regular project status meetings.

Environment: Datastage 9.x, Oracle 10g/9i, SQL Server 2000, SQL, PL/SQL, Autosys, OBIEE, MS Office Suite, TOAD, Manual Testing, UNIX,.

Software Tester

Responsibilities:

• Involved in Requirement verification
• Involved in user documentation and technical documentation
• Used T-SQL for Querying the SQL Server database for data validation.
• Designing test cases.
• Execution of smoke tests on each build using QTP and reporting the results to management
• Replaced fixed values with parameters, to check the functionality of the application with multiple sets of data.
• Parameterized test scripts in QTP to pass data from different data sources like Excel spreadsheets
• Test case execution and test report generation.
• Smoke test of applications after each new build.
• Designed test plans and defined test cases for functional, integration system, and UAT.
• Attend the knowledge sharing session on application from development team.
• Preparing status reports (Daily, Weekly), traceability matrix, query tracker.
• Responsible for reviewing Test cases
• Involved in Regression testing, integration testing, system testing, backend testing, UI testing, smoke testing, sanity testing and Functional testing
• Defect tracking and analysis for finding the root causes of the defects arrived in the application and closely interact with Development team for defect fixing

Environment: ASP.Net 3.5, C#.Net, .Net Framework 2.0, Oracle 9i, Windows XP, QC 9.0,QTP 11.0

Software Tester

Responsibilities:

• Involved in Requirement verification
• Involved in user documentation and technical documentation
• Used T-SQL for Querying the SQL Server database for data validation.
• Designing test cases.
• Test case execution and test report generation.
• Smoke test of applications after each new build.
• Attend the knowledge sharing session on application from development team.
• Preparing status reports (Daily, Weekly), traceability matrix, query tracker.
• Responsible for reviewing Test cases
• Involved in Regression testing, integration testing, system testing, backend testing, UI testing, smoke testing, sanity testing and Functional testing
• Defect tracking and analysis for finding the root causes of the defects arrived in the application and closely interact with Development team for defect fixing

Environment: ASP.Net 3.5, C#.Net, .Net Framework 2.0, Oracle 9i, Windows XP, QC 9.0

Software Tester

Responsibilities:

• Involved in Requirement verification
• Involved in user documentation and technical documentation.
• Designed and developed components using C# and .Net Framework classes.
• Used Web forms and Server controls in ASP.Net.
• Designing test cases.
• Test case execution and test report generation.
• Smoke test of applications after each new build.
• Attend the knowledge sharing session on application from development team.
• Preparing status reports (Daily, Weekly), traceability matrix, query tracker.\
• Defects were tracked, reviewed, analysed and reported using Quality Centre.
• Responsible for reviewing Test cases
• Involved in Regression testing and Functional testing
• Defect tracking and analysis for finding the root causes of the defects arrived in the application and closely

Environment: ASP.Net 3.5, C#, SQL Server 2005, HP Quality Center9.0.