Sql Server Testing

KAUSALYA

PROFESSIONAL SUMMARY:

• * Years of Experience in Testing Methodologies with experience in manual and automation testing of various projects involving Functional testing, Integration testing, System testing, Regression testing, Performance testing and new feature testing.

• Extensive experience in Software Testing of Web-based, Client/Server and backend database applications

• Experience with automation tools such as QTP, Win Runner, Loadrunner and Test Director (Quality Center).

• Expertise in using Mercury Interactive Tools Quick Test Pro. Extensively used its advanced features and functions and thorough knowledge of Process Workflow of the system. Hands on expertise in designing, developing, enhancing automated test scripts for QTP (using VBScript), WinRunner and LoadRunner and Rational Suite of tools.

• Experience in executing tests in both Client/server and Web Applications

• Quick understanding of software business requirements and application flows.

• Providing input for Test Plan preparation to the management.

• Expertise includes preparing Test Design, Test Cases and generating Test Reports.

• Expertise involves filing defects, tracking the defects and documenting the defects appropriately.

• Experience Includes Manual and Automated testing and Black-Box testing for Various Client-Server and Web-based applications using automated tools like WinRunner, Quick Test Professional, Loadrunner and Rational Suite of Tools

• Polished leadership skills with the ability to motivate team to increase productivity.

• Extensively involved in Backend testing of SQL Queries using Oracle & SQL Server.

• Experience and good understanding of AGILE Methodology, Software Development Life Cycle (SDLC) using the Waterfall Model and Rational Unified Process (RUP).

• Design Document and User Requirement Document for the Unit, Integration, Regression, Functional, Performance, and User Acceptance Testing (UAT)

• Created and executed tests scripts through Quick Test Professional for regression testing.

• Excellent problem solving skills, desire and ability to learn and apply new technologies.

• Requirement to test case mapping using Test Director and generated traceability Matrices to ensure that all the requirements are covered by the test case

TECHNICAL SKILLS

Operating System Windows Professional, Windows XP, Windows 98, MS-DOS,

Windows 2003 Server, Windows NT/2000, Mac

Languages C#, Java, Visual Basic, SQL, PL/SQL

Environment Client Server applications, Stand alone applications

RDBMS Oracle 8.0,9i,10g, SQL server

Web Technologies HTML,VB Script, XML, Dream Weaver, Front Page

Tracking tools Test Director, Clear Quest ,Quality Center, Bugzilla

Testing Tools Quality Center, Test Director ,QTP Win Runner , IBM Rational ClearQuest, Rational Requisite Pro, Rational Robo

PROFESSIONAL EXPERIENCE

Wynn/Encore Resorts April 2010– September 2010

Las Vegas

Role: QA Analyst

Description: The project involved testing the Wynn online application . The project involved testing various online services including room reservations, Membership services, Dining reservations, Show reservations.

Responsibilities:

• Designed Test cases from Requirements, Functional Specifications and Design Documents. Execution of Test cases through Quality Center tool

• Managed defects using Quality Center

• Conducted various types of testing like Functionality, GUI and regression testing.

• Created test scripts Quality center.

• Performed Manual Testing using in Quality Center 10.0

• Performed automation scripting using in QTP 10 for the web application.

• Performed Browser compatibility testing in Safari, Firefox, Google Chrome and IE 6, 7, 8 versions.

• Performed Regression Testing, Functional Testing, Smoke Testing

• Performed Validation Testing, Downtime Testing.

• Communicated defects encountered during regression test and follow-up with developers until all issues were resolved

• Implemented Requirement Traceability Matrix by mapping requirements to test cases.

• Developed User-Acceptance Test scripts and assisted users in conducting UAT

• Validated test scripts and test cases in compliance with requirement.

• Created Test Plans & Test Execution Matrix.

• Tested functionality of the application by inserting various check points like standard check points, text check points, table check points, image check points, and database check points in QTP 9.2.

• Performed Data driven testing with different sets of data using QTP

• Used SQL queries to check for integrity of data and to make sure the information retrieved for each consumer is accurate.

• Performed backend testing to ensure proper backup and restoring of data by executing SQL queries in SQL Server.

• Backend system testing of Opera & Patron Management.

Environment: Quality Center 10.0, QTP 10.0/9.0, ASP .Net, C#, SQL Server 2005 and Windows NT/2003,Opera ,Patron Management.

HSBC Bank Dec 2008 – Mar 2010

New York

Role: QA Analyst

Description: The HSBC Online Savings & Checking Account project involved introducing the easiest, paperless online savings& checking account opening process in the industry. The objective of this project was also to offer customers an opportunity to go green when they signup to receive paperless statements for their HSBC card account. By offering the customers an opportunity to receive paperless credit card statements, HSBC was supporting a sustainable environment

Responsibilities:

• Reviewed Business Requirement Documents and the Technical Specification.

• Actively involved in QA process activities, like Creation of test plan, Creation of test case, Creation of Test Matrix, Test Case execution, Reporting the bugs, problem resolution, bug tracking, system defects, retesting the bugs etc

• Involved in design and development of Test Plan and Test Cases, and Test Matrix.

• Performed all phases of end-to-end testing which includes Functionality testing, Regression Testing, GUI testing, boundary testing, negative testing, system testing of the Application.

• Designed and processed test scripts for manual testing of each application.

• Developed test cases and test scripts for the functional testing.

• Performed manual Quality Assurance testing (QAT) and User Acceptance Testing (UAT) activities for new releases.

• Developed load scenarios using LoadRunner.

• Performed Stress Testing.

• Tested front-end web applications.

• Created automated test scripts based on the test cases using QTP 9.5.

• Tested front-end web applications for 3-tier and n-tier technology.

• Run SQL queries to SQL server 2000 and SQL Server 2005 for results verification.

• Extensively used SQL to verify the integrity and consistency of the data in the database.

• Conducted the Regression tests for already reported Bugs to test whether fix has been applied or not and also to test whether the fix causes another problem or not.

Environment: SQL Server 2000, SQL Server 2005, ASP, C#, .NET, Windows server 2003, windows XP, windows server ,QTP 9.5,Bugzila.Loadrunner.

Client: Countrywide Financial Corp Sept 2006 – Nov 2008

Calabasas, CA

Role: QA Analyst

Description: Countrywide Financial Corporation is a diversified financial services holding company that mostly engages in residential mortgage banking and related businesses. I was working on the Customer Maintenance System (CMS), which is an advance system of online information system (OIS). The application is on home loans. The application was a web application in which client need to register online with correct login name and password. After that they get all the information regarding their home loan. Application has three modules ‘Query’, ‘My Loan’ and ‘Quote’. As a tester I was testing the functionality of each module.

Responsibilities:

• Analyzed the business requirements and wrote Test Cases and Test Strategy for functional requirements.

• Analyzed the system specifications and helped team members to achieve test goals.

• Recorded scripts in Quick Test Pro to perform Functionality testing.

• Performed data driven testing using Quick Test Pro.

• Involved in parameterization using Quick Test Pro.

• Used Telnet to connect oracle with UNIX platform.

• Interacted with business user during UAT

• Performed Back-End Testing using SQL queries.

• Generated all reports for the test cases through Quality Center document generator.

• Responsible for extracting bug reports and conducting Bug Review meetings

• Prepare Project-level test plans and created test cases for the respective applications.

• Developed and Executed Load Test Scenarios using LoadRunner.

• Installing, maintaining and administering LoadRunner software.

• Performed Load, Stress and Performance Testing using LoadRunner

• Plotting and implementing different scenarios for load testing using LoadRunner.

• Used Quality Center for tracking and reporting bugs.

• Used the LoadRunner Online Monitors.

• Working with different Vuser types and groups in LoadRunner

• Use UNIX to connect oracle database using SQL Queries

• Attend regular meeting to track bug related issues and critical problems

Environment: Window XP, Oracle 10g, UNIX, SQL, IIS, HTML, Quick Test Pro9.2, Load Runner 8.2, Quality Center 9.0, Win Runner

Client: United Behavioral Health (UBH) May 2005 – August 2006

San Francisco, CA

Role: QA Analyst

Description:

Health Management Corporation’s (HMC) Disease Management System (DMS) is a Web based application for data collection and management of program participants. The system houses each member's medical history record, which tracks a member's progress through every HMC program in which he/she is enrolled. DMS also integrates customized health management initiatives provided through the health plan to improve outcomes for clients. The system also has easy web access for patients who prefer the web for educational resources and communication with the care team.

Responsibilities:

• Involved in the development of system test plan and test scripts using business and system requirement documents.

• Worked on multiple releases on different environments at the same time.

• Assist entry-level tester(s) on reviewing requirement, preparing and executing test cases, and report software defects.

• Performed black box, Functional, Integration, and Regression testing of the website.

• Developed test scripts using Quick Test Professional to perform smoke, functional and regression testing in VB (front end) code.

• Actively participated to setup the test environment for the application(s) needs to be deployed on test environment

• Created functions library to write reusable functions.

• Prepared Test Data for the design phase as per the specifications of the Functional Design doc and followed Agile methodology.

• Prepared reports and test results after each release cycle for management and further test planning.

• Tested GUI and functionality of the application under test using multiple browsers such as Netscape Navigator 4.7/6.0, Microsoft Explorer 5.5/6.0 on multi platforms and interpreted the positive and negative results.

• Close interaction with developers to get updates and resolve defects.

• Manually performed back-end testing by writing SQL queries

• Developed User-Acceptance Test scripts and assisted users in conducting UAT.

• Checked the broken links in the application and conducted cross browser testing

• Responsible for updating and maintaining the Test Director for all the defects found during functional and regression testing and follow up the bug life cycle.

• Wrote reusable functions to handle application exceptions locally instead of passing control to silk test built-in error handler.

• Used Rational Clear Quest for version control, tracking defects, enhancement requests, assign work activities, and assess the real status of project throughout the life cycle

• Interacted with developers, users and various members of the team to discuss issues resolve defects and set priorities.

Environment: VB 6.0, Oracle9i, Windows XP, Mercury Quality center -Test Director 7.5/7.2,Quick Test Professional

Education: Bachelors in Engineering, Madras University, India

References available upon request

Contact this candidate