Open to opportunities

Shivam Ranaut

@shivamranaut

Message

Data Analyst using Python, SQL, and Power BI to turn business questions into clear, actionable decisions.

India

Message

What I'm looking for

I want to apply data analysis to operational and supply-chain decisions—building dashboards, forecasting demand, and finding cost or workflow improvements with tools like Excel, SQL, Python, and Power BI.

I focus on using data to answer tough business questions, from optimizing operational costs to forecasting future demand. I combine tools like Excel, SQL, and Power BI with the ability to translate complex metrics into clear strategies stakeholders can act on.

In my internship with SRHydrates (Production & Operations), I managed end-to-end production workflow for customized water bottles and supported uninterrupted manufacturing by tracking critical raw materials like labels, caps, and corrugated boxes. I also helped with operational improvements by monitoring production-related metrics.

I’ve built logistics and inventory work using Excel Solver and linear programming to simulate routing scenarios, and I created interactive KPI dashboards (Order Cycle Time and Fulfillment Rates) using Excel/Power BI to drive SOP improvements.

Experience

Work history, roles, and key accomplishments

Intern (Production & Operations)

SR Hydrates

Oversaw the end-to-end production process, ensuring efficient and safe manufacturing of customized water bottles for diverse brands. Managed inventory levels of critical raw materials to support uninterrupted production workflows.

Production Management Inventory Management Operations