Maksudur Rahman
Maksudur Rahman
Back to Projects
Case Study2020 - 2021

HRM & Payroll Engine

A payroll-focused HRM engine that handles work shifts, salary disbursement, tax deductions, and compliance records.

Role

Backend Lead

Sector

Enterprise

db://hrm-payroll-audit

Active Salary Query

SELECT name, salary_hash FROM employees

// AES-256 Cryptographic Output

0x8F3D129C... (Arif R.)

0x9E7F44B2... (Tariqul I.)

Blind index search matched.Log: Saved

The Challenge

  • Custom calculations for shifts, overtime, holidays, and employee tax variables.
  • Keeping sensitive payroll and salary information encrypted yet searchable by managers.
  • Slow report queries running over thousands of active employee records.

Our Solution

  • Built a custom payroll engine utilizing dynamic formula evaluators.
  • Implemented column-level AES database encryption combined with blind index search.
  • Created materialized views and query optimization structures to cache reports.

Measured Impact

"Automated payroll calculations, ensuring zero calculation errors and cutting pay processing time by 75%."

System Reliability Verified