Tuhin Kumar Mukherjee
Data Modeler/Data Architect
Kolkata
Summary
- Tuhin is currently working as Data Architect/Data Modeler and having 16+ years of professional experience. His core strengths are on the subjects of data architecture, data modeling, ETL Development, data warehousing and database design. His experience includes working in the Life Science,Banking, Insurance, Telecommunication, Airlines and Industry domain. He has been involved in the complete software development lifecycles, starting from requirements analysis to final production deployment.
- Proficient in analyzing and translating business requirements to technical requirements and architecture.
- Develops and approves strategies for continuous improvement in data management
- Translate Business Requirements to Conceptual and Logical Data Models
- Recognize the need for a specific relational design - OLTP, OLAP, Data Warehouse - from a set of requirements and/or from a Logical Data Model
- Participate in the mapping of Logical to Physical Data Models and vice versa (Reverse Engineering)
- Good understanding of Conceptual, Logical and Physical designs and familiar with ER diagrams.
- Heavily interacted with the Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources coming up with load strategies of loading staging area and data marts. Dealt with Type1/ Type2/ Type3 loads excessively
- Experience in DWH ETL mapping documents
- Experience in data modeling using ERStudio, ERWin and IBM IDA tools
- Evaluate other Modeler's logical and/or physical data models for adherence to modeling
- Manage multiple assignments simultaneously, whether working independently or in teams
- Identify, recommend and implement emerging Modeling and IT trends, tools and solutions
- Experience in Software Development Life Cycle involving Data Modeling, Data Architecture, ETL design and development of the application as well as Production Support.
- Identify/Fix SQL performance issues
- Conduct/attend requirements definition meetings with end-users and document system/business requirements
- Have excellent written and oral communication skills with the ability to communicate appropriately in business and technical situations at all levels.
- Successfully handled various roles and responsibilities in the project life cycle.
- Highly motivated with the ability to work effectively in teams as well as independently.
Overview
17
17
years of professional experience
Work History
Senior Data Architect
CAPGEMINI TECHNOLOGY SERVICES INDIA LIMITED
09.2023 - Current
- Collaborated with business stakeholders to translate requirements into actionable data architecture plans.
- Actively participated in regular code reviews helping improve overall code quality across the team.
- Provided technical guidance to junior team members, fostering career growth and skill development.
- Conducted periodic performance tuning exercises to proactively address potential bottlenecks in the system.
- Simplified complex datasets through normalization techniques, enabling easier interpretation by endusers.
- Developed comprehensive database documentation, facilitating better collaboration among team members.
- Mentored new hires on best practices followed by the organization aiding their smooth transition into their roles.
- Enhanced data integrity by designing and implementing robust data models and schemas.
Sr. Data Modeler
IBM INDIA PVT LTD
01.2022 - 09.2023
- Prepare and implement timeline for the Data Model deliverables
- Reverse engineering done from the ddl script provided by the client
- De-normalized the tables wherever it was required, also performed data analysis
- Responsible for designing warehouse logical data model and physical data model
- Data-Definition created for each element in the data-model design
- Define conceptual models, logical models and support physicalizing of the models with all the required KPI
- Review the data model with functional and technical team
- Created Technical Design Documents
- Providing technical/functional support to ETL Team Members
- Develops and approves strategies for continuous improvement in data management
- Comply with regulatory requirements such as BASEL, GDPR.
Senior Project Manager - Data Modeler
HCL TECHNOLOGIES LTD
04.2021 - 01.2022
- Develops and approves strategies for continuous improvement in data management
- Provide guidance and leadership to perform analysis and provide solutions
- Assists with coordination of database changes within context of overall configuration management process
- Manage multiple assignments simultaneously, while working independently, and with other engineers and SMEs
- Identifying, recommending and implementing emerging Modeling and IT trends, developments, tools and improvements/solutions
- Create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques.
Senior Lead Analyst
INFOSYS
01.2020 - 04.2021
- Working as a Lead Data modeler for Datawarehouse development project
- Responsible for preparing ERDs and source to target mapping documents for ETL team
- Involved in Data Analysis for new requirements
- Working knowledge of BDM ETL tool and Erwin Data modelling tool
- Implemented slowly changing dimensions
- Type I and II as per the requirements
- Involved in effort estimations and driving the enhancements till deployment
- Designed the different layers Staging, Data Integration, EDM, Business Access layer with all the required KPI to support the Power BI Dashboards.
Senior Advisory Analyst
IBM INDIA PVT LTD
03.2012 - 01.2020
- Prepare Software Project Management Plan and obtain approval from program management and line management of involved departments
- Perform regular lessons learned and ensure defined software development processes are continuously improved
- Identify SW development work products, plan and monitor their regular release within SW Maturity Gate according to the defined software development lifecycle
- Define and establish planning guidelines and priorities for SW development
- Find, evaluate, estimate and track change management issues (effort, timing, risks)
- Manage release recommendation and estimation of technical risks.
IT Analyst
TATA CONSULTANCY SERVICES LIMITED
08.2010 - 03.2012
- As per the ETL handover documents developing, designing and modify parallel jobs and create the sequence for running parallel jobs
- Communicate with the Business Analyst to clarify doubts on business requirements
- Conduct unit testing and prepare all testing related all documents and deliverables
- Ensure Onsite/Offshore communication
- Co-ordination with the different teams
- Leading the ETL Development team through providing estimation, work allocation, monitoring, reporting
- Guiding/mentoring junior members in the team
- Monitoring System Status on different servers
- Bug logs Management within SLA
- Total ownership of CRs and URs
- Managed Team Members
- Designed & Configured the routines and scripts for sending the critical alerts from the production support environment prospective
- Helped Production support team in resolving issues.
Associate Software Engineer
IBM INDIA PVT LTD
04.2007 - 08.2010
- As per the ETL handover documents developing, modify parallel jobs and create the sequence for running parallel jobs
- Participate in system testing
- Monitoring System Status on different servers
- Monitoring the jobs and resolving the errors
- Ensure Onsite/Offshore communication
- Monitoring and resolving the different applications issue
- Co-ordination with the different teams for operation support
- Knowledge Transfer to trainees.
Education
Bachelor of Technology - Information Technology -
UNIVERSITY OF CALCUTTA
Master of Technology - Radio Physics and Electronics - undefined
UNIVERSITY OF CALCUTTA
Skills
Data Modeling Tool: IBM Infosphere Data Architect 8100 (IDA), Erwin, ERStudio 170ETL Tool: DataStage v75, 80, 90, SSIS
Database/DWH: Snowflake, Oracle 11g, 12c, Netezza, DB2, MS SQL Server
BI Tools: Power BICloud: AzureProcesses/Methodology: ITIL, AgileFunctional/Core Competencies: Requirement Analysis, Design, Coding, Documentation, Testing, Functional Support Defining escalation / response /resolution time for reported problems on the basis of criticality, Mentoring team and handling deployment of tasks Client Interaction, End to end query management, Team ManagementMajor Clients Handled
- Barclays, UK
- ING, Netherlands
- Telstra, Australia
- USAA, US
- Etihad Airways, UAE
- CITI BANK, US
- Hutchison Three, UK
- Celcom, Malaysia
- CITI GROUP, UK
- NETAPP, US
Timeline
Senior Data Architect
CAPGEMINI TECHNOLOGY SERVICES INDIA LIMITED
09.2023 - Current
Sr. Data Modeler
IBM INDIA PVT LTD
01.2022 - 09.2023
Senior Project Manager - Data Modeler
HCL TECHNOLOGIES LTD
04.2021 - 01.2022
Senior Lead Analyst
INFOSYS
01.2020 - 04.2021
Senior Advisory Analyst
IBM INDIA PVT LTD
03.2012 - 01.2020
IT Analyst
TATA CONSULTANCY SERVICES LIMITED
08.2010 - 03.2012
Associate Software Engineer
IBM INDIA PVT LTD
04.2007 - 08.2010
Bachelor of Technology - Information Technology -
UNIVERSITY OF CALCUTTA
Master of Technology - Radio Physics and Electronics - undefined
UNIVERSITY OF CALCUTTA