Quality Assurance Saint Louis

NITIN AGARWAL

Phone: 640-***-****

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

EXPERIENCE SUMMARY

Sr. QA professional with over 16 years of IT experience in Quality Assurance

Domain experience includes Banking application, Credit card application, Retail Applications and Web based applications.

Experience in Manual Functional, Regression, UAT and database testing.

Experience in Software Development Lifecycle (SDLC), Agile, Test Data, Test Environment and Test Management.

In-depth knowledge of V-model testing process.

Over 4 years of experience in leading and mentoring testing team

Responsible for coordinating meetings, leading projects and to create formal presentations.

Created and executed test scripts and test cases for validation of Business & Technical requirements.

Executing SQL queries in SQL*Plus.

XML data validation in UNIX sandbox

Currently carries Moderate Federal Security Clearance.

TECHNICAL SKILLS

Languages

SQL, VB, XTML and HTML

Operating Systems

Windows 7/Vista/XP and Unix

Tools

Quality Center, IBM Rational Suite (Requisite Pro, Rational Manual Tester, Clear Quest, Clear Case), AS400, SOAPUI, JIRA and Oracle

EDUCATION

University of Missouri Saint Louis, Saint Louis, MO

Bachelor of Science in Accounting, Dec 2008

Major: Accounting

Saint Louis University, Saint Louis, MO

Bachelor of Science in Business Administration, Aug 2003

Major: Finance, Management and International Business

PROFESSIONAL EXPERIENCE

TIAA - New York City, NY Jan 2024 - Present

Lead QA Tester

Diagnosed and troubleshoot technical problems faced by users.

Integrated Karate tests into CI/CD pipelines using Jenkins or Azure DevOps to ensure automated testing in the deployment process.

Strategized and negotiated individualized payment plan options.

Generated monthly consignment payment report and transmitted payments to artists.

Developed and maintained automated test scripts to ensure comprehensive test coverage.

Developed and executed comprehensive performance testing strategies using LoadRunner to assess application scalability and reliability under various load conditions.

Developed and maintained an automated testing framework using Selenium WebDriver and Python to increase in test coverage and reduction in manual testing efforts.

Created SOAPUI/Postman Request for functional Test cases and JMeter for QA Performance Testing.

Conducted API testing and integrated TOSCA with tools like Postman and SoapUI for end-to-end validation of web services.

Designed and executed tests for Node.js APIs, validating endpoints for functionality, data accuracy, response times, and error handling using tools like Postman or REST Assured

Developed and executed test cases for Business Process Management (BPM) workflows, ensuring smooth end-to-end process validation.

Developed and maintained automated test scripts using Python and testing frameworks such as PyTest or unittest, ensuring efficient regression testing.

Developed and executed complex SQL queries and PL/SQL scripts to validate data integrity, ensuring accurate testing of database functionalities.

Integrated UFT with ALM tools to manage test cases, track defects, and facilitate reporting.

Developed and executed comprehensive test plans and test cases for ServiceNow modules.

Developed custom Appium commands and extensions to handle complex user interactions and enhance test capabilities.

Executed end-to-end testing of SAP HANA applications, ensuring integration across modules and validating data accuracy and reliability.

Developed comprehensive test plans, test strategies, and test schedules for mainframe applications.

Integrated automated tests with CI/CD pipelines using tools like Jenkins or GitHub Actions to ensure continuous testing of the codebase.

Developed comprehensive test plans and strategies for REST APIs to ensure functionality, performance, and security.

Designed and executed test scenarios to verify the functionality of SWIFT message flows.

Worked on JMeter for Creating Web Test scripts, creating scenarios and Test Executions

Developed ETL/ELT processes to ingest and transform data from various sources into Snowflake, utilizing tools like Apache Airflow or AWS Glue.

Developed and maintained automated test scripts for mobile applications using Appium, enhancing testing efficiency and coverage.

Developed comprehensive test plans for Quadient applications, focusing on document generation, customer communications, and workflow automation.

Designed validation test cases and scripts based on requirements, specifications, and design documents.

Integrated TOSCA with project management tools like Jira, enabling real-time defect tracking and updates.

Developed automated test scripts using tools like Kafka TestKit and REST APIs to simulate various producer-consumer scenarios, enhancing testing efficiency.

Automated tests for mobile applications, leveraging Worksoft Mobile Execution to validate functionality across diverse devices and OS versions.

Developed and executed detailed test cases for ServiceNow modules, ensuring functionality, reliability, and compliance with business requirements.

Automated regression tests for SWIFT payment workflows using tools like Selenium and Postman

Conducted functional, integration, system, and regression testing for batch and online mainframe processes.

Designed and implemented customized workflows in Jira to align with project requirements and improve tracking of tasks and issues.

Developed test plans and strategies for J2EE applications, ensuring comprehensive coverage of functional, integration, and performance testing.

Used Visual Studio & Android Studio code to write the JavaScript/TypeScript/python to run them using Protractor integrated terminal.

Performed database testing by verifying data migrations, transformations, and back-end processes using PL/SQL queries.

Designed, developed, and maintained automated test scripts using Astra Automation to streamline testing processes.

Tested and performed Oracle database load testing to verify the slow response queries to suggest the DBA teams to fix with Indexes.

Environment/Tools: IBM RPT 9.1, JMeter, Protractor, Dynatrace, VSTS JIRA, Selenium WebDriver, RFT, Cucumber, Oracle, Visual Studio Code.

Save–A-Lot - Kansas City, MO April 2022 – Dec 2023

Lead QA Tester

Performed Smoke, End to End, Functional, Integration, Sanity, Regression, Cross Browser, System Testing and Ad- hoc testing for Web Applications, Mobile MEW and Mobile Apps.

Experience in Real Device Testing, Usability Testing, Device Emulation and Device Simulation for Mobile App with strong knowledge of Agile Software Development Life Cycle.

Managed QA efforts for mobile and web-based applications within the SimCorp ecosystem, ensuring a seamless user experience across platforms.

Integrated LoadRunner tests into CI/CD pipelines to ensure performance testing is part of the continuous testing process.

Designed dimensional and relational data models in Snowflake to support business intelligence and analytics initiatives, ensuring data integrity and accessibility.

Developed and maintained robust and scalable web applications using JavaScript, TypeScript, Node.js, and React.js, achieving improvement in application speed and responsiveness.

Conducted integration testing to verify data exchange and communication between Kafka brokers, consumer groups, and other applications.

Developed and maintained automated test scripts using Python, enhancing test coverage and reducing manual testing effort.

Designed, developed, and executed test cases for REST, SOAP, and JSON-based APIs integrated with mainframe systems.

Collaborated with product, development, and UX/UI teams to validate interactive elements, rich UIs, and Web 2.0 components, ensuring they met usability and accessibility standards.

Conducted regression testing of PL/SQL-based components after system updates and enhancements.

Implemented automated testing scripts using tools like Selenium or ServiceNow Automated Test Framework (ATF) to enhance testing efficiency and coverage.

Designed and implemented test strategies for batch processing workflows to ensure data integrity and accuracy throughout the ETL lifecycle.

Conducted performance testing on Windows applications to assess responsiveness, stability, and scalability under load.

Integrated Worksoft Certify with CI/CD pipelines using tools like Jenkins, enabling continuous testing and faster delivery cycles.

Tested API interactions between mainframe applications and cloud-based systems (AWS, GCP, Azure).

Created and executed detailed test cases for various J2EE components, including Servlets, JSPs, EJBs, and web services.

Developed and maintained automated test scripts for SAP HANA

Developed and maintained automated test scripts using RestAssured, enhancing test efficiency and reducing manual testing efforts.

Conducted manual testing for embedded systems, ensuring robust performance and compliance with specifications, achieving a defect-free launch.

Implemented Infrastructure as Code practices using tools like ARM templates or Terraform within Azure Pipelines to provision and manage cloud resources automatically.

Designed and executed test plans and strategies to validate application functionality, integration, and regression.

Performed performance testing on high-traffic, content-heavy sections, ensuring Web 2.0 elements-maintained stability and responsiveness under load.

Implemented eCommerce features like shopping cart, checkout, and user profile management in a React-based web application, increasing the purchase conversion rate.

Implemented data-driven testing capabilities using Karate’s built-in features to validate API responses against multiple datasets.

Conducted testing of database operations, including CRUD functionalities, ensuring data integrity and accuracy.

Automated mainframe API test cases using Postman Collections and integrated them into CI/CD pipelines using Jenkins.

Reporting and reviewing bugs in ALM, JIRA & SNOW.

Strong hold on the Retail Domain & Banking services with testing support of Wholesale and Retail Pricing and Promotions. Special pricing options such as coupons, seasonal discounts, holiday discounts and end of the year discounts were also created and tested on the front-end dashboard for various grocery items.

Developed custom test reports using PL/SQL to track and analyze test coverage and defect trends.

Developed documentation for Snowflake architecture, data models, and query optimization strategies, promoting best practices within the team.

Automated BPM workflow testing using tools like Selenium, TestNG, and JUnit, significantly reducing manual testing effort and improving test coverage.

Developed comprehensive test plans and test scripts in JMeter, including setting up thread groups, samplers, and listeners to simulate different user scenarios and load patterns.

Implemented data-driven testing approaches in Cypress to validate application behavior with various input sets.

Implemented end-to-end business process validations using Worksoft Certify, ensuring seamless integration across SAP modules and non-SAP systems.

Implemented automated testing frameworks like JUnit, TestNG for regression and functional testing of J2EE applications.

Developed and maintained automated test scripts using PowerShell to streamline regression testing and enhance testing efficiency.

Experience in testing with a wide variety of projects and environments like Java, SQL server and Oracle.

Developed Python scripts for performance testing and monitoring, analyzing system behavior under various load conditions.

Managed Input and Output results of API response in excel spreadsheet.

Created and Verified Web services API requests, and SOAP Protocols.

Applied data-driven testing strategies in TypeScript to run tests with various data sets using tools like Jest or Mocha with custom data providers.

Involved in validation of Test Environment for Web services Testing.

Involved in functional specification documents to develop test cases and test scenarios in JIRA.

Found and logged defects in the JIRA defect tracking tool.

Environment/Tools: Save a Lot Portal test, ALM, API-POSTMAN (XML), SQL, ADO, AS400, Power-BI, EDI files, AZURE, Oracle, ServiceNow and JIRA.

H&R Block– Kansas City, MO Oct 2021 – Apr 2022

Mobile Tester

Strong familiarity with iPhone and Android operating systems and applications

Experienced with testing across multiple mobile and web operating systems.

Experienced with log file investigation and device configuration.

Terrific ability to work in a fast-paced agile environment.

Solid understanding of Consumer Banking rules and regulations

Integrated automated testing frameworks (e.g., Selenium, JUnit, or NUnit) into Azure Pipelines to run tests as part of the build process, ensuring high code quality.

Exceptional time management and multi-tasking abilities

Automated the setup and configuration of test environments through PowerShell scripts, ensuring consistency across multiple testing sessions.

Developed and executed test plans for a J2EE-based e-commerce application, ensuring high-quality deliverables.

Developed comprehensive test plans and strategies for configurator order flow to ensure thorough coverage of all features and functionalities.

Built and maintained automated test scripts for ServiceNow applications, reducing manual testing efforts and increasing test coverage for critical workflows.

Developed and maintained automated test scripts for mobile applications using Appium, covering both Android and iOS platforms.

Developed and maintained automated test scripts using Cypress for web applications, ensuring comprehensive coverage of user journeys.

Designed and executed business process change impact assessments using Worksoft Certify to validate system behavior after updates or patches.

Developed and maintained automated test scripts for PAR Brinks POS software using tools like Selenium or Appium to ensure robust testing processes.

Tested ETL processes by writing PL/SQL scripts to verify data extraction, transformation, and loading.

Performed comprehensive testing of backend APIs, verifying response formats, status codes, and data validation using tools like Postman or the Karate framework.

Excellent written and verbal communication skills

Conducted integration testing of Endur with other ETRM systems and third-party applications to verify data consistency and workflow integrity.

Developed and executed comprehensive test plans and test cases for Node.js applications, ensuring functionality, performance, and security of back-end services.

Developed and executed comprehensive test plans for React.js applications, ensuring functionality, performance, and security of interactive UI components.

Performed integration testing of hardware and software components, ensuring seamless interaction and performance of embedded systems.

Executed performance tests on batch processes to identify bottlenecks and optimize execution time, utilizing tools like LoadRunner or Gatling.

Developed and maintained automation frameworks using tools like Postman, Rest Assured, or SoapUI to facilitate API testing.

Highly passionate about mobile apps platforms design and development

Developed performance test scripts in TypeScript with tools such as Artillery or k6 to assess application performance and scalability.

Involved in validation of Test Environment for Web services Testing.

Integrated AWS services with test management tools (e.g., JIRA, TestRail) to streamline test case management, defect tracking, and reporting.

Wrote test cases and test scenarios in ALM for POSTMAN testing.

Updated Traceability Matrix Document per project needs.

Environment/Tools: Experitest, Blockapp, ALM, API-POSTMAN (XML), SQL, AZURE, SLACK, BROWSERSTACK and JIRA.

Federal Reserve Bank – Kansas City, MO Feb 2018 – Aug 2021

Senior QA Tester

Develop, document and maintain test artifacts like test data and data validation.

Execute test scripts using HP Quality Center.

Designed and executed performance tests using Apache JMeter to assess application behavior under various load conditions and identify potential bottlenecks.

Designed and implemented Azure Pipelines for CI/CD processes, reducing deployment times by 50% and improving overall application stability.

Conducted comprehensive end-to-end testing of business processes implemented in Newgen iBPS to ensure seamless workflow execution.

Conducted end-to-end performance testing on SAP systems, including SAP HANA and SAP S/4HANA, ensuring that applications met speed, stability, and scalability requirements.

Performed API testing for applications on SAP BTP, validating seamless integration between SAP and third-party applications using SAP Integration Suite.

Developed data mapping strategies and executed data migration from on-premises systems to Oracle SaaS, ensuring data integrity and completeness.

Conducted end-to-end testing of React applications with Cypress, ensuring all user interactions and workflows performed as expected across different scenarios.

Developed and executed end-to-end test scenarios that encompass the entire batch processing workflow, validating data flow from ingestion to output.

Worked with BPM platforms like Appian, Pega, IBM BPM, Oracle BPM, and Camunda to test and validate end-to-end workflows.

Created PowerShell scripts to monitor system performance and log application behavior, assisting in identifying potential issues during testing.

Developed a scalable test automation framework for Quadient's document automation platform to reduce testing time.

Developed comprehensive test plans for Java APIs, including functional, regression, and performance testing strategies.

Integrated Appium with test frameworks such as TestNG, JUnit, or Cucumber to create comprehensive, end-to-end test scenarios.

Integrated automated tests within CI/CD pipelines using tools like Jenkins or GitLab, ensuring Node.js code quality and stability before deployments.

Create and track bugs and generate bug reports using HP-Quality Center.

Developed and executed data-driven test cases to validate SHAW Application functionalities with various loan products, terms, and customer profiles.

Managed configuration files and environment variables for microservices to ensure proper deployment and testing across environments.

Managed the deployment and administration of Tableau Server, ensuring data governance and access control for published dashboards.

Maintain the regression suite and oversee regression testing each release cycle.

Maintain and update test documents on shared drive and share point sites for audit and compliance purposes.

Developed and executed automated test scripts for Newgen iBPS applications using tools like Selenium or UFT to improve testing efficiency and coverage.

QA and UAT testing and other test environment validation for a very large projects such as TITAN (TAAPS), SNC, Unified Intake and FEDNOW which involved an upgraded web-application for Treasury client.

Worked upon process documentation of ALM to JIRA Data migration which involved- Basic CSV export to get data out of ALM, and CSV import to import the data into Jira Cloud.

Developed and tested serverless applications using AWS Lambda and AWS API Gateway, including creating and managing test cases for serverless architectures.

Integrated Python-based test automation into CI/CD pipelines using Jenkins, enabling automated test execution and faster feedback loops.

Analyze migrated data for data quality and integrity using available tools like Beyond compare, Excel.

Monitor import, export and sync jobs. Configure JIRA projects, JIRA customizations and related applications.

Easily adapt to changes including project changes, timelines, and resources.

XML data validation in UNIX sandbox

Environment: SQL, ALM, API (XML) and JIRA.

Wells Fargo - St. Louis, MO Jan 2017 - Jan 2018

UAT Test Lead

Develop, document and maintain test artifacts like test data and data validation.

Created and executed detailed test cases to validate Java API functionality, ensuring adherence to business requirements and specifications.

Created and executed detailed test cases specifically for the configurator order flow, covering various customization options and user scenarios.

Managed change management processes, including training sessions and user support, to ensure smooth transition and adoption of Oracle SaaS solutions.

Designed and implemented test automation solutions using the Karate framework for RESTful APIs and web services.

Developed and executed detailed test plans and cases for Bluetooth functionality, validating interoperability across various devices and platforms.

Developed and executed detailed test plans and cases for HTML5 applications, ensuring compliance with web standards and cross-browser compatibility across various devices.

Developed and maintained automated test scripts using C# with frameworks like NUnit or MSTest to ensure software quality.

Developed and managed realistic test data sets to ensure comprehensive test coverage for batch processing scenarios.

Integrated Cypress tests into CI/CD pipelines (e.g., Jenkins, GitHub Actions) to ensure automated testing during the build and deployment processes.

Developed and maintained robust test automation scripts using Selenium WebDriver, ensuring comprehensive test coverage for web applications.

Developed and executed a document migration strategy that successfully transferred documents to a new management system, ensuring 99% accuracy in data integrity.

Developed comprehensive test plans and strategies tailored to Allegro’s ETRM functionalities to ensure software quality.

Designed and developed test automation frameworks using TestNG to improve the efficiency and effectiveness of automated testing.

Attend project meetings and communicate with project team including project manager, development, business partners about testing deliverables and any issues that may hinder meeting testing deadlines. Also provide regular test status reports and defect reports.

Integrated Tableau with other tools and platforms (e.g., Salesforce, Google Analytics) to enhance data storytelling and provide a comprehensive view of business performance.

Documented API testing processes and maintained updated documentation for future reference.

Ensure successful delivery of final content by the testing deadline including test sign off reports, any outstanding defects and how they would be handled, and hand off to UAT.

Evaluated Bluetooth range capabilities by testing connections in various environments to determine maximum effective distances and signal integrity.

Upon testing completion, identify test cases (both manual and automated) that would be added to the regression test suite.

Work on multiple projects at one time and deliver high quality results within project timelines.

Tested integrations with cloud services and microservices deployed in PCF, validating communication and data exchange between components.

Utilized Chrome DevTools to perform functional testing of web applications, ensuring compliance with design specifications and user requirements.

Maintain and update test documents on shared drive and share point sites for audit and compliance purposes.

Implemented backup and disaster recovery solutions using AWS Backup and AWS S3, ensuring data integrity and availability for test environments.

Develop strategies for process improvement and identify areas of improvement, increasing efficiencies in time spent on test execution which would reduce overall testing costs.

QA, UAT testing and production validation for very large projects (Wires-Retail, IRA, Checks, ACAT and ACH) which involved the seamless migration of >1 million online banking customers from QM to BPM over a 2-year period.

Conducted functional, usability, and performance testing of interactive HTML5 to ensure a seamless user experience.

Tested Bluetooth functionality across a variety of devices to ensure seamless connectivity and data exchange.

QA, UAT and Regression testing on various E Commerce/Merchant services applications such as Point of Sale (Clover POS Station and Clover Station Duo), Mobile Credit Card Processing Machine (Clover®-1 GO- Mobile Card Reader), Independent Hand-Held Portable Credit Card Processing Machine (Clover-Flex), Countertop in Store Credit Card Processing Machine (FD150 Terminal) and Payment Getaway (WooCommerce Payment Getaway)

Train newly hired employees and assist fellow team members with debugging failed test cases.

Easily adapt to changes including project changes, timelines, and resources.

Environment: SQL, Version1 (Project Management Tool), ALM and JIRA.

USDA - St. Louis, MO Jun 2016 – Dec 2016

Senior QA Tester

Loan Insurance data testing included Hurricane coverage, Flood Coverage, Wildfire coverage General natural calamity and Common crop insurance.

Created calculated fields and parameters to derive new insights and enhance the interactivity of Tableau visualizations, improving user engagement.

Designed and implemented reusable test frameworks in C# to enhance testing efficiency and maintainability.

Conducted both manual and automated testing of Allegro modules, identifying and documenting defects for resolution.

Developed comprehensive test plans and strategies for Salesforce implementations, focusing on functional, integration, and user acceptance testing.

Developed Jython-based test scripts for performance testing of Java applications using tools like JMeter.

Utilized testing frameworks like JUnit or TestNG for unit and integration testing of Java APIs.

Developed and implemented comprehensive test strategies for microservices architecture, focusing on unit, integration, and end-to-end testing.

Developed and maintained automated test scripts and frameworks using Java, including using popular libraries such as JUnit, TestNG, and Selenium WebDriver.

Leveraged AWS S3 for storing and managing test data and artifacts, ensuring secure and efficient data handling.

Developed and maintained automated UI tests using Espresso and UI Automator in Android Studio, enhancing the efficiency and reliability of the testing process.

Comprehensive knowledge of database management systems, SQL Queries, and UNIX

Created and executed detailed test cases and test scripts for Salesforce features, including Sales Cloud, Service Cloud, and custom applications.

Performed integration testing, functional testing, user interface testing, section 508 compliance, accessibility and data testing.

Extensive knowledge of software design life cycle and database testing procedures.

Responsible for acting as a liaison between the integration testing team and the production environment testing team (TCO).

Skilled in communicating technical information in an accurate and precise way.

Assigned the tasks of documenting test results by following standard procedures and guidelines.

Well versed in analyzing Results, Bug Tracking & Bug Reporting in JIRA and ALM.

Responsible for developing test plan and test strategy procedures by coordinating with Architect.

Environment: SQL, ALM, JIRA, JUnit, TestNG, Selenium

US Bank - St. Louis, MO Oct 2013 - May 2016

Senior QA Tester

Assisted in analyzing business process data and creating reports that were presented directly to management.

Assisted in creating presentations that were used to persuade management to consider more efficient business methods.

Also Tested various types of non-mortgage related loan applications for Retail Loans, Commercial loans, Personal loans and Credit Card Cash advanced loans.

Managed Oracle Database environments, ensuring high availability, performance tuning, and security compliance.

Developed and executed comprehensive test plans and test cases for CSS3-based web applications, ensuring adherence to design specifications and cross-browser compatibility.

Implemented and maintained CI/CD pipelines in PCF to automate testing and deployment processes, ensuring rapid and reliable releases.

Maintained thorough documentation of test cases, test results, and automated testing processes using C#.

Implemented Jython scripts to simulate complex user workflows, improving test case realism and coverage.

Developed and maintained automated test scripts using Visual Studio Test (VSTest) and frameworks like MSTest and NUnit to improve testing efficiency and reliability.

Developed and wrote test-plans, acceptance criteria, test scenarios and test-cases for interface testing between Sales force and Net Oxygen on various web browsers such as IE, Chrome, Firefox, IOS and Android.

Developed and maintained automated test frameworks using tools like Selenium, JUnit, or NUnit to streamline regression testing for microservices.

Designed and implemented comprehensive test strategies for RESTful and SOAP APIs, ensuring thorough coverage of endpoints.

Developed and executed detailed test plans and strategies for EKA’s ETRM functionalities to ensure comprehensive test coverage.

Knowledge of underwriting standards for Qualified Mortgage loans (Fannie Mae –DU and FHA/VA/USDA).

Verified Terminal Branch POS system compatibility with peripherals such as Card Reader, Bar Code Scanner, Printer, Scanner, Cash drawer and other Interface devices.

Designed and maintained modular test scripts in Worksoft Certify, enhancing reusability and reducing maintenance efforts.

Developed and executed automated tests using AWS Lambda for serverless testing and AWS CloudFormation for provisioning infrastructure.

Designed and implemented robust test automation frameworks in Java, integrating with tools like Maven or Gradle for build and dependency management.

Responsible for identifying and isolating

Contact this candidate