Case studies

Projects that shipped, ran, and moved numbers.

Each project below is a full case study — the business problem, the architecture, the trade-offs, and the measurable impact. Screenshots and live demos are linked where available.

All ERP Dashboards Financial Analytics APIs Research

Fairway ERP

PythonNiceGUIPostgreSQLFastAPIReportLab

01 · ERP Platform

Fairway Construction ERP

A full-stack ERP suite for a mid-sized construction firm — double-entry accounting, payroll, procurement, inventory, and financial reporting under one deployment.

🎯 Business problem

Fragmented Excel workflows, no audit trail, and 5–7 day monthly closes.

🧩 Solution

Unified ERP with role-based access, journal-entry posting, and automated reports.

⚙️ Architecture

NiceGUI frontend · FastAPI service layer · PostgreSQL with double-entry constraints.

📈 Impact

Month-end close reduced from 7 days to under 24 hours. Reporting errors down 92%.

Live Demo GitHub

02 · BI Dashboard

Financial Analytics Dashboard

Executive-grade P&L, cash-flow, and working-capital dashboard with drill-downs by cost center, project, and time period.

🎯 Business problem

Leadership needed weekly financial insight but received month-old PDFs.

🧩 Solution

Automated ETL from ERP → warehouse → Streamlit with cached queries and RBAC.

⚙️ Architecture

Pandas ETL · PostgreSQL warehouse · Streamlit + Plotly · Firebase Auth.

📈 Impact

Daily refresh replaces monthly PDFs. CFO cited 3× faster decision cycle.

Live Demo GitHub

Finance BI

StreamlitPlotlyPandasPostgreSQL

Equity IQ

PandasPlotlyStreamlit

03 · Equity Analytics

Shareholder Analytics Dashboard

Cap-table intelligence, dividend forecasting, and concentration analytics to give private equity teams a live view of ownership.

🎯 Business problem

Ownership changes tracked manually across 200+ shareholders.

🧩 Solution

Event-driven cap-table with dividend projection and Herfindahl concentration index.

⚙️ Architecture

SQLite + Pandas · Streamlit · Plotly Sunburst · CSV export.

📈 Impact

Board reporting time down 80%. Enabled scenario-based dividend planning.

Live Demo GitHub

04 · Real-time BI

Binance Trading Analytics Dashboard

A live crypto trading analytics platform streaming Binance WebSocket data with volatility, drawdown, and risk-adjusted return metrics.

🎯 Business problem

Retail traders lacked institutional-grade risk views on their positions.

🧩 Solution

WebSocket → Redis buffer → analytics engine → live Streamlit tiles.

⚙️ Architecture

Async Python · WebSockets · NumPy rolling stats · Plotly candlestick.

📈 Impact

Sub-second refresh on 20+ symbols; used daily by an active portfolio.

Live Demo GitHub

Trading BI

WebSocketNumPyStreamlitAsync

Finance API

FastAPIPydanticJWTPostgreSQL

05 · API Platform

FastAPI Financial Data API

A production-grade REST API exposing accounting entities — accounts, journals, ledgers, and reports — with JWT auth, rate limiting, and OpenAPI docs.

🎯 Business problem

Multiple frontends needed the same accounting data with strict access controls.

🧩 Solution

A typed FastAPI service with Pydantic schemas and role-scoped JWTs.

⚙️ Architecture

FastAPI · SQLAlchemy · Alembic · JWT · Docker · GitHub Actions CI.

📈 Impact

Powered 3 frontends (web, desktop, mobile) with a single source of truth.

API Docs GitHub

06 · Research Analytics

Research Data Analysis Dashboard

A publication-ready analytics platform for academic surveys — automated cleaning, GLM modelling, and export of journal-grade figures.

🎯 Business problem

Researchers spent weeks cleaning Likert data and generating plots for revisions.

🧩 Solution

Parameterised pipeline with reusable statistical modules and PDF report export.

⚙️ Architecture

Python · statsmodels · R integration · Matplotlib · WeasyPrint PDFs.

📈 Impact

Cut analysis-to-figure time from 2 weeks to 2 hours per revision.

Live Demo GitHub

Research Lab

statsmodelsRGLMMatplotlib

Payroll

PySide6SQLiteReportLab

07 · HR & Payroll

Payroll Management System

A desktop payroll application handling attendance, statutory deductions, bonuses, and PDF payslip generation for up to 500 employees.

🎯 Business problem

HR ran payroll in Excel with recurring errors and no audit trail.

🧩 Solution

Offline-first desktop app with signed payslips and change history.

⚙️ Architecture

PySide6 · SQLite · ReportLab · Python packaging.

📈 Impact

Payroll cycle reduced from 3 days to 4 hours with zero calculation errors.

GitHub

08 · Operations

Inventory Management System

Multi-warehouse inventory with barcode support, reorder alerts, valuation methods (FIFO/Weighted Avg), and stock-movement analytics.

🎯 Business problem

Frequent stock-outs and inflated closing inventory due to manual counts.

🧩 Solution

Real-time transactional inventory with automated valuation.

⚙️ Architecture

FastAPI · PostgreSQL · NiceGUI · Plotly analytics module.

📈 Impact

Stock-out incidents down 74%; audit-ready valuation on demand.

GitHub

Inventory

FastAPINiceGUIPostgreSQL