01
Professional Summary
- Senior QA professional with 17 years of experience, including 8 years focused on ETL/ELT testing and data warehouse validation.
- Partners with data engineers, business analysts, and solution architects to understand application architecture and ETL workflows end-to-end.
- Reviews mapping documents, data lineage, and architecture diagrams to validate source-to-target transformations.
- Builds PySpark ETL automation with pytest for repeatable execution and detailed validation reporting.
- Automates checks for row counts, schema consistency, duplicates, nulls, and data integrity across large datasets.
- Strong in SQL-based validation — joins, CTEs, window functions, recursive queries — for source-to-target accuracy, completeness, and consistency.
- Validates cloud-based pipelines on AWS S3, Glue, and Redshift, including event-driven workflows on AWS Lambda.
02
Core Competencies
SQL & Databases
SnowflakeOracleSQL ServerMySQLDB2Foundry
Cloud & Data Services
AWS RedshiftAWS S3AWS GlueAWS Lambda
Query Tools
DBeaverMySQL WorkbenchOracle SQL Developer
ETL Automation
PythonPySparkpytest
API Testing
PostmanREST Assured
UI Automation
Selenium WebDriverJavaTestNGMaven
CI/CD
JenkinsAzure DevOpsGitGitHub
Reporting & Test Management
TableauPower BIJiraALM/QCRQMClearQuest
03
Professional Experience
SEP 2025 — APR 2026
QA Test Engineer
World Wide Technology (ProNexus)
JAN 2020 — JUN 2024
Senior Tech Lead
Ness Digital Engineering
AUG 2018 — DEC 2019
Senior Test Engineer
Tech Mahindra (Radar Technosoft)
FEB 2017 — JAN 2018
Senior Test Engineer
Honeywell (Magna Infotech)
JUL 2012 — APR 2016
Test Engineer
Computer Sciences Corporation (DXC)
SEP 2006 — JUN 2012
Quality Engineer
iSOFT R&D Pvt Ltd
04
Key Achievements
- Reduced regression execution time by 70% through automation.
- Designed a reusable PySpark validation framework.
- Automated 200+ ETL validation scenarios.
- Validated 10M+ records across AWS Glue pipelines.
- Mentored 8 QA engineers.
05
Project Experience
Transmission Asset Health Management — PG&E
ETL Testing · Sep 2025 – Apr 2026
Utility analytics platform for monitoring transmission asset health, assessing operational risk, and supporting preventive maintenance through data-driven insights.
- Validated ETL/ELT pipelines orchestrated through AWS Glue across source, staging, target, and reporting layers.
- Performed source-to-target validation for datasets processed via Glue and loaded into Amazon Redshift.
- Executed SQL-based validation in Redshift to verify transformations, aggregations, and business rules.
- Performed data reconciliation testing between S3 source files and Redshift target tables.
Sustainability Asset Management — S&P Global
ETL Testing · Sep 2020 – Jun 2024
ESG analytics platform used to evaluate and generate sustainability ratings from environmental, social, and governance data.
- Validated end-to-end ETL pipelines using AWS Glue for ESG datasets across source and target systems.
- Executed SQL-based validation in Redshift for ESG scoring accuracy, sustainability metrics, and reporting outputs.
- Supported validation of AWS Lambda-triggered workflows and downstream processing.
- Conducted data quality checks: row counts, duplicates, null checks, integrity testing.
Software Asset Management — ServiceNow ▸
API Testing · Jan 2020 – Aug 2020
Software Asset Management — ServiceNow ▸
API Testing · Jan 2020 – Aug 2020
IT asset management solution integrating SaaS applications to monitor software utilization and optimize licensing costs.
- Developed API automation scripts using REST Assured and TestNG.
- Validated request/response payloads and JSON structures.
- Automated 30+ SaaS integrations and regression scenarios.
- Integrated API execution into CI/CD pipelines.
Power Strip Manager — Riverbed ▸
Selenium Automation · Aug 2018 – Dec 2019
Power Strip Manager — Riverbed ▸
Selenium Automation · Aug 2018 – Dec 2019
Quotation and order management platform for configuring products, generating pricing, and streamlining order workflows.
- Enhanced automation framework and implemented parallel execution.
- Validated order management workflows and backend data.
- Integrated database validations into automation scripts.
- Reduced manual effort by automating the end-to-end order processing workflow.
ACSM — Honeywell ▸
Selenium & API Automation · Feb 2017 – Jan 2018
ACSM — Honeywell ▸
Selenium & API Automation · Feb 2017 – Jan 2018
Aircraft Connectivity Services Management system for aircraft connectivity subscriptions, services, and operational support.
- Automated comparison of 300+ invoices against the legacy system (DB Man).
- Performed cross-browser compatibility testing using Selenium.
- Performed API testing using Postman and Swagger.
My Maintainer — Honeywell ▸
Database Testing · Feb 2017 – Jan 2018
My Maintainer — Honeywell ▸
Database Testing · Feb 2017 – Jan 2018
Aircraft maintenance analytics platform for monitoring fault history and improving maintenance decisions.
- Executed SQL queries to verify aircraft fault history data stored in FHDB.
- Validated data flow between UI and DB for accuracy and consistency.
- Verified data integrity across fleet and aircraft-level reports.
Numerix Leading Hedge — TransAmerica ▸
ETL Testing · Jul 2012 – Apr 2016
Numerix Leading Hedge — TransAmerica ▸
ETL Testing · Jul 2012 – Apr 2016
Risk management and hedging platform used to analyze annuity products and support investment decisions.
- Validated source, staging, and target database loads.
- Performed source-to-target mapping and transformation testing.
- Wrote data mapping test queries using joins and sub-queries.
- Validated constraints, primary keys, data types, and data integrity.
Lorenzo Regional Care — NHS UK ▸
Manual Testing · Sep 2006 – Jun 2012
Lorenzo Regional Care — NHS UK ▸
Manual Testing · Sep 2006 – Jun 2012
Electronic Patient Record (EPR) platform for managing patient information and improving healthcare service delivery.
- Created and executed functional test cases.
- Performed functional validations and defect management.
- Prepared test metrics, reports, and release sign-offs.