Test Engineer

Email: ***********.****@*****.***

Cell 214-***-****

VISHAL K GUPTA

Profile Summary

Over 12 years of professional experience in Information Technology, with extensive experience in performing Performance, Load and Functional Automated Testing for client/server and web-based applications in diversified industry sectors including Banking, Finance, Inventory Management and Airline domain and providing solutions for Test Automated Framework CI/CD by evaluating new test tools.

Proficient in various SDLC methodologies like Rational Unified Process (RUP), Waterfall and Agile Methodology and SAFe (Scaled Agile Framework).

Expertise in Lead/Architect Role and responsible for resolution of imminent and current impediment, test tool evaluation. Expertise in validating web services and MQs using CA LISA, SOAP UI, QTP, JMeter and HP Loadrunner.

Experience in conducting Build Verification test, Functional test, Security and Access Control Test, User Interface or Usability Test, Regression Test, Business Cycle Test, Performance Test, Database Integrity Test, Failover and Recovery Test, Compatibility Test, Regulatory Compliance Test, Installation Test, Data Migration Test, Parallel Run Test, System Test, Cross Platform testing, Integration testing and Stability testing, User acceptance testing.

Experience in SQA Process and proficient in working with Quick Test Pro 11, CA LISA 7.5, SOAP UI, Trac and Quality Center.

Expertise in VSE, Pathfinder, VUGen, ALM Performance Center 9.5 and Load Runner 9.5/11.0.

Experience in creating complex SQL queries (to validate data).

Achieved SHU level in agile assessment conducted by agile coaches.

Expertise in Test Strategies, Traceability Matrix, Bug Reports and Test Plans.

Work closely with the business analysts for documenting operational process workflows to support new initiatives and associated system changes.

Demonstrated creative problem solving skills to resolve functional and technical problems and ensure no slippages to delivery schedule.

Expertise in Performance Testing for Web Applications, Web services, MQs using ITKO LISA

Expertise in Quality Center Site Administration like Create Domain, Project, Users and Assign Users to Projects and Domains.

Expertise in Quality Center like Create Requirements, Test cases, execute test cases and Track the defects.

Involved in Migration process from Quality center 10.0 to Quality Center ALM version.

Expertise in Execute manual and automated test scripts from Quality center.

Proven leadership skills that demonstrates the ability to manage a team of cross-department and cross-level resources.

Facilitate general status meetings and senior level executive status meetings related to implementation, status, and analysis and issue resolution.

Execute integration plans with specific regard to business applications and user training and provide constant feedback to IT and senior management.

Good communication skills, interpersonal skills, self-motivated and quick learner.

Good team player with excellent work history as regards with work ethics, dependability and willingness to go an extra mile.

Experience in team management, onsite-offshore model.

Identify, prioritize, escalate and resolve complex technical and business issues related to implementation of business rules.

Adhering to all established methodologies, standards and guidelines individually and/or as the QA lead of a project team.

Experienced in Test Case Design, Test Planning, Test Tool Usage, Test Case Execution, Defect Management, Risk Analysis and building Test Environment.

Recommend go/no-go decisions for projects about to launch.

Serve in a liaison role between the business analysts and testers and work to manage expectations and delivery of new initiatives.

Experienced in time management, reporting and monitoring, risk management, issue management, quality assurance and change management.

Certification - Sun Certified Programmer for Java2 platform 1.4 in July 2007.

Education:

Master of Computer Applications from RGPV University, Bhopal, India in 2004.

Bachelor of Computer Science from DAVV University, Indore, India in 2001.

TECHNICAL SKILLS

Programming Languages

C, C++, Java,J2EE,PERL

Scripting Languages

VB Script, Java Script,Ruby,Perl,Shell

Operating Systems

UNIX, Solaris, Linux, Windows 95/98/NT/2000/XP, MS-DOS

DBMS

Oracle, mySql, MS Access, SQL Server, DB2, PL/SQL, Teradata

Web Technologies

HTML, XML, XSLT, WML, Servlets, SOAP, Java Web Start, Resin Web Server, Jigsaw Web Server, Apache Web Server

Virtualization Tools

Vmware

Documentation Tools

Microsoft Project, Excel, Word, Access, PowerPoint, Rally Software,JIRA, Sharepoint

QA & Testing Tools

Quick Test Pro, TestDirector, WinRunner, LoadRunner, Quality Centre, Rational Robot, Rational Test Manager, Rational Performance Tester, Rational Functional Tester, Rational Manual Tester, ITKO Lisa, Selenium, Jmeter, Watir, MTM, TFS

Professional Experience:

BNSF Railway Sep 18 to Current

Fort Worth TX

Performance test lead

Worked on Detector Analytics mechanical project to develop performance testing framework using Jenkins, Jmeter,

Db2, custom java code to implement work load model and custom java code to generate html report by executing the queries in DB along with automatic email notification at the end of testing.

Setting up test infrastructure with Jenkins admin and Jmeter Master-Slave configurations.

Offshore co-ordination with daily task and status updates along with technical guidance.

Performance test approach and plan demo to business stake holders.

CVS/Health Jun 15 to Sep 18

Richardson TX

Performance Lead/Test Architect

Worked on multiple projects developed with PeopleSoft, Web Services, SAML, Active MQ, EJB, Virtualization of Web services, EJB calls, HTTP requests, Web 1.0 and Web 2.0 applications

Job Responsibilities:

Participated in User sessions for obtaining SLA and Functional requirements for Performance test, functional tests and Virtualization

Developed and Executed ITKO Lisa scripts, Load Runner for Performance testing of applications developed with Web1.0 and Web2.0 technologies

Created performance test plan, Test results document and ROI documents

Worked on multiple projects, created POC for various applications, tool selection and environment set up.

Created data validation scripts and executed data validation runs for gathering/modifying the data.

Created custom logic in Load Runner for handling complex functional flows using C language

Installed and configured HP Sitescope for monitoring purposes

Installed and configured LISA infrastructure in the enterprise version

Developed and executed LISA scripts for Web Services EJB calls, JMS calls, and Active MQ calls.

Developed and executed Load Runner scripts for Web Applications (web, http/html, EJB, Web service calls)

Generated detailed reports for Performance test execution on ITKO Lisa and Load Runner

Analyzed Performance results, identified bottlenecks and various metrics like CPU Usage, memory (heap, Threads, Connections and Garbage Collection)

Collected metrics from HP sitescope and HP Diagnostics for identification or problems and analysis of Performance results

Performed Benchmark, Baseline, and Performance, load, Stress and Endurance testing.

Developed Custom LEK steps for LISA and also worked with Java script steps for handling the extra operations which LISA can’t support.

Developed custom LISA framework for virtualization without recording transaction for multiple times using Mysql database and custom SQL queries

Used Quality centre10.0 for defect management and reporting

Performed detail performance analysis of SUT in terms of threads, Physical CPU, process CPU, Heap and Used Memory

Created Virtual services for Web services, HTTP calls and EJB calls using ITKO Lisa.

Created and Executed Web2.0 scripts for testing Web applications using Java script and Ajax calls

Performed detailed analysis for estimating the hardware for installing LISA software (coordinator, simulator) and provided detailed system requirements.

Created complex SQL queries, procedures to extract data from DB2 and Oracle databases

Environment: ITKO Lisa4.6.4/5.0.20.45, Load Runner12.5, Quality Centre10.0, HPC, HP Sitescope, HP Diagnostics, TOAD, Active MQ, Peoplesoft, SAML, Federation Server, AS400, Mainframes, DB2, Oracle, EJB, Java script, Java, LEK

BNSF Railway Mar 14 – June 15

Fort Worth TX

QA Lead

Customer Web

A business application that allows customers to manage their equipment in our shipment life-cycle.

This will also allow customers to track their shipments and notified them if there is any alert/attention items for them throughout the shipment life-cycle.

Analyze the LISA reports after Performance testing done.

Analyze the Design, Architecture Documents, IT Plan, Use Cases and developed & supporting test plans, test cases & scripts.

Tested ETL job Process, created and updated ETL Object migration form and database migration form.

Integration, system, functional, regression and systems integration testing with testing interfaces between several systems.

Interface Testing of Mainframe. Using XML as an interchange format allows seamless data exchange between Downstream and Upstream applications.

Executes integration and regression test cases as required for application releases and enhancements and Documenting test results for corrective actions, reporting and audits.

Data analysis - ability to understand Logical and Physical Data Models and Backend Database Validation testing using SQL Developer and TOAD.

Run and validate the web service functionality using Soap UI.

Have very good experience creating Suites and Staging documents using LISA

Developed Automation frame work for CW portal using QTP/Quality Centre.

Developed Common and Application specific functions as a part of frame work

Developed and executed BVT suits as part of release process.

Involved in daily release, defect triage and weekly status meetings.

Used Quality Center for Defect tracking and Test Management.

Prepared a Test Suite of Smoke (BVT), Mini Regression, Detail Regression testing.

Prepared Test summary report for each cycle of testing.

Performed Sanity testing in Production environment after application is deployed. This is to confirm that application is deployed correctly and working as expected.

Involved in System Integration testing to validate end-to-end business scenarios between HUB, Salesforce, Web and Mainframe environments.

Conducting weekly review meetings during Test Planning stage, daily status updates during Test Execution stage.

Environment: CA LISA 7.0.1, HP UFT12.01, MainFrame,J2EE/Dot Net Applications, Oracle, Team forge 7.1, DB2, Teradata, SOAP/REST Web services, SOAP UI, Mongo DB (No SQL),

Worksoft Certify 9.0.1, Control-M, ETL/Informatica

Liberty Mutual Insurance Nov 13 – Mar 14

Seattle WA

Sr.QA Engineer

WorkBench

This track focuses on replacing and retiring existing Surety Net application. This Workbench Surety Net Replacement initiative includes the full analysis and delivery of document management capabilities needed within LMS. It is the strategic effort to redefine how all LMS documents are managed, including save/search/retrieve. This project is specifically for the Pilot release.

Environment: CA LISA 7.0.1, Quick Test Professional 11, Main Frame,J2EE/Dot Net Applications, IBM MQSeries, Oracle, MTM, TFS, Visual Studio, Selenium, QTP 11.0

Developed LISA scripts for functional, Load and Performance testing by specifying no of instances and no of cycles in Staging Document.

Analyze the LISA reports after Performance testing done.

Extensive experience in doing performance testing of web services through ITKO LISA.

Analyzed system requirement specifications and developed test plans, test cases to cover overall QA System Testing and Performance Testing.

Created and Executed ITKO LISA scripts for Web Service and MQ validation.

Developed Automation framework Using LISA to validate Web services, MQs and Data Base after messages are processed and data inserted to DB

Developed and executed scripts for web service validation using ITKO LISA

Created and Post MQ messages using ITKO LISA.

Developed the CA Lisa scripts to do the performance testing for Web services, DB and Web applications.

Used LISA VSE to generate the virtual services to test when the real services were down.

Used LISA Pathfinder to debug the log files to trace the issues.

Macys Systems and Technology Sep 13 – Nov 13

Johns Creek, GA

Test Lead

Order Capture and My Ship Automation/D2C

Worked as onshore test lead for My Ship application for automating the manual test cases using

QTP 11 and HP ALM and SOA test 9.5 for automating the Order Capture application.

Coordination with offshore test team to discuss the status and explain the requirement.

Conducting weekly review meetings during Test Planning stage, daily status updates during Test Execution stage.

Run the Batch programs in UNIX environment and validate the data.

Used Win SAP tool to modify and copy the files from UNIX environment to Windows environment and vice versa.

Used Putty tool to connect to UNIX system and execute the batch programs.

Environment: SOA test 9.5, Quick Test Professional 11, HP ALM 11, SOAP UI Pro, DB2, and SQL.

American Airlines Mar 09 – Sep 13

Fort Worth TX

Sr.QA Automation Engineer/Scrum Master

RM (Revenue Management), Everest LT (Location Tracking)

American Airlines Cargo, a division of American Airlines, Inc., is one of the leading international air cargo providers. The cargo unit has embarked on a multiyear business transformation program (Project Everest) to migrate from the legacy systems to more agile business driven systems. As part of this program, the warehouse operations has identified shipment piece tracking as one key area to be addressed by the transformation effort. Once implemented, the Location tracking project will provide the cargo business unit visibility to all the shipments (at piece level) across all their warehouses from tender to delivery.

• Extensively tested web service functionality and Performance using ITKO LISA.

• Performed Load testing for the Web services and MQ’s using ITKO LISA

• Developed Automation frame work for Customer Web portal using QTP

• Written and executed automation scripts for Web service Validation using QTP WSDL add in

• Developed Common and Application specific functions as a part of frame work

• Executed QTP and LISA scripts as a part regression testing for every release.

• Developed and executed BVT suits as part of release process.

• Involved in daily release, defect triage and weekly status meetings.

• Run the Batch programs in UNIX environment and validate the data.

• Used Win SAP tool to modify and copy the files from UNIX environment to Windows environment and vice versa.

• Used Putty tool to connect to UNIX system and execute the batch programs.

Environment: ITKO LISA, HP QTP11, Mercury Quality Center 10 & ALM 11, ALM Performance Center, VuGen, SOAP UI, Windows XP, UNIX, Main Frame,J2EE, IBM MQSeries, Oracle, IBM Web Sphere, Putty, SQL Developer, TOAD, Track, WinSCP, Rally, Agile Methodologies and Web Services, PL/SQL, Teradata

American Express May’08 – Mar’09

Atlanta, GA

QA Engineer

BIP -SaaS: Deliver a scalable, secure and serviceable B2B platform known as Buyer Initiated Payments - Software as a Service (BIP-SaaS) platform using Web Sphere, Informatics & Oracle 10g to allow paperless invoices to be processed between Buyers & Suppliers.

Analyzed and optimized the process. Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification and Technical Specification.

Performed Functionality testing and Regression testing, GUI testing, Backend testing, Integration testing, System testing, and Performance Testing.

Executing SQL queries, Stored Procedures and functions to validate the data in the back end. Validation of DB2 tables.

Validation of Front end applications and Back end testing of table data validations using SQL and TOAD.

Used Joins, Inserts, updates and delete statements using SQL.

Performed Tuning of DB tables views and Indexes.

Validated the test results in the unit testing for Junit.

Created Data sets in the Data table from Excel sheet and database to test various sets of data using Quick Test Professional.

Executed QTP automated tests in Debug mode to make sure they run smoothly by inserting breakpoints, monitor variables and control the tests to identify and isolate defects.

Involved in creating and grouping test scripts for running them in unattended mode using Test Batch Runner in Quick Test Professional. Incorporated Error handling for test scripts.

Performed Functionality testing and regression testing using Quick Test professional.

Updated change requests, reported bugs and maintained bug reports in Rational Clear Quest.

Coordinated with developers to recreate the errors and maintained the trouble log reports. Involved in conducting the test walk-through and worked closely with project management.

Involved in testing the Hogan Integrated Loans System for the LEAD Application.

Involved in testing the middleware (MQ Series) for core banking applications and database interactions.

Environment: J2EE, Oracle SQL * Plus, HOGAN, TOAD, Business Objects, Struts Framework, MVC, Junit, Rational Clear Quest, QTP 8.2, Test Director, Load Runner, PERL, and UNIX.

American Express Oct’ 06 - May’08

Pune, India

Tester

WSIP (Web services IP Payments): Provide Web Services to Point of Sale (POS) device manufacturers, software vendors, 3rd party processors, and merchants can use to easily and securely connect to American Express via the Internet. The Web Services would need to support both real-time and batch authorizations.

Interacted with developers and studied the Specifications provided by the analysts to have a better understanding of the application

Developed the testing strategy and documented it for higher levels of management

Formulated detailed test plans for System testing

Carried out cross browser testing for the search portal

Conducted Functionality, Interface and Regression testing during various phases of development

Created test scripts using WinRunner and parameterized them to test scenarios using different test data

Wrote SQL queries to test the database tables

Performed Regression testing on the application builds when any modification was done

Enhanced test scripts by integrating exception handling features like pop-up Exception, TSL Exception and Object Exception

Conducted performance testing under off load and peak load conditions

Used LoadRunner Transaction and Web Resource monitors to pinpoint bottlenecks

Identified and reported software defects using TestDirector

Participated in walkthrough and review meetings

Environment: WinRunner, LoadRunner, TestDirector, SQL Server, VBScript, Windows 2000/NT

CMC Limited Apr’05- Oct’06

Mumbai, India

IT Engineer

OLPICS (Online Purchase and Inventory Control System): Screen based ON-LINE Inventory system developed for effective inventory management by replacing the existing manual system.

Involved from the initial stage of putting the Requirements Documents for testability.

Involved in creating Test Resources and Test Strategy for the application.

Developed Test Cases, and Test Procedures, expected results using Test Director and testing of end-to-end scenarios.

Identified the high-risk points and the priorities of the application.

Tested the product for possible security breaches. The scope includes authentication and authorization testing.

Responsible for preparing Test cases, Traceable matrix for different modules.

Performed Black Box testing in entire project.

Involved in complete Software Development Life Cycle (SDLC) in the project.

Regular interaction with the core developers in helping the bug fixes/defects with in deadlines.

Developed positive and negative Test Cases and Test Data for each feature.

Gathered the Test Input data including Pre-condition, Test Input, Test Result, Test Regression data.

Integration testing with Ultimatix TCS ERP system.

Functional Testing included task feature testing, boundary testing, forced error condition testing.

Compatibility Testing included Cross Browser Testing, confirmation of browser security settings.

Executed the Test Cases, open defect upon detection of bugs and collecting the Test Metrics.

Analyzed different Reports and Graphs, and recommended the rectification of bottlenecks.

Environment: PL/SQL, AJAX, JSP/Servlets with Tomcat 5.0.28, Oracle 9i, Test Director

Contact this candidate