Sql Server Test

PRIYANKA B

862-***-**** /************@*****.***

SUMMARY

• Over 8 years of professional experience in Information Technology with extensive experience in Quality Assurance and performing Manual, Automated and performance testing.

• Experience in analysis, design, development and testing of Web-based and Client-Server technologies.

• Strong knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

• Experience in performing systems/functional testing in a Waterfall and Agile Software Development environment

• Good experience with testing tools like QTP, Quality Center, TestDirector, Win Runner and Load Runner.

• Proficient in analyzing system requirements, use cases and other documents to gain overall understanding of the application.

• Good testing skills which include preparation of test plan, test scenarios, test cases, test scripts and bug reports.

• Experience in working with diverse industries such as Financial, Health Care and Insurance.

• Involved in designing and maintaining Requirements Traceability Matrix.

• Experience in test design, defect tracking & management, and test reporting.

• Diverse work experience on functional testing, integration testing, GUI testing, system testing, regression testing, database testing, user acceptance testing and compatibility testing.

• Experience in bug tracking tools like TestDirector, Quality Center and Bugzilla.

• Proficient in writing complex SQL queries to extract data from various source tables to perform database testing.

• Experience in analyzing the bugs and interacting with developers and team members in fixing the defects.

• Good expertise in peer reviews.

• Expertise in analyzing the test results, reporting suggestions and documenting the Test Plan, Test Cases and User Manuals.

• Experience in preparation of various reports (Daily Status Report, Weekly Status Report, Monthly Status Report, Daily Test Execution Report, Test Summary Report).

• Excellent communication, presentation, interpersonal skills and leadership qualities.

• Experience in different languages like VB, .NET, Java, SQL, VBScript, HTML and XML.

• Experience in different database like SQL Server, Oracle and MS-Access.

• Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies.

EDUCATION

• Bachelor of Technology in computer science from JNTU, India

SKILLS

Testing Tools : Quick Test Pro (QTP) 9.2/9.5/10.0,

Load Runner, Win Runner

Defect Tracking Tools : Quality Center 9.0/10.0, TestDirector 8.0, Bugzilla

Database Technologies : SQL Server 2000/2005, Oracle 9i/10g,

MS-Access 2000/2003

Internet Technologies : VB Script, Java Script, HTML and XML

Languages : SQL, PL/SQL, C, C++, Java, JSP, .NET, VB, SAS

Operating Systems : Windows 2000/XP/Vista and UNIX

Others : MS Word, Excel, PowerPoint, MS Query Analyser,

SQL Server Studio, AQT, Outlook and Lotus Notes

EXPERIENCE

MetLife, Somerset, NJ Oct’2010 – Jun’2011

QA Tester

Metropolitan Life Insurance is one of the leading insurance companies providing auto and proprety insurance to its customers. The application allows the electronic interaction between the company and various contractors. All the open claims made by the customers are entered into the databases that are related to property or autos that could be reviewed by the contractors. They can submit their estimations there for the claims that can be reviewed by the company officials.

• Involved in both manual and automated testing using the automated tool QTP.

• Responsible for QA test suite development, execution and analysis.

• Developed and executed the test cases based on business requirements and functional specifications.

• Responsible for the test data while executing the test scripts.

• Interacted with developers to resolve the problems while executing the test scripts.

• Automated scripts were developed using QTP to perform regression testing.

• Involved in functional testing and verified the application, as per the user requirements.

• Created Test Cases and Defects in Quality Center.

• Used Quality Center for generating the status reports (Test Case Status Report and Defect Status Report) for QA Manager and Project Lead.

• Worked with developers to resolve problems and managing the process for smooth transition between development team and testing team.

• Performed positive and negative testing and tested for boundary cases.

• Designed manual test cases in Mercury Quality Center under Test Plan Module for new functionality

• Mapped the test cases to requirements under the Requirements module in Quality Center for Traceability

• Generated error reports and distributed to the team.

• Wrote different SQL queries to access data from different database tables, and used for data verification.

• Reviewed various reports prepared by Test engineer.

• Involved in peer reviewing of test cases and sending appropriate comments.

• Participated in team meetings for test case reviews and status updates on daily/weekly basis

Environment: QTP 10.0, Quality Center 10.0, Agile, AQT, Java, J2EE, JSP, Web Services, XML, HTML, Java Script, VB Script, SQL, Oracle 10g, Internet Explorer, MS-Office, UNIX and Windows.

Capital One, Richmond, VA Aug’2009 –Oct’2010

QA Tester

Capital one is a diversified bank that offers a broad array of financial products and services to consumers, small businesses and commercial clients. The Loan Path project mainly deals with credit application which includes major functionalities like creating credit applications, programs, partners and associating them. My major involvement is in credit application which performs credit checks, process the fund requests and book the application for the customers. It also determines the customer eligibility for the loan.

• Involved in automated testing using QTP.

• Responsible for writing the scripts for daily/weekly smoke tests, regression tests.

• Created scripts using HP/Mercury Quick Test Professional 10.0 for the purpose of loading data through a user interface.

• Successfully implemented the new architecture and written script for it

• Using Data driven design, written a driver script which run all smoke tests

• Created the defects in QC and validated the defects assigned to me.

• Inserted SQL Queries in to the scripts and have coded CTB Scripts

• Developed and executed the test cases based on business requirements.

• Involved in functional, regression testing and responsible for tracking, reporting and closing the defects.

• Prepared status summary reports with details of executed, passed and failed test scripts.

• Responsible for the collecting the test data while executing the test scripts.

• Interacted with developers to resolve the problems while executing the test scripts.

• Interacted with manual team to better understand the test cases they have written.

• Automated scripts were developed using QTP to perform regression testing.

• Involved in functional testing and verified the application, as per the user requirements.

• Worked with developers to resolve problems and managing the process for smooth transition between development team and testing team.

• Performed positive and negative testing on the credit application.

• Wrote different SQL queries to access data from different database tables, and used for data verification.

• Involved in peer reviewing of scripts and sending appropriate comments.

• Participated in team meetings for test case reviews and status updates on daily/weekly basis

• Log project related issues in the defect tracking tool identified for the project.

Environment: QTP 10.0, Quality Center 10.0, RAD, Java, J2EE, JSP, Web Services, XML, HTML, Java Script, VB Script, SQL, Oracle 10g, Internet Explorer, PVCS, MS-Office and Windows.

Travelers Insurance, Hartford, CT Oct’ 2008 – Jul’ 2009

QA Tester

This project deals with Corp ID Application that assigns and tracks unique Travelers corporate identification number given to all persons requiring access to Travelers locations. It is also used by the various help desks throughout Travelers for authentication in a password reset circumstances. Worked as a system tester and performed manual testing and automated testing.

• Designed and documented all valid test scenarios based on requirements set forth by business using the business requirement and functional specification documents.

• Decomposed business requirements to write test steps and created test cases.

• Prepared Test Cases according to the business specification and wrote scripts.

• Implemented the whole life cycle of QA methodology starting from planning, capturing, creating, executing, reporting and tracking the defects using Quality Center.

• Performed manual and automated testing.

• Performed functionality testing manually and conducted system, integration and regression testing of the AUT.

• Extensive involvement in backend testing using SQL Queries.

• Conducted data and integrity testing of the database and usability testing manually.

• Maintained Traceability Matrix and performed Gap Analysis.

• Coordinated with the developer on defect status on regular basis.

• Used Quality Center to track and analyze defects.

• Analyzed test results using reports and graphs generated in Quality Center.

• Made extensive use of MS Office tools to create and maintain documents such as test plans, test execution and test results documents.

• Evaluate test process with the customers and project team.

Environment: QTP 9.2, Quality Center 9.0, VB.NET, Active X Controls, MS SQL Server 2005, SQL Server Management Studio, MS-Office and Windows.

Intuit, Marshfield, MA Jul’ 2007 – Sep’ 2008

QA Tester

Intuit develops products for business and financial management for small businesses, accounting professionals and consumers. This project was on a web based application which was developed for placing ecommerce orders for intuit products like TurboTax QuickBooks and quicken. This project is to enhance product downloads and account management.

• Reviewed business requirement documents and the technical specification documents.

• Developed test plans, test scenarios, test cases from business requirements documents and performed functionality, interoperability, and compatibility tests.

• Executed test scripts, analyzed the results and reported the test results to the project teams.

• Conducted manual, black box, gray box, functional, regression, data driven and navigational testing on the application using Internet Explorer.

• Performed authorization testing on download redesign new mechanism.

• Conducted functional and regression testing on account management system.

• Prepared the test scenarios and test cases for testing the application.

• Identified and logged defects in Bugzilla.

• Performed back-end testing with extensive use of complex SQL queries.

• Performed regression testing for all the internal releases.

• Tested different links for the user’s to navigate through the site with hyperlinks.

• Developed final test reports and actively interacted with development and business analysts to verify new updates in business requirement.

• Involved in weekly project meetings with development/QA teams to review the development and QA updates and discuss the bugs.

Environment: Bugzilla, SQL, Java, JSP, HTML, XML, Java Script, Oracle, Internet Explorer, MS Office, UNIX and Windows.

ICICI Lombard Ltd, India Jul’ 2002 – Dec’ 2005

Software Test Engineer

ICICI Health Master is a premier claims management tool that offers a high degree of automation and data capture. ICICI Health Master provides different options for claims management. Medical and hospital claims can be processed online or electronically. ICICI Health Master’ electronic commerce capabilities are designed to accept external claims.

• Reviewed Business Requirements Documents and the technical specifications.

• Wrote and executed test cases based on the user requirements.

• Involved in writing test case matrix, summary reports.

• Designed and implemented test cases using boundary value analysis, Equivalence class partition, and error guessing.

• Logged and tracked defects, prepared defect statistics report, defect data report and defect charts.

• Verified ecommerce functions as online application processing with credit cards.

• Used SQL queries to access data from different database tables.

• Extensively used SQL queries to verify the data in the database.

• Reported defects found during test cycles and tracked the defects and retested in fixed modules.

• Interfaced with subject matter experts and developers to resolve the problems while executing the test scripts and test cases.

• Involved in defect reviews, and known issues reviews with developers.

Environment: Win Runner 7.0, TestDirector 7.0, VB, Active-X Controls, SQL Server, Query Analyser, MS Office and Windows.

Contact this candidate