Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Heena Girdhar

Hyderabad

Summary

Dynamic Team Lead at Accenture with expertise in ETL and DWH testing, leveraging Python and SQL to enhance data integrity. Spearheaded automation initiatives, achieving a 50% increase in regression coverage. Adept at collaborating with cross-functional teams, ensuring successful project deliveries and seamless user acceptance testing.

Overview

7
7
years of professional experience
1
1
Certification

Work History

TEAM LEAD

Accenture
Hyderabad
04.2021 - Current
  • Supervise creation and maintenance of automated regression suite built with Provar improving regression coverage by 50%.
  • Implemented RAG pipeline to automate test case generation using Azure Open AI (LLM: GPT 4o) reducing manual effort by 30%.
  • Define test strategies for business functionalities, covering policy/quote management, claims processing, and customer data management.
  • Successful Production go-live of 4 big releases without any test slippage.
  • Allocate tasks efficiently among a team of 7 testers, balancing workload and priorities.
  • Lead User Acceptance Testing (UAT) efforts, assisting business users with test execution and issue resolution.
  • Automated Test scripting and execution for a web-based application to onboard new business units with Selenium Webdriver and Python.
  • Designed and executed rigorous test strategies to validate end-to-end ETL flows on databricks using Azure Data Factory, ensuring seamless data extraction, transformation, and loading into SQL Server-based data marts.
  • Developed automated test scripts using Python and SQL, verifying data integrity and transformation logic across data marts, achieving 99% data consistency.
  • Project: Managing the quality assurance process of Salesforce based insurance broking platform covering entire policy lifecycle (Commercial Insurance, Property & Causality Insurance, Quotation to Bind, Policy issuance and renewal, Premium Payments, FNOL, Claim Processing).
  • Project: ETL project to streamline data flows from diverse sources, including transactional databases, different file formats and CRM systems, into specialized data marts to support portfolio management, risk analysis, and regulatory reporting.

ETL Test Analyst

Tata Consultancy Services
Utrecht
02.2018 - 02.2021
  • Designed automated test scripts in IntelliJ and SQL speeding up test execution by 50%.
  • Validated ETL pipelines and data flows created in Informatica PowerCenter.
  • Wrote complex queries in Oracle to validate data correctness, completeness and data integrity.
  • Worked on the client location (Netherlands), very comfortable in direct client facing roles.
  • Collaborated with Dutch business analysts, developers, and client stakeholders to gather and refine testing requirements.
  • Good exposure to CICD tools -Git, Jenkins, Bitbucket.
  • Used JIRA for test and release management activities.
  • Project: Managing QA for a leading Retail bank in Netherlands, validating the ETL process to load data from various sources to Data vault and data marts used for end user reporting.

ETL and BI Tester

Tata Consultancy Services
Gurgaon
02.2018 - 02.2021
  • Validated source data from OLTP system (Sybase) to OLAP system (Oracle) for correctness and completeness.
  • ETL automation for creation test scenarios, test cases and query pairs in Query Surge.
  • Validated data marts integrity by checking data in dimensions and facts.
  • Involvement in Requirements and design analysis with onshore team and stakeholders.
  • Used JIRA for test management and defect tracking.
  • Created traceability matrix for test cases to test scenarios and then to requirements.
  • Project: Testing ETL workflows, Data Warehouse architecture and BI reports of a Japanese shipping client.

Education

XII Std - PCM

S.K.D.V.M. Hansi
Hansi
03.2021

B. Tech - Electronics and Communication Engineering

Kurukshetra University
Haryana
02.2018

Xth Std - All Subjects

S.K.D.V.M. Hansi
Hansi
06.2012

Xth Std -

S.K.D.V.M. Hansi
Hansi
03.2006

Skills

  • ETL and DWH Testing
  • SQL
  • Python
  • Insurance
  • Banking
  • Azure Data Factory
  • Databricks
  • Informatica PowerCenter
  • Azure DevOps
  • JIRA
  • Salesforce
  • Query Surge
  • Selenium Web driver
  • IntelliJ
  • Provar
  • Azure OpenAI
  • GPT-4o
  • Functional Testing
  • Regression Testing
  • Agile Methodologies
  • PowerBI
  • Cognos
  • OBIEE

Websites

Certification

  • Salesforce Certified Administrator
  • Salesforce Agentforce Specialist
  • Microsoft Certified: Azure Fundamentals (AZ-900)
  • ISTQB Advanced Level Test Analyst

Timeline

TEAM LEAD

Accenture
04.2021 - Current

ETL Test Analyst

Tata Consultancy Services
02.2018 - 02.2021

ETL and BI Tester

Tata Consultancy Services
02.2018 - 02.2021

XII Std - PCM

S.K.D.V.M. Hansi

B. Tech - Electronics and Communication Engineering

Kurukshetra University

Xth Std - All Subjects

S.K.D.V.M. Hansi

Xth Std -

S.K.D.V.M. Hansi

Similar Profiles

CREATE PROFILE
Heena Girdhar