Namya Mandalia
Tempe, AZ *************@*****.*** 623-***-**** linkedin.com/in/namyamandalia/
EDUCATION
Arizona State University Tempe, Arizona
Master of Science in Supply Chain Management May 2025 Ahmedabad Univrsity Gujarat, India
Bachelors Of Business Administrations, Major in Supply Chain Management May 2024 PROFESSIONAL EXPERIENCE
HBT Bearings Pvt Ltd
Associate Demand Planner Jan. 2023-Mar. 2024
• Developed demand forecasts for 700+ SKUs over an 18-month rolling horizon using time series forecasting models, enhancing forecast granularity across product hierarchies.
• Analyzed historical sales trends and market demand drivers to identify key variances, reducing MAPE from over 30% to under 20% for critical categories.
• Led monthly consensus planning reviews with sales, marketing, and inventory teams using Market Insights (MISI) and qualitative inputs, improving planning effectiveness and cross-functional alignment by 20%.
• Performed root cause analysis on forecast deviations for 70+ A-class SKUs, resolving incorrect seasonality profiling and preventing $5M in potential lost sales by maintaining positive bias during peak periods. Meghmani Industries Ltd
Supply Chain Analyst Intern Jun. 2022-Aug. 2022
• Created unconstrained forecasts for both new and existing products using time series models such as Na ıve, Moving Average, and Exponential Smoothing; collaborated with vendors, sales, marketing, and cross-functional teams to drive consensus forecasting.
• Developed monthly analysis reports highlighting key metrics -- Rate of Sale, MAPE, BIAS, Volume Drivers, ASP, OOS%, and Store Count to enhance brand-level forecast accuracy and visibility.
• Identified under-forecasting across 50+ SKUs, uncovering $1M in missed sales opportunities; implemented corrective actions that improved forecast accuracy by 12%.
Pheromone Chemicals Pvt Ltd
Demand Planning Analyst Jan. 2021-May 2022
• Automated master data generation for demand planning using Python, improving process efficiency and accuracy by 40%.
• Analyzed large datasets to uncover demand patterns and trends, enabling data-driven planning decisions.
• Achieved key KPI targets within 6 months by improving MAPE by 14% through item-level root cause analysis and corrective actions. AREAS OF EXPERTISE
Technical Skills: Demand Planning, Forecasting, Advanced Excel (Pivot Tables, Data Models, VLOOKUP), Supply/Build Planning, Demand Forecasting, Data Analysis, Supply Chain Optimization, R, Python, Tableau, Project Management, SQL, PowerBi machine learning, order processing, compliance, business management, international business, cross-functional, attention to detail, organizational skills, communication skills, customer service, problem-solving, team player CERTIFICATIONS
• CCSCMP Supply Chain Foundations: Inventory Management Professional Certificate
• CSCMP Supply Chain Foundations: Demand Planning Professional Certificate PROJECTS
Demand Forecasting & Inventory Optimization
Supply Chain Consultant
• Forecasted sales data over a 3 year period for a nursery company to optimize inventory management by constructing three distinct time-series models, achieving 65% accuracy.
• Enhanced forecasting models by incorporating seasonal patterns, boosting prediction accuracy by 20%.
• Developed interactive Power BI dashboards for real-time demand tracking and sales trend visualization, which decreased analysis time by 20%. Price Forecasting Analysis
Pheromone Chemicals Pvt Ltd.
• Constructed a chemical price forecasting model of import export data with 90% accuracy, integrating insights into Power BI.
• Leveraged SQL stored procedures to extract, cleanse, and aggregate pricing and sales data from three core tables cutting ETL runtime by 50% and enabling real time dashboard refreshes.
• Designed interactive dashboards tracking 5+ KPIs, boosting strategic planning by 30%.