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

πŸ‘‹ Hi, I'm Mandar Hirphode

πŸš€ Aspiring Data Scientist with a passion for uncovering insights, solving problems, and driving data-driven decision-making. Currently pursuing an Advanced Certification in Full Stack Data Science from IIT Guwahati in collaboration with AlmaBetter, I bring a strong foundation in data analysis, machine learning, and visualization tools.


🌟 About Me

I am a motivated professional with expertise in Python, SQL, Power BI, and Tableau. My focus is on leveraging data to create impactful business solutions. I have hands-on experience working on projects in supply chain optimization, sales forecasting, and app analytics. My goal is to build intelligent solutions that empower organizations to achieve their objectives.


πŸ”§ Skills

Programming & Tools

  • Programming Languages: Python, SQL, R
  • Visualization: Power BI, Tableau, Excel
  • Databases: MySQL, PostgreSQL, MongoDB

Data Science & Machine Learning

  • Supervised & Unsupervised Learning (Regression, Clustering, Decision Trees, Neural Networks)
  • Time Series Analysis & Forecasting (ARIMA, LSTM)
  • Statistical Modeling & Data Manipulation (Pandas, NumPy, Scikit-learn, statsmodels)
  • Model Deployment & Feature Engineering

Soft Skills

  • Problem-Solving
  • Collaboration & Teamwork
  • Communication & Data Storytelling

🧠 Projects

1. Amazon Sales Analysis

  • Objective: Analyzed over 10,000 rows of Amazon sales data to identify trends and drive strategic decision-making.
  • Highlights:
    • Improved sales by 15% through insights from interactive Power BI dashboards.
    • Enhanced reporting efficiency by 30% using dynamic KPI cards and filters.

2. Play Store Analysis

  • Objective: Analyzed app engagement and user feedback to improve app design and positioning.
  • Highlights:
    • Boosted user engagement by 20% through feature recommendations.
    • Enhanced app ratings by 15% with actionable insights derived from exploratory data analysis.

3. Flipkart Product Case Study

  • Objective: Designed and optimized a scalable database schema for a platform with 2 million monthly active users.
  • Highlights:
    • Reduced database query times by 20% with efficient SQL schema design.
    • Won a top-5 position in a data design competition.

4. Supply Chain Data Analysis (Professional Internship)

  • Objective: Optimized inventory levels and reduced costs for a leading organization.
  • Highlights:
    • Achieved a 15% cost reduction by creating real-time dashboards using Power BI and Tableau.
    • Delivered actionable insights for cross-functional decision-making.

πŸŽ“ Education

  • Advanced Certification in Full Stack Data Science & AI

    • IIT Guwahati in collaboration with AlmaBetter (Dec 2023 - Oct 2024)
  • Bachelor of Technology

    • D.Y. Patil College of Engineering and Technology, Kolhapur (June 2020 - July 2023)

πŸ“œ Certifications

  • Data Analysis and Visualization – Accenture (Forage)
  • Google Analytics – Google

🌟 Contact Me


✨ Let’s Connect!

I’m always excited to collaborate on projects or discuss ideas in data science, analytics, and beyond. Feel free to reach out to me!


Pinned Loading

  1. Amazon_Sales_Analysis_Dashboard Amazon_Sales_Analysis_Dashboard Public

  2. Excel_Dashboarding Excel_Dashboarding Public

  3. HR_Data_Analytics_Project HR_Data_Analytics_Project Public

    HR Data Analytics Project

  4. IPL_2008_2019_Data_Analysis IPL_2008_2019_Data_Analysis Public

    Jupyter Notebook

  5. Hill_Vally_Prediction Hill_Vally_Prediction Public

    Jupyter Notebook