← All projects
06 / Enterprise data system
HR Leave Management System
An end-to-end Oracle leave-management system with role-based approvals, balances, reporting, and automated maintenance.
Product screenshot
The challenge
Leave management spans policy validation, approval workflow, balances, and compliance reporting; those concerns must stay consistent across the process.
What I built
- Multi-stage role-based approval lifecycle
- Holiday-aware balance calculation and yearly accruals
- Notifications, scheduler jobs, dashboard views, and test scripts
Technical approach
Oracle PL/SQL packages organize leave requests, approvals, balances, notifications, reporting, and maintenance. Views provide dashboard-ready queries, while scheduler jobs run accrual and retention work.
Key decisions
- Encode approval stages and authorization in the database to protect workflow integrity.
- Re-check balances at final approval to avoid race conditions.
- Separate operational packages from reporting views and scheduled maintenance.
Demo status
Live at manager.hemanthga.com as Hemanth's Manager: a safe interactive demo with fictional data, leave balances, validation, and manager-to-HR approval flow.