Arati Jaiswal Kotah

Email:ad23u5@r.postjobfree.com

https://www.linkedin.com/in/aratikotah1252ab15b/

PROFESSIONAL SUMMARY

Over 11 years of diverse experience across US and India in Information Technology with expertise in Manual and Automated Quality Assurance testing and analysis for the following domains: Banking and Brokerage, Financial, Media, payments, Telecom industries, sales, Networks, Healthcare, Travel and Tourism and e-commerce applications. Experience covers Business Requirements, Analysis, Functional, System, Load, Regression, Integration, Database and End-End Testing for GUI and Non-GUI (IVR – Interactive Voice Response) systems on cross-platform (Web and client-server) applications. Experienced in Automation testing using REST Assured, Selenium and QTP. Developed excellent professional and communication skills with proven results in meeting aggressive timelines and working independently and as a coherent team member and managing Test Lead and Test Manager responsibilities.

PROFESSIONAL RESPONSIBILIITIES:

Holding Industry experience in Information Technology with strong emphasis in Software Quality Assurance.

Experience in Manual testing, Backend testing, Automation testing and End-End testing.

Performed Pilot tests, Integration, Interface testing, Negative testing, Regression, Smoke, System, Functional, API, GUI, Database Integrity and User-Acceptance (UAT) testing, ETL Testing

Experienced in Rest Assured, Selenium, QTP, Quality Centre and Neoload.

Worked with Selenium Framework, TEST-Ng and Selenium Scripts.

Experience on Selenium Web Driver, IDE and creating Scripts in selenium.

Experience with Data Driven Testing and Run book.

Worked with POSTMAN scripts.

Worked on Salesforce CRM and the Salesforce Lightning Experience.

Worked with Mulesoft Anypoint Platform

Worked on estimations, metrics, demos, Planning and scheduling of projects.

Experience in working with databases: Oracle 9i and SQL Server.

Experience with Financial, Brokerage Applications, Payments, Sales and Billing, Web applications, Telecom and Travel applications.

Experience in Financial applications – portfolio management, position maintenance and custody applications for domestic and foreign assets (CUSIP, SEDOL based), reconcile positions on System of Record (SOR) with Custodians, recon aging, resolve recon breaks.

Coordinated and participated in Peer Reviews and External Walk-thru with the Client at regular project stages or reviews on Test Plans, HLTC and DTC.

Performed trouble-shooting to resolve production problems.

Good working knowledge of Software Engineering Methodologies like SDLC, CMM and Agile methodologies (Scrum status, Daily Status and Test Progress Reports) and Kanban board.

Deployments on QA and UAT servers, and performing SIT, Risk based Testing, Requirement Ambiguity Testing, Testing, Database testing using SQL, Testing, Multi Browser Testing, Webservices Testing (API), Migration Testing, Sanity/Smoke Testing, Regression Testing etc.

Used Quality Center tool for all the test management activities like Release Planning, Test Planning, Test case Execution, Requirement Traceability and Reporting. (using currently Kanban)

Excellent in driving the onsite and offshore model. Coordinated a 12-member offshore team to successfully implement an onsite-offshore model.

Knowledge in Core JAVA, HTML and .Net technologies.

Involved in Configuration Management and New Release Requirements Meeting

Timely Escalations to the management’s notice for any major/blocking issues and participated in Defect Triage Meetings.

Was involved in internal testing for projects involving ATM certification, testing middle layer changes, Config files and maintenance of servers.

Worked with Maven and Jenkins for the build integration.

Comfortable with change and tight deadlines and able to adapt quickly to new situations and technologies.

EDUCATION DETAILS:

M.Tech (Computer Sciences) - JNTU Campus – Hyderabad. B.E (Electronics and Telecommunication)-JNEC- Marathwada University.

TECHNICAL SKILLS:

Testing Tools and Management

REST Assured Framework, SOAPUI, Postman (API testing), Selenium, Cucumber Framework, UFT, QTP 10.0, Quality Center9.2, Microsoft Test Manager, JIRA, Rational Suite-Clear Quest, Test track, Microsoft Test Manager, Rational Suite-Clear Quest, Bugzilla and Load Runner.

Languages

Visual Basic, C++/C, Java.

Web/Scripting

HTML, Java Script, TSL and VB Script

RDBMS

Oracle, SQL Server 2008, SQL, SOQL and PostgreSQL

Version Control

Visual Source safe, PVCS, Clear Case and SVN and GIT

Methodologies

Agile &Scrum and SDLC

Quality Standards

CMMI L3.

Integrated Platform Tool

Any Point Platform

Environment

WINDOWS95/98/2000/NT, MAC, IIS, Tomcat and AUTH servers

PROFESSIONAL EXPERIENCE

Verizon, GA

April 2023 – Till Date

Sr.QA

Working on VBG-WLN project on E-E testing on onsite-offshore model. Project involves the validation of Finops approval of MSA contracts for install services for 4g/5g for Access (dynamic and static), Broadband, PIP, CPE products and services for E2E testing. Project also involved regression and progression automation using FAST framework (keyword driven).

Working on understanding the presales requirements by attending DTP calls, Developers calls and Demo calls.

Getting approval of the business requirements vs the test cases and defining the scope of testing for the sprint timelines.

Prevalidation testing done to see all the systems are ready, data loading for the environments under the plan and configurations done.

Validated the E2E flow for full blown functional, integration, regression and systems testing, UI Testing.

Testing involved testing the upstream and downstream systems by creating an opportunity in Salesforce - quoting-pricing-ordering-provisioning-billing-Finops Approval and opening trouble tickets.

Facilitated data, data environments switch overs and data provisioning

Running Postman scripts for simulation/activation/provisioning.

Setting up meetings with concerned teams to facilitate the trouble tickets with concerned audience.

Validated notifications, reports, invoices, bills, quotes and orders for usages, JITR files, BMA reports, SOA and UOTM notifications, etc.

Validating with business on Finops approval.

Running the automation regression and progression suite using FAST framework and SmartAs

Preparing for release, summary notes, tracking test cases, daily status calls and problem reporting and solution are an integral part.

Environment: Agile, JIRA (v8.20), Java, QTest, Postman FAST framework(automation) and SmartAs, JSON, XML, Jenkins Pipeline, Maven (3.0.3) and Azure.

Mulesoft, TX May 2020 – Mar 2023

Sr. QA

C360_AT&T is launching a new C360 app to have a holistic view of the customer through a dashboard so that agents and reps can serve them. As a sales agent, speaking to a new customer, Sales Force needs to show what consumer products, promotions, accounts, orders, billing and payments, service availability, adjustments, consent preferences and messages potentially available at a location to be purchased. This is facilitated through Mulesoft Anypoint platform integration.

Responsibilities:

Working on understanding the manual migration requirements. Analyzing Exchange requirements (RAML design) and work with prebuild teams to understand the requirements.

Analyzing requirements from user stories and raise defects based on API testing, Backend testing, test data and expected results.

Performed the JSON/XML request and response data validation via Postman webservice API tools.

Validated the application using MuleSoft ESB, build & the services to trace it form SAPI, PAPI and EAPI layers.

Running functional tests in POSTMAN and run the batch files through Newman for dev, QA, SIT, STG and UAT environments.

Acquiring test data through various back-end systems architecture by raising data requests to backend teams, through ATT portals to suit the needs.

Additionally, also acquired the request- response data through service virtualization.

Facilitated test data migration and test data copies for all environment changes.

Interacted with Salesforce to validate the Salesforce workbench objects to check the data is transformed correctly according to various business rules, and make sure that all projected data is loaded into Target tables without any data loss.

Mapped the transformations for Salesforce fields for validation from Frontend -Mule-Backend(lmgw)

Used SOQL Queries Salesforce workbench on both Source and Target to extract records and validate data for upsert of records. r analysis.

Involve in API design sessions to decide various resources within each API, message schemas, message formats and authentication.

Automation of Test cases through Run Book data using Rest Assured framework for functional, Sanity and Regression testing.

Key features include Input Excel validation, Runner, Payload fields to capture input, Assertion validation with status codes, response body Method creation – GET, POST, PUT, DELETE, Utilities file with common libraries, KeyStore values for authentication, Listeners and exception classes, Test Class and Main class to create methods and Test Report in html format

For automation ran the Jar file for execution

Maven add-ons for Pipeline execution

Created a repo in Code Cloud to check-in and checkout the source code to write to Jenkins pipeline along with Maven packaging artifacts, to Nexus repository.

Interacted with Frontend, Third party and Internal teams to streamline Mulesoft Integration test cases and trace requirements, functionality for end-end testing by raising jeopardies, Defect Resolution, Triages and lockdowns.

Reported in the Agile Process, with scrum meetings, scrum status, Sprints, sprint backlogs, iterations, releases.

Demo the user stories to Product owners, users, scrum masters and SF leads.

Environment: Java1.8, REST Assured Framework (3.2.0), SalesForce Lightning View, MuleSoft (4.30), SOQL workbench, Webservices, Postman-(8.12.0), Selenium, TestNG (6.14), JSON, XML, Jenkins Pipeline, Maven (3.0.3), Java, G IT, JIRA, Agile, Code cloud, RTF, Azure and BSSE.

Hertz, Estero, FL Jan 2018 – Apr 2020

Sr.QA Automation Tester/Lead

Working for InFact-Digital to automate their webservices, offered by integration technology MuleSoft for end-end scenarios on their gold rewards programs for members and guests, car rental locations, special offers, vouchers and frequent traveler credit programs. Also working on InFact integrations with Fleet, ResRent, GSystems, Concur, Localiza, Seamless for ESB integrations.

Responsibilities:

Working on understanding the manual requirements.

Performed Manual Testing.

Identifying automation test cases from manual test cases.

Developing the Automation Infrastructure Development by presenting POCs

Setting up the Selenium based REST Assured framework for regression testing.

Setting up scripts in the present framework with respect to the current existing scripts.

Automating APIs to assert payloads (business data) and validate field to field mapping for JSON schema.

Performed end to end use case automation for MuleSoft response payloads.

Running functional unit tests in POSTMAN.

Coordinating and reporting with onboard team (4 ppl)

Active involvement in setting up Maven and Jenkins for continuous integration.

Working and coordinating with Developers and Business Analysts.

Tested manually on Postman to verify responses of webservices.

Assisted on Digital production on hand-offs.

Interacted with other teams to understand the linking of Concur and Localiza applications with Digital systems (Excalibur).

Automating APIs to assert payloads (business data) and validate field to field mapping for JSON schema.

Performed end to end use case automation for MuleSoft response payloads.

Developed Splunk pages in Selenium for automation of Splunk queries.

Reported back results on different environments like QA, UAT and Bluemix servers.

Environment: Java1.8, REST Assured Framework, MuleSoft, Webservices, POSTMAN, Selenium, TestNG, POM, JSON, XML, Jenkins, Maven and GIT.

Charter Global, Atlanta, GA Dec 2013-Nov 2017

Testing Team lead

Project1: Customer Power is a multi-channel e-marketing solution, allowing users to use the application to send targeted marketing campaigns across the following channels: Email, Mobile Text Messages, Banner ads and SST.

Responsibilities:

Involved in Automation Infrastructure Development using Selenium.

Setting up the Automation Environment Setup Using Eclipse, Java, Selenium WebDriver and TestNG jars.

Implementing Selenium framework (POM).

Used Selenium IDE for recording initially to develop scripts.

Enhanced the Selenium Scripts using Web driver and java and selenium commands.

Developed Data Driven testing to retrieve test actions, test data from Excel files.

Worked on Add on s like firebug, fire path, etc.

Configured the OR and accessories like data and content for products and prices.

Creating reusable components.

Tested the reports in Test-NG for e-mailable reports.

Enhancement and configuration of HTML reports.

Integration with Maven and Jenkins.

Conducting browser testing and parallel test execution.

Responsibility of configuration and integration management of the test ware

Managed work on both Manual and Automation Testing.

Preparing metrics for client like defect density sheets and status reports.

Worked in a highly dynamic AGILE environment and participated in scrum and sprint meetings.

Done the estimates and metrics, plans and strategies, schedules and preparation of demos from the inception of project.

Artifact Review and preparation (Test Cases, Test Plan, Status Report, Summary Plan).

Creating WBS (Work Break Schedule).

Have been on active client coordination on all issues, risks, artifacts, data management issues and notifications to client.

All presentations and demos like the Kick off demo, QA Approach demo, QA Proposal demo and Phase-wise demos have been successfully carried out.

Maintained the Selenium automation code and resources in SVN over the time for improvements and new features.

Environment: Java1.8, Mozilla Firefox38,17, IE8,9,10&11; Chrome 47, 48; Selenium Framework HTML and XML, Eclipse IDE, Jenkins, Maven and SVN.

Western Union – New York Dec 2010 to March 2013

Senior QA Analyst/Onsite-Offshore Coordination

Project: Western Union (WU) Speed Pay Application is a payment gateway used by multiple clients in different industries to accept payments from their consumers. The Speed pay application facilitates different interfaces like the Internet (Online), IVR, Extranet, HTTTP Wrapper, and Web services. Mode of collecting payments includes Credit Cards, ACH, ATM and check Payments and reporting on BI reports.

Responsibilities:

Analyze user/business requirements and develop detailed test cases based on requirements.

Performed QA, interface testing and User Acceptance Testing for changes/upgrades to Speed pay clients.

Deployments to QA and UAT servers

Actively pursued testing production hot-fixes for critical production issues.

Created and Executed Manual Scripts for Web, back-end, scrape, IVR, various standard and custom crystal reports for various Speed pay clients.

Customized database, server and client settings for the install.

Tested the XML scripts for data content.

Extensively used the Quality Center tool for all the test management activities like Release Planning, Test Planning, Test case Execution, Requirement Traceability and Reporting.

Organized the test cases in Quality Center.

Copy selective databases and run database scripts relevant to the current install.

Used SQL queries to query test data for corresponding test cases.

Run test and executed reports in Test Manager.

Coordinated a 12-member offshore team to successfully implement an offshore-onsite model.

Automated the regression scripts using QTP

Tested BE processing using Notes posting, Recurring Daemons, Processing, MISC Processing, Print Module, and Crystal reports.

Also worked on critical projects involving one-time emails, recurring emails and SMS notifications.

Was involved in internal testing for projects involving ATM certification, testing middle layer changes, Config files and maintenance of servers.

Assisted Project Managers on all critical issues faced during testing.

Environment: Java/J2EE, .Net, SQL Enterprise Manager, QC 9.2, VSS, Visio, Lotus Notes, Windows XP, IIS Servers, AUTH Servers, Microsoft Outlook, Excel, MS-Visio, Citrix, alive, EFO (Clientele).

Lehman Brothers – New York Dec 2009-Nov 2010

QA Analyst

Project: Wealth Management Reporting - Data Consolidation Operations Tools is entitled to be used across business and operations teams for further levels of data integrity to be established across all downstream and WMR sub-systems. Data is captured into staging area after batch process, any data issues are resolved and uploaded for further processing and further exceptions are escalated via Exceptions Summary View with a corresponding Exception Report.

Responsibilities:

Made a detailed study of the in Requirements, Use-Case Analysis and had a Gap Analysis for SR3 and SR4 Exceptions.

Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, and Test Data for DC Prototype Tables for Pilot testing of the exceptions.

Reviewed requirements to reconcile positions for domestic and foreign assets by CUSIP and SEDOL respectively. Reconciled positions at individual account, Omnibus accounts and at asset level.

Recon breaks caused due to holiday discrepancy (global vs US), or trade reversals are aged for the holiday and expected to clear the following day.

Asset transfers (free receipts/delivers) are reconciled for units.

Run the batches in Pilot tests in Auto sys (development) environment for capturing raw sets of data.

Raised the JIRAs for resolution of issues and bugs.

Conducted FE testing for the UEM (dashboard)and Data Consolidation (Data Inquiry, Data Correction, Data Viewer and Hearsay Maintenance

Conducted, Pilot tests, Integration tests Regression, Smoke, and End-End Testing.

Coordinated team members (Developers and BAs and other QC team members) for reporting to Manager on status reports, defect management and development of tests.

Mapped the Traceability between the requirements and the test cases created in Mercury Quality Center’s Requirements-Analysis-Reports-Requirements with Coverage Tab.

Mapped the different Schemas for the tables as and when required for DB servers and connectivity in DB Artisan 81.1.1.

Worked extensively with SQL queries to validate the Batch parameters, Input, Staging, Persistent Recon, correction, Exception, Recon, for Journal, Trades, Income, Holdings and transaction for different types of exceptions on Missing Product, Price, Fx Rates, OOB, Accrual Breaks, Unsupported activity, etc.

Tested the positions, bonds and stocks, settlements, reconciliations, reporting and exception processing involved with the back-end systems.

Worked on change requests generated for SR3 release and retest the changes for a sign-off on them.

Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings with an ability to demonstrate via the UEM dashboard.

Gave final presentations of the UEM dashboard to all users of the system and Offsite coordinators.

Environment: Mercury Quality Center 9.0, Java, SQL, DB2, Oracle 9i, DBArtisan8.1.1, Autosys, Sybase, Windows XP, IIS servers, JIRA, Microsoft Outlook, Share point, BEN, MS-Office, Excel, MS-Visio and IM-live.

UMG – SONY Corporation (Time Warner), New York Oct 2008-Nov 2009

QA Tester

Project: Universal Music Group (a SONY Corporation entity) Shared Royalty Platform delivers the client service for royalty calculation, accounting, maintain/disburse royalty payments, generate client reporting statements, MIS reports, accounts and more. Worked on Alpha and Beta test strategies involving calculation of statements, records and contracts.

Environment: Mercury Quality Center 8.2, Java, J2EE, SQL Oracle 9i/10G, TOAD, XML, Windows XP, Web Application Server (WebSphere), Share point, Service Port, Lotus-i-notes, MS-Office, Excel, MS-Visio, Unix and TRACS.

iPASS, CA, India, Pune Jul 2007- Sept 2008

QA Tester

TAP, SouthBell Corporation, CA- India, Pune Feb 2006 to Jun 2007

Test Planner

Contact this candidate