Sales Testing

VINAY PANCHAL

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

Phone 248-***-****

A Senior Quality Assurance Technician with a wide range of

experience. Able to work on own initiative and as part of a team.

Proven leadership skills involving managing, developing and

motivating teams to achieve their objectives. First-class

analytical, design and problem solving skills. Dedicated to

maintaining high quality standards.

Summary

Industries: Retail; Consumer / Electronics / Mechanical Goods;

Media and Entertainment; Banking

Testing Tools: Quality Center 9.0, Mercury Test Tools(WinRunner 7.0

and Test Director 6.0/7/2), Quick Test Professional,

Clear Quest

Computer Languages: PL-SQL, Java, C++, C, HTML, JavaScript, XML, UML,

Visual Basic, VB Script

Database MS SQL Server 7.0/2000; ORACLE 7.0/9.0; MS-Access 2000

Operation Systems: Windows 95/98, Windows NT/XP, Unix, Red Hat Linux

Development Tools: Visual Studio, Jbuilder, Microsoft Visio, Edit Plus

6.0

Applications: Microsoft Office 97/2000,Visual Source Safe, RWD

InfoPak, IBM Ascendant, PVCS, VM Ware

Browsers: Internet Explorer 6.0/7.0, Netscape Navigator, Mozilla

Firefox

Development Tools: Visual Studio 2005, Visual InterDev,

Web Servers: Apache Web Server, Java Web Server (JWS), Internet

Information Server (IIS), Personal Web Server (PWS)

Experience Summary:

Over 8 years of QA experience in all phases of life cycle, including

requirements gathering, coding, risk analysis, project planning,

scheduling, testing, defect tracking, management, and reporting.

Strong analytical experience in developing user interface,

functional specifications, and application rules for Web based

Application Testing, GUI Testing, Functional Testing, Integration

Testing, Regression Testing, Client/Server Testing and Interface

Testing.

Ability to apply technical expertise to organize and implement white

and black-box test efforts and to analyze requirements for software

design, development, and validation

Extensively used Mercury Interactive testing tools like Quality

Center, WinRunner, QuickTest Professional and TestDirector for

various Web based and Client Server applications.

Strong experience in descriptive programming and VB Script

programming. Used VB Script to create custom functions, file access

and database connections.

Experience in developing Software Test Plans, Test Case Design, and

Test Scripts based on User Requirements Specification and System

Requirements documents.

Hands on experience in application development using SAP Sales and

Distribution, SAP CRM, Java, J2EE, JFC/SWING, JDBC, JSP Servlets,

Visual Basic, XML, C++, JavaScript, Oracle, SQL server, Microsoft

Visio, Microsoft Visual Source Safe, RWD Infopak, IBM Ascendant

Experience in Software Unit Testing, Integration Testing, Regression

Testing, performance, configuration and usability testing.

Strong background in analysis and transforming/improving business

processes.

Experienced in Database Testing such as Schema Testing. Strong

knowledge of writing and testing Stored Procedures, Functions,

Triggers, Cursors and Indexes.

Have excellent analytical, problem solving, decision-making,

presentation skills communication skills, work ethics and the

ability to work well in a team or individual environment

Capability to apply wide technical and practical skills to manage

and execute white-box and black-box tests and to evaluate needs for

software designing, development, and validations.

Ability to learn new technologies and challenging concepts quickly

and implement them.

Basic knowledge of Shell Scripting and Unix Commands

Experience in installing and configuring various Web Servers and

Applications

Experience in Unix Shell Scripting.

PROFESSIONAL EXPERIENCE:

Company : Orion Inc

Client: KPMG, Montvale, NJ (May 2010 to Date)

Role: Sr. QA Analyst

Environment: Test Complete, MS Office. Windows 7.0, Quality Center

10.0, Clear Quest, SQL Server 2007, Microsoft .Net, HTML, VBScript

Involved in writing the Green Chart, test plans, test cases, review

reports, and defect Logs, Installation documents

Prepared and validated the test script using Test Complete 8.0

software.

Performed Unit Testing, System Integration Testing, White Box

Testing and Black Box Testing.

Prepared and reviewed the Test cases using Quality Center and Clear

Quest software.

Identified and logged the defects using Quality Center and Clear

Quest software.

Validated and closed the defects resolved in Quality Center and

Clear Quest.

Meeting with Business Analysts, Developers and clients for

functional changes.

Arranged daily status meeting with offshore QA and Development teams

and periodic meetings with business users and clients

Performed manual testing of eAudit for French, Urdu and Hebrew

languages.

Leading offshore and onshore team of 5 QA Analysts and Software

testers for eAudit project and 3 QA Analysts and Software testers

for Engagement Site, File Retention tool, eADiagnostics project,

eAudit Online web service.

Arranged and attended Defect Review Meetings with clients and

Development Leads

Company : CTG (Computer Task Group)

Client: Corning Inc.,NY (October 2009 to May 2010)

Role: QA Lead

Environment: Quick Test Professional 10.0, MS Office. Windows XP,

Telelogic DOORS, Microsoft Team Foundation Server 2010, SQL Server,

Java Script, HTML

As an Analyst involved in gathering business requirement, studying

the application and involved in writing the test plans.

Created Test Requirement and Test Cases in the Telelogic DOORS

software from Requirement Specification Document

Quick Test Professional 10.0 test tool used for automated testing

and for generating test scripts. Developed custom scripts through VB

Script. Created custom functions, file access and Database

connection through VB Script.

Documented Defects found during test on the Microsoft Team

Foundation Server 2010 and communicated, recorded problems to the

responsible development personnel

Developed automated test scripts using Quick Test Professional and

played back. Analyzed the test results and triggered suitable

corrective actions.

Microsoft TFS 2010 was used for Version control.

Developed various bug reports, log reports, test reports using MS

TFS.

Developed Test cases connectivity DOORS software with Bug Report in

MS TFS

Performed Black box and White box testing for shell scripts, Java

Scripts, HTML and Java.

Involved in Functional, Unit and System Testing

Participate in weekly meeting with the management team and

walkthroughs

Arranged and attended weekly bug report meeting, future enhancements

meetings, and test case scenario meetings.

Involved in preparing test data required for running the tests and

executed test cases.

Performed GUI, Functionality, Usability, Regression and Security

Testing using QTP.

Worked with development team to ensure testing issues are resolved

Performed System Integration testing for IDAS system. Created and

analyzed log file.

Created test cases, bug report and user manuals for system

integration testing.

Accessed and manipulated files through Unix Shell Scripting.

Client: IBM, USA (May 2007 to April 2009)

Role: Sr. QA Analyst, Sr. Consultant

Environment: IBM Ascendant, MS Office. Windows XP, Test Director,

Quick Test Professional 9.0, RWD Infopak, Mercury Quality Center,

Java, Lotus Notes, SQL Server, SAP CRM 5.0, Java Script, ABAP 4.0,

Web Services, SOAP

Client: Medtronic (May 2007 to August 2007, August 2008 to March

2009)

Project: Complaint Management

Responsible for Functional and Regression testing using Quick Test

Professional

Prepared Functional Unit Test (FUT) documents using BPP documents to

include all the functionality for different transactions.

Manually tested all the scenarios covered in FUT documents. Describe

the result in detail with screen shots.

Documented and reported bugs found out during the process of testing

in the bug database of the QA

Prepared BPP (Business Process Procedure) documents from the

Functional Specifications for different transactions and activities.

Attended meetings with Functional Consultants to verify the scenario

to be included in FUT documents.

Worked with IBM Ascendant tool for Document Version Control and

Maintenance.

Pass all the FUT documents, BPP documents, COE documents to

Functional and Business team for approvals.

Modified the existing Functional Specification and sent them to

RICEF and Business approvals.

Created User and System Manuals

Client: Bridgestone Firestone Company Client (January 2008 to June

2008)

Project: COOP and Smart Resource Module

Discussed, Analyzed and documented business requirements for COOP

and Smart Resource module for leading Tire Manufacturing Company.

Arranged meeting with end clients, Gathered and analyzed the current

requirements, flow charts and business process. Proposed and

suggested the new requirements.

Conducted Gap Analysis to facilitate move to the new system and lay

out expectations.

As a Business analyst, created the Requirements document using

existing and new requirements, functions and existing and proposed

screen shots.

Knowledge Transfer of detailed requirements to development team.

Client: Lenovo (August 2007 to December 2008)

Project :Service, SRM and Order to Cash Module

Prepared Test Plan, Test Cases and executed Test Cases for manual

Testing and automation testing using QTP

Created Custom functions and scripts using VB Script.

Used VB Script to access MS Excel files.

Performed field size validation and check constraints for different

tables in the database.

Performed front end data validation with back end data.

Involved in database testing such as schema testing

Prepared course outline for Claims and Warranty management, Service

management, Complaint Management and Supplier Relationship

Management

Analyzed Blue print, Functional Specification, Design Documents and

BPP documents.

Developed and Reviewed the power point presentation for End users

Worked in different modules with Developer, End user and Tester to

prepare the Demo data for instructor

Developed simulator files for Claims and Warranty, Complaints

Management, Installed Base, Supplier Relationship Management and

Order management using RWD InfoPak

Used web services to transfer billing data from Windows environment

(processing) to Unix environment (billing).

Client: State Farm Insurance (February 2005 TO April 2007)

Role: Sr. QA Analyst

Environment: Visual Basic, Test Director 7.0, Quick Test

Professional 6.5, VB Script, HTML, XML, UML, MS Office 2000, Visual

Source Safe, Windows XP,

Involved in testing of an online application. The application helps

the field agents of the company to enter prospective customers' data

also calculates the amount of premium required, cash value and

benefit amount for the years in consideration. I was involved in

testing the Long Term Cares.

Involved in the Quality Assurance Analysis and Testing of Insurance

Information System.

As an Analyst involved in gathering business requirement, studying

the application and involved in writing the test plans.

Involved in the Regression Testing of Property Module with different

Data (Data driven Test).

Quick Test Professional tool used for automated testing and for

generating test scripts.

Used VB Script to create custom test scripts.

Documented Defects found during test on the Test Director and

communicated, recorded problems to the responsible QA or development

personnel

Participated in various meetings and discussed Enhancement and

Modification Request issues

Visual Source Safe was used for Version control.

Performed Black box and White box testing.

Involved in Functional, Unit and System Testing

Participate in weekly meeting with the management team and

walkthroughs

Involved in preparing test data required for running the tests and

executed test cases.

Performed GUI, Functionality, Usability and Security Testing using

QTP.

Extensively used SQL queries for Data verification and Backend

Testing.

Client: Flagstar Bank, MI (MAR 2004 TO DEC 2004)

Role: Sr. QA Analyst

Environment: J2EE, Oracle 9.0, WinRunner, Test Director 7.0, Windows

NT, PVCS, MS Office 2000

The Purpose of Cash Management's Account Analysis system (CMAA) is

to track information for a customer, as well as the multiple

corresponding accounts that a customer may have. The system allows

customer to be charged on both a daily and monthly basis. Charges

may be entered manually or downloaded from a text file. The system

also generated a full set of predefined reports.

Involved in complete testing life cycle of the project

Designed the test cases to satisfy all the functions of the

application

Managed all test plans, test cases and reported bugs with the help

of PVCS Tracker.

Conducted Manual Test for entire applications using manual scripts,

which are designed specifically.

Performed System, Security & User Acceptance testing.

Attended Bug Review meetings and discussed issues with the

Developers and Business Owners.

Reviewed the User Requirements Document, Functional Requirement

Documents and Technical Requirement Documents.

Responsible for Functional and Regression testing using WinRunner

Worked closely with development staff to resolve the defects and

Testability issues throughout Software Test Life Cycle.

Client: Holcim, Inc., Dundee, MI (FEB 2003 TO DEC 2004)

Role: Sr. SAP Consultant, QA Analyst

Environment: SAP R/3 4.6, Test Director 6.0, MS Office 2000

The purpose of SAP Sales and Distribution Module is to integrate

different phases of the sales order into single system. Sales order

includes Inquiry, Quotation, Order, Shipping and billing.

Configuration of document type, Inquiry, Quotation, Order and

linking with item categories and schedule line categories.

Definition & Assignment of Enterprise Structure - Sales

Organization, Distribution channels, Divisions, Sales areas, Sales

groups, Storage Location & Warehouse.

Defined Copy Controls for Sales Documents and Worked on Sales

Inquiry, Quotation, Rush Order, Credit Process, and Free-of-charge

Sample Sales order types configuration.

Configured different sales scenarios related to Third Party Sales

and Cross Company Sales. Used Material Listing/Exclusion and

Material determination to automatically exchange materials in the

sales document.

Configuration of consignment stock process and Outline Agreements

which includes Quantity and Value Contract.

Set up collective invoicing for multiple orders and deliveries and

maintained Text, Output and partner determination procedures.

Configured Account groups, maintained number ranges, assigned number

ranges to Account groups and implemented Partner Determination.

Involved in writing and implementation of the test plan and

developed test cases and test scripts in Mercury Test management

tool Test Director.

Used Test Director to store, tracking and reporting bugs.

Involved in Functionality, Block box, Integration, System, and Load

testing.

Performed End-to-End testing manually

Monitored TestDirector to close the bugs/cases as and when

developers fix the bugs

Performed User Acceptance Testing on behalf of End Users

Configured Apache Web Server

Client: Dr Reddy's Lab, India (AUG 2000 TO DEC 2002)

Role: Software Engineer

Environment: JDK1.2, SQL Server, Visual Caf , MS Office, Microsoft

Visio, Win Runner, Load Runner, Quick Test Professional, HTML, Java

Script, Clear Quest

Enterprise Logbook is an intranet and internet based Time Management

and logbook application for the employees. Employees can record

their daily incoming and outgoing timing. Plan their meeting,

activities and sub activities. A supervisor is authorized to view

all the activities and meetings of the employees. Daily, Monthly and

weekly reports can be generated from the application.

Prepared Functional Specification and system specification document

from the existing requirements.

Arranged and attended meetings with RICEF and Business Team.

Enterprise Logbook System was developed for a Company Manufacturing

UPS, Variable Speed Drives etc. All the database transactions were

handled by Middle tier which was RMI SERVER, Connected to database.

The System was developed using 3 tier architecture.

Gathering business requirements from the clients. Analysis and

design using different levels Data Flow Diagrams, ER Diagrams.

Database connectivity to the application using JDBC connection

pooling.

Developed screens using AWT and JFC Swing controls.

Prepared Functional Unit Specification document from the Functional

Specification.

Manage script creation for regression and stress testing using

LoadRunner and QuickTestPro

Use Clear Quest for repository, reporting and tracking bugs, and

providing updates on resolved bugs.

Involved in Black Box and White Box Testing

Involved in the development of Unit Testing and Integration Testing

Created system manual and user manual.

Configured and used Personal Web Server (PWS) and Internet

Information Server (IIS)

Education:

Master in Computer Application, DDIT, Nadiad, India

Sun Certified Java programmer

Core member of the team implementing ISO 9001, CMM and function in

charge of Requirement Management.

Audited different projects and processes as a part of Internal Audit

Schedule of the company.

Contact this candidate