Quality Assurance Analyst

Manish Mandavia

**************@*****.*** Cell: 603-***-****

SUMMARY

Software Quality Assurance Analyst with over 18 + years of IT experience in Financial, Insurance and Retail business domain, specializing in Manual Quality Assurance Testing and Software Test Automation development and maintenance following SDLC (Software Development Life Cycle).

Strong analytical expertise in developing test strategies comprised of Test Plans, Test Cases, Test Scenarios, Test Scripts, Test Reports following STLC (Software Testing Life Cycle).

Extensive experience working on different Test Methodologies Using Agile Scrum, Kanban, and Waterfall.

Extensively worked with the Agile team and contributed on behalf of QA team during the scrum, user stories parting, user story point allocation and in retro meetings at the end of the sprint.

Experience with developing and executing complex Functional, Integration, UAT and Regression test cases.

Performed various types of Testing including black box/functionality testing, system integration testing, regression testing, compatibility testing, security testing,

Experience Testing on Conversion Projects and Integration Projects using technologies like DataStage and Informatica.

Experienced working on different Financial Applications for Capital Market, Wealth Management, Investment Portfolio Management, Transfer Agency, Corporate Actions, Credit Card Application etc.

Experience testing Property and Casualty application for the Homeowner Insurance domain.

Experienced working with POS system testing.

Experience analyzing Business Requirement, System Design Specification, and Functional Requirement Specification.

Ability to create Test Cases and multiple business scenarios to test different levels of Business Complexity.

Mentored Test Engineers in understanding the process and the complexity of the application.

Good Experience in working with different team sizes, work culture and different positions within QA groups.

Able to learn new tasks quickly and offer flexibility working on multiple assignments.

Provided complete Coverage of the testing phase to ensure the project is done within time and budget. This becomes a handy mechanism whenever high reliability is expected.

Possesses superior Problem Solving, Analytical, Communication and interpersonal skills, an enthusiastic, fast learner and effective in developing efficient solutions.

Experience working in Agile fast paced environment.

TECHNICAL EXPERIENCE

Platforms:

Windows 10, Linux, iOS, Android

Languages:

Visual Basic, C, C++, SQL, Python

Automated Testing Tools:

WinRunner, QTP, UFT, TestComplete, Cypress, Postman, Jason, XML

Defect Tracking Tools:

Test Director, Tempest, Mantis, Quality Center, HP ALM, JIRA

Database:

Oracle, MS SQL Server, MySQL

Test Management Tools

JIRA XRAY, Silk Central, Quality Center, HP ALM

FTP Tools:

FTP, Telnet, TCP/IP

ERP Packages:

SAP FICO, SD

PROFESSIONAL EXPERIENCE

Plymouth Rock Assurance

Sr. Quality Assurance Analyst November 2024 – May 2025

Performed Functional Systems Testing on Automobile Insurance Policy covering Policy Renewals for six months and twelve months business scenarios.

Analyzed business requirements and translated them into effective manual test cases for policy and endorsement testing.

Conducted end-to-end manual testing of underwriting processes, customer details, and risk assessment workflows.

Led planning, coordination, and execution of User Acceptance Testing (UAT) across multiple enterprise-level projects.

Designed and maintained detailed UAT test plans, scenarios, scripts, and documentation by analyzing Business Requirement Documents (BRD) and System Requirement Documents (SRD).

Planned and executed Regression Testing to ensure stability and compatibility of updates in insurance systems.

Designed UAT policy life cycle scenarios, including new business, renewal, cancellation, and reinstatement processes.

Checked compliance with state-specific insurance regulations by validating published policy documents and endorsements.

Collaborated with cross-functional teams and led UAT testing for multiple projects and performed gap analysis in manual testing coverage and ensured comprehensive SQA process.

Created and executed test cases for various endorsements, customer information, Coverage, driver information, vehicle information, to cover around the corner and out of sequence transaction scenarios.

Performed testing on Billing Systems testing different payment methods and payment options including IVR, Credit card, EFT etc.

Performed Root Cause Analysis (RCA) on critical defects, ensuring timely issue escalation and resolution in collaboration with development teams.

Actively participated in Agile Scrum ceremonies, providing QA input for sprint planning, backlog grooming, and feature validation.

Performed testing on Policy documents Publishing for renewals and non-renewal policy scenarios. Validated different published forms, policy documents, letters generated using XML files and generated physical forms for various states like NJ, NY, PA etc.

Created new and expanded existing test cases to cover Billing and Policy changes.

Maintained test case repository and reported defects using HP ALM.

Generated test execution reports using HP ALM.

VJS Inc.

Sr. Quality Assurance Analyst August 2023 – October 2024

Performed Functional Testing for POS system using Agile framework and user stories to validate core functionality including Sale transactions, refunds, inventory updates, receipt generation, split transactions, partial returns etc.

Created and executed test cases for third party integration testing to ensure seamless communication between POS systems and payment gateways, inventory management and accounting software generating reports.

Participated in performance testing to measure transaction speed, concurrent user handling, and system stability under peak loads.

Validated hardware components, including barcode scanners, receipt printers, cash drawers, card readers, and touchscreens for proper functionality.

Performed usability testing to ensure intuitive user interfaces, accessibility, and error-handling processes for smooth cashier operations.

Performed backend testing for real-time inventory updates, sales reporting, and transaction data integrity.

Executed Regression testing to verify system stability after updates, patches, or new feature deployments.

Participated in recovery mechanism testing to ensure transaction continuity during power failures or network issues.

Participated in Sprint planning, story point calculations, stand ups and Retrospective meetings.

Contributed on behalf of the team in defect triage meetings and generated test coverage reports.

Bank of America, Pennington, NJ

Quality Assurance consultant November 2022 – August 2023

Worked with SIT (System Integration Testing) Manual and Automation team performing complex day to day Trading activities testing for retirement products.

Created, maintained and executed Manual and Test Automation test cases and test scripts.

Comprehensively used BDD (Behavior Driven Development) framework for End-To-End testing from TestComplete.

Created manual test cases from the user stories for the complex stock trading application.

Performed Manual Compliance Testing for Pre-Allocation and Post Allocations for Equities, Fixed Income funds and Money Market Funds using different Models, Accounts and securities.

Performed Portfolio Management testing for various asset allocations strategies like Active approach, Passive approach, Age based asset allocation and their ROI, portfolio monitoring and rebalancing with active buying/selling securities and stocks.

Successfully performed Manual End to End Testing of Trade routing of Equities and Fixed Income Funds using specific Models and Accounts.

Participated and represented the testing team during agile scrum meetings.

Collaborated with cross functional teams to complete End to End testing.

Coordinated with Dev team and Business Team to perform Gap Analysis for manual and automated test cases.

Performed daily environmental centric smoke test for critical trading applications.

Generated daily test execution, test coverages and defect reports.

Reviewed automation test results with Functional and testing team.

Performed backend data validation for different Securities Symbol, Cusips and SEDOL using SQL queries.

Coordinating offshore team members for automation testing and Smoke Testing.

Environment: TestComplete, SQL TOAD, Windows 10, ALM,

DTCC (Formerly -Omgeo), Boston, MA August 2013 – March 2022

Sr. QA Analyst

Leading Manual testing involved testing various changes made on a Broker portal using key features for security and functionality.

Performed Quality Assurance Analyst responsibilities on a complex Project for OMGEO and later DTCC for EOD settlement application widely used by Business Analysts and Brokers. Guided the offshore team to conduct a series of scenario testing.

Participated in all Agile practices including Daily Stand-ups, Iteration Planning, TDD and Demonstrations to the business of functionality being delivered for Salesforce rollout from Classic to Lightning platform.

Test case development and defect management using ALM.

Performed API testing using Postman tool for different HTTP methods like POST, GET, PUT.

Created different test scenarios using snippets with Postman tool.

Performed backend data validation using SQL queries and verified expected data populated in correct tables.

Used SQL queries for specific to search and provide data for UAT testing.

Performed SIT (System Integrated Testing) and coordinated UAT (User Acceptance Testing) with business users.

Created Functional, Regression, Systems Integrated and User Acceptance Test Cases for Salesforce Migration Project.

Conducted Test Case review and mapping with business requirements Vs Legacy and Lightning platform.

Using QA best practices and developing various test cases for Billing scenarios.

Participated in story estimation and planning with agile track team members and balancing SDLC lifecycle.

Closely work with the Dev and Business team to ensure that Agile Iterative Testing needs are met.

Created Test Matrix and test data Status reporting to management.

Managing the Requirements, Test Cases and Defects using ALM.

Environment: SQL TOAD, Windows 10, ALM, Postman,

Fidelity Investments, Merrimack, NH August 2010 – August 2013

Sr. QA Analyst

Performed Quality Assurance Analyst responsibilities on Multiple Financial Projects for Fidelity Pricing and Cash Management Systems (FPCMS) Group.

Prepared comprehensive Test Plans and Test Strategy documents from Systems Requirement Specification (SRS) and Technical Requirement Document (TRD)

Performed SIT (System Integrated Testing) and coordinated UAT (User Acceptance Testing) with business users.

Created Functional, Regression, Systems Integrated and User Acceptance test cases.

Conducted Test Case review and mapping with business requirement.

Performed business day validations, Inbound file processing using Control-M jobs validations.

Outbound Files/ Report generation using GUI and UNIX commands.

Performed outbound file validation, file comparison and directory comparisons using tools like ExamDiffPro 5.0.1 and Beyond Compare 3.3.4

Preformed Functional and Regression Testing on multiple financial applications.

Created Test Matrix and test data for regression and user acceptance testing.

Managing the Requirements, Test Cases and Defects using HP Quality Center 10.0, 11.0

Test Cases execution and test report generation from Quality Center.

Test supporting, Test Summary and user guide preparations.

Environment: Oracle 10g, Windows XP and Win7, UNIX, Mainframe, Quality Center 10.0, 11.0.

J.P. MORGAN CHASE, Dallas, TX January 2010 – August 2010

Lead QA Analyst

Performing as Lead Quality Assurance on SIT (Systems Integration Test) for Capital Market Application.

Coordinating offshore Test Team in various time zones and created Test Plan to provide integrated Test Results.

Involved in creating Test Plan, Test Strategy document for SIT and Black Box Testing of various Data Warehouse Reports and Extracts.

Building and maintaining productive and effective Test Team, valuing integrity and developing key relationships.

Created and delivered test strategy document for Parameterization Test for various DW reports and Extracts.

Created Defect Management and Defect Life Cycle document.

Helping the team to develop Positive and Negative Business Scenarios from Functional Specification Documents and from the Use Cases.

Involved in Creating Test Automation Strategy using Quick Test Pro.

Coordinating with Testers and Developers and conducting daily defect status calls and providing daily and weekly status report to higher management using Quality Center.

Effectively using HP Quality Center for defect tracking and management reporting.

Coordinating Systems Test and Business User Tests.

Environment: Oracle 10g, Windows XP, UNIX, Cognos ODBC, Mainframe, QTP 9.5, Quality Center 8.2/9.0, TOAD.

STATE STREET, Boston, MA September 2007 – December 2010

Sr. QA Analyst

Performed lead Quality Assurance responsibilities on Multiple Financial Projects with Transfer Agency.

Performed backend testing using SQL server, UNIX for System Conversion Projects, System Integration Projects.

Good hands-on experience of testing Perl Script, File Transmission.

Performed automated SFTP file transmission using Autosys as scheduler.

Performed DataStage jobs validation through Autosys Scheduler.

Performed Automated Intraday trade test using MQ series, QRACLE and SQL Server.

Developed Positive and Negative Business Scenarios from Functional Specification Documents and from the Use Cases.

Developed Test Plan, Test Strategy and Test Cases for Financial Application.

Performed Lead role and delivered timely results for System Integration Testing for Financial Application

Performed ETE test, Connectivity test, for systems and application.

Extensively used Mercury Quality center as Defect Tracking tool and Management Reporting tool.

Performed File Validation using Multi Edit.

Coordinated Systems Test and Business User Tests.

Environment: SQL Server 2003, VB.Net, Oracle 9i, Windows XP, UNIX, Power Builder, Perl, Autosys, Mainframe, QTP 9.5, Quality Center 8.2/9.0, TOAD, Multi Edit 9.0

JP MORGAN CHASE, Wilmington, DE February 2007 – September 2007

Sr. QA Analyst

Developed Functional Specification Documents from the Use Cases.

GAP Analysis between BRD (Business Requirement Documents), Use Case and Test Script.

Performed ETE (End to End) Testing of Credit Cards, created Test Plan, Test Cases and Test Scenarios for ETE Testing

Condition Test Accounts to validate various scenarios in Mainframe –Tsys.

Coordinated Account Building Process with ORI and CMS and generated Fulfillment with CPC.

Data Validation on different screen and scenarios in Mainframe – Tsys.

Provided daily status report to Project Manager on ETE scenarios like Acquisition, Balance Transfer, Convenience Check, Product Trade, Card Design, Promo Pricing and Retention.

Participated in Daily Check Point meetings and coordinated for ETE Testing.

Involved in preparing Automated Test Scripts from Test Cases for new, existing Financial Application using QTP.

Good understanding of Object Repository manager and creating/ updating and maintaining OR using OR Manager.

Involved in Creation of numerous functions, planning of enhanced automation scripts with the help of QTP functionalities like Checkpoints and other logical conditional and reporting statements.

Maintained Test Plan, defect tracking and defect reporting and executed scripts in Test Lab - Quality Center 8.2

Environment: C++, Java, HTML, XML, Oracle 9i, UNIX, Mainframe–Tsys, QTP 9.5, Quality Center 8.2/9.0

INVESTORS BANK & TRUST, Boston MA February 2006 – February 2007

QA Analyst

Developed TSL Scripts using WinRunner 7.6/8.0 to perform activities of both Administrator and Operator Modules.

Created TSL Scripts to perform Data Driven Testing from Excel files and Business Test Cases including GUI testing. Generated Data Sheets and TSL Scripts to perform multiple iterations.

Maintained GUI MAP Files and for Administrator and Operator Modules.

Created Test Suits in Quality Center 8.2/9.0 from Test Plan to run TSL Scripts.

Extensively used Quality Center for Bug Reporting and Management Reporting.

Created and Maintained Function Library.

Extensively Used WinRunner Scripts for Regression Testing as well as Power Builder Functions in WinRunner7.6/8.0

Performed Manual Backend testing using SQL Query Analyzer and TOAD.

Used Multi Edit 9.0 for ETL File Compare.

Performed File Validation of ETL Files using Business Requirements and Mapping Documents.

Created Manual Tests in Quality Center using Mapping Documents.

Environment: SQL Server 2003, WinRunner7.6/8.0, Windows XP, PowerBuilder, VB.NET, TOAD, Oracle 9i, Quality Center 8.2/ 9.0

LIBERTY MUTUAL, Portsmouth NH December 2004 – January 2006

Business Analyst – QA

Analyzed Business Requirements, KB Rules (Knowledge Based), and System Requirements and developed Test Cases for Property and Casualty Insurance.

Created Test Strategy and System Test Cases based on the Business and System Requirements to test the functionality of the System.

Performed Integration Testing for DRW (Direct Response Workbench) and CFP (Customers First Property) application.

Created Billing Test Cases from the Use Case this covers various Transaction Type, Billing Options and payments.

Performed Manual Testing and supported Automation Testing team for creating Test Data for Data Driven Testing.

Created Test Cases for GEOCODE and ISO finding geographical location of the property to get the accurate Basic Premium.

Created Boundary Level Test cases based on different Rate Structures using Rate based Analysis.

Created Test Cases for Inspections, Discounts for Property and created various scenarios for Automation Team for Data Driven testing.

Created Test Cases for Bind- ability Rules and SHP (Safe Homeowner Program) for Property and created Excel Sheets for Data Driven testing.

Extensively worked with the Automation Team for creating TSL in WinRunner 7.6 for KB Rules and created various scenarios for 100 % coverage of the KB Rules. Created Test Cases for Validation and Cross Checks for Property and created TSL in WinRunner 7.6

Updated Test cases and the results for both manual and Automation in Tempest.

Implemented ad hoc Testing of the Functionality of each screen prior to running the business rules. In Property, made test cases for the Inspection rules which are necessary to get the Property approved and inspected within the Policy effective Date.

Tracked defects or bugs using Mantis.

Coordinated with Business Analyst, UAT and Ad hoc testing team to verify the business rules before going the system to Pilot. Worked on Regression Test Suit for February Release and coordinating Production Support with Business Analyst

Environment: C++, Java, HTML, XML, SQL, Java Messaging Services, EJB, JSP, Web Logic, LoadRunner, WinRunner, Windows XP

Contact this candidate