Sql Server Quality Assurance

Rupesh Trivedi

Ph: (M) 732-***-**** Email:

**************@*****.***

SUMMARY

. 11 years of experience in Quality Assurance and Software Testing.

Proficient in Manual Testing and Automation Testing of Web, Desktop and

Hand-Held Devices (Palm & Pocket PC) applications using QTP, Quality

Center, Win Runner, Test Director and Load Runner. Experience working as

Software Developer in Test environment.

. Microsoft Certified Professional (MCP and MCSD) with VB, and SQL Server

2000.

. Strong in System Development Life Cycle (SDLC) concepts, SQA methodology

and test process automation.

. Strong experience in Back End Testing with SQL Server 2000/2005/CE using

SQL Queries and also having experience with Database administration.

. Expertise in understanding of business requirements and user requirement

analysis.

. Extended work experience to develop and execute software test plan, test

cases/scripts and test specifications for manual and automated testing.

. Expertise in Black Box, White Box, Functional, Integration, System,

Regression testing, Load testing, UI Testing and UAT (User Acceptance

Testing)

. Detecting, classifying and reporting bugs through Defect Tracking System.

. 1+ years of experience in full cycle of software development life cycle

using Internet Technologies (ASP, HTML, and DHTML).

. Excellent written and verbal communication & interpersonal skills.

Skill Set

Automation Tools QTP 8.2/9.0, Load Runner 7.x, Win Runner 7.6, Silk Test

7.6

Defect Tracking Tools ServiceDesk 8.0, Adventnet 9.0, BugZilla 3.x, Quality

Center 8.0/9.0, Test Track Pro, Test Director 7.x,

Scripting Tools TSL, JavaScript, VB Script, SQL, PL/SQL

Languages C++, ASP 3.0, VB 6.0, .NET, JSP, JAVA/J2EE, XML, XHTML,

HTML, DHTML

Tools MS VSS, Visio 2002, Crystal Report, SQL PLSQL, TOAD, MS

Office 2003 (Word, Excel, PowerPoint), MS Project 2003,

Satellite Forms (InfoPath, Form Docs, Jet Forms, MS .NET

2005), Front Page, Inter Dev, Outlook Express, SnagIt,

Putty

RDBMS Sybase, MS SQL Server 2005/2000/CE, Oracle, MSDE, MS

Access 2000, Pervasive SQL

Networking Tools Remote Desktop, WebEx, PC Anywhere, Go To My PC, VNC, and

Win sock 2

Operating Systems/ Windows 2003/2000/NT/XP/CE, IIS, Active Directory, Mail

Servers Server, PWS XP/CE, UNIX, LINUX

Internet Protocols HTTP, HTTPS, TCP/IP, VoIP, FTP, SMTP

Professional Certification

. Microsoft Certified Solution Developer (MCSD)

. Brain bench Certification (HTML 4.0)

. Diploma in Information Technology (DIT)

Professional Experience

Employer Name: Lightspeed Research Inc, Warren, NJ

Project: *.lightspeedpanel.com, Orion v1.0, MapSys 6.31

(Web & Desktop Applications)

Apr08 - Present

Quality Assurance Specialist

Lightspeed Research is part of Kantar, the information, insight, and

consultancy division of WPP - leaders in advertising, consumer insights,

and market research. The recent acquisition of TNS online panel business,

Lightspeed is one of the leading market research companies worldwide.

Through Lightspeed Research global online research panels and products,

Lightspeed Research delivers valuable data to help clients make informed

business decisions. LSR have the research history and experience, the panel

reach and scope, and the technology in place to deliver the highest quality

data to clients quickly and accurately.

. Developed effective test strategies and test plans for LSR legacy

systems.

. Reviewed Change Requests, Software Requirements Specification (SRS)

and Functional Requirement Specification (FRS) for LSR Legacy systems

and Orion application.

. Planned, scheduled and implemented testing projects of 20 various

websites of Lightspeed panel for all countries and coordinated with

India team and assigned the task also conduct the status meeting.

. Defined QA best practices and identified QA process improvements and

implemented the solutions like prepared documents to define and

describe the testing process and developed test cases for ALL panel

sites as per the requirements.

. Done the database testing using PLSQL and SQL for Sybase and Oracle

8i.

. Implemented defect tracking system Bugzilla 3.0 to improved bug

reporting process.

. Developed and executed detailed test scripts, test cases and test

scenarios.

. Done the Functional, Regression and System testing for LSR Legacy

systems (Lightspeed Panel website and MOAT application) at different

stages of the Testing Life Cycle.

. Analyzed and documented test case results

. Helped to ensure overall products qualities and delivered on time.

. Communicated with Development team and Clients and achieved the

quality product.

. Quickly learn new TNS system "MapSys/Orion" and verified the various

functionalities within the system and to achieve quality product after

integration of Lightspeed and TNS systems.

. Involved in UAT (User Acceptance Testing) for each and every change

request/fixes from end users.

. Involved in production deployment process and verified all

changes/fixes on production servers and delivered bug free

functionalities.

. Gave the First-tier support for Mapsys/Orion application and assigned

the tickets to concern developers.

Environment: BugZilla 3.x, ServiceDesk 8.0, Adventnet 9.0, SnagIt, Putty,

UNIX, LINUX, MS Office 2007, Java, J2EE, JSP, Oracle 8i, Sybase,

MS SQL Server, PLSQL, SQL, JavaScript, Webservices, WebEx,

Remote Desktop, Windows XP

Employer Name: R-square Inc, Princeton, NJ

Nov 06 - Apr 08

Client: Arbonne International LLC, Irvine, CA

Project: Arbonne.com, myArbonne.com, ArbonneIntranet.com,

ArbonneUniversity.com

(Web Applications)

Sr. QA Analyst/QA lead

Arbonne International LLC is a direct selling company that operates in the

United States, Canada, Australia and United Kingdom. Arbonne markets its

products based on Multi Level Marketing exclusively through a network of

Independent Consultants & Clients. Arbonne website facilitates to buy

unique products online to the consultants & clients with the special

qualifications. Consultants can edit their profile information and can

trace their previous order history in online consultant tool called Web

stats. Consultant can keep an eye on his/her complete progress in Group

Volume and Order information of their down links also. Consultant can

participate and register for the Arbonne Events from the Events section.

Consultant can create their own website on myarbonne.com and they can take

certification of Arbonne from ArbonneUniversity.com.

. Review Business Requirement s (Change Request), Software Requirements

Specification (SRS) and Functional Requirement Specification (FRS).

. Developed the Test Plan and Test Cases as per the requirement studies.

. Assign the Weekly task to Integration team and follow-up and keep track

of progress and also coordinate with other department like MLM, Marketing

& Oracle to complete the cycle.

. Performed Functional, Integration, System, UI, and Regression testing at

different stages of the Testing Life Cycle.

. Done testing of various modules like Shop Online, Internet Consultant

(Consultant Registration Mgt, Surveys, Events, Rewards and Recognition,

etc.), Locate a Consultant, Web stats (Order Information, Group Volume,

My Clients, My ASAP Points, Web Reports, Commissions), Item Master.

. Performed the Arbonne Database testing using complex SQL Queries and

match with the Test, Staging and Production databases.

. Performed the Database tuning, User setup and Backup - Restore for

performance and setup the testing environment

. Performed the User Acceptance Testing of the Application and sign off

from the Marketing department.

. Perform End-to-End Testing and created a set of re-usable Test scripts

for Arbonne Web applications.

. Performed Black box testing including smoke, function and regression

testing.

. Used Test Track Pro to track and Report system defects and Bug fixes.

. Maintained and checked the Version Control mechanisms using Microsoft

visual source safe (VSS).

Environment: Test Track Pro, MS Office 2003, HTML, DHTML, ASP, .NET,

JavaScript, VB Scripts, SQL Server 2000, MS VSS, IIS, Windows

XP/2000.

Employer Name: Universal Software, Ahmedabad, Gujarat, Inida.

Sept 99 - Nov 06

Project: XRMS (Web and Desktop Applications)

Sr. QA Analyst

XRMS is a Records Management System (RMS) for Police and Sheriff's

departments, which helps in streamlining the logical work-flow of police

department and tracking the investigation and supervision activities. It is

a suite of modules designed to collect, store, and report all information

pertaining to an incident.

. Review Business Requirement and Software Requirements Specification (SRS)

and executed the Test Plan, Test Cases.

. Assign the Weekly task to Integration team and follow-up and keep track

of progress using MS Project 2003.

. Design the diagram of Testing environment and project architecture using

Visio 2002.

. Performed Functional, Integration, System, UI, and Regression testing at

different stages of the Testing Life Cycle using QTP 9.0.

. Done testing of various modules like Investigation, Arrest, Missing

Person, Warrant, Vehicle Towing, Ticket Booking Information, Field

Interview, Case Activity Information, Charge Information Court

Information, Crime, and Property Vehicle Information.

. Performed the XRMS Database testing using complex SQL Queries.

. Performed the Database tuning, User setup and Backup - Restore for

performance and setup the testing environment

. Performed the Performance Testing of XRMS web module and User Acceptance

Testing of the XRMS Application.

. Developed reusable test scripts using VB scripts in QTP 9.0 to perform

End-to-End Testing and created a set of re-usable scripts for XRMS Web

application.

. Tested the web module of XRMS application using QTP 9.0 to checking page

contents, broken Links, web objects, frames and tables.

. Performed Black box testing including smoke, function and regression

testing using QTP 9.0.

. Performed load and stress testing with concurrent Vuser using Load Runner

7.8.

. Performed System Testing on various Hardware platforms and Software

Configurations.

. Used Quality Center 8.0 to develop the test cases track and Report system

defects and Bug fixes.

. Attended Peer Reviews, Walk-through and Inspections throughout the

Testing life cycle.

. Prepared the test databases and maintain and update it as per the

requirement.

. Checked the Integration of Messaging system of Xmobile who is communicate

with other applications like XRMS and XCAD which is developed in .NET

using Win sock API and TCP/IP.

. Maintained and checked the Version Control mechanisms using Microsoft

visual source safe (VSS).

. Given the product installation and client support with trouble shooting

and also given the solution for the same.

Environment: HP QTP 9.0, Load Runner 7.8, Test Director 7.x, Quality Center

8.0, .NET, VB Scripts, MS Project 2003, Visio 2002, Crystal

Report for .net, SQL Server 2000 and 2005, MS VSS, Form Docs,

IIS, PC Anywhere, Go to My PC, Windows 2003/XP/2000.

Client: Archonix Systems Inc

Project: XCAD Geo

Role: Sr. QA Analyst

XCAD is a windows-based computer aided dispatch ("CAD") system that

provides greater productivity in dispatching police, fire and emergency to

their destination. CAD allows dispatchers to easily track assigned and

unassigned personnel and incidents for single and multi-jurisdictions.

Flags alert dispatchers to prepare responding personnel for any hazards

ahead. XCAD can work independently, or when combined with our XRMS and

Xmobile system, it can provide your agency with a complete public safety

package.

. Review Business Requirement and Software Requirements Specification (SRS)

and executed the Test Plan, Test Cases.

. Design the diagram of Testing environment and project architecture using

Visio 2002.

. Executed Test Cases and Gathered Test Execution results

. Tested the Functionality of the application manually using Test Director.

. Developed Test Scenarios and Test Procedures based on the test

requirements.

. Performed the System Testing like User Interface testing, Usability

Testing, Functionality Testing and Regression Testing using QTP 8.2

. Responsible in Detecting, classifying and reporting bugs through Defect

Tracking System using Test Director

. Created and executed automated test scripts using VB Script in QTP 8.2

for search and address verification module.

. Extensively used QTP 8.2 to program with TSL as to create Reusable

Functions, and scripts that would work on different machines, platforms

and environments

. Documented errors and implemented their resolutions

. Prepared Functional automated scripts for Maintenance and Regression

testing

. Coordinate all the database changes to the development and test databases

and implemented SQL Scripts and Wrote SQL queries to validate data

. Performed the Database administration task as and when required.

. Given the Product Support with trouble shooting and give the solution for

the same.

Environment: QTP 8.2, Test Director 7.x, Visio 2002, .NET, Crystal Report

for .net, SQL Server 2000 & 2005, MS VSS, PC Anywhere, Go to My

PC, Windows 2003/XP/2000

Client: BellSouth Telecom

Project: CBS

Role: QA Analyst/Tester

A CBS (Common Business Service) is a software module that provides a

solution to a single and shared BellSouth business problem that can be used

by any application that meets BellSouth technology standards defined by the

EID (Enterprise Infrastructure Development) organization. One of the major

projects for the CBS is Rodeo 1.x. The CBS Rodeo1.x services provide a

common business API for sending bundled customer orders for the different

suppliers systems.

. Reviewed the Business Requirements Documents and the API's.

. Executed the Test plan and wrote the Test Cases and Test Scripts in test

director and MS Excel.

. Prepared the presentation files for Test Scenarios and flow for testing

in MS PowerPoint.

. Performed the manual testing of the AIO module for VoIP testing.

. Wrote complex SQL queries to perform back-end testing and tested CBS.

. Automated back-end testing by win runner 7.6.

. Worked on SAS Reports and Crystal Reports

. Developed user defined functions for various requirements.

. Written and developed TSL scripts for functionality testing for different

modules using Win Runner 7.6

. Developed and maintained GUI Map files for the modules

. Performed Regression Testing using Win Runner 7.6

. Maintained and executed Manual as well as Automation test cases from Test

director.

. Involved extensively in back-end testing and integration testing to check

the different status of the orders in databases using TOAD, with

accordance to Requirement specs.

. Written test scripts and executed the same for different phases of

testing.

. Involved in writing and maintaining Documentation for every CR (change

request).

. Worked extensively with harvest as version control as well as bug (DCR)

reporting tool

Environment: Win Runner 7.6, Test Director 7.x, TOAD, Oracle 8i, MS Excel,

MS PowerPoint, VB, Crystal Report, MS VSS, Windows 2k3/XP/2k

Client: We Care Media

Project: Buddy Drive (Toolbar Application & Website)

Role: Software QA Tester

The goal of the Buddy Drive personal site would be to create a central

location for a user of the Buddy Drive to extend their personal privacy

zone beyond the local machine protection that is offered by the flash

device. The personal site will educate BD users in issues concerning

current privacy and how they can maintain their personal zone with BD.

Personal Privacy Site (PPS) will also offer additional revenue

opportunities to We Care Media through the use of renewable subscription

services such as protected browsing, online file backup and storage,

private e-mail addresses and other service potentials.

. Responsible in creating Test Scenarios and Test cases according to the

business/functional requirements.

. Prepared the test cases, executing them and record any issues to resolve

for quality assurance of online store applications.

. Verified web objects such as frames, tables, cells, images and text and

checked differences in the standard properties of each page.

. Checked the various links considering the design flow of the system in

different URL.

. Performed Functional, Navigational and GUI Testing on web based

application.

. Written SQL queries to perform the back-end testing of the SQL server

database

. Created Help Manual and Web Content and also responsible for fixing some

documentation errors

. Prepared the Test Scripts especially for Regression Testing of some basic

functionality in the project which remained almost same in each release

using Win Runner 7.6

. Tracked the manual testing results using MS Office Tools back to the Test

Director

. Verification of fixed bugs using Test Director and writing weekly quality

progress reports

. Tested the entire functionality of the application on different browsers

like IE, Netscape and operating systems

. Executed the Black Box Testing and System Testing for the project.

. Documented and stored all the test results found for each and every

release of the product.

. Participated in weekly assessment meetings with business analysts and

developers.

Environment: Win Runner 7.6, Test Director, ASP.NET, JSP, JAVA/J2EE, VC++,

SQL Server 2000, MS VSS, IIS, Windows 2003/XP/2000, Outlook

Express

Client: Pi Star Communication

Project: City of Kokomo (COK-CAD)

Role: Software QA Tester

COK (Pi Mobile CADS ) is a Computer Aided Dispatching system that will

incorporate a Report Generator Module (RGM) and will also provide a GPS

Mobile Application Module for use with vehicles in the FCR/SOK program.

. Developed Test Script template with Validation Condition/Test Procedure

and expected results.

. Design the diagram of Testing environment and project architecture using

Visio 2002.

. Automated testing on Desktop application for COK Client, COK Server and

PPC application module using Win Runner.

. Conducted Functional, Usability, Integration and Regression testing.

. Coordinated and oversee validation of all FDA regulated software systems

company wide.

. Tested the Hand-Held application module of COK application with GPS

system on Pocket PC.

. Performed the SQL Server CE Database testing using complex SQL Queries

and store procedures.

. Performed Acceptance, System, Negative, online transactions and

Regression Testing.

. Responsibilities also included extensive client communication, on-site

client testing and support, and specialized web-based performance testing

. Investigated and analyzed the bugs using Test Director.

. Worked with product development to develop test scenarios and test cases

based on methodology being utilized.

. Given the Product Support with trouble shooting and give the solution for

the same.

Environment: Win Runner 7.6, Test Director, VB.NET, VC++, EVB, Visio 2002,

Crystal Report, SQL Server 2000/CE, MS Map Point Web Services,

Windows 2003/XP/2000 and WinCE

Client: US Department of Labor

Project: OSHA Self Audit Manager

Role: QA Tester

The purpose of this application is to help you comply with the Occupational

Safety & Health Administration (OSHA) standards. This solution comprised of

Desktop, Palm and Pocket PC based applications. A facility was also

provided which could sync the data with the Desktop application from Palm.

. Performed Testing for the Entire Application manually

. Tested the Hand-Held application module of OSHA self audit manager on

Palm OS.

. Prepared the test scenarios and Test Cases based on methodology being

utilized.

. Performed functional, user interface, regression and acceptance testing

using Win Runner 7.6.

. Executed the test plans & cases, set up hardware/software environments,

recommend improvements to programmers and document results.

. Performed White Box test based on preset checklist and conditions.

. Categorized bugs based on the severity and interacted with developers to

resolve them.

. Given the Product Support with trouble shooting and give the solution for

the same.

. Interacted with developers to resolve the issues.

. Performed the SQL Server CE database testing for Hand-Held application on

Palm performance with complex SQL Queries.

. Used the Test Director for the bug and issue tracking system and maintain

the testing related issues/defects management.

Environment: Test Director, VB 6.0, EVB 3.0, ActiveX Database object (ADO),

Data Access Report, App Forge, MS-Access, SQL Server 2000, Oracle

8i, Windows NT/2000 and Palm OS

Client: University of IOWA Medical Department

Project: CHMS 1.0

Role: QA Tester

The main purpose of CHMS (Chronic Health Management System 1.0) Application

would be to store previous medical data of patients in a central repository

from wherein those data could be accessed from anywhere in the world

through the Pocket PC Which is Synchronize their data with Web Server. This

would help the Patient/Doctor in retrieving the required past data without

wasting much time. This will also help the doctors in proper diagnosis of

problems for a respective patient. This software has two main parts one is

Medical Records Converter and second one is Medical Records Viewer.

. Performed the Manual testing for functional and regression testing for

Web and Desktop application.

. Prepared the test scenarios and Test Cases based on methodology being

utilized.

. Performed functional, user interface, integration, regression and

acceptance testing for both Web and desktop application modules.

. Executed the test plans & cases, set up hardware/software environments,

recommend improvements to programmers and document results.

. Tested the Hand-Held application module of CHMS application on Pocket PC

and make sure the data was synchronized with the website and desktop

application.

. Categorized bugs based on the severity and interacted with developers to

resolve them

. Given the Product Support with trouble shooting and give the solution for

the same.

. Interacted with developers to resolve the issues

. Performed the SQL Server CE Database testing using complex SQL Queries

and store procedures for PPC application.

Environment: Test Director, ASP, EVB 3.0, MS SQL Server CE 1.0, MS SQL

Server 2000, Windows NT/2000 and WinCE.

EDUCATION:

> Master Program in Business Administration (MBA) with Information

Technology from NIM, Mumbai.

> Bachelor in Commerce (B.Com.) from Gujarat University, Ahmedabad.

Contact this candidate