Challenge
Before
Each department ran its work on separate Excel files, tools and spreadsheets. Data was scattered and the linkage between effort, evaluation and hiring was lost.
- Unify each department's tools into oneExcel and SaaS scattered across departments
- Auto-aggregate effort and attendance dataManual Excel entry took days for month-end tallying
- Link projects × effort × evaluationSiloed tools fragment data
- Automate candidate trackingCandidate data managed in Excel
Solution
After
On a shared Express + Knex + MySQL backend, 30+ business modules are implemented as a unified UI with React + Material-UI. Role-based, department-optimized screens are delivered from one platform.
Unified dashboard — attendance, leave and overtime at a glance
