Kumar Harsh Raj

Data Analyst | SQL • Power BI • Excel

Transforming raw data into actionable business intelligence. Building dashboards for customer retention, sales insights, and strategic decision-making.

6+Analytics Projects
₹1Cr+Sales Data Analyzed
15%Decision Speed Boost
53.99%Portfolio XIRR

About Me

I'm a final-year B.Sc. Chemistry & Mathematics student at the University of Delhi with a passion for data analytics. I specialize in transforming complex datasets into clear, actionable insights using SQL, Power BI, and Excel.

Through hands-on projects analyzing customer retention, sales trends, and user behavior, I've developed practical expertise in data cleaning, KPI tracking, and dashboard development. My analytical chemistry background gives me a unique edge in approaching data with scientific rigor.

Beyond technical skills, I bring proven leadership experience from managing teams, securing sponsorships, and driving measurable results in college initiatives.

Key Achievements

  • Built 6+ analytics dashboards analyzing customer retention, sales, and behavioral data
  • Doubled investment portfolio capital with 53.99% XIRR through data-driven decisions
  • Led teams to 1st place wins in strategy competitions at IIFT, KMC, NSUT, SRCC
  • Improved decision-making speed by 15% during internship at Novitech R&D
  • Secured ₹80,000+ sponsorships as Head of Sponsorship Department

Featured Projects

Zepto Analytics
Power BI

Zepto Customer Analytics

Analyzed customer behavior across cohorts to track retention, churn, and repeat purchase patterns. Identified high-value customer segments through CLV analysis and flagged churn risk groups.

SQLPower BIExcelCLV Analysis
View on GitHub →
Sales Dashboard
Power BI

Revenue & Profitability Dashboard

Interactive dashboard tracking revenue trends across multiple regions with drill-down to product-level profitability. Identified top revenue drivers and underperforming segments using KPI analysis.

ExcelPower BIPivot TablesKPI Tracking
View on GitHub →
Amazon Sales
Excel

Amazon Sales Dashboard

Interactive Excel dashboard tracking ₹1.02Cr+ in sales across 23 cities and 5 product categories. Built with pivot tables, KPI cards, and dynamic charts to convert raw data into actionable business insights.

ExcelPivot TablesData Visualization
View on GitHub →
Spotify Analytics
SQL

Spotify User Behavior Analysis

Analyzed 28K+ song streams to uncover listening patterns, peak engagement times, and top-performing artists/genres. Extracted insights via SQL and visualized user behavior trends.

SQLData AnalysisBehavioral Analytics
View on GitHub →
Growth Insights Dashboard
Lovable · React

Growth Insights Dashboard

Interactive web app built with Lovable to visualize potential customer retention metrics. Tracks growth KPIs, churn signals, and retention trends in a clean, real-time dashboard interface.

ReactCustomer RetentionKPI DashboardLovable
View Live App →
Sales Analytics Dashboard
Lovable · React

Sales Analytics Dashboard 2024

A fully interactive sales analytics web application built with Lovable. Displays 2024 sales performance, revenue trends, regional breakdowns, and product-level insights through dynamic charts and filters.

ReactSales AnalyticsData VisualizationLovable
View Live App →

Skills & Tools

Data Analysis & BI

  • Microsoft Power BI
  • Tableau
  • Business Intelligence
  • KPI Tracking & Metrics
  • Dashboard Development

Database & Querying

  • SQL (Advanced)
  • Data Extraction
  • Query Optimization
  • Data Modeling

Excel & Spreadsheets

  • Advanced Excel
  • Pivot Tables
  • VLOOKUP & Index-Match
  • Data Cleaning
  • Formula Automation

Analytics Specialties

  • Customer Analytics
  • Sales Analysis
  • Cohort Analysis
  • Churn Prediction
  • CLV Modeling

Data Visualization

  • Interactive Dashboards
  • Chart Design
  • Data Storytelling
  • Report Automation

Experience & Leadership

Data Analyst Intern
Novitech R&D Pvt Ltd
Jul 2025 – Aug 2025

Analyzed project data using SQL & Python, improving decision-making speed by 15%. Conducted market research & maintained process documentation.

Head of Content Department
BIONOMIE (College Fest)
Jan 2025 – Present

Led a 16-member team, producing engaging digital content with 30% higher online reach.

Head of Sponsorship Department
INFINITIUM
Jan 2024 – Sep 2024

Contributed to securing ₹80,000+ sponsorships for college events. Built and maintained partnerships with 10+ external sponsors.

Member, Digital & Marketing Team
BIONOMIE
May 2024 – Jan 2025

Supported digital campaigns, increasing event visibility and student participation by 20%.

NSS Volunteer
National Service Scheme
Dec 2024 – Jun 2025

Assisted in organizing 8+ community events, promoting engagement and volunteerism among 150+ people.

Get In Touch

I'm actively seeking data analyst opportunities and always open to discussing analytics projects, collaborations, or just connecting with fellow data enthusiasts.

📱

Phone

+91 8084497923
📍

Location

Pitampura, Delhi, India