Loading case study...
[Technical_Log]MINIERP
05 / 05BELFORT MINI-ERP
Belfort MiniERP is a modern enterprise resource planning and revenue intelligence suite designed to eliminate Excel-based business tracking. It provides executives and operational teams with an automated single source of truth across revenue trajectory audits, top revenue-generating anchors, accounts receivable collections, and procurement governance.
- Role
- Lead Full Stack Engineer & Architect
- Timeline
- 3 months
- Team
- Solo project in direct collaboration with Belfort management
- Disciplines
- Rust / Next.js / Docker
VIEW // MINIERP_PRIMARY
01
Problem Space
A fragmented, manual status quo
Belfort's business tracking was historically handled across complex, fragmented Excel workbooks. As transaction volume scaled, manual data entry, spreadsheet corruption, and decoupled procurement and collections workflows caused substantial delays and visibility blind spots.
- 01
Manual spreadsheet entry across multiple departments led to data inconsistencies and formula breakdown
- 02
Monthly financial audits required days of manual Excel reconciliation before numbers could be trusted
- 03
Lack of real-time visibility into customer revenue velocity and overdue collections aging
- 04
Procurement and spend tracking were disconnected from incoming revenue, clouding true operating margins
- 05
Version sprawl across desktop Excel files created data integrity and security vulnerabilities
02
Process
How the system was built
I audited daily spreadsheets used by sales, collections, and purchasing departments to map every data touchpoint. I then architected a compiled Rust backend coupled with a relational PostgreSQL model, containerized the platform via Docker, and deployed on Contabo cloud infrastructure with an intuitive Next.js executive dashboard.
- Decision 01
Built high-throughput backend services in Rust for compile-time memory safety, sub-millisecond query execution, and reliable financial calculations
- Decision 02
Containerized the entire application ecosystem with Docker and Docker Compose for deterministic multi-service isolation
- Decision 03
Deployed on Contabo high-performance cloud VPS infrastructure with Nginx reverse proxying and automated SSL
- Decision 04
Selected Next.js with TypeScript and Tailwind CSS for responsive executive dashboards and Recharts trajectory visualizations
- Decision 05
Engineered real-time 'Revenue Anchors' and collections pipelines to replace manual spreadsheet workflows
03
Delivered System
Capabilities shipped
A comprehensive web-based ERP platform that unifies commercial administration into four dedicated operational modules: Revenue Hub, Performance Audits, Collections Management, and Procurement Governance.
01
Executive Revenue Hub
Live aggregation of total revenue (TZS 46.2M+), velocity metrics against prior periods, monthly averages, and active consumer volume.
02
Revenue Trajectory Audit
Interactive time-series charts (Chronos / Vector views) comparing multi-month revenue trends and trajectory velocities.
03
Top Revenue Anchors
Automated ranking of high-performing products and key enterprise clients to optimize inventory and sales focus.
04
Collections & Debtors Pipeline
Real-time receivables tracker to monitor outstanding customer invoices and accelerate collection velocity.
05
Procurement Governance
Structured purchase order workflows and supplier spend logs that prevent unauthorized expenditures.
06
Enterprise Data Integrity
Centralized relational store with audit logs and access controls, eliminating desktop spreadsheet vulnerabilities.
04
Technical Stack
System architecture
Hybrid full-stack architecture pairing a compiled, memory-safe Rust backend service handling ledger computation and high-concurrency API endpoints with a Next.js executive frontend. The entire stack is containerized using Docker and Docker Compose, running in production on a Contabo cloud server behind an Nginx reverse proxy.
- Backend & Systems
- Rust · Docker · Docker Compose · PostgreSQL · SQLx
- Frontend
- Next.js · React · TypeScript · Tailwind CSS · Recharts
- Infrastructure & Hosting
- Contabo VPS · Linux / Ubuntu · Nginx · GitHub Actions CI/CD
05
Measured Impact
What the numbers say
Belfort MiniERP successfully transitioned day-to-day administration off fragile spreadsheets into an automated, real-time command center.
100%
Excel tracking eliminated
<1s
Dashboard query latency
TZS 46.2M+
Audited revenue throughput
Zero
Spreadsheet formula errors
4
Unified business hubs
100%
Audit trail coverage
Switching from messy Excel spreadsheets to MiniERP gave us instant clarity on our daily revenues, top products, and collections without waiting days for manual reports.
06
Retrospective
Notes for the next build
- R-01
To replace Excel successfully, the new system must be faster and simpler to navigate than opening a spreadsheet
- R-02
Visualizing revenue anchors and velocity upfront provides immediate operational value to sales managers
- R-03
Structuring collections and procurement alongside revenue prevents cash flow blind spots