Soumyadipta Paul profile photo 1 on Tal

Soumyadipta Paul

Senior Data Modeler & Data Governance Professional | AI Governance | ETL Solution Designer

Kolkata

12+ years of work experience

Cognizant
Jun 20224 yrsPresent

West Bengal, India

► Data Modeling Governance • Work with Data Modeling team and ensure that we get a clear understanding of any new requirement - scope, timelines. Go into connects with the stakeholders, Data Modeler, Solution Design Architect and Data Architect. • Facilitate Data Modelers during Data Analysis phase to clear doubts and blockers. Help them ask the right questions to the right people at the right time. • Review Source to Target mapping document and ERwin Solution model prepared by the Data Modelers ensuring Data Modeling best practices are followed. • Perform Cataloging activities in Collibra - Classification of Assets, Preparation of EDM Models, Stitching: LDD-PDD and LDD-Glossary
Tata Consultancy Services
Oct 20183 yrs 8 mosMay 2022

Kolkata, West Bengal, India

• Involved in designing data movement from on-premise Oracle DB to GCP. • Working as Solution Architect for CCN designs to ingest data from source systems using cloud native tools such as Google Cloud Storage, Data Flow, Cloud Function, Composer, BigQuery • Scrum Master for a squad of 10 members. • Worked as Solution Designer providing ETL solutions for business requirements in on-prem using Oracle PLSQL • Mentor the development team, providing technical support • Assisting the team with performance tuning for ETL and database processes • Organise knowledge transfer sessions with junior colleagues to provide direction and mentorship on SQL/PLSQL related topics and ETL deliverables • Establish best practices, processes and focus on continuous improvement
Tata Consultancy Services
Apr 20148 yrs 2 mosMay 2022

Tata Consultancy Services
Apr 20153 yrs 6 mosSep 2018

Kolkata, West Bengal, India

• Worked in data modelling - Fact and Dimensions. Building Entity-Relationship diagrams. • Worked in building Slowly Changing Dimensions, dimensional surrogate key handling, exception handling, table partitioning, dynamic SQL • Hands on experience in developing/enhancing front end reporting apps in Qlik Sense • Worked as a developer in the migration of: Oracle11g to Oracle12c • Troubleshoot performance issues, perform RCA, build strategic solutions to resolve the root cause

Education

Asansol Engineering College (AEC)

Bachelor of Technology - BTech, Electrical Engineering

Asansol Engineering College (AEC)

20064 yrs2010

St. Patrick's HS School

199412 yrs2006

Join Soumyadipta and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Soumyadipta Paul on Tal

Headline

Senior Data Modeler & Data Governance Professional | AI Governance | ETL Solution Designer

About

I am a senior data modeling and data governance professional with 15+ years of experience designing, governing, and optimizing enterprise-scale data solutions across complex and compliance-driven environments. My core expertise spans logical and physical data modeling, metadata management, data lineage, data quality, and the implementation of robust governance frameworks. In addition to governance and design responsibilities, I bring strong hands-on experience in SQL-based data analysis, including working with Databricks on AWS to analyze datasets, perform data quality checks, and support both business and analytical use cases. I have collaborated closely with architects, engineers, analysts, and business stakeholders to translate requirements into scalable, well-structured data designs. I also have a good understanding of responsible AI principles, AI risk management, model governance considerations, and regulatory expectations. While my hands-on background is rooted primarily in data governance, data modeling, and SQL-driven analysis, I am well-equipped to support AI initiatives from a data trust, compliance, and risk-awareness perspective. I’m particularly drawn to opportunities in data governance, data standards, and solution design review-roles where informed decision-making, critical thinking, and purposeful design are essential for ensuring data quality and organizational success. I am open to both remote and hybrid opportunities.

Location

Kolkata

Work experience

Manager Projects at Cognizant, Jun 2022 - Present · 4 yrs, West Bengal, India, ► Data Modeling Governance • Work with Data Modeling team and ensure that we get a clear understanding of any new requirement - scope, timelines. Go into connects with the stakeholders, Data Modeler, Solution Design Architect and Data Architect. • Facilitate Data Modelers during Data Analysis phase to clear doubts and blockers. Help them ask the right questions to the right people at the right time. • Review Source to Target mapping document and ERwin Solution model prepared by the Data Modelers ensuring Data Modeling best practices are followed. • Perform Cataloging activities in Collibra - Classification of Assets, Preparation of EDM Models, Stitching: LDD-PDD and LDD-Glossary

Assistant Consultant at Tata Consultancy Services, Oct 2018 - May 2022 · 3 yrs 8 mos, Kolkata, West Bengal, India, • Involved in designing data movement from on-premise Oracle DB to GCP. • Working as Solution Architect for CCN designs to ingest data from source systems using cloud native tools such as Google Cloud Storage, Data Flow, Cloud Function, Composer, BigQuery • Scrum Master for a squad of 10 members. • Worked as Solution Designer providing ETL solutions for business requirements in on-prem using Oracle PLSQL • Mentor the development team, providing technical support • Assisting the team with performance tuning for ETL and database processes • Organise knowledge transfer sessions with junior colleagues to provide direction and mentorship on SQL/PLSQL related topics and ETL deliverables • Establish best practices, processes and focus on continuous improvement

Solutions Designer at Tata Consultancy Services, Apr 2014 - May 2022 · 8 yrs 2 mos

IT Analyst at Tata Consultancy Services, Apr 2015 - Sep 2018 · 3 yrs 6 mos, Kolkata, West Bengal, India, • Worked in data modelling - Fact and Dimensions. Building Entity-Relationship diagrams. • Worked in building Slowly Changing Dimensions, dimensional surrogate key handling, exception handling, table partitioning, dynamic SQL • Hands on experience in developing/enhancing front end reporting apps in Qlik Sense • Worked as a developer in the migration of: Oracle11g to Oracle12c • Troubleshoot performance issues, perform RCA, build strategic solutions to resolve the root cause

Education

Bachelor of Technology - BTech, Electrical Engineering, Asansol Engineering College (AEC)

St. Patrick's HS School