Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic
SAYAN DUTTA

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
SAYAN DUTTA