Summary

Overview

Work History

Education

Skills

Certification

Accomplishments

TOOLS & TECHNOLOGIES

Timeline

AMPITA DUTTA BISWAS

ETL/Data Testing & Project Coordination Professional

Kolkata

Summary

Detail-oriented Data Validation & ETL Testing Professional with 11 years of experience in SQL-based validation, source-to-target checks, BI reporting checks, UAT execution, and project coordination. Hands-on experience in validating ETL data loads, performing data reconciliation, identifying mismatches, validating Power BI reports, and supporting ADF pipeline monitoring. Strong in stakeholder coordination, release readiness, audit documentation, and defect management. Possess working knowledge of ETL mapping understanding and basic Data Warehouse concepts such as fact/dimension tables, incremental loads, SCD types, and data flows.

Overview

years of professional experience

Certifications

Work History

Project Coordinator & ETL / Data Validation Analyst

TCS iON

04.2019 - Current

Performed source-to-staging and staging-to-target data validation, including pre/post-load checks, SQL-based reconciliation, and mismatch investigation across nationwide assessment platforms.
Monitored and validated Azure Data Factory (ADF) pipelines, checked pipeline outputs, identified failures, and collaborated with developers for issue resolution.
Conducted transformation rule checks using SQL, verified business logic, and ensured data accuracy for candidate records, hall tickets, test centers, and result datasets.
Validated Power BI dashboards, KPI calculations, and data visuals to ensure accuracy and consistency with backend data.
Executed UAT cycles, including scenario creation, defect logging, triaging, test evidence preparation, and coordination with cross-functional teams.
Managed release readiness activities — deployment support, smoke checks, environment sanity, and post-release data verification.
Coordinated with developers, QA, SMEs, zonal SPOCs, and client stakeholders for timely issue resolution and requirement alignment.
Delivered weekly RAG status, heatmaps, operational dashboards, and progress reports for leadership review.
Maintained audit-ready documentation, including test evidence, RCA reports, version tracking, and compliance reports for governance teams.
Managed end-to-end assessment operations, ensuring data accuracy from pre-exam (candidate data validation) to post-exam (result processing and verification).
Coordinated project timelines and deliverables, ensuring alignment with client expectations.
Facilitated communication between cross-functional teams to drive project success.
Developed and maintained project documentation, enhancing transparency and accountability.

Senior Process Associate

Utility

10.2014 - 04.2019

Worked extensively on SAP CRM for customer data, billing information, and service requests.
Performed data checks, SLA reporting, and audit validation across operations.
Prepared Excel-based automated reports, ensuring accuracy and compliance.
Resolved escalations through data investigation and RCA reporting.
Streamlined operational workflows to enhance efficiency and reduce processing time.
Mentored junior team members on best practices and process improvements.
Analyzed process data to identify trends and recommend strategic enhancements.

Education

MBA - Operations Management (Distance Learning)

NMIMS

Pune, India

01.2024

Bachelor of Arts - Arts

Acharya Prafulla Chandra College

North 24 PGS

05.2001 -

Skills

ETL & Data Warehouse Testing (Source-to-Staging, Staging-to-Target validation, data reconciliation, pre/post load checks, basic understanding of DWH concepts)

SQL (Intermediate) (Joins, aggregations, filters, data profiling, window functions – learning/exposure)

BI Reporting Validation (Power BI dashboards, visuals, KPI checks, business rule testing)

Cloud Concepts (Basics of AWS – S3/Glue concepts, Azure Data Factory pipelines – monitoring & triggers)

UAT & Project Coordination (Deployment readiness, UAT execution, defect tracking, RCA documentation, audit reporting)

Data Quality Checks (Data completeness, consistency, referential integrity checks, duplicates/null analysis)

Stakeholder Management (Client communication, requirement clarification, risk flagging, weekly RAG reporting, heatmaps & status updates)