01/06 · Internal platform
TI Hub
IT service desk with an SLA engine, inventory, maintenance, custody letters and monthly KPI reporting, plus a friction-free portal for any worker to file a report.
In production160
tests
19
RLS policies
23
routes
- 160
tests
- 19
RLS policies
- 23
routes
- 5
CI stages
About the project
The SLA engine tracks per-priority response and resolution targets in clock hours, flags tickets at an 80% due-soon threshold, pauses the clock while a ticket is on hold, and takes runtime overrides from the admin panel instead of hardcoded values.
The monthly KPI report is derived from immutable timestamps with no snapshot tables, so any closed month can be reconstructed: created, responded and resolved cohorts, backlog at close, per-service availability and a six-month trend.
The mail layer was designed for the Microsoft 365 basic-SMTP retirement: three send methods, basic SMTP, Microsoft Graph app-only and interactive OAuth, with credentials stored in the database so the method can change without a redeploy.
Free-tier gaps are covered with purpose-built infrastructure: a daily GPG AES256-encrypted dump published as a 30-day artifact with five verification assertions, plus a daily keepalive against the inactivity pause.