Integrated Enterprise HRIS & ERP Ecosystem
An integrated enterprise system designed from scratch to manage the entire HR lifecycle and business group operations. Covers complete HRIS modules (Personnel, Biometric Attendance, Payroll, ESS) and ERP modules (Finance, Accounting, Advertising/Marketing CRM). This system serves as the operational backbone for hundreds of employees across all Bisnis Indonesia Group entities.
Role
Lead Architect & Full-Stack Developer
Timeline
2021 – Present
Organization
PT. Jurnalindo Aksara Grafika (Bisnis Indonesia Group)
Impact & Tangible Results
60%+
Payroll Time Reduction
From a manual weekly process to automated calculation in minutes.
100%
HR Digitalization
Elimination of manual spreadsheets for all personnel and attendance data.
Multi-Entity
System Coverage
Used by all Bisnis Indonesia Group entities on a single platform.
Real-Time
Data Visibility
Executive dashboard with direct employment and financial insights.
Problem Statement
The company previously relied on aging Oracle Forms/Reports systems that were unresponsive, difficult to maintain, and unable to support modern integrations. The manual payroll process took weeks, HR data was scattered across spreadsheets, and there was no real-time visibility into attendance or budgets.
Solution & Architecture
Built a fully decoupled multi-repo ecosystem, with a Next.js frontend communicating to an Express.js backend via secure RESTful APIs, and PostgreSQL as the single source of truth for all data.
Architecture Details
Next.js Frontend (App Router) with TypeScript for type safety and SSR/SSG hybrid rendering.
Express.js backend with a clean layered architecture (controller to service to repository).
PostgreSQL with a normalized relational schema and versioned migrations.
Multi-container for local, staging, and production environment isolation.
JWT-based RBAC (Role-Based Access Control) with refresh token rotation.
Immutable audit log for all financial transactions and sensitive data changes.
Key Modules & Features
Personnel & Master Data Module
Complete employee data management: profiles, contracts, job history, dynamic org structure, and digital documents.
Attendance & Biometric Module
Fingerprint machine integration, real-time attendance summary, and leave/permit management with multi-level approval workflow.
Payroll & Compensation Module
Automated multi-scheme salary calculation (monthly, daily, prorated) with PPh21, BPJS, variable allowances, and overtime.
Employee Self-Service (ESS)
Employee self-service portal for leave requests, overtime claims, digital payslips, personal data updates, and attendance history.
Finance & Accounting ERP Module
Journal recording, department budget management, real-time P&L reports, and group financial transaction reconciliation.
Advertising & Marketing CRM Module
Client management, ad order tracking, sales commission calculation, and revenue reporting per media business segment.
Challenges & Engineering Solutions
Challenge #1
Complexity of multi-scheme payroll calculation with hundreds of compensation variables and deductions.
Solution
Built a configurable rule-based payroll engine without requiring code changes, allowing HR to set formulas independently.
Challenge #2
Migrating historical data from Oracle Forms to PostgreSQL without operational downtime.
Solution
Phased migration strategy with a dual-write period, where both systems ran in parallel until 100% data validation was complete.
Challenge #3
Financial transaction data consistency in a highly concurrent system.
Solution
Implemented strict ACID database transactions and row-level locking on critical operations, with an append-only audit log for full traceability.