Experience

Designed a suite of modular SQL views to parse 1,000+ unique product names and apply time-versioned rate cards ingested via Fivetran, creating the first centralized variable-cost model for a channel pacing $21M in 2025 revenue.
Delivered real-time margin visibility across all products and eliminated 10-12 analyst hours per month by replacing Excel workbooks with queryable tables feeding internal Tableau dashboards and partner reports.
Coded a Python audit script to reconcile automated pipeline outputs with manual reports, identifying and resolving approximately $1K in monthly mispayments (0.4% error rate).

Spearheaded market research and data analysis on U.S. coffee market, leveraging multiple data sources to calculate TAM/SAM for cafes and roasters, driving 194% growth in contracts and 107% increase in revenue for FedEx shipments (does not include metrics related to sea freight).
Created Excel visualizations shaping market entry strategy, resulting in 111% growth in Roasted contracts (373% revenue increase) and 137.5% growth in Micro Green contracts (30.59% revenue increase) for FedEx shipments.

Bernard Shen | Experience.