Yash Sonawane
Supply Chain Data Analyst
Fullerton,CA
Summary
Results-driven Supply Chain Data Analyst with 4 years of experience in leveraging data analytics to optimize supply chain
operations, reduce costs, and improve efficiency. Proficient in Power BI, SQL, Python, and data modeling, with expertise in
inventory management, demand forecasting, supplier performance analysis, and logistics optimization. Skilled in developing
interactive dashboards and ETL workflows to ensure accurate, real-time insights that drive data-driven decision-making. Adept
at collaborating with cross-functional teams to streamline processes, enhance reporting efficiency, and improve overall supply
chain performance. Passionate about data storytelling, predictive analytics, and business intelligence, with a strong focus on
transforming complex data into actionable insights for business growth.
Overview
5
5
years of professional experience
Work History
Supply Chain Data Analyst
State Street
01.2024 - Current
- Developed data-driven dashboards in Power BI to monitor supply chain performance, reducing reporting time by 30%
- Analyzed inventory, procurement, and logistics data, leading to a 15% cost reduction in supply chain operations
- Built SQL-based data pipelines to integrate supply chain data from multiple sources, improving data accuracy by 25%
- Collaborated with cross-functional teams, including procurement, finance, and logistics, to optimize demand forecasting and inventory management
- Implemented ETL workflows using SQL and Power Query, ensuring clean and structured data for reporting
- Automated supplier performance tracking, improving vendor evaluation efficiency by 20%.
Data Analyst
Experion Technologies India
01.2020 - 12.2022
- Designed interactive dashboards in Power BI and Tableau, providing real-time insights into supply chain metrics for senior management
- Led demand forecasting initiatives, improving forecast accuracy by 20%, reducing stockouts and overstock situations
- Optimized SQL queries and data models, improving report generation speed by 40%
- Conducted root cause analysis of logistics delays, leading to a 12% improvement in delivery times
- Collaborated with data engineers and supply chain teams to implement automated data validation processes, improving data quality
- Developed custom reports for procurement and inventory teams, enabling data-driven decision-making.
Education
Master of Science - Computer Science
California State University Dominguez Hills
May 2024
Bachelor of Engineering - Information Technology
MIT College of Engineering
July 2021
Skills
- Data Analysis & Visualization: Supply Chain Analytics, Dashboard Design, KPI Tracking, Data Storytelling, Trend Analysis
- Forecasting, Interactive Visualizations, Root Cause Analysis
- Data Management & Modeling: Data Cleaning, Data Normalization, Data Warehousing, ETL (Extract, Transform, Load), Star &
- Snowflake Schema, SQL Query Optimization, Relational Databases
- Supply Chain & Business Intelligence: Inventory Optimization, Demand Forecasting, Logistics & Transportation Analytics
- Procurement Analysis, Supplier Performance Monitoring, Cost Analysis, Warehouse Management, Risk Management
- Query & Scripting Skills: SQL (Joins, CTEs, Stored Procedures), Power Query (M Language), DAX (Data Analysis Expressions)
- Python (Pandas, NumPy, Matplotlib), R (ggplot2, dplyr)
- Tools & Technologies: Power BI, Tableau, Excel (Power Pivot, Power Query, VBA), Google Sheets, SQL Server, SAP, Oracle ERP
- Snowflake, Google BigQuery, Python, R
Timeline
Supply Chain Data Analyst
State Street
01.2024 - Current
Data Analyst
Experion Technologies India
01.2020 - 12.2022
Master of Science - Computer Science
California State University Dominguez Hills
Bachelor of Engineering - Information Technology
MIT College of Engineering
Similar Profiles
Mitchell AndersonMitchell Anderson
Officer at State StreetOfficer at State Street
Parameswaran MParameswaran M
Assistant Vice President – Application Support, Hedge Fund Support at State StreetAssistant Vice President – Application Support, Hedge Fund Support at State Street
Chloe CookChloe Cook
Senior Associate at State StreetSenior Associate at State Street