Summary:

• More than 6 years of experience as a QA Analyst in Software Testing of Web Applications andClient/Server Applications
• Good experience in Functionality testing, System Testing, Regression testing and User Acceptance testing
• Knowledge on Software Development Life Cycle methodologies
• Extensive working experience in both Automation and Manual Testing of Client Server & Web based Applications
• Experience in developing testing documents such as Test Strategies, Test Plans, Test Procedures and Test Cases.
• Strong knowledge of QTP
• Experience in Writes Automated Scripts based on working manually executable test cases which are supplied by functional test engineers.
• Experience in Data-Driven automation tests, automation coding such as VBScript.
• Experience in Creating and maintaining Libraries and Object Repositories for the Automation Frameworks.
• Experience in Reviewing broken scripts or suites and helps the automation team resolve issues with the running of scripts.
• Experience in both Functional Testing and Non-Functional Testing
• Extensively used Quality Center for Defect Management
• Experience in preparing and executing Test cases based on Business requirements and Technical Specifications
• Strong skills in back-end testing using SQL Queries on SQL, Oracle (TOAD), MS Access
• Experience in writing Queries in order to retrieve the data from the database like Oracle and SQL Server
• Good team player with right communication skills
• Hosted Defect Status meetings with developers and Business Analysts to validate the severity and responsible for tracking of the Defects from open to closure

Education:

• Master of Commerce from Confidential, University
• PG Diploma in Computer Applications (PGDCA)

Technical Skills:

Operating System: Windows 98/NT/2000/XP, UNIX
Languages: JAVA, J2EE, .NET, COBOL, SQL and Visual Basic
Internet Programming/Tools: VB Script, Java Script, HTML, XML
Database: Oracle 11g/10g, SQL Server, DB2, MS-Access
Testing Tools: Quick Test Pro 11/10
Bug Tracking System: Quality Center, Bugzilla
Documentation Tools: MS Office 2003/2007, Adobe Tools, Visio

Professional Experience:

Confidential,Bloomington, IL September 2009 Till Date
Test Analyst
Description:
This is a one of the fortune insurance company in the Midwest region and has been in the business of providing excellent automobile, Homeowners insurance coverage at an affordable price since 1922. As Test Analyst in P& C Test Delivery my primary responsibility is verifying that systems solutions meet functional and technical requirements.
Responsibilities:

• Created Test Strategies.
• Created Test Plan by including detailed testing scope, testing requirements, success criteria, milestones, and necessary resources
• Involved in redefining the test strategies which work for the project environment.
• Manually performed Ad-Hoc testing, end-to-end testing, and system testing
• Performed manual testing by entering positive values, negative values, and boundary values to the application
• Strong Database (Oracle, SQL Server, MS Access) testing skills using SQL.
• Performed Integration, Regression, Systems, and Backend testing
• Created, maintained and updated regression suites upon receiving new build
• Worked on conversion of manual tests into automated test scripts
• Customized the scripts using Checkpoints, Functions, and user-defined functions
• Validated old-side/new side results.
• Create and execute Database Scenarios for validating data by running SQL queries and performing Database verifications.
• Involved in writing SQL statements to create test data for test cases and data validation tests to extract data from the tables
• Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins used TOAD and SQL Developer
• Verified Data with the Toad Interface tool running SQL queries in the Data Base (Oracle 9i).
• Generated Test Plan, Test Cases in Test Director
• Tested the application on different Browsers like IE, Netscape Navigator
• Checked the Client side and Server side validations
• Performed GUI test for Data entry screens
• Participate in Triage team meetings.
• Used Quality Center as a defect management tool to create and track testing defects

Environment: Manual Testing, QTP, Quality Center, Java, JSP, VB Script, EJB, XML, HTML, MS SQL Server, TOAD, SharePoint, Oracle9i, Windows XP.

Confidential, Kentucky December 2007 August 2009
Test Engineer/Analyst
Confidential,Testing
Confidential,is leading Player in US healthcare industry. Humana Inc uses many applications to create a new healthcare product, rating and quoting, claims adjudication etc. These applications serve as an integrated solution for Humana Inc for its business. The project involves integration testing of various subsystems such as products, claims etc. Testing is initially done manually and then migration to QTP.Responsibilities:

• Analyze functional requirements, writing Test plans
• Wrote test procedures for the front-end GUI standards
• Involved in writing and implementing numerous Test Cases and Test Scripts
• Performed Manual Testing
• Performed Functional and User acceptance Testing
• Spearheaded implementation of Mercury test suite and assisted with coordination of new test lab equipment and setup
• Creating and maintaining libraries and object repositories for the Automation Framework.
• Work closely with manual test engineers for automating existing test cases.
• Write effective and thorough bug reports and verify bug fixes.
• Development of a test framework per application
• Work with developers to integrate automated tests with end-to-end build and test environment.
• Reviewed broken scripts or suites and helps the automation team resolve issues with the running of scripts.
• Writes automated scripts based on working manually executable test cases which are supplies by functional test engineers.
• Created complex SQL queries to test the Backend functionality of the application
• Performed Back end testing by writing SQL statements using SQL Plus and TOAD
• Used Toad and Win SQL to validate the data in Database
• Performed operations on the front end and check all the tables involved whether they are updated correctly as per the specifications.
• Verified Data with the Toad Interface tool running SQL queries in the Data Base (Oracle 9i).
• Regression tested the interfaces to make sure that existing functionalities are not impacted by the changes
• Performed System Integration testing to ensure the integrity with database.
• Performed Navigational, Functional, Ad-hoc, Sanity and Regression tests
• Preparation of Test Metrics, Requirement Traceability Matrix documents.

Environment: Manual Testing, Automation Testing, Oracle9i, VB scripts, MS SQL Server, QTP, TOAD, Quality Center, Windows XP.

Confidential,Chicago, IL November 2005 November 2007
Test Analyst
The Customer Automation and Reporting Environment (the "CARE"), owned and operated by U.S. Bank National Association ("U.S. Bank"), is provided to the customer under the terms and conditions of Customer Automation and Reporting Environment Terms of Service (CTS), which incorporates by reference any operating rules, or policies that may be published by U.S. Bank.
Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the user/business requirements and functional specs documents.
• Analyzed and helped in modifying the use cases using MS Visio and created the Test cases. Worked on conversion of manual integration tests into automated tests using WinRunner
• Executed tests and participated actively in system testing and regression testing.
• Developed and maintained automated test scripts to support regression testing.
• Used the Test Director as a repository for all of the testing efforts.
• Worked with the SQL statements to extract data from DB2 tables and verify the output data of the reports on the browser page
• Used Quality Center for the defect reporting and tracking

Environment: IBM Mainframe, DB2, Manual Testing