William C. Huguenin
Areas of Expertise
Programming
Python
SAS (certified)
Git
Databases & Cloud
SQL (MySQL, Postgres)
AWS (EC2, Redshift)
Python Libraries
Pandas
Scikit-Learn
NumPy
SciPy
StatsModels
BeautifulSoup
Matplotlib
Seaborn
Data Science & Analytics
Predictive Analytics
Regression Analysis
Clustering & Segmentation
Database ETL & Reporting
Web Scraping & APIs
Data Visualization
Tableau
Periscope Data
D3.js (basic)
Education
Metis Data Science Bootcamp
Data Science Certificate 2016
Tufts University
BA Quantitative Economics 2011
Magna Cum Laude
University College London
Study Abroad: Economics 2010
Experience
L2
New York, NY
Data Scientist
10/2018 - Current

Research and advisory firm benchmarking the digital performance of consumer brands


  • Enabled deeper social media marketing research for eight sector-specific reports by applying matrix factorization and k-means clustering techniques to segment Instagram posts by content strategy.


  • Improved rigor of influencer marketing analyses company-wide, increasing client engagement with earned media marketing content. Onboarded new data vendor, built quality assurance and reporting processes, and assisted with development of panel selection and benchmarking methodologies.


  • Pivotal player in client renewals; contributed to a 95% client renewal rate in 2018 by providing continuous analytic support and training to a team of five analysts, thus ensuring on-time content delivery to over 75 beauty sector clients.


Junior Data Scientist
02/2017 - 09/2018

  • Reduced burden analyzing data for Asia Pacific research by building pipelines to store, enrich, and report Chinese e-commerce and social media data.


  • Developed coding standards for team of ten data scientist to ensure code readability and reproducibility.


Abt Associates
Bethesda, MD
Programmer Analyst, Social and Economic Policy
11/2014 - 03/2016

Mission-driven global leader in public policy research and program implementation


  • Proposed data-driven improvements to deployment of pilot college advising program through analysis of college enrollment and retention outcomes for low-income students participating in federal college access programs. Recommendations well received by client agency, resulting in $300,000 contract extension.


  • Promoted twice and six months ahead of schedule. Received six spot bonus awards recognizing outstanding quality of work on project management and data analysis.


Associate Analyst, Social and Economic Policy
08/2011 - 10/2014

  • Standardized and cleaned property transaction and foreclosure dataset consisting of millions of records for analysis of HUD community redevelopment programs.

Academic Projects
Yelp User Segmentation

Segmented Yelp users by topics most often discussed in restaurant reviews in order to customize users' online experience.

Airline Sentiment Analysis

Compared performance of various sentiment analyzers on over 10,000 tweets sent to U.S. airlines. Project featured in Data Science Weekly's June 2016 newsletter.

School Closure Prediction

Identified underperforming schools at risk of closure using random forests and support vector machines and National Center for Education Statistics data.