Ticketing System of 21st Men's
Ticketing System of 21st Men's
World Handball Championship
World Handball Championship
Darko Homar
Darko Homar
Head of development & consulting
Head of development & consulting
DEKOD telekom
DEKOD telekom
HrOUG presenter: Goran Mati
HANDBALL
HANDBALL
▪
▪
Handball is played around the world
Handball is played around the world
Europe
Europe
Asia
Asia
Africa
Africa
South America
South America
▪
▪
Megapopular in Europe
Megapopular in Europe
Germany, France, Spain, Danemark, Sweden...
Germany, France, Spain, Danemark, Sweden...
of course, Croatia
of course, Croatia
HANDBALL
HANDBALL
HANDBALL IN CROATIA
▪
▪
World's top in last 15 years
World's top in last 15 years
▪
▪
Gold and silver Olympic medals
Gold and silver Olympic medals
▪
▪
World Championship 1st and 2nd places
World Championship 1st and 2nd places
▪
▪
World Cup
World Cup
HANDBALL IN CROATIA
HANDBALL IN CROATIA
WORLD HANDBALL
WORLD HANDBALL
CHAMPIONSHIP 2009
▪
▪
broadcasted on 90 different TV channels
broadcasted on 90 different TV channels
▪
▪
130 mil TV viewers of finals France vs. Croatia
130 mil TV viewers of finals France vs. Croatia
▪
▪
102 matches
102 matches
▪
▪
42 match days
42 match days
▪
▪
7 venues
7 venues
▪
▪
5 sales channels
5 sales channels
▪
▪
4 access control solutions
4 access control solutions
▪
▪
300.000 tickets issued
300.000 tickets issued
WORLD HANDBALL
WORLD HANDBALL
CHAMPIONSHIP 2009
Venues
Venues
Venues
Venues
Spaladium Arena
Venues
Venues
Venues
Venues
Arena Vara
Venues
Venues
Arena Osijek
Venues
Venues
Arena Zadar
Venues
Venues
Arena Zagreb
Why DEKOD telekom?
Why DEKOD telekom?
▪
▪
ticketing software > 10 years experience
ticketing software > 10 years experience
▪
▪
ticketing service > 5 years
ticketing service > 5 years
▪
▪
Paganini project (ticketing) won Oracle Apps
Paganini project (ticketing) won Oracle Apps
World Elevator Pitch contest in 2001 (Paris)
World Elevator Pitch contest in 2001 (Paris)
▪
▪
Oracle
Oracle
--
24 years of experience!
24 years of experience!
--
Oracle Certified Partner
Oracle Certified Partner
▪
Tennis
Tennis
Soccer
Soccer
About DEKOD telekom
About DEKOD telekom
▪
▪
privately owned company since 1992
privately owned company since 1992
▪
▪
Telecom division:
Telecom division:
--
JDSU partner, test and measurement solutions
JDSU partner, test and measurement solutions
▪
▪
Software division:
Software division:
--
BI, ticketing, SW projects
BI, ticketing, SW projects
--
ticketing service
ticketing service
▪
▪
ISO 9001:2008 certified
ISO 9001:2008 certified
▪
Project scope
Project scope
▪
▪
to provide ticketing service
to provide ticketing service
▪
▪
to interface with access control systems
to interface with access control systems
--
every venue has different AC system, or none
every venue has different AC system, or none
▪
▪
to provide access control where AC system not
to provide access control where AC system not
available
Ticketing service
Ticketing service
▪
▪
Sales channels:
Sales channels:
internet
internet
outlets (agencies)
outlets (agencies)
box offices
box offices
ticketing center
ticketing center
▪
▪
Distribution of tickets: delivery service
Distribution of tickets: delivery service
▪
▪
Hardware & software: servers, workstations, printers...
Hardware & software: servers, workstations, printers...
▪
Timeline
Timeline
2009/01/15 2009/01/15 Championship Championship start start 2009/02/01 2009/02/01 Finals Finals Project Project closure closure 2008/11/1 2008/11/1 Project start Project start 2008/11/24 2008/11/24 Sales start Sales startChallenges
Challenges
▪
▪
Short preparation time
Short preparation time
▪
▪
Building organization
Building organization
-
-
outsourcing and contract
outsourcing and contract
employees
employees
▪
▪
Adjustments to specific rules
Adjustments to specific rules
regarding seating plans, pricing, sales process
regarding seating plans, pricing, sales process
▪
Project team
Project team
▪
▪
15 people from DEKOD telekom
15 people from DEKOD telekom
▪
▪
15 hired
15 hired
▪
Simple ticketing process
Simple ticketing process
▪
▪
example: rock concert
example: rock concert
▪
▪
define price categories
define price categories
▪
▪
include VIP box definitions
include VIP box definitions
▪
▪
take care of sponsor tickets
take care of sponsor tickets
▪
▪
sell
sell
-
-
internet, outlets, box offices...
internet, outlets, box offices...
▪
Handball World Championship
Handball World Championship
Ticketing Process
Handball World Championship
Handball World Championship
Ticketing Process
Ticketing Process
▪
▪
one ticket for the 3 matches on a "match day"
one ticket for the 3 matches on a "match day"
▪
▪
seating plan definition
seating plan definition
--
not recommended to mix supporters
not recommended to mix supporters
from different countries
from different countries
--
press areas
press areas
--
IHF (International Handball Federation) area
IHF (International Handball Federation) area
--
seats for national teams not playing at the time
seats for national teams not playing at the time
--
two VIP areas
two VIP areas
--
sponsors
sponsors
Internet
Internet
ticketing center
Ticketing center
Ticketing center
request
payment
offer
Outlets
Outlets
Local box offices
Local box offices
Project Organization
Project Organization
internet sales outlets
help desk & call center ticketing center project management software development technical support ticketing access control teams box offices
Project Organization
Project Organization
internet sales outlets
help desk & call center ticketing center project management software development technical support ticketing access control teams box offices
order processing seating plan administration payment processing ticket issuing
Project Organization
Project Organization
sales channel control payment processing packaging and delivery
internet sales outlets
help desk & call center ticketing center project management software development technical support ticketing access control teams box offices
Project Organization
Project Organization
hardware & software installation education
ticket paper supply ticket paper control
internet sales outlets
help desk & call center ticketing center project management software development technical support ticketing access control teams box offices
Project Organization
Project Organization
ticket sales
ticket collection (tickets bought through other sales channels) internet sales outlets
help desk & call center ticketing center project management software development technical support ticketing access control teams box offices
Project Organization
Project Organization
new reports continuous improvement (outlet app - new partner!) access control interfaces bug tracking and resolving
internet sales outlets
help desk & call center ticketing center project management software development technical support ticketing access control teams box offices
Project Organization
Project Organization
sales control cash flow control HR management
communication - CHF, partners, accounting... Issue detection internet sales outlets
help desk & call center ticketing center project management software development technical support ticketing access control teams box offices
Pre
Pre
-
-
sales definitions
sales definitions
▪
▪
Seating plans
Seating plans
sectors, rows, seats
sectors, rows, seats
Arenas not finished yet!
Arenas not finished yet!
technical seats
technical seats
-
-
TV cameras etc
TV cameras etc
▪
▪
Price categories definition
Price categories definition
▪
▪
Access control: zones, AC devices definition
Access control: zones, AC devices definition
▪
▪
Event definition
Event definition
▪
Seating plan definition
Seating plan definition
Seating plan definition
Seating plan definition
Seating plan definition
Seating plan definition
Outlet/box office application
Outlet/box office application
Outlet/box office application
Outlet/box office application
Outlet network
Outlet network
Outlets
Outlets
▪
▪
network
network
-
-
ADSL lines
ADSL lines
▪
▪
provide equipment
provide equipment
▪
▪
provide software
provide software
▪
Internet shop
Internet shop
Internet shop
Internet shop
Internet shop
Internet shop
DEKOD's internet center
DEKOD's internet center
Oracle DB Oracle OAS other services (DNS...) mail server
--
Windows / Linux platform
Windows / Linux platform
(Oracle on Windows platform)
(Oracle on Windows platform)
--
Oracle Standard Edition
Oracle Standard Edition
--
partially virtualized
partially virtualized
--
connected to payment processors
connected to payment processors
Payment gateways
Center for all sales channels
Center for all sales channels
Internet
ticketing center
System Architecture
System Architecture
▪
▪
central ticketing database
central ticketing database
z
z
supports all sales channels: internet, outlets, local
supports all sales channels: internet, outlets, local
box offices, ticketing center
box offices, ticketing center
▪
▪
central application server
central application server
z
z
supports all sales channels
supports all sales channels
▪
▪
local last minute sales databases & applications
local last minute sales databases & applications
z
z