Quality Assurance Supply Chain
Resume:
Vaibhav D Gandhi
Phone: 214-***-****
Email: *********@*******.***
Objective:
I am looking for a key Quality Assurance team lead position in a fast-
paced technology company with varied responsibilities and the potential for
advancement.
Summary
. 5 years of experience in Software Quality and 3+ years as a Test Lead.
. Lead a team of 7 across various products.
. Expertise in leading the onsite-offshore model of software
development.
. Experience working in Agile/Scrum methodology/process.
. Proficient in using Testing Tools like Test Director/Quality Center
9.2/10.0, QTP 9.5/10.0.
. Subject Matter Expert in Automation Framework and its best practices.
. Highly skilled in MS Query, DB Visualizer and SQL Analyzer in SQL
Server 2005 and Oracle environment.
. Experience in Client-Server, Web and Mainframes application testing.
. Have good familiarity with Bug Tracking Tool and Process.
. Experience in documenting and implementing Test Plan and Test Case.
. Savvy in setting up the Server from scratch for Client-Server as well
as Web based application.
. Extensive knowledge of QTP related third party support tools like Test
Advantage.
. Excellent domain knowledge of Supply Chain, Consumer Goods/Retail,
Healthcare and Finance.
. Good analytical & communication skills, excellent and innovative
presentation skills.
. Expertise in building metrics such as Requirement traceability, Test
execution, Test case coverage, Defect severity/priority, Defect Aging.
Technical Skills:
Operating System: Win 98/2000/XP
Databases: SQL Server 2005, DB2, Oracle, MS Access
Languages: VBSCRIPT
Testing Tools: Test Director/Quality Center 9.0, 9.2 and 10.0,
QTP 9.2, 9.5 and 10.0, Test Advantage, Load Runner 7.2,
VSTS, Lotus Notes, MS Query, SQL Analyzer, DB Visualizer,
Golden 32, Toad, Informatica and Win Runner
Professional Experience:
PepsiCo
Aug 09 -Till date
QA lead
Description:
Supply Chain Dashboard is a web based application used by the senior
management to view the performance of the existing plants and distribution
centers across North America. It displays metrics as well as graphical data
based on the search criteria.
Pipeline stream of applications are used to place, pick, modify, complete
and acknowledge the customer, facility and route orders.
KEY ACHIVEMENTS:
. Lead a team consisting of onsite and offshore resources.
. Provide high level Estimates, Test Plan, Test Strategy and Test
Summary report.
. Communicate the list of priority tasks expected from the team for
that particular week.
. Take up the next set of tasks from the customers and prepare the
30, 60 and 90 days plan with respect to each team member.
. Prepare test scenarios and review test cases
. Hand shake daily with the offshore resources regarding the progress
of assignment.
. Investigate, solve the technical issues of the team.
. Conduct ETL testing using Informatica.
. Review the QTP automated scripts.
. Initiate process improvements wherever necessary.
. Build reports from Quality Center.
. Execute UNIX scripts and verify the data on the mainframes.
. Provide weekly status report to the stakeholders.
Environment: Xcelsuis/SAP, COBOL, DB2, Java, Oracle
Eclipsys Corporation
Mar 07 -June 09
Senior QA Analyst
Description:
Sunrise Medication Manager deals with medication care of the patients.
Emergency Department provides Patient care during the critical condition.
Sunrise Clinical Portal is a web based product helping the physicians and
nursed to keep a check on patient health and their reports. Sunrise
Radiology deals with fixing the appointment, conducting examination and
viewing the reports. SIRI handles the insurance claims processing for the
healthcare services provided.
KEY ACHIVEMENTS:
. Lead a team of 7 automation test engineers
. Prepare Test Plan and Test Case based on the requirement
specification.
. Execute Smoke test and Ad hoc testing.
. Identify test scenarios that are suitable for automation.
. Instrument in developing the Automation Framework.
. Design and develop the Automation Test Script.
. Solve technical issues of the team.
. Build the Enterprise Server and Database Server from scratch.
. Restore, backup and truncate the database with each build upgrade.
. Upgrade the server side configuration as and when a new build is
released.
. Troubleshoot with HP for any QTP related constraints or issues.
. Discuss the progress of the assigned work and plan the next phase
of tasks.
Environment: .NET, SQL Server 2005, QTP 9.5, QC 9.2, Test Advantage, VSTS
CCH, A Wolters Kluwer Business
Jan 06 -Feb 07
Quality Assurance Analyst
Description:
This application is mainly used for Audit & Account purpose. The features
includes Signing Off any of the item in the workpaper, Tracking changes,
Providing answers to predefined set of questionnaire, Viewing Smart Tips
associated with each item of the workpaper and Inserting tick marks.
KEY ACHIVEMENTS:
. Understanding the business logic of the application and develop the
test plan and test cases.
. Identifying the test cases for regression and automating the same.
. Preparation of test data and upload the same into application to
test the application under peak load.
. Execute the scripts daily in overnight batch mode.
. Create test execution report.
. Use Descriptive programming to tackle complex situation while
automating.
. Automation framework enhancement in QTP.
. Create Reusable Libraries using VBscript which includes use of COM-
DCOM objects for sending mails after each batch execution.
. Extensive use of Regular Expression in QTP to better identify the
objects.
. Maintain scripts from release to release.
. Review the scripts and provide necessary feedback.
. Database Testing using SQL queries.
Environment: .NET, SQL 2005, QTP 9.2, QC 9.0, LoadRunner 7.2, Lotus Notes
Client: Eclerx Services
Oct 05 -Jan 06
Quality Assurance Analyst
Description:
This application had 3 logins namely administrator login, guest login and
registered login. Based on the assigned rights to each of the login the
user can perform activities related to online investments. Administrator
login can view the entire client base data including their business
profile. Registered login has access to their own investment profile and
can perform transactions online related to investment. Guest login can
create their account online and view the services offered by the vendor.
KEY ACHIVEMENTS:
. Create test cases and test plan. Execute test cases
. Log bugs and track defects through the entire bug life cycle.
. Data driven test and Batch test using QTP.
. Understand the existing set of scripts in Win Runner and migrate
those in QTP.
. Establish ADODB connection using VBscript.
. Retrieve data from the database using record set concept.
. Tackle unexpected errors using Error Handler.
. Use of Recovery Scenario to ensure uninterrupted batch execution of
the test suite.
Environment: Java, Oracle, Quality Center 9.0, QTP 9.2.
Education:
Degree Institute
BS in Computer Pune University
Engineering
Contact this candidate