Project Overview
A production-ready HR & Payroll Management System (PMMS) that automates the full employee lifecycle — from onboarding and attendance tracking to payroll processing and analytics reporting.
The system features role-based access control — admins manage the entire system while employees access their own dashboards for payslips, attendance, and profile management.
Problem Statement
Manual HR processes are time-consuming, error-prone, and hard to audit. Companies waste hours on payroll calculations, attendance records, and report generation. This system eliminates all of that.
Key Features
- Employee Dashboard — attendance history, payslip access, profile management
- Admin Dashboard — manage all employees, departments, attendance, and payroll
- Automated Payroll — calculate salary, deductions, and generate payslips
- Attendance Tracking — mark, view, and export attendance records
- Analytics Module — integrated Power BI dashboard for workforce insights
- Payment Slip Generation — downloadable payslip HTML templates
- Role-Based Auth — admin vs employee access separation
Technical Highlights
Built on Flask with a clean template architecture and MySQL backend. The db.py module provides a clean database abstraction layer. Power BI integration gives management real-time workforce analytics without writing SQL manually.
- Modular route structure — admin routes separated from employee routes
- MySQL stored procedures for payroll calculations
- Responsive HTML/CSS with custom JS for dynamic UI updates
- Power BI .pbix file for executive-level workforce reporting
Business Impact
Automates payroll processing that would otherwise take HR teams days per month. The analytics dashboard turns raw attendance data into actionable workforce insights — absenteeism trends, department productivity, and salary distribution.
System Screenshots
