Neha Sakpal
Software QA Engineer
Ph: 804-***-****
Objective:
Progressively develop a career in QA field and implement testing
process & quality standards for manual and automation testing.
Summary:
As a QA Analyst / Test Engineer with more than 4 years of experience
in all phases of software lifecycle, developing Test Cases, Test Plan and
Automation test scripts using HP (Mercury) Quick Test Professional (QTP)
and performance testing in HP LoadRunner in Client/Server, Windows,
UNIX/Linux, Web Services and Web based applications. Good experience in
Banking, Financial, Supply Chain Management, Insurance and Telecom Billing
sectors with strong Business and Functional knowledge.
Specific Expertise:
. Excellent understanding of Software Development life Cycle (SDLC) and
importance of QA in Development/ Enhancement and Maintenance of
software applications.
. Expertise in Manual and Automated Testing in different testing
methodologies like Agile, Scrum, Waterfall etc.
. Extensively worked on ETL testing using Informatica and generated
reports using Oracle Business Intelligence and Enterprise Edition
(OBIEE) - Reporting tool.
. Hands-on experience in web services testing using standards like XML,
WSDL, SOAP and Java Message Service.
. Experience using SoapUI tool for Web Services for validating request
and response XML.
. Good scripting experience in VB for HP/Mercury Quick Test
Professional.
. Involved in developing and executing Test plan and Test Cases for
Functional and Regression testing.
. Proficient with automation testing, Quick Test Professional and
developing function libraries in VB script for QTP.
. Good working experience using Test Director / Quality Center, Rally,
Clear Quest, Jira, Bugzilla bug tracking tools.
. Developed test cases for Regression, and Data Driven tests using
automated test tools. Working experience with on site and off shore
team based on the schedules.
. Experience using different Frameworks like Hybrid, Keyword and Data
Driven frame works in QTP, Shared Object repository, descriptive
programming etc.
. Good experience in QTP - VB Script programming standards, developed
reusable functional libraries which are used in different scripts.
. Good experience in handling custom objects, exception
handling/Recovery Scenarios in QTP and also familiar with String
functions, Date functions, Math functions and other related QTP
functions.
. Utilizing Dictionary object in QTP, Maintaining Test data in Excel
files and Importing Excel files from Resources module in Quality
center to QTP data table and read the values based on the functional
requirement.
. Expertise in executing VUGen scripts in Load Runner for Performance,
Load and Stress Testing using Controller in Load Runner and generated
reports using the Analysis tool in Load Runner.
. Knowledge of performance bottlenecks, end-to-end performance, and web
performance measures like server response time, throughput and network
latency.
. Hands-on experience in Black box Testing, White box testing, Unit
Testing, User acceptance testing, Functional, Integration, GUI,
System, Usability, Regression, Performance, Security, Stress Testing
and backout testing.
. Participated in requirement review meetings, analyzing requirements,
developing test plan and test cases, Requirement Traceability Matrix,
Defect management, Reporting and tracking.
. Good knowledge in VB, C, C++, HTML and Java scripting languages.
. Proficiency in Structured Query Language (SQL), Joins, PL/SQL stored
procedures & Triggers.
. Experience in preparing Test data by retrieving data from Relational
Databases Oracle, MS-SQL.
. Have good working Experience in UNIX.
. Good Analytical, Interpersonal and communication skills. Result
oriented, committed and hard working with a quest to learn new
technologies and undertake challenging tasks.
. Highly motivated, self-starter able to work independently and
collaboratively within a diverse technical team.
Technical Skills:
Operating Systems Windows 95/98/00/NT/XP, MS-DOS and UNIX (HP-UX, Sun
Solaris).
Testing Tools Quick Test Professional ( QTP ), LoadRunner, Test
Director, WinRunner Quality Center, IBM (Rational) Test
Manager, Clear Quest, Bugzilla.
Languages Visual Basic (VB), TSL, SQL, HTML, XML,VB Script, Visual
source safe
Databases Oracle 9, 10, 11, MS SQL Server, Sybase, and MS Access
Tools SQL * Plus, Toad, Microsoft Office Suite, WS_FTP Pro,
WinSCP
App/Web servers HTML, XML, WebLogic Server, WebSphere, SoapUI, WebServices,
and other tools SAP
Adobe Flex and Adobe AIR, Informatica, Teradata, (ETL,
Data warehouse)
Education: Bachelor of Science.
PROFESSIONAL EXPERIENCE
Project#7
Supply Chain Management
Organization : Intelizign Engineering Services Pvt Ltd
Project title: E- Commerce / POS - Point of Sale - Billing
Duration : Jul2012-Jun2013
Summary:
The leading brands of America selling consumer electronics including
accessories. It has Internet based e-commerce web application. System is
designed and developed such that the transactions are secure, calculate
rates and billing based on the options, able to handle heavy user traffic
periods and allowed users to browse through the products. Features include
saving shopping cart, multiple shipping addresses, gift registry etc. Also
I worked on another project that is used in stores for Point of Sale (POS).
Role: QA Test Engineer(Manual/Automation)
Responsibilities:
. Developed test cases and performed manual testing for each system
build for POS, e-commerce apps.
. Performed Backend Testing and ensured the authentic retrieval of the
data from the database.
. Parameterized key elements to verify the Database Integrity.
. Conducted Regression Testing on various builds of the application and
reported the defects to the developers using Quality Center for the
bug fixing and tracking.
. Performed GUI Testing by creating GUI checkpoints to verify the
functionality of the GUI objects using QuickTestProfessional.
. Tested SAP SD - Sales and Distribution module to validate the data
and reports.
. Used Actions and Re-usable Actions in QuickTestProfessional, for
designing the Automation test scripts.
. Extensively worked with VB scripting and Descriptive programming by
using QuickTestProfessional.
. QualityCenter was used to track defects and reported to development
team.
. Developed base line scripts for testing the future release of the
application using QuickTestProfessional.
. Script enhancements and Data Driven Testing were implemented with
QuickTestProfessional.
. Enhanced Test Scripts using user defined functions (Function
libraries) in VB script.
. Involved in entire QA Life Cycle, which includes Test Designing and
Execution of the entire QA process and documentation of Test Plans,
Test Cases, Test Procedures and Test Scripts.
. Analyzed the specifications in the User Requirements Document,
Functional Specifications and Technical Requirement Documents to
prepare Test plans.
Environment: C# .net, VB Script, Oracle, SQLPlus, SAP SD module (Sales and
Distribution), XML, Quick Test Professional (QTP), Quality Center, MS
Office, Adobe Flex.
Project#6
Telecom
Organization : Intelizign Engineering Services Pvt Ltd
Project Title: Call Rating / Billing / PDF E-Bills
Duration : Jun2011-May2012
Summary:
One of the leading wireless service providers in the US market. Offers
various services through web based application for customers to view their
bills, pay bills, check their payments, e-bill enrollment, sort their bills
and print the bills in PDF format. Testing included new features, upgrades,
enhancements, production fixes and validating .csv and .pdf files which
contains customers monthly bill statements.
Role: QA Test Engineer(Manual & Automation Testing)
Responsibilities:
. Developed Test Plan and Test Cases for e-bill, call rating based on
the user stories (functional and technical requirements), based on
the solution requirement specification (SRS) documents from
Business analyst and technical design documents from Developers.
. Attended sprint plan meetings to review the requirements.
. Maintained issue trackers to track requirement and business
clarifications.
. Involved in manual testing of the application and tested the
billing functionality and call rating.
. Tested bill rating based on the universal service order codes
(USOCs), feature codes and plans.
. Tested billing calculations based on multiple plans / features like
text messages, downloading files etc.
. Involved in webservices testing using SOAPUI.
. Worked on Enterprise data Integration tool (Informatica) testing
the data migration from IBM DB2 to Oracle Database and reviewed the
mapping document and developed test cases for ETL testing.
. Experience in testing the process of extracting Meta data from
sources and targets, transform and load the data into Target
systems.
. Worked on generating reports using the Business Intelligence (BI)
Tools and knowledge of BI Architecture.
. Developed automation test scripts for Quick test professional.
. Data Driven Testing using parameterization in Quick Test
Professional (QTP) to test the application with different sets of
data. Executed SQL queries, joins and stored procedures.
. Conducted Unit Testing (Module Testing), Integration Testing,
Regression and Smoke Testing.
. Interacted with performance testing team to provide the
functionality of application to help them build performance test
plan. Prepared test data for performance testing.
. Executed VUGen scripts in Load Runner for Performance, Load and
Stress Testing using Controller in Load Runner and generated
reports using Analysis tool in Load Runner.
. Performed Smoke Testing, Security Testing, GUI Testing and User
Acceptance Testing.
. Member of the User acceptance Testing Team, wrote Enhancement
Requests and worked with the perspective of the user.
. Coordinated with developers to fix the bugs and conducted
Functional (Positive and Negative), and Integration Testing.
. Participated in weekly meeting with the management team and
walkthroughs.
Environment: C#, .net, QuickTestProfessional (QTP), Quality Center,
LoadRunner, MS Office, Unix, IBM DB2, OracleOLAP.
Project#5
Organization : Intelizign Engineering Services Pvt Ltd
Project : Life Insurance Claims management application
Duration : Jun2010-May2011
Summary :
This project was about Life Insurance claims management application of one
of the leading USA insurance provider. This insurer has its in house
Client/Server claims management system in microsoft technologies with SQL
2008 as database. This application was regarding handling all life claims
related activities from initiation of claim till claim closure with or
without payment dispatch. Position in this project was responsible for
testing application with ongoing enhancement in the application.
Role: QA Analyst (Manual/Automation)
Responsibilities:
. Developed Test Plan and Test cases based on the user stories
(Functional requirements) using the Mercury Quality Center.
. Involved in Database testing with writing SQL queries to validate
the data in target database
. Actively involved in functional, unit and integration testing in
the application.
. Attending scrum meetings to validate defect o review the user
stories.
. Detected defects, communicated to the developers using bug
reporting tool and tracking the defects using Quality Center.
. Extensively used Quality Center for test planning, bug tracking
and reporting.
. Uploaded Business requirements, test scenarios, test cases and
defects to Quality Center.
. Involved in VB scripting programming using Quick Test
Professional.
. Tested WebServices using testing standards like validating XML,
WSDL and SoapUI.
. Prepared Test Cases for GUI application. Developed test scripts
for Data driven testing using parameterization in QTP by using Excel
sheet for test data and Database Queries based on the functionality.
. Converted manual test scripts to automated test scripts in Quick
Test Professional, enhanced the scripts by adding user-defined
functions. Automated test scenarios for GUI, Functionality,
Integration, Database, Boundary, Security and Regression Testing
using Quick Test Professional
. Prepared test scripts using Quick Test Professional with
checkpoints using regular expressions for handling windows with
different names.
. Identified bottlenecks/critical issues by executing performance
test scripts using HP Load Runner, attended meetings with business
analysis team, developers and technical architects to discuss about
the bottlenecks.
. Involved in complete QA Life Cycle.
. Participated in RTM/TC's Walkthroughs and defect report meetings
periodically.
. Involved in ETL testing, executed SQL queries to validate the
data in target database and familiarity with fact tables, dimension
tables, star schema and snow flake schema.
. Tested webservices, XML, WSDL using SOAPUI tool. Modified end
points when we worked on different servers and different versions of
Web Services.
. Tested WebServices, providing required input data to request XML
and validated response XML
. Validated WebServcies request and response xml using SOAPUI tool.
. Converted manual test scripts to automated test scripts in Quick
Test Professional, enhanced the scripts by adding user-defined
functions. Automated test scenarios for GUI, Functionality,
Integration, Database, Boundary, Security and Regression Testing
using Quick Test Professional.
. Involved in Data warehouse (DWH) testing while migrating data
from existing legacy system to Siebel and reviewed mapping
documents.
Environment: Microsoft .NET, MS SQL 2008, Quick Test Professional (QTP),
Quality Center, LoadRunner, MS Office, Web Services, SoapUI, XML.
Project#4
Admin
Organization: Intelizign Engineering Services Pvt Ltd
Project: Employee onboarding system
Duration : Aug2009-May2010
Summary:
This project was regarding automation of employee onboarding process for
leading telecom company. This application was aimed towards automating
existing manual process so as to improve efficiency of data gathering,
reduce manual intervention, reduce paperwork and speed up employee joining
process. Responsibility in this project was testing individual modules of
this project and also integration of the modules and end state application.
Role: QA Analyst (Manual Testing)
Responsibilities:
. Developed Test plan & Test cases based on the Functional
specification document using the Mercury Quality Center.
. Actively involved in functional, unit and integration testing.
. Detected Defects, Communicated to the developers using Bug
Reporting Tool and Tracking the Defects using Quality Center.
. Extensively used Quality Center for test planning, bug tracking
and reporting.
. Uploaded Business requirements, test scenarios, test cases and
defects to Quality Center .
. Expertise in QA Testing in distributed Windows Environment.
. Involved in entire QA Life Cycle, which includes Test Designing
and Execution of the entire QA process and documentation of Test
Plans, Test Cases, Test Procedures and Test Scripts.
. Analyzed the specifications in the User Requirements Document,
Functional Specifications and Technical Requirement Documents to
prepare Test plans.
ENVIRONMENT: UNIX, MS Office, TOAD, Windows.
Project#3
Banking
Organization : Intelizign Engineering Services Pvt Ltd
Project Name : Online Banking.
Duration : Jan 2009 to July2009.
Summary :
This project designed for all day to day banking operations of SunTrust
Bank, USA. This project contains various modules like Admin, Banker and
Customer module etc. The retail user can check his account balance, request
for cheque book, demand drafts, banker's cheque, stop cheque payment, issue
standing instructions, request for bank statement etc. The user can also
transfer fund to other accounts at the same branch, transfer fund to any of
the accounts of the specified bank, card to card fund transfer. The user
can request for a particular service, track it and he can customize the
appearance, preferred date format, preferred amount format. The user can
pay bills through his internet banking account etc.
Role : Tester.(Manual Testing)
Responsibilities:
. Generated test cases as per Use cases defined in product requirement
document.
. Actively involved in reviewing test cases.
. Involved in Functional Testing, Re-Testing, Regression Testing and
End-to-End testing.
. Generating Test Log documents and analyzing obtained Test Results.
. Reporting the bugs.
. Executed test cases from QC and logged defects.
. Interacting with development team for bugs closure.
. Verification of fixed bugs and subsequently closing them if they
passed the test case.
. Reporting status of testing progress, issues to team lead on a
weekly basis.
. Periodically obtaining feedback from Team lead and consciously
working for Improvement.
Environment : Toad, SQL server 2005, IE 6.0, IIS 5.0.
Project#2
Logistics
Organization : Intelizign Engineering Services Pvt Ltd
Project Title : Sales Tracker.
Duration : July 2008 to Dec 2008.
Summary :
Sales Tracker is a complete business solution to manage the entire Sales
activities and Inventory of finished goods. Administrator defines and
manages the Master entities. Sales people perform transactions required for
the business. Customer logs in and track his sales order details such as
Confirmed orders, Out of Stock, Shipment pending and Delivered etc, and
also Invoice details such as billed and to be paid etc. Warehouse people
logs in and tracks the Goods to be shipped, Shipping slip generation,
Generate dispatch order and Update inventory etc. Supplier logs in track
the pending inventory orders Confirmed inventory orders and goods to be
shipped etc.
Role : Tester.(Manual Testing)
Responsibilities:
. Generated test cases as per Use cases defined in product requirement
document
. Actively involved in reviewing Test cases.
. Generating Test procedure documents for various tests that are to be
performed.
. Executing Test cases as per the requirement.
. Performed Functional and Regression testing.
. Reporting the bugs.
. Verification of the fixed bugs and subsequently closing them if they
passed the test case,
. Involved in weekly status reporting and official meetings.
. Reporting status of testing progress, issues to team lead on a weekly
basis.
. Periodically obtaining feedback from Team lead and consciously working
for Improvement.
Environment : ASP. Net, Toad, SQL Server 2003, Win2000.
Project #1
Web Services
Organization : Intelizign Engineering Services Pvt Ltd
Project Name : BetRepublic
Duration : Jan 2008 to Jun 2008.
Summary :
Bet Republic is a Social Networking site where users can focuses on
building online communities of people who share interests and/or
activities, or who are interested in exploring the interests and activities
about Online Betting and Games. Here Users can share their views by posting
their scraps in Stadiums, Chalkboard postings, PUB's, Upload Images/ Videos
to his and Teammates accounts.
Role : Tester.(Manual Testing)
Responsibilities:
. Actively involved in reviewing test cases.
. Generated Test procedure document for various tests that are to be
performed.
. Performed Functional and regression testing.
. Generating Test Log documents and analyzing obtained Test Results.
. Reporting bugs.
. Verification of fixed bugs and subsequently closing them if they
passed the test case.
. Reporting status of testing progress, issues to Team Lead on a weekly
basis.
. Periodically obtaining feedback from Team lead and consciously working
for Improvement.
Environment : PHP, My SQL, Windows XP.