All work
Price Optimization Tool
2024·Sole engineer·shipped

Price Optimization Tool

A full-stack dynamic pricing tool built end-to-end as part of a BCG X technical interview. Delivered under time pressure: FastAPI backend, PostgreSQL database, React + Recharts frontend, Docker deployment, and real-time pricing algorithms with scenario modeling.

Problem

Pricing decisions at scale require modeling multiple variables simultaneously — demand elasticity, competitor pricing, inventory levels, and margin targets. Spreadsheet-based pricing is slow, error-prone, and doesn't support real-time scenario comparison.

Solution

FastAPI backend exposes pricing algorithm endpoints. PostgreSQL stores product data, historical prices, and scenario configurations. React frontend with Recharts visualizes pricing curves and scenario comparisons in real time. Docker Compose packages the full stack for portable deployment.

Architecture

Backend

FastAPI REST API with endpoints for price calculation, scenario modeling, and product CRUD. Pricing algorithms implement demand elasticity and margin optimization logic.

Database

PostgreSQL stores product catalog, historical price records, and saved pricing scenarios. SQLAlchemy ORM with Alembic migrations.

Frontend

React SPA with Recharts for dynamic pricing curves. Real-time scenario comparison sliders update charts without page reload.

Infrastructure

Docker Compose packages web, API, and database services. Single command deployment — built under interview time constraints.

Highlights

  • Built end-to-end under BCG X interview time pressure — full stack in one session.
  • Dynamic pricing algorithms with demand elasticity and margin optimization.
  • Real-time Recharts visualizations — scenario sliders update pricing curves instantly.
  • Docker Compose packaging for portable, reproducible deployment.