John Boen

Senior Data & AI Systems Engineer | Data Engineering, AI Automation, GTM Systems, Analytics, Workflow Design

Boen38@gmail.com | Bellevue, WA | LinkedIn | GitHub

Professional Summary

Senior data and AI systems engineer with 30+ years of experience spanning aerospace, enterprise software, digital media, and AI/ML operations. Built data warehouses for Microsoft's largest web properties, designed fault-tolerant infrastructure for internet-scale platforms, and delivered analytics for global travel booking systems. Now applying that foundation of data engineering, pipeline architecture, and quality discipline to AI systems and go-to-market automation. Combines deep SQL Server expertise with modern AI/ML pipeline operations, bridging traditional data engineering and emerging AI workflows.

Experience

Data Modeling Engineer (Contract)

Artech, LLC (Google Core ML)
2022 – 2023
  • Consolidated dozens of ad-hoc data and reporting jobs into a version-controlled, multi-environment pipeline with dependency management, retry logic, and alerting
  • Performed large-scale statistical analyses (Inter-Rater Reliability, skew assessments) to identify similarity clusters across data cohorts
  • Introduced disciplined software-lifecycle practices to the Core ML analytics team, including version control and multi-environment deployment

Senior Database Engineer

Virtuoso Inc.
2014 – 2020
  • Designed stored-procedure interfaces and analytics powering luxury-travel booking platforms serving global travel advisors
  • Led emergency data-repair efforts that restored production accuracy within hours during critical outages
  • Implemented new data and reporting solutions supporting revenue operations and business intelligence

Software Engineer

Demand Media
2009 – 2014
  • Built the data-infrastructure layer for a fault-tolerant internet domain registry managing millions of domains
  • Designed high-availability data systems supporting continuous operations for a large-scale web platform

Senior Software Engineer

Virtuoso Inc. (Contingent Staff)
2008 – 2009
  • Redesigned cruise-market subsystems during enterprise consolidation, improving scalability and feature velocity
  • Rapidly learned complex travel-industry domain and redesigned data architecture for a new business area

Senior Software Engineer

Ripl Corp
2007 – 2008
  • Created data infrastructure enabling predictive analytics for social-media trend detection
  • Built greenfield analytics and data systems in a fast-cycle startup environment

Senior Software Engineer

Getty Images
2004 – 2007
  • Designed database applications powering sales and marketing analytics across global imagery catalogs
  • Built data systems connecting imagery catalog metadata to revenue-driving business decisions

Application Developer → SDE → Database Engineer → Manager

Microsoft Corporation (Volt → Direct Hire)
1995 – 2004
  • Built data warehouses for major web properties including WindowsMedia.com, MSN, Xbox, and subscription services
  • Pioneered reporting environments that became blueprints for later Microsoft web property analytics
  • Drove large-scale projects using pre-release Microsoft technologies, shaping early data platform patterns
  • Managed engineering teams and led cross-divisional data initiatives across WindowsMedia, MSN, Xbox, and subscription divisions

Engineer

Boeing Commercial Airplanes
1991 – 1995
  • Managed change-management and design-coordination processes for commercial aircraft programs
  • Built decision-support and workflow tools serving cross-team engineering coordination
  • Applied CQI/TQM quality principles to engineering workflows — foundational systems thinking that later shaped data quality engineering practices

Project Examples

Short-term exploration projects used to practice architecture patterns, data engineering, and AI integration. Each is open-source with full documentation.

Artemis

Data science platform for optimizing a 13-image calendar from 12,000+ NASA Artemis II photos — framed as constrained portfolio optimization, not top-N ranking.

  • Multi-modal feature store: CLIP vision embeddings (512-dim), sentence-transformer text embeddings, and perceptual metadata clustered via HDBSCAN with weighted fusion
  • Beta-Binomial posterior scoring with exposure weighting, Elo ratings from pairwise votes, and Borda counts from category rankings — fused into a composite score with uncertainty penalties
  • Hungarian algorithm for provably optimal image-to-month assignment with diversity constraints enforced via CLIP cosine similarity

Certification

Multi-provider exam study app supporting 10 certification vendors with a provider-agnostic quiz engine, zero production dependencies, and an Atlas design system.

  • Provider-agnostic core: new vendors plug in by adding JSON data files and a branded HTML page — no shared code changes needed for the engine or scoring
  • Stateless QuizEngine class with pure business logic, no DOM dependency — fully testable with idempotent answer submission and temporal hint tracking
  • Token-first Atlas design system: all visual decisions flow from CSS custom properties with single-attribute dark mode toggle and zero client-side JavaScript

Data Readiness

Regulatory compliance readiness platform covering 12 data regulation frameworks with self-assessment tools, control inventories, and advisory guidance.

  • Hub-and-spoke architecture: hub site discovers topic spokes at build time by scanning sibling directories for site.json manifests validated against a Zod schema
  • Zero client-side JavaScript — navigation uses CSS-only hamburger toggle, status badges are pure data-driven rendering, entire site is static HTML
  • Content collections pattern with four data dimensions (controls, advisory, services, tools) per regulation, enabling type-safe Astro collection queries

JobClass

Labor market analytics platform that ingests federal data (SOC, O*NET, BLS) into a four-layer DuckDB warehouse and serves occupation insights through a pre-rendered static site.

  • Four-layer immutable warehouse (Raw → Staging → Core → Marts) with schema drift detection that blocks publication on unexpected column changes
  • Static site served from GitHub Pages using a fetch() shim that intercepts API calls and redirects to pre-built JSON — full API ergonomics with zero server cost
  • Multi-vintage time-series with CPI-deflated real wages, crosswalk-aware taxonomy evolution, and as-published vs. comparable-history modes

Lessons Hub

Knowledge management system that harvests markdown lessons from multiple GitHub repos into a searchable static site with a RAG chatbot backend.

  • Adapter pattern abstracts LLM and vector operations across four cloud stacks (local Ollama/ChromaDB, AWS Bedrock, Azure OpenAI, GCP Vertex) with lazy SDK imports and mock-friendly testing
  • Seven-rule gap detection identifies corpus weaknesses from retrieval scores, triggering automated GitHub discovery and candidate lesson staging
  • H2-boundary chunking preserves semantic structure (789 chunks from 116 lessons) instead of token-window splitting

SDLC Pipeline

Prompt-driven software development lifecycle that converts product ideas into structured, phased implementation plans executable end-to-end by AI agents.

  • Document-as-state model: all project status lives in markdown task tables with explicit state transitions (Open → Started → Completed/Blocked) — no external tooling required
  • Self-contained phase plans generated by expand stage include schema, imports, and patterns so an implementer can execute holding one file and the codebase
  • Deployed across 6+ projects (resume, data-readiness, SOC 2, GTM Leads) — reproducible and battle-tested

Skills

Data Engineering

MS SQL ServerData ModelingStored ProceduresETL / Data PipelinesData WarehousingPerformance TuningHigh-Availability DesignReporting & AnalyticsData Quality / GovernanceMulti-environment Deployment

AI Engineering

ML Data PipelinesFeature EngineeringLarge Language ModelsAgentic WorkflowsLangChainLocal Model Operations (Ollama)Statistical AnalysisPredictive Analytics InfrastructureAI-Assisted SDLC

GTM Engineering

Revenue / Business Data SystemsOperational ReportingWorkflow AutomationAnalytics for Business IntelligenceCampaign / Marketing AnalyticsPipeline Dependency ManagementData-Driven Decision Support

Process Engineering

Agile / ScrumSix Sigma / CQI / TQMConfiguration ManagementCI/CD PlanningProduction Incident TriageMulti-environment Workflow DesignVersion Control IntegrationSoftware Lifecycle Discipline

Education

Bachelor of Science — Materials Science Engineering

Washington State University
1990

Associate of Arts — General Studies

Walla Walla Community College
1987
Forward Email