Skip to content

mandarhirphode/mandarhirphode

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

11 Commits
Β 
Β 
Β 
Β 

Repository files navigation

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

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors