Archives
Data Quality Assessment on a Data Warehouse and KPI Assessment on Its Users
Formlabs, one of the largest 3D printer manufacturers in the world, tasked me with examining their data warehouse to determine its properties (volume, usage, users, queries and data quality) and survey the people that engaged with the data to derive common business reporting metrics and key performance indicators. The goal was to find issues and […]
Chicago Hospital Ranking System
There is an incredible lack of transparency and accessibility to hospital ratings. In order to address this issue, and as part of a weekly civic tech hackathon, an organizational quality coordinator from a Chicagoland hospital and I developed a Chicago hospital ranking system as a proof of concept. We: • Acquired, cleaned, analyzed and joined […]
A Regression-based Cross-Sectional Analysis of the Effects of Resources on Math Proficiency
(For Chicago Public Elementary Schools, SY 2017-2018) Per-pupil expenditures have been on the rise on average for decades at both a national and state level. However, academic outcomes haven’t got much better. A heavy reliance on revenue from local property taxes to fund schools means poorest school districts in Illinois receive 20% less than the […]
Online Poker Analytics
As webmaster of one of the largest gambling websites in the world, my day-to-day responsibilities included: • Loading and joining data from many sources and using them to inform on the success of marketing, sales, and customer service initiatives. I was also • Evaluating and improving the efficacy of changes to the website itself for […]