platform2024 - PresentActive

RENW

Commercial Decision Intelligence, Logistics Optimization & EPR Systems

Director of BI and Product for RENW, an operating commercial manufacturing licensee scaling molded fiber packaging. Built and scaled the computational systems and decision infrastructure powering operations across 75+ sustainable packaging SKUs—from two-legged freight calculation to 105+ automated dbt test gates and 50-state EPR regulatory compliance.

The Challenge

Scaling commercial packaging operations from pilot to 100M units requires unifying messy supplier pricing, volatile freight routes, and evolving state environmental regulations into a single defensible source of truth.

The Approach

Engineered the commercial operations decision platform with a 105-test dbt data quality pipeline and DuckDB analytics engine. Engineered a multi-modal logistics calculation engine with Haversine geospatial port detection, led California EPR regulatory modeling and public rulemaking testimony, and managed product architecture for production microservices (Product, Pricing, Sync).

Key Highlights

Commercial Decision & Operations Engine

Production analytics platform with 105+ automated dbt tests validating transaction-level unit economics, margin schedules, and environmental claims across 75+ SKUs.

Two-Legged Logistics Optimization

Unified calculation engine using piecewise linear interpolation and Haversine geospatial distance for ocean + domestic freight optimization.

EPR Regulatory Compliance & Advocacy

Built 50-state regulatory fee schedules and map overlays; provided public testimony establishing sustainable packaging regulatory pathways.

Impact

  • •Production systems powering commercial operations at enterprise scale (1K to 100M units)
  • •105+ automated data quality tests ensuring 99.7% mathematical accuracy
  • •Two-legged freight engine optimizing multi-modal logistics across 75+ SKUs
  • •Led regulatory compliance strategy and public testimony before California rulemaking bodies

Technologies

PythondbtDuckDBFastAPIPostgreSQLDockerPrometheusGrafana

Metrics

105+ dbt Tests75+ SKUs Live100M+ Unit Scale99.7% Accuracy

Links