BACK TO PORTFOLIO
Case Study — DESKTOP

VertexEMS

Replacing a 15-Year-Old HR System — Built for Offline Reliability

Enterprise Workforce Management Desktop App for HR-Intensive Organizations.

ClientVertexEMS
IndustryEnterprise HR
OutcomeHR admin overhead dropped 45% and payroll accuracy reached 99.8% after replacing a legacy Access-based system.
Timeline
8 weeks
Platform
Electron Desktop (Windows · macOS)
Status
Deployed & Live
Project Overview

What We Built

VertexEMS is a cross-platform Electron desktop application that centralizes employee records, attendance, payroll, leave management, performance reviews, and asset tracking for a 340-person manufacturing organization. It operates with full offline capability and syncs to Supabase when connectivity is restored — a critical requirement for the client's factory floor environment.

Desktop View

[Desktop Screenshot]

Mobile View

[Mobile Screenshot]
The Challenge

Problem Statement

The organization ran HR operations on a Microsoft Access database built in 2009. The system had no user access controls, no audit trail, and ran on a single machine. Payroll was calculated in Excel by two full-time staff and contained frequent errors resulting in monthly employee disputes. Remote branches had no HR system at all.

Our Solution

How We Solved It

We built an Electron app with a React frontend that runs locally on Windows and syncs to a cloud Supabase backend when connected. Payroll is calculated automatically from attendance records with configurable deduction rules, overtime multipliers, and advance recovery. Role-based access controls ensure payroll data is visible only to authorized HR officers. A complete audit log records every data change with user attribution.

Capabilities

Key Features

Full offline-capable operation with automatic cloud sync on reconnect
Automated payroll with configurable deductions, overtime, and advances
Biometric-ready attendance integration with manual override
Leave management with approval workflows and balance tracking
360-degree performance review cycle with KPI tracking
Asset assignment and return tracking per employee
Outcomes

Measurable Results

-45%
HR Admin Time Reduction
99.8%
Payroll Accuracy
-85%
Payroll Cycle Duration
8 weeks
Build Timeline
Engineering

Tech Stack

Frontend / UI
React 18 · Tailwind CSS (Electron Renderer)
Backend / API
Node.js · Express.js (Electron Main)
Database / ORM
SQLite (Local) · PostgreSQL via Supabase (Cloud Sync)
Authentication
Supabase Auth (Role-Based)
Hosting / Deployment
Electron-builder MSI · Auto-updater
Tools & Integrations
Resend (Payslip Emails)Novu (Leave Approval Alerts)
Value Delivered

Client Benefits

Payroll calculation time dropped from 4 days to 6 hours per cycle
Employee disputes from payroll errors eliminated in the first month
Full offline functionality for factory-floor branches with cloud sync
Audit trail enabled compliance reporting for the first time
Ready to Scale?

Let's Build Together

Want a similar solution tailored to your business? Let's talk. Our engineers will walk you through the architecture, timeline, and investment — no fluff, no sales pitch.

💬 Chat with us on WhatsApp