Tuhin Chakraborty
Kolkata
Summary
Assistant Consultant working in TCS
- 14+ years of data and analytics experience, with expertise in data modelling and stakeholder engagement at Johnson & Johnson/Kenvue. Proven track record in developing robust data ingestion frameworks and enhancing data governance. Skilled in data visualization tools like Tableau and Power BI, driving impactful business insights and fostering collaboration across teams to resolve complex data challenges.
- Analytical professional with technical knowledge and critical thinking skills to thrive in data-driven environments. Tackles challenges with positivity and drive to overcome. Works great alone or with others and consistently exceeds expectations.
- Experience in stakeholder management comprising 2+ years of working in Canada, dealing directly with business users.
- Experienced in fast-paced environments and adaptable to last-minute changes. Thrives under pressure and consistently earns high marks for work quality and speed.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Assistant Consultant (Business Analyst)
Kenvue (Consumer Customer 360 Data Products)
Toronto
05.2022 - Current
- Engaging stakeholders to gather and define business requirements.
- Creating Test document in Jira with proper business use cases, acceptance criteria
- Working in Tableau and Power BI to identify key business metrics for business value addition.
- Data analysis in Snowflake to perform a gap analysis for new enhancements and business requirements.
- Data study for Canada retailers like Walmart, Costco, Amazon etc to create new ingestion process for respective retailer Inventory/POS/Store Inventory data
Assistant Consultant (Data Modeller/Data Warehouse Architect
Johnson & Johnson (Consumer data product sales/revenue)
Kolkata
03.2018 - 04.2022
- Built conceptual and logical models using Erwin to support analytics.
- Create and update the data dictionary and lineage in Alation to facilitate data governance.
- Developed and modelled a data ingestion framework using Azure Databricks(Pyspark/Sql) via Azure Data Factory.
- Creation of L0, L1, and L1 plus layers to store raw data from the source in the L0 layer, data profiling, cleansing, harmonization, and transformation in the L1 layer, updating and writing delta log/data to the L1 plus layer with specific business logic required for reporting purposes.
- Writing L1 plus data to Snowflake and linking Snowflake with Tableau for visualization purposes.
- Using ADLS and creating Iceberg tables in Snowflake for directly reading the delta data from ADLS.
IT Analyst (Data Visualization Specialist)
Johnson & Johnson (Consumer Product Market Campaign)
Kolkata
06.2014 - 02.2018
- Created detailed technical specifications for dashboard and report requirements.
- Perform a feasibility analysis and impact assessment for the reports that need to be developed, and then develop the wireframe/UI for the report.
- Create interactive business reports containing the stacked bar chart, Pareto, donut chart, etc. in Tableau, with the business KPIs like social impression, clicks, views etc.
- Validation of data in the report with the backend AWS Redshift database to establish data sanity and integrity.
- CI/CD implementation using Jenkins and Bitbucket.
- Test case creation and completion in Jira as part of SIT and UAT.
- Migration of Tableau reports to Power BI.
- Create new reports in Power BI for POC purpose
Trainee (Support Engineer)
Johnson & Johnson (Ethicon Endo Surgery Products)
Kolkata
01.2010 - 05.2014
- Provided L2/L3 support for analytics platforms.
- Monitored ETL pipelines (developed in Informatica) using Control M, and managed incident queues.
- Provided support to end-users in troubleshooting application issues. Debug and analyze the data issues in Cognos Reporting Studio, and backtrack the data in Informatica and Oracle to mitigate and resolve the data discrepancies.
- Collaborated with cross-functional teams to identify and resolve data-related issues.
- Streamlined acquisition of reporting requirements and specifications to disseminate across multiple business lines and IT support teams.
Education
Bachelor of Technology - Information Technology
Techno India Saltlake
Kolkata07-2010
Skills
- Data Modelling
- Data Governance
- Data Warehousing
- Data visualization
- Stakeholder engagement
- Effective communication
- Project management
- Problem solving
Certification
- Tableau Desktop Specialist
- Microsoft Power BI Associate (DA-100, PL-300)
- Snowpro Core (COF-C02)
- Azure Fundamentals (AZ-900)
Languages
- English
- Hindi
- Bengali
Functional Experience
- Commercial Operations/Sales and Marketing: Sales Analytics over customer/product, Master Data Management (Customer Mastering and Golden Record Creation)
- Contract Management (Contract Lifecycle Management, Contract Pricing, Contract Performance Monitoring, and Compliance Tracking), Market Share and Third-Party Sales, Field Sales Organization Analytics (Alignments, Product Marketing, Performance, and Payments)
- Supply Chain: Order to Cash Process, Inventory Management, Bill of Material
Skill
- Database: Oracle, RedShift, Snowflake, SQL Server
- Visualization - Cognos, Tableau, Power BI
- Data Catalog – Alation
- ETL – Informatica, Python, Databricks
- Data Cloud Services – AWS, Azure
Timeline
Assistant Consultant (Business Analyst)
Kenvue (Consumer Customer 360 Data Products)
05.2022 - Current
Assistant Consultant (Data Modeller/Data Warehouse Architect
Johnson & Johnson (Consumer data product sales/revenue)
03.2018 - 04.2022
IT Analyst (Data Visualization Specialist)
Johnson & Johnson (Consumer Product Market Campaign)
06.2014 - 02.2018
Trainee (Support Engineer)
Johnson & Johnson (Ethicon Endo Surgery Products)
01.2010 - 05.2014
Bachelor of Technology - Information Technology
Techno India Saltlake
Similar Profiles
Navaz DadachanjiNavaz Dadachanji
Manager - Ethics & Compliance at KENVUE (JNTL CONSUMER HEALTH INDIA PVT. LTD.)Manager - Ethics & Compliance at KENVUE (JNTL CONSUMER HEALTH INDIA PVT. LTD.)
Nana OkanoNana Okano
Shopper Activation, Brand Management at Kenvue (former.Johnson&Johnson - Consumer Health)Shopper Activation, Brand Management at Kenvue (former.Johnson&Johnson - Consumer Health)
Rishabh JainRishabh Jain
Head of Procurement at Kenvue (formerly J&J Consumer)Head of Procurement at Kenvue (formerly J&J Consumer)
SATYARANJAN DEYSATYARANJAN DEY
Network Engineer at Tata Consultancy ServicesNetwork Engineer at Tata Consultancy Services
ASWINI KUMAR SHARMAASWINI KUMAR SHARMA
Associate General Manager – Procurement at AMPIN Energy Transition Pvt. Ltd.Associate General Manager – Procurement at AMPIN Energy Transition Pvt. Ltd.