Created and maintained the sources of truth for growth & strategy data.Managed the growth for Chicago, East Bay, South Bay, Portland, Nashville, Austin, Dallas, Houston.Built tables for analysts with production data using airflow, redshift, bigquery, and python.Dressed up as a burrito to spark growth (whatever it takes).Used SQL/bigquery/redshift/postgres/python/pandas/geopandas to analyze and present Postmates data.Creatively dissected our data to find unique and interesting patterns that we can turn into marketing.Transformed our data into music.Worked on an article that was published in WIRED.Produced a radio ad that everyone in LA heard 8 times.Starred in and did the sound editing for a wrestling themed email campaign that was sent to 20 million people.

For about four months, I was traveling through South America. My goals while traveling are to gain a stronger command of Spanish, as well as to put myself into new and potentially uncomfortable situations to strengthen my resolve to overcome them. Tackling language barriers, taking on difficult but rewarding physical experiences, challenging myself to get by with very little, budgeting effectively, learning the importance of confidence and improvisation, etc. In retrospect, this was maybe the best thing that ever happened to my career.

Managed the ads for all labels in the US, Mexico, Argentina, Chile, Colombia, Bolivia, Peru, Ecuador, Guatemala, Honduras, Paraguay, Uruguay, Costa Rica, Panama, Hong Kong, Malaysia, Taiwan, Singapore, and the Philippines. Used advanced Excel/Google Docs formulas and SQL to create an efficient system for all of the 100+ external Label Account Managers to manage their multiple millions of Euro worth of ads.Ran large analyses of years of ad data to calculate global spend levels for labels.Hired and managed a team of 4 during a critical system migration, upgrading to DFP Premium.Worked directly with representatives from the major labels to deliver everything on time, and maintain strong relationships. Launched detailed global campaigns on tight deadlines working across departments.Worked with all sides of the Sales org to balance the needs of Sales with the contractual obligations to Labels.

Performed the duties of many roles, Technical Lead, Ad Trafficker, Account Manager, Pricing & Yield Manager, etc. Oversaw our transition to DFP Premium. Yelp was using DFP Premium when it was still called Google Ad Manager, giving me a very deep knowledge of everything it has to offer. Designed and maintained dozens of complex Excel/Google Spreadsheets templates and scripts that became the backbone for the AdOps process.Created tools and new ways of targeting and displaying ads using Javascript.As part of a small team, I worked directly with Product Managers and Engineers on any new ad products.

Managed the delivery of millions of dollars worth of rich media ads.Worked constantly with engineers on upgrading the product.Used advanced XML templates as the basis of our ads.Because of the growing nature of the company, I executed on very tight deadlines with little room for error.

Used SQL to monitor and maintain Soundflavor’s complex and evolving database of metadata on music.Wrote queries from scratch to find and update systematic errors with data.Developed processes based on the analyses to prevent recurring issues.Reworked the QA process for verifying the metadata using complex Excel functions and macros.