📋 Deep Dives

How Data Becomes Decisions

Detailed project narratives highlighting business impact, analytics approach, and technical execution across healthcare and enterprise.

01
Smart Report Analyzer
AI-powered report parsing
02
Sales Forecasting
Time-series demand planning
03
Cost of Living Index
Market affordability tool
04
Olympics Tracker
Real-time medal analytics
Case Study 01

Smart Report Analyzer

An LLM-powered pipeline that transforms manual report review into instant, AI-generated executive insights.

GenAI / LLMAutomationExecutive InsightsHealthcare
Problem

Business teams spent excessive time manually reviewing reports (PDF, Excel, CSV), delaying insights for strategy and compliance decisions by days.

Approach
  • LLM-powered parsing for structured & unstructured data with concise executive summaries
  • Automated charting & anomaly surfacing via STAR-style prompt engineering
Impact
~60%Faster Report Review
20+Stakeholders Served
3File Formats Parsed
PythonHugging FaceLangChainPandasPower BIAWS
Case Study 02

Sales Data Analysis & Forecasting

A time-series forecasting engine that replaced guesswork with data-driven demand planning.

ForecastingTime-SeriesScenario PlanningSupply Chain
Problem

Leadership faced unpredictable demand, leading to inventory mismatches and excess across multiple business units — costing hundreds of thousands.

Approach
  • ARIMA & Prophet models with seasonality decomposition
  • Power BI dashboards with scenario planning and error bands
Impact
~20%MAPE Improvement
$500KProjected Savings
4Business Units
SQLPythonProphetPower BI
Case Study 03

Global Cost of Living Index

An interactive Streamlit application comparing market affordability across 50+ countries.

StreamlitData PipelinesDecision Support
Problem

Global strategy teams needed standardized cost-of-living metrics — but existing data required hours of manual normalization.

Approach
  • Interactive Streamlit app with filters, drilldowns, and CSV export
  • Normalization across CPI, rent, and grocery basket prices
Impact
40+Hours Saved / Month
50+Countries Covered
Real-timeData Comparisons
PythonStreamlitPlotlyPandas
Case Study 04

Paris Olympics 2024 Medal Tracker

Real-time analytics dashboard delivering medal standings to 100+ stakeholders.

APIsReal-TimeDashboards
Problem

Media teams needed up-to-date medal standings — but manual data pulls created bottlenecks during the Games.

Approach
  • Ingested official feeds with automated country & sport breakdowns
  • Multi-filter views with shareable URL state
Impact
100+Stakeholders Reached
ZeroManual Updates
Real-timeData Feed
PythonREST APIsPower BIPlotly