Patrick de Guzman

Experience

1. Senior Data Scientist, Marketing Analytics

   Intuit

   Aug 2022 — Present

   Forecasting new mobile & web subscriptions for our core accounting software products and website traffic with time series models in fiscal year and quarterly planning • Executing quarterly and annual scenario planning for marketing budget decisions and their expected impact on future sales • Developing a home-grown Media Mix Modeling Optimizer web app using Plotly Dash, which will enable marketing and analytics teams to optimize media budgets on a self-serve basis • Planned & executing on end-to-end measurement of a $10M campaign targeting nascent businesses, involving measurement in media (TV, Audio, Display, Video, and Social), Quickbooks.com landing pages, and post-acquisition CRM • Driving incrementality testing on various Social platforms (e.g. Facebook, Tiktok) to estimate overall incrementality and elasticities for diminishing returns in order to inform platform media strategy • Identified & facilitated a $5M incremental revenue opportunity to reallocate media budgets using our Media Mix Model

Skills

• Microsoft Office
• Event Planning
• Social Media
• Customer Service
• Facebook
• Microsoft Word
• Leadership
• Public Speaking
• Teamwork
• Research
• Microsoft Powerpoint
• Microsoft Excel
• Administration
• Powerpoint