Tech LeapLLC

Work

What this has looked like

Every figure here is from a production system, across federal health, defense, aerospace, energy, payer and geospatial environments.

8h → 2h

Rebuilt a nightly full-load procedure as a true incremental MERGE with change detection and structured logging.

Federal health agency

9.2B rows

Designed and executed an archive purge cutting roughly 96% of retained volume, averting filegroup saturation on a system days from failing its writes.

Federal health agency

2.5×

Caught a join fan-out silently inflating a curated dataset that fed a production prediction model, then corrected the upstream logic.

Global aerospace manufacturer

Every run

Traced a model's quietly degrading accuracy to vector metadata written to ephemeral storage, forcing a full index re-fit on every single run and drifting the embedding space underneath it.

Global aerospace manufacturer

51 tables

Built parameterized data-quality automation covering seven pipeline families, wired across 17 orchestration tasks in restricted environments.

Defense analytics platform

3 datasets

Root-caused a type promotion that had silently widened integer quantity fields across three production datasets, tracing it to placeholder casting in a shared transformation service.

Defense analytics platform

12 → 3

Consolidated legacy scheduled jobs into orchestrated workflow chains ahead of a platform-wide governance migration.

Defense analytics platform

Multi-year

Recovered a pharmacy-benefit data backlog by exposing hardcoded date filters, a parallel-execution race condition, and a recursive delete hazard producing silent zero-record loads.

Regional health plan

Semantic search

Connected LLM embeddings to a PostgreSQL vector store with HNSW indexing, enabling hybrid retrieval across work-management and equipment data for an operations AI assistant.

National energy operator

FHIR R4

Delivered outbound interoperability moving encrypted, standards-compliant payer data to a national interoperability platform on a daily orchestrated schedule.

Regional health plan

98.6%

Workflow efficiency gain from a full-stack geospatial application, recognized with an agency award.

Federal geospatial agency

Spatial ETL

Built enterprise pipelines reconciling point-of-interest, address, boundary and imagery datasets, with distributed processing for volumes past single-machine scale.

Federal geospatial agency

Tell me what's broken.

A short description of the platform and what isn't behaving is enough to start. I'll tell you within a day whether it's something I can help with.