/01
AI & GenAI
Production GenAI for enterprises — Anthropic Claude, Snowflake Cortex Code, RAG over governed data, agentic workflows. Row-access enforced, citations grounded, evals run before promotion.
// current exampleCortex Code AI workflow auto-generating & optimizing stored procedures across the team.
/02
Real-time platforms
AWS-native streaming: Kinesis, Apache Flink, ECS Fargate, NLB → Snowpipe Streaming into Snowflake. Sub-second visibility, sub-300ms p99 latency. Predictable behaviour at scale.
// current exampleDevice platform: 300K+ devices at ~83 TPS, replacing a 25K-line legacy C++/Oracle stack at −83% cost.
/03
Cost & token budgeting
FinOps for both compute and AI tokens. Per-tenant warehouse routing, query tagging, auto-suspend. AI workspace token caps, prompt caching, model routing (cheap-first → escalate to Claude Opus).
// current exampleWarehouse FinOps control plane — typical 40-85% Snowflake credit reduction.
/04
MCP servers & RAG
MCP servers giving Claude, Cursor, downstream agents governed access — Snowflake queries, audit history, design docs. Separate RAG indexes per domain with hybrid retrieval & citation grounding.
// current example6 MCP servers in production bridging Claude to a governed Snowflake estate. 4M+ docs indexed.
/05
Platform modernization
Migrating legacy SQL Server, MySQL, DB2, Oracle, Netezza, Redshift estates into Snowflake. CDC pipelines, Dynamic Tables, Streams, Tasks, SCD1/2, audit + rejection-handling frameworks.
// current example5 migrations across healthcare & retail. +60% query perf on Tableau modernization.
/06
Multi-tenant governance
Collapse 100+ per-customer schemas into governed shared models with row-access policies, dynamic masking, RBAC, PHI/PII protection. Tenant onboarding from weeks to hours.
// current example120 Oracle schemas → 1 governed Snowflake model. CJIS & HIPAA aligned.
/07
Architecture review & ARB
Authoring Technology & Architecture Change Requests (TACR), leading external audit cycles, navigating compliance regimes (HIPAA, CJIS, SOC2). Independent second-opinion on existing designs.
// current exampleLed 4 external AI audit cycles to ~95% legacy parity. ARB TACR shipped.
/08
DevOps for data & AI
Pulumi (Python) for IaC. GitHub Actions for SQL + agent deploys. PR-gated cost regressions. Docker, Jenkins, CloudWatch + Airflow observability. CI/CD that data + AI workloads share.
// current examplePulumi end-to-end stack reproducible from a clean AWS account in < 1 hour.