Experience — Bernard Shen

Red Ventures Fort Mill, SC

Business Analyst Intern · Jun 2025 – Aug 2025

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).

Those Coffee People Medellín, Colombia · Remote

Market Research & Analytics Intern · Jun 2023 – Aug 2023

Spearheaded market research and data analysis on the 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.

Summit Coffee Davidson, NC

Barista · Jul 2021 – Mar 2022