ARUN K. GUPTA

**** ********** *****

Cumming, GA, 30040

Res. 678-***-**** Cell 678-***-****

Email: acqxni@r.postjobfree.com

OBJECTIVE:

A Lead or Senior UAT / Quality Assurance Analyst position leading to management responsibilities.

SUMMARY:

Over 12 years experience in software testing in client/server and web based environments in all phases of the testing life cycle.

Over 3 years experience in a Lead QA Analyst position.

Experienced in review of Business Use Cases, performing business requirements analysis, preparation/execution of Test Strategies, Test Plans, Test Scripts, Test scenarios.

Expertise and experience in performing different kinds of testing like Blackbox, Unit, Functional, GUI, XML, Database and Regression Testing, HBX Tag testing and Web Services Testing using SOAP UI, JSON and REST Client. Experience in HP Quality Center, Rational ClearQuest, SharePoint 2010. Jack Track, WebTrax, Remedy and JIRA.

Functional and Regression Testing of the APIs Using SOAP UI and REST Client Services.

Experience in Automating test cases using QTP Pro and Test Complete 9.

Ability to execute test plans, test cases and automated test scripts in different test environments like QA, UAT, ETE and Systems Integration. Record results and test matrix and ensure quality products released to production.

Proficient in UNIX based testing and in UNIX commands and scripts.

M2M testing and Multi Browser Testing – Chrome, IE 8, 9, 10 and 11, Firefox, Safari.

Experienced in Waterfall, Agile and SCRUM methodology.

Interaction with Business Users, Development team, application support team as and when required in updating QA test environment, analyzing defects and follow up testing.

Strong domain knowledge in Wireless Telecom, Mobile Apps, Financial and Retail.

Expertise in OOPS, RDBMS, SQL Queries - PL/SQL, T-SQL, iSQL, SOAP UI.

Experience in testing JAVA, J2EE, VB.net, C & C++ & Mobile applications.

Excellent Planning, Analytical, Problem Solving, Communication and Interpersonal skills.

Self-starter and ability to adapt and learn new things quickly.

TECHNICAL SKILLS:

Testing Tools: WinRunner 7.5, Test Director 8.0, HP Quality Center 10.0, QTP 10.0,

Test Complete 9.0, SOAP UI

Reporting Tools: HP Quality Center 10.0, Rational ClearQuest, JIRA, QA Complete

Scripting Languages: TSL, SQA Basic Language, VB Script

Languages: P/LSQL, V-SQL, iSQL, JAVA, J2EEVB.Net, C++, C, HTML, TSL, PHP

PERL & Korn Shell Scripts, UNIX Commands

Data Bases: Oracle 9i/10g/11g, MS-Access, MySQL, Sybase 12.5, SQL Server 2012,

Vertica DB, TOAD, Wedat, Benthic Golden32, Squirrel SQL Client

Operating Systems: Windows XP, 2000, NT, Windows 7, UNIX, Linux, AS400

GUI: Visual Basic, C++, JavaScript, J2EE, HTML, Citrix clients

Misc. Tools: MS Office, FrontPage, MS SQL Server, Visio, Notepad, SOAP UI, REST Client, VersionOne, PuTTY, Git Bash, Jenkins.

WORK EXPERIENCE:

Sr. QA Analyst Manheim Corp.

April 2015 – Present Atlanta, GA

Operational Data Store / Business Event Engine Manheim is in the process of converting it’s Auto Auction DB2 Data Base to Oracle 11g. The

project consists of 2 parts – developing and testing various APIs (Pre Sale and Post Sale) for it’s Auto customers and developing and testing SQL scripts for Data Base conversion and clean up.

Environment:

Windows 7, AS400, Oracle 11g, Squirrel SQL client, SQL Developer, Informatica, XML,

SOAP UI and REST Client Services

Responsibilities:

Developed test plans and test cases for testing APIs and Data Scripts.

Performed Functional and Regression Testing of the APIs using SOAP UI and REST Client.

Wrote SQL queries to validate Data Scripts and Data Base tables.

Created Auction transactions in AS400 servers and validated them in the Data Base

Performed Pre Deployment and Post Deployment validation of Data Base scripts and APIs.

Senior SQA Analyst Bridge2Solutions Inc. March 2014 – April 2015 Alpharetta, GA

Bridge2Rewards Application

Bridge2Solutions Inc. administers and manages the rewards programs for a number of major corporations. It has a rewards redemption application tailored for each of it’s major clients. The customization is managed by an application called Sys Admin. The customized rewards application is connected to a Product Services Data Base and a Pricing Service application. The Product Service Data Base has information on hundreds of thousands of products from many suppliers – Walmart, Best Buy, Sears etc. The Pricing Service application, prices the products based on the Country, State and local taxes and the shipping costs. All these interconnecting systems have their own data bases.

Environment:

Windows 7 Enterprise, JAVA/J2EE, SQL Server 2012 Data Base, QA Complete, JIRA, Jenkins,

SOAP UI, JSON, REST Client and Agile / Scrum Methodology.

Responsibilities:

Developed test plans and test cases for manual testing of the B2R (bridge2rewards) application, using QA Complete as the test repository.

Performed Functional Testing, Systems Integration Testing, Regression Testing and Smoke testing of the application and it’s associated systems and the databases.

Write simple SQL queries for data base validation and use SOAP UI and REST Client request to validate the data in the associated systems.

Used JIRA for documentation and entering defects.

Deployed new builds into QA and UAT environments using Jenkins,

Performed Functional and Regression Testing of APIs using SOAP UI and REST Client.

SQA Engineer Landis+Gyr Inc. July, 2013 – Feb 2014 Alpharetta, GA

Tokyo Electric and Power Company (TEPCO)

Command Center is a complex application that an Electric Utility uses to monitor all the electric meters in use by it’s customers .The CC application can turn on / off the meters, get instant readings from the meters and generate various reports about electric usage by a customer. It can also get information from Gas and Water meters, via the Electric meter. The Command Center communicates with the meters via the internet and Radio Frequency. The TEPCO project is the biggest GridStream RF project in the world with about 27 million customers.

Environment:

OS- Windows XP, IE 9.0, UNIX, JAVA/ASP.net, Oracle 11g, Team Foundation Server, Visual Management Studio, SQL Server 2008, 2012, SQL Developer, Test Manager, SOAP UI, SharePoint 2010, M2M testing with PuTTY, Agile / Scrum Methodology.

Responsibilities:

Wrote test cases in Test Manager, for testing the Command Center application.

Used Visual Studio and Test Manager for documenting and executing test cases.

Set up the hardware and M2M testing environments. Installed new builds and software.

Performed Functional Testing, Regression Testing and Data Base Validation.

Used Visual Studio and Test Manager for entering and tracking defects.

Used SOAP UI for Web Services testing.

Wrote simple SQL queries for Data Base verification in both SQL server and Oracle environments, using SQL Server and SQL Developer.

Performed some M2M testing of the Radio boards used in the electric meters, using PuTTY and USB to Serial port cables.

Senior Test Engineer Lancope Inc. June, 2012 – April, 2013 Alpharetta, GA

StealthWatch Management Console (SMC)

StealthWatch is a proprietary Web Security application that corporations use to monitor the traffic on their network for potential cyber attacks and misuse of their computer network. SMC is a graphical user interface that displays traffic observed by StealthWatch, to and from every client/server on the network. It raises alarms of suspicious traffic and displays graphical and tabular statistical data of the traffic on the network. SMC also sends alerts of hosts that have been disconnected or shut down, or are being compromised by other hosts.

Environment:

Windows 7, UNIX, JAVA/J2EE, XML, JIRA, SQL, IE8.0, Mozila Firefox, Test Complete 9.0, Vertica DB and vSQL, VersionOne, Agile / Scrum Methodology.

Responsibilities:

Developed and automated test cases using Test Complete 9.0, for testing the SMC.

Performed Functional Testing, Unit Testing, Automated Testing and Regression Testing.

Used VersionOne for documenting and executing test cases

Used JIRA for defect tracking and for generating issue reports.

Used PuTTY to monitor Client/Server operations and to look at logs and XML files.

Wrote simple SQL queries for Data Base verification.

UAT Lead Verizon Wireless Inc.

Apr 2011 to Feb 2012 Alpharetta, GA

Internet Sales & Operations Applications

The ISO team is responsible for the final testing and approval of enhancements to applications before going into production. The UAT lead is responsible for the testing of the functionality and system integration of various applications and makes the decision to either permit the deployment to production or to further enhance or test the application. I was responsible for the My Verizon, My Business and the Mobile Store applications. Types of changes and enhancements made to these applications include new devices, price plan changes and bundling of services, limited time promotions. Was responsible for testing various smart phones on different platforms – Android, Iphones, Blackberry and other devices. The UAT lead also manages the post implementation of the applications and sets up a command center for a few days following the deployment to production.

Environment:

Windows XP, Oracle 10g, Dot.Net, JAVA/J2EE, C++, SQL, VDRT, HP Quality Center, AS400,

UNIX Servers, HTML ACSS, WFM, Vision, Windows XP, IE 8.0

Responsibilities:

Develop testing strategy, test plan and test cases based on the requirements documents and testing time line of the Point of Sale and Provisioning applications.

Execute test cases and document defects for the Point of Sale, Provisioning applications.

Testing of various smart phones – Iphones, Blackberry and phones with the Android OS.

Run SQL queries and/or use the VDRT to retrieve testing data from the Billing data base.

Perform backend data validation of the billing database (Vision) using ACSS, a front end GUI interface of the Vision (Billing) database.

Coordinate meetings to get the various teams together to resolve high priority issues.

Set up and manage the command center for a few days following deployment.

Prepare reports of the testing effort for upper management.

Sr. QA Analyst Lexis Nexis Inc.

Sep. 2010 – March, 2011 Alpharetta, GA

eCrash & CRU eCrash is a keying application that Lexis Nexis developed to enter information about vehicle accident reports they obtain from the various law enforcement agencies through out the nation. There is a separate keying application form for each state. CRU (Claims Record Unit) is a GUI based application that receives a request for an accident report from an insurance company and then checks the master database for the accident report. If the report exists, it retrieves it and sends it to the insurance company via – email, fax or regular mail.

Environment:

Windows XP, Linux Servers, PHP (Hypertext Preprocessor), Zend Framework

(MVC architecture), Web Services, XML, MySQL DB, TOAD, HP Quality Center.

Responsibilities:

Developed test plans and test cases for manual testing of eCrash & CRU applications in HP Quality Center 10.0.

Performed Functional and Regression Testing of the applications.

Used HP Quality Center 10.0 (Test Director) for documentation and Bugzilla for defect tracking and for generating defect reports.

Communicate with developers, business analysts, and product manager to clarify design issues and requirements

Write simple SQL queries for Data Base verification in MySQL DB.

Lead QA Analyst (Employee Position) Global Payments Inc.

Jan 2008 – July 2010 Sandy Springs, GA

Customer Master File (CMF Project)

CMF is a new master data base that Global Payments is developing to merge it’s three market segments into one repository. Global Payments processes credit card and debit card transactions for the small to medium size customers. CMF will contain information of all the company’s customers and all the Point of Sale terminals the merchants use for credit card and debit cards.

Environment:

Windows XP, Oracle 10G, SQL Server, UNIX, XML, BizTalk & .DotNet, JAVA/J2EE, TOAD, SQL,

HP Quality Center 10.0, QTP 10.0, CaliberRM 6.0

Responsibilities:

Developed test plans and test cases for manual and automation testing of CMF using QTP 10.0 in HP Quality Center 10.0.

Performed Unit Testing, Functional Testing, Systems Integration Testing, Regression and Web Services Testing of the application.

Web Services Testing using XML.

Used QTP 10.0 for creating automation test scripts.

Used HP Quality Center 10.0 (Test Director) for documentation, defect tracking and for generating defect reports.

Communicate with developers, business analysts, and product manager to clarify design issues and requirements

Sr. SI Analyst T-Mobile.

Nov 2007 - Jan 2008

E2E & SI of Retail Systems

E2E Retail Systems Project – T-Mobile has a number of retail outlets – T Mobile stores, indirect retailers like Best Buy, Partners like WalMart, Telesales via phone and Internet store. Each of these outlets use their own retail application. The Retail applications are CSM, TMO, MyTMO, HSO, POS and TOM. Different applications have different levels of functionality, depending on the type of retailer and type of services. SI Testing involves the verification of data accessibility by the various retail applications, when a customer opens a new account or makes changes to an existing account. E2E testing involves the creation of new accounts with different price and data plans, sale and shipment of all the equipment purchased by the customer, activation of the handsets, ability to make and receive calls, SMS and text messages and validation of the billing database (Samson).

Environment:

Windows XP, UNIX, JAVA, JAVA Scripts, C++, Oracle 10g DB, MySQL DB, TOAD, SQL, XML, SOAP UI, HP Quality Center 10.0

Responsibilities:

Developed test plans and test cases for testing the various Retail and Provisioning applications, in HP Quality Center 10.0.

Performed E2E, Systems Integration and Web Services Testing of the various Retail and Provisioning applications.

Web Services Testing using SOAP UI.

Execute test cases and document defects for the Point of Sale and Mobile applications.

Testing of various smart phones – Iphones, Blackberry and phones with the Android OS.

Performed Live testing of the various features of the Mobile devices.

Used HP Quality Center 10.0 for creating and executing test cases, for defect tracking and for generating reports.

Write simple SQL queries for Billing Data Base (Samson) validation, in Oracle 10g DB and MySQL DB.

Senior QA Analyst AutoTrader.com

Feb 2007 – Oct 2007 Alpharetta, GA

Sell Your Car (SYC application)

Autotrader.Com is a web site consisting of different applications. People can buy a car or sell their car, can research and compare various vehicles and can shop around for car insurance and auto loans. The application Sell Your Car allows a person to advertise his/her car for sale on the site. The customer has a choice of purchasing from many advertising packages. Once a package is chosen, the customer enters his/her car details and can download photographs of the car for prospective buyers to see.

Environment:

OS- Windows NT, Oracle 10g, UNIX (Sun Solaris), JAVA/J2EE, PL/SQL, TOAD

Responsibilities:

Developed test plans and test cases for manual testing of the SYC application.

Performed Systems Integration Testing, Functional Testing, Unit Testing and Regression Testing.

Used HP Quality Center 9.2 (Test Director) for documentation, and defect tracking.

Communicate with developers, business analysts, DBAs, and project managers to clarify design issues and requirements.

Write simple SQL queries for Data Base verification.

Senior QA Analyst / Production Support Analyst (Employee Position) AT&T Wireless

July 2003 to Jan 2007 Alpharetta, GA

Cingular Wireless Project: QuickPay / Bobsled

QuickPay system handles all credit card payments made by customers to pay their monthly bills and / or deposit payments when opening new accounts. AutoPay is the system that handles all automatic bank draft payments using their checking or savings account. Bobsled is a retail application that processes orders taken by BellSouth reps for new Cingular Wireless customers. Bobsled processes orders from address validation, migration ability, credit check, port in eligibility (WLNP), price plan validation, activation of mobile numbers.

Environment:

Windows XP, Oracle 9i, SQL Plus, UNIX (AIX 5.2), WebLogic, JAVA/J2EE, Korn

Shell Script, Wedat, iSQL, Remedy, Rational ClearQuest & Webtrax.

Responsibilities:

Gather/analyze information from design documents, addendums, and meetings to create test plans

And test case requirements.

Communicate with developers, business analysts, DBAs, and project managers to clarify design issues and requirements.

Use SQL to extract and verify information from an Oracle database.

Log defects found during test execution into Rational ClearQuest and Remedy

Cingular Wireless Project: PRICING (Systems Integration Testing)

CARE, PRICING and WISDOM (CPW in short) are the three processes that make up the entire Billing process at Cingular Wireless (South East Region). Pricing starts with the wireless call being received at the switch and ends with the call being priced. WISDOM then receives the priced calls from Pricing and customer information from CARE and generates the customer monthly bill.

Environment:

Windows XP, Sybase 12.5, UNIX (AIX 5.2), Korn Shell Script, Perl Script 5.8.6,

C & C++ Programming, iSQL, TestDirector 8.0 and ILS (Incident Logging System).

Responsibilities:

Developed Test Strategies & Test Plans and documentation for manual testing of various modules of the PRICING process.

Configure the various servers for Systems Integration testing.

Set up the Test Server environment for testing the various applications – creating and loading the databases, installing the code (scripts & programs) and test kit.

Performed backend database checks and error detection in the log files.

Cingular Wireless Project: RETAIL Applications

RETAIL SYSTEMS consists of 4 main retail applications – PosDotCom, OPUS, CBAS & TelePOS that Cingular Wireless telemarketers and retail outlets use to activate new customer accounts and maintain and service existing customer accounts. These front end retail apps interact with a number of back end systems (Oasys, Compass, CAM, Quickpay) and with the billing system database, CARE. Major changes are constantly being made to these front end applications to accommodate AT&T wireless MIGRATIONS to the Cingular network, WLNP (Wireless Local Number Portability) mandate and new product offerings.

Environment:

Windows XP, Sybase 12.5, Oracle 9.2, SQL Plus, AS400, Java & C++ Programming,

SQL, iSQL, ILS (Incident Logging System), JackTrack (a defect logging tool).

Responsibilities:

Developed Test Strategies & Test Plans and documentation for manual testing of various Provisioning and Retail applications.

Validation of the Billing System Database, CARE.

Set up the Test Server environment for testing the Provisioning and Retail applications

Performed Regression Testing and ETE testing of the applications.

Performed backend database validation of the Billing application (CARE)

WLNP (Wireless Number Portability), New Activations and Customer Service.

Executed Wireless MIGRATIONS and WLNP test cases

FEEDER ENGINEER (Employee) BELLSOUTH CORP.

Sep 1986 - Oct 2002 Tucker, GA

Responsible for the planning and availability of all feeder plant between the central office and strategic locations for the cities of Loganville, Conyers, Panola and Lithonia. Responsibilities included the planning, design and ordering of all telephone equipment for the provisioning of interoffice facilities, fiber diversity and advanced telecom services.

GRADUATE INSTRUCTOR & RESEARCH ASSISTANT Aug 1978 - May 1984

Responsible to teach, examine and grade various undergraduate courses at Florida State University & Purdue University. Research duties included Computer programming and modeling for Projects funded by the U.S. Govt. and major corporations.

EDUCATION:

A) Database Administration Dec. 2004

Gwinnett Technical College, GA. GPA 4.0/4.0

B) M.B.A. Major in Finance

Florida State University, Tallahassee, FL. GPA 3.7/4.0

C) M.S.I.E. Major in Operations Research

PURDUE UNIVERSITY, W. Lafayette, IN. GPA 5.75/6.0

PERSONAL:

U.S. CITIZEN. Willing to travel and relocate.

References will be furnished upon request.

Contact this candidate