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
11
11
years of professional experience
2
2
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, India01.2024
Bachelor of Arts - Arts
Acharya Prafulla Chandra College
North 24 PGS 05.2001 -
Skills
Certification
CRM 7 (TCS) Utility Domain (Year 2016)
Accomplishments
- 24/02/2025 Best Delivery Award - For smoothly execution of a big stakeholder project. (Year - 2025)
- 20/10/2024 Service Commitment Award - For consistent service excellence. (Year - 2017, 2019 & 2024)
- 20/08/2021 Appreciation from IITKGP - For smoothly execution of a project during COVID- 19. (Year - 2021)
- 23/01/2019 Star Performer Award – TCS - For exceptional performance. (Year - 2016 & 2019)
TOOLS & TECHNOLOGIES
- ETL Azure Data Factory, Informatica (basic exposure)
- BI Power BI, Tableau/Qlik (exposure)
- Databases SQL Server, MySQL, Oracle (exposure)
- Cloud Azure, AWS (basic), Databricks (conceptual)
- Tools Excel (Advanced), Power Query, SAP CRM, SharePoint, MS Teams
Timeline
Project Coordinator & ETL / Data Validation Analyst
TCS iON
04.2019 - Current
Senior Process Associate
Utility
10.2014 - 04.2019
Bachelor of Arts - Arts
Acharya Prafulla Chandra College
05.2001 -
MBA - Operations Management (Distance Learning)
NMIMS