Sudhanshu Kumar
Dubai,U.A.E.
Summary
Dynamic data analyst with expertise in advanced analytics, Power BI, and Python programming. Skilled in big data processing, report generation, and SQL programming, delivering impactful insights through data visualisation and time series analysis. Proficient in Microsoft VBA, driving efficiency in data management tasks. Committed to leveraging analytical skills to support strategic decision-making and enhance business performance.
Overview
12
12
years of professional experience
4
4
years of post-secondary education
Work History
Data Analytics Manager
DBMSC Steel FZCO
Dubai
07.2024 - Current
- Implemented predictive models, improving forecast accuracy.
- Translated complex datasets into clear visualisations for non-technical stakeholders.
- Developed comprehensive dashboards for easy data interpretation and reporting.
- Harmonised disparate datasets, providing a unified view of business metrics.
- Improved data accuracy by implementing robust validation checks.
- Utilised cutting-edge analytics tools to derive key business insights.
- Streamlined decision-making processes with data-driven strategies.
- Designed new systems to enhance data collection, enabling deeper analysis and strategic insights.
- Created Power BI reports providing insight into broad, high-volume datasets for improved business strategy.
- Generated data visualisations to present and communicate analysis results using Power BI.
- Developed MIS reports to highlight gross profit trends, supporting higher management in strategic decision-making.
- Conducted in-depth analysis across sales, finance, and procurement functions to provide actionable insights for management.
Data Analytics Manager
Saint Gobain Abrasive
Mumbai, IN
01.2020 - 11.2023
- Designed intelligence power BI dashboards led to increase in site on-time delivery by 15%
- Created a system to forecast high selling stock items which increased availability from 80 to 90% and reduced lead time from 28 days to 2 days
- Designed power BI dashboards to reduce MRP release time from 3 days to 1 day
- Reduced inventory turns from 3 months to 2 months by analyzing open orders, consumption trends, in transit materials and requirement
- Collected, reviewed and analyzed demand trends from 20+ branches that helped to increase monthly sales by 20% over 2 years
- Created a BI report and monthly review process that identified 230 MINR worth of non-moving inventory and reduced it to 140 MINR over 1 year
- Designed BI report to calculate, review and monitor manufacturing lead time at different stage led to reduction of overall lead time by 25%
- Monitored system performance and identified areas where improvements were needed
- Created dashboards for visualizing data insights in an easy-to-understand format
- Collaborated with stakeholders across departments to understand their requirements for data analysis projects
- Established KPIs, tracked performance metrics, and produced reports on business trends
- Developed and implemented data-driven solutions to improve operational efficiencies and reduce costs
- Used Python, SQL and Power BI to efficiently gather and analyze large data sets and create dashboards
PPC Engineer
Saint Gobain Abrasive
Mumbai, IN
06.2018 - 12.2019
- Managed scheduling and sequencing of 5 production lines with monthly output of around 400 tons
- Automated excel based planning with help of VBA macros led to increased planning efficiency by 15%
- Increased on-time delivery by 10% by reducing planning horizon from monthly to weekly
- Created a database and monthly review process that helped forecast the increase in demand and be prepared for spike in order inflow
- Assisted central supply chain to establish S&OP process by providing production and planning related data after analyzing
Production Engineer
Saint Gobain Abrasive
Mumbai, IN
10.2016 - 05.2018
- Managed organic department production with 11 pneumatic presses and 6 mixing machines
- Increased productivity by increasing planning horizon from 2 days to 6 days resulted in increase in monthly output by 20%
- Managed 3 WCM audits as a QPC pillar leader for 2 pilot machines led site to be WCM silver certified
- Designed a excel based UI to convert paper based database to system based which resulted in analyzing losses easily and helped to increase ontime delivery by 10%
- Led an input output project for 6 months which lead to identify 3% unaccounted loss by designing system to calculate volumes of complicated shapes
Production Engineer
KLT Automotive & Tubular Products Ltd
Mumbai, IN
06.2013 - 10.2016
- Managed scheduling and sequencing of 25 hydraulic presses and more than 500 SKU
- Increased planning efficiency by 20% and yield by 15% by identifying variance, green stage scrap in sheet metal
- Reduced assembly loss time by 15% by maintaining system based daily production report and hourly monitoring system
- Increased output by 10% by analyzing raw rejection and dimensional based rejections
- Managed more than 200 operators under 3 different plants on daily basis
- Reduced system Vs physical variance up to 2% by proper maintenance of BOM for actual consumption
- Created a database of 500 SKU with 3D views using PRO-E that helped identifying the products by workers and optimized non-moving inventory
Education
Bachelor of Engineering (B.E.) - Mechanical Engineering
Mumbai University
Mumbai, India 06.2009 - 05.2013
Skills
- Advance Analytics
- Power BI
- Python Programming
- Big Data Processing
- Report Generation
- SQL Programming
- Microsoft VBA
- Time Series Analysis
- Data Visualization
Languages
English
Fluent
Hindi
Native
Timeline
Data Analytics Manager
DBMSC Steel FZCO
07.2024 - Current
Data Analytics Manager
Saint Gobain Abrasive
01.2020 - 11.2023
PPC Engineer
Saint Gobain Abrasive
06.2018 - 12.2019
Production Engineer
Saint Gobain Abrasive
10.2016 - 05.2018
Production Engineer
KLT Automotive & Tubular Products Ltd
06.2013 - 10.2016
Bachelor of Engineering (B.E.) - Mechanical Engineering
Mumbai University
06.2009 - 05.2013
Similar Profiles
SANJAY HaldarSANJAY Haldar
Head of Quality at DBMSC STEEL FZCOHead of Quality at DBMSC STEEL FZCO
MOHAMED SAFEEK AHAMEDMOHAMED SAFEEK AHAMED
Procurement Assistant at Steel Wood Industries FZCOProcurement Assistant at Steel Wood Industries FZCO
PARVEZ ALI KHANPARVEZ ALI KHAN
Accountant at Techmax Trading Services FZCOAccountant at Techmax Trading Services FZCO