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 supported. This note will be visible to only 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

Data Analytics GIF

  • 🏢 Data Analyst at Integrated Active Monitoring, Pune
  • 📊 Building Power BI dashboards, Python-SQL pipelines & Grafana monitoring for 5+ enterprise clients
  • 🎓 IIT Guwahati certified in Full Stack Data Science & AI
  • ⚡ Specialised in Energy Analytics & Time-Series Forecasting
  • 🏆 Employee of the Month — Integrated Active Monitoring
  • 🤖 Skilled in Machine Learning — Regression, Clustering, Classification
  • 🔍 Open to Data Analyst · BI Analyst · Power BI Developer roles
  • 📍 Pune, India


🛠️ Tech Stack

📊 BI & Visualisation

🗄️ Databases & SQL

🐍 Programming & ML

☁️ Cloud & Data Engineering

🔧 Tools


🚀 Featured Projects

# Project Description Tools
📊 Amazon Sales Analysis Dashboard Interactive Power BI dashboard on 10,000+ rows. 30% faster reporting with dynamic KPI cards Power BI DAX Excel
👥 HR Data Analytics Project HR attrition analysis, department KPIs and workforce insights dashboard Python Power BI SQL
🎬 Movie Recommender System Content-based recommender using TF-IDF & cosine similarity. 85% accuracy Python Scikit-learn NLP
🏎️ Car Price Prediction ML regression model to predict used car prices based on features Python Scikit-learn Regression
📺 Netflix Shows Clustering Unsupervised clustering of Netflix titles for content segmentation Python K-Means NLP
🛒 Customer Sales Analysis End-to-end sales analysis with customer segmentation and KPI reporting Python SQL Power BI
🌍 Global Terrorism EDA Exploratory data analysis on global terrorism dataset with visual insights Python Pandas Matplotlib
📱 Play Store EDA App engagement and user feedback analysis to improve app positioning Python Pandas EDA

📊 GitHub Stats

  

💼 Experience Timeline

🏢  Data Analyst          │  Integrated Active Monitoring, Pune  │  Jan 2025 – Present
    ├─ Power BI forecasting dashboards for energy consumption & peak demand
    ├─ Python-SQL pipelines saving 10+ hrs/week manual effort
    └─ Grafana + Looker Studio real-time KPI monitoring — 5+ enterprise clients

🔬  Data Science Intern   │  RajYug IT Solutions                 │  Sep 2024 – Dec 2024
    ├─ Power BI dashboards — Travel, Oil & Gas, Real Estate sectors
    ├─ ETL pipelines via Microsoft Fabric & SSIS
    └─ ML models for demand forecasting (+12% forecast reliability)

📊  Data Analyst Intern   │  YBI Foundation                      │  May 2024 – Jul 2024
    ├─ Data cleaning & transformation with Python (Pandas, NumPy)
    └─ Churn analysis & segmentation dashboards in Power BI

🎓 Education & Certifications

🏛️  Full Stack Data Science & AI  │  IIT Guwahati            │  2023 – 2024
🎓  B.Tech                        │  Shivaji University       │  2020 – 2023
🏆  Employee of the Month         │  Integrated Active Monitoring

🐍 Contribution Snake

Snake animation

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