Projects

Shipped work for real questions.

Products people can use, analytical stories they can explore, and focused case studies with a clear point of view. Each project moves from a messy source or user problem to a working, documented experience.

Take a scroll, stay a while ↓

drrachanaali.com
Full psychology clinic homepage screenshot
Business analysis consulting2026

Psychology Clinic Redesign

Reported inquiries rose from 2 to 15 per month.

Practice-reported consultation inquiries rose from 2 to 15 per month after launch, while observed traffic was 30% higher than the prior level. I gathered requirements from the practice owner, mapped the patient journey, translated findings into page and contact-flow specifications, and delivered the redesign. GA4 measurement is planned to validate the traffic comparison.

Requirements gatheringStakeholder managementAnalytics
Project Insight
Full Project Insight report screenshot
Applied AI product2026

Project Insight

Evidence in. Decision out.

A full stack market research app that turns a company name into a structured, source grounded brief by combining live web search, financial data, public filings, social signals, and AI analysis in one interactive dashboard.

AIResearch workflow
LiveDeployed product
FastAPILLMsProduct design
The Greening Divide
Full Greening Divide globe screenshot
Interactive data story2026

The Greening Divide

The clean hypothesis did not survive the data.

An interactive globe that tests whether environmental greening favors wealthy countries and finds the hypothesis wrong. MODIS vegetation data from 166 countries shows that geography, water, and land use matter more than income.

166Countries
25 yearsCoverage
MODISSatellite data
Geospatial dataResearchVisualization
UC Sustainability Rivalry
Full UC Sustainability Rivalry screenshot
Project leadership · Writing artifact2026

The Other Rivalry

UC campuses compete over everything. Now sustainability has a scoreboard.

I led a four-person research team and built a 63-rank sustainability dashboard. The case study now includes the methodology behind the emissions, LEED, and EUI scoring choices—and the original 27-point first-place tie.

9Campuses
7Metrics
27Winning total
Project leadershipMethodology designAnalytical writing
Outage Lens
Full Outage Lens dashboard screenshot
Prediction and analysis2026

Outage Lens

Where the grid fails, and what predicts it.

An analysis of major United States power outages from 2000 to 2016 using Purdue University laboratory data. It tests how outage causes affect duration and predicts restoration time from information available when an outage begins.

PythonPredictive modelingData visualization

Case studies

Questions examined in depth.

Structured analyses that connect filings, market behavior, and statistical evidence to a clear strategic call.

SMB Money Stack
Full SMB Money Stack website screenshot
Strategic financeCase study 01

The SMB Money Stack

Three models. One five year call.

A 12 of 12 period reconciliation control ties mapped revenue back to reported totals across Intuit, BILL, and Toast. The filing-led model then compares SaaS KPIs and which growth model appears most durable over five years.

12/12Periods tie
3Companies
4 yearsFiling history
SEC filingsFinancial analysisBusiness models
Spotify Collaborations
Full Spotify featured artist analysis screenshot
Statistical analysisCase study 02

Spotify Collaborations

The popularity gap is mostly genre, not collaboration.

I reconstructed a lost 89,740-row analysis dataset by fingerprinting summary statistics from the original presentation and matched the prior result to within one row. I then completed the proposed OLS analysis, corrected two overclaims, and added an algebraic regression test that prevents the genre-decomposition error from returning.

89,740Rows rebuilt
±1 rowPrior match
98.9%Genre composition
PythonFixed effectsMusic data