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.

View source Oracle / PL/SQL / SQL / Reporting

Project preview

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

Source available. A hosted demo is not planned because it requires an Oracle database environment.