Skip to content
Available for opportunities

Kavya Raval

Data Analyst

I turn raw data into structured, decision-ready insight — SQL, dashboards, and analysis that ship real outcomes.

SQL·Python·Excel·Tableau
View ProjectsView ResumeContact ↓
01/About

An analytical builder, not just a dashboard-maker.

Product- and data-minded builder who turns structured analysis (SQL, Power BI, RICE/MoSCoW) into shipped outcomes — from diagnosing a product trust deficit using 100+ user reviews to leading delivery of a full-stack platform now running 65+ concurrent projects. Comfortable working across the full loop: research, data, prioritization, and execution.

I'm a B.Tech Electronics & Telecommunication Engineering student at MPSTME, NMIMS University, working at the intersection of data analysis and product thinking — pulling signal out of messy datasets, prioritizing what matters, and shipping the fix.

Focus
Data & Product Analytics
Degree
B.Tech, Electronics & Telecommunication Engineering
Institution
MPSTME, NMIMS University
Class of
2027
Core tools
SQL · Python · Power BI · Tableau
02/Experience

Relevant experience

Project Management Intern

Galaxy Home Automation LLP · 20-person team

May 2026 – Jul 2026

  • Analyzed cross-team workflows and stakeholder feedback to scope a platform now running 65+ concurrent projects, cutting manual task-tracking time by 30%
  • Built real-time KPI dashboards and automated reporting workflows, replacing scattered updates with a single source of truth and cutting reporting delays by 45%
  • Identified a manual bottleneck in the quotation process, then redesigned the workflow with the AI team — cutting turnaround from 4–5 hrs to 1–2 hrs

65+

concurrent projects

30%

less manual tracking time

45%

fewer reporting delays

4–5h → 1–2h

quotation turnaround

03/Skills

What I work with

Grouped the way I actually use them — for analysis, for shipping, and for working across a team.

01 / Product & Data Analytics

  • SQL01
  • Power BI02
  • Tableau03
  • Python (Pandas, NumPy)04
  • DAX05
  • A/B Testing06
  • RICE / MoSCoW Prioritization07
  • Exploratory Data Analysis08

02 / Cross-Functional & Process

  • Requirements Gathering01
  • Stakeholder Management02
  • Agile / Scrum03
  • Product Roadmaps04

03 / Tools

  • Excel (Advanced)01
  • Git / GitHub02
  • Jira03
  • Notion04
  • REST APIs05
04/Projects

Data investigations

Each project starts as a question, not a chart. The dashboard is what's left after the analysis.

01
Product Case Study

CRED Engagement & Trust

Question
Why does CRED's gamified reward mechanic underperform on trust with users?
Data
100+ user reviews across App Store, Trustpilot, and product teardowns
Tools
Qualitative codingRICE scoringA/B test design
Analysis
Diagnosed a trust deficit in the gamified reward mechanic, then RICE-scored three candidate fixes to force-rank them by impact vs. effort.

Insight

Top fix scored 144 vs. 77 and 15 for the alternatives — proposed validating it with an A/B test on a 10–15% holdout.

02
BI Dashboard

Olist E-Commerce Sales Dashboard

Question
How is revenue distributed across a 9-table e-commerce dataset, and where should the business look first?
Data
99K+ orders, 96K+ customers across a 9-table relational model
Tools
Power BISQLDAX
Analysis
Modeled the 9-table schema and built DAX measures to surface revenue, order, and customer trends in an interactive BI dashboard.

Insight

Tracked $16M+ in revenue across the full order history.

03
Risk Analysis

Credit Card Loan Portfolio — Risk Analysis

Question
What actually drives default in a large consumer credit portfolio?
Data
150K loans, $1.98B portfolio
Tools
SQLExcel risk scorecard
Analysis
Built a SQL + Excel scorecard segmenting the portfolio by risk factors to isolate the strongest predictor of default.

Insight

Credit utilization was the top default driver (32.5% vs. 6.0%) — proposed underwriting changes projected to cut portfolio losses by ~$60M.

04
Full-Stack · Project Lead

Project Management System — Galaxy Home Automation CRM

Question
Can one platform replace scattered spreadsheets and manual reporting across 65+ live projects?
Data
Live operational data across concurrent client projects, quotations, and KPIs
Tools
React / Next.jsPython / FlaskPostgreSQL / SupabaseVercel
Analysis
Designed and built a full-stack CRM centralizing project tracking, a quotation builder, real-time KPI dashboards, and automated notifications.

Insight

Now running 65+ concurrent projects in production.

05
Applied ML · Project Lead

AI Equity Trader

Question
Can short-term trading opportunities be identified systematically from market data rather than discretion?
Data
Live and historical market data via market-data APIs
Tools
PythonMarket-data APIsGit / GitHub
Analysis
Owned system architecture, trading logic, and data analysis through iterative development, favoring repeated small trades over a single long-term thesis.

Insight

Currently in Phase 5/6 of iterative development.

05/Certifications & Education

Credentials

Degree
B.Tech, Electronics & Telecommunication Engineering
Institution
MPSTME, NMIMS University
Period
2023 – 2027
GPA
3.1 / 4.0

Certifications

  • IBM AI Product ManagementIBM·In Progress
  • SQL (Intermediate)HackerRank·Jul 2026
  • SQL (Basic)HackerRank·Jul 2026
  • GenAI Powered Data AnalyticsTata (Forage)·Apr 2026
  • Product Management BasicsSimpliLearn SkillUp·Jul 2026
  • Scrum Fundamentals Certified (SFC)SCRUMstudy·Mar 2026
  • Project Manager Job SimulationSiemens (Forage)·Jan 2026

Leadership & Achievements

  • Sub-Head, R&D — TechSafar 2026 — State-Level R&D Techfest, IEEE NMIMS MPSTME Student Branch · Certificate of Appreciation from the Dean
  • Organising Committee Member — Taqneeq 18.0 — Tech Fest, NMIMS MPSTME · Coordinated a 4-day, multi-team fest
  • Advisory Member — Team DARVIN, MPSTME · Supported the team representing NMIMS University at the Intelligent Ground Vehicle Competition (IGVC) 2026, Oakland University, USA
  • Selected among the Top Teams for Stage 2 of Tata Technologies InnoVent-27, out of 7,000+ project submissions from 20,000+ students across 500+ colleges
  • Won 1st place at NMIMS Indore's inter-campus tech fest, representing the Mumbai campus
  • Secured 2nd place in the AI Whisperer competition at NMIMS Indore's tech fest
  • Smart India Hackathon (SIH) 2024 — Participant, Government of India
  • Scored 91.64 percentile nationally in ISWDP Level 1 — Samsung Semiconductor x IISc x Synopsys

06 / Resume

The full picture, in one document.

This site is the walkthrough. The resume is the record.

View ResumeDownload

07 / Contact

Let's work with data.

Open to Data Analyst and Product Analytics roles. The fastest way to reach me is email — I usually reply within a day.

Emailkavyaraval543@gmail.comLinkedInkavya-raval1306GitHubkavyaraval543-gif