Jared Mahotiere

Retail Sales Forecasting Dashboard

Python | scikit-learn | XGBoost | Prophet | Streamlit | FastAPI | AWS ECS | Terraform

End-to-end ML pipeline: raw sales data to production forecasts and actionable customer segments, served via an interactive dashboard on AWS.

• XGBoost model achieving 11% MAPE and R² = 0.91 on 6-week holdout across 1,115 stores.
• K-means segmentation producing 4 actionable store clusters (silhouette > 0.4).
• Interactive 4-page Streamlit dashboard + FastAPI /predict endpoint, deployed on AWS ECS Fargate.

IoT Streaming ETL Pipeline

PySpark | Kafka | Airflow | Redshift | Great Expectations | Prometheus | Grafana | Terraform

Production-grade data engineering: 100+ events/sec from simulated sensors through Kafka, Spark, and a medallion data lake to a Redshift warehouse with full observability.

• 100+ events/sec Kafka ingestion with PySpark Structured Streaming (10-min watermark, dead-letter queue).
• Medallion data lake (Bronze/Silver/Gold) with z-score anomaly detection and data lineage tracking.
• Airflow orchestration with SLA monitoring; Grafana dashboard with 11 panels and 7 alert rules.

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.

workflow-orchestrator

TypeScript | Node.js | Postgres | Redis Streams | React

Built distributed workflow orchestration with lease/heartbeat recovery; benchmarked 25 runs in 15.94s (1.57 runs/s) with 0 failures.

• Implemented DAG validation, Redis Streams consumer groups, and Postgres durable run/task state.
• Added retry/backoff, dead-letter routing, and idempotency-key dedupe for reliability hardening.

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.

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.

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.

Feature Flag Platform

TypeScript | Node.js | Redis | React

SLO-driven multi-tenant feature flag platform with deterministic rule and percentage rollout evaluation, JS SDK with local cache, and admin UI.

• Implemented idempotency middleware, RBAC, tenant quota controls, and audit logging.
• Built load-test harness, operations docs, and live end-to-end smoke test suite.

sipeed/picoclaw (PR #213)

Go | Provider Architecture | +1,791/-770 | State: Open

Refactored providers by protocol family and completed review-requested hardening: shared protocol types, Anthropic api_base propagation, compatibility adapters, and expanded auth/routing/proxy tests across 13 files.

sipeed/picoclaw (PR #211)

Go | Security Hardening | +326/-39 | State: Open

Security hardening and CI fixes: added config validation, Slack channel sanitization, cron service hardening, and expanded test coverage across 11 files.

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/cli (PR #4495)

Go | AppKit Template | State: Closed

Fixed AppKit TypeScript tRPC template usage by replacing unsupported request-context calls with WorkspaceClient and aligning template behavior with current CLI APIs.

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.

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 #56)

Go | OAuth Device Flow | State: Merged

Fixed device-code login parsing for interval values returned as either strings or integers, added targeted tests, and improved headless authentication guidance.

google/langextract (PR #359)

Python | Gemini Batch Cache | State: Open

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