PROFESSIONAL SUMMARY

• Around 6 years of experience in Information Technology as QA Tester Testing various applications in client server and web based architecture
• As a QA Tester/Test Engineer involved in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) keeping in accordance with Standards involved in the process of the application in various domains like Insurance, Banking and Health care
• Extensive experience in Black box testing in manual testing and Quality Center and Test Director
• Proficient in reviewing, analyzing process flows, Requirement functional specifications and system specifications
• Expertise in preparing Test cases, Reviewing the Test cases, Executing the Test case and Test reporting
• Experience in preparing and reviewing Requirements Traceability Matrix (RTM) to match the Test cases created with the Requirements.
• Performed back end/database testing using SQL and database objects with Major RDBMS systems including Oracle, Microsoft SQL Server and DB2.
• Participated in preparing and reviewing Test Strategy, Test Plan, and Test Summary Reports for manual testing
• Performed various testing like GUI/UI Testing, Sanity Testing, Functional Testing, Black Box Testing, Data Driven Testing, Web Testing, Regression Testing, User Acceptance Testing, Security testing in various domains.
• Experience in tracking the bugs using the bug tracking tools such as HP Quality Center v9.2/v10, Mercury Test Director v8.0
• Experience in Testing the Interfaces such FTP the files from external systems to Unix Environment and loading the data into Oracle and SQL tables and verifying the data
• A good team player and can work independently.

EDUCATION

• Bachelor Degree in Computer Applications

TECHNICAL EXPERIENCE

Visual Basic 6.0, .Net, JavaScript, VBScript, MS Office ,Visio

DBs & RDBMS

Oracle 10i, SQL Server, DB2, TOAD, SQL Server Management Studio, SQL Plus, Oracle SQL Developer

Operating Systems

Windows, UNIX

Testing Tools

Test Director, Quality Center

Web Technologies

HTML, XML, ASP.NET, VBScript, JavaScript, SAOPUI

Reporting Tools

Crystal Reports, Business Objects

Version Control

Share Point, TFS, SVN, CVS

SDLC

Agile and Waterfall methodologies

PROFESSIONAL EXPERIENCE
Confidential,Columbus, OH April’11 to Present Quality Assurance Analyst

Nationwide has grown from a small mutual auto insurer owned by policyholdersto one of the largest insurance and financial services companies in the world, with more than $135 billion in statutory assets.

Involved in performing quality assurance activities for Bank Deposit Application project used for both Internet and Intranet. Electronic application to Agent for non-internet delivery channels of deposit application. Internet Bank Deposit Application for deposit products offered by Nationwide Bank to increase functionality for the customer and gain internal flexibility and efficiencies to respond to customer needs.

Responsibilities:

Responsible for full lifecycle testing of Web based applications at Nationwide. The applications included are: insurance claims processing and accounting systems.

• Analyzed and reviewed the functional Requirements, functional specifications, system requirements, process flows, product design document and test specification documents for auto and property business lines
• Participated in designing and maintained testing process documentation, plans and strategies
• Mentored, coached and trained other test engineers in manual testing
• Created Test Cases for user interface, functionality, system and ad-hoc testing keeping in accordance with standards involved in the process of the application
• Manually executed Test cases after reviewing the business requirement document and technical specifications and responsible for updating existing test cases against the requirements
• Executed test cases and logged defects using Quality Center
• Executed end to end Test plans and compared actual results to expected results
• Performed functional, integration, and system testing
• Performed Black Box, Smoke/Sanity and Regression Testing
• Performed UAT in preproduction testing environment
• Investigated bugs and consulted business Analysts and developers to reproduce, resolve and retest
• Involved and collaborated in meetings and in WebEx session to solve issues, defects and design of the system with the product application developers and business units
• Performed UI/GUI Testing and database testing
• Experience in Testing the Interfaces such FTP the files from external systems to Unix Environment and loading the data into Oracle and SQL tables and verifying the data
• Queried database using the SQL for data validations
• Performed webservice API testing using SOAP UI
• Reported status in project and updated management and the integration team(s) on issues
• Responsible for defect management by recording, reporting, analyzing and tracking defects to resolution
• Developed and maintained Requirement Traceability Matrix (RTM)

Environment: Windows 2008, Windows XP, MS Office 2010, Visio, IE, .Net/ASP.Net, XML, Quality Center, TFS, Web Services Definition File (WSDL), Microsoft Visual Studio 2010, .net framework 4.0, HTML, Java Script, SQL Server 2008, Oracle 10i, IIS, SQL, SOAP UI , Oracle SQL Developer, Oracle 11G

Confidential,Columbus, OH Feb ‘10 – Mar ‘11
Quality Assurance Analyst
Project: ebusiness applications
Cardinal Health, Inc. is a care services company based in The firm specializes in distribution of pharmaceuticals and medical products, serving more than 60,000 locations. The firm also manufactures medical and surgical products, including gloves, surgical apparel and fluid management products.

Responsibilities:

• Developed test cases and test matrix using specifications, use cases, and data mapping documents.
• Performed Functional, Security, Integration and Regression testing during various phases of development of ebusiness applications using various Web Browsers.
• Performed data validation against business test cases to make sure data is referentially intact, check constraints are working as expected, database triggers are functioning as expected
• Interacted with Developers to resolve functional/performance issues. Tracked all defects using Quality Center and generated reports on test metrics that include total number of test cases, number of test cases passed, number of test cases failed, blocked test cases due to environmental reason, etc...
• Performed Cross Browser Testing on Internet Explorer and Google Chrome, Mozilla Firefox. Cross Browser testing was required to make sure there are no compatibility issues with the application on different versions same and different of web browsers.
• Provided walkthrough sessions on the new features Tested and gathered feedback from Business Analysts.
• Experience in writing SQLs to validate the data in SQL Server 2008 and DB2 Tables.
• Data migration from DB2 to SQL Server 2005
• Retained documentation necessary to plan assigned testing. Documents include test strategy, test plan, test data, test cases and sign-off documents required to complete testing phase.

Environment: ASP.Net, Microsoft Visual Studio 2005, .net framework 3.5, SQL Server 2005, C#, JavaScript, Unix, Quality Center, DB2, TSO, SPUFI, Windows XP, MS Office and Web Browsers.
Confidential, OH Nov’08 – Oct’09
QA Tester
Project: OLBA, OLBP and OLCC

The Online banking application (OLBA) allows the customers of the bank to check balances make transfers and view recent transactions. Online Bill payment module (OLBP) and Online Credit Card Payment module (OLCC) integrates tightly with A/R and A/P systems; support back-end processing work flows.

Responsibilities:

• Created test plan document using project requirements and design documents. Test Plan document contains project scope; requirements trace ability matrix, and available environments that require to complete testing.
• Created test cases using requirements and low-level design documents to complete Functional, Integration and Regression Testing.
• Conducted walk-through meetings to review test plans and test cases. During walk-through meetings, test plans and test cases are reviewed by Business Analysts, QA Analysts and Developers to make sure all requirements are covered in the documents.
• Utilized Quality Center for Test Management activities.
• Used Clear Quest to perform defect management tasks like defect tracking, update defect status, and generate defect reports.
• As the defects were identified, was responsible for coordinating with developers to ensure correct understanding of the problem. Once the error was corrected, additional tests were performed to ensure accuracy.
• Used SQLs to verify data is referentially intact between related tables, column constraints are implemented for code values wherever applicable.
• Retained documentation necessary to plan assigned testing. Documents include test strategy, test plan, test data, test cases and sign-off documents required to complete testing phase.

Environment: ASP.Net, Microsoft Visual Studio 2005, .net framework 3.5, SQL Server 2005, C#, JavaScript, IIS, TFS, Unix, Quality Center, Windows XP, MS Office and Web Browsers.

Confidential,OH Aug’07 – Oct’ 08
Quality Assurance Analyst

Nationwide has grown from a small mutual auto insurer owned by policyholdersto one of the largest insurance and financial services companies in the world, with more than $135 billion in statutory assets. Nationwide has been in business for more than eight decades.

Responsibilities:

Responsible for full lifecycle testing of Web based applications at Nationwide. The applications included are: insurance claims processing and accounting systems.

• Analyzing the business and system requirements.
• Participated in preparing the Test Strategy and Test plan.
• Preparing Test design, Test cases & Test procedures.
• Creating and reviewing change requests.
• Executing the test scripts and logging the defects.
• Written Sqls and validated the data in Oracle database
• Performed functional, system and regression testing.
• Interacted with Developers to fix various issues relating to software defects.

Environment: Java, J2EE, Weblogic Server, JSP, Java Script, HTML, JDBC, Oracle, Toad, SQL, SQL Plus, Microsoft Office, Windows 2000, Windows XP

Confidential, Feb’ 05 to May’ 06
Tester
Project: CMSP & PTS

CMSP is an intranet Content Management System Portal is a hospital administration system for employee/doctors to create their own websites and to publish. PTS is a Patient Tracking System that tracks the individual patience electronically maintained records and history.

Responsibilities:

• Analyzed the business requirements, functional specifications, system requirements process flows and test specification documents.
• Created Test Cases, mapped requirements to the Test Cases designed,
• executed tests and logged defects using Rational ClearQuest
• Performed Functional, Black Box, and Regression Testing.
• Analyzed Error log files to find the root cause of issue.
• Responsible for defect management and analysis after defects fixing.
• Developed and maintained Requirement Traceability Matrix (RTM).

Environment: Visual Basic 6.0, Oracle 9.0, SQL, Windows 2003, IBM Rational ClearQuest, Microsoft Office 2003