Leading a six-month project in collaboration with a CRM consulting firm to develop a custom-built CRM tailored for media owners, overseeing the migration from Google Workspace to Microsoft 365. Serving as the primary point of contact, working one-on-one with the firm and Pearl media C-Suite to collaborate ideas and ensure the solution fits our sales, operations, and financial departments, while managing a team of two coworkers throughout the project
Leverages Microsoft Power BI to create interactive dashboards to visualize campaign reporting data for clients
Engages with clients to confirm advertisement creatives, specifications, and scheduling, fostering effective communication and alignment with client expectations
Utilizes Broadsign and Si9n software to deploy and troubleshoot digital advertisements for companies like Disney, Chanel, and Hulu on screens nationwide
Enhanced monthly reporting efficiency by creating a streamlined Excel system, improving the delivery of comprehensive reports to clients and ensuring clarity in showcasing deliverables
Automated Google Sheets, Docs, and Drive through Google Apps Script, streamlining organizational processes.
Intern - Data Analytics
3D Printed Talent
01.2022 - 04.2022
Integrated/automated software platforms such as Hubspot, Notion and Gmail using Integromat software
Engineered an automated SKU-based inventory management system leveraging Excel macros, yielding a significant boost in operational efficiency
Collaborated with CEO to provide analytical insight into prospective clients/companies using Hubspot and Notion
Cleaned, analyzed, and expanded the company’s prospect database by over 400%.
Intern - Financial Planning & Analysis
Questex
06.2021 - 08.2021
Orchestrated a project to standardize reporting classifications for 10,000+ suppliers across Questex's 11 Industry sectors
Interacted directly with Market Leaders
The new system is now utilized by all sales and finance team members companywide to more precisely analyze and track performance in Salesforce
Led a project to evaluate and improve pricing strategies across all Questex lines of business
Prepared budget, forecasting and other financial statements for use by the office of the CFO.
Intern - Data Analytics and Marketing Strategy
Factory LLC
06.2020 - 08.2020
Analyzed and optimized the digital promotion of three food brands (Mikey’s/Stuffed Puffs/Pipcorn) on 50+ Ecommerce platforms
Recommendations were implemented per plan
Conducted comprehensive analysis, identifying the top 40 social media influencers from over 1,000+ potential options for Mikey's (gluten-free bread) and Roar (electrolyte beverage), setting the stage for strategic brand representation
Conducted extensive CPG market research to direct the social media marketing strategy for several of Factory’s food brands.
Education
Bachelor of Science in Economics -
Lehigh University, College of Business
Bethlehem, PA
05.2023
Skills
Highly skilled with Excel, Microsoft Power BI, and Broadsign
Expert in Broadsign, Si9n, and Connectwise softwares
Proficient in SQL, R, Python, Java, Netbeans IDE, and Git
Well-versed in CRM softwares HubSpot and Salesforce, as well as integration software Integromat
Timeline
Associate - Digital Operations and Analytics
Pearl Media
12.2023 - Current
Intern - Data Analytics
3D Printed Talent
01.2022 - 04.2022
Intern - Financial Planning & Analysis
Questex
06.2021 - 08.2021
Intern - Data Analytics and Marketing Strategy
Factory LLC
06.2020 - 08.2020
Bachelor of Science in Economics -
Lehigh University, College of Business
Similar Profiles
Melanie MargolinMelanie Margolin
Director of Business Development at Pearl MediaDirector of Business Development at Pearl Media