Employee Management System (HRIS)
A centralized HRIS platform featuring employee self-service (attendance clock-in, daily work log entry, attendance history, and leave request workflows) alongside automated payroll, contract management, and HR reporting for multi-department organizations.
// Key Challenges
- Data Fragmentation: HR, Finance, and Department heads each maintained separate employee files with no single source of truth.
- Manual Data & Manipulation Risks: Monthly payroll calculated via manual spreadsheets was vulnerable to data input errors, formula miscalculations, and unauthorized tampering of overtime, deductions, or allowances.
- No Contract Visibility: Employment contract expiry dates were tracked manually, causing unnoticed contract lapses.
- High Concurrent Access: Multiple HR staff, department managers, and employees needed simultaneous access for daily attendance logging, work reporting, and payroll processing without data corruption.
// Approach & Solutions
1. Employee Self-Service Portal
Empowers employees to record daily attendance, submit detailed daily work reports, view complete attendance logs, and file leave requests with automated manager approval routing.
2. Unified Employee Data Hub
Single-source database with role-based access control (RBAC) separating Employee Self-Service, HR Admin, Department Manager, and Finance views.
3. Automated Payroll Engine
Rule-based payroll computation engine handling base salary, attendance deductions, overtime additions, and allowances automatically — generating printable payslips in one click.
4. Contract Expiry Alert System
Scheduled background jobs send automated email alerts 30/15/7 days before contract expiry, eliminating missed renewal risks for both probationary and fixed-term employees.
// Tech Stack
| Technology | Reason |
|---|---|
| FastAPI + PostgreSQL | FastAPI with SQLAlchemy ORM provides efficient async transaction management for high-frequency attendance logs, daily work reports, and concurrent payroll writes; PostgreSQL handles complex JOIN queries across attendance, contract, and salary tables without performance degradation. |
| Celery Beat | Cron-like scheduler for automated contract expiry checks, leave quota reset tasks, and payroll report generation without manual HR intervention. |
| Redis | Session caching for high-concurrency periods (daily peak morning attendance & payroll week) and task queue backend for background payslip generation jobs. |
// Results & Business Impact
- 100% - Payroll Accuracy (Zero manual calculation errors since system deployment)
- 0 - Missed Contract Renewals (Automated 30/15/7-day alerts eliminated all lapsed contracts)
- 3x - Faster Payroll Processing (Monthly payroll cut from 3 days manual work to under 1 day)
- 1 - Unified Data Source (Replaced 6+ departmental spreadsheets with one access-controlled system)
// Project Gallery
