Patrick Desgrange

Patrick Desgrange

Marketing Intern

Followers of Patrick Desgrange98 followers
location of Patrick DesgrangeMilford, Ohio, United States

Connect with Patrick Desgrange to Send Message

Connect

Connect with Patrick Desgrange to Send Message

Connect
  • Timeline

  • About me

    CRM specialist using technology and strategy to improve resiliency and efficiency in the arts. __ Tessitura | Data Analysis | SQL | Python | Tableau

  • Education

    • Otterbein University

      2000 - 2004
      Bachelor of Arts (B.A.) Arts Administration
    • Coursera

      -
      Google Data Analytics Professional Certificate Data Analytics
    • Coursera

      2022 - 2022
      IBM Data Analytics Professional Certificate Data Analtytics
  • Experience

    • The Philadelphia Orchestra

      Aug 2003 - Dec 2003
      Marketing Intern

      -- Created visualizations for new pricing and rezoning strategies for Verizon Hall

    • Cincinnati Symphony Orchestra

      Oct 2004 - Aug 2006
      Customer Service Representative

      -- Engaged patrons in person, over the phone, and at concerts with superior service-- Increased patron engagement, ticket sales and donations by suggesting additional ticket purchases and/or adding on donations with purchase

    • Cincinnati Playhouse in the Park

      Apr 2005 - Feb 2022

      -- Planned, organized and implemented all performance and event set-up within Tessitura CRM for 16 consecutive seasons-- Performed most ETL functions for the company using custom SQL queries, lists, extractions and output sets for marketing campaigns, sales leads, ticket and renewal data, reports, triggered email campaigns, etc.-- Developed Tessitura Analytics reports and dashboards for all departments-- Managed all TNEW Admin setup for efficient online purchase paths-- Developed SSRS reports for automated sales and customer service reports-- Trained staff and wrote customized documentation to ensure all departments leveraged Tessitura efficiently according to their specific business needs/goals-- Lead technical analyst for Tessitura integrations such as payment processors, access control (Zebra scanners), WordFly and Revenue Management App-- Optimized transactional emails and digital tickets by customizing HTML templates using Razor markup language-- Kept the company up-to-date on Tessitura and technology upgrades through continuous training and classes including attending conferences Show less

      • Ticket System Administrator

        Aug 2008 - Feb 2022
      • Assistant Ticket Services Manager

        Aug 2006 - Aug 2008
      • Tickets Services Representative

        Apr 2005 - Aug 2006
    • Tessitura

      Feb 2023 - now
      Technical Consultant
  • Licenses & Certifications