Learn Data Skills
Beta
Jon Vertuno

Jon Vertuno

Business Intelligence Architect and Designer

Lincoln Center for the Performing Arts | New York

Technologies

My Portfolio Highlights

My New Course

Understanding Data Engineering

My New Course

Data Warehousing Concepts

Statistical poet, weaving elegant stories with the threads of data.

My Work

Take a look at my latest work.

course

Understanding Data Engineering

course

Data Warehousing Concepts

course

Understanding ChatGPT

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Lincoln Center for the Performing Arts | Sep 2023 - Present

Business Intelligence Architect & Designer

N/A

CSM Sport & Entertainment | Jun 2022 - May 2023

Senior Business Intelligence Manager

• Spearheaded and created a process for data collection leading to the creation of a database for internal tracking on campaign success allowing a data driven basis for creating KPIs for external and internal campaign performance utilizing multiple data warehouses and data visualization tools. • Built and configured servers and databases for the Brand Experience team. Extracted, loaded, and authenticated historical data to create a historical database by using Alteryx, Power Query, and Excel Queries to preserve data integrity. Monitor the performance of current data collection processes to ethically handle private data. • Built a data collection framework for the Integrated Marketing Team. Expanded and rolled out additional capabilities and data framework for Brand Experience, Production, and Consulting team. • Assessed and negotiated with multiple vendors for ETL Tools, Data Visualization Platforms, and Influencer Marketing platforms to create a new offering for the larger Brand Experience/Integrated Marketing Team. • Created and maintained multiple Power BI, Looker Studio, and Excel Dashboards for sales, marketing efforts, and influencer reporting. • Trained and developed internal Social Listening, Influencer Marketing Metrics across multiple platforms. • Driving force between the platforms, clients, and client teams for setting up campaigns, troubleshooting, and reporting needs on the campaigns.
Show More

CSM Sport & Entertainment | Mar 2021 - Jun 2022

Senior Marketing Manager

• Launched a Social Listening and Influencer reporting offering across experiential brand marketing events. • Created and maintained a ticketing framework guide for future season event builds (consisting of a pricing matrix, naming structure, event code build, discount and dynamic pricing strategies, etc). to create consistency and simplify the building process. • Created and implemented the ticket sale strategy alongside marketing timelines, competitive landscapes, creating terms and conditions, building FAQs, and guided the development team in creating the best possible experience for consumer and client from the ground up. • Launched ticket sales for inaugural and first in-person seasons of Softball and Lacrosse for a women’s sports league on multiple ticketing platforms and set up processes for future success for additional seasons and sports. • Cultivated and created client relationships across ticketing platforms, vendors, box office, operations, marketing, and all other departments. • Designed emails, website, digital calendar, ticket stock, and subscriber collateral from design, partner outreach, and receiving quotes from printing companies.

Bergen Performing Arts Center | Apr 2020 - Jul 2021

Director Of Ticketing

• Created processes and reporting for cancelled, rescheduled, and postponed events. • Worked with all internal teams to coordinate messaging and ticketing policies that were board approved. • Built all brand new Outdoor Drive-In events including seating manifests, price tables, holds/kills, discounts, pre-sales, "pod" seating, flexible seating in Archtics and Ticketmaster Host • Created a brand new reporting system for daily ticketing wraps for "business as usual sales" alongside Pandemic specific reports that tracked refund/ chargeback/credit requests. • Facilitated in processing refunds, credit, and enacted policies that could track when special credits (with added value) were needed. • Developed and implemented best practices for customer communication (phone and email) and created standardized responses to set expectations with guests. • Analyzed and improved the theater’s database protocols. • Honed current Marketing and Development processes to streamline further work and assist all to successfully meet goals.

AKA NYC | May 2018 - Mar 2021

Insights Analyst

• Analyzed daily sales trends by performance, by part of house, by ticket type in order to generate pricing recommendations with the goal of helping each client be as effectively sold as possible. • Coordinated with company management to enact pricing recommendations and report on the performance of said price changes • Conducted in-depth trend reports for clients that lead to long-term pricing strategies and tactics • Utilized sales database of previous & current clients to generate reports regarding seasonal sales trends, comparison sales trends, & anticipated sales by channel then presented key sales trends/potential actions to clients • Created new Inventory Management visualization tools with various ticketing platform data via Alteryx, Tableau, PowerBI, Looker Studio, and Excel

Bergen Performing Arts Center | Dec 2017 - May 2018

Ticketing and Database Manager

• Led the On-Boarding of the Development, Ticketing, Marketing departments and the Performing Arts School to the Archtics Platform during the transition from Ticketmaster Host. • Built all events including seating manifests, price tables, holds/kills, discounts, pre-sales, etc. in Archtics and Ticketmaster Host. • Assisted in recruiting, managing, and training ticket services staff. • Developed and implemented best practices focused on achieving exceptional guest service by coaching, training and motivating staff. • Assisted Development and Marketing departments in working with all Ticketmaster software, including Host, Account Manager, and FanBuilder. • Analyzed and improved the theater’s database protocols and produced multiple box office reports and artist sales reports as requested.

Broadway Across America | May 2011 - Nov 2017

Ticketing Manager

• Built all events including seating manifests, price tables, holds/kills, discounts, pre-sales, etc. for full season and one-night engagements. • Create and maintain multiple reports in Microsoft Office Suite for dynamic pricing/discount/sales initiatives. • Strategize and communicate with producer/presenters when needing to use third party discounts. • Extensive knowledge on Groupon/Goldstar/Travelzoo and Ticketmaster discount programs. • Promoted, improved, and strengthened relationships with new and existing VIP Subscribers. • Developed and implemented best practices focused on achieving exceptional guest service by coaching, training and motivating staff.

My Education

Take a look at my formal education

Bachelor’s Degree, Musical TheatreThe New School | 2010

About Me

Jon Vertuno

Jon hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free