DATA PLATFORM
Diversified Gas & Oil
Corporate Historian — OT Data Platform
Lead engineer on the central operational data warehouse. TimescaleDB with 15 schemas, 77 tables, 114 PL/pgSQL functions managing 1.6M+ daily production records. Star-schema with effective-dated dimensions, hypertables, continuous aggregates. ETL from CygNet SCADA, Snowflake, MNR; outbound to Grafana, regulatory reporting, volume control. Embedded pgai with OpenAI / Anthropic / Cohere / Voyage for automated issue detection over operator free-text and semantic search across historical observations.
1.6M+records / day
114pl/pgsql functions
15 / 77schemas / tables
TimescaleDBPL/pgSQLpgaiPythonCygNetSnowflake
ML PLATFORM
Diversified Gas & Oil
Historian ML — Industrial Anomaly Detection
ML platform over 186M+ telemetry observations. Pattern-detection engine covering 8 categories of industrial sensor failure. Isolation Forest for unsupervised anomaly detection, Random Forest for pattern classification, LSTM for sensor-level time-series forecasting. Packaged as an AWS CDK stack (SageMaker, S3, IAM, Secrets Manager, CloudWatch) with a 580-line handoff runbook.
186M+observations
8failure categories
3model architectures
SageMakerCDKPythonIsolation ForestLSTM
DEVOPS
Diversified Gas & Oil
Hybrid DB Migration CI/CD
5-stage Azure DevOps pipeline on a self-hosted Windows agent: validates, classifies, approves, executes, documents every schema change. Pattern-based SQL risk classifier (BLOCKED / HIGH / MEDIUM / LOW) over ~30 regex patterns. DROP TABLE foreign-key safeguard. Transactional execution with auto-rollback. Git-based state tracking, nightly drift detection, SOX-aligned audit logging.
5pipeline stages
~30risk patterns
SOXaudit-aligned
Azure DevOpsPowerShellPostgreSQLgit
AI SYSTEMS
That Simple Tech
Autonomous AI Agency Platform
10-agent system handling the full client lifecycle — intake, sales, scoping, build, QA, deploy, support, billing, comms, phone — across 8 project types (websites, web & mobile apps, IT setup & support, AI automation, cloud infra, consulting). MiniMax M2.7 primary across roles (100% tool calling, ~3.3× cheaper, ~2.5× faster than the Claude API path); Gemini 3 Flash Preview for visual QA. Voice via Pipecat + Telnyx + Deepgram Nova; agents execute inside Cua sandboxes. SvelteKit client portal on Vercel with a unified revision queue (portal / email / SMS / phone), SSE updates, S3 assets. Harness: Qwen Code on OpenRouter.
10specialized agents
8project types
~15×cost reduction target
MiniMax M2.7Gemini 3 FlashOpenRouterQwen CodePipecatTelnyxDeepgram NovaCuaSvelteKitStripeRedis + CeleryMCP
AI AT SCALE
Delta Air Lines
Reporting Modernization — SCRD / ESR / MPR v2
Architected and shipped a JSON-first v2 replacement for three legacy operational scorecards (SCRD, ESR, MPR) at Delta — SCRD alone processing ~2,300 organizational entities per monthly close. Python packagers run against Teradata, wired into a Step Functions parallel branch with DynamoDB caching and an S3-backed registry; renderer collapsed from per-report PPTX/HTML templates to a single vanilla-JS viewer (Chart.js, CSS custom properties, no build pipeline). AWS Bedrock (Claude Haiku 4.5) generates auto-narratives and per-KPI explanations served via /api/v1/kpi-explain on API Gateway + Lambda, with schema validation, source-data grounding, and content-keyed DynamoDB caching. Closed seven latent defects in the legacy code en route — including an eval()-based templating injection and swapped year/month columns. Delivered phases 0–3 inside a restrictive delegate-admin- IAM boundary plus a Lambda-creation SCP, deploying AI compute as a Glue Python-shell job to ship without an architecture exception.
~2.3kentities / closeout
7legacy defects closed
13engineering docs · phases 0–3
AWS BedrockClaude Haiku 4.5Step FunctionsDynamoDBGlue (Python shell)LambdaAPI GatewayS3TeradataChart.js
MOBILE
Diversified Gas & Oil
Field App — Offline-First Tank Inspections
Ionic 8 + Angular 20 + Capacitor app replacing paper-based tank inspections. Single codebase deploys as native iOS / Android and installable PWA. Offline-first on Dexie / IndexedDB with master-data caching and a write-queue for user-generated content; sync resolves conflicts on reconnect. AWS Amplify backend with AppSync GraphQL, DynamoDB, Cognito brokered with Azure AD via MSAL.
3targets, 1 codebase
Offlinefirst by design
SSOCognito ↔ Azure AD
Ionic 8Angular 20CapacitorDexieAppSyncCognito