Sr. QA Analyst with 11+ Years in Financial Services QA

Arati Jaiswal Kotah

Sr.QA Analyst

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

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

Phone:703-***-****

PROFESSIONAL SUMMARY

•Holding 11 years Industry experience with emphasis in Software Quality Assurance in Financial Services, Investments, Transactions and Brokerage Applications, Payment’s platform (Credit Cards and ACH), Data Migration, Sales and Billing, Ordering, Media, Telecom and Travel applications.

•Experience in Manual and Automation testing.

•Having experience in Manual testing with hands on coverage on Business Requirements, Analysis, Functional, Smoke, System, Regression, Integration, Database, Compliance testing (508), End-End Testing, for GUI and Non-GUI on systems on cross-platform (Web and client-server), websites, IVR systems applications across multiplatform testing

•Additionally performed Pilot tests, Integration, Interface testing, Negative testing, UI testing, API (Web Services), GUI, Backend testing, API testing, Database Integrity, cloud based testing,User-Acceptance (UAT) testing, and End-End testing.

•Also applied Business analysis using logic and reasoning to identify strengths and weaknesses and offer of alternative solutions, conclusions and approaches to problems with focus on QA planning, UAT planning, script writing, testing with CICD guidelines.

•Familiar with BDD and TDD frameworks.

•On the Webservices side worked on API Testing POSTMAN collections, API Automation using Rest Assured framework.

•Having experience on QA Automation with Selenium, Rest Assured, Quality Centre and exposure to Neo load.

•Worked on Selenium with Java on POM Framework, TEST-Ng and Selenium Scripts on multiple browsers

•Built POCs Cucumber framework with Gherkin.

•Experience with Data Driven Testing and Run book.

•Worked on API testing with Rest Assured scripts with Java.

•Worked with Maven, GIT, Jenkins teams for the build integration and also having knowledge about Azure DevOps and GitLab

•Good Knowledge in Core JAVA, HTML and XML.

•Worked with MuleSoft Any point Platform logs.

•Experience in working with Oracle 9i and SQL Server, DB2 and Mongo DB (NO SQL)

•Validated data validation, data migration, and reporting system testing.

•Worked with Splunk queries

•Knowledge in Playwright framework (Javascript and Typescript)

•Familiarity with prompt engineering concepts in AI

•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

•Additionally, also done deployments on QA and UAT servers, performed SIT, Risk based Testing, Requirement Ambiguity Testing, Database testing using SQL Testing, and Migration Testing and Multi Browser Testing.

•Worked as Team Lead and adept with Project management and STLC starting with QA processes and Software Engineering Methodologies like SDLC, CMM and Agile methodologies (Scrum status, Daily Status and Test Progress Reports).

•Understand the requirements of clients and subsequently draw the estimates and metrics, plans and strategies, schedules and preparation of demos from the inception of project.

•Used Quality Center tool for all the test management activities like Release Planning, Test Planning, Test case Execution, Requirement Traceability and Reporting with attention to ITIL.

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

•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.

•Creating WBS (Work Break Schedule). Assignment of resource, tracking and team mentoring.

•Resolution of defects and tickets (setting up triage meetings if necessary) as a part of problem management.

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

•Lead the QA testing team to manage testing schedules and communicate testing progress (standard-daily and custom reports).

•Experience recommending and implementing best practices to improve quality engineering workflows

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

•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.

•Performed troubleshooting to resolution of production problems.

•Maintained Training Material Documentation

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

EDUCATION DETAILS:

MTech (Computer Sciences) - JNTU Campus – Hyderabad. (2001)

B.E (Electronics and Telecommunication)-JNEC- Marathwada University. (1991)

TECHNICAL SKILLS:

Automation Testing

QTP/UFT, Selenium WebDriver with Java, JUnit, TestNG, REST Assured,

Cucumber, Playwright(Typescript and JavaScript)

Automation Framework

Data Driven, POM, Keyword Frameworks

API Testing Tools

REST Assured, Postman, SOAPUI/Ready API

Project Management and bug tracking tools.

JIRA, Confluence, HP-ALM, QC, Zephyr (JIRA plugin), XRay,Test Manager and Bugzilla

Performance Tools

JMeter, LoadRunner

Primary Languages

Java

CI/CD (Continuous Integration)

Jenkins

Version Control Tool

Git, SVN, VSS

Web Technologies

HTML, CSS, JavaScript, XML

Database

MySQL, PostgreSQL, PgAdmin and SOQl Queries, Oracle.

Build Management Tools

Maven

PROFESSIONAL EXPERIENCE

Verizon, GA

April 2023 – Till Date

Sr.QA

Project: Working on VBG-WLN project on E-E testing for Commercial and Federal EIS customers. Project involves the validation of Finops approval of MSA contracts for Business Support Systems (BSS) install services for 4g/5g for Access, Broadband, PIP, CPE products and services for E2E workflow testing and validation of account creation, to quoting, ordering management, billing, provisioning to approval of Vz contracts to other downstream systems like fesp (inventory details) to downstream systems.

Responsibilities:

•Validated the E2E flow for full blown functional, integration, systems testing, UI Testing starting with the presales requirements, adjusting the Test plans and Test strategy within the scope of testing for the sprint timelines, getting approval of test cases, and facilitating the data environment switch overs and data provisioning

•Pre validation testing done to see all the systems are ready, data loading for the environment under switch over and data provisioning.

•Testing involved testing the upstream systems by creating quoting-pricing-ordering-provisioning, billing-Finops Approval.

•Running system tests for simulation/activation/provisioning process

•Data validation done using SQL.

•E2E testing involved POSTMAN testing for quote generation issues to validate the response payloads (e.g., account IDs, quote IDs).

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

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

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

•Automation involved Selenium with Java for regression suites using FAST framework.

•Executed Automation scripts for GitHub to integrate with Jenkins pipeline for CICD for regression tests.

Environment: Agile, JIRA, Java, Postman, JSON, XML, Oracle/SQL, Confluence pages, Jenkins Pipeline and Maven.

MuleSoft, GA

May 2020 – Mar 2023

Sr. QA

Project: 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, Salesforce needs to show what consumer products, promotions, accounts, orders, order history, management and lifecycles, billing and payments, service availability, adjustments, consent preferences and messages potentially available at a location to be purchased, for a total case lifecycle. This is facilitated through middleware MuleSoft Any point platform integration (which retrieves data from various backend systems and data is transformed and exchanged to match Salesforce format for the C360 view.

Responsibilities:

•Working on understanding the manual migration requirements.

•Analyzing the requirements with the user stories, Exchange (RAML design) and worked with prebuild teams for API testing, Backend testing, test data and expected results.

•Verify manually the functionality using API requests return expected responses using POSTMAN with endpoint validation of HTTP status codes, response times and JSON format and schema mapping and verification of Data Flow Validation for data formats and accurate data.

•Worked on acquiring test data through various back-end systems by raising data requests to backend teams, through ATT portals to suit the needs and maintain test data copies for all environment changes.

•Additionally, validated the mocked request- response data through service virtualization and tested the POSTMAN RR pairs.

•Performed the functional testing with JSON/XML request and response and data validation via POSTMAN webservice APIs by validating the application against the MuleSoft ESB build & services logs tracing the flow between SAPI, PAPI and EAPI layers.

•Run the parameterized automation APIs using Newman to run the batch files for dev, QA, SIT, STG and UAT environments.

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

•Verified the data transformation, converting raw backend data into a structured format for MuleSoft/SF using the mapping and transformations.

•Validated the Salesforce workbench objects by checking the data transformation using SOQL Queries on both the Source and Target to validate data for upsert of records.

•Data validation of BE DB using SQL queries for data.

•Automation of Test cases through Run Book data using Rest Assured framework for Sanity and Regression testing using Jar file for execution using Rest Assured-Java.

•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, Exception classes, Test Class and Main class to create methods and Test Report in html format.

•Used JavaScript for writing the pre-validation checks in Postman.

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

•Overlooked and participated in load testing in JMeter.

•Been a part of Compliance Testing (508) Team using ANDI and JAWS

•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 for a Go/No-Go sign off.

•Used Maven and Jenkins for CICD collaboration.

Environment: Java1.8, SQL, REST Assured Framework (3.2.0), MuleSoft (4.30), SOQL workbench, JAWS,ANDI, Azure RTF, AWS, JIRA, Webservices, Postman-(8.12.0), Selenium, TestNG (6.14), JUnit, JSON, XML, Jenkins Pipeline, Maven (3.0.3), Java, GIT, JIRA, Agile.

Hertz, Estero, FL

Jan 2018 – Apr 2020

Sr.QA Tester/Lead

Project: Working for InFact-Digital to automate their web application using 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, Concur, Localiza, and Seamless for ESB integrations.

Responsibilities:

•Working on understanding the manual requirements along with Business involving eCommerce element around loyalty programs, offers, and transactional integrations in the travel and mobility domain.

•Test and validate RESTful APIs exposed by MuleSoft services allowing to explore endpoints, verify request/response schemas, and ensure RAML adherence early in the development lifecycle.

•Identifying the manual test cases to run the functional and unit tests in POSTMAN to verify responses of webservices.

•Verified Inbound, Outbound, Queues, and ETL data transformations and stored procedures.

•Reconcile data between source systems, staging areas and the target systems.

•Worked on Membership & Rewards flows, voucher Promotions and offers and vehicle reservations using Chained workflows in POSTMAN.

•Worked with POSTMAN to run a set of integrated tests between systems.

•Worked on Splunk queries.

•Connected and Automated end-to-end UI flows using Selenium WebDriver

•Automation of Java based REST Assured framework for API testing.

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

•APIs also asserted by doing data validation against databases using SQL •

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

•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.

•Assisted on Digital production on hand-offs.

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

•Developed Splunk pages in Selenium for automation of Splunk queries.

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

•Used GIT for version control and to transfer files from local to remote repos.

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

Charter Global, Atlanta, GA

Dec 2014-Nov 2017

Testing Team lead

Project: 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:

•Managed work on both Manual and Automation Testing.

•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).

•Used Eclipse. IntelliJ and VS Code to write and debug code.

Focused on setting up the Automation Environment Setup Using Eclipse in the IDE, Java, Selenium WebDriver and TestNG jars for the Selenium IDE for the POM framework (POM) for Cross Browser testing requirements.

Also enhanced the framework for Data Driven testing to retrieve test actions, test data from Excel files.

Tested UI components for functionality, responsiveness, and cross-browser compatibility across Chrome, Firefox, Edge, Safari

•Worked on adding the reusable components like OR, Accessory files for data, addons like firebug, fire path, reports through the TEST-NG framework and HTML reports to the framework.

•Connected and tested Postgres database with pgAdmin for retrieval of data.

•Coordinated with the Integration with Maven and Jenkins teams.

•Knowledge of all the key components of Azure Dev ops (Azure Boards, Azure Repos, Azure Test Plans, Azure Artifact) for software development cycle

Conducting browser testing and parallel test execution and sent the reports to users.

•Preparing metrics for clients like defect density sheets and status reports.

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

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

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

•Participated on LoadRunner for load and performance testing.

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

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

Western Union – New York

Dec 2013 to Nov 2014

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, IVR and check Payments and reporting on BI reports.

Responsibilities:

•Analyze user/business requirements and develop detailed test cases based on requirements for Interface testing and User Acceptance Testing for changes/upgrades to Speed pay clients.

•Deployments to QA and UAT servers

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

•Copied and customized the selective databases, client settings and run database scripts relevant to the current install.

•Tested the XML scripts for data content.

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

•Worked with Credit cards, Debit cards and Merchant Processing using the Speed pay Platform.

•Tested and validated SWIFT (MT/MX) and payment message formats for credit/debit flows

•Run test and executed reports in Test Manager.

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

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

•I also worked on critical projects involving one-time emails, recurring emails and SMS notifications.

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

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

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

•Participated in all meetings involving LoadRunner

•Assisted Project Managers on all critical issues faced during testing.

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

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

•Assisted Project Managers on all critical issues faced during testing.

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

Lehman Brothers – New York Dec 2012-Nov 2013 QA Analyst

Project: Wealth Management Reporting - Data Consolidation Operations Tools entitled the migration of data from old systems to new systems, 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),cut offs,tax/FX rates 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.

•Also tested the mutual funds and annuity products including variable annuity for advisor and Subadvisor clients.

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

•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, Fix Rates, OOB, Accrual Breaks, Unsupported activity, etc.

•Validated system testing, integration testing, data migration testing, data integrity testing, and data transformation-related testing between the systems and the Front end

•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.

•Interfaced with Retail banking for seamless, secure, and compliant financial services.

•Maintained Test Logs, Test Summary reports and participated in defect review / Status / GONOGO 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 MLive.

UMG – SONY Corporation (Time Warner), New York Oct 2011-Nov 2012 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.

Contact this candidate