KD

Karan Dere

Data Analyst & Business Intelligence Specialist

Pune, Maharashtra, India

@karan_dere

0 followers

Electronics & Telecommunication Engineering at SPPU · Graduating 2026

About

Data Analyst with hands-on experience in Python, SQL, Excel, Power BI, data cleaning, exploratory data analysis, and data visualization. Has worked on customer purchasing behavior, HR analytics, and automated data preprocessing workflows to turn complex datasets into actionable business insights.

Experience

  • AI/ML Intern
    Mass IT Solutions
    Jan 2025 – Feb 2025

    Developed Python-based data cleaning and preprocessing pipelines using Pandas to prepare structured datasets for analytical modeling. Performed Exploratory Data Analysis (EDA) and created visual data reports using Matplotlib to highlight dataset distributions. Collaborated on data preparation workflows to ensure clean inputs for predictive analytics and downstream reporting.

Education

  • B.E. in Electronics & Telecommunication Engineering
    SKNCOE, Pune
    Electronics and Telecommunication Engineering (ETE) · 2022 – 2026

Skills

Tools / apps / platforms

<3 months <3 months Just getting started - under three months. This is also what shows when a level has not been set.
Git MySQL GitHub VS Code Microsoft Excel Jupyter Notebook Microsoft Power BI

Projects

  • Employee Data Analysis
    Python, Pandas, Matplotlib, NumPy

    Cleaned and structured raw workforce datasets using Pandas and NumPy to resolve missing values and anomalies. Conducted exploratory statistical analysis to evaluate employee attributes and organizational distribution patterns. Constructed visualization charts with Matplotlib to present analytical insights clearly to non-technical stakeholders.

  • HR Analytics Dashboard
    Power BI, Excel, KPI Modeling, Data Visualization

    Designed an interactive Power BI attrition dashboard tracking 1,470 employee records and 237 attrition events. Established core executive KPIs including a 16.12% attrition rate, 8.57 years average experience, and 32.77 years average age. Segmented attrition patterns across organizational demographics and roles to inform workforce retention strategies.

  • E-Commerce Customer Purchase Analysis
    Python, Pandas, SQL, Data Cleaning, EDA

    Analyzed retail transaction datasets to identify key drivers behind revenue, purchasing trends, and product performance. Performed automated data cleaning and revenue calculations in Pandas utilizing transaction quantities and unit pricing. Executed exploratory data analysis (EDA) and generated data visualizations to communicate strategic business insights.

Explore the Broxer community

Online · instant AI help
Broxer