From Excel chaos to a single source of truth

Automated staff identity management that replaced 2 manual operators and one shared spreadsheet.

The Problem

Three people managing staff data in a shared Excel file. No validation, no consistency, no source of truth. Employees who left the company would linger on the intranet townhall and birthday spotlight for months.

Architecture

The Solution

A fully automated pipeline triggered on Excel upload. It validates every row against the data dictionary, cleans the data, upserts records, and handles offboarding — zero manual intervention required.