Sql Server Test

Summary

* ***** ** ********** ** Software Quality Assurance and

Software Testing of Client/Server, UNIX and Web based

applications.

Experience in developing and testing SQL Server queries.

Extensive experience in reviewing and analyzing Business

Requirements and writing detailed Test Plans, Test Cases and

Test Scripts.

Experience includes the testing of Client/Server and WEB

based applications using automated testing tools like Win

Runner, QTP, Test Director and Quality Center.

Experience in writing SQL queries for data validations.

Extensive experience in conducting data driven Tests by

using SQL to check the same functionality for different data

points.

Expertise in analyzing requirement specifications and

responsible for developing Test Objective, strategies,

Scope, Test procedures and Test Matrices.

Extensive experience in conducting different kinds of tests

such as Integration, Regression, Functional, Performance,

System Testing, Black Box, Ad-Hoc and Load Testing.

Excellent working knowledge of designing & implementation of

all QA test strategy plans manually and automated test

solutions for client/server and Web applications with

Mercury Interactive test suite.

Extensive Experience in Pre-Test Architectural overview,

Load contribution analysis, Planning and Test Execution and

Post test result analysis.

Worked on Test Director to create Test cases and Report

bugs.

Extensively used Test Director for specifying requirements,

updating Test Cases, application testing status reporting,

maintaining Test scripts, and observing traceability.

Uploaded Business requirements, test scenarios, test cases

and defects from MS Word and Excel to Test Director.

Well versed with SQL/PL SQL queries to run the data

integrity tests.

Strong experience to work in UNIX, Windows environment, .Net

and Java technologies.

Effective leadership skills with good written, verbal

communication and presentation skills. Self-motivated with

result oriented approach. Committed collaborator and team

leader.

Technical Skills

Testing Tools: WinRunner, LoadRunner, Quick Test

Professional, Test Director and Quality center, Photoshop,

SQL Server Management Studio, Visual Studio, Crystal

Reports, Microsoft Office, Microsoft Word, Power Point,

EXCEL

Languages: .Net, Visual Basic, Java, J2EE, PL/SQL

Databases: SQL Server, Oracle

Operating Systems: Windows NT/2000/XP, Unix

Web Development : HTML, XML, DHTML

Scripting: TSL, VBS

Work experience Wachovia

June 2008 - Till date

QA Analyst

Project Description:

This system is developed by Wachovia Bank and provides

on-line information about its clients' holdings, maturity,

realized or unrealized gain and loss etc. This system is

designed to work with both Browsers: Netscape and Internet

Explorer. This system was developed using JAVA, Java Script,

HTML, Sybase and SQL Server. This system is a web

application developed using Java, J2EE technologies with

WebSphere as application server and Oracle as database.

As a team member my job responsibilities are; but not

limited to:

Analyzed the business requirements and specifications.

Conducted Manual testing prior to Automation testing on

applications.

Performed testing on a number of web applications and

Ecommerce applications.

Tested Cash in, Cash out, Money transfer transactions by

processing some deposit and withdrawal transactions and

verifying that the database is updating with correct amount

and balance.

Performed testing on transactions for on-line credit card

payments.

Conducted Manual/functional testing on IVR applications.

Created Test Plans, Test cases, Test Matrix, Traceability

Matrix, reviewed requirements, logged defects in Quality

Center.

Used Mercury Quality Center to manage the requirements, test

cases and also defects.

Wrote SQL queries to extract data from the database to

validate the results returned by the application.

Conducted Test Batch Processing and data driven tests by

using SQL Server to validate same functionality for

different types of data, positive data, negative data.

Documented and sent reports according to the standards.

Implemented training documents for end users and involved in

the training.

Reviewing Business Requirement Documents and the Technical

Specification.

Set up a QA process and ensured it was effective project

wide.

Documented test cases corresponding to business rules and

other operating conditions.

This system was developed using JAVA, Java Script, HTML,

Sybase and SQL Server. This system is a web application

developed using Java, J2EE technologies with Web Sphere as

application server and Oracle as database. Created Test

input Data Requirements and prepared the test data for data

driven testing.

Reported the failed test cases, tracked the defects and

verified the fixes in multiple environments.

Used Quality Center to log defects and generate defect

reports and graphs.

Actively participated in enhancement meetings focused at

making the application more reliable.

Monitored Quality Center to close the bugs/cases as and when

developers fixed the bugs.

Environment: Quality Center, Java, Servlets, JSP, Java

Script, XML, Web Services, Oracle9I and UNIX, Microsoft

Word, Power Point, EXCEL.

Jason Cohen & Foster, P.A

June 2007 - May 2008

QA Test Engineer

Project Description:

The Law Office of Jason Cohen & Foster collects tremendous

amount of information to prepare a Case. The Case Management

System provides stability by providing consistent, sound set

of procedures, which significantly reduces the amount of

time spent on organizing the information. It allows

customers to perform multiple parameter searches by

utilizing the Advanced Search engine. This system was

developed in Java, J2EE.

Responsibilities:

Worked on Manual Testing and Automation using Quality Center

and QTP.

Conducted Testing on several web applications.

Tested negative and empty data entries for Case types in the

Case Details screen and whether error message is displayed

after entering invalid data.

Performed testing on Case Dates tab, whether Date Opened is

less than Date Closed and proper error messages are being

displayed.

Worked closely with Development team to discuss the design

and testing aspects of the applications to design the Test

plans.

Developed test scripts and designed test cases. Executed

test scripts that are automated under various business

process testing.

Conducted Manual Testing in the VI Editor, by using UNIX

command line and Shell scripts.

Extensively used Shell commands, command line arguments and

Shell scripts to test software applications on the web

server.

Conducted data driven Tests by using SQL to check the same

functionality for different data points.

Involved in implementing QA methodology and Test Matrices.

Used Quality Center for preparing the test plans and manual

test scripts.

Test execution-using Quality Center.

Bugs were reported to Developers using Quality Center and

after rectification from Developers regression testing was

performed.

Worked with developers using Quality Center to fix the

defects.

Developed detailed test plans from use cases detailed

specifications etc. develop test cases for System testing

and User Acceptance testing.

Review of manual methods to design, develop and execute

automated test cases using QTP.

Created Data-Driven Tests by using Data Driver Wizard and by

manually adding data driven statements to test scripts to

check how it performs the same operations with multiple sets

of data.

Developed test scripts for Functional and Data driven tests

using QTP on web based module.

Interacting with developers to resolve technical issues.

Detect defects, communicate to the developers using bug

reporting tools and tracking the defects.

Responsible for weekly status meetings showing progress and

future testing efforts.

Assisted the project lead in preparing Test Plans.

Involved in Black Box Testing, Front End, Backend, Baseline,

Regression and Stress testing.

Used QTP to conduct Data Driven Testing by pulling data from

the tables.

Conducted Functionality, Security, End to End and

Performance Testing.

Used Quality Center for test documentation management and

defect tracking.

Participated in various meetings and discussed Enhancement

and Modification Request issues.

Environment: Quality Center, QTP, .Net, JUnit, Java,

Servlets, JSP, Java Script, DHTML, XML, Oracle 8i, UNIX,

Manual Testing, Microsoft Word, Power Point, EXCEL.

BellSouth Corp.

April 2005 - May 2007

QA Test Engineer

Project Description:

Telecom is an intranet Employee web portal. This software

allows a network operator to find out the information about

various network elements, circuits, and customer information

on a DSL network.

Roles and Responsibilities:

Extensively used Test Director for test planning, bug

tracking and reporting.

Extensive experience in creating and running Shell Scripts

in VI Editor in UNIX based environment, also used command

line arguments and Shell commands to test various client

server applications.

Performed manual and automation testing on applications

developed in .Net.

Uploaded Business requirements, test scenarios, test cases

and defects for MS Excel to Test Director.

Developed detailed Testing Methodologies, Test Matrices,

Test cases and Test scripts.

Worked on Manual Testing and Automation using Win Runner and

Test Director.

Master GUI Map is maintained in the central repository and

changes are made to it for every version.

Performed Functional/Regression testing and Unit testing,

Integration testing, Black box, System Testing and User

acceptance testing.

Developed scenarios for Regression/Functional testing, which

covers more than 90% of the Critical scenarios for the

application.

Generated Automation Scripts and TSL Test Scripts using Win

Runner for Regression Testing and the additional scripts are

generated for each version.

Data driven testing was performed and the scripts were

enhanced.

Documented all the Performance and Regression tests, results

were compared at every new build. Analyzed and presented

Results.

Interacted with developers to resolve for the savior

priority bug issues, which would affect income-generating

functionality in Production.

Always met the deadline when required to do Regression

testing and multi-browser testing.

Work with Developers, Business and Release managers to

discussed ways to fix the defects.

Helped new team members understand the site functions.

In charged of daily back up of the team's working files.

Environment: Oracle, Forms 6i, Reports 3.0, SQL, HTML, UNIX,

.Net, PL/SQL, Windows NT, WinRunner, Test Director, Manual

Testing, Microsoft Word, Power Point, EXCEL.

Staples

Feb 2004 - March 2005

QA Trainee

Project Description:

The Net web application was a solution devised to facilitate

online functioning of HR, administration, Payroll, and other

departments of the company, through the features like email,

notifications, workflow, Reporting, user administration,

security and helpdesk support module.

Roles and Responsibilities:

Had written test cases for the given test scenario.

Performed White box, Black box, Positive and Negative

testing manually.

Identified defects and documentation was provided to the

development team for debugging.

Documented QA process standards and procedures including

master test plan using MS Word, MS EXCEL.

Environment: Java, HTML, Oracle, Windows, Tomcat

Education

Bachelor's Degree

Diploma in Software Engineering

Status GREEN CARD

* References gladly provided upon

request*

Contact this candidate