SUMMARY

• Over 7+ years of professional experience in Quality Assurance, Testing stand - alone, Client Server and web based applications using Manual Testing, HP ALM Explorer 11.5x/Quality Center, on UNIX, Windows.
• Extensive ETL testing experience using Informatica 8.6.1 (Power Center/ Power Mart) (Workflow Manager, Workflow Monitor).
• Extensive experience in Functional, Integration, Regression, User Acceptance, System, Performance, Load & Stress Testing, Black Box Testing.
• Expertise in Oracle table data manipulation using SQL queries and UNIX commands.
• Extensive experience working in UNIX, Oracle, SQL Developer and MS Access.
• Experience in Test Design, preparing Test Cases, Test Plans, Test Logs and bug reports.
• Documenting Test Documents Using MS Office Tools - Word, Excel, and Power Point.
• Backed by strong credentials including Bachelor degree, methodologies and monitoring tools; and cross-platform skills in Windows and Unix.
• Experience in testing and writing SQL and PL/SQL statements.
• Demonstrated methodical, detail-oriented and thorough approach to all assignments while adhering to compressed timelines. Completed all assignments on or ahead of schedule.
• Consistently recognized for excellent problem-solving and analytical skills by programmers, project managers and supervisors.
• Proficient in managing in all Quality assurance testing cycle from Test planning to Defect tracking and managing Defect life cycle. Analyzing bugs and interacting with development team members in fixing the defects.
• Self-starter, Self-motivated, willing to assume responsibilities, a strong team player with great leadership qualities as well as comfortable individual with excellent communication and analytical skills.

Platforms: UNIX, Windows (NT, 2000, XP, 2003, Vista), MS-DOS

Programming languages: SQL, PL/SQL, XML, HTML, HTTP

Database systems: Oracle11g/10g, SQL Server 2008

Defect-tracking software: HP Quality Center/ALM11.5x

Tools and Utilities: Toad, Oracle SQL Developer, SQL Plus

ETL Tools: Informatica

Methodologies : Agile Scrum, Waterfall

Office tools: MS office MS word, Excel, Power point.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. QA tester

Responsibilities:

• Extracted data from various sources like Oracle, flat files and CSV files.
• Performed database testing to ensure the ETL process for the data being extracted, transformed and loaded into the new Database through Informatica.
• Wrote complex SQL Queries against Oracle database to validate Test Cases resulting in verifying all required business scenarios.
• Created expected results and validated the Data Integrity.
• Prepared the Test Data for the Incremental / historical Load testing and validation.
• Use Informatica debugger and session log to debug the defects.
• Understanding the Business Requirement Document (BRD) and Functional Requirement document (FRD).
• Acted as the Subject Expert in the functionality assigned for the project.
• Updated Requirements Traceability Matrix (RTM) to reflect the test coverage.
• Took part in Test Plans Walkthroughs with the development teams.
• Managed and executed the test process, using Agile Methodology.
• Used ALM Explorer for writing Test Plan, Test Cases development, test script writing, Test case execution & Defect Tracking.
• Played a vital role in setting up various Test Environments like Integration Testing Environment, System Testing Environment, User Acceptance Testing Environment and Prod-Fix Environment with the goal of replicating the end-users environment.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Responsible for executing the Data Load Scripts to load the test data into the appropriate database and running the SQL to ensure the accuracy of data load.
• Finalized and published Test Results in an incremental manner through thoroughly analyzed defect reports.
• Used SQL queries to cross-check the backend data.
• Participated in Daily defect calls to elaborate on newly raised defects and also to keep track on the status of existing defects.
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Responsible for drafting Test/Defect Metrics and Test Closure Report.
• Involved in all phases of Software Testing Life Cycle (STLC): Requirements & Design Review, Test Planning, Test Designing, Test Environment Setup, Test Execution and Test Reporting.
• Participated in the SCRUM Backlog grooming, Sprint Planning & Estimation session involving multiple teams.
• Participated in Daily SCRUM meetings (aka 15 minute standup) to keep track of the story update from various development teams and to identify any impediments in our testing sign-off deliverables.
• Identified Critical, High/Medium/Low Priority defects and logging them into the HP ALM Explorer 11.5x defect tracking tool.
• Responsible for testing the application using SQL Queries/ UNIX command for the DB check and server startup/new builds.
• Checking log files in UNIX for back end exceptions, and forwarding the same to developers.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.

Environment: Agile Scrum Methodology, ETL Tools Informatica 8.6.1,HP ALM Explorer 11.5x, HTML, Oracle 11g, Toad, Unix, SQL Developer 3.0, PL/SQL, HTTP, Weblogic 10.3, Microsoft Office 2010.

Confidential, Pittsburgh, PA

QA Manual Tester

Responsibilities:

• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Tested the data and data integrity among various sources and targets.
• Prepared test cases for data validations.
• Developed and involved in both Manual Testing based on Use cases developed.
• Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
• Experienced in writing complex SQL queries for extracting data from multiple tables using joins, analytical functions and aggregate functions.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments.
• Used Quality Center for generating Requirements, Test Sets, and Test Plan and for reporting defects.
• Followed agile development methodology and adhered to strict quality standards in requirement gathering.
• Reviewed the test cases written based on the Change Request document.
• Involved in preparation of System Test Results after Test case execution.
• Created critical scenarios for each change request and defect request.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance.
• Assisted in promotion of ETL Informatica Power center code and UNIX from UAT to Production Testing, Performance Testing and Regression Testing.
• Tested the PL/SQL procedures, functions, packages according to the requirements.
• Actively involved in functional, unit and integration testing in agile methodology.
• Used various SQL queries to validate the test case results for back-end test cases.
• Worked on UNIX environment in Test and UAT environment.
• Checking log files in UNIX for back end exceptions, and forwarded the same to developers.
• Testing ETL components by Executing SQL and PL/SQL Queries.

Environment: ETL Tools Informatica 8.6.1, TOAD, Quality Center 10.0, SQL, PL/SQL, UNIX, Oracle 10g, Agile

Confidential, Madison, WI

QA Tester

Responsibilities:

• Extracted data from various sources like Oracle, flat files and CSV files.
• Performed database testing to ensure the ETL process for the data being extracted, transformed and loaded into the new Database through Informatica.
• Wrote complex SQL Queries against Oracle database to validate Test Cases resulting in verifying all required business scenarios.
• Created expected results and validated the Data Integrity.
• Prepared the Test Data for the Incremental / historical Load testing and validation.
• Use Informatica debugger and session log to debug the defects.
• Understanding the Business Requirement Document (BRD) and Functional Requirement document (FRD).
• Acted as the Subject Expert in the functionality assigned for the project.
• Updated Requirements Traceability Matrix (RTM) to reflect the test coverage.
• Took part in Test Plans Walkthroughs with the development teams.
• Managed and executed the test process, using Agile Methodology.
• Used ALM Explorer for writing Test Plan, Test Cases development, test script writing, Test case execution & Defect Tracking.
• Played a vital role in setting up various Test Environments like Integration Testing Environment, System Testing Environment, User Acceptance Testing Environment and Prod-Fix Environment with the goal of replicating the end-users environment.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Responsible for executing the Data Load Scripts to load the test data into the appropriate database and running the SQL to ensure the accuracy of data load.
• Finalized and published Test Results in an incremental manner through thoroughly analyzed defect reports.
• Used SQL queries to cross-check the backend data.
• Participated in Daily defect calls to elaborate on newly raised defects and also to keep track on the status of existing defects.
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Responsible for drafting Test/Defect Metrics and Test Closure Report.
• Involved in all phases of Software Testing Life Cycle (STLC): Requirements & Design Review, Test Planning, Test Designing, Test Environment Setup, Test Execution and Test Reporting.
• Participated in the SCRUM Backlog grooming, Sprint Planning & Estimation session involving multiple teams.
• Participated in Daily SCRUM meetings (aka 15 minute standup) to keep track of the story update from various development teams and to identify any impediments in our testing sign-off deliverables.
• Identified Critical, High/Medium/Low Priority defects and logging them into the HP ALM Explorer 11.5x defect tracking tool.
• Responsible for testing the application using SQL Queries/ UNIX command for the DB check and server startup/new builds.
• Checking log files in UNIX for back end exceptions, and forwarding the same to developers.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.

Environment: Agile Scrum Methodology, ETL Tools Informatica 8.6.1,HP ALM Explorer 11.5x, HTML, Oracle 11g, Toad, Unix, SQL Developer 3.0, PL/SQL, HTTP, Weblogic 10.3, Microsoft Office 2010.

Confidential, Arlington Heights, IL

QA/Etl Tester

Responsibilities:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Tested all the ETL process that were developed to fetch the data from various feeds into the data warehouse.
• Written SQL scripts for validating the data loaded by the ETL processes.
• Tested the reports developed using Business Objects.
• Perform manual testing and created various test results to track the testing results.
• Export requirement, test cases into the Quality Center, run manual and automation test cases from test lab and log defects from defects module.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Participated to create Test Analysis reports (TAR) and stored them into the Quality Center.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Developed SQL Queries to retrieve or create test data from different Oracle Test databases.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Tested reports in report studio and query studio by using SQL.
• Met with client to present future functionality of the application, gather information from them to know about their need and send this information to test manager.
• Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.