← Back

Data Science and Analytics

• Rebuilt the core report shell: automated branding/white-labeling that had been done by hand, and added versioning, conditional logic, and exception-handling.

  Senior Analyst · Analytic Marketing Partners (AMP) · Sep 2016 – present

  SAS VBA

• Consolidated three separately-maintained versions of the same report — often out of sync with each other — into one data-driven shell.

  Senior Analyst · Analytic Marketing Partners (AMP) · Sep 2016 – present

  SAS

• Became the team's mapping expert: automated per-run maps in PDF output, drive-time measurement, and Huff-model competitor analysis.

  Senior Analyst · Analytic Marketing Partners (AMP) · Sep 2016 – present

  Geospatial / Huff Modeling

• Co-built, launched, and now maintains a client-facing data portal — self-service data exploration that replaced a slow, fully manual request process — and helped shape a new data marketplace offering built on top of it.

  still in production, still growing

  Senior Analyst · Analytic Marketing Partners (AMP) · Sep 2016 – present

  Python SQL

• Took on a client's "group within a group" segmentation problem: curated a new dataset combining their client-provided data with our consumer data, ran it through rigorous statistical analysis to determine the right method, then built a custom k-means model from scratch.

  400%+ response rate vs. prior efforts

  Senior Analyst · Analytic Marketing Partners (AMP) · Sep 2016 – present

  K-Means Segmentation SAS

• Tasked with optimizing an upcoming campaign: asked the right questions about what data they actually had access to, then refactored their existing bucketed RFM process into a standard-deviation-based model parsed across more categories, folded into full custom modeling blending spending/engagement patterns with household attributes.

  record-breaking engagement — the client started paying for this study on every campaign

  Senior Analyst · Analytic Marketing Partners (AMP) · Sep 2016 – present

  RFM Modeling

• Solved an auto-loan campaign with no exact-match variables using reverse-logic modeling on the microgrid variables that were available.

  Senior Analyst · Analytic Marketing Partners (AMP) · Sep 2016 – present

  Campaign Optimization

• Overhauled a client's manual data-selection process — replacing a slow, manual, copy/paste-and-highlight workflow with a tool built on their existing Google BigQuery setup, giving them instant feedback on selections and full control over their own parameters.

  replaced a fully manual selection process with instant, self-service control

  Senior Analyst · Analytic Marketing Partners (AMP) · Sep 2016 – present

  SQL

• Learned enough R in a single day to execute and validate a client's own scoring model against their internal testing — not R mastery, just enough to get it done.

  same-day turnaround, vs. weeks from other vendors

  Senior Analyst · Analytic Marketing Partners (AMP) · Sep 2016 – present

  R

• Pushed a client off straight-selects and hot-zips onto modeling; the resulting multi-territory win expanded into all franchises plus a full-year budget for the account.

  Senior Analyst · Analytic Marketing Partners (AMP) · Sep 2016 – present

  Campaign Optimization

• Built Personal Financial Plans — Social Security projections, amortization schedules, and scenario modeling — for advisors' clients.

  Advanced / Personal & Business Planning Analyst · Northwestern Mutual · Jan 2013 – Sep 2016

  Campaign Optimization

• Rebuilt new-agent production tracking end to end and shipped macros/dashboards giving agents real-time visibility into daily, weekly, and monthly goals.

  Director of District Reporting & Training · Northwestern Mutual · Jan 2011 – Jan 2013

  VBA