Work Sample 1
Problem Solving through text mining, sentiment analysis and statistical hypothesis testing
The Problem
A long-successful restaurant chain noticed a decline in same-store sales for a few of its locations, but couldn’t figure out the cause.
The Solution
Text and sentiment mining of Google and Yelp reviews revealed an erosion of customer satisfaction across a few key areas at the struggling locations which correlated with their decline in sales, as confirmed via statistical analysis.
Case Study - The Olive Garden Problem
Case Study - The Olive Garden Problem - Deliverable Detail 1
Case Study - The Olive Garden Problem - Deliverable Detail 2
More Examples of Problem Solving Projects
Second-Line Lung Cancer Treatment Decision Model
Healthcare / Biotechnology
Devised a pilot treatment decision model for non-small cell lung cancer patients requiring second-line treatment. The decision model combined survival probabilities and incremental cost data for each potential treatment pathway (including clinical trial therapies) and resulted in a shortlist of recommended treatment pathways, ordered by cost per QALY gained.
Novel Employee Engagement Analytical Model & Survey
Management Science / Human Resources
Designed a novel work engagement survey and analytical model based on a synthesis of three employee engagement theories from academic literature. This client project ignited a deep interest in this field of research for me. I retained IP ownership of the theoretical model (which I call the 'Four Lens Model') and hope to further develop and test it..
Customer-Facing Real Estate Ranking Algorithm, Survey & App
Real Estate
Developed a customer-facing survey and corresponding ranking algorithm and app to select and rank real estate properties in Mexico City based on weighted customer preferences, along with an internal-use companion app for analyzing and comparing real estate values and other metrics by neighborhood. Led the distributed data team tasked with building out a fully automated back-end system for the apps and integrated into existing company processes.
NIBRS Crime Data Query Tool App
Government Data / Research
Parsed and packaged millions of NIBRS data records; created a Shiny App for user-friendly data access and research purposes. The National Incident-Based Reporting System (NIBRS) is a nationwide (US) crime data collection and reporting system managed by the FBI. Anonymized data are released annually as sets of massive raw data files.
Retail Customer Segmentation Analysis & Targeted Strategy Recommendations
Consumer Goods / Retail
Deep-dived into historical data for a long-standing retailer in New Zealand transitioning to online sales while continuing to mail out physical catalogues at significant cost. Detailed statistical analyses led to recommendations for which catalogues to send, at what frequency, to which customer segments, in order to optimize conversion rate and order value.
Diagnostic Audit & Update Plan for Custom Builder's Revenue Forecast Model
Manufacturing / Construction
Executed a diagnostic audit and review of a monthly revenue forecast model used by a custom builder in Australia that tended towards over-estimating revenues in the near term. The deliverable was a detailed model update plan to correct the over-estimation problem and provide additional predictive accuracy.