Create your free profile

About

B. Com (Hons) graduate (2024) bringing a business-analytics background, with a Data Analytics certification from Intellipaat, in association with IIT Roorkee, backed by 18+ self-driven analytics projects spanning retail, SaaS, marketing, HR, manufacturing, supply chain, and finance domains.

Experience1

  1. Finance & Marketing Analytics Intern

    May 2023 — Jul 2023

    Ads Klick Media

    Collaborated with cross-functional finance and marketing stakeholders to surface channel-level performance insights via Google Analytics and Excel, driving +20% reach and +25% engagement. Created automated pivot-table KPI dashboards and reusable templates, eliminating repetitive manual reporting.

Projects11

  • Superstore Sales Performance Dashboard

    Built a Power BI dashboard with $2.3M in sales, 12.48% profit margin, and 5,000+ orders across 793 customers, flagging Technology and West as top growth levers.

    • Power BI
    • DAX
    • Excel

  • Marketing Funnel & Campaign ROI Analysis

    Analyzed a multi-channel marketing funnel across 30 campaigns, achieving 3.20x ROAS and 220.4% ROI, and modeled a budget-reallocation scenario projecting a 4.00x ROAS uplift.

    • SQL
    • Power BI
    • Excel

  • Customer Cohort & Retention Analysis

    Built cohort retention curves for SaaS subscribers, measuring 60% six-month retention and identifying Partner as the top acquisition channel to guide onboarding and acquisition strategy.

    • SQL
    • Power BI

  • SaaS Customer Churn Analytics Platform

    Predicted churn across 2,500+ records at 94.2% AUC-ROC and 90.8% F1-Score using Gradient Boosting, with a Chart.js risk dashboard.

    • Python
    • SQL

  • Chinook Revenue Intelligence & Data Engineering

    Surfaced top-value customers and made invoice ingestion failure-safe across 11 relational tables using DENSE_RANK()/PERCENT_RANK() CLV queries.

    • SQL

  • Retail Monthly Sales Forecasting Engine

    Achieved 4.28% MAPE on monthly demand forecasts by benchmarking SARIMAX against Facebook Prophet to support inventory planning.

    • Python
    • SARIMAX

  • Retail RFM Customer Segmentation App

    Deployed a production Streamlit app auto-segmenting customers into tiers from live CSV uploads.

    • Python
    • Streamlit

  • A/B Testing Website Conversion Framework

    Validated a Design B rollout using a dual-metric test with KDE diagnostics.

    • Python
    • SciPy

  • Manufacturing Downtime Intelligence Dashboard

    Built a Tableau dashboard tracking downtime incidents, achieving a 91.4% asset reliability score and identifying root-cause failures.

    • Tableau

  • Budget vs Actual Financial Planning Model

    Built an Excel FP&A model with dynamic formulas for monthly and YTD variance analysis across financial scenarios.

    • Excel

  • Operations & Supply Chain Performance Analytics

    Analyzed 4,000 orders end-to-end to flag supplier bottlenecks and regional delivery risk for management review.

    • SQL
    • Power BI
    • Excel

Education3

  • Bachelor of Commerce (Honours)

    2021 — 2024

    Amity University, Noida

  • Google Data Analytics Professional Certificate

    2024 — 2025

    Coursera

  • Data Analytics Certification Program

    2025 — 2026

    Intellipaat, in association with IIT Roorkee