SUMMARY:

• 6+ years of experience in Software Quality Assurance, Testing of Web based and Client/Server applications using HP Quality Center and SQL on UNIX and Windows Platforms.
• Mainly involved in design, development, and execution of Test plans, Test cases for Database and Client/Server applications
• Expertise in Manual testing and hands on experience in writing complex SQL queries for Back - End testing on Oracle and SQL Server.
• Excellent understanding of Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC), and Agile Methodologies.
• Experience in Requirements Analysis and create strategic Test plans, Test Cases, Test Scripts, and Test Reports for both manual and automated tests using HP Quality Center and QTP
• Extensively performed Functional testing, Database testing, Regression testing, Integration testing, Ad-hoc testing, Volume testing, Smoke testing, and Data driven testing.
• Quick learner with excellent analytical and communication skills
• Profound insight to determine priorities, schedule work, and meet critical deadlines within budget guidelines.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center, Quick Test Professional (QTP)

Databases: Oracle 11g/10g/9i, SQL Server 2008/2005

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, HTML, XML

Database Utilities: TOAD, SQL*Plus, Oracle SQL Developer

ETL Tools: Informatica Power center 9.5

Operating Systems: UNIX, Linux, MS-DOS, Windows NT

Microsoft Office Suite: MS Word, Excel, Access, PowerPoint, Visio, Outlook

Other Tools: Notepad++, XML Spy, Text Pad, WS FTP Pro

PROFESSIONAL EXPERIENCE:

Confidential, VA

Sr. QA Analyst

Responsibilities:

• Responsible for Bi-Weekly (Agile Sprint) Project deliverables testing by coordinating with Developers.
• Extensively used SQL Queries to retrieve data from database and prepared standard set of SQL queries for Regression testing activities.
• Involved in preparing Test Cases, Test Scripts, Test strategy document for various Internal and Client projects.
• Analyzed User requirements, attended Change Request meetings to document changes.
• Assigned Test Cases to Application Functional Requirements ensuring traceability throughout the testing process in Quality Center.
• Used QTP to generate automated test scripts for functionality and modified the script using VB Script.
• Executed Back End Test cases using Toad and documented the defects in Quality Center
• Created high level test cases and SQL queries for the ETL Source to Target mappings.
• Extensively performed Functional, System/Integration, Regression testing, and User Acceptance Testing.
• Worked with developers to resolve the defects and communicated with Management team on testing status, issues and risks.
• Involved in preparing weekly status report and defect report.

Environment: HP Quality Center 11.0/9.5, Quick Test Professional 9.0, Oracle 11g/10g, MS SQL Server 2008/2005, Toad, Informatica 9.5, Oracle SQL developer, SQL, T-SQL, Windows 7, UNIX, WS FTP Pro, and MS Office Suite (Word, Excel, Access, PowerPoint).

QA Analyst

Responsibilities:

• Worked with Business Analysts to clarify detailed requirements specification and business needs.
• Decomposed detailed requirements specifications, detail system design documents and use cases into high level test scenarios, test conditions, test cases and test scripts.
• Understand and analyze business requirements for testability and completeness.
• Involved in Developing Manual and Automated test cases and test scripts
• Participate in System, Integration, Regression and User Acceptance testing.
• Understand and apply knowledge of banking business to daily analysis activities.
• Developed and maintained automated test scripts to support regression testing.
• Effectively used SQL queries for Database applications testing.
• Successfully implemented Mercury Quality Center for Requirement Management, Test Design, Test Execution, Defect logging, Requirement Mapping with Test cases
• Prepared Traceability matrix document mapping with requirements and Test cases using Quality Center.
• Troubleshoot the defects and environment issues and thoroughly documented defects along with specific error messages and steps to reproduce
• Assisted the team lead with daily QA tasks, attended project meetings, release meetings, and QA status meetings.

Environment: Test Director/Quality Center 9.2, Quick Test professional, XML, T-SQL, SQL Server 2005, Toad, Windows 7, UNIX, and MS Office Suite (Word, Excel, PowerPoint)

QA Analyst

Responsibilities:

• Developed Test cases by analyzing the functional and technical specifications.
• Execute test cases to ensure that requirements have been met
• Performed Functional, Regression, GUI and Database testing.
• Involved in System testing, User Acceptance Testing and Integration testing.
• Performed manual user experience testing and verified whether the application is in the tolerance level of the user or not.
• Logged and reported the defects to the build team using Mercury Quality center.
• Attended weekly meetings to present the QA status report and defect status report.
• Follow the bug life cycle and keep track of defects until it gets closed.
• Involved in creating Test deliverables such as test reports, test release report, defects.
• Involved in Result Analysis, Identification & Isolation of the Defects.
• Ensured minimum defect leakage and Follow up with issues and defects until they are resolved.

Environment: Mercury Quality Center, XML, Teradata, SQL, VB, Java, Windows XP, IE, UNIX, Excel, UltraEdit

QA/Validation Engineer

Responsibilities:

• Reviewed requirements and design specifications to identify gaps and ensure documented project criteria are clear, consistent and testable.
• Created and executed Test cases using Quality Center
• Mainly Performed functional, system and regression testing on CBRS project
• Used XML Spy to create test data.
• Created Negative test scenarios, Boundary tests for CBRS rules engine to see proper output rule trigger
• Created SQL queries for back-end data validation.
• Created weekly status reports for team management on behalf of QA team.
• Used Clear quest for defect tracking and defect analysis
• Participate in issues resolution and change control process.
• Created UAT test data and test cases for User Acceptance testing
• Attended Status meetings and change request meetings
• Performed Regression testing for previously identified defects.
• Prepared test summary document for Servicer release project.
• Thorough documentation was created for all Test Artifacts

Environment: - Quality Center, Rational Clear Quest, TOAD, Oracle 10g, MS Access, MS Excel, MS Word, and Visual Studio Team foundation Server (VSTS)