// portfolio

William Allen Mabery

AI Infrastructure Architect  |  Systems Thinker

"I build systems that work in production, not just demos."

Production Projects

screenshot placeholder

BSG Marketing Command Center

Live

Enterprise marketing platform built in 48 hours. AI-powered campaign orchestration across a 500K+ member database, with a journey builder, multi-tenant provisioning, and an MCP server for direct external agent access.

  • RBAC with 4 distinct permission roles
  • AI engine toggle — Cortex, Claude, or Bedrock at runtime
  • 6 pre-built journey templates, real-time analytics dashboard
  • Event ingestion webhooks for external CRM data
  • MCP server exposing campaign primitives to AI agents
FastAPI Next.js 16 DuckDB Snowflake Claude API Snowflake Cortex AWS S3 Secrets Manager EC2
screenshot placeholder

S3-Snowflake Automated Loader

Open Source

Event-driven ETL pipeline that turns S3 into a self-routing data lake. Drop a file in S3 — it lands in the right Snowflake table automatically. Convention over configuration: folder structure determines routing, schema, and destination database.

  • Automatic schema detection and table creation on first load
  • PGP decryption for sensitive files in transit
  • Multi-database isolation for tenant separation
  • Centralized audit logging for every load event
  • Zero-touch deployment via CloudFormation
AWS Lambda S3 Snowflake CloudFormation Python
screenshot placeholder

PickyBatAds

Live

AI-powered video advertising platform with real video generation, end-to-end campaign management, and live Stripe billing. Built to validate a product hypothesis from zero to production in a single sprint.

  • Real video generation via Sora API integration
  • Live payment processing (Stripe)
  • Cohort-based audience targeting engine
  • Async job queue (Celery + Redis) for video rendering
  • Containerised, Docker-based production deployment
FastAPI Next.js Sora API Stripe PostgreSQL Redis Celery Docker
screenshot placeholder

Night Architecture

Newsletter & Podcast

Technical newsletter and podcast exploring AI consciousness, multi-agent systems, and the future of human-AI collaboration. 50+ episodes. Essays that synthesise research across computer science, philosophy, and systems thinking.

  • 50+ podcast episodes published
  • Cross-domain research synthesis — AI, philosophy, architecture
  • Covers multi-agent coordination, emergent behaviour, and LLM internals
  • Independent publication, no institutional backing
Substack Podcast Essays AI Research
screenshot placeholder

OpenClaw — Open Source Contributions

OSS

Production contributions to OpenClaw open-source AI agent infrastructure. Originally built an autonomous multi-agent system (Forgekeeper) that accumulated 1,184+ commits before being migrated into the OpenClaw ecosystem.

  • PR #19235: stream management fixes for production Telegram deployment
  • Built autonomous multi-agent system (Forgekeeper) with 1,184+ commits
  • Migrated personal agent infrastructure to open-source OpenClaw
  • Contributed production-grade stream handling and stability patches
Python Multi-Agent Systems Telegram API Stream Management Open Source

Technical Skills

AI & ML

  • Multi-agent systems design
  • LLM pipeline architecture
  • Snowflake Cortex
  • Model Context Protocol (MCP)
  • Prompt engineering & evaluation
  • Claude, GPT-4o, Bedrock integration

Cloud & Infrastructure

  • AWS (Lambda, S3, EC2, RDS, SQS, Secrets Manager)
  • Google Cloud Platform
  • Docker & container orchestration
  • Kubernetes
  • Terraform
  • CloudFormation

Data Engineering

  • Snowflake (architecture, Cortex, Streams)
  • DuckDB
  • PostgreSQL & SQL Server
  • ETL pipeline design
  • Data lake architecture
  • Event-driven ingestion

Languages

  • Python
  • TypeScript / JavaScript
  • SQL
  • C#
  • Bash / Shell scripting