Andrew Lysaught
Supervisor, Marketing Sciences · OMD
Work Experience
Supervisor, Marketing Sciences
OMD2017 – Present
Comprise, analyze, and represent the global mobile app and beef campaigns for McDonald's. Leading a team of two analysts we work together to create and troubleshoot Alteryx workflows, SQL databases, Tableau dashboards, week over week trend reports, and track in-store lift measurement in order to keep the campaign train on track.
Senior Analyst
Initiative2016 – 2017
Built easy to navigate Tableau dashboards for Boeing, Massachusetts Financial Services, and Aramark, and presented reports to VPs and Directors to make sure that campaign success was clearly understood.
Reporting Solutions Analyst
Starcom MediaVest Performance Marketing2014 – 2015
Created over 100 insightful data-driven reports for Starbucks that were digestible to the client as I made the data more human and fun. The reports centered around the performance of Starbucks' banner ads.
Advertising Analyst
Ebiquity2013 – 2014
Managed the PepsiCo account writing campaign assessments on their competitors in the market. SQL software was the main portal used to portfolio the thousands of ads from over 20 different countries.
Education
Masters in Applied Behavioral Economics
Cornell University2015 – 2016
Masters in Applied Behavioral Economics
Bachelor of Arts in Cold War History
Indiana University2009 – 2013
Bachelor of Arts in Cold War History
Post-Graduate Certificate in Creative Writing
Northwestern University2013 – 2014
Post-Graduate Certificate in Creative Writing
Post-Graduate Certificate in Integrated Marketing
University of Chicago2014 – 2015
Post-Graduate Certificate in Integrated Marketing