Quality Sql Server

REEMA JUSTIN 732-***-****

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

Summary:

● Ten plus years of professional experience in Quality Assurance and Software testing

● Experience in various phases of Software Development Life Cycle (SDLC)

● Strong Experience in Client Server and Web based Application testing.

● Expertise in both Manual and Automated testing.

● Expertise in White Box and Black Box testing.

● Experience in creating Test Plans, preparing and executing Test Cases and Test Scripts.

● Thorough hands on experience with all levels of testing including Smoke Testing, Functional Testing, Integration Testing, Regression Testing, End-to-End testing, System Testing and User Acceptance Testing

● Experience working in HP ALM and Team Track

● Extensive experience in QTP Automation Frameworks (Keyword Driven, Data Driven and Hybrid )

● Developed automated test scripts using VBScript in Quick Test Professional (QTP)

● Experience working in both Development and Production support.

● Knowledge of Waterfall, Agile and Iterative Methodologies.

● Solid ability to create "ad-hoc" tests to exploit areas of suspect performance.

● Strong Experience in Back-end testing.

● Expertise in RDBMS like Oracle and SQL Server, writing SQL Queries.

● Good working knowledge of major Operating Systems and tested applications on Windows and UNIX environments

● Extensive experience MS Office tools like Excel, Word, Visio, PowerPoint and Access.

● Excellent in meeting deadlines, attention to detail, time management and presentation skills.

● Possess strong problem analysis skills with ability to follow project standards.

● Exceptional ability to quickly master new concepts to applications and a team Player.

Technical Skills:

Testing Tools : QTP 9.0/9.2/10,11

Bug Reporting Tools : Quality Center 8.2/9.2/10,11,Team Track

Languages : SQL2000/2008, PL/SQL, VB, .NET, C.

Web Technologies : HTML, DHTML, XML, JavaScript, VBScript

Databases : Oracle, Microsoft SQL Server,, MS Access

Operating System : Windows XP/NT/2000/2003/98, UNIX, AS/400

Professional Experience:

UPS, Paramus, NJ Jan’10 – current

Project: GSS

Role: Sr.QA Analyst

Project: GSS ( Global Scanning System)

Role: Lead Tester

The Global Scanning System is computer software and hardware that will capture and maintain information from packages and equipment in UPS international facilities. These products gather data from international and subsidiary package scans and make the data available for the following purposes: • Determine plan operational volume flow • Provide visibility to customers • Simplify package handling • Meet Customs regulatory requirements worldwide.

● Implemented Quality Center for the entire project.

● Attended requirement meetings and design review meetings to analyse the requirements

● Developed Testcases from usecases and assign it for different testcycles

● Test Cases are executed in HP ALM and Identified defects are logged in team track

● Report the defects in Team Track

● Developed SQL queries for Root cause analysis and backened testing

● Assigned and coordinated with work with team members

● Prepared weekly and cycle summary Reports

● Actively participated in daily bug review meetings and reviews and interacted with developers to ensure high quality software.

● Prepared daily and Cycle Summary reports to improve the process

● Upgraded Quality center 10 to HP ALM

● Automated UI in QTP11.

● Worked on mainframe environment

● Involved in Manual stress and Performance testing

UPS Data Capture

A distributed data capture system with the ability to capture package information for int'l and domestic shipments. UDC has acquired the responsibilities of Data Movement and Workflow Management with its inclusion in the Worldport and PFT automated solutions. In addition, it has been integrated with many UPS systems to facilitate in Operational Reporting, Package Routing, Customs Clearance, Document Imaging, Scanning, Package Tracking, Billing, Preload Simplification.

Responsibilities:-

● Develop detailed test plans from use cases and develop test cases for functional, integration, system testing, regression and user acceptance testing.

● Implemented Quality Center for the entire project individually.

● Upgraded Quality center 9.2 to Quality center 10

● Give training to team members on Quality center

● Assigned Test sets and requirements to different cycle

● Test Cases are executed in Quality Center 9.2 and Identified defects are logged in team track

● Extensively worked on QTP scripts in analyzing the business processes and created automation scripts.

● Enhanced the QTP Scripts in expert mode in order to implement efficient test scenarios.

● Upgraded QTP 9.2 to QTP 10

● Performed keyword driven testing, designed Input/Output check points to validate the data and develop effective automated QTP Scripts

● Lead the automation team to develop QTP scripts in Keyword driven framework

● Performed extensive VB scripting using QTP 10 and 11

● Wrote WMI Queries to interact with windows services

● Wrote SQL queries to get data from SQL Server database

Environment: HP ALM, QC 9.2,10, QTP 11 9.2, XP, Windows7, XML,TeamTrack, mainframe, AS/400, MS SQL Server, Agile,

Verizon Wireless, NJ Aug’08 - Dec’09

Project: My Verizon

Role: Sr.QA Analyst

Myverizon is a self service portal for customers of the Verizon wireless. The system has ability to be able to respond to changing user and application needs. This web application includes all the features for the customer to buy /upgrade their phone.

Responsibilities:-

● Involved in different phases of Software Development Life Cycle.

● Develop detailed test plans from use cases and develop test cases for functional, integration, system testing, regression and user acceptance testing.

● Extensively worked on QTP scripts in analyzing the business processes and created automation scripts.

● Test Cases are executed in Quality Center 9.2 and Identified defects are logged.

● Reported the bugs, Email notifications to the developers using the Quality Center.9.2

● Performed data driven testing, designed Input/Output check points to validate the data and develop effective automated QTP Scripts

● Performed extensive VB scripting using QTP 9.2.

● Created user defined functions using QTP.

● Tested different applications for the mobile users

● Involved in testing test harness page for Web services for different application area

● Tested Winforms in different application area

● Configure test environment for specific test cases, create test data, and execute automated or manual tests, document results, and update defect tracking systems.

● Work closely with developers, business analysts and user representatives and participate in the product design process including specification and other document reviews.

● Involved in manual testing.

● Extensively used Quality Center, for test planning, bug tracking and reporting.

● Actively participated in daily bug review meetings and reviews and interacted with developers to ensure high quality software

● SQL queries are written in TOAD to verify the Data for the validation.

Environment: Mercury Quality Center 9.0, QTP 9.2, Oracle10g, LoadRunner7.6 HTML, .NET, VB Script, XML, WSDL,TOAD, Windows XP, Unix, Microsoft Office tools, Agile, Scrum,, SOAP

EMA, Livingston, NJ Aug’06 – July 08

Project: ED Information Manager

Role: Sr.QA Analyst

EMA Software empowers healthcare organizations with exceptional information technologies and professional services that improve clinical and financial outcomes. Emergency Department Information Manager (EDIM) is a HIPAA compliant patient documentation, patient tracking and charge capture system designed to document the patient encounter from arrival to disposition, and track patient movement and progress throughout the visit.

Responsibilities:-

● Extensively worked in QTP scripts in analyzing the business processes and created automation scripts.

● Created and executed data driven test scripts in QTP.

● Conducted Functionality testing during various phases of the application using QTP.

● Enhanced the test scripts through Check Points and Parameterization.

● Created User Defined Functions in QTP.

● Called External functions in VB Script.

● Managed Back end (Oracle database) and data validation testing of the application

● Configure test environment for specific test cases, create test data, and execute automated or manual tests, document results, and update defect tracking systems.

● Analyze patient data by querying SQL

● Worked in the AGILE environment handling multiple projects at a time.

Environment: Mercury Quality Center 9.0, QTP 9.2, Oracle 9i, HTML, .NET, MS Excel, VB Script, TOAD, XML, WSDL, SOAP, Unix, Crystal Reports, Microsoft Office tools, UNIX, Windows XP, Agile, Scrum

Client: Cavin Corporation Jun’01 - June’06

Role: Programmer/Tester

Description:

The ‘MIS Data Collector’ prepares and sends the periodical database to the KHPT head office where it will get integrated into the MS SQL Server database through the Intranet Site developed in ASP. Net

Responsibilities:

● Develop web components for the front end using ASP.NET and HTML

● Developed Winforms

● Developed test cases, test scripts for functionality and regression testing.

● Setting Up the Database for Testing.

● Performed white box testing.

● Performing sanity testing

● Bug Logging.

● Preparing User Manual.

● Preparing daily and cycle summary Reports.

● Actively involved in team discussions in resolving the conflicting issues.

Environment: TestDirector8, C#.NET, ASP.NET, HTML, MS Word, MS Excel, Windows 2000, SQL Server.

Education:

● Masters in Computer Science, India

Contact this candidate