P-03Shared core of an enterprise ERP platform
Minaret ERP
The shared core of a complete ERP platform, where every change had to hold everywhere, and a data layer tuned at multi-million-row scale.
- Role
- Full-Stack Developer · core engineer
- Company
- AL-MOTKAMEL Global Co.
- Period
- August 2022 – March 2024
- Layers
- Data · Backend
01
Context
Minaret is a complete ERP platform for enterprise operations, not a single system. I worked on the shared core rather than isolated features, so every change had to hold across the whole platform.
The data layer ran at multi-million-row scale, and heavy reports were called again and again.
02
What I built
- 01Composite indexes, partitioning and query rewrites across the data layer.
- 02Heavy reporting logic moved into database stored procedures.
- 03Vue.js SPA clients built against shared REST APIs.
- 04SOLID held in place through code review, written documentation and a consistent component architecture.
03
Results
- Stored procedures cut both the cost of repeated report calls and the round trips behind them.
- A codebase held to SOLID through review, written documentation and one consistent component architecture.
04
Stack
- Laravel
- Python
- PostgreSQL
- Vue.js
- SPA
- REST API
- Stored procedures
- Composite indexing
- Partitioning
- SOLID
Details that belong to clients or employers stay private. Everything here is from my CV.
More work
All workP-01May 2025 – Present
Multi-agent generation pipeline
Muqnea AI pipeline
82%lower generation cost
Case studyP-05May 2024 – May 2025
Records, scheduling, billing and reports
Clinic management system
Freelance · healthcare client
Case study