I was initially hired as IT Support (hardware, POS, CCTV, and network). After identifying process gaps, I independently designed and developed a custom ERP system for Holycow restaurants (multi-branch across Indonesia) to integrate operations across divisions in a single, database-driven platform.
Integrated Divisions
HR, IT, Maintenance, Operations, Marketing, Cost Control, Purchasing, and Outlets—connected end-to-end with clear roles and audit trails.
Key Features I Built
- HR: employee database, leave management, auto-generated letters.
- IT & Maintenance: barcode-based asset tracking, damage logs, asset transfers & repairs.
- Operations: raw-material inventory and daily operational checklists.
- Marketing/CRM: customer data, voucher system, engagement tracking, campaign calendar.
- Finance & Purchasing: sales tracking, vendor & inventory management, PR/PO workflows.
- Outlet Integration: consolidated sales reports, voucher allocation & reconciliation.
Measured Impact
- 80–90% faster report generation (days → minutes) via automated Excel/PDF and dashboards.
- 70–80% faster data retrieval across HR, IT assets, and operations.
- 300+ internal transactions/month processed (HR requests, asset movements, maintenance logs, inventory, purchasing).
- 100% improvement in asset tracking with barcodes, boosting accountability and reducing loss.
- ~50% fewer human errors, especially in inventory, HR records, and asset transfers.
Additional Contributions
- Built event campaign microsites (e.g., company anniversary) to drive engagement.
- Led digital transformation: automated manual workflows and centralized data for better decisions.
- Provided on-ground IT support across branches during rollout and stabilization.
Technology & Role
- Role: Full-Stack Developer — module design, implementation, integration, testing, rollout, and training.
- Stack: Yii2 (PHP) backend, Bootstrap UI with jQuery/AJAX interactions, MySQL database (with PJAX used where pragmatic).
Status
In progress — ongoing iterations aligned to daily operational needs, with continuous improvements to reporting, usability, and cross-division visibility.