SAYAN DUTTA
Kolkata
Summary
A seasoned professional with 12 years of experience as a Senior Data 7 Business Analyst and ETL & Big Data Tester, specializing in the Investment Banking, Capital Market, and Healthcare domains. Highly proficient in the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC), with expertise in Agile methodologies including Scrum Framework, Kanban, and Waterfall models. Holds key certifications, including SAFe Agilist, Google Certified AI Leader, and Salesforce Certified AI Associate.
Overview
12
12
years of professional experience
Work History
Lead
Tata Consultancy Services Limited
12.2021 - Current
- Designed and tested BI dashboards and complex Tableau reports (dashboards, drilldowns, scorecards, summary/master/detail) for global and senior management, ensuring cosmetic accuracy and end-to-end data validation.
- Lead cross-functional teams (analysts to VPs), managed testing lifecycle (test plans, unit/acceptance testing, defect tracking), coordinated stakeholders/resources, and drove training and workflow changes.
Senior Associate
PricewaterhouseCoopers Private Limited
01.2021 - 12.2021
- Performed end-to-end data analysis and validation across ODS → EDW → OLAP layers, validating ETL transformations in Informatica and SSIS to ensure BI data accuracy.
- Provided user support and problem-resolution, maintained standardized reference reports, and collaborated with customers and IT to define business requirements and project scope.
- Facilitated continuous user–development–QA interaction throughout the SDLC, produced clear data/process models for stakeholders, and achieved a 95% testing success rate.
Test Analyst
Infosys Limited
10.2018 - 01.2021
- Executed data scripts and performed detailed analysis, data cleansing/verification, and mismatch identification across EDW/Hive tables (partitions, bucketing, loading) using HQL and SQL.
- Applied ETL methodologies with Informatica PowerCenter to support extraction, transformation, and loading; validated KRIs and reports via SQL, PivotTables, and VLOOKUP.
- Defined and tracked QA metrics (defects, test results/status), prepared/executed test plans and test cases for EDW/web apps, analyzed results, reported defects, and maintained RTMs.
Associate
Cognizant Technology Solutions
02.2014 - 10.2018
- Managed the end-to-end data lifecycle, including gathering, cleansing, and validation, to ensure data integrity and accuracy.
- Developed and executed ETL processes, utilizing complex SQL queries to verify data mapping and maintain daily error logs for efficient data management.
- Spearheaded comprehensive testing protocols, including detailed test case design, regression testing, and issue reporting to project management, guaranteeing quality assurance and project success.
Education
BTECH - Information Technology
West Bengal University of Technology
Kolkata 06-2012
Skills
Programming Language: SQL, Python
Database: IBM DB2, SQL Server
Data Analysis & Business Intelligence Testing
Tableau Report Validation
ETL Testing & Data Warehousing
Big Data Testing & Hadoop Ecosystem: Hive, Databricks
Test Management & Quality Assurance: HP ALM, Jira
Domain Knowledge: Capital Market, Investment Banking, Healthcare
Timeline
Lead
Tata Consultancy Services Limited
12.2021 - Current
Senior Associate
PricewaterhouseCoopers Private Limited
01.2021 - 12.2021
Test Analyst
Infosys Limited
10.2018 - 01.2021
Associate
Cognizant Technology Solutions
02.2014 - 10.2018
BTECH - Information Technology
West Bengal University of Technology