Ad hoc analyses and reporting tools

Analyses on effectiveness of digital direct mail, Asian play trends, cross-property marketing, and others.

2016-2018Link

User interests

Aggregates content labels to user level. Project included filtering NSFW, grouping labels, and decaying. I designed and implemented. Batch feature was built with Airflow scheduler calling BigQuery scripts. Streaming feature was built with Flink. Further built User-to-Subreddit mapping using Annoy approximate nearest neighbors.

2021-2022Link

Data work

Aggregated player data and joined with the marketing data from many sources and systems.

2016-2018Link

Lifetime value model

Built a customer lifetime value model of our commerical policy data.

2014-2016Link

User covariates

Covariates are user variables that we control for when analyzing impact of A/B tests. I identified impactful covariates and wrote script to compute these.

2021-2022Link

Marketing segmentation

Designed and aligned market segments from 15 different casinos.

2016-2018Link

Commercial auto model

Helped refresh our decade-old commercial auto model, combining two previous models.

2014-2016Link

Event post forma dashboard

Built a Tableau dashboard to show event KPIs versus benchmarks. Spearheaded initive and achieved wide roll-out to about 60 users at 15 casinos with 1000s of uses per month, becoming most-used workbook in the company.

2016-2018Link

StacksByStacks

This is a now-defunct website I’ve made to track predictions made for NHL games, by experts on the internet. The front-end is built with Angular, which uses a PHP handler to access the MySQL database, which gets populated with a library of Python scrapers.

2020Link

Webscraper 8

Create backend worker. Played more with logging, trying fluent-bit. Switched from LevelsDB to sqlite to fix parallel access.

2024Link

Webscraper 9

Implemented proxy pools. Switch from expiration to freshness pattern.

2024Link