Project Overview

I built an Internal HR Management System that centralizes employee records, payroll, leave management, promotions, performance evaluation, and workforce analytics into one structured platform.

The system was built using Airtable as the core employee database and backend, with structured tables to manage HR operations and analytics dashboards to provide real-time visibility into workforce health.

This system is designed for growing companies that want to manage HR internally, reduce reliance on spreadsheets, and gain clarity on employee performance, retention, and workforce trends without adopting heavy HR software.

🎯 Problem / Challenges

• Employee data scattered across spreadsheets and documents
• Payroll, leave, and promotions tracked manually
• Difficulty monitoring employee performance and evaluations over time
• No clear visibility into workforce growth, retention, or attrition
• HR decisions based on assumptions rather than data
• Reporting required manual compilation and was often outdated

⚙️ Solution Overview

I designed a centralized HR system that:

• Stores all employee data in one structured database
• Automates payroll, leave, and promotion tracking
• Tracks performance evaluations consistently
• Provides real-time workforce analytics for better decision-making
• Gives management visibility into employee trends without manual reporting