SUMMARY

Over **+ years of diversified experience as Automation Engineer/Business System Analyst and Over 8+ years of experience in Financial and Credit card services at JP Morgan Chase bank.

•Skills include Automated Testing on Client/ Server & Web applications, Data Analysis, Requirement Gathering and Business Analysis.

•Executed and created automation scripts including dynamic parameterization using data sheets, database tables and excel spreadsheets, checkpoints, HTML/XML DOM objects, java classes/objects and descriptive programming.

•Identifying objects of App using UI Automator tool for Android and Appium Inspector for iPhone.

•Experience in Test Automation using tools like QTP, Selenium, Cucumber, Maven, Jenkins, Gherkin.

•Expertise on Testing REST API services using SOAP UI/Postman.

•Created and maintained server-side integration tests, JSON documents, running with every build with Git, Jenkins.

•Extensively used UDF2 framework to design functional test using Selenium.

•Extensively used Business Process Testing (BPT) framework.

•Developed Appium Scripts for Native Android/IOS Apps using Java.

•Experience with creating Components to perform Business Process Tests.

•Extensive experience in writing Stored Procedures, Packages, Database Triggers using SQL.

•Used Jenkins for Continuous Integration (CI) and Maven as build development tool.

•Hands-on experience in AS400 with RPG programming, RS6000 with SQL programing and Visual Basic.

•Experience in designing Automation test cases using Selenium, Cucumber, TestNG, Gherkin scripting and execution.

•Experience with Total System Services (TSYS) for credit processing and handling transaction, rewards and awards.

•Implements Customer Content Management System (CMS) using SharePoint.

•Proficient in testing RDBMS such as Oracle, DB2, SQL and PL/SQL programming for testing data integrity.

•Experience in Data Warehouse development, worked with Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Ascential DataStage with DB2 UDB, Oracle, SQL Server.

•Experience with SQL LOADER, SSIS, SSRS from loading the data from XML, Text file etc and inserted into the database.

•Extensive experience in Functional testing, Unit testing, Usability Testing, Integration testing, Regression testing, GUI testing, Back-end testing, User Interface (UI) Testing, Ad-hoc testing, White Box Testing,Gray Testing, Black Box Testing, System Testing, baseline, Installation, Performance and Build Verification Testing.

•Extensively used tools like Mercury Tools (QTP 11, Win Runner, Load Runner, ALM, Test Director)

•Tested Web Services call for their working and functioning and parsing XML documents.

•Extensively used Load Runner for Performance and Load Testing. The Avg. CPU usage, Response Time, and TPS are analyzed for each scenario

•Experienced in RTM (Requirement Traceability Matrix) to know the status of the project.

•Responsible for Test cases, Test Plans, Test Reports, Executing Test Cases, Scripts

•Worked with Oracle PL/SQL Stored Procedures, Table Partitions, Triggers, SQL queries, SSIS, PL/SQL Packages, IBM SQL Procedural Language and loading data into Data Warehouse/Data Marts.

COMPUTER SKILLS

Languages

VB, Gherkin, C#, Java, Java script, Web Services, J2EE, VB.NET, SQL, XML, SOAP, UNIX, TSYS, REST API

Database

Oracle 10g, MS SQL 2008, SQL LOADER, SSIS, SSRS, Toad

Testing Tools

Selenium, QTP, Jira, ALM, Postman, Eclipse, SoapUI, Appium, Jenkins, Maven, Bitbucket, GIT, SVN, HP Quality Center, Jmeter

Reporting Tools

Tableau, Business Objects.

Software Q/A & Testing

Standard & Procedures Development, SDLC, Testing,

Test Plan Design and Development

Methodology

Waterfall, Agile Scrum Methodology

Data Modeling Tools

Erwin, Visio.

GUI Servers

IIS, Web Logic, Tomcat

Operating Systems

Windows 10, Unix, Linux.

PROFESSIONAL EXPERIENCE

Bank of America Newark DE. Apr 22 – Till Date

Automation Test Engineer

Mule API Migration Project:

This project is implemented to migrate API from Mule 3.9.5 to Mule 4.4. As part of this project, extensive manual testing was performed using tools like Postman and automation testing.

Responsibilities: -

•Extensively used Postman to test API and validate the response.

•Experience using Splunk to check logs and validate the API is routed to accurate proxy.

•Used REST Assured framework to test API via Automation.

•Tested workflow of application, functionality of API

•Good knowledge of web services tools Rest API and understanding of HTTP code responses.

Environment: Selenium, Jira, TSYS, Postman, SoapUI, QTP, ALM, Toad, Splunk.

JPMorgan Chase Wilmington DE. Feb 13 – Apr 22

Automation Test Engineer/BSA

Chase Pay: Chase Pay is a faster mobile checkout alternative to Point of Sale (POS), available to 50 million Chase cardholders. It is a direct merchant and bank relationship that can deepen customer relationships and potentially reduce fraud liability and payment costs. Chase Pay lets customer use their smartphone to pay for purchases in a store instead of presenting a physical credit or debit card. Digital wallet can also be used to store information for quicker online purchases.

Chase Pay Merchant Integration - This project is implemented to integrate Chase Pay services on Merchant application and e-commerce websites. With this integration Chase customers can leverage easy checkout option on Merchant app and websites as well as take advantage of numerous benefits offered by Chase. Some of the merchants that were successfully implemented were Starbucks, Walmart, Cinemark, ShopRite, Atom Tickets, Gulf and Shell.

Chase Pay - Starbucks: This project enables Chase customer to use Starbucks Loyalty Membership card at Starbucks store. Starbucks Loyalty Card Information is saved in Chase Pay App Profile. Any purchases made at Starbucks store using Chase Pay is by default done using the SBUX Loyalty card. First Chase Pay transaction made at SBUX earns 300 Stars.

Chase Pay - Walmart: Chase pay services were implemented on Walmart App and Walmart e-commerce website. Chase customers can take advantage of easy checkout and other benefits offered by Chase.

Chase Pay - Walmart 10X Offer: This project enables Chase Pay user to shop at Walmart and earn bonus points. Chase customers can earn 10 times points when they use Chase Pay as Payment Method on Walmart App or at Walmart.com. This offer is subjected to cap of $325 in maximum purchases.

Chase Pay - Best Buy 10x Offer: This project enables Chase customers to shop at Best buy and earn extra bonus points. Chase pay transactions made at Best buy stores earns 10X points. That’s 9 more points than 1-point customers earn on all transactions.

Chase Pay - ShopRite 10x Offer: This project enables Chase customer to shop at ShopRite store or ShopRite.com and earn extra bonus points. These transactions earn 10X points on up to $400 in overall purchases at Shop Rite stores or at ShopRite.com

Freedom Unlimited Product Launch: Chase launched a new product “Freedom Unlimited” to existing and new customers. This product offers unlimited 1.5% cash back on every purchases.

Acquisitions- Global Refer-a-Friend (GRAF):

Global Refer-a-Friend campaign is to acquire new customers while providing an existing customer the ability to earn rewards points for each card member he/she refers. New Cardmember would get the premium that is currently the control offer and existing cardmembers would get smaller premium for each person they refer that is approved for the card thru this initiative and makes first use by a certain date.

Ultimate Rewards 2.0 (UR 2.0):

This application enables card members (Credit & Retail) to enroll on the website and perform activities. Activities includes both credit and retail card member redeeming for Gift Card, Charity Checks, Points Transfers, Rewards Check, Points Purchase and Statement Credits. Card member has the ability to navigate through the Rewards Activity Page, Ultimate Rewards Page, View Past transactions, View Pending Transactions.

Responsibilities: -

•Provide Product Owner, Scrum Master, and Team Members knowledge and leadership regarding software quality processes, as well as process improvement. Automation experience creating and maintaining automation frameworks in Cucumber, VB Script, JavaScript.

•Experience with Automation Tools / frameworks – Jira, Confluence, Jenkins, Maven, TestNG, TestRail.

•Developed automated integration and smoke tests using modern tools including Selenium, SoapUI (web front-end and services)

•Partner with development to build page-objects for automation scripts using Selenium WebDriver, JAVA and TestNG early in Sprint cycle for quick turnaround.

•Design, Build and maintain macro scripting.

•Experience with Automation Tools / frameworks – Jira, Confluence, Jenkins, Maven, Bitbucket, TestNG and Eclipse.

•Experience in Java, VBScript, VBA and XML.

•Experience with calling RESTful API services and parsing JSON File.

•Experience in creating XPATH to locate web elements.

•Proficient in developing automated API and services test (REST, SOAP) using market tools such as REST-assured, Postman, and SoapUI.

•Participate in daily Scrum calls, reviewing Product Backlog, Sprint Backlog and Sprint Retrospective.

•Performed automated testing and maintain documentation on different types of Testing viz., Regression, Functional and Performance testing.

•Extensively used Business Process Testing (BPT) framework.

•Experience in designing Automation test cases using Selenium, Cucumber, TestNG, Gherkin scripting and execution.

•Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server.

•Extensively used REST API to design utility macros in JIRA.

•Used TSYS mainframes, for posting payment transactions for the card member to get enrolled by posting the monthly fix pay amount.

•SQL LOADER loaded the data from any text file and inserted into the DB2.

•Extensively used Oracle, SQL queries to retrieve data from the databases.

•Tested Web Services calls used in the applications using SOAP UI.

•Optimized QTP/UFT scripts for Regression testing of the application with various data sources and data types.

•Experience testing under various application environments including web-based, client/server and AS400 based systems.

•Managed the overall testing effort, including coordination of testing personnel and test lab resources.

•Extensively used ALM and JIRA for Test Planning, Bug tracking, and Reporting.

•Expertise in writing SQL Queries and performing Database validation including data integrity and data validation.

•Analyzed the Data quality, Data validating, Data mapping to test data in SQL server.

Environment: Selenium, Jira, Confluence, Jenkins, Maven, Cucumber, Bitbucket, TestNG, UNIX, Windows, TSYS, Postman, Tableau, SoapUI, QTP 9.2, ALM, SQL Navigator 4.5, SQL Server 2008, Oracle 10g, Toad, J2EE, .NET Framework.

JPMorgan Chase, Mechanicsburg PA. Jan 10 – Jan 13

Automation Test Engineer/BSA

Partner Pages:

This project is for JPMorgan Chase. This application enables card members (Credit & Retail) to enroll on the website and perform activities. Activities includes both credit and retail card member redeeming for Gift Card, Charity Checks, Points Transfers, Rewards Check, Points Purchase and Statement Credits. Card member has the ability to navigate through the Rewards Activity Page, Ultimate Rewards Page, View Past transactions, View Pending Transactions.

Points.com

This application enables card members to redeem points via partner site. Partner Data is loaded into Chase Catalog by batch process. It is a point redemption plan whereby Chase credit card holders will accumulate points through purchases made with the Chase credit card or through special offers from Chase. Points accumulated by Card members may be redeemed for specific Program Awards at specific Point Costs, provided that the card members are enrolled in the Program.

Catalog Feeds:

CLS provides a DAF process to manage the receipt of the data feed from different Partners. Data feed is pushed as XML to CLS daily. CLS determines new Partners, update Partner data, and Partners that have been removed from the program. Application generates a Partner record within its system as a result of processing the Image and Data Feed files.

Responsibilities: -

•Managing all verification and validation (V&V) activities for all Production modifications including projects, releases, and changes.

•Coordinating with other QA Leads, the Project Manager, Development Manager, and SQA.

•Created test plan, strategy and scripts for the .NET and web-based applications using AGILE methodology in Mercury Quality Centre 9.0.

•Performed testing across different browsers e.g. IE 6.0, IE 7.0, IE 8.0, Safari, FF.

•Performed end to end testing to validate whether card member is charged for the item redeemed and credited for the returned item.

•Hands-on experience in AS400 with RPG programming, RS6000 with SQL programming and Visual Basic.

•Used SQL to produce monthly reports, month to date reports, daily activity reports and reconciliation reports using SSRS.

•Assessing risk to quality based on results of V&V activities and making recommendations based on this assessment.

•Coordinate regression, system, integration, and API web services testing with Product Engineering and engineering team.

•Created SQL Queries against source table, target table and Distribution Tables.

•Performed Unit & Functional testing using JUnit (J2EE Env) &NUnit (.NET Env)

•Developed several FIFOs: developed system to automate record keeping and devised a system to publish the output from existing AS/400 application to company’s intranet.

•Integrated & deployed web-services using SoapUI.

•SQL LOADER loaded the data from any text file and inserted into the DB2.

•Wrote Test cases, Test Scripts and Test Scenario in Microsoft Excel, based on System Requirements Specifications (SRS) and Customer Requirements and then imported to Quality Center.

•Verified ETL transferred data from DB2 and Microsoft SQL tables to the Operational Data Store created in Oracle8i.

•Performed manual and automated testing and maintain documentation on different types of Testing viz., Regression, Integration, System, Performance, and Acceptance testing. Comprehensively reviewing the business requirements, specifications, systems design, and conceptual design documents

•Supporting the business in defining requirements and specifications and trace matrix.

•Made XPath Queries on the XML Document from WebServices calls.

•Understanding system functionality as it relates to the business requirements and specifications in order to define QA test objectives

•Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server.

•Assisting the business through the process by providing solutions and options for implementation of the business requirements.

•Tested the interfaces and participated in functional, integration and dataintegrity testing.

•Wrote PL/SQL Functions, Stored Procedures, Triggers, & Packages in Oracle.

•Developed PL/SQL procedures to match Prices between our Data warehouse and Daily Feeds.

•Performed regression testing of application for every new build released.

•Managed the overall testing effort, including coordination of testing personnel and test lab resources.

•Mapped the custom objects to the standard objects where necessary, and inserted Text checkpoints where needed, to compare the current behavior of the application being tested to its behavior in the earlier version using Quick Test Pro (QTP).

Developed Requirements Traceability Matrix (RTM) to ensure adequate test coverage.

Environment: UNIX, Windows, TSYS, Rapid SQL 7.6, SQL Loader, SQLServer, SSIS, SSRS and SSAS, JUnit, NUnit, SoapUI, Crystal Reports, Erwin 4.1, QTP 9.2 and HP Quality Center 9.2, SQL Navigator 4.5, SQL Server 2008, Xml Spyware, Oracle 10g, Toad, J2EE, .NET Framework.

Independence BlueCross, PA Mar 08 – Dec 09

Test Engineer/BA

Project I: Managed Healthcare Systems (MHS) 660, 671, 680:

MHS include the design, development, ongoing monitoring and management of managed health care solutions, to the benefit of medical scheme administrators, medical schemes, their members and providers of health care. This is achieved through the provision of appropriate managed care and clinical expertise, consultation, computer systems and software, specialist products, resources and services.

It’s a system that controls the financing and delivery of health services to members who are enrolled in a specific type of healthcare plan.

Project II: Claims Purge and Archive:

This Project was introduced in order to purge posted claims records to history while retaining the ability to view the active and historical claims. This application helps to reduce the number of claims in the database by purging claims based on different parameters.

Project III: Wellness Partners:

It is a web based application developed to address the needs of employees. Employers are recognizing the importance of providing convenient health education and disease management programs that address the needs of their employees. Programs perform different preventive health screenings, awareness seminars, and other wellness activities. Associates can login online to the application and register for the activities.

Responsibilities:

•Used Rational Unified Process (RUP)/UML to make an Object Oriented model for the application and used UML/Rational Rose for creating the Use Cases, Activity Diagrams, Class diagrams, Sequence diagrams, Process Flows etc.

•Involved in writing Test Plans, Test cases and developing Test scripts using Test Director.

•Designed ETL process as per the requirements and documented ETL process using MS VISIO.

•Demonstrated the ETL process Design with Business Analyst and Technical Lead. Preparation of design guidelines for ETL process development using DataStage Enterprise edition Parallel Extender, PL/SQL, SQL and Shell scripts.

•Implemented the logical Data Stage connections across the platform.

•Performed manual and automated testing and maintain documentation on different types of Testing viz., Regression, Integration, System, Performance, and Acceptance testing.

•Ability to build and execute SQL Queries on AS400 DB.

•Created test plan, strategy and scripts for the .NET and web based applications using AGILE methodology in Mercury Quality Centre 9.0.

•Participated in agile/scrum process – scrum team meetings with developers.

•Optimized QTP scripts for Regression testing of the application with various data sources and data types.

•Used Serena Team Track for defect management and reporting.

•Extensively used Oracle, SQL and DB2 queries to retrieve data from the databases.

•Experience testing under various application environments including web-based, client/server and AS400 based systems.

•Verified ETL transferred data from DB2 and Microsoft SQL tables to the Operational Data Store created in Oracle8i. Also, created test data for end to end process.

•Running jobs, backups, disaster recovery, printing reports and user assistance in an IBM i5 AS400 environment.

•Tested the design, develop software systems using Java / J2EE, Web Services, HTML, Java Script, SQL Server 2005, XML, Crystal Reports,

•Estimate, initialize, manage, monitor and control and close project according to Requirement guidelines.

•Developed and wrote UNIX Shell scripts for Batch jobs using Control-M.

•Developed PL/SQL procedures to match Prices between our Data warehouse and Daily Feeds.

•Wrote PL/SQL queries to verify data’s in the Oracle 10g database.

•Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server.

Environment: SoapUI, NUnit, JUnit, BMC Remedy 7.1, Actuate Reports, TSYS, Quality Test Professional, AS 400, Quality Center, Load Runner 8.0, SQL Server 2005, Oracle 9i, J2EE, Unix.

EDUCATION:

Master’s in business administration Sept 05 – Jan 08

St Joseph’s University (Haub School of Business), Philadelphia, PA, USA

Bachelor’s in mechanical engineering Sept 99 - July 04

Parshvanath College of Engineering, Bombay, MH, India

Contact this candidate