Gopi Tina Gandhi
Madison,WI
Overview
12
12
years of professional experience
Work History
QBA Analyst (Quality Business Analyst)
Exact Sciences
Madison, WI
08.2021 - Current
- Working on SAP modules (functional testing for desktop and mobile device).
- Microsoft Azure (creating test plans, execution/reports), JIRA.
- Worked closely with the BA/Product Owner, Project Manager, and the business to understand requirements and business flow of the application.
- Collaborated with the development team and another business team.
- Performed System, Functional, and Regression testing of the application.
- Created and Reviewed test cases and test scenarios.
- Used Postman for Automation Testing.
- Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
- Performed End-to-End testing.
- Prepared UAT test scripts and conducted testing with the business to make sure the functionality works in the SAP environments.
- Designed and developed test strategy for the upcoming projects which outlines the new processes and systems in SAP using Microsoft Visio.
- Documented Test Approach that can be used for existing and upcoming projects as well as features (small enhancements).
- Also tested applications like Service Now enhancements, pronto forms, Tableau-reporting tools and collaborated with the Epic team for testing.
- Played the scrum master role, whenever required by leading scrum calls, updating any sort of follow up items with the business, lead retrospectives, sprint planning sessions, organizing sprint charts.
- Active lead BA role for a few projects, worked closely with the customer, ensuring requirements were met.
- Developed user stories and process flows to support the design of the requirements of the clients.
- Worked collaboratively with team members to design solutions that met with the business requirements and fulfill user stories.
- Conducted key meetings with clients including requirements sessions, UAT and end-user training.
- Environment: SAP (Plant Maintenance Module), Microsoft Azure Devops, JIRA, Microsoft Visio, Service Now
QA Analyst (ETL Datawarehouse)
Trial Card Inc
Morrisville, NC
06.2019 - 08.2021
- Prepared Test Strategy and Test Plan documents.
- Designed Test Case in Service Now Test Management/Excel, ensuring compliance with the user stories.
- Worked closely with the Product Owner, Project Manager and the business to understand requirements and business flow of the application.
- Collaborated with the development team and another business team.
- Performed System, Functional, and Regression testing of the application.
- Implemented Modified Condition/Decision Coverage for testing the business rules and edits of the application.
- Reviewed test cases and test scenarios of the Policy module.
- Extensively used Service Now to organize stories (requirements), tasks, tests plan, track/organize defects, update defect logs, and track iterations (sprints) and releases following Agile methodology.
- Evaluated test results using test tools to manage Test scripts, Test execution and defect resolution process.
- Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
- Performed End-to-End testing and executed Regression test cases.
- Environment: SQL Server, Service Now, Service Now Test Management 2.0
QA Analyst (ETL /BI)
Investors Title
Morrisville, NC
04.2019 - 06.2019
- Conducted business analysis, gathered requirements, and coordinated with onsite clients and project leads.
- Developed validation plans, quality summary reports, and drafted test plans based on strategy and product requirements.
- Designed, reviewed, executed, and automated regression test cases; managed end-to-end testing including UAT and integration.
- Utilized SQL extensively for backend/front-end procedures, data validation, reporting, and troubleshooting.
- Extracted and transformed data using SSRS and Excel; ensured data integrity, completeness, and accuracy in the data warehouse.
- Created reports and validated them through complex SQL queries and SSRS testing.
- Prepared daily status and defect reports; communicated findings effectively both orally and in writing.
- Supported Agile projects with Scrum, managed timelines, and automated scripts for regression testing.
- Environment: SQL Server 14.0, Microsoft TFS, SSRS, Microsoft Excel, Word
Sr. QA Analyst
Coca Cola Consolidated
Charlotte, NC
08.2016 - 04.2019
- Collaborated with business stakeholders to define user requirements and project goals; analyzed business and functional requirements across multiple modules.
- Developed and executed test cases, plans, and procedures for system and ETL testing.
- Wrote SQL queries to validate data integrity, accuracy, and content in Enterprise Data Warehouse, BI, and backend testing.
- Automated tests using Selenium with C# and Query Surge for data validation.
- Created and managed test data using SQL insert and update statements.
- Tested data migration, application interfaces, data extracts for ETL workflows, and ensured data quality assurance.
- Validated transformation logic and data routing using mapping documents from source to target tables/files.
- Designed test scenarios based on subscription plans for transaction validation.
- Conducted integration, system, positive/negative, and backup/restore testing.
- Coordinated and attended meetings to improve testing and reported defect statuses.
- Executed Unix command line jobs for Supply Chain module updates.
- Achieved system, regression, UAT, and vendor testing objectives.
- Used Easitrax and SAP to create and validate orders and tested various SAP modules including HR and Sales.
- Managed test case suites and manual scripts in HP Quality Center.
- Created Tableau dashboard test scripts per requirement specifications.
- Maintained daily defect reports and supported test case requirements for all project phases.
- Utilized JMeter to design performance test approaches, scripts, and scenarios.
- Environment: SAP HANA, SAP, Easitrax, ALM 11.00, 12.53, SQL Server, Excel, Oracle, SQL Server, Jmeter, Unix, Query Surge, Selenium
Sr. QA Tester
American Institute of Certified Public Accountants (AICPA)
Durham, NC
02.2016 - 08.2016
- Created Test Strategy and Test Plan documents.
- Automated testing with Selenium and HP ALM.
- Designed test cases in Quality Center/JIRA to meet user stories.
- Coordinated with Product Owner, Project Manager, business and development teams.
- Prepared Business Process Test Cases in QC.
- Conducted System, Functional, Regression, and End-to-End testing.
- Applied Modified Condition/Decision Coverage to business rule testing.
- Reviewed Policy module test cases.
- Extensively used JIRA for requirements, defect tracking, and Agile project management.
- Evaluated test results and managed scripts, executions, and resolution.
- NetForum/OSR CRM project: analyzed requirements, managed bugs via JIRA.
- Used EOS and SRI applications; ran SQL queries for failed orders.
- Performed web-UI testing across browsers and regression tests.
- CandL Project: AICPA website offering flexible access to learning for CGMAs, enabling them to discover new competencies and track career progress.
- Environment: SQL Developer, JIRA, HP-QC 12, Excel Smart Sheet, Abila, Web UI/UX application, HTML, Selenium
Sr. QA Tester
Wells Fargo (IRT- Institutional Retirement & Trust)
Charlotte, NC
04.2015 - 12.2015
- Collaborated with clients to gather and analyze user, business, and functional requirements.
- Developed Test Strategy for both Data Warehouse and application components.
- Wrote and executed SQL queries for data integrity checks, validation, back-end testing, and verifying data accuracy.
- Utilized Informatica Power Center tools including Source Analyzer, Data Warehousing Designer, Mapping/Mapplet Designer, and Transformation.
- Created detailed Test Cases, Test Plans, and Procedures for System Testing.
- Designed technical specifications for the ETL process and developed advanced SQL for data extraction and reporting.
- Tested business rule and data load files; performed manual security, integration, system, positive/negative, and backup/restore testing.
- Led meetings, communicated defect status, and coordinated with production support on implementation cycles.
- Environment: Informatica Power Center 9.6, ALM 11.00, SQL Developer, Excel, Oracle, SQL Server, DB2
Sr. QA Tester
Bright House Networks
Riverview, FL
03.2014 - 03.2015
- CSG History Conversion Project: Converted CSG historical data to match the Monarch format/schema for future analysis in Bright House.
- Testing verified mappings and transformations aligned with ICOMS standards and ensured the ETL process was bug-free and met requirements.
- Developed and reviewed test plans and cases in ALM.
- Created and ran SQL scripts for manual testing and updated statuses in ALM.
- Provided support during execution, attended meetings to address issues, risks, and dependencies.
- Reported daily progress and defects; verified and escalated unresolved issues.
- Deliverables included: Test queries (Sybase 14.0.10), Results summary (run time, pass/fail), Defect tracking (ALM 11.00), Dashboard updates (Excel, ALM), Data profiling compared CSG and ICOMS datasets using Min/Max, unique counts, top value frequencies, and null ratios.
- Metadata and ETL validation checked table structures, constraints, field types, and ensured error-free code execution.
- Automated record-level tests validated mapping accuracy against current ICOMS data.
- Environment: SQL, Sybase 14.0.10, Excel, Quality Center 11.0/ALM
Timeline
QBA Analyst (Quality Business Analyst)
Exact Sciences
08.2021 - Current
QA Analyst (ETL Datawarehouse)
Trial Card Inc
06.2019 - 08.2021
QA Analyst (ETL /BI)
Investors Title
04.2019 - 06.2019
Sr. QA Analyst
Coca Cola Consolidated
08.2016 - 04.2019
Sr. QA Tester
American Institute of Certified Public Accountants (AICPA)
02.2016 - 08.2016
Sr. QA Tester
Wells Fargo (IRT- Institutional Retirement & Trust)
04.2015 - 12.2015
Sr. QA Tester
Bright House Networks
03.2014 - 03.2015