Skip to content
View Kapilmali07's full-sized avatar
1 follower · 2 following

Block or report Kapilmali07

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
Kapilmali07/README.md

Hi, I'm Kapil Mali! 👋

🎯 Senior Data Analyst | · Python · SQL · Power BI · Advanced Excel · Machine Learning | 4.5 Years @ Kantar, Pune

🚀 About Me

I'm a senior data analyst with 4.5+ years of experience at Kantar, specializing in analytics automation, large-scale survey data processing, and business intelligence. I delivered a 66% reduction in processing time through Python automation and managed 1M+ annual records for global consumer insight projects.

Currently building end-to-end analytics portfolio projects in Python, MySQL, Power BI and Machine learning, targeting a transition into a full-stack Data Analyst/ Senior DA/ Business analyst/ Consultant roles.

🛠 Skills

  • Languages & Analysis: Python (Pandas, NumPy, Matplotlib, Seaborn), SQL, MySQL
  • BI & Visualization: Power BI (DAX, KPI Dashboards, Slicers), Advanced Excel
  • Methods: EDA, Feature Engineering, Customer Segmentation, Statistical Analysis
  • Tools: GitHub, Jupyter Notebook, Google Colab, VS Code, IBM SPSS Dimensions

📂 Featured Projects

Project Tools Highlights
UPI_FRAUD_RISK_ANALYZER Python · MySQL · Power BI 50,000 records · 4 SQL queries · Interactive dashboard
Customer Shopping Behavior Analysis Python · MySQL · Power BI 3,900 records · 10 SQL queries · Interactive dashboard

📫 Connect With Me

LinkedIn GitHub

Pinned Loading

  1. upi-fraud-risk-analyzer upi-fraud-risk-analyzer Public

    Behavioral fraud detection system for UPI transactions using Python, MySQL, and Power BI with custom Fraud Velocity Index (FVI) risk scoring.

    Jupyter Notebook 2

  2. Customer-Shopping-Behavior-Analysis Customer-Shopping-Behavior-Analysis Public

    End-to-end retail customer behavior analysis using Python, MySQL, and Power BI — EDA, SQL queries, interactive dashboard

    Jupyter Notebook 2

  3. Customer-Churn-Analysis Customer-Churn-Analysis Public

    Telecom customer churn EDA on 7,043 records using Python, Pandas, Matplotlib, and Seaborn

    Jupyter Notebook 2

  4. sql-case-study sql-case-study Public

    SQL Case Study — Relational DB Design & Business Query Solving

    2

  5. automotive-sales-dashboard automotive-sales-dashboard Public

    2