Professional Summary

• More than 7 years of experience in Quality Assurance testing of client/server, Web based using manual and automated testing tools.
• 2+ years of experience using applications using Mercury interactive testing tools Quick Test Pro 8.x/9.x, Mercury Quality Center 8.x/9.x, IBM Rational Tools Clear Case, Clear Quest and Test Manager.
• Excellent working knowledge of designing and implementation of all QA test strategy plans manually and automated test solutions for client/server and Web based applications.
• Involved in the entire software development process monitoring and improving the process and making sure that standards and procedures are followed and also ensuring that problems are found and fixed.
• Experience in documentation of Test Plans, Test Cases for the Web and Client/Server Applications.
• Experienced in Functionality testing, Black Box testing, System Testing, Integration, Regression Testing, Database Testing and Browser Testing.
• Very Good Exposure in Functional, Usability, Regression and Sanity Testing
• Comfortable with various Industry Leading Operating systems (Windows 95/NT/98/2000/XP and UNIX flavors).
• Excellent skills in overall Defect Management/Problem Solving including Tracking Bugs, Reporting using Mercury Quality Center and IBMClear Quest.
• Comprehensive knowledge of Client Server architectures, Distributed Computing, Use Cases and various databases like Oracle (7.x, 8i and 9i) and PL/SQL.
• Strong understanding of the Software Development Life Cycle (SDLC) and QA Life Cycles.
• Ability to interact with developers and product analysts regarding testing status and Defect Tracking.
• Excellent team player with good communication and interpersonal skills.
  

Tools : Mercury Quick Test Pro 9.0, Quality Center 9.0, Win Runner 7.0 and Load
Runner 9.0
Microsoft Tools : MS office Suite (Word, Excel, PowerPoint), Adobe Acrobat Reader.
Bug Tracking Tools : Quality Center, IBM Clear Quest.
Databases : MS SQL Server, Microsoft Access and Oracle.
Languages : HTML, SQL, PL/SQL, T-SQL, Visual Basic, C#.Net, ASP.Net
Scripts : VBScript and Java Script
Operating Systems : Windows 98/NT/2000/XP/Vista/2003/2007,UNIX
SDLC Methodologies : Waterfall, Agile (SCRUM)

Professional Experience:

Confidential, Columbus OH APR 10 - Till date
Role: QA Analyst
Description:

Confidential, is an Americanmultinationalbanking corporation ofsecurities,investmentsandretail. It is the largest bank in the United States by assets. It is a major provider offinancial services, and according toForbesmagazine is the world\'s second largest public company based on a composite ranking.

Responsibilities:

• Wrote and maintained Test Cases, Test Plans, and Scenarios using Mercury Quality Center.
• Create Requirements using Quality Center and generate Traceability Matrices to ensure that all the requirements are covered by the test cases.
• Execution of test cases, verification the actual results against the expected and documenting in the test plan.
• Performed Manual Testing and Automated Testing.
• Conducted Partly Unit, Component Integration, System and UAT Tests.
• Identify the common Automation flows so as to write the QTP functions and also write the Generic functions such as Verifying the Pages and Entering Data on Pages etc.
• Validated various XML Interfaces and web services (SOAP).
• Executed of Test cases using Quick Test Pro to check the Product pricing and eligibility rules avoiding the User Interface of system by providing the test data, default data, decision engine to
  check the eligibility.
• Modify the test data, default data using Quick Test Pro as per the changes in guidelines, new regulations, and addition/modification.
• Tracked and advised process changes for better coverage for many test cases from regression view
• Monitored and facilitated any issue resolution or escalations that were necessary for testing.
• Tested GUI by inserting checkpoints in QTP scripts for single or multiple objects and text.
• Perform Functional and System Integration Testing for all interfaces.
• Checked the Integrity of the Backend Data by creating Database functions and also by Database
  Check Points using QTP
• Prepare Defect Report, Weekly Status Reports, and Bug tracking.
• Involved in testing of each phase of the application using Quick Test Pro and Quality Center.
• Tested Database integrity testing by executing SQL statements on Oracle database.
• Documented Test Plan and Test cases using Quality Centre, classifying them based on the functionality of the application.
• Generated SQL and Run Query to generate Reports (Front-end) and compare the results with that of Oracle (Back-end).
• Provided clear concise feedback to development team on recurring defects with an aim of long-term reduction of defects found in final release.
• Provided back end testing for database auditing and data validation using SQL queries.
• Interacted with Business Analyst and developers inresolving the issues.
• Worked with QA and Data Analyst to develop Test Cases and set up Test Data for Performance testing.

Environment: ASP.NET, SQL, PL/SQL, Oracle10g, MS Office, Mercury Quality Center 9.0 and QTP 9.0

Confidential, Charlotte NC JUNE 08 - MAR 10
Role: QA Analyst.

Confidential, headquartered inCharlotte, North Carolina, is the largest electric power holding company in theUnited States. Duke Energy Generation Services (DEGS), a subsidiary of Duke Energy, specializes in the development, ownership, and operation of various generation facilities throughout the United States

• Written the Test Cases for- Unit Level, Functional and Regression Testing.
• Executing the Test Cases, and analyzed the Test Results.
• Analyzed and identified the Test Cases based on the requirement document of the application.
• Reviewing and Modifying the Test Cases.
• Writing Test Definition Files and functions wherever necessary for various units of the business
• modules
• Developed the Test Cases and executed using QTP.
• Performed Data Driven Testing for multiple sets of data.
• Penned SQL queries to access the data from the database and crosscheck the result.
• Conducted smoke testing, batch testing and black box testing.
• Performed Regression, Integration and Functional testing using QTP.
• Attended Walkthrough and review meetings with Business Analysts & Development team.
• Interacted with Developers and Business Analyst for clarifications of missing functionalities
• Recording the Test Definition Files as per the Test Cases written.
• Involved in the Defect Status Reporting, Prepare Bug Summary Reports and release notes.
• Effective coordination between development team and testing team.

Environment: Mercury Quality Center 9.0, C#, ASP.Net, SQL Server 2005.

Confidential, JUL 07 - MAY 08
Role: QA Analyst

• Wrote Test cases for Functionality, Security, Database and Acceptance testing of the software.
• Executed Test cases manually against expected test results.
• Extensively used SQL queries for interacting with the Oracle Database.
• Validated Source files data with the Staging tables, ODS tables and Target tables.
• Tracked and managed the defects with Quality center.
• Performed System Test and end to end test manually.
• Worked with Data Warehousing developers who extensively used Informatica, to design mapping to move data from source to target database using Stages to do the functionality
• Prepared Test Matrix and Test Procedures for the different modules of the application.
• Installed, maintained and used Testing software. Set up the test environment and created the Test data.
• Performed Integration and Regression Tests and created the regression test suite.
• Modified test scripts to accommodate GUI changes in the new versions of the product.
• Created bug reports, verified bug fixes, logged bugs into Bug Tracking System and Presented progress of the testing process at status meetings.
• Server, Application Server and Database Server to identify any bottlenecks in the network.
• Interacted closely with the development team and DBA with all the analyzed results.
• Created customizable graphs and reports indicating the final analysis of the test plan to project requirements coverage, test readiness and overall application quality using Test Director.
• Participated in Control Body meetings, to investigate the software bugs using Test Director, documented and tracked defects using Test Director.
• Strong understanding of Mortgage Loan Origination and servicing, FIX protocol, Equities, Stocks, Mutual funds etc.

Environment: HTML, DHTML, XML, Oracle 9i, TOAD 9.0, Win runner, Mercury Test Director 8.0

Confidential, Atlanta, GA APR 06 - JUNE 07
Role: QA Tester
Description:

Confidential, offers hospital surgery software that captures clinical, medical and financial data on every patient event from surgery scheduling through transcription of the surgical report. StatCom is a workflow communication tool from Surgical Information Systems, which gives the status of a case or staff member, or the location of a patient or important equipment.

Responsibilities:

• Create Test Plans, Test Cases and logs defects in Test Director.
• Converting high-level test requirements into reliable, repeatable, and maintainable test cases.
• Generating scripts that handle error condition and perform GUI interface verification.
• Planning, scheduling and coordinating testing in conjunction with the application development and support teams.
• Tracking and managing defects (i.e. communicate with developers regarding the status)
• Created different types of scenarios to run with the available virtual users.
• Monitored the performance of the various online monitors as per required.
• Conducted Functional, Integration, System, Regression, Performance, Load/Stress, White and Black Box Testing.
• Created analysis sessions and collated execution results.
• Used SQL to perform Backend testing.
• Viewed summary reports, creating HTML reports, and worked with transaction reports.
• Involved in test cases and wrote scripts manually.
• Writing user defined functions and calling those functions from the compiled module.

Environment: Windows NT, Servlets, EJB, XML, Oracle 9i, Win runner, Informatica, Mercury Test
Director 7.6. SQL Server 2000,

Confidential, DEC 04 - JAN 06
Postal Department, India
Role: Developer

This product is developed for postal agents to print Recurring Deposit Forms. The system contains postal agent's information and customer information. The system will capture daily deposited accounts information and their amounts and print these accounts total amounts along with postal agent information on the forms. It has master tables like postal agent and customer information and transaction tables like recurring deposit master and recurring deposit child tables. It also has security table which has all user accounts information.

Responsibilities:

• Developed User Controls to reduce the Complexity in User Interface Coding and provide better look and feel.
• Wrote and maintained Test Cases, Test Plans, and Scenarios using Mercury Test Director.
• Design and Development of Win Forms using VB.NET.
• Created stored procedures, Views, Cursors, Indexes and Triggers by using PL/SQL.
• Used ADO.NET in VB.NET to execute stored procedures.
• Developed various reports by using Crystal Reports Bundled Version for .NET.
• Involved in Unit Testing.
• Expected test cases manually to verify the expected results.
• Involved in Reference tables updates as part of Testing.
• Regression tests were performed after every bug fix and system enhancement.
• Performed manual testing for the entire application and reported the defects to the developer using Bugzilla.

Environment : Mercury Test Director 8.0, VB.Net, Crystal Reports and SQL Server 2005