Puspa ERP.
Internal ERP system for PT Bhawana Piranti Semesta covering inventory management, sales operations, accounting ledgers, and HR workflows. Designed the cross-module MySQL schema to normalize data shared across departments — inventory items, employee records, and cost centres are defined once and referenced by all modules.
The primary deliverable was a unified reporting dashboard that replaced four separate per-department tools. Consolidating reporting gave management a consistent view across all modules without context-switching, and eliminated the synchronisation errors that arose when departments maintained their own spreadsheets.
Cross-module schema: shared master tables for inventory items, employees, and cost centres referenced by all modules
Unified reporting dashboard replaced 4 separate per-department tools with a single source of truth
Modular PHP architecture with a shared data-access layer used across all 4 modules
Role-based access control scopes each user to their department's modules and data
Accounting module derives P&L automatically from integrated inventory and sales data