Hi, I'm Mandar Hirphode

I bring 1+ years of professional experience across Data Analysis and Data Science. I build reliable ETL/data models and dashboards to inform decisions, and create practical ML prototypes (regression / forecasting) that improve operations. Tech: Python, SQL, Power BI, InfluxDB, SSIS basics, Flask/Streamlit.

Let's Connect View Resume
Mandar Hirphode

Selected outcomes

  • 12% cost reduction — regression-based recommendations for load scheduling (analyst + model prototyping).
  • 15% penalty cut — short-term peak demand forecasting + operational suggestions.
  • Real-time dashboards — ETL → InfluxDB → Grafana for live KPIs & alerts.
  • Top 5 – AlmaBetter — SQL schema & performance tuning (reporting focus).
  • Power BI reporting — stakeholder dashboards & scheduled insights.

Skills

SQL & Data Modeling

ETL, schema design, query tuning

Python

Pandas, NumPy, scripting for ETL & modeling

Machine Learning

Regression, forecasting, evaluation, prototypes

Power BI & Dashboards

Reports, storytelling, scheduled refresh

Real-time Monitoring

InfluxDB, Grafana, streaming KPIs

APIs & Deployment

Flask/Streamlit, simple serving

SSIS & MS Fabric

Basic pipelines & Fabric concepts

Collaboration

Git, documentation, stakeholder comms

Work Experience

Data Analyst (primary) & ML Prototypes – Integrated Active Monitoring

Pune · Jan 2024 – Present

  • Mainly worked as a Data Analyst: ETL flows, SQL data models and scheduled reports to support operations.
  • Built Power BI / Looker Studio dashboards used daily by ops and management.
  • Implemented telemetry pipelines and live dashboards (InfluxDB + Grafana) with alerting.
  • Created small ML demos (regression, short-term forecasting) to validate automations — prototypes handed to engineers for productionization.
  • Delivered data-backed recommendations that reduced costs and improved scheduling decisions.

Data Science Intern – RajYug IT Solutions Pvt. Ltd.

Pune · Sept 2024 – Dec 2024

  • Primarily focused on Power BI reporting and dashboarding for product teams.
  • Built scheduled ETL using SSIS and simple data pipelines to feed reports.
  • Developed and evaluated basic ML models (classification/regression) as prototypes to support product features.
  • Familiarity with Microsoft Fabric concepts and how Fabric integrates ETL, storage and BI workflows.

Data Analyst Intern – Ybi Foundation

Remote · May 2024 – July 2024

  • Data cleaning and preparation for program datasets using Pandas & SQL.
  • Built basic ML models (linear regression, clustering) for churn and segmentation projects.
  • Packaged results into dashboards and concise reports for program managers.

Projects

EDA

Global Terrorism DB — EDA & Reporting

EDA, dashboards and derived metrics for trend analysis.

View Project
Recommender

Movie Recommender — Prototype & Dashboard

Streamlit prototype + A/B logging + dashboard to measure performance.

View Project
Amazon Sales

Amazon Sales — Dashboards & Forecasts

Power BI dashboards + short-term forecasting for planning.

View Project

Get in touch

If you need clean analytics or practical ML prototypes — reach out.

Email LinkedIn GitHub
+91 9420662327 · Pune, Maharashtra, India