Daniel Meier

• Partner with the MagicEye and Photos Analytics teams, extract data, and perform in-depth analyses on user distribution, churn, product mix, upload velocity, paywall hit rate, conversion rate, and cost of sales to calculate user lifetime value (LTV). • Build comprehensive, bottoms-up models that calculate and compare the full estimated P&L of the business to evaluate investment strategies for our products, strategic partnerships for business generation and profitability, and resource allocation. • Use Google SQL and big data to understand and better forecast the growth and volatility of users, subscribers, revenue, and average revenue per user (ARPU). This data is also used to influence executive decision-making for key business initiatives. • Write macros in google sheets to automate the monthly financial reporting process. These macros snap-off all business metrics for Google Photos and create a summary sheet that compares actuals to the forecast, annual plan, and multi-year plan. • Develop, maintain, and present the quarterly financial review to the VP of Finance to drive scalable analysis and insight.

• Implemented multiple machine learning and time series models, including ARIMA, Bayesian, Fourier, TBATS, HoltWinters, Linear Regression, Random Forest, and Gradient Boosting, in R to forecast demand, attendance, and revenue. • Created a process that optimizes inventory buckets and reservation models using R and Python. • Bolstered forecasts, improved targeted Marketing, and empowered executives and clients to better understand guest demographics by creating a methodology and process to log and track guest origin. • Built a SQL database and Tableau dashboard to calculate and understand the liability and impact of outstanding tickets.

Data analyst in the first cohort of Disney's Business Leader Rotation Program, a full-time, entry-level program designed to provide recent college graduates a hands-on, interdisciplinary learning experience across a broad range of business areas throughout the Disneyland Resort. During this program, participants have the unique opportunity to experience four distinct rotations over a two-year period designed to provide participants with real-life business issues and experiences, ongoing mentorship, and targeted development critical to building key technical and leadership skills needed to succeed as a business leader at the Disneyland Resort.

• Responsible for consolidating the weekly Commercial Strategy Forum, which provides an executive update, forecast, and plan for the Disneyland Resort as a whole. • Utilize SPSS, Tableau, and SQL to develop analysis, actionable insight, and recommendations on leading indicators, commercial strategy, and strategic decision making.

• Created an algorithm, model, and subsequent tool using SQL and Tableau to forecast the most efficient amount of Cast Members to Train and Cross-Train for over 10,000 positions at the Disneyland Resort. This forecast helps boost scheduling efficiency, support an incredible guest experience, and save massive costs on training. • Assisted in planning and building better efficiency for Security and Emergency Services at the Disneyland Resort.

• Evaluated and presented to executives the business opportunities, objectives, and strategic approaches for new and upcoming events, entertainment, and attractions tied to key intellectual properties. • Crafted engaging reports for the Annual Passholder team and executives on previous “AP Corners” to better understand the events’ successes and the ways they can be improved in the future to ultimately increase AP visitation and demand. • Selected and organized content, including the copy and photo assets, for the monthly Disneyland AP eNewsletter in order to better inform Annual Passholders of offerings and events to ultimately drive revenue and visitation to the resort.

• Developed innovative reports and dashboards through Teradata and Excel that compounded over 3 years’ worth of data for over 15 million guests, which assessed various trends and changes in sales and attendance to help stakeholders make and evaluate vital business decisions, new revenue, pricing, yield strategies, and improve predictions. • Built and optimized financial plans and developed new visualizations and metrics for product offerings using Excel and PowerPoint to better highlight strategic business opportunities, lifting revenue growth, and improving guest experience. • Used linear regression and modeling to maximize the potential revenue for Disneyland Grad Nite by over $4M, organizing interested high schools into groups using models as well as each schools’ date choice, size, and history with the resort.

• Created research decks for cross-functional support and provided sales with consumer trends, platform performance, consumer affinity, and demographics to help create and close multimillion-dollar deals with advertisers. • Designed, developed, and maintained innovative reports and dashboards using Tableau, Snowflake, SQL, and Excel that help stakeholders evaluate the successes and failures of new content and make decisions on key aspects of future content.

• Built a predictive algorithm using R and R Shiny to forecast, optimize, and convert social media engagement into sales. • Used Tracx, Crimson Hexagon, and UTM parameters in Google Analytics to construct emergency impact and sentiment reports for executives about leaks, events involving our content and brand, and sales flow from social channels. • Produced performance reviews with insights such as conversation volume, sentiment, post and traffic source, month over month and week over week changes, and demographics for campaign leads, senior level directors, and executives. • Executed the reveals and launches of the most popular packs for The Sims 4, reported their social performance, and used this to provide solutions and recommendations for future campaigns. • Made a step-by-step guide to finding meaningful insights from tools such as Tracx and Twitter Analytics and presented this to the entire community engagement team. • Regularly posted content, managed, and performed data analytics on social channels for the Sims, EA Access, and Origin Access using Spredfast, Percolate, Podio, Tweet Deck, and Facebook Business Manager.

• Update The Sports Quotient Stat Machine with new and engaging sports statistics and quiz questions.

• Developed a brand new research project looking for ways to track customer behavior with online data points in order to boost customer retention. • Produced excel worksheets from extracted data and created formulas to autonomously calculate summaries, validate names and emails, split up data, populate cells, and create various data visualizations. • Created and tested surveys in multiple languages and updated web pages to enhance both employee and customer experience.

• Member of the Bank of America promotional marketing team at AT&T Park for the San Francisco Giants and Major League Baseball offering fans complementary souvenirs for applying for the MLB® BankAmericard Cash Rewards™ MasterCard® credit card.

• Maintained a database of around 30,000 members and ran trend reports and logged critical information about these members in order to better serve their needs. • Analyzed and summarized attrition data, simplified preexisting filing systems, and produced trend documents. • Wrote a query that resulted in an estimated savings to the JCC of over $40,000/year.

• Baseball coach for elementary to high school students for an overnight summer sports camp.

• Camp counselor in charge of activities for 6-10 year olds.

Programming in R, SPSS, SQL, Python, SAS, and Stata.