Skip to content
View mandarhirphode's full-sized avatar

Block or report mandarhirphode

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
mandarhirphode/README.md

Typing SVG


👨‍💻 About Me

I'm a Data Analyst passionate about transforming raw data into actionable business insights.

Currently working at Integrated Active Monitoring Pvt. Ltd., where I design scalable BI solutions, automate enterprise reporting workflows, and build Machine Learning models for Industrial IoT and Energy Analytics.

Highlights

  • 📊 Built 25+ Production Dashboards
  • 👥 Supporting 500+ Enterprise Users
  • ⚡ Automated 5–7 Daily MIS Reports
  • 🔍 Reduced Data Errors from 8% → <1%
  • 🤖 ML Models with 85–93% Prediction Accuracy
  • ⚙️ Reduced Reporting Time from 2 Days → Same Day
  • 💡 Delivered 10–12% Energy Savings
  • 🏆 Employee of the Month

🛠 Tech Stack

📊 Business Intelligence


🗄 Databases


🐍 Programming


☁️ Data Engineering


🤖 Generative AI


🚀 Featured Projects

Project Description Tech
IPMVP Energy Forecasting System ML-based Energy Forecasting Platform with 85–93% Prediction Accuracy Python • PostgreSQL • InfluxDB • Scikit-learn
🤖 GenAI LinkedIn Post Generator RAG application using LangChain + Llama3 + ChromaDB Python • LangChain • Streamlit
📊 BMS Reporting Automation Platform Automated Enterprise Reporting using Python & n8n Python • REST API • PostgreSQL • n8n
💹 Financial MIS Dashboard Suite Interactive Business Dashboards for Financial KPIs Power BI • Excel • DAX

💼 Professional Experience

🏢 Integrated Active Monitoring Pvt. Ltd.

Data Analyst

Jan 2025 – Present

✔ Built 25+ Production Dashboards

✔ Automated 5–7 Enterprise Reports

✔ Reduced Data Errors from 8% → <1%

✔ ML Models with 85–93% Accuracy

✔ Supported 500+ Enterprise Users

✔ Optimized SQL Queries

✔ Built Reusable ETL Pipelines


💼 Arthalay Financial Services

MIS Executive

Jun 2024 – Dec 2024

✔ Power BI Dashboards

✔ Excel Automation

✔ Reduced Manual Reporting by 40%

✔ Automated MIS Workflows

✔ Improved Data Accuracy by 30%


🏆 Certifications

  • 🎓 IIT Guwahati – Full Stack Data Science & AI
  • Microsoft PL-300 (In Progress)
  • Microsoft DP-900 (In Progress)
  • Snowflake – DataCamp
  • Accenture Data Analytics Job Simulation

📫 Connect With Me


Pinned Loading

  1. Amazon_Sales_Analysis_Dashboard Amazon_Sales_Analysis_Dashboard Public

  2. HR_Data_Analytics_Project HR_Data_Analytics_Project Public

    HR Data Analytics Project

  3. Car_Price_Prediction Car_Price_Prediction Public

  4. Customer_Sales_Analysis Customer_Sales_Analysis Public

    In this project data analysis and visualisation done with Python, SQL, Power BI.

  5. Movie_Recommender_System Movie_Recommender_System Public

    Jupyter Notebook

  6. Netflix_TV_Shows_Clustring Netflix_TV_Shows_Clustring Public

    Jupyter Notebook