Ankit Saxena

QA Lead with 10 years of experience in Data Analysis, ETL/Data Warehouse Testing, and Data Quality Assurance across Financial Services, Asset Management, and P&C Insurance. Experienced in data reconciliation, reporting validation, KPI reporting, Power BI dashboards, and modern cloud data platforms including AWS S3, Snowflake, and Databricks concepts. Strong SQL practitioner with exposure to Delta Lake architecture, Bronze-Silver-Gold data processing layers, and ETL/ELT pipeline validation.

GitHub Copilot certified practitioner with experience in Python-based data validation, automation, and business reporting workflows. Skilled in ensuring data accuracy, quality, and business rule compliance across enterprise data platforms.

Test Lead at Accenture (2019-08 – Present)

Asset Management | Capital Markets | Investment Banking

• Led end-to-end QA strategy for Asset Management and Institutional Shareholder Services platforms, owning test planning, execution, and stakeholder sign-off across multiple Agile releases.
• Validated modern ETL/ELT data pipelines involving AWS S3/ Azure, Databricks Lakehouse concepts (Bronze-Silver-Gold layers), and Snowflake reporting environments through source-to-target reconciliation, data quality checks, and business rule validation.
• Performed data validation, reporting verification, and Power BI dashboard validation across Snowflake data warehouse environments using data ingested through AWS S3/Azure data lakes, ensuring accuracy and consistency across ingestion, transformation, reporting, and visualization layers.
• As a GitHub Copilot certified practitioner, developed a Copilot-assisted Python utility that reduced Denodo upgrade testing effort by 70% through automated validation and reporting.
• Built a reusable Python-based source-to-target validation framework for ELT pipeline testing, reducing functional test execution time by 50% across data migration projects.
• Validated data models, transformation logic, and reporting workflows on the Denodo data virtualization platform for institutional clients.
• Developed Python/PyTest API automation suites for RESTful service validation, building scalable and reusable test libraries that reduced manual regression effort across releases.
• Built end-to-end UI automation scripts using Playwright with Python, enabling reliable cross-environment regression testing for web-based enterprise applications.
• Integrated GitHub Copilot, Claude, and Amazon Q into daily QA workflows covering test case generation, automation scaffolding, data profiling, API validation, and PDF comparison.
• Executed end-to-end ETL and data pipeline testing using complex SQL queries across source, staging, and target layers, validating transformation logic and business rules for financial data workflows.
• Coordinated UAT activities with business stakeholders across Asset Management and Investment Management domains, ensuring business sign-off aligned with release timelines.
• Mentored junior QA engineers on automation best practices and participated in QA technical interviews and onboarding activities.

ETL Test Analyst at Cognizant Technology Solutions (2015-09 – 2019-08)

P&C Insurance

• Tested Guidewire PolicyCenter across Policy, Claims, and Billing modules, covering both UI functional testing and backend data validation for a large P&C Insurance carrier.
• Performed end-to-end ETL testing and SQL-based data validation across fact and dimension tables, verifying transformation logic and business rules across source, staging, and target layers.
• Contributed to an automated data quality validation framework for database testing, writing SQL-based validation scripts that reduced manual data verification effort across releases.
• Validated business reports and reporting workflows against source data using SQL, ensuring data accuracy and consistency for downstream business consumers.
• Supported test planning, release validation, and production deployment activities across multiple delivery cycles with minimal post-release defects.
• Conducted data profiling and reconciliation across DEV, UAT, and production environments to identify data anomalies and ensure environment consistency.
• Mentored 3–5 junior QA analysts on ETL testing practices and SQL-based data validation, supporting structured knowledge transfer during project transitions.

Bachelor of Technology – SRM University, Chennai (2011 – 2015)