Jack Lopez
← Back to Work
AngularNode.jsPostgreSQLDefense

SAIC

Technical Lead

Architecture

Angular 17MyTraining UINode.js Service ATraining RecordsNode.js Service BUser ManagementPostgreSQLNormalized DBAir Force10,000+ UsersWCAG AA · a11yMicroservices20% Perf Gain

The Problem

The Air Force MyTraining platform was struggling under the weight of a poorly normalized database and a tightly coupled monolith. With 10,000+ active users, performance degradation and scaling bottlenecks were becoming mission risks.

What I Built

  • Led a phased migration to a microservices architecture using Node.js, separating training records, user management, and scheduling concerns

  • Redesigned the PostgreSQL schema — normalizing the database and eliminating the N+1 query patterns causing 20%+ performance degradation

  • Enforced WCAG AA accessibility compliance across all Angular UI components

  • Mentored five engineers, running design reviews, pairing sessions, and introducing pull request standards that improved code quality measurably

Outcomes

01

20% application performance improvement via database normalization and query optimization

02

Full WCAG AA compliance — accessibility verified across all 10,000+ user-facing screens

03

On-time delivery for all major milestones on a mission-critical Air Force program

What they said

Jack made a tremendous impact in a short time by improving processes and providing structure to our workflows. His ability to communicate complex technical concepts to both technical and non-technical stakeholders has been invaluable.

David Little

Product Lead · SAIC

WORKING ON SOMETHING SIMILAR?

I'd like to hear about the problem you're trying to solve.

Get in touch →