Work

Case studies on systems and decision support

Work on data access, warehouse modeling, and operational decisions.

Case study

AI-Powered Text-to-SQL System

Built an AI-powered Text-to-SQL system that used structured metadata, Athena execution, and validation loops to speed up ad-hoc analytics.

Outcome: 4-10 hours to under 1 hour

Case study

Graph-Based Warehouse Optimization and Simulation

Built a warehouse optimization workflow that combined graph construction and simulation to test inventory placement and picker travel distance before a full optimizer existed.

Status: usable first system for directional analysis

Case study

Recommended Order Quantity for Perishable Inventory

Built a perishable ordering engine that combined forecast with freshness, timing, and warehouse constraints.

Decision engine: forecast plus freshness and handling constraints

Case study

Operational Reporting and Dashboard Systems

Built recurring reports and dashboards so inventory exceptions, stock risk, and ordering issues became easier to spot and act on.

Recurring visibility for inventory exceptions and stock risk

Case study

Sales Forecasting Competition

Won a public forecasting competition by matching the preprocessing and forecast logic to the competition's asymmetric scoring rule.

First place by matching preprocessing and forecasts to the scoring rule

Case study

Supplement Recommendation Prototype

Built a web prototype that matched supplement suggestions to profile inputs using scraped product and review data.

End-to-end prototype from data collection to recommendation flow

Case study

Tweet Sentiment Tracker

Built a public-data analysis project that collected historical tweets, stored them in PostgreSQL, and scored sentiment over time.

End-to-end text analysis pipeline on public social data