Mandar Hirphode profile photo 1 on Tal

Mandar Hirphode

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

Pune Division

2+ years of work experience

Integrated Active Monitoring Pvt. Ltd. (IAM)
Jan 20251 yr 6 mosPresent

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
RajYug Solutions Ltd
Sep 20244 mosDec 2024

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.
AlmaBetter
Apr 20246 mosSep 2024

Remote

Education

Indian Institute of Technology, Guwahati

Certification, Full Stack Data Science And AI

Indian Institute of Technology, Guwahati

D. Y. Patil College of Engineering & Technology, KASABA BAWADA (DYPCET)

Bachelor of Technology - BTech, Mechanical Engineering

D. Y. Patil College of Engineering & Technology, KASABA BAWADA (DYPCET)

20203 yrs2023

Join Mandar and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

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)