Sumit Karmakar

Data Analytics Leader with extensive experience in operations, digital marketing, and business intelligence across manufacturing, marketing, and IT domains. Proven expertise in leveraging advanced analytics tools like Power BI, Python, and Azure to deliver actionable insights, automate processes, and drive measurable business improvements. Skilled in managing cross-functional teams, leading global reporting projects, and implementing innovative solutions that enhance decision-making and operational efficiency. Adept at sustainability tracking, cost reduction, and KPI optimization to align analytics initiatives with organisational goals.

Kohler Co, 

Assistant Manager, Operations Data & Analytics    April 2024 – Present

• Led a cross-functional global team to deliver advanced analytics and reporting solutions across key areas, including Project Management, Smart Factory, Manufacturing Analytics, and Cost Out Reports, improving project outcomes and enabling leadership to make informed decisions.
• Directed the automation of global reporting processes, achieving a 30% reduction in report preparation time while ensuring high accuracy, consistency, and timeliness of data delivery.
• Oversaw the development of Manufacturing Analytics Reports, tracking operational efficiency metrics and providing actionable insights to global leadership to streamline processes.
• Guided the creation of Cost Out Reports, comparing forecasted vs. actual cost savings and delivering critical insights for cost optimization initiatives.
• Spearheaded sustainability tracking projects such as Scope 3 Reporting, enhancing compliance with environmental standards and aligning organizational goals with sustainability benchmarks.
• Championed Digital Transformation initiatives for global manufacturing plants, deploying the Microsoft Power Platform to automate data collection, streamline reporting, and develop KPI dashboards for improved visibility and decision-making.

Assistant Manager, Digital Marketing Data & Analytics    April 2022 – April 2024

• Led the end-to-end development and automation of Digital Marketing Reports, integrating data from Azure, Salesforce Marketing Cloud (SFMC), and Adobe Analytics into Power BI dashboards to provide comprehensive insights on KPIs such as open rates, click-through rates, and conversion metrics.
• Optimized data queries and reporting pipelines, achieving a 40% reduction in report refresh times, significantly improving the speed and efficiency of marketing operations.
• Designed and implemented scalable ETL pipelines to unify marketing data from multiple sources, ensuring data accuracy, reliability, and seamless integration.
• Collaborated closely with marketing stakeholders to refine reporting requirements, delivering actionable insights that boosted campaign performance and achieved a 15% increase in ROI.
• Automated recurring Power BI reports, reducing manual workload by 35% and allowing marketing teams to focus on strategic analysis and planning.

Senior Data Analyst    Feb 2021 – Mar 2022

• Designed and implemented interactive dashboards and performed advanced analytics using Power BI, Python, and DAX queries, translating raw data into meaningful insights to support data-driven decisions in marketing and lead generation.
• Developed and maintained scalable BI solutions, enhancing operational efficiency and enabling more accurate forecasting.
• Delivered actionable insights through predictive modeling, improving the effectiveness of lead generation campaigns and digital marketing strategies.
• Managed multiple BI projects, meeting deadlines with consistent quality and delivering measurable business impact.

Concentrix

Lead Data Analyst  Mar 2020 - Jan 2021

• Improved reporting efficiency by 25% through automated data validation and auditing processes.
• Standardized data collection frameworks, reducing inconsistencies by 30% and ensuring seamless integration.
• Created Excel-based incident tracking dashboards, cutting resolution times by 15% for high-impact issues.
• Delivered daily MIS reports with insights on IT Ticketing Analysis, supporting strategic leadership decisions.
• Led a Python-based Root Cause Analysis project, automating processes and reducing manual effort by 40%.
• Mentored junior analysts on data validation and Python scripting, enhancing team skills and productivity.

Hewlett Packard

Senior Technical Analyst   Feb 2018 - Sep 2019                               

• Led and mentored a team of 15 Solution Analysts, implementing the Total Customer Ownership (TCO) model, achieving a 20% reduction in ticket resolution times.
• Designed real-time data reports to track ticket statuses, improving accuracy of insights and reducing delays by 25%.
• Maintained rigorous customer service standards, ensuring SLA compliance and achieving a 95% customer satisfaction score.
• Acted as a liaison between technical teams and leadership, delivering project briefings and resolution strategies.
• Reduced recurrence of high-priority issues by 30% using root cause analysis techniques.
• Streamlined ticket management processes, improving operational efficiency by 10%.
• Utilized tools like ServiceNow, JIRA, and Power BI to monitor tickets, generate insights, and automate reporting.

Technical Analyst  Jun 2017 - Jan 2018

• Resolved web application and cloud resource issues for EMEA clients, ensuring seamless functionality.
• Conducted LogMeIn sessions, troubleshooting issues and providing hands-on training.
• Tracked and prioritized issues using Agile methodology and Microsoft Dynamics CRM, cutting resolution times by 20%.
• Streamlined processes through scrum meetings, improving resource allocation and collaboration.
• Maintained knowledge bases to enhance team efficiency and knowledge transfer.

Junior Technical Analyst  Jun 2016 - May 2017

• Diagnosed and resolved software and hardware issues, reducing downtime and improving customer satisfaction.
• Assisted clients across channels, delivering technical support for account setup and device compatibility.
• Managed escalations and documented insights using Dynamics CRM, enabling process improvements.
• Supported the HP Instant Ink Program Sales, ensuring smooth onboarding and optimized usage for US region HP Customers

Education

Bachelor of Computer Engineering – Gautam Buddha University, Lucknow                                                 (2010 - 2014)