Project: HR Management System
Organization: Ekushey Television Limited
Developer: Ariful Islam Emon
Stack: Visual Basic, MS SQL Server, Biometric Fingerprint Integration
Domain: Workforce Management • Data Engineering • Operational Analytics
Project Report
Background
Ekushey Television operates in a continuous 24×7 broadcasting environment requiring accurate workforce tracking across rotating shifts. Manual attendance processes were inefficient, error-prone, and unsuitable for real-time operational oversight. To address these challenges, a centralized HR Management System (HRMS) was designed and implemented to automate employee data management, attendance processing, leave tracking, and administrative reporting.
Objective
The project aimed to develop an integrated HR platform that:
- Automates attendance capture from biometric devices
- Supports shift-based workforce scheduling
- Provides analytics-ready workforce data
- Enables administrative control and reporting
- Ensures data accuracy and operational transparency
System Architecture
The system follows a structured data workflow:
Biometric Device → Raw Attendance Storage → Validation → Transformation → Application Database → HR Reporting
Key architectural characteristics:
- Centralized relational database (MS SQL Server)
- Desktop application interface (Visual Basic)
- Rule-based attendance evaluation engine
- Role-based user access control
Key Outcomes
- Automated attendance processing across departments
- Reduced manual reconciliation and reporting effort
- Accurate tracking of shift-based workforce activity
- Structured data foundation for HR analytics
- Improved administrative governance and auditability