Available to hire
Hi, I’m Oindrila Gupta, a Senior Data Test Analyst with 18+ years of experience in software testing, specializing in complex data-driven enterprise systems. I combine hands-on testing with data-focused quality assurance to help organizations deliver reliable, scalable solutions. I thrive in collaborative, multi-disciplinary teams and enjoy turning ambiguous requirements into solid test strategy and actionable results.
Based in Melbourne, I’m currently working with Tower Insurance New Zealand on a remote remediation program, validating data, and driving Snowflake SQL validations for customer overcharges and financial reconciliation. I partner with analytics, pricing, and business SMEs to ensure data accuracy, align test outcomes with business goals, and continuously improve testing practices in Agile environments.
Skills
Language
English
Fluent
Work Experience
Senior Data Test Analyst (Remote Contract) at Tower Insurance (New Zealand) / Tower Foundation Remediation Programme
June 1, 2024 - PresentSenior Data Test Analyst leading remediation for a multi-policy discount error affecting ~65,000 customers. Defined Test Strategy, Test Plan, and Test Summary Report; developed complex Snowflake SQL queries to validate overcharges and customer IDs; collaborated with analytics and pricing teams to ensure data accuracy across Power BI dashboards, Snowflake, and the core insurance platform (EIS); participated in Agile ceremonies and defect triage.
Test Lead (Contract) at Auckland Council – Waste Digitisation Project
September 1, 2023 - March 1, 2024Led E2E testing for a responsive portal with GIS integration and SAP CRM enhancements; conducted system and integration testing across Hybrid platform, GIS assets, and accessibility testing (NVDA); planned GIS tests and executed automation; managed defect triage and test data.
Senior Automation Test Analyst — Data Migration at Bank of New Zealand
February 1, 2022 - September 1, 2023Migrated data from legacy GDW to cloud-based big-data pipelines to meet BS11 regulatory requirements; created Snowflake and Hive SQL scripts for ETL testing; executed ST/SIT/UAT/PVT testing; extended test framework with Python automation; collaborated with analytics and business teams for data accuracy.
Test Lead (Permanent) at SMX New Zealand – Email Security Platform
April 1, 2020 - February 1, 2022Led testing for an email-filtering platform; collaborated with security, QA, and development teams; authored System Acceptance Test Strategy; conducted E2E testing and regression planning; built a PowerShell-based test automation framework and utilized SoapUI/Groovy for regression testing; maintained CI/CD artefacts and test artifacts.
Senior Test Analyst / Test Lead (Contract) at Auckland Council – City Centre Masterplan (CCMP) Digital Transformation
March 1, 2020 - April 1, 2020Planned and executed UAT for digital transformation initiatives; performed GIS and SAP CRM integration testing; conducted accessibility testing (WAVE/NVDA) and cross-platform validation; supported the shift from hard copies to a unified digital platform.
Senior Test Analyst / Test Lead (Contract) at Chorus New Zealand – Billing Capability Implementation
June 1, 2018 - March 1, 2019Implemented Chorus billing capabilities post-separation; performed end-to-end SAP ECC billing testing (SD/FI/Security modules); defined test plans, risk assessments, and QA documentation; executed post-go-live support.
Senior Test Analyst (Contract) at SMX New Zealand – Spark Xtra Mail Migration (Victoria Release)
July 1, 2016 - April 1, 2018Migrated Spark Xtra Mail customers to a customized SMX platform with a new cloud Subscriber Management system for CSR activities; performed API testing, functional testing of new services, compatibility and regression testing across multiple components; built an automated API test suite using ReadyAPI and Groovy scripting.
EDW/BI Test Analyst (Contract) at Auckland Council – NewCore WiRED EDW/BI Programme
October 1, 2015 - June 1, 2016Enterprise data warehouse/BI testing across EDW, SAP BO reporting, data transformation, and delta data validation; defined test estimates, risk flags, and led UAT readiness for Release 1 & 2; supported CSR post go-live.
Senior Test Analyst (Contract) at SMX New Zealand – Spark Business Mail
May 1, 2015 - July 1, 2015End-to-end functional testing of E2E email flow, filtering, archiving, and nostalgia of mail; regression testing and test summary reporting; planned and executed defects and UAT defect analysis.
Test Architect (Contract) at IBM New Zealand – Big Data: Timeline & Government Insights (Westpac)
July 1, 2014 - November 1, 2014Test architecture for a big data sub-system to provide transactional data to Westpac’s online banking platform; defined test scenarios, test plans, data preps, and defect tracking; led cross-team coordination.
Test Specialist – Technical (Contract) at IBM New Zealand – RISL, Telecom New Zealand
October 1, 2012 - August 1, 2013Vendor integration and system testing for mid-tier web portal applications; test case design, review, data prep, regression testing; SOAP UI testing; defect reporting.
Quality Analyst at IBM India Pvt. Ltd. (Aug 2006 – Jun 2012)
August 1, 2006 - June 1, 2012End-to-end testing across multiple engagements; test planning, data creation, integration testing; contributed to test automation and defect triage across several projects (ISL, Teleco, NewFO, TDC Nordic, etc.).
Senior Data Test Analyst (Remote Contract) at Tower Insurance New Zealand
June 1, 2024 - PresentIdentified a system error that incorrectly applied multi-policy discounts, leading to overcharges for approximately 65,000 customers. Initiated and led a formal Remediation Programme in response, coordinating with stakeholders to address customer-impacting events in a consistent, managed manner. Developed complex Snowflake SQL queries to validate customer overcharges, compute compensation, and identify affected customers. Collaborated with analytics and pricing teams to ensure data accuracy; reconciled results across Power BI dashboards, Snowflake, and the core insurance platform. Participated in Agile SCRUM ceremonies, including test planning and defect triage.
Test Lead (Contract) at Auckland Council
September 1, 2023 - March 31, 2024Waste Digitisation project: E2E testing for an integrated municipal service portal with Hybris, GIS asset synchronization, and SAP CRM enhancements. Planned and executed GIS, accessibility, and compatibility testing; managed automated test tasks and defect reporting; collaborated with PMs, SMEs, and development teams to ensure smooth delivery.
Senior Automation Test Analyst — Data (Contract) at Bank of New Zealand
February 1, 2022 - September 1, 2023MIGRATION of data from a legacy GDW system to the cloud using big-data pipelines to meet BS11 regulatory requirements. Created Snowflake SQL scripts for ETL validation, tested data loads across ST/SIT/UAT/PVT, and extended Python-based automation for test suites; reviewed Informatica logs and coordinated defect triage with analytics and business teams.
Test Lead (Permanent) at SMX New Zealand
April 1, 2020 - February 28, 2022Email Security Platform: led end-to-end testing and security testing for SMX email filtering and cloud portal administration. Authored System Acceptance Test Strategy; built and maintained a PowerShell-based automation framework for mail-filtering tests; performed security testing using GO-SSS/GOss framework; coordinated with security and QA management.
Senior Test Analyst / Test Lead (Contract) at Auckland Council
March 1, 2020 - April 1, 2020City Centre Masterplan (CCMP) Digital Transformation: testing strategy and plan for a city-scale digital platform supporting a 20-year vision across multiple outcomes; managed UAT planning, execution, and defect triage; conducted accessibility and browser compatibility testing.
Senior Test Analyst / Test Lead (Contract) at Auckland Council
October 1, 2015 - June 30, 2016NewCor e WiRED EDW/BI Programme: EDW/BI testing across data migration, BI reporting, data transformation, and delta data validation; managed test data creation and E2E test execution; collaborated with CRMs and PMs to ensure successful releases.
Senior Test Analyst (Contract) at Chorus New Zealand
June 1, 2018 - March 31, 2019Billing Capability Implementation: end-to-end SAP ECC billing solution testing (SD/FI/Security) for 1,500–2,000 customers; test data preparation, test design and execution; documentation and regression testing; supported security testing and PO C for automated authentication.
Senior Test Analyst (Contract) at SMX New Zealand
July 1, 2016 - April 30, 2018Spark Xtra Mail Migration: migrated Xtra Mail customers to SMX with a new cloud Subcriber Management system; API testing, compatibility and regression testing across related products; built automated API test suites using ReadyAPI and Groovy scripting; post-migration testing across related products.
EDW/BI Test Analyst (Contract) at Auckland Council
October 1, 2015 - June 30, 2016NewCore WiRED EDW/BI Programme: enterprise data warehouse and BI platform testing for data migration, reporting, transformation validation; ensured SA P CRM and B2B interfaces integrated with BI tooling; contributed to risk assessment and defect reporting.
Senior Test Analyst (Contract) at SMX New Zealand
May 1, 2015 - July 31, 2015Spark Business Mail: functional testing of E2E email flow, filtering, archiving, and search; regression testing and UAT defect analysis; utilized SMX tooling including SMX3 for migration validation.
Test Architect (Contract) at IBM New Zealand
July 1, 2014 - November 30, 2014Big Data: Timeline & Government Insights (Westpac): ensured reliable transactional data delivery to Westpac's online banking platform using Hadoop-based data stores; test scenario identification; risk tracking; stakeholder reporting.
Test Specialist – Technical (Contract) at IBM New Zealand
October 1, 2012 - August 31, 2013RISL, Telecom New Zealand: WebSphere integration between legacy systems and Siebel CRM; vendor integration and system testing; test case preparation, review, and updates; supported SAP UI integration.
Quality Assurance Specialist at IBM India Pvt Ltd
August 1, 2006 - June 30, 2012ISL — IBM Information Server (2010–2012): end-to-end connectivity testing across Information Server and Informix databases; created new test cases; regression testing using Apache Ant; supported WebSphere components. Tele2 EDW Implementation (2009–2010): functional and integration testing for Customer & Segmentation EDW/BI modules; regression and risk management. Enterprise Clustering System, Walmart (2008–2009): testing of intranet retail modules (store groups, purchases, attributes); SDLC test planning and defect triage. New FO, TDC Nordic (2006–2007): E2E testing for Nordic Reg Act compliance; test planning and data validation; architecture-level test design. New FO, TDC Nordic (2006–2007): test data creation and SANITY testing during maintenance.
Education
Bachelor of Technology – Information Technology & Communication at West Bengal University of Technology, India
January 11, 2030 - January 1, 2006Bachelor of Technology in Information Technology & Communication at West Bengal University of Technology, India
January 11, 2030 - January 1, 2006Qualifications
ISTQB Foundation Certification (Certified Tester Foundation Level) – ANZTB
January 1, 2012 - April 30, 2026IBM Rational Functional Tester (RFT) Certification
January 1, 2008 - April 30, 2026HP QuickTest Professional (QTP) / HP LoadRunner
January 1, 2009 - April 30, 2026Microsoft Visual Studio .NET 2005
January 1, 2005 - April 30, 2026ISTQB Certified Tester Foundation Level (ANZTB)
January 1, 2012 - April 30, 2026IBM Rational Functional Tester (RFT) with Java – Certified
January 1, 2008 - April 30, 2026HP QuickTest Pro (QTP) / HP LoadRunner
January 1, 2009 - April 30, 2026Microsoft Visual Studio
January 1, 2005 - April 30, 2026Industry Experience
Financial Services, Software & Internet, Telecommunications, Government, Professional Services
Skills
Hire a QA Engineer
We have the best qa engineer experts on Twine. Hire a qa engineer in Melbourne today.