---
title: "Mandar Hirphode - Data Analyst in Pune Division | Tal"
description: "Meet Mandar Hirphode, Turning Data into Cost Savings ⚡ | Data Analyst → Data Science | ML • Power BI • SQL • Python • Grafana | Energy Analytics | IIT Guwahati Alum based in Pune Division."
image: "https://tal.club/meet/mandar-6/share-image"
---

# Mandar Hirphode on Tal

## Headline

Turning Data into Cost Savings ⚡ \| Data Analyst → Data Science \| ML • Power BI • SQL • Python • Grafana \| Energy Analytics \| IIT Guwahati Alum

## About

Data Analyst with hands\-on experience in solving real\-world business problems using data, with a strong focus on energy analytics, time\-series data, and machine learning\. Currently working across multiple projects and organizations, I analyze large\-scale operational and energy datasets to drive cost optimization, improve system performance, and support data\-driven decision\-making\. My work goes beyond traditional reporting—I build end\-to\-end data solutions: • Designing dashboards \(Power BI, Grafana\) for real\-time monitoring and insights • Developing automated data pipelines using Python and SQL • Working with time\-series databases \(InfluxDB, InfluxQL, Flux\) • Applying machine learning models for forecasting, baseline modeling, and anomaly detection I have implemented ML techniques such as regression, clustering, and SVM for: • Energy consumption forecasting using occupancy & cooling degree days • Baseline modeling for ESG and compliance \(IGBC, ASHRAE standards\) • Detecting anomalies in operational data Alongside technical work, I collaborate with cross\-functional teams, perform root cause analysis, and work directly with clients—presenting dashboards, explaining insights, and enabling better business decisions\. I also actively explore modern AI and automation tools \(like generative AI, workflow automation, and coding assistants\) to improve productivity and streamline data workflows\. Currently focused on strengthening my capabilities in Deep Learning, MLOps, and cloud technologies to transition into a full\-scale Data Science role\.

## Location

Pune Division

## Work experience

Data Analyst at Integrated Active Monitoring Pvt\. Ltd\. \(IAM\), Jan 2025 \- Present · 1 yr 6 mos, Pune City, Maharashtra, India, • Analyzed large\-scale energy and operational data using SQL, Python, and Excel to identify optimization opportunities and improve system efficiency • Built interactive dashboards using Power BI and Grafana to monitor KPIs, energy trends, and real\-time performance metrics • Developed automated data pipelines using Python and PostgreSQL, reducing manual reporting effort and improving data reliability • Worked extensively with time\-series databases \(InfluxDB, InfluxQL, Flux\) to process high\-frequency data for continuous monitoring systems • Applied machine learning models \(regression, clustering, SVM\) for energy forecasting, baseline modeling, and anomaly detection • Designed energy consumption forecasting models using occupancy patterns and Cooling Degree Days \(CDD\) to improve load planning and reduce penalties • Conducted ESG and compliance\-related analysis \(IGBC, ASHRAE standards\) to evaluate building performance and sustainability metrics • Performed root cause analysis on system inefficiencies using data insights and collaborated with cross\-functional teams to resolve issues • Led client\-facing interactions including dashboard walkthroughs, insight presentations, and requirement gathering • Delivered reporting and analytics solutions across multiple domains including BMS monitoring, attendance systems, and operational analytics

Data Science Intern at RajYug Solutions Ltd, Sep 2024 \- Dec 2024 · 4 mos, Pune, Maharashtra, India, • Processed and analyzed 500,000\+ records using Python and SQL to identify travel behavior trends, improving user engagement by 20%\. • Developed Power BI and Tableau dashboards for supply chain optimization, reducing operational costs by 15%\. • Implemented ETL workflows using SSIS and Microsoft Fabric to integrate and transform large datasets for analytics\.

Student Instructor & Project Consultant at AlmaBetter, Apr 2024 \- Sep 2024 · 6 mos, Remote

## Education

Certification, Full Stack Data Science And AI, Indian Institute of Technology, Guwahati

Bachelor of Technology \- BTech, Mechanical Engineering, D\. Y\. Patil College of Engineering & Technology, KASABA BAWADA \(DYPCET\)

[View the original profile](https://tal.club/meet/mandar-6)

```json
{
  "@context": "https://schema.org",
  "@graph": [
    {
      "@type": "Person",
      "@id": "https://tal.club/meet/mandar-6#person",
      "name": "Mandar Hirphode",
      "url": "https://tal.club/meet/mandar-6",
      "image": "https://tal.club/meet/mandar-6/profile-photo.jpg",
      "description": "Meet Mandar Hirphode, Turning Data into Cost Savings ⚡ | Data Analyst → Data Science | ML • Power BI • SQL • Python • Grafana | Energy Analytics | IIT Guwahati Alum based in Pune Division.",
      "jobTitle": "Data Analyst",
      "worksFor": {
        "@type": "Organization",
        "name": "Integrated Active Monitoring Pvt. Ltd. (IAM)"
      },
      "hasOccupation": {
        "@type": "Occupation",
        "name": "Data Analyst"
      },
      "homeLocation": {
        "@type": "Place",
        "name": "Pune Division"
      },
      "alumniOf": [
        {
          "@type": "EducationalOrganization",
          "name": "Indian Institute of Technology, Guwahati"
        },
        {
          "@type": "EducationalOrganization",
          "name": "D. Y. Patil College of Engineering & Technology, KASABA BAWADA (DYPCET)"
        }
      ],
      "mainEntityOfPage": {
        "@id": "https://tal.club/meet/mandar-6#webpage"
      }
    },
    {
      "@type": "ProfilePage",
      "@id": "https://tal.club/meet/mandar-6#webpage",
      "url": "https://tal.club/meet/mandar-6",
      "name": "Mandar Hirphode on Tal",
      "description": "Meet Mandar Hirphode, Turning Data into Cost Savings ⚡ | Data Analyst → Data Science | ML • Power BI • SQL • Python • Grafana | Energy Analytics | IIT Guwahati Alum based in Pune Division.",
      "dateModified": "2026-07-18T19:22:30.183Z",
      "isPartOf": {
        "@id": "https://tal.club/#website"
      },
      "mainEntity": {
        "@id": "https://tal.club/meet/mandar-6#person"
      },
      "primaryImageOfPage": {
        "@type": "ImageObject",
        "url": "https://tal.club/meet/mandar-6/profile-photo.jpg",
        "contentUrl": "https://tal.club/meet/mandar-6/profile-photo.jpg",
        "caption": "Mandar Hirphode profile photo on Tal"
      },
      "inLanguage": "en-IN"
    }
  ]
}
```