Skip to content
abees.meCase study

Case study 03 — Local Government Projects · Delivered

Civic Operations Dashboards

Period
Jan 2024 – Jan 2025
Role
Developer — led full lifecycle for 5 concurrent applications
Stack
React · FastAPI · Python · Supabase · OpenAI API

Problem

Local-government departments ran point-of-sale, housing-society management, and supply-chain workflows on legacy tools and manual reports. Reporting was slow and reliability was poor.

Constraints

  • 01Five concurrent applications, one developer, community-service budget
  • 02Three legacy systems needing migration without stopping operations
  • 03Non-technical staff across multiple departments
  • 04Reports that previously took hours of manual effort

Architecture

POSHousing mgmtsocieties · plotsSupply chainstock · movementFastAPI servicesPython · SupabaseDashboardsreal-time · 50+ DAUOpenAI APIautomated reports
Departmental apps on one modern stack, with automated reporting via the OpenAI API.

What was built

  • POS, housing-society management, and supply-chain systems in production
  • Real-time dashboards (React + FastAPI) replacing manual reporting
  • Migrated 3 legacy systems to a modern Python/Supabase stack
  • OpenAI API integration automating report generation and data processing

Outcome

Users

50+ daily active users across delivered systems

Migration

3 legacy systems moved to Python/Supabase

Scope

Full lifecycle of 5 apps — requirements to deployment

All shipped systemsNext: Colony Management System