Data architect · Applied-AI developer

NASA Glenn · 2018–2025M.S. · UC Berkeley175+ citations · h-index 52023 GITEC Award

Capabilities

Enterprise data

Architecture & governance

A FAIR-aligned data-governance framework across NASA Glenn's Aerosciences Evaluation & Test Capabilities. Enterprise databases on PostgreSQL, Oracle, and SQL Server across a 30+ year data career. Team member on the 2023 GITEC Emerging Technology Award.

Applied AI

LLM systems that ship

Author of MCP servers that expose data to LLMs, RAG / natural-language search(GPT-4o-mini, Qwen 2.5 via Ollama, ChromaDB), and production text-to-speech pipelines — running in production, not prototypes.

Full-stack delivery

From schema to shipped

End-to-end product builds in Next.js / TypeScript / Drizzle, Django, and Rails — with Stripe, Auth.js, and deploys to Vercel and self-hosted VPS. Four products live in production today.

Products in production

Four exam-prep and training platforms I designed, built, and operate — each with its own domain, content pipeline, and infrastructure. The two veterinary products are co-built with Laura Krogman, DVM.

ProductFeatures
CPT Prepcpt-prep-academy.comFitness-certification exam prep across six certifications — ACE, ACSM, ISSA/NCCPT, NASM, NSCA-CPT, and NSCA-CSCS. Expert-written lessons, adaptive quizzes, and domain-weighted practice exams; 5,500+ practice questions.
Breaking Into Vet Medbreakingintovetmed.comA self-paced course that takes career-changers from "I want to work with animals" to hired as a veterinary assistant — 13 modules, a capstone, and a job-search toolkit.
PracticeReadypracticeready.healthThe B2B side of the same engine: clinics onboard new veterinary assistants with DVM-authored coursework — 14 hours of audio-guided lessons so a new hire arrives clinic-ready.
ExamToLicenseexamtolicense.comPSI exam prep for Ohio contractor licensing— both the HVAC and Business & Law exams. Ohio-specific code references, open-book strategy, and adaptive practice quizzes; 561+ questions.

Selected engagements

Paid client engagement · deliveredCanadian real-estate data platform

Mapping and modernizing a production real-estate data platform

Audited a live AWS data platform end-to-end, reverse-engineered its ETL and search path, and delivered a tiered set of client reports — the same findings written three ways for three readers, from decision-maker to engineer.

  • Mapped a production AWS platform: 19 EC2 instances, 5 RDS PostgreSQL clusters, 8 Lambdas, and S3 across legacy and modern accounts.
  • Documented a strangler-fig migration from monolithic cron/EC2 ETL to Python microservices on ECS/Fargate + Airflow.
  • Built a BigQuery → PostgreSQL fact-loading pipeline (partitioned queries, service-account auth) into the production event tables.
  • Ran a Solr search-gap analysis — 34 concepts not reaching the index across 18 MLS feed sources — and traced it to code logic, not missing data.
  • Unified 186 attributes from 2,962 raw feed rows into a canonical schema, with a field catalog and rollout options ranked by effort and risk.
  • Shipped an MCP server exposing property search to LLMs, plus a natural-language search app on the same index.
Schema lineage: source fields from every MLS feed mapping into one canonical attribute
One attribute's lineage — every source field across a dozen MLS feeds resolving to a single canonical value. All 186 attributes were unified this way.
5
RDS Postgres clusters mapped
186 → 1
attributes into a canonical schema
3×
reader-tiered deliverables
MCP
property search for LLMs

AWS (EC2 · RDS · Lambda · ECS/Fargate · Airflow · S3) · PostgreSQL · Google BigQuery · Solr / Sunspot · Rails · Python · MCP

Applied AI

MCP & natural-language search

MCP servers that hand structured data to LLMs, and NL search that blends hosted and local models.

  • Property-search & Gmail MCP servers (JSON-RPC / stdio).
  • GPT-4o-mini function-calling + Qwen 2.5 via Ollama.
  • ChromaDB embeddings and re-ranking.
  • Production ElevenLabs TTS content pipelines.
Full-stack range

Instrumented, local-first tools

Small, sharp builds that show breadth across data and interface.

  • Oura health dashboard — FastMCP + pyarrow + Recharts, VPS-deployed.
  • Voice-driven inventory PWA — Turso (libSQL) cloud sync on Vercel.
  • QA test-tracker — Next.js + Drizzle, versioned YAML plans.
  • Gmail automation — 262 filters audited, quota-safe daily cleanup.

Career timeline

1970s

M.S., Wildland Resource Science — UC Berkeley

Under A. Starker Leopold. Resolved a 50-year taxonomic dispute over the tule goose using punch-card computer cluster analysis, PCA, and discriminant functions on 16 morphometric characters — two sole-authored papers.

1976 — 1984

Arctic Research Scientist — NOAA / NMFS

Designed and led ice-based census operations for the bowhead whale migration past Point Barrow, Alaska, and built the multinomial population models that became foundational Arctic survey methods. Presented census research to the International Whaling Commission Scientific Committee (Cambridge, UK).

Appeared in the PBS NOVA episode "Umealit: The Whale Hunters" (1980).

1980 — 2018

Enterprise data architecture

VP and co-owner of Analytical Software Inc. — grown to 40 staff and $4M+/yr — then enterprise database architecture at HomeGrocer.com, Onvia, and a decade of Seattle consulting. The data career that connects the science to NASA.

2018 — 2025

Data Architect — NASA Glenn Research Center

Built a center-wide data-governance framework aligned with FAIR principles across the Aerosciences Evaluation & Test Capabilities portfolio. Enterprise databases on SQL Server, Oracle, and PostgreSQL; BI in Power BI and Tableau. Team member on the 2023 GITEC Emerging Technology Award.

2025 — now

Independent Consultant — AI & Data Strategy

Applied AI, data architecture, and AI-augmented product development — building and operating the products above, most notably the veterinary-assistant training platform built with Laura Krogman, DVM.

Skills

›Data & cloud

PostgreSQLOracleSQL ServerGoogle BigQuerySQLite / TursoAWSAzureSolr / SunspotElasticsearchSSIS · SSRSAirflow

›AI & LLM

MCP serversRAG / NL searchGPT-4o-miniQwen 2.5 · OllamaChromaDBElevenLabs TTSPrompt engineeringscikit-learnKNIME

›Full-stack & delivery

Next.jsTypeScriptDrizzle ORMAuth.jsDjango · HTMXPython · FastAPIRailsStripeVercelHetzner · Docker

›Governance & foundations

FAIR data governanceData modeling · ErwinPower BI · TableauMultivariate analysisMIT Applied Data Science (2022)PMPOracle DBA

Published research

Peer-reviewed work in population statistics and quantitative taxonomy — 175+ citations, h-index 5. The methodological roots of everything above.

1975
A Morphometric Study of the White-fronted Geese Wintering in California
Krogman (sole) · M.S. thesis, Wildland Resource Science · University of California, Berkeley (advisor: A. Starker Leopold)
1979
A systematic study of Anser albifrons in California
Krogman (sole) · in Management & Biology of Pacific Flyway Geese, pp. 22–43
1979
Sexual Behavior of Bowhead Whales Observed Off the North Coast of Alaska
Everitt & Krogman · Arctic 32(3): 277–280
1986
A Multinomial Model for Estimating the Size of a Whale Population from Incomplete Census Data
Zeh, Ko, Krogman & Sonntag · Biometrics 42(1): 1–14
1989
Ice-Based Census of Bowhead Whales Migrating Past Point Barrow, Alaska, 1978–1983
Krogman, Rugh, Sonntag, Zeh & Ko · Marine Mammal Science 5(2): 116–138 — first author

Plus ~45 publications, technical reports, and IWC / North Slope Borough working papers across the career.