Managed, upgraded, and automated NBCUniversal’s legacy Java/Oracle Database SNL ticketing system before transforming it into a modern, self-service platform. Added rich text email editing, PDF ticket generation, acknowledgment tracking, reminder emails, and barcode integration. Redeveloped in Drupal and migrated to Azure for improved performance, scalability, and alignment with cloud strategy.
Project Overview
Challenges & Solutions
Challenges
Legacy ASP.NET application with Oracle Database backend was outdated and lacked modern functionality
Business users had to manually create ticket emails using HTML code with no rich text support or previews
No ability to generate PDF tickets for guests
Email formatting required developer involvement, delaying turnaround and consuming developer time
No reporting module
Tracking acknowledgments required manual follow-ups
No way to send reminders directly from the system
System was hosted on on-premises servers, limiting scalability and not aligned with cloud migration goals
Solutions
Managed and enhanced the legacy ASP.NET / Oracle Database application, introducing automation to reduce manual work and speed up processes
Replaced manual HTML editing with a rich text editor and built-in email preview functionality
Added PDF ticket generation to standardize guest ticket formats
Implemented reusable email templates so business users could format and send without developer assistance
Automated acknowledgment tracking to show whether guests responded within a defined time window
Enabled business users to send reminder emails directly from the application
Integrated barcode generation into tickets to streamline guest entry
Redeveloped the application in Drupal with an improved UI, enhanced performance, and better user experience
Coordinated with privacy and cybersecurity teams to ensure compliance in handling guest data