Carnegie Hall

📈Projects
- refined weekly subscription report to present insights, observations, and trends, as visualizations rather than dense tables reducing time to understanding and decision-making

Marketing Analytics Manager

Monitor and report on campaign effectiveness across multiple channels, including e-mail, direct mail, and telemarketing. Monitor ticket sales and make recommendations to optimize revenue using dynamic pricing and inventory management. Segment customers into lists for use across channels including e-mail, direct mail, telemarketing, and social media. Collect, organize, and interpret historical sales data to inform season projections. Team lead for CRM.

📈 Projects
- collaborated with senior marketing team to design, deploy, analyze, and interpret subscriber survey using SurveyMonkey and Excel
- created revenue projection Excel template based on existing business model to quickly and accurately project revenue scenarios for future concerts using SUMIFs and dynamic array formulas, as well as Excel tables and named ranges to improve readability of formulas
- developed email segment performance Excel template to analyze email performance by list segment using Power Query and Power Pivot modules to join multiple reports from Tessitura CRM
- reduced time to process and clean leads collected online using Power Query scripts; process now takes a couple hours rather than a day
- reduced time spent collecting data (running reports) and updating reports by configuring ad hoc data pipelines using Tessitura scheduled reports, Power Automate, Sharepoint, and Power Query. 

Tools: Microsoft Excel, Tessitura, Tessitura Analytics, Revenue Management Application (RMA), Wordfly, Mailchimp, Google Analytics, Google Data Studio, Microsoft Power Automate

Marketing Analyst

Maslanka Press

📈 Projects
• Managed logistics for annual trips to exhibit at Midwest Clinic (LTL shipping, booth setup, staffing, inventory)
• Setup and maintain project management system (Trello) and internal knowledge base to keep teamwork synchronized and to share important information with each other
• Cultivated excellent long-term relationships with clients and patrons, maintaining ongoing communication and facilitating solutions to address concerns

☑️ Responsibilities
• Schedule, organize, and coordinate residency details (scheduling, contracting, invoicing, travel) for David & Matthew Maslanka's 20+ yearly visits to colleges, ensembles, and festivals (national and international)
• Organized and coordinated commission details for patrons commissioning new works written by David Maslanka
• Manage ISMN registration, copyright registration, and online content for a catalog of 75+ works
• Maintain and distribute up-to-date product catalog to distributors and customers
• Process orders for individuals customers and distributors, nationally and internationally
• Maintain/update datasheet with all details and pricing for inventory
• Maintain website (WordPress)

Administrator

Museum of Arts and Design

In addition to supervising a team of 5 Visitor Experience Associates, I also administered two SaaS platforms - ACME Ticketing and Dexibit (Analytics). My goal working with both people and technology was to ensure our visitors had a positive, memorable experience at the museum, encouraging repeat visitation, membership, and positive word-of-mouth.

📈 Projects
• Created weekly reports for senior leaders using Dexibit (analytics platform) and Excel to surface insights about visitation trends and effects of marketing efforts
• Maintained and developed Dexibit (analytics platform) by building thematic dashboards, custom reports, and maintaining configuration 
• Built a series of visitation scenarios, allowing leaders to develop a range of plans and forecasts for reopening after COVID-19 lockdown
• In first 30 days, audited and corrected existing visitation and revenue reports resulting in matched reporting between ticketing and analytic platforms
• Managed COVID-19 reopening for Visitor Experience (planned/implemented timed ticketing; configured automated member discounting; configured contactless ticket scanning; trained 4 VE staff)
• Overhauled configuration of ACME ticketing system to automate discounting, collect key visitor data online securely, optimize marketing messaging at key points in checkout flow, and simplify reporting
• Reworked event creation workflow in ACME and retrained staff to use workflow reducing time to create events from over 15 minutes to less than 10 minutes
• Started and maintained comprehensive knowledge base hubs using Teams, SharePoint, and other Office 365 apps, to share knowledge and best practices for multiple systems/departments (ACME, Dexibit, and Visitor Experience)
• Created Group Sales Tracker system using multiple connected Microsoft 365 technologies (Forms to collect information, Lists for request tracking, Word/Excel mail merge for document creation, and Power Automate to pass data between services)

Visitor Experience Manager

Cooper Hewitt, Smithsonian Design Museum

📈 Projects/Achievements
• Created SSRS custom reports (Tessitura) for Group Tours workflow, saving on average 2-3 minutes per invoice or receipt generated (on over 1000 documents generated per FY)
• Using Zendesk & GoodData, programmed 8 metrics, created 68 reports, and designed 4 dashboards (emailed weekly) showing support tickets for 2 specific, tech-heavy exhibitions as well as 2 dashboards summarizing support tickets for the rest of the exhibition galleries
• Created dashboard in Google Sheets to track performance of interactive pen devices, including a forecasting model, using moving averages and seasonality
• Developed dashboard prototypes in Tessitura Analytics
• Created logs (referenced tables) in Excel to track tour details and payments more accurately by reducing copy/paste errors and adding automation
• Created dashboard in Excel using Pivot Tables to track Docent tour stats
• Created documentation for Tours, School Programs, and Design Guide, workflows and systems

☑️ Responsibilities
• Assisted Head of Visitor Experience managing staff of 10+ Visitor Experience Associates, including modifying daily schedules, leading daily morning meetings, stepping in as needed, and communicating real-time updates to staff
• Scheduled private tours and school programs; created/updated/maintained systems & policies used to schedule private tours and school programs
• Maintained Help Center (in OneNote notebook) with most up-to-date policies, procedures, & information for staff to reference
• Gathered data from various sources, wrangling, cleaning, and analyzing data, using Excel, SQL, Python, and other data tools, to create reports
• Tracked performance of tours, school, and design guide programs over time (counts of programs and visitors) and sent reports as needed to Education, Development, and Director’s Office
• Maintained Daily Visitation dashboard for senior managers
• Maintained Gallery Tech dashboard for Chief Experience Officer and gallery tech staff

Senior Visitor Experience Associate (Tours)

Visitor Experience

Various

Performed as classically-trained musician with numerous orchestras, opera companies, chamber music groups, and pit orchestras, in New York City, Spokane, Philadelphia, Miami, Pittsburgh, and other locations throughout the United States.

Taught one-on-one private lessons to students ranging from beginner to advanced high school. Coached student horn and brass sections from middle school to high school.

Classical Musician (French Horn)

Spokane Symphony Orchestra

• led a four member horn section
• performed 10 Classics series, 5 Pops series, and numerous new music and education concerts
• highlights from the '14-15 season included Mahler Symphony No. 5, Adams Doctor Atomic Symphony, and Brahms Symphony No. 4

Principal Horn

Ticket Philadelphia

Award
- Received call center Representative of Month in Spring 2014 following commendation from patron and recognition by supervisors for excellence in customer service

Daily Tasks
- Provided excellent customer service to all patrons and clients by adhering to the Ticket Philadelphia Standards of Excellence
- Sold tickets to all client events; accepting subscription orders by telephone and processing ticket exchanges and subscription ticket donations as needed (using Tessitura software)
- Disseminated information regarding various arts organizations and venues

Patron Services Associate

Tech-savvy and curious Analyst with 9+ years' experience specializing in data analytics, reporting, process improvement, and system configuration. I love to enable high performance for my team by optimizing processes and systems.

Tech Skills
Microsoft Excel (Power Query, DAX) | SharePoint | Power Automate | Microsoft PowerBI | MS SQL | Tessitura CRM

Taplio

Kyle Wilbert's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Kyle Wilbert's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Kyle Wilbert's Linkedin Analytics