Jared Mahotiere

workflow-orchestrator

TypeScript | Node.js | Redis Streams | PostgreSQL | AWS ECS

Distributed workflow engine with DAG validation, Redis Streams dispatch, durable Postgres run/task state, idempotent retries, and dead-letter handling.

• Benchmarked at 25/25 successful runs in 15.94s (1.57 runs/s).
• AWS deployment validated on ECS Fargate with ALB, RDS, and ElastiCache, then deprovisioned to manage cost.
• Includes deterministic demo seeding and reproducible deploy/teardown scripts.

IoT Streaming ETL Pipeline

Apache Kafka | PySpark | Airflow | Great Expectations | Terraform | AWS

Streaming ETL pipeline processing 100+ events/sec using Kafka and Spark Structured Streaming.

• Implements Bronze/Silver/Gold architecture, checkpointed recovery, and validation via Great Expectations.
• Prometheus/Grafana observability with production-style metrics and alert coverage.
• Infrastructure provisioned with Terraform on AWS (MSK, S3, VPC, ECR); currently deprovisioned to manage cost.

Retail Sales Forecasting Dashboard

Python | FastAPI | XGBoost | AWS ECS | Terraform | SQL

End-to-end ML forecasting platform deployed on AWS ECS Fargate.

• Achieved XGBoost R² = 0.91 and ~11% MAPE with production-oriented evaluation.
• Backed by FastAPI inference, Streamlit UI, and Terraform-managed infrastructure.
• Active live deployment with endpoint and health verification.

Feature Flag Platform

TypeScript | Node.js | React | PostgreSQL | Redis | AWS ECS | Terraform

Multi-tenant feature flag control plane with deterministic rollout targeting, RBAC, idempotent writes, and publish/rollback workflows.

• Deployment was validated on AWS ECS Fargate behind ALB with RDS Postgres and ElastiCache Redis.
• Currently deprovisioned to manage cost; reproducible with Terraform and deployment scripts.

cachekit

C (C11) | POSIX | TCP | RESP

Built a Redis-like in-memory cache server in C with a select-loop TCP engine; benchmark harness runs 10,000 SET/GET pairs per trial.

• Implemented Robin Hood hashing + approximate LRU eviction with O(1) average key access.
• Added TTL expiration, RESP command parsing, and RDB snapshot load/save with ASan + Valgrind CI coverage.

Help Westmoreland

Next.js 16 | React 19 | TypeScript | Tailwind v4

Shipped production disaster-relief platform with 3 intake flows (contact/volunteer/partner), donation integration, and accessibility-first UX.

• Implemented Donorbox + Formspree workflow plumbing and GA4 event instrumentation.
• Built SEO baseline with JSON-LD, sitemap/robots automation, and Open Graph/Twitter cards.

syncboard

Next.js 15 | Socket.io | PostgreSQL | Prisma | NextAuth

Built real-time collaborative Kanban with optimistic UI + Socket.IO sync for 4 mutation paths (create/move/update/delete).

• Implemented reconnect/offline handling, presence heartbeat tracking, and last-write-wins conflict merge logic.
• Delivered REST endpoints with Zod validation on a Next.js + Prisma/Postgres + NextAuth stack.

Telemetry Node

ESP32 | FreeRTOS | C | Python

Built ESP32 telemetry logger streaming 25-byte UART frames (20-byte payload + CRC16) for 9 sensor fields with Python CSV decode tooling.

• Implemented fixed-rate FreeRTOS sampling for MPU6050 accel/gyro plus temperature and battery channels.
• Added deterministic protocol fixtures and CI checks for firmware build + host decoder validation.

Retail Forecast Dashboard

Status: Live | Verified: Mar 2, 2026

ECS Fargate service behind ALB with Terraform-managed AWS infrastructure.

• Endpoint checks: /, /docs, and /api/health returned HTTP 200.
• Stack: ECS, ALB, ECR, CloudWatch, Terraform.

Feature Flag Platform

Status: Deprovisioned | Last Verified: Feb 19, 2026

Control-plane API and admin UI were validated on ECS Fargate with managed data stores.

• Historical checks: /api/health, /api/flags, and /api/tenants/tenant-a/quotas returned HTTP 200.
• Stack: ECS, ALB, RDS Postgres, ElastiCache Redis, ECR, Terraform.
• Deprovisioned after verification to manage cost; redeploy is scripted.

Workflow Orchestrator

Status: Deprovisioned | Last Verified: Feb 19, 2026

API, worker, and UI services were validated on ECS Fargate behind ALB.

• Historical checks: /api/health and /api/workflows returned HTTP 200; seed create/trigger flow succeeded.
• Stack: ECS, ALB, RDS Postgres, ElastiCache Redis, ECR, Terraform.
• Deprovisioned after verification to manage cost; redeploy is scripted.

Streaming ETL Pipeline

Status: Deprovisioned | Last Verified: Feb 19, 2026

Core infrastructure and shell path were validated; full managed services remain entitlement-gated.

• Core mode scope: MSK, S3 medallion buckets, VPC, ECR.
• Historical check: shell path on ECS Fargate + ALB returned HTTP 200.
• Full mode: EMR/MWAA/Redshift pending account service subscription enablement.
• Deprovisioned after verification to manage cost; redeploy is scripted.

PicoClaw - Open Source Contributor (PR #213)

Go | Provider Architecture | +1,798/-774 | State: Merged

Merged provider protocol-family refactor with compatibility adapters, shared protocol typing, and expanded auth/routing test coverage across 11 files.

PicoClaw - Open Source Contributor (PR #56)

Go | OAuth Device Flow | State: Merged

Merged device-code auth interval parsing fix for string/integer polling values with targeted regression tests.

PicoClaw - Open Source Contributor (PR #211)

Go | Security Hardening | +204/-27 | State: Closed

Active follow-up contribution focused on security hardening and CI reliability improvements; related Telegram handling updates are also under review in PR #251.

bloomberg/comdb2 (PR #5743)

C/C++/SQL | SQLite Security Backports | State: Open

Backported targeted SQLite security fixes for issue #3904 with source-build validation, full harness runs, and a published verification matrix tied to reproducible test IDs.

bloomberg/comdb2 (PR #5731)

Java | JDBC Metadata | State: Open

Preserved active metadata result-set cursors by isolating version lookup from getTables() flow, preventing iterator invalidation during JDBC metadata access.

sipeed/picoclaw (PR #251)

Go | Telegram Channel Reliability | +1,115/-88 | State: Closed

Fixed Telegram send failures for oversized outputs by chunking outbound messages, preserving placeholder-edit sequencing, and adding HTML/plain-text fallback tests for long payloads.

databricks/cli (PR #4504)

Go | Root Auth Resolution | State: Open

Fixed non-bundle auth resolution so workspace commands no longer implicitly load bundle default targets; preserved explicit bundle behavior via --target and added regression tests.

databricks/databricks-sdk-py (PR #1258)

Python | SDK Config Internals | State: Open

Fixed Config subclass attribute discovery and caching so inherited ConfigAttribute fields resolve consistently, with regression coverage for inheritance paths.

google/langextract (PR #359)

Python | Gemini Batch Cache | State: Merged

Stabilized cache-key hashing by supporting Enum and dataclass serialization in request signatures, removing a crash path in batch processing.