Subham Kumar Sahana

About Subham Kumar Sahana

II bridge business and data—aligning stakeholders, managing delivery, and building BI solutions with Power BI, SQL, and automation.My professional foundation started in research and applied innovation. I published work on a Coil-based Water Level Sensor with Quality Detection and secured patents for solutions including Wastewater Treatment Powered by Solar Energy and a Biomechanical Electrolarynx Device. This experience built a strong habit of structured problem-solving, documentation, and translating complex concepts into practical results.In analytics and BI projects, I specialize in building Power BI dashboards that translate complex datasets into actionable insights. I focus on data reliability through standardization, validation, and deduplication, and improve report usability by optimizing models and DAX measures for performance.What I bring- BI & Visualization: Power BI, dashboards, KPI design, DAX, data modeling- Data & Querying: SQL (MySQL Workbench), debugging/optimizing queries, accurate data extraction- Business Analysis: requirement gathering, stakeholder coordination, converting needs into metrics and reports- Project Management: planning, tracking, coordination, delivery support- Automation: streamlining recurring reporting and data workflows to reduce manual effort and errorsCurrently pursuing a PGDM (Digital Business & Analytics) and continuously building real-world projects to strengthen my analytics and delivery capabilities.Let’s connect if you are hiring for Business Analyst / BI Analyst / Data Analyst / Project roles where analytics and automation can drive impact.

Experience

1. Planning & Replenishment Analyst

   FreshToHome

   Jan 2026 — Present · Bengaluru, IN

   Managed planning & replenishment for quick-expiry SKUs, translating demand signals into replenishment actions to support dark-store fulfilment- Forecasted SKU-level demand and maintained measurable KPIs: availability >90% for key SKUs and wastage <10% through tighter planning controls- Created and maintained MIS reports and daily/weekly tracking for planning performance and exceptions (stock-out risk, overstock risk, waste)- Executed planning transactions in Magento + SCM systems with strong accuracy and process adherence. Used dashboard tools for monitoring and reporting: Metabase, Grafana, plus internal systems (Orca, Beluga)

Education

• JAGSoM - Jagdish Sheth School of Management

  Postgraduate Degree, Postgradate Diploma In Management

• Indian Institute of Technology, Madras

  B. tech and M. Tech in Infrastructure Civil Engineering, Civil Engineering

• Indian Institute of Technology, Madras

  Master's degree, Civil Engineering

  2014 — 2020