Vishal Mongia 469-***-****

accfhd@r.postjobfree.com

Professional Summary

Over 6+ years of professional experience in I.T. industry with experience

in diversified fields of the Software Development Life Cycle and automation

using Interactive Tools (QC, SAHI).

Experienced in system analysis, design, Quality Assurance, and automation

of testing.

Over three years of experience with Agile Scrum Methodology.

Experience in using automated testing tools such as ALM, Quality Center,

Quick Test professional (QTP),Sahi, and Load Runner on applications

developed in Java, VB, C++, Oracle 11i and web based applications, as well

as testing applications manually.

Extensive knowledge and experience in all stages of the Software

Development Life Cycle (SDLC) beginning from requirement specification to

deployment and support.

Specialized in analyzing functional specifications, determining the test

conditions and writing project test plan.

Experience with developing test strategies by reviewing Business and

Technical requirements.

Extensive experience in writing Test Plans, Test Cases and Test Scripts,

Defect Tracking & reporting for Manual and Automated Testing for various

business applications and also with the generation of SQL queries to test

database functionality.

Worked in important phases of Testing Life Cycle like Integration Testing,

Regression Testing, and System Testing, User Acceptance Testing (UAT),

Black Box Testing, Stress/Load Testing, Manual and Regression testing with

automated testing tools.

Excellent knowledge of Oracle & SQL database with SQL for Back end testing

as well as creating and maintaining Test Data in relational databases.

Extensively involved with other teams such as Development team, Business

analysts in sharing requirements and reporting of bugs.

Experienced team player also with ability to work independently and

excellent communication and written skills.

Enthusiastic to learn new skills with a shorter learning curve and possess

strong analytical and problem-solving skills with ability to work under

tight schedule.

Technical Skill Set

Testing Tools:

ALM

SAHI 4.3

JIRA 5.2, Green Hopper for Agile management

Confluence

Contour 3.6.2

Microsoft Sharepoint

Quick Test Professional 9.0, 9.2

Quality center 9.0, 10.0

Load Runner 8.2, 9.0

Scripting Languages: VB Script, JAVA Script

Database: Oracle 9i, SQL Server 7.0/2000/2008, and MS Access

Operating Systems: Windows 95/98/NT/2000/2003/XP, UNIX, MS-DOS, LINUX,

SOLARIS

Programming Languages: C, C++, JAVA, VB, SQL, PL/SQL, HTML

Professional Experience

Homedepot.com, Irving TX

September 2013 - Present

Role: Online Quality Analyst

Description: The Home Depot is the largest improvement retailer in the

U.S., Canada and Mexico. The Home Depot has more than 2,200 convenient

locations throughout the United States (including the territories of Puerto

Rico and the Virgin Islands), Canada, China, and Mexico.

HD Online Application (BOSS Shared SKU project): The BSS project is one of

the most challenging and prestigious project for homedepot.com. The project

is to enhance the homedepot.com current Ship to Store program (also known

as BOSS - Buy Online Ship to Store). This project will enable the pickup of

40,000+ products from store that are currently not assorted for Buy online

Pickup from Store (BOPIS).

Responsibilities:

Reviewed the Business Requirement documents with the business and

development team to understand the architecture and functionality of the

application.

Assisted my team in a smooth transition from Waterfall methodology to Agile

methodology

Participated in all different ceremony's of Agile such as estimation

sessions/planning sessions/daily stand up/retrospective and sprint review.

Validated the Buy Online Ship to Store order workflow including the various

integration checkpoints such as Cybersource fraud check, Sterling

application, B2B application, conversion of the orders using Perl, POMS

application, and triaging any issues in the workflow using in house SPLUNK

application

Managed the offshore QA Team, and the task allocation process. The day to

day tasks included distributing the daily tasks to the offshore team,

taking offshore calls to go over the distributed tasks, validate the tasks

completed by offshore, work with Business team to help resolve any queries

raised by offshore team, validate the defects raised by offshore team and

assign to the Developers

Validate the test data provided by the Test Data Management Team and report

any data discrepancy.

Involved in database testing, and smoke, functional, regression, E2E,

exploratory testing of online application.

Track Analytics for sku search, adding to cart, and placing of the order

Environment: Windows 7, Windows Server 2003, Java, TOAD for SQL Server,

JIRA, Quality Center 10.0, Cybersource, B2B, Sterling, OMS, POMS

JP Morgan Chase, Lewisville TX

June 2013 - September 2013

Role: Technology QA Analyst

Description: J.P. Morgan is a leader in Financial Services, offering

solutions to clients in more than 100 countries with one of the most

comprehensive global product platforms available.

Mortgage Banking (DocData): JP Morgan is currently outsourcing the letter

generation process through a third party vendor after the loan is

conditioned. This project is to insource this letter generation process

after the loan is conditioned for different Making Home Affordable (MHA)

plans. This ongoing project includes conditioning of the loans that matches

the inclusions and exclusions criteria, validating the generated XML, and

validating the Letter generated after the Doc simulation process.

Mortgage Banking (Agent Desktop): Agent Desktop application assists in

implementing the Making Home Affordable (MHA) program. Agent Desktop is now

the core underwriting application used for loan modification products. This

web-based tool determines if a customer qualifies for loan modification

according to the MHA, Chase Modification Programs, and other investor

guidelines.

Responsibilities:

Reviewed the Functional Specification Documentation for various Change

Request as per the changes in the Policies with the Business Analyst team,

Development Team, and UAT Team to understand the changes required for the

existing loan conditioning process and ensuring that the FSD complies with

the Regulations as outlined in the Change Request.

Reviewed the Functional Specification Documentation for the Insourcing of

the Letter generation process along with the Business Analyst team,

Development Team, and UAT Team to identify any gaps

Involved in smoke, functional, UI, regression, and Ad hoc testing of Agent

Desktop application

Responsible for Database testing using SQL queries in SQL Developer

Identified, analyzed, and documented defects utilizing ALM

Conducted Cross-Trainings with offshore team to help them understand the

Change Requests as per the changing Regulations

Managed offshore team task allocation process

Environment: Windows 7, Windows Server 2003, MSP, Linux, Java, ExtJS,

Oracle 11i, SQL Developer, Jboss 5.1, Lender Live, Quality Center 10.0, ALM

Fiserv, Dallas TX

March 2012 - June 2013

Role: QA Analyst

Description: Fiserv is a leading global provider of information management

and electronic commerce systems for the financial services industry. Fiserv

currently has more than 16,000 clients worldwide, including banks, credit

unions and thrifts, billers, mortgage lenders and leasing companies,

brokerage and investment firms and other business clients.

PNC Bank: This project was to enhance Fiserv's Corpoint Order Manager and

add custom functionalities for PNC Bank. Corpoint Order Manager is a web

based solution for enterprise-wide cash inventory management for branches,

vaults, transport providers, and ATMs. Corpoint Order Manager allows PNC

Bank's customers to create orders with Cash Vault's used by PNC, and

validate their credit limit through MemoPost services. Corpoint batch

process allows system to create orders and validate through MemoPost

without the need of manual intervention.

JPMC: This project was to enhance Fiserv's Corpoint Deposit Manager and add

custom functionalities for JPMC. Corpoint Deposit Manager focuses on

facilitating expedited provisional credit to corporate customer accounts -

regardless of the customer's geographic footprint. Corpoint Deposit Manager

provides provisional credit to the customers by validating the deposits

made via bill acceptors or from UI. The Fiserv's custom batch jobs

generates transactions files on a daily basis for the bank that provides

provisional credit to their customers

Walmart - Walmart is Fiserv's first venture into Retail sector. This

project was to re-design Corpoint Order Manager as per Walmart's

requirements. Corpoint Order Manager engine forecasts the cash needed on a

daily basis for their checkout counters, based upon their past 60 days

useage and allows Walmart admin operators to create orders with bank

accordingly.

Responsibilities:

Reviewed the Business Requirement documents with the Business Analyst team

and Professional Services Team to understand the enhancements required for

existing products - Corpoint Order Manager, and Deposit Manager.

Participated in the brain storming sessions with Business Analyst team and

Product Manager to understand the use cases and develop test scenarios.

Participated in all different ceremony's of Agile methodology like

estimation sessions/planning sessions/daily stand up/retrospective and

sprint review.

Assisted Business Analyst team in Story Slicing and creating User Stories

Tested various batch processes on Windows and Linux servers, and verified

the data consistency by checking the log files for any exceptions and by

executing SQL queries.

Created detailed test cases as per the Requirements and maintained the

Traceability Matrix between Feature, Stories, Test Cases, and Bugs in

Contour. Created defect summary reports for each cycle of testing.

Managed individual test cycles and worked with analysts and developers

offshore and onsite to resolve the reported bugs.

Automated the manual test cases during every Sprint using the existing

framework in Sahi.

Worked with offshore QA Team for knowledge transfer of various batch

process and the Corpoint Order workflow.

Involved in Functional Testing, Integration Testing, Regression Testing and

End-to-End testing of the application.

Tested the application compatibility in the Versions of Internet Explorer,

Google Chrome, and Fire fox browsers.

Environment: Windows XP, Windows Server 2003, Red Hat Linux, Java, ExtJS,

SQL Server 2008, Jboss 5.1, IIS7, IBM HTTP Server 7

Parker.com website, Parker Hannifin Corporation, USA

May 2010 - Feb 2012

Role: QA Tester

Description: Parker Hannifin is the world's leading diversified

manufacturer of motion and control technologies and systems, providing

precision-engineered solutions for a wide variety of commercial, mobile,

industrial and aerospace markets.

The company's products are vital to virtually everything that moves or

requires control, including the manufacture and processing of raw

materials, durable goods, infrastructure development and all forms of

transport.

This project was to build the global website of Parker Hannifin using the

vignette content management system, Vignette portal and Vignette Dynamic

Portal module. The content management application allows the parker

employees and distributors across the globe to create and manage content

for their website. The website displays information about the various

divisions, products, technologies, distributors etc in 15 languages. The

website also integrates and displays over 25000 product catalogs in 15

languages along with over 800K parts that are sold by parker. The

management application also allows creation of product literature in 17

languages which are made available to the users via the website. The

website also allows online shopping of product literature, training

material etc.

Responsibilities:

Reviewed the Business Requirement documents with the business and

development team to understand the architecture and functionality of the

application.

Participated and Initiated Team meetings on a regular basis and involved in

active discussion in order to improve the testing quality by better

strategies and testing approach.

Managed individual test cycles reported bugs and worked with analysts and

developers to resolve problems.

Involved in the development of test plan and test strategy; performed

functional and structural analysis for the same.

Wrote and executed test cases based on the requirements.

Performed End-to-End testing of full functionality.

Experienced in using Quality Center as a defect tracking tool.

Involved in Component Testing, Functional Testing, Integration Testing and

Regression Testing.

Performed Regression Testing manually for every new build.

Involved in testing the database (backend Testing) using SQL statements

Participated in the team meetings to discuss the issues arising out of

testing.

Environment: HPQC 9.0/10.0, Windows 2003, SQL Server 2000, Vignette Content

Management, Vignette Portal, Vignette Dynamic Portal Module, BEA Weblogic,

Java, JSP.

Amica Insurance, RI

October 2009 - April 2010

Role: QA Analyst

Description: The Application for the Amica Insurance Company deals with the

day-to-day transactions of policies such as renewing the policy, start a

new policy or terminate an existing policy. The application gives lot of

flexibility to the insurer to access the whole details and transactions of

his policy online. Also, the customers can claim their insurance from the

different sectors, like Automobile Insurance, Home Insurance and Life

Insurance. Customer can claim online and they can change or edit their

claim online. The application consists of many details like Insured

information, General loss information and Basic information.

Responsibilities:

Evaluated Business and Systems Requirement documents.

Built and produced test-plans and test cases in accordance with the

business requirements.

Involved in testing the new functionalities based on test cases and

coordinated with development

team in fixing the issues.

Used Quality center to maintain the requirements, test plans, and execute

tests, defect tracking and generating reports.

Performed Regression testing for every modification in the application and

new builds.

Involved in extracting client side and server side exception logs during

AUT(app under testing// full form to be deleted. Only to remember.) using

UNIX command on Linux and Solaris operating systems.

Used SQL queries to perform data integrity and backend testing.

Categorized defects based on the severity and interacted with developers to

resolve them.

Prepared test status reports and actively participated in Defect Review

meetings to remain supportive, involved & aware of progress on the

resolution of the issue.

Environment: HPQC 9.0 / 10.0, SQL Server2000, Linux/UNIX, Java, Oracle

9i

CITIZENS BANK, CT

June 2008 - September 2009

Role: QA Analyst

Description: Citizens bank offers wide array of financial products and

services. The website allows customers to access only their account

information. In case of joint customers, the customers can see the joint

account and their personal accounts. Also, the customer can transfer funds

between their accounts and to a third party and pay bills via the Internet,

by phone or wireless devices. I was Involved in co-ordination of testing

effort for the web application which includes development of test

scenarios, determination of test conditions, documenting test scripts,

setting up of the test data, execution of the test scenarios and scripts

and review of product functionality. The application is developed using

HTML and Java as the front-end and Oracle as the back-end.

Responsibilities:

Analyzed Business requirements and Functional requirements.

Prepared Test Plan based on technical specifications and business

requirements.

Involved in manual and automated testing of application.

Performed Regression testing for every modification in the application &

new builds using QTP.

Conducted Data Driven Testing using QTP.

Used SQL queries to perform data integrity and backend testing

Used Quality center to maintain the requirements, test plans, and execute

tests, defect tracking and generating reports.

Categorized defects based on the severity and interacted with developers to

resolve them.

Prepared test status reports and actively participated in Defect Review

meetings to remain supportive, involved & aware of progress on the

resolution of the issue.

Environment: Java, HTML, Oracle, SQL, Unix, Windows NT, QTP 9.2, and

Quality Center 10.0, SQL Server2000

COMTEK INTERNATIONAL, IL

Performance Appraisal App

October 2007- May 2008

Role: QA Engineer

Description: Performance Appraisal application keeps track of each and

every employee's performance. Performance appraisal is the periodical,

formal evaluation of employee performance. This application minimizes the

hassles of manual, paper-based performance reviews. This application has

parameters like calls that were successfully completed by employees, number

of escalated calls, number of appreciations, internal audit scores of the

individual and many other things.

Responsibilities:

Developed Load Runner scripts to accurately emulate typical customer

transactions, so that tests provide a realistic preview of system

performance.

Interacted with the development team to understand some functionalities of

the application.

Tested Web Application in the QA environment using LoadRunner.

Recoded user actions and created Test Scripts to emulate the real user,

using LoadRunner's VuGen utility.

Created and scheduled Endurance, Load and Stress test Scenarios using

LoadRunners Controller to test the application under all kinds of loads.

Created, scheduled and ran the Scenarios using LoadRunners Controller to

generate the necessary graphs.

Merged necessary graphs and analyzed to find out the bottlenecks.

Called meetings to discuss the findings in the executed tests and decide

the next steps.

Clearly documented all the testing work.

Environment: QTP 9.2, Quality Center 9.0, Load Runner 9.0, Java, SQL

Server2000, Windows 2000, Visual Basic

Education

BSC Computer Application, Kurukshetra University, India

Maters in Information Technology, Manipal Academy of Higher Education,India

[pic]

Contact this candidate