Salomi Gandra

Turning raw data
into clear decisions.

Data Analyst — SQL, Python, Excel. I find the story in the numbers and make it impossible to ignore.

Featured Build
Live Product

Latest updates

8-question quiz
Expanded to cover all 16 streams
4 stages live
After 10th · 12th · Graduation · Vocational
72+ courses
Fully researched with salary & exam data
Product BuildData ArchitectureEducation · India

Pathsy — Career Path Discovery for Indian Students

Students in India face thousands of options after Class 10, 12, graduation, and beyond — with no neutral guide. I structured the entire problem as a relational data model across 4 stages and 16 streams, built a weighted quiz engine on top, and shipped a working product — solo, start to finish.

Every salary benchmark (Fresher → Senior), entrance exam, and career role was researched and curated manually. The quiz now covers 8 questions mapped to all 16 streams — no black box, no AI guesswork.

Solo build — research to deploySEO · performance optimisedLive at pathsy.org
Data Stories
Live Data
₹95.68/$
Live rupee · 2026-06-12
~68%
Modelled pump shock
2.6×
Bottom vs top burden

The Iran Shock: How an Oil Crisis Reaches Indian Household Budgets

Bottom income quintile carries 2.6× the relative fuel burden of the top. Built a crude-to-pump price transmission model with live rupee data.

Price TransmissionQuintile Analysis
Deep dive →
Data Story
7.79%
CPI peak Apr 2022
250 bps
RBI rate hikes
3 wars
Geopolitical triggers

Geopolitical Shocks & CPI: Measuring War's Impact on Consumer Prices

Food CPI leads core by 2–3 months. FD real return turned negative (−0.8%) at peak inflation — traced through three conflict transmission channels.

MacroeconomicsTime-Series
Read →
Data Story
$12,555
US per capita
2.24×
Over Medicare
100M+
In medical debt

U.S. Hospital Price Audit: 2.35× Above Global Benchmarks

Federal reference pricing reform projected to save ~$180B annually. 44% of hospitals non-compliant with price transparency rules.

Healthcare PolicyPrice Analysis
Read →
Data Story
1.67M
Deaths/year
9 of 10
Polluted cities
5.3 yrs
Life years lost

104,300 Premature Deaths: India's PM2.5 Air Pollution Burden

Closing the NAAQS–WHO gap could prevent ~27,000 additional deaths per year. Transport and industry are the primary levers.

Public HealthEnvironmental
Read →
Global Data Story
+1.45°C
2023 global warming
×3.8
Arctic vs global avg
14 yrs
Top 14 on record

National Warming Trajectories: 140-Year Temperature Anomaly Analysis

Current pledges leave a 23.5 Gt gap by 2030. Arctic nations face 3.8× global average warming while contributing the least emissions.

Climate ScienceRegression
Read →
Data Story
78%
Trains on time
₹73K Cr
Annual cost est.
PDI 77
Power Distance

India's $340B Productivity Gap: Quantifying Meeting Overculture

Power-distance norms (PDI 77) drive institutional lateness — scheduling incentives outperform awareness campaigns. ₹73,000 Cr annual workforce cost modelled.

Behavioural DataGame Theory
Read →
Experience
Oct 2023 – Jul 2024
Web Developer· Church Life Apps
Sep 2022 – May 2023
Graduate Assistant — Web Team· Cleveland State University
Mar 2022 – Sep 2022
Web Design & Research Specialist· Cleveland State University