AI Pipeline & Automation Engineer with 15+ years delivering mission-critical
data solutions for US Navy, USMC, and federal programs. Active Top Secret clearance. Navy veteran.
Currently building production AI pipelines at an AEC-focused startup — integrating local LLMs,
n8n workflow orchestration, and containerized infrastructure (Docker, PostgreSQL) to automate
competitive intelligence workflows. I communicate clearly, document thoroughly, and thrive in
self-directed problem solving for federal and commercial environments.
Microsoft 365 • SharePoint • Teams • Graph API • OAuth2 / Azure AD
Power BI (DAX, M) • SQL Server / T-SQL • Excel VBA • Requirements Analysis
Projects
Production AI Competitive Intelligence Pipeline
AI Pipeline & Automation Engineer
End-to-end competitive intelligence pipeline for an AEC-focused startup — ingesting RSS, YouTube,
and podcast content, processing 500+ documents weekly through a local LLM
(Ollama/Llama 3.1) for relevance scoring, entity extraction, and semantic clustering.
Delivered automatically to SharePoint and Microsoft Teams via Graph API.
500+
15+
0
Autyvia AEC Intelligence Pipeline
Designed and deployed production pipeline ingesting RSS, YouTube, and podcast sources through Ollama/Llama 3.1 for relevance scoring and entity extraction
Built semantic clustering pipeline using pgvector embeddings to automatically group content by topic, eliminating a flood source diluting content quality
Architected 15+ n8n automation workflows spanning ingestion, LLM processing, deduplication, and automated delivery to SharePoint and Microsoft Teams via Graph API
Designed config-driven Python scraper pipeline to expand sourcing beyond RSS feeds
Migrated production pipeline from MongoDB to PostgreSQL — schema design, backfill workflows, dual-write transition with zero data loss
Designed LLM input sanitization layer and least-privilege OAuth2 credential architecture across Microsoft 365 integrations
Python-driven NLP/ML platform that matched 4,000+ requirements to test cases for a federal modernization program,
cutting validation from 3–4 months to < 2 hours (≈ 98% time reduction).
633+
75–85%
50%
Intelligent Requirements-to-Test Case Matching System
Adaptive learning with domain acronym harvesting (633+ terms)
Cross-product knowledge transfer saving 40+ hours per product family
Links: Classified government project (no public docs).
PythonNLPMLText AnalyticsJaccardData Engineering
Executive Metrics Dashboard with Advanced Analytics
BI Developer & Data Analyst
Executive dashboards with quad-chart slicers and 15 KPIs. Integrated data from
13 formats via Power Query ETL, increasing reporting metrics by 496% and
visual elements by 389%.
87%
94%
98.2%
Power BI Performance Management Dashboard
Interactive quad-chart dashboard with drill-down capabilities
DAX measures for complex metric calculations
Automated ETL aggregating 13+ data source types
496% increase in functional test metrics; 389% more visual elements
Clean, normalized data models ensuring accuracy and integrity
Links: Government client under NDA.
Power BIDAXPower Query (M)SQL ServerETL
High-Speed Requirements Validation Macro
VBA Developer
Macro validates 1,592 requirements across 471 test cases in
< 1 minute vs 7+ hours manual. RTVM identified a
3.4% coverage gap (62/1,806), enabling 100% verifiable coverage.
<1 min
98.6%
RTVM
Excel VBA Requirements Traceability Automation
Validates 1,592 requirements vs 471 test cases in <1 minute
RTVM revealed 3.4% coverage gap (62 of 1,806) → enabled 100% coverage
Reusable macro framework for ongoing validation cycles
Automated gap detection & quality checks
Links: Federal contract (sensitive data).
Excel VBAAutomationQAData Validation
Enterprise Budget Consolidation System
Database Developer & Solution Architect
Consolidated $628M across 600+ accounts from siloed Excel files into a unified
SQL Server / MS Access system. Regex-driven parsing & VBA procedures enabled rapid reconciliation and
executive visibility, reducing manual work by 75%.
$628M
600+
75%
SQL Server / MS Access Financial Management Database
Consolidated $628M across 600+ accounts into a unified platform
MS Access front-end with SharePoint 2010 back-end providing real-time tracking and query reporting for
170M+ data points across depots. VBA ETL imports heterogeneous Excel feeds, automates discrepancy analysis,
and accelerates processing by 65%.
170M+
24/7
65%
SharePoint-Integrated Tactical Vehicle Tracking System
Real-time tracking for 170M+ data points across depots
VBA-driven ETL importing from multiple disparate sources
Dynamic discrepancy identification and resolution workflows