Gokkul.dev
Back to all projects
Team Project / Full Stack · 2026

HRMS System

Attendance, payroll & payslips

hrms-system — experience preview (simulation)
Live sim

A job fails (a PDF or email timeout). BullMQ retries it with exponential backoff.

Run payroll

Problem

Manual attendance and payroll runs don't scale — geo-spoofed check-ins, missed payslips, and RBAC gaps are common failure points.

Approach

  • Async payroll engine (BullMQ + Redis), geo-tagged attendance with OpenStreetMap reverse-geocoding, AES-256 JWT auth, and RBAC middleware.
  • Real-time Socket.IO notifications, Puppeteer PDF payslips, and ExcelJS bulk import/export.

Result

Attendance is geo-verified against real coordinates, payroll runs asynchronously without blocking the API, and payslips/exports generate on schedule.

Stack

Node.jsExpress.jsMySQLRedisBullMQSocket.IOJWTAES-256PuppeteerExcelJSNodemailer

The preview above replays the hardest moment of this project's Experience, drawn from the same simulation code. Click it to try the whole thing yourself.

Under the hood

A simplified excerpt of the core logic and how a request flows through the system.

// queues/payroll.worker.js
const worker = new Worker(
"payroll",
async (job) => {
const { employeeId, month } = job.data;
const days = await getAttendance(
employeeId, month
);
const net = calculateNet(days);
await Payslip.create({ employeeId, net });
await generatePdfAndMail(employeeId);
},
{ connection: redis, concurrency: 5 }
);

Payroll pipeline

Attendance API
BullMQ queue (Redis)
Payroll worker

Connects to

MySQLPuppeteer PDFNodemailerRBAC middleware

More projects