Khushi Kharvar | Aspiring Data Analyst Portfolio

About Me

Know Me Better

I'm Khushi Kharvar, a PGDM student specializing in Data Science and Analytics at Narayana Business School, with an undergraduate background in BBA from Veer Narmad South Gujarat University.

Practical experience as a Data Analyst Intern at ES Healthcare Centre involved competitor pricing analysis, healthcare data, and patient journey processes. This experience helped develop an understanding of how data can uncover operational insights, identify gaps, and support better business decisions.

Interests lie in Data Analytics, Business Intelligence, and Data Visualization. Working with data, identifying meaningful patterns, and transforming complex information into clear, actionable insights helps businesses make informed decisions.

Profile snapshot

NameKhushi J. Kharvar

LocationSurat / Ahmedabad

Emailk.kharvar513@gmail.com

Availability Open to Work

More About Me

Skills

Tools & Technologies

Core Skills

Time ManagementTeamwork & CollaborationAttention to Detail

Technical Skills

PythonSQLMySQLMongoDBPandasNumPyEDAStatistical AnalysisPower BITableauExcelExcel Data VisualizationAdvanced ExcelPivot TablesMatplotlibSeabornDAXGitJupyterRapidMiner

Projects

Selected Work

View All On GitHub

Healthcare

PROJECT 01 / 05 Tableau • SQL

Healthcare Operations & Patient Management

Built interactive Tableau dashboards integrating Patients, Appointments, Doctors, and Billing. Identified $18.5k in billing leakage, reduced physician idle time by 22%, and designed dynamic parameter switches for treatment profit vs. capacity optimization.

Tableau Desktop SQL Joins & Aggregations Data Modeling Heatmaps Calculated Fields

Live Dashboard GitHub Repo

Automobile Sales & Market Performance Dashboard

Automotive

PROJECT 02 / 05 Power BI • DAX

Automobile Sales & Market Performance Intelligence

Engineered an executive Power BI dashboard analyzing vehicle revenue trends, brand market share, and buyer demographics across regions. Uncovered a 14% inventory turnover gain and identified $82k in untapped regional SUV demand using advanced DAX modeling.

Power BI DAX Measures Market Share Treemaps Regional Geo Maps SQL Server

Live Dashboard GitHub Repo

FinTech

PROJECT 03 / 05 Python • Excel

FinTech Customer Analytics & Risk Scoring

Conducted exploratory data analysis across 50,000 customer records and 33 variables. Evaluated credit scores, fraud indicators, and loan default probabilities, safeguarding ~$45k in quarterly risk while detecting high-LTV customer retention segments.

Python (Pandas / NumPy) Advanced Excel Credit Risk Scoring Cohort Analysis Fraud Detection

GitHub Repo

Public Policy

PROJECT 04 / 05 Python • EDA

Crime Data Analysis of India (2018 – 2023)

Analyzed longitudinal crime data spanning multiple Indian states, cities, and categories. Performed automated data cleaning and statistical EDA with Python and Matplotlib, mapping regional crime density, year-over-year trends, and demographic patterns.

Python Pandas • NumPy Matplotlib • EDA Geospatial Trends Exploratory Data Analysis

View Jupyter Notebook GitHub Repo

ESHS Healthcare Operational Excellence System

Healthcare Operations

PROJECT 05 / 05 Operations • Analytics

ESHS Healthcare Operational Excellence System

Developed an integrated healthcare operations system covering the patient lifecycle, medical records, billing, feedback, and quality management. Designed centralized workflows and role-based dashboards to monitor patient activity, revenue, feedback, compliance, documentation, and operational KPIs.

Centralized Workflows Role-Based Dashboards Patient Lifecycle Billing & Feedback QA & NC/CAPA

Education & Experience

Education

2025 - Present

PGDM in Data Science and AnalyticsNarayana Business School • AICTE • 79.20%

2022 - 2025

BBAAgarwal Vidhya Vihar English Medium College • Veer Narmad South Gujarat University • 75.30%

2020 - 2022

12th CommerceSir V.D.T. Girls' High School • Gujarat • 78.53%

2018 - 2020

10th GeneralSir V.D.T. Girls' High School • Gujarat • 77.50%

Experience

Data Analyst Intern — ES Healthcare CentreMay 2026 - July 2026 • Data Analytics Department

Conducted primary and secondary market research through healthcare websites and telephonic communication.
Compared diagnostic test rates and healthcare packages to identify market pricing trends.
Used Excel, SQL, and databases to organize, clean, and analyze operational data.
Analyzed patient workflows from inquiries and follow-ups through appointments, billing, feedback, MRD, NC, and CAPA.
Collaborated with the R&D team to translate requirements and process gaps into data-driven recommendations.