Data Analyst
Resume:
MOST RECENTLY USED
Advanced Excel - pivot tables,
lookups, macros, VBA
Tableau - making ad hoc dashboard
for data analysis and those that are
stakeholder facing and easy to
manipulate
SQL (via Snowflake) - proficient in
creating queries from scratch, used
on a daily basis to retrieve data and
maintain quality control
Looker
Adobe Analytics
YouTube Analytics
Confluence
Google Suite
Microsoft Suite
PAST EXPERIENCE
PowerBI
Google Analytics
Brandwatch
Sprinklr
HootSuite
Google Adwords
Bing Ads
Yahoo Gemini
Alvaria Software
ad5xzd@r.postjobfree.com
www.linkedin.com/in/jennsfrancisco
29046 Silver Stirrup Way, Winchester, CA
C O N T A C T P R O F I L E
E D U C A T I O N W O R K E X P E R I E N C E
B.A. English Language and Literature
University of California, Riverside
SEP 2009 - JUN 2013
Extracurriculars: Katipunan Pilipino
Student Organization, Cultural Night Lead,
Powder Puff Football Team Co-Captain
Data Analyst with 8+ years of experience working with and maintaining quality of large data sets using SQL queries, forecasting (short-term, long-term), consulting for ad hoc projects, and collaborating with cross-functional teams especially those within the finance, advertising/sales, and marketing sectors. Seeking a remote, independent contributor role in analytics within an organization and under leadership that values work-life balance and mental health, and encourages creativity in a collaborative work environment. J E N N I F E R F R A N C I S C O
Senior Finance Forecasting Analyst
The Walt Disney Company / ESPN
Managed and improved the long-term and short-term digital ad inventory forecasting models across several sports and ESPN networks over the course of four years.
Proven ability to increase forecast accuracy to within 1% to goal for monthly or event-specific forecasts by creatively combining internal and external data/resources to determine and anticipate performance drivers. Assisted in driving business decisions for finance planning, content rights and ad placement strategy by providing insights on platform growth, audience behavior, and seasonality on a recurring basis Presented to over 100+ ESPN employees on the anatomy of a UFC event and how strategic ad placement, network, event prep, and in-event performance heavily affects revenue.
Managed monthly meetings with Google partners to improve YouTube KPIs so that we may better translate content viewership into revenue numbers. Optimized ESPN+ financial forecasting model by network, platform, and individual sports keeping scalability at the forefront, improving overall speed of ad hoc analyses from ~2 hours to 30 minutes.
Collaborated with data science teams weekly in an agile/sprint-based setting to build an in-house app which managed forecasts. This resulted in saving more than 50% of time on ad hoc analyses and gave the team more visibility into granular views of data in order to maintain data quality. Consulted with finance, content, and ad sales stakeholders to understand their ad hoc project needs and define the KPIs that would best fit their goals. Tools: Snowflake (SQL), Tableau, Excel (formulas, pivot tables, macros), Adobe Analytics, Looker, YouTube Analytics, Confluence, Microsoft Suite SEP 2019 - OCT 2023
S E N I O R D A T A A N A L Y S T & F O R E C A S T E R T O O L S T A C K
Senior Forecasting Analyst, Workforce Management
Nordstrom
Delivered high-quality forecasts at a daily and intraday level for all of Nordstrom’s online staffing needs inclusive of contacts needed for HR, styling and beauty services, and in-store operations. Confidently cross-collaborated with supportability and operational teams to determine and incorporate performance drivers into our forecasts. After only one month of training and quickly picking up a new software and industry, was thrown into the fast-paced holiday season and ended the quarter with positive feedback and was ranked as a high-performer. Tools: Alvaria Workforce Management Software, Excel, Confluence OCT 2023 - MAR 2024
ad5xzd@r.postjobfree.com
www.linkedin.com/in/jennsfrancisco
29046 Silver Stirrup Way, Winchester, CA
The Walt Disney Company
Employee of the Quarter (Q2 FY23,
Q2 FY22)
Event Committee Lead, created and
organized team bonding events with
limited budget (Office Olympics,
March Madness, Fantasy Football,
holiday events)
Disney VoluntEARS organizer for
events in Seattle, WA.
Past Personal Volunteering
High school public speaking
tournament judge specializing in
original oratory and oratorical
interpretation
Teacher’s assistant for the Inneract
Project, which helps to bring free art
and culture to youths in the Bay
Area, California
Writer for The Culture Trip blog, Bay
Area Edition
C O N T A C T
S E N I O R D A T A A N A L Y S T & F O R E C A S T E R W O R K E X P E R I E N C E
A C H I E V E M E N T S &
C O N T R I B U T I O N S
C O U R S E S T A K E N &
O T H E R I N T E R E S T S
Lead Data Analyst/Consultant
Microsoft (via Rational Consulting)
Managed a four-person marketing analytics team for Microsoft’s Cloud and Enterprise segment, which included cross-collaborating with events, blog, and social media teams to report on marketing campaign performance for Azure, Microsoft 365, SQL Server, IoT, and other developer products. Presented monthly campaign performance insights and offered strategy and process and improvements to leadership and decision makers to improve overall viewership, CTR, and other engagement metrics. Promoted from Data Analyst to Lead Data Analyst after only eight months. Tools: Sprinklr, Brandwatch, YouTube Analytics, Adobe Analytics, PowerBI Mar 2018 - Sep 2019
Marketing Campaign Analyst
Goodreads.com, an Amazon company
Single analyst reporting out on the performance of all Goodreads native advertising campaigns inclusive of newsletters and display ads. Developed an Excel-based automated tool to quickly generate weekly performance insights at scale for hundreds of marketing campaigns. Made significant process improvements for collecting client contact data within Salesforce and maintaining overall campaign progress. Built MBR decks for Campaign Managers to present to advertisers. Worked with ad campaign Pricing Strategist to determine reasonable growth rates based on historical campaign performance.
Sep 2017 - Mar 2018
Digital Marketing Analyst (Contractor to FTE)
LQ Digital Marketing Agency Emeryville, CA
Built and managed paid SEM campaigns in Google Adwords, Bing Ads, and Yahoo Gemini Ads simultaneously for clients with budgets of up to $500,000 in the following industries: e-commerce, finance, travel and hospitality
(Outrigger Resorts), car sharing services (Turo)
Presented campaign performance to clients on a weekly basis and worked with them to grow their marketing efforts by A/B testing new campaigns. Streamlined monthly processes for updating Outrigger Resort’s promotions offerings, which reduced total processing time by about 5 hours (50%). Aug 2016 - Sep 2017
J E N N I F E R F R A N C I S C O
Courses Taken
Graphic Art and Design courses
Pubic Speaking course
Leadership and Coaching course
PowerBI Course
Google Adwords Certification
Other Interests
Art in all of its forms
Event planning & volunteering
Marketing Assistant (Internship)
Fan Compass Software San Rafael, CA
Researched and maintained marketing contact lists in a B2B setting. Monitored marketing campaign performance using Google Analytics and Hootsuite, and reviewed performance with leadership on a weekly basis. Clients included NBA teams, Premier League clubs, and MiLB teams Mar 2016 - Jul 2016
Marketing & Community Engagement Manager
PawLoyalty Software San Francisco, CA
Managed content marketing strategy and execution of social media, blog, newsletter, and webinar content focusing on benefits of SaaS. Researched and managed contact lists in MailChimp. In a B2B setting, worked directly with small business owners to train them on software best practices and pet industry business best practices. Aug 2013 - Jul 2015
Contact this candidate