Daniel Guzman

Daniel Guzman

Product Analyst

EXPERIMENTATION · BEHAVIORAL & OPERATIONAL ANALYTICS · DECISION SYSTEMS

I help teams turn behavioral, commercial, and operational data into decision systems by separating meaningful signal from noise before it becomes an expensive product, growth, or operating decision.

UW Foster MSBA · 3+ years analytics experience · MIT Sloan SSAC Runner-Up · Seattle

Professional Summary

I specialize in separating meaningful signal from persuasive noise before a team makes a product, growth, commercial, or operating decision. My work spans B2B customer lifecycle analysis, marketplace and operations analytics, experimentation, and KPI systems. I have analyzed randomized experiments at a 576K-user scale, built risk and prioritization frameworks across customer and project portfolios, and reduced recurring decision latency from 48 to 15 hours by automating analytical reporting. I am most effective when the problem is ambiguous: a team has many possible signals, limited capacity, and an important choice to make. I define the outcome, examine plausible drivers, quantify uncertainty, and translate the analysis into a practical system, a score, a segment, an experiment readout, a KPI layer, or a prioritization rule that teams can use repeatedly.

Experience

Current
May 2024 — Present
Re-Systems Group Americas

Business Data Analyst

Re-Systems Group Americas · Coon Rapids, MN

  • Diagnosed bottlenecks across 150+ projects, separating approval, handoff, and execution delays; average completion time subsequently fell by 22%, from 45 to 35 days.
  • Mapped variation across 28 project-health KPIs covering $3.45M in active work, reducing weekly review preparation by 90%, from about 40 to 4 hours.
  • Assessed 55+ opportunities on margin, strategic fit, value, and execution risk, increasing the share of qualified opportunities pursued by 18 percentage points.
Built KPI SystemsAutomated ETLMillions of RecordsExecutive Decision Support
Apr 2023 — May 2024
PC Connection, Inc.

Business Solutions Analyst

PC Connection, Inc. · Minneapolis, MN

  • • Segmented customers on RFM plus category breadth and open-order issues, identifying accounts deviating from expected reorder patterns and raising at-risk accounts flagged from 20 to 32 (+60%).
  • Identified user lifecycle cohorts and high-response segments by running clustering analysis across 125K+ B2B accounts, informing a redesign projected to create $672K in revenue opportunity and reduce travel costs by 28%.
  • Automated 47+ recurring reports across 3M+ monthly transactions, reducing reporting latency from 48 to 15 hours (a 69% reduction).
Automated ReportingSegmentationRevenue AnalysisLarge Datasets
Jul 2022 — Mar 2023
Total Quality Logistics

Logistics Operations Analyst

Total Quality Logistics · Minneapolis, MN

  • • Diagnosed hard-to-cover patterns across 100K+ FTL loads using 6 drivers, improving root-cause classification accuracy by 43% across sourcing, pricing and service-design issues.
  • • Benchmarked 200+ FTL carriers on 5 service and reliability measures, with Carrier Index as a separate compliance gate, cutting recurring evaluation time by 50%, from roughly 10 to 5 business days.
Operational AnalyticsOptimizationScorecardsMeasurable Savings
2024 — Jun 2026

MS Business Analytics — Product Analytics & Experimentation

University of Washington, Foster School of Business · GPA 3.85 (Top 10%)

Featured Work

User behavior → Experimentation → Causal rigor → Technical execution

Charlotte FC Silver Club: Segmentation & Churn

MIT SSAC 2026
Question
Which season-ticket members are about to churn, and what actually separates them?
Scale
~11,200 season-ticket members
Method
GMM clustering, PCA, Random Forest, Logistic Regression
Finding
Four distinct buyer personas, with one leading predictor of non-renewal isolated at 98% validation accuracy.
Decision
Retention targeting by persona instead of blanket renewal outreach.

Dell Adaptive Gaming Experimentation Agent (Phoenix)

Question
Which variant actually worked, and what should be tested next?
Scale
Multi-metric experiment history across gaming test programs
Method
Lift estimation, uncertainty quantification, weighted composite scoring, LangGraph agent orchestration
Finding
Causal evaluation layer separates real variant effects from noise before a recommendation is issued.
Decision
Recommends the next experiment for human approval, never auto-launches to production.

A/B Test Design & Cohort Segmentation (576K-User Campaign)

Question
Does the campaign lift behavior, and for whom?
Scale
576K users in a randomized controlled experiment
Method
Power calculations, balance checks, ITT and ATT estimation, post-hoc segmentation
Finding
Heterogeneous effects: 2.2% lift for inactive users, 3.67% for non-American users, no effect for active domestic users.
Decision
Target the responsive cohorts, stop spending against segments with no measurable response.

Football Transfer Intelligence Platform

Question
Can transfer market value and movement be modeled end to end from public data?
Scale
Continuous scraped market and player data across leagues
Method
Scraping to S3, Airflow orchestration, Databricks, MLflow, Kafka streaming, Streamlit and Tableau delivery
Finding
In build. Pipeline and serving layers are the current focus.
Decision
Supports valuation and scouting comparisons once deployed.

Analytical Operating Principles

01

Question the belief behind the metric.

Every number encodes an assumption about users. Name it before defending it.

02

Define the comparison before choosing the method.

The counterfactual comes first. The estimator follows from it, not the other way around.

03

Match the strength of the recommendation to the strength of the evidence.

Directional data gets a directional call. Only clean identification earns a firm one.

Projects

Airport Baggage Analysis

Live on GitHub

EDA and probability analysis of airline baggage delivery times across ~99K real flights.

PythonpandasSciPyMatplotlib

Zillow Housing Analysis

Live on GitHub

EDA, feature engineering, and ZHVI price prediction across 1,406 West Coast cities over 10 years.

PythonpandasScikit-learnMatplotlibSeabornParquet

Direct Mail Response Analysis

Live on GitHub

EDA and predictive response modeling for a direct mail campaign across 100K customer records.

Pythonpandasscikit-learnMatplotlib

A/B Test Design & Cohort Segmentation (576K-User Campaign)

Academic Project

Designed and analyzed a randomized controlled experiment across 576K users. Power calculations, balance checks, post-hoc segmentation for ITT and ATT effects. Detected heterogeneous treatment effects — inactive users showed 2.2% lift, non-American users 3.67%, while active/domestic users showed no effect.

PythonSciPystatsmodels

Geo-Experiment & Causal Lift Measurement

Academic Project

Analyzed a randomized geo-experiment across 200 U.S. markets applying DiD with DMA and time fixed effects to isolate causal advertising lift vs. naive last-click attribution.

PythonstatsmodelspandasDiD

Football Transfer Intelligence Platform

Deploying Soon

End-to-end ML system for football transfer market analysis: web scraping → S3 → Airflow → Databricks → MLflow → Kafka → Streamlit/Tableau.

PythonAirflowDatabricksMLflowSageMakerKafkaApifyStreamlit

PortfolioSense

Deploying Soon

Stock portfolio monitoring agent with automated alerts, technical indicators, and a self-serve Streamlit dashboard.

PythonDuckDBStreamlityfinancepandas-taClaude API

Voir Dire — Agentic Job Scoring Pipeline

Deploying Soon

A personal agent-based decision-support system (Claude API + MCP stack) that scores and triages roles against a scraped JD corpus before I touch an application.

PythonClaude APIGitHub MCPDuckDB

Technical Skills

SQL & Databases

BigQuerySnowflakeDuckDBWindow FunctionsCTEs

Exploratory Data Analysis (EDA)

PythonPandasNumPySciPyStatsmodels

Data Visualization

TableauPower BIDAXMatplotlibSeaborn

Experimentation & Analytics

A/B TestingCohort AnalysisCausal Inference / DiDFunnel AnalysisPower / MDE

ML & Time Series

Scikit-learnARIMA / ProphetRandom ForestK-meansMLflow

Product Analytics Tools

AmplitudePostHogDatadogMixpanel

AI Systems

LangGraphRAGLLM EvaluationFastAPIOpenRouterChromaDB

Cloud & Infra

AWSDatabricksSnowflakeGitHubGitAirflow

Education

UW Foster School of Business · MS Business Analytics
GPA 3.85, Top 10% · June 2026
University of Minnesota · BS Economics, Minor in Management & Statistics
May 2022