Trevor McCollum

Experience

• 

  The Madison Square Garden Company

  Apr 2008 - Aug 2020

  • Conducted month/year-end A/R reconciliation of 240 accounts for corporate finance to assess and ensure the completeness and accuracy of data. • Gathered, interpreted, and evaluated wire data via JP Morgan Solutions and presented it to events and productions teams for review. Produced a wide range of monthly progress reports related to accruals for department managers using Concur. • Co-authored important guidelines for Travel and Expenses module to help cross-functional teams to adapt to various changes occurred in the T&E system. Show less • Recorded accurate data of over sixty daily purchase orders and invoices using appropriate systems, including Oracle and Coupa. • Built solid in-house and vendor relationships to maintain smooth execution of daily workflow while proficiently dealing with sensitive correspondence.• Established and maintained a strong rapport with fifty vendors and ten internal teams across cross-functional departments, which contributed to gaining the trust of employees in handling complex problems and reducing curb turnaround time on FAQs. • Performed in-depth review and approval of contracts for twenty accounts every holiday season by consulting effectively with legal department. Show less

  • Shared Services Coordinator

    Apr 2018 - Aug 2020

  • Accounts Payable Represenative

    Apr 2008 - Mar 2018
• 

  PHD

  Jul 2021 - Aug 2023

  Paid Social Coordinator

  • Created, QA’d, and optimized campaigns from conception to completion in multiple digital platforms, including Meta, Pinterest, TikTok, and YouTube for Chuck E Cheese and Ghirardelli/Lindt• Built out 10+ campaigns each quarter, monitoring for efficiencies and issues throughout. • Led internal meetings on daily pacing for each and provided insights to improve performance. • Analyzed data for mid and post-campaign wrap reports, providing insights and identifying trends. • Assisted in compiling client tactical needs by pulling historical data from Meta, Pinterest, TikTok, and YouTube.• Reviewed past and current platform tests and made recommendations accordingly including suggestions for new digital partners for selected quarterly campaigns.• Reduced wait times for the financial team by 50% by authoring a QA document that efficiently reviewed Prisma buys. • Co-authored a paid social podcast/article playlist for upcoming trends and current marketing news. Show less

• 

  Critical Mass

  Dec 2023 - now

  Associate Media Planner