• Build and maintain Power BI dashboards to verify and track inconsistency of industries, hierarchies, names, etc. between Disney systems and visualize key metrics.• Formulate SQL scripts to query and access multivariable sales, finance, and marketing data from the Disney Advertising server to incorporate into reports, visualizations, and dashboards.• Translate assignment data from sales teams into systems, such as Salesforce, to allow stakeholders to quickly distinguish who is working with specific advertisers and agencies, provide necessary permissions, and report on revenue.• Unify data between sales systems of Disney, ABC, ESPN, Hulu, National Geographic and Freeform to improve workflow and reporting for sales, finance, and technology teams, organized by industry and holding companies.• Cleanse, populate, and validate information of roughly 30,000+ advertiser and agency accounts in Salesforce to ensure accuracy and fullness.• Provide ad hoc user support for teams within The Walt Disney Company.

See above. Converted to full-time.

• Transformed existing marketing operations processes with the development of tools to easily distinguish relevant contacts in targeted market segments and assign them to designated salespeople.• Updated and manipulated data from multiple sources into reporting objects for analysis.• Transitioned and advanced marketing operations reporting language and code for 2020 to 2021.• Supported marketing and sales personnel with customer research projects and ad-hoc requests to gather meaningful executive-level insights and learnings on current prospects, potential prospects, and KPIs.• Tracked performance of in-person and online marketing events along with global asset sends.

• Facilitated batches of marketing and sales leads while cultivating created opportunities for the sales team within the Salesforce platform, generating roughly 70 leads a month with a conversion total of 58%.• Analyzed email engagement metrics to continually improve content and achieve designated KPIs.• Edited marketing emails and creatives/assets for global database with an average CTO of 25%.• Developed and delivered marketing and sales dashboards and reports to stakeholders.

• Promoted Facebook page with weekly post and promotion, organically growing following by 30%.• Launched Instagram page, maintaining an engagement rate of 18%.• Administered Google and Yelp pages to attract potential clients and connect with present customers.

• Accelerated and modernized period schedule process for retained earnings and dividend accounts of KFC, Taco Bell, and Pizza Hut using Microsoft Excel and Oracle systems.• Cooperated with accountants and fellow interns on database projects pertaining to the number of franchises/franchisees owned by Yum Brands! around the globe.

• Monitored student and faculty payable accounts to ensure transactions were accurate and delivered.• Collaborated with fellow student office assistants and Business Office personnel to complete general office task.