Yashas Sudarshan
Supply Chain Data Analyst
Bengaluru
Summary
Results-driven Supply Chain Data Analyst with over 13 years of experience delivering data-driven solutions across inventory management, demand forecasting, and predictive modeling. Proven success in building interactive dashboards, automating workflows, and driving operational efficiency using Power BI, Snowflake, Power Apps, and Excel VBA. Recognized for impactful contributions to multi-million-dollar cost savings and data projects by senior leadership.
Overview
13
13
years of professional experience
4
4
Certifications
Work History
Senior Supply Chain Data Analyst
Caterpillar India Engineering Solutions Private Limited
Bengaluru
01.2021 - Current
- Designed and deployed a predictive model using Snowflake and Power BI — considered existing machine population, regional distribution, part-level history, supplier lead times, and past failures which helped in savings of $6M annually
- Developed an Excess Inventory Dashboard that led to multi-million dollar cost savings by identifying obsolete and fast/slow-moving parts, analyzing emergency/future orders, and calculating carrying costs.
- Built and maintained the Dealer Pro Dashboard, used by a key dealer in India — tracks inventory orders and conversion rates, with plans to roll out globally.
- Developed a SAS-based dashboard for a major dealer (in collaboration with a teammate), including DAX-based logic, gateway setups, and multiple iterations with stakeholders.
- Spearheading development of internal automation tools using PowerApps and Power Automate.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
Supply Chain Analyst
Caterpillar India Engineering Solutions Private Limited
Bengaluru
01.2016 - 12.2020
- Recognized by VP for automating workflows using Excel VBA, reducing 2,500 man-hours annually and improving efficiency by 30%.
- Led a global QA cost-reduction initiative saving $200,000/year by optimizing scrapping procedures.
- Developed Power BI dashboards and Excel-based reports to support supply chain visibility and reporting.
- Supported cross-functional planning teams and transitioned from manual reporting to automated BI tools.
Engineer - Quality
KDDL Limited
Bengaluru
09.2014 - 01.2016
- Directed standardization project increasing production output by 2%, adding 800 units/year.
- Ensured compliance with AS9100C, resourcing gates, and PPAP processes.
- Led problem-solving and product quality improvement initiatives for aerospace components.
Manager
The Oil and Flour Mills
Mysore
12.2012 - 08.2014
- Managed inventory and streamlined SCM documentation processes.
- Maintained ERP systems to optimize SCM performance.
- Implemented quality control compliance and drove customer satisfaction.
Education
Master of Science - Mechanical Engineering
Coventry University
Coventry, United Kingdom 04.2001 -
Bachelor of Engineering - Industrial And Production Engineering
The National Institute of Engineering
Mysore, India 04.2001 -
Skills
Power BI
DAX
Power Query
Snowflake
SQL
Excel VBA
SAS
Power Apps
Power Automate
Predictive Modeling
Inventory Management
Demand Forecasting
Supply Chain Analytics
Data Modeling
Certification
Microsoft Power BI Desktop for Business Intelligence – Udemy
Recognition And Leadership
- Recognized by VP for innovations in process automation & cost reduction (Caterpillar)
- Led and mentored 2-member analytics team from 2021 to 2023. Leading a team of 3 members now.
Timeline
Senior Supply Chain Data Analyst
Caterpillar India Engineering Solutions Private Limited
01.2021 - Current
Supply Chain Analyst
Caterpillar India Engineering Solutions Private Limited
01.2016 - 12.2020
Engineer - Quality
KDDL Limited
09.2014 - 01.2016
Manager
The Oil and Flour Mills
12.2012 - 08.2014
Master of Science - Mechanical Engineering
Coventry University
04.2001 -
Bachelor of Engineering - Industrial And Production Engineering
The National Institute of Engineering
04.2001 -