LUISHERNÁNDEZ

Full-stack developer & IT lead

Querétaro · UTC-6

I build the systems I operate.

Most IT managers buy their tools. I write the ones my department runs on, and answer for their uptime on the same report.

Get in touch

Selected work06 projects1,050 automated tests93% response SLA100% availabilityNext.js · TypeScript · PostgreSQLQuerétaro, MX

Role

Sole author
Architecture
Product owner

Stack

Next.js 15
React 19
TypeScript
Supabase
PostgreSQL

Launch

2026
In production

Numbers

160 tests
19 RLS policies
23 routes
5 CI stages

ti-hub.internal

160

tests

RLS policies

routes

01In production

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.
Internal system
Attendance
Time clock for home-office staff with no application server: every business rule lives in PostgreSQL, punches are append-only and the client holds no write privilege on any table.
Internal platform
Maintenance portal
Work orders with assignment, log, per-machine history and statistics, scoped across five sites including customer-site service centres at BRP, Hella and Faurecia.
E-commerce
B2B Marketplace
Recycled-plastics commerce with direct purchase and RFQ. Selling to invited customers since 1 September 2026, multi-vendor in production since 15 September.
Open source
MeetScribe
Real-time meeting transcription and minutes, fully local on Windows: dual-track WASAPI capture, CPU Whisper and on-device diarisation.
Browser extension
Password Vault
Local password manager for Chrome and Edge. Envelope encryption with AES-256-GCM and scrypt derivation at twice the OWASP minimum; keys live only in the service worker.

Selected work

01/06

Scroll, arrow keys or the buttons

Selected work

ti-hub.internal
160
tests
19
RLS policies
23
routes
01In production
Internal platform
01/06
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.
- 160 tests
- 19 RLS policies
- 23 routes
- 5 CI stages
Open
attendance.internal
345
SQL assertions
27
migrations
12,990
lines of SQL
02In production
Internal system
02/06
Attendance
Time clock for home-office staff with no application server: every business rule lives in PostgreSQL, punches are append-only and the client holds no write privilege on any table.
- 345 SQL assertions
- 27 migrations
- 12,990 lines of SQL
- 0 app servers
Open
maintenance.internal
5
sites
3
customer-site centres
PWA
installable
03In production
Internal platform
03/06
Maintenance portal
Work orders with assignment, log, per-machine history and statistics, scoped across five sites including customer-site service centres at BRP, Hella and Faurecia.
- 5 sites
- 3 customer-site centres
- PWA installable
Open
marketplace.internal
100%
prices derived server-side
0
client write privileges
04Live, multi-vendor
E-commerce
04/06
B2B Marketplace
Recycled-plastics commerce with direct purchase and RFQ. Selling to invited customers since 1 September 2026, multi-vendor in production since 15 September.
- 100% prices derived server-side
- 0 client write privileges
Open
meetscribe.internal
329
tests
2
audio tracks
0
bytes leave the machine
05MIT licence
Open source
05/06
MeetScribe
Real-time meeting transcription and minutes, fully local on Windows: dual-track WASAPI capture, CPU Whisper and on-device diarisation.
- 329 tests
- 2 audio tracks
- 0 bytes leave the machine
Open
password-vault.internal
216
tests
2×
OWASP scrypt minimum
06Chrome & Edge
Browser extension
06/06
Password Vault
Local password manager for Chrome and Edge. Envelope encryption with AES-256-GCM and scrypt derivation at twice the OWASP minimum; keys live only in the service worker.
- 216 tests
- 2× OWASP scrypt minimum
Open

Come say hi

Credits

LUISHERNÁNDEZ