Matt Livingston
San Juan, PR 00907
matt.j.livingston.40@gmail.com
Experienced digital professional with a scientific training – Analytically minded with a passion for solving complex problems that have no immediate answer
SKILLS
Business Intelligence: Tableau, BIME, Datorama, Google Data Studio |
Pull Data: SQL - MySQL, Google BigQuery, Vertica SQL, SQL Server, PostgreSQL |
Automation: Python Scripts |
Programming: Python, R |
Web Applications: Flask/Python/Bootstrap framework - AWS Deployment |
Data Science: Market Basket Analysis, Multivariate Regression, Logistic Regression, Bayes Theorem, A/B testing |
EXPERIENCE
RentPath - Atlanta, GA
Analytics Lead – Online Rental Marketplace
November 2017 - June 2018
-- Lead Analyst supporting 6 product managers across 4 websites
-- Mentored junior analysts and taught python for automation purposes
-- Built Tableau dashboards that supported sales, product, and executive leadership
-- Developed Stored Procedures in SQL Server for table creation
-- Developed python scripts and deployed on AWS Lambda for custom reporting
Quantcast - Austin, TX
Senior Analyst – Programmatic Media
October 2016 - November 2017
-- Senior Analyst covering high profile accounts totalling millions of dollars a quarter
-- Mentored junior analysts on industry standards and taught python for automation purposes
-- Recommended campaign optimizations to client teams to drive better performance
-- Developed custom PostgreSQL statements for reporting and campaign insights
-- Built ad hoc Tableau dashboards for various stakeholders in the company
-- Developed and deployed (on AWS) a Flask/Python web application which predicts
performance at incremental budget for any live campaign within the company
Perk - Austin, TX
Data Analyst – Mobile Rewards Network
January 2016 – June 2016
-- Provided analytical support for over 20 apps and web properties
-- Consolidated financial reporting that comes from over 10 ad networks
-- Built daily ad hoc queries in various SQL platforms – BigQuery, RazorSQL, and MySQL
-- Integrated database tables, Google Analytics, Attribution reporting, Google Sheets and
other data sources into BIME (BI tool) to reveal business insights
-- Manipulated GB size files in RStudio that was not possible in Excel
-- Coded market basket analysis using R to determine user adoption of apps
-- Coded extensive text-cleaning and text-standardizing commands in R
-- Created business decks that analyze consumer behavior for industry insights
Xaxis - Los Angeles, CA
Analyst, Insights & Analytics – Programmatic Media
June 2015 – January 2016
-- Primary analyst on accounts totaling $10 million in revenue
-- Provided ad hoc analysis for two account managers and two strategists
-- Unified data streams coming from Ad Servers, DSPs, viewability vendors, and Salesforce
into Datorama for real time campaign analysis
-- Utilized cross media attribution tools to illustrate synergies between various channels
-- Created and presented campaign decks containing audience insights, KPI analyses, and
other insights to drive future campaign strategy
Target Media Partners - Los Angeles, CA
Business Analyst – Digital Advertising
August 2014 – June 2015
-- Directly managed over $3 million in account revenue
-- Managed fastest growing digital product – Responsible for 1500% of growth
-- Wrote Excel macros to automate campaign management for $2 million in account
revenue – Saved 10 hours a week in management time
-- Developed systematic approaches for campaign management
-- Defined process flows for campaign fulfillment using JIRA
-- Analyzed historical data to find actionable management trends
-- Used SQL Server for campaign management, ad hoc requests, data analysis, and
stored procedures
-- Managed campaigns in AdWords, DFP, DCM/Bid Manager, Thinknear, and TubeMogul
advertising platforms
-- Analyzed web analytics and lead generation via Google Analytics
EDUCATION
University of Chicago - Chicago, IL
Master of Science degree - August 2013
Chemistry PhD Candidate |
University of Wisconsin-Madison - Madison, WI
Bachelor of Science degree - May 2012
Major: Chemistry |
Overall GPA: 3.7/4.0, Major GPA 3.8/4.0 |
Dean’s List, Graduated with Distinction, Golden Key International Honor Society, Delta Upsilon Fraternity |