Case Study: Building a Complete HR Management System for an Apparel Manufacturer

Summary: An apparel manufacturing company in Pakistan was running HR on spreadsheets. SG Technologies designed and built a complete HR management system — employee records, recruitment, onboarding, attendance, leave, payroll, loans, performance, self-service, compliance, offboarding and HR analytics — in one web application built with React, Node.js, Express and MongoDB. Client details, employee names and salaries are hidden in all screenshots.

The client

A Pakistani apparel manufacturer with management, finance, services, sales and technical teams working from a Lahore office, and a structure that spans more than one company.

The challenge

Like many growing manufacturers, the HR team was managing people with spreadsheets and paperwork:

• Attendance, late arrivals and leave balances were calculated manually.
• Payroll took a long time to prepare, with loans and advance deductions tracked separately.
• Managers had no direct view of their team's attendance or leave.
• There was no single, trusted record of employees, designations and departments.
• Management had no quick way to see headcount, hiring and attendance trends.

What we built

One web-based platform covering the entire employee lifecycle, with a module for each part of HR:

• Employee management — complete employee cards with code, company, division, department and designation, plus an organogram.
• Recruitment & hiring and onboarding.
• Attendance & time management — the current month fills automatically: every day is assumed present unless covered by approved leave, a rest day or a manual mark; anything more than 10 minutes after the 09:00 start is marked late.
• Leave management — leave requests, approvals, annual and short leave balances.
• Payroll management — a payroll register for any date range and division, with gross pay, salary deductions, loan and advance deductions and net pay, printable and downloadable as PDF.
• Loan management with automatic deductions.
• Performance management and learning & development.
• Employee self-service (ESS) and manager self-service (MSS).
• Employee relations, career management and compliance & policy management.
• Offboarding & exit management.
• HR analytics & reporting, plus auto email notifications.
• Company profile and company list for multi-company use, user logins and a log tracker (audit trail).

A live dashboard for HR

The dashboard answers the questions HR is asked every morning: total employees, present, absent and on leave today, a 7-day attendance chart, recent leave requests, all-time hires, resignations, open positions and a hiring overview.

One trusted employee directory

Every employee has a single record — code, company, division, department and designation — searchable and filterable, and used by every other module.

Attendance that calculates itself

Each employee's page shows total leaves taken, annual leave remaining, short leave, attendance rate and late arrivals, with a daily attendance log that is filled automatically and marked as auto-calculated or manual.

Payroll in minutes, not days

The payroll register brings together gross salary, salary deductions, loan and advance deductions, other deductions and net pay for every employee, for any period and division, ready to print or download as PDF.

Technology

• Front end: React — fast, responsive screens for HR staff, managers and employees.
• Back end: Node.js and Express APIs.
• Database: MongoDB.
• Security: role-based access for super admins, HR, managers and employees, user login management and a full audit log.

The result

• One system instead of many spreadsheets — every module uses the same employee data.
• Attendance, leave and payroll connected, so payroll uses real attendance and approved leave automatically.
• Managers and employees self-serve, which reduces requests to HR.
• Live visibility of attendance, hiring and headcount for management.
• Scales across companies and divisions as the business grows.

Could this work for your company?

If your HR team is still working in spreadsheets, or your current software doesn't fit your policies, we can build a similar system around your structure, shifts and rules — starting with the modules that matter most. Read our guide to HR and payroll software in Pakistan or start a project.

Frequently asked questions

What does the SG Technologies HR management system include?

It includes employee management, recruitment, onboarding, attendance and time, leave, payroll, loans, performance, learning and development, employee and manager self-service, employee relations, compliance, offboarding, HR analytics, auto email, multi-company support, user logins and an audit log.

Which technologies were used to build the HR system?

React on the front end, Node.js and Express for the back end, and MongoDB for the database.

How does the system calculate late arrivals?

Attendance for the month is filled automatically. Each day is marked present unless it is covered by approved leave, falls on a rest day or is marked otherwise, and any check-in more than 10 minutes after the 09:00 start time is marked late.

Can a similar HR system be built for my company?

Yes. SG Technologies builds HR systems around each client's own structure, policies and approval rules, usually in phases starting with employees, attendance, leave and payroll.