Portfolio evidence • multi-role scope

Workflow, Integrations, and Role Evidence

This page maps real code, data pipelines, and infrastructure to the exact skills and roles demonstrated by FleetFlow.

Live demo runs on free-tier infrastructure

Supabase + Upstash + Railway (fallback-safe, limited workloads)

Full-power stack is local-first

Run locally to unlock Kafka, Flink, Airflow, PostGIS, TimescaleDB, Redis, MongoDB, OSRM.

Portfolio priority: local = full capabilities

Workflow & Integrations

End-to-end flow from data to decisions

Ingest + Stream

Producers emit orders, GPS, and route events into Kafka topics for real-time flow.

KafkaFastAPIKafka consumers

Store + Index

Operational data is stored in Postgres/PostGIS with time-series in TimescaleDB.

PostgreSQLPostGISTimescaleDB

Batch + Transform

Airflow DAGs orchestrate dbt models and scheduled optimization workloads.

AirflowdbtSQL models

Optimize

OR-Tools and custom heuristics compute multi-objective routes and assignments.

OR-ToolsOptimization API

Predict

Forecasting ensemble blends Prophet, LSTM, and XGBoost for demand prediction.

ProphetTensorFlowXGBoost

Serve + Observe

FastAPI APIs, WebSockets, and monitoring dashboards expose real-time state.

FastAPIWebSocketPrometheus/Grafana

Role Evidence Matrix

Claims backed by shipped code

Data Engineering

Senior-grade foundations

  • Airflow DAGs for daily optimization + hourly forecasting
  • dbt staging + marts models for analytics layers
  • Flink stream processor for real-time event handling

Data Science

Applied forecasting + EDA

  • EDA notebook with exploratory insights
  • Feature engineering for temporal signals
  • Evaluation metrics utilities in ML pipeline

ML Engineering

Experimentation + serving scaffolding

  • Training + tuning scripts for forecasting models
  • MLflow experiment tracking + model registry hooks
  • Standalone ML inference API for routing + forecasting

Backend / Software

Production-style API core

  • FastAPI REST + GraphQL endpoints with auth middleware
  • Kafka consumers + event producers for state changes
  • Pytest suite for API, consumers, and optimization logic

Full-Stack

Type-safe dashboard + real-time UI

  • Next.js App Router dashboard with tRPC data layer
  • Deck.gl + MapLibre for fleet visualization
  • Playwright E2E tests for demo flows

Data Architecture / DevOps

Multi-store + infra blueprints

  • Postgres/PostGIS + Timescale + Redis + MongoDB topology
  • Docker Compose + Kubernetes manifests for services
  • Prometheus + Grafana dashboards for observability

Skills, Tools, and Libraries

Full stack map
Next.js 16
React 19
TypeScript
FastAPI
Kafka
PostGIS
TimescaleDB
Redis
MongoDB
Airflow
Flink
dbt
OR-Tools
MLflow
Docker
Kubernetes
Prometheus
Grafana

Want the full experience?

The live demo is optimized for free-tier deployments. Clone the repo and run locally to unlock the full stack and advanced workloads.