Sql Server .Net Project Experience Manager Testing

Sarada, Sr. Test Analyst

E-mail: ablfaf@r.postjobfree.com

Mobile: 425-***-****

Summary:

. Proactive and result-oriented QA Professional with 7 years of

experience in Software Testing.

. Extensively Worked on GUI based Client-Server & Web Based applications

using Manual and Automated testing procedures.

. Sound knowledge in software development life cycle methodologies (SDLC).

. Good exposure to all phases of Software Test Life Cycle (STLC).

. Hands-on Experience in analyzing Business, Functional and Technical

Specifications.

. Strong experience in developing Test Plans, Test Scripts and Test

Cases from requirements and design documents.

. Well versed with Smoke Testing, White Box Testing, Black Box Testing,

Integration testing, Functional testing, GUI Testing, Regression

testing, database Testing.

. Good experience in testing of applications built on VB.Net, ASP.Net,

MS Visual Studio.Net 2003/2005, Web Services, T- SQL, MS Reporting

Services and PL/SQL.

. Experience in testing Windows/Web Applications using .NET Frame Work

(C#, VB.Net ASP.Net, VS.Net, ADO.Net).

. Test Automation experience in Mercury Quick Test Pro for web-based

applications

. Good Experience with SQL Server Versions 2008/ 2005/2000

. Experience in debugging complex Stored Procedures, Functions,

Triggers, SQL Queries and Views using SQL Server2000 / 2005/2008

. Strong experience in Web Technologies (ASP, ASP.NET, VBScript, HTML,

XML).

. Good knowledge in SQL Server Integration Services and Reporting Services

. Experience in Test Management tools like Microsoft VSTS, Test

Director, and Quality Center

. Lead QA/Test team in Triage meetings.

. Ability to work successfully as part of small to medium sized team or

independently.

. Excellent communication, analytical, interpersonal and business

interaction skills.

Technical Summary:

QA Automation tools: Quick Test Pro (QTP)

Scripting Languages: VBScript

Operating Systems: Windows 98/2000/NT/XP/2003/WIN 7,Unix

Frameworks: Microsoft .NET Framework 2.0/3.0/3.5

Web tools: ASP.NET, ASP, Web Services, XML, HTML, XSD

Test Management Tools: Visual Studio Test System (VSTS), Test Director,

Quality Center

Databases: SQL Server 2008/2005/2000

Programming Languages: VB/VB.NET, ASP.NET, C++,T- SQL, PL/SQL,ADO.NET,C#

Projects Summary:

P & R Handler:

P & R (Project & Resource) Handler facilitates higher management an

excellent view of available resources and projects executed. It is a web

application by design and provides an effective communication between

engagements and is widely used to review the current state of the projects.

It provides clear picture of resources allocated and their utilization and

also facilitates the project managers in fulfilling release formalities for

the associates in an engagement. It effectively communicates with Timesheet

management system also.

Role: Sr. QA Analyst

Duration: Mar'09 - Till date

Client: Pfizer

Responsibilities:

. Was responsible for the deliverables from a team of 4 resources.

. Successfully worked in agile environment for on-the fly requirements.

. Participated in Build Verification Test.

. Involved in various testing methodologies like Functional Testing, Ad

Hoc testing, System testing and Regression Testing.

. Responsible for creation of Master Test Plan (MTP) and got sign-off

from stake holders.

. Developed and implemented Test Cases according to the application

requirements.

. Involved in designing of Test Cases and test case execution and in

defect tracking.

. Involved in review of test cases and test scripts.

. Responsible for creation and maintenance of test automation Scripts

using T-SQL for data validation.

. Ably managed offshore team located in India with timely deliverables.

. Lead Test team in Triage meetings.

. Involved in knowledge transfer for new resources.

Environment: ASP.NET, VB.NET, VBScript, SQL Server 2008, Quality center,

QTP

Resume Repository:

It is a web portal which helps the associates to view the available onshore

and offshore opportunities across the organization. To apply for any open

position displayed on the portal, associates need to have approval from the

current project manager and also should complete 18 months tenure in

current project.

This interface allows PM's to search for suitable resources as the tool

maintains the list of resumes of all the available candidates.

Role: QA Analyst

Duration: Oct' 08 - Feb' 09

Client: Pfizer

Responsibilities:

. Responsible for writing test cases after reviewing the business &

functional requirement documents, and technical specifications

document.

. Developed SQL Queries to perform database (backend) testing.

. Used Test Director as the approved defect reporting and tracking tool.

. Involved in different walkthroughs meetings with stake holders of the

application.

. Involved in Trouble shooting of issues that come up regularly in

different environments.

. Responsible for UI, functional, regression testing.

. Actively participated in triage.

Environment: ASP.NET, VB.NET, VBScript, SQL Server 2008, Quality center,

QTP

NHCIS:

National Health Care Insurance System (NHCIS) is basically a Health

Insurance application. The service providers in medical field render their

services to the people without charging them directly. They claim fees from

the RHIF. If service providers claim is valid and approved it goes to NHIF.

From National Health Insurance, service providers get the amount. This

project is divided into four main modules. RHIF Register module maintains

the all the data from service providers and receipts. NHIF Register

maintains national level details. In the Claim processing module all claims

process ids are maintained. If the claim amount is proper then it is sent

for approval to National Level budget system. Once it gets approved there

the amount will be disbursed to the service providers.

Role: QA Analyst

Duration: Jan' 07 - Oct' 08

Client: NHC

Responsibilities:

. Preparing Test scenarios as per the specifications.

. Writing and executing test cases as per specifications.

. Participated in functional, integration and regression testing.

. Involved in Requirements coverage, Test plan creation and execution

and bug tracking using Quality center.

. Actively participated in triage.

. Involved in knowledge transfer for new resources.

Environment: Oracle, java, Quality Center

Verizon Home Phone App

The Objective of this project is to provide Landline Customers the

flexibility of tracking the calls. Using the Web flavor of the project,

Users facilitated with the option of managing the calls made/received. With

the help of Client - Server flavor, Users can forward calls, block unwanted

phone numbers, set status like 'Do not disturb' and can synchronize phone

book from the memory of Landline.

Role: QA Analyst

Duration: Dec'05 - Jan' 07

Client: Verizon

Responsibilities:

. Created Test plan, Test Design and responsible for implementation of

Test cases as automated test scripts.

. Used Quality Center for Test Execution, and Generating Reports.

. Bug Tracking-using Quality Center.

. Responsible for automation of test cases to test the User interface

using QTP.

. Inserted GUI checkpoints, Database Checkpoints, Text checkpoints and

Bitmap checkpoints

. Database with the values entered during automated testing by inserting

Database Checkpoints

. Maintained the BUG reports for internal evaluation of the product

using Test Director

. Maintenance of the automation scripts for enhancements and

modifications to the product

. Developed SQL Scripts for validating data transaction and database

integrity.

. Coordinated Project activities and managed teams across globe

Environment: VB.Net, ASP.Net, SQL Server 2005, Mercury Quality Center, QTP.

Trichup.com

Trichup.com is an e-commerce application which facilitates the customers

worldwide to shop the products of Vasu pharma. Here the user can identify

the list of desired products by selecting an appropriate indication like

bones and joint care, kidney care, liver, skin and hair care etc. The

products added to the shopping cart can then be delivered to the shipping

address upon payment.

Role: QA Analyst

Duration: Feb' 04 - Nov' 05

Client: VHC

Responsibilities:

. Responsible for writing test cases after reviewing the business

requirements document, and technical specifications document.

. Actively involved in designing and executing test scripts for systems,

integrated and release testing stages.

. Wrote SQL Queries to perform database (backend) data testing.

. Used Test Director as the approved defect reporting and tracking tool

and defect analysis.

. Involved in different walkthroughs meetings with the Business

Analysts, Developers and others in the team.

. Trouble shooting issues that come up regularly.

. Writing technical test specs and other documentation.

. Responsible for UI, functional, regression testing.

. Closely interacted with billing system (API) to test the functionality

of the application.

Environment: Test Director, ASP.Net, VB.Net

ATP Tool:

This application allows the resources to showcase their achievements in the

current year to the project managers and plan their targets for the next

year in order to be awarded for their efforts. Tool captures this data and

checks if associate meets his / her targets and automatically suggests

points to be awarded. This can be approved / rejected by the project

manager and he can give his own comments and rating to the associate. Based

on this the associates would be rewarded for their performance.

Role: QA Analyst

Duration: Jun' 03 - Jan' 04

Client: SIS

Responsibilities:

. Prepared detailed Test Cases based on Requirements Document.

. Wrote SQL scripts using SQL Server and performed Back end testing

. Performed data-driven testing to read test input data from an Excel

File so as to test the application with different positive and

negative data.

. Executed test cases manually. Compared and analyzed actual with

expected results and reported all deviations to the appropriate

individual(s) for resolution.

. Responsible for Functional, Data Integrity, Regression, and System

testing.

Environment: C#.Net, ASP.Net, SQL Server 2000, Test Director[pic]

Contact this candidate