e-Pilammas
Freelance · Government / education
Personnel and salary recap system for honorary teachers, PPPK, and civil servants (PNS).
- Laravel
- MySQL
- Government Project
Architecture overview — internal system, diagram shown in place of screenshots.
01Problem Solved
Personnel and salary data for different teacher categories (honorary, PPPK, PNS) was recapped manually, which was slow and error-prone.
02Solution
A web application to manage teacher personnel data and generate salary recaps per category automatically.
03Key Features
- Personnel data management for honorary teachers, PPPK, and PNS
- Salary recap per teacher category
- Reports and data export
- User roles for administrators
04Technologies Used
- Laravel
- PHP
- MySQL
- Bootstrap
- jQuery
05Challenges & Solutions
Challenge
Different rules per teacher category
Solution
Modeled each category separately in the database so recaps follow the right rules.
Challenge
Accuracy of salary data
Solution
Validated input and generated recaps from one data source instead of manual spreadsheets.
06My Role
Web & Back-end Developer
Built the application end to end: database design, back-end, and reports.
07Business Impact
- Faster, more accurate salary recaps.
- Centralized teacher personnel data.
Want to hear more about how this was built?
Let's Talk