Official Travel Governance System ESDM (SPPD)
Ministry of Energy and Mineral Resources (Kementerian ESDM)
Continuous maintenance and query optimization for the official civil service travel governance system (SPPD ESDM) since 2020.
Software Engineer (Maintenance)
2020 — Present
PT Mitreka Solusi Indonesia
Overview
Long-term maintenance and technical stewardship for the official travel governance platform (SPPD) at the Ministry of Energy and Mineral Resources (ESDM). The system handles the entire workflow of civil service travel orders, approvals, and disbursement audits.
Project Context
A mission-critical legacy management system supporting hundreds of travel missions monthly across ESDM directorates.
What I Worked On
- Ensuring long-term system reliability and continuous maintenance for the ESDM Official Travel Governance System (SPPD) from 2020 to present, demonstrating steadfast commitment to ministerial legacy system stability.
- Perform regular query optimization, database indexing, and bug resolution directly on live ministry hosting environments.
- Maintain workflow authorization integrity across submission, multi-tier approval, and travel reimbursement lifecycles.
Technical Challenges
- Managing complex submission-to-reimbursement lifecycles with multi-role authorization levels.
- Maintaining consistent server performance and database query speed during peak travel submission cycles.
Implementation Details
- Refactored database query execution and indexing for historical travel reports and status audits.
- Implemented modular submission approval steps and financial accounting checks.
No public screenshots available. This platform is an internal government or banking management system subject to institutional data confidentiality.