QA Test Engineer

Sandeep kaur

Email:***********@*****.***

Phone: 571-***-****

Summary:

. Over 8 years experience in Information Technology with over 7 years

experience in Software Testing

. Performed both Manual Testing and Automated Testing on Client-Server and

Web-based applications.

. Advanced knowledge in writing SQL queries for Database Testing

. Testing expertise in performing Interface, Functional, GUI, Database,

Regression, and Security testing

. Extensive experience in Black Box Testing

. Experience in performing Backend Testing to verify data integrity

. Excellent experience in testing with Automated Tools such as Quality

Center,QTP

. Hands on experience with all phases of Software Development Life Cycle

(SDLC)

. Proficient in different phases of Testing like System Testing, Module

Testing and Integration Testing, Positive Ttesting, Negative Testing

. Extensive experience in Following QA Process,

. Excellent communications skills, strong analytical skills and a good team

player.

. Adaptable to work both as a team member as well as independently

Technical Skills:

Languages: VBScript, SQL

Operating Systems: Windows NT/2000/XP, MS-DOS

Databases: MS-Access, Oracle, SQL Server

Testing Tools: HP Quick Test Pro,HP Quality Center,TestDirector

Project Experience:

Geico Insurance, ChevyChase,MD

July'11-Present

Sr. Manual/Automation Tester

Atlas Rewrite project is to replace Geico's legacy Claims application with

Guidewire Claim Center. ClaimCenter is a Claim Management System which

supports all phases of Claims Process. New loss can be entered into the

ClaimCenter using the New Claim Wizard or can be imported from the external

system. The claim details can be viewed / edited using Loss Details

Screens. There are search screens that facilitate Claim Search, Policy

Search, Check Search etc. Exposures and Activities can be created

automatically using business rules or they can be manually created using

the ClaimCenter UI. The user can also create/update transactions like

Payment, Recovery, and Reserve using the ClaimCenter UI. Claims, Exposures,

and Activities can be assigned automatically using assignment rules.

- Analyzed Functional Requirements and Use Cases and developed

Test Cases and Test scripts accordingly

- Helped inserting the Requirement in the requirement Tab of

Quality Center

- Created the Requirement Tracbility Matrix(RTM) by mapping the

manual and automation test cases to requirement within the

Quality Center(ALM)

- Execueted the manual tests and logged the defects for the failed

test cases

- Provided daily Status report of test case execuetion during

Regression Cycle

- Execueted Complex SQL Queries to verify the Data

- Used Various SQL Statement e.g. Joins, Union and SubQuery and

Having Clause

- Inserted SQL Functions within the queries e.g. Avg,

Count,Max,Min and Group By

- Identified eligible Test Cases for Automation, and automated

them through Quick Test Pro(UFT)

- Inserted various Checkpoint e.g.image,bitmap,standard within the

QTP Automation Script

- Inserted Reusable Actions and Function within the QTP Automation

Script

- Inserted synchronization points, for synchronizing the different

actions.

- Used Transaction statement, for accurately recording the

transaction time of different modules.

- Connected to SQL Server through Quick Test Pro and verified the

Backend Data Integrity by writing the Queries within Quick Test

Pro.

- Developed a functional library in advance vbscript along with

Quick Test Pro reusable Actions.

- Used descriptive programming in Quick Test Pro

- Handled exceptions in script programatically along with Recovery

Scenario Manager

- Execueted the scripts through Quality Center Test Lab module.

- Configured parties involved screen to display claim contacts

based on the selected filter option.

- Developed Claim Incidents Screen to display all Vehicle/Non-

Vehicle Incidents associated with a Claim.

Tools: Quick Test Professional 11, Quality Center

10,JIRA,JSP,Perforce, Oracle 10g, Apache Tomcat.

Dycom Industries Palm Beach

Gardens,FL

Sept'09 -June'11

Dycom Industries, Inc. is a leading provider of specialty contracting

services. These services are provided throughout the United States and

include engineering, construction, maintenance and installation services to

telecommunications providers, underground locating services to various

utilities including telecommunications providers, and other construction

and maintenance services to electric utilities and others.

Tech Dispatch ( Dycom Industries)

Tech Dispatch is a Scheduling System that dynamically routes Tickets

to Technicians to their Work Locations.Tickets are matched to

technicians based on multiple factors: Required completion Time/Date

of Ticket, Physical Location of Technician, Scheduled Time

Off/Breaks, Locate Duration, Emergencies and Ticket Type, Weather,Traffic. Tickets are feed into the system through parser.

- Mostly Involved in Automation Testing of the application through

Quick Test Pro

- Automated the process of Ticket parsing through Quick Test Pro

- Used FileSystemObject to create,copy and moved Files.

- Used Vbs functions to search and replacing thetext in .txt

files.

- Used the Date Funtion to change the dates of the ticket and

formatted the date accordingly.

- Used Various Checkpoints during the Automation Scripts

- Identified the objects, their properties and methods, using

Object Spy, in Mercury Quick Test Pro.

- Developed the Data-driven automation scripts, using data from

different Excels sheets, through Mercury Quick Test Pro.

- Extensively used VBscrips function, for the customization of the

automation script in Mercury Quick Test pro.

- Developed a shared object repository in Quality center, through

using Mercury Quick Test pro.

- Created a Global Recovery Manager.

- Customized the global setting according to the application

requirements.

- Developed numbers of different actions, for reusability

purposes.

- Integrated the different actions, to form several scripts.

Environment: Window, Microsoft Visual Studio, Asp.Net, C#, Microsoft

SQL Server, HP Quality Center 9.2, Mercury Quick Test Pro 9.2, HP

Quick Test Pro 10

eSketch 1.24 (Dycom Industries)

E-Sketch is a software application that is installed on the PC, and it

provides a graphical user interface that locators use to render

diagrams that depict the location where the locator sprayed paint to

indicate where a facility line is located. E-Sketch assists the

locator by displaying an image file on the computer that is an aerial

photograph of the terrain, including buildings and foliage, where the

locator was sent to find and mark facility runs

- Documented & Updated Test cases in HP Quality Center.

- Involved in Project and defects meeting

- Invloved in Manual Testing for verification of requirements

- Developed test cases through using HP Quality Center.

- Executed the test cases manually using HP Quality Center.

- Reported numbers of defects in the defect module of the

application, by using the HP Quality Center.

- Actively participated in the weekly held bug review meetings.

- Tested the accurary of the GPS, and verified the color

combination on the basis of distance

- Performed regression testing after each build

- Tested ETL to made sure, Data is passing Between Qmanager

Database to eSketch Database

- Wrote and executed the SQL Queries, for backend testing

Environment: Window, Microsoft Visual Studio, C#, Microsoft SQL

Server, HP Quality Center 9.2, Mercury Quick Test Pro 9.2, Franson

GPSGate

Field Check 1.30(Dycom Industries)

Field Check is also known as Imag Approval System. Once the Locator

are done marking their facilities,they close the Ticket. Ticket is

then transferred to Database and it could be viewed through Field

Check application. Supervisiors can approve the ticket, can send a

ticket to QC or Coaching. Supervisors can see the different reports

and history of the Ticket.

This application also let upper management to view their Hierarchy and

tickets information of the reporting subordinates.

- Involved in Manual Testing of the application

- Tested all the modules of the application

- Updated and added Test cases in HP Quality Center

- Coordinated with other members of QA Team, to understand the

application

- Went through the old test cases and old defect in Quality center

to better understand the application

- Assiged defects to developers after discussing the issues with

them

- Performed the Security testing of the application i.e. only

supervisors and management can access the application, and only

manager can access and approve the ticket for their subordinates

level.

- Updated QA Lead and ITS maanger about the progress of testing

- Tested the ETL progress, to make sure, all different types of

ticket along with all the images are passing to Field Check

Application.

- Tested the reporting feature of the Application

- Performed thorough regression testing after each build.

- Execueted the different Stored procedure to make sure, all the

Hierarchial information is appearing as in Database SQL Server

- Designed and execueted SQL Queries to verify the Data

- Compared the Data of Qmanager admin to Field Check application.

- Verified and tested the Production Issues.

- Made sure, all the RFCs go through QA Enviroment first

-

Environment: Window, Microsoft Visual Studio, Asp.Net, C#, Microsoft

SQL Server, HP Quality Center 9.2, Mercury Quick Test Pro 9.2

Advisor Online 2007 West Palm Beach,FL

Mutual Service Corporation Feb'07 - Sep'09

QA Tester

Advisor Online 2007

Advisor Online 2007 is the newest edition of Mutual Service

Corporation software that helps its reps, to better manage their

business. This is the most significant advancement MSC has made to its

technology to date. The application provides an integration of clients

and accounts with a redesigned user interface.The major modules of

this application are Clients, .Accounts, Calendar, Distribution,

Transfer and Reports.

- Created the project Advisor online 2007 in Mercury Quality

Center 9.0.

- Created user and assigned different user level access to

different groups including Tester, DBA and developer in Mercury

Quality Center 9.0.

- Created new Mercury Quick Test pro Script for all the modules.

- Documented a Business requirement Document for the QA Team.

- Documented Test cases and Test Plan.

- Helped in documenting the Test cases for the application in

Mercury Quality Center.

- Reported defects in Mercury Quality Center, and Followed through

until defects are fixed.

- Perform Regression Testing, after fixing of the bugs.

- Trained and Lead QA tester team, for the testing of the

application.

- Documented a user manual of the Advsior online, for the purpose

of training of QA Team.

- Attended and participated in the weekly held QA meeting.

- Reported to QA manager and Project manager for all the testing

update from time to time.

- Tested in Intregation Enviroment to make sure, the defects have

been fixed, before moving to QA environment.

- Helped QA teams, for clarification of Business logic.

- Divided the Mercury Quick Test Pro Script into number of

Actions, for the purpose of reusability.

- Created several check points, for the validation of the scripts

and application.

- Participated in Load testing of the application. Defined

performance requiremnt for the application.

- Designed Complex SQL queries for Back end testing through

Mercury Quick Test Pro and Microsoft SQL Server.

- Ran stored procedure, designed by developer, to help testing the

application.

- Verified the Data in our back office application,in Microsoft

SQL Server and iSeries Navigator in DB2.

- Tested the DB2 data through AS400 query application.

- Created Recovery Scenario Manager for the application.

Environment: Window, Microsoft Visual Studio, Asp.Net, Fox Pro, DB2,

Microsoft SQL Server, Mercury Test Director, Mercury Quick Test

Pro 8.2,9.0,9.1,IBM iSeries Navigator, As400

Education:

Bsc Economics (hons.)

Post Graduate diploma in computer Applications

Contact this candidate