Vishesh Ranka Supply Chain & Operations Management

Vishesh
Ranka

Supply chain and operations professional with hands-on experience across procurement, MRO operations, and production engineering, backed by demonstrated analytics capability in demand forecasting, multi-echelon inventory optimization, and simulation using SQL, Python, and linear programming.

Seeking Supply Chain / Operations internship for Spring 2027 · Open to full time from May 2027
View the work Download Resume Email
PROFILE
Location
Los Angeles, CA
Program
M.S. Engineering Management, USC
Grad. Certificate, Optimization & SCM (USC Marshall)
Focus
Forecasting · Inventory optimization · Simulation
Phone
(213) 574-8237
Email
visheshsunilranka@gmail.com
Links
linkedin.com/in/vishesh-ranka
github.com/vishesh-ranka
12.5% Company-wide forecast accuracy improvement (M5 hierarchical pipeline)
58M Rows staged in SQL across 30,490 product store combinations
100% Distribution center service level in out-of-sample simulation, vs. 87.7% naive
8.3% Holding cost reduction vs. a decentralized baseline (upper bound)

01 Experience

Procurement & Business Operations Intern

NTT Data Limited
Dec 2024 – Feb 2025 Mumbai, India
4–6 suppliers benchmarked per sourcing cycle 2–3× weekly vendor coordination OTIF procurement sustained
  • Enabled faster, data-backed purchasing decisions by building structured Excel vendor scorecards, benchmarking 4–6 suppliers per sourcing cycle on price, lead time, technical specs, and reliability.
  • Sustained cost-effective, on-time-in-full (OTIF) procurement across a large-scale technology supply chain by coordinating 2–3 times weekly with 4–6 vendors on real-time quotes, lead times, and delivery status.

Mechanical Engineering Intern

Air India Engineering Services Limited
Jun 2024 – Oct 2024 Mumbai, India
10% faster servicing turnaround 5% fewer spare-parts stockouts
  • Reduced aircraft servicing turnaround time by 10% through root-cause analysis and testing of hydraulic, pneumatic, and avionics components, supported by precision equipment calibration and enhanced diagnostics.
  • Cut spare-parts stockouts by 5% by designing and implementing an automated inventory tracking system for critical avionics parts, optimizing reorder points and improving supply chain visibility.

Production Engineering Intern

George Philips Medical Engineering Private Limited
Jan 2023 – Apr 2023 Mumbai, India
~12% shorter production cycle time 12% better material utilization 500–2,000 units/day line
  • Reduced production cycle time ~12% by redesigning the syringe pump production workflow and automating quality checks on a 500–2,000 units/day line, applying lean process improvement in cross-functional collaboration with QA and manufacturing.
  • Improved material utilization by 12% through root-cause analysis of production datasets covering cycle times, defect logs, and material usage for the HDM-DPT kit.

02 Projects

PROJECT 01 / FORECASTING

Hierarchical Demand Forecasting & Reconciliation

DuckDB (SQL) Python LightGBM Pandas Nixtla hierarchicalforecast

Built an end-to-end forecasting pipeline for 30,490 product store combinations from a 58M row Walmart (M5) dataset, staging raw data in SQL and generating LightGBM demand forecasts across 5 business levels: company, category, department, store, and item.

Diagnosed a crossed (non-nested) hierarchy structure, where product and geography rollups intersect rather than nest. That structure is the reason a naive bottom-up rollup doesn't reconcile cleanly at every level.

Live dashboard View code on GitHub
PROJECT 02 / OPTIMIZATION

Multi-Echelon Inventory Optimization Under Demand Uncertainty

Python (PuLP) NumPy Pandas Linear programming Monte Carlo simulation Plotly Streamlit

Built a multi-echelon inventory optimization model (linear programming, PuLP) across a 13-node, 3-region global supply network, allocating safety stock between distribution centers and stores under a 95% service level constraint.

Diagnosed autocorrelated demand causing standard safety stock formulas to understate distribution center variability by up to 10.6× over 30–45 day international lead times, and replaced it with empirical quantile based sizing.

Live dashboard View code on GitHub

03 Skills

Supply chain

Demand Forecasting Inventory Management (EOQ, Safety Stock, Reorder Point) Multi-Echelon Inventory Optimization Procurement & Sourcing Supplier Evaluation & Vendor Management MRO Operations Production Planning Lean Manufacturing Supply Chain Optimization Logistics Management Process Improvement Root-Cause Analysis Quality Control (ISO 9000)

Data & analytics

SQL (DuckDB) Python (Pandas, LightGBM, PuLP) Linear Programming Monte Carlo Simulation Data Visualization (Plotly, Power BI) Microsoft Excel (Pivot Tables, VLOOKUP, Solver)

Engineering software

MATLAB AutoCAD SolidWorks

04 Education

  • University of Southern California, Los Angeles, CA Master of Science in Engineering Management Graduate Certificate in Optimization & Supply Chain Management, in progress Aug 2025 – May 2027
  • Bachelor of Technology in Mechanical Engineering Mukesh Patel School of Technology Management & Engineering · Mumbai, India 2021 – 2025