Lombard, IL *****
Cell: 630-***-****
Home: 630-***-****
Email: ablqrm@r.postjobfree.com
LinkedIn: http://www.linkedin.com/in/ranigupta1
SSN: xxx.xx.1486
Summary
Experienced as QA Analyst Lead and BA positions.
•
Excellent communicator with external customers, vendors, subject matter experts, quality
•
assurance teams.
• Proven track record of delivering all project deliverables on time and under budget.
Excellent knowledge in Software Development Life Cycle (SDLC).
•
Expert in Mercury Quality Center and QTP.
•
Excellent understanding of web technologies.
•
Strong in the Financial industry.
•
Solid understanding of JAD and AGILE methodologies
•
Experienced in writing requirements as related to business processes.
•
Excellent logical skills for understanding and developing system workflows and verifying
•
Software Metrics and well suited for communicating with both technical and non technical
professionals.
Strong in developing test strategies, test plans, test scripts, test cases, test data, test
•
checklist, defect tracking & reporting.
• Technical skills with proficiency in data analysis and process analysis
Experienced in change controls and change requests.
•
Strong skills in Back end testing using SQL Queries on Oracle tables and MS SQL
•
Server.
Expertise in software management tools such as Quality Center for Requirements
•
creation, Test Sets, and Reports.
Good understanding of Relational Database Management Systems.
•
Extensive experience testing of client/server and database applications which are
•
developed in .NET, C++, Java, AS/400, Visual Basic, COM, ORACLE 8i/9i, UNIX and
Windows NT/2000/XP.
Experienced in testing Client/Server, Web based and stand alone applications.
•
Strong functional knowledge in E Commerce, Global Marketing, Banking, Telecom,
•
Insurance, and Health care industries.
Excellent communication skills with the flexibility of working both individually and as a
•
team member and also a quick learner.
Education
BBA in Management of Information Systems, Ohio University, Athens, OH, June 2000
Technical Skills
Defect Reporting Tools: ClearQuest and Quality Center
Scripting Languages: VB Script
Languages: .NET, C, COBOL, SQL, PL/SQL, HTML, XML, VB Script, Java, and TSL
Databases: Oracle, MS SQL Server, DB2 and MS Access
Operating Systems: Windows NT/98/2000/XP, UNIX, OS/400, DOS
Automated Testing Tools: WinRunner, QuickTest Professional, LoadRunner, Rational
Robot, ClearCase
Harris Bank, Buffalo Grove, IL
QA Analyst
August 10 to Present
Harris Bank just acquired Amcore Bank and this project involves testing the conversion of
customers from Amcore’s legacy system. This is a short term project that required QA testing of
8 different applications including Mainframe.
• Trained on all of Harris’s bank products including: Various kinds of Checking, Savings,
Money Market, Loans, CDs, Mortages, etc.
• Tested in various applications including client facing, internal, web based as well as
mainframe applications.
• Reported and Tracked defects
• Executed test scripts
Whitman-Hart, Chicago, IL
QA Analyst
June 10-July 10
Whitman Hart is an interactive agency that develops websites and online marketing for large
companies. This was a short term project that involved testing SC Johnson and Harley Davidson
websites. The applications tested were: SC Johnson Carbon Calculator and the Harley Davidson
website.
• Executed test scripts
• Tracked defects
• Cross browser testing in FF, IE, Chrome, and Safari.
The Trizetto Group, Inc., Naperville, IL
BA/QA Analyst
June 09 – March 10
Trizetto Group is a publicly owned company that offers Integrated Management Solutions for
Health Care. Primary duty was quality assurance and testing a new product called Incentive
Manager which is part of the a award winning Value Based Benefits project as recoginized
internally. The goal is to allow payers and members to manage programs designed to provide
incentives for preventative health care. Developed and executed test cases to validate quality
level of software under development.
Worked closely with Product Design and Software Engineering teams as
•
functional/design specifications are designed and developed.
Worked in a .NET framework environment
•
Involved at some level throughout the entire system or software enhancement
•
development life cycle, designing initial testing requirements, writing, communicating and
verifying test execution.
Executed and reported on planned tests, report and manage defects, and regress
•
software fixes for new and existing builds.
Entered requirements, test cases, and test executions in Mercury Quality Center and did
•
defect tracking in Serena Business Mashups.
Conducted test case walk throughs with the designer, programmer, and team leads.
•
Used Aqua to edit the Oracle database.
•
Managed multiple testing tasks across maintenance releases and systems under
•
development.
Analyzed system impact during design reviews and product integration, and troubleshoot
•
test failures.
Communicated product testing knowledge across development and QA teams.
•
Pulled together test cases in support of business cases (use cases), design documents
•
and systems requirements.
Documented and tracked defects and fixes and ensure fixes do not adversely impact
•
existing functionality. Provide status reports to QA Manager and Lead.
JPMorgan Chase & Co., Chicago, IL
Business Analyst
June 08 – February 09
Treasury Services: Responsible for user acceptance test scripts for several applications,
primarily DIMS (Document Information Management System). This project consists of integrating
iVault, and Global Docs with DIMS. It is a component of the TSS Global Client Documentation
Repository/Management Program whose goals are to reduce operational, regulatory, reputation
and legal risk, improve the client experience, and gain operational efficiencies by improving the
client on boarding documentation processes. In addition to DIMS, also tested TS Deal Manager.
Responsible for writing use cases and assisted with funtional requirements gathering.
•
Primarily Responsible for writing user acceptance test scripts
•
Responsible for extensive requirements analysis, change controls, and estimation.
•
Conducted meetings with subject matter experts, project managers and QA teams.
•
Involved in all phases of the software development life cycle.
•
Responsible for managing user acceptance testing, defect tracking, meetings with UAT
•
Leads, reporting, QA cross referencing (also checks and balances).
Used Mercury Quality Center to enter requirements, create test execution grids, run
•
manual tests, generate Test Plan reports, Test Results Reports, in addition to extensive
defect ticket creation and defect analysis in Quality Center.
Responsible for creating Critical Business Functions, Kick off presentation, Test Data
•
Criteria, and Test Data creation.
Responsible for training business users and incoming team members.
•
Managed user roles and entitlements.
•
U.S. Cellular®, Chicago, IL
Business Analyst
April 08 – June 08
Online Photo Album: U.S. Cellular® has developed a replacement Online Photo Album for
customers consisting of various enhancements and top of the line technology to facilitate
customer experience. The purpose of the new project is to replace the existing service with a new
online album and legacy service.
The project scope has been identified as: 1. Provide a service to allow Multimedia Service (MMS)
customers the ability to save and share photos and blogs. 3. Provide the ability for non MMS
customers to view photos online (legacy service). 4. Migrate customer data from the current
vendor (QPass) to Newbay at implementation
Responsibilities included: converting Online Album Business Requirements into User
•
Acceptance Test Scenarios.
Managed Vendors offshore.
•
Setting up Test Environment and configuring handset equipment for testing.
•
Creation of UAT Requirements Traceability Matrix.
•
Creation of Business Process Test Flow diagram.
•
Assisted with UAT planning, execution, and testing.
•
Conducted several team meetings, reviews, and walk throughs with vendors, business
•
(marketing and customer service) and technical teams.
Tested migration of customer accounts into test environment.
•
Handled change requests for business requirements.
•
McDonald’s Corporate Headquarters, Oak Brook, IL
BA/QA Analyst
Mar 07 - Mar 08
Global IT Marketing: Solely responsible for on site testing of promotional children’s games: Flash
based Web applications including the Digital Engagement Platform: Shrek, Shrek III, Surf’s Up,
Bee Movie, Happy Meal, Happy Set, and Happy Meal Australia.
Solely responsible for on site testing of the applications in several languages including:
•
French, German, Spanish, Portuguese, Japanese, Chinese, International English, and
Italian.
Additionally, tested Happymeal.com, Happyset.com (Japanese) and Happy Meal
•
Australia for every new Happy Meal toys promotion. (Developed by creative agencies and
DreamWorks Animations).
Involved in communications with various vendors.
•
Developed 2007 and 2008 Test Strategy presentations via PowerPoint and presented
•
them to senior management.
Developed 2007 and 2008 Test Plans for the Digital Engagement Platform, for Happy
•
Meal, and all localizations.
Integrated the Digital Engagement Platform and Happy Meal in to McDonald’s on site
•
web servers.
Developed business requirements for Voice of McDonald’s II.
•
Responsible for system integration testing, load testing, functional testing, and regression
•
testing.
Created reports and extensively communicated with senior management and creative
•
agencies on a daily basis.
Assisted in deployment of applications from development, staging and production
•
servers.
Used Mercury Quality Center to enter requirements, create test execution grids, run
•
manual tests, generate Test Plan reports, Test Results Reports, in addition to extensive
defect ticket creation and defect analysis in Quality Center.
Used HTTP Watch to generate data on load times. Extensively analyzed trends from
•
HTTP Watch.
Generated daily Akamai Site Accelerator Diagnostics Reports which included daily
•
statistics on hits per second, No. of Visitors, Top URLs, and Server Health. Analyzed
trends in data on daily load times and trends in each category of Site Accelerator
Diagnostics.
Managed defects in Mantis, a free web based bug tracking system.
•
Kaiser Permanente, Los Angeles, CA
QA/Business Analyst
Nov 05 - Mar 07
Health Connect Working at KP Health Connect User/Security Provisioning Project as a senior
tester. Security Provisioning provides the ability to search the enterprise directory for any person
within KP and provisions to create, modify, deactivate and delete Epic accounts of KP users on
demand. Wrote test cases using functional specifications and by collecting the requirements thru
meetings with developers.
• Executed test cases for system testing, integration testing and regression testing.
• Used Quality Center for writing/executing test cases and reporting defects.
• Conducted meetings with developers & business persons for reviewing the developed
test cases.
• Trained & assisted new test leads on the project.
• Worked on the Admin tool, to looks up for AD users.
• Coordinated with the automation team in an effort to automate the basic regression test
cases and explained them the test scenarios.
Conducted cross training sessions with team members in order to achieve expertise to all
•
testers in all areas of execution.
Kaiser Permanente, Los Angeles, CA
QA/Business Analyst
May 05 - Oct 05
Health Connect KP Health connect Project is to connect 8 regions across the country with a
single Health care system integrating patients' clinical medical records with appointment
scheduling, registration and billing systems. Physicians, nurses and other health care
professionals who are involved in members' care will be able to access accurate, complete and
up to date medical information. Patients will also be able to access portions of their medical
records online, such as test results, immunization history and current medications.
• Responsible for gathering requirements, developing test cases, and conducting QA
meetings.
• Responsible for functional testing of Order Scheduling for Inpatient system in Epic.
• Responsible for functional testing of Outpatient system in Epic.
• Responsible for designing test plan, test cases and executing them manually as well as in
quality center.
• Conducted regression testing using QTP
PNC Financial Services Group Inc., Cincinnati, OH
QA Analyst
May 04 - Feb 05
PNC Bank is one of the largest diversified financial service organizations in the US. Its major
businesses include Regional Community Banking, Corporate Banking, Private Banking, Mortgage
Banking, Secured Lending, Asset Management and Mutual Fund Servicing. The company has
developed new software, PINACLE, for information reporting with many salient features for the
operations of Treasury Management.
Analyzed the Business Requirements Document (BRD) and modified the existing test
•
plan and prepared detailed test cases for the application under test (AUT).
Executed test cases manually and also using automation tool and reported the defects to
•
developers through Defect Manager in TestDirector.
Performed manual testing of the AUT.
•
Participated actively in the team meetings with the developers for defect reviews.
•
Progressive Insurance Company, Cleveland, OH
QA Analyst
Sep 03 - Mar 04
Sun Trust is offering different services to its customers in investment banking, financial services
(for consumers and businesses), financial transaction processing, asset and wealth management
and private equity. Sun Trust agent provides customer and account information to the customers.
The system gives the information about money transfers, loan approvals, generating the end of
the day transactions and preparing month ends balance sheet. It executes on a three tier client
server environment.
Involved in development of test cases for Web Application
•
Automated test scripts using WinRunner 7.5.
•
Created Test Plans, Test Cases and Test Scripts for some of the modules of the
•
application under test (AUT)
Involved in various levels of testing like Functionality, Integration Testing
•
Analyzed user Requirements, General Design, Detail Design documents
•
Performed Cross Browser Testing on Netscape & Internet Explorer and compared the
•
results by running parallel tests
CIGNA Health Care, Easton, PA
QA Tester
Feb 03 - Aug 03
CIGNA is a leading provider of health care coverage, group life and accident insurance through
their web site www.cigna.com supported by the web applications mycigna.com. MyCIGNA.com is
a one stop web based application, which provides access to user ýs personalized health care
information. Users can manage their accounts, check their claims, and search for hospitals,
physicians to get personalized information.
Developed test plans, test cases, test conditions, test designs and test reports using Test
•
Director.
Responsible for executing and tracking test cases for web based applications for CIGNA.
•
Responsible for functional and regression testing using Win Runner.
•
Responsible to Create detailed problem reports in defect tracking database of Test
•
Director.
Experienced in completing assigned tasks according to requirements in Test Director
•
within project timeframes.
Good in Co operating with a cross functional team to set and verify requirements and
•
design.
Conducted system, UAT and regression testing, debugged the software errors, and
•
interacted with developers to resolve technical issues.
Sun Trust bank, Atlanta, GA.
QA Tester
Jun 02 - Dec 02
Sun Trust is offering different services to its customers in investment banking, financial services
(for consumers and businesses), financial transaction processing, asset and wealth management
and private equity. Sun Trust agent provides customer and account information to the customers.
The system gives the information about money transfers, loan approvals, generating the end of
the day transactions and preparing month ends balance sheet. It executes on a three tier client
server environment.
• Involved in development of test cases for Web Application
• Created Test Plans, Test Cases and Test Scripts for some of the modules of the
application under test (AUT)
• Involved in various levels of testing like Functionality, Integration Testing
• Analyzed user Requirements, General Design, Detail Design documents
• Performed Cross Browser Testing on Netscape & Internet Explorer and compared the
results by running parallel tests
The Revere Group, Chicago, IL
Technology Consultant
Jun 00 - Jun 02
The Revere Group is a consulting firm and leading provider of business solutions, servicing
industries such as Healthcare, Insurance, Manufacturing, and Financial Services. The Revere
Group has grown to over 250 consultants, with offices in four cities: Chicago, Milwaukee,
Charlotte, and Boston. From client server, to ERP, to e business and beyond, the company has
evolved to meet the changing needs of its clients.
Lead developer and project manager for a full life cycle Siebel implementation for dot
•
com client.
Developed a customized customer care solution with Siebel eBusiness software for an E
•
Commerce dot com called Full Audio.
Responsible for gathering requirements, developing test cases, and conducting meetings.
•
Responsible for front end user interface design and development, administrator tasks,
•
configuration, installation, user training, and knowledge transfer.
Created Test Plans, Test cases, and Test scripts for some of the modules of the AUT.
•
Lead developer for a Vantive and Crystal Reports implementation for market research
•
corporation
Was responsible for a developing a largely customized data validation reporting system
•
using
Vantive software and VB scripting.
•