Customer Case Study HP Customer

1

• Customer Case Study (HP Customer)
• Passenger Reservation Systems and related
• Websites
• in
• Indian Railways
• By
• Deepak Chhabra
• Group General Manager (Webservices)
• Email id - dchhabra_at_cris.org.in

2
GROWTH OF PASSENGER TRAFFIC OVER YEARS (in
Millions)
Year Suburban Non Suburban Total all
classes second class 1950-51 412 847
1284 1960-61 680 899
1594 1970-71 1219 1196 2431 1980-81
2000 1602 3613 1990-91 2259 1580 3858 1
995-96 2484 1507 4018 2000-01
2861 1932 4833 2001-02 2999 2053 5093 200
2-03 2934 2037 4971
3
Major Projects

• Country Wide Network for Computerised Enhanced
  Reservation (CONCERT)
• Web Enabling of CONCERT
• National Train Enquiry Services (NTES)
• Web enabling of NTES
• Season Ticketing
• Data Warehousing

4
Projects handled by PRS Group

• CONCERT Implementation on VAX Systems in 1998-99.
• Porting of CONCERT in PRS/Secbad
  22 Sept, 94
• Porting of CONCERT in PRS/New Delhi
  9 Sept, 96
• PRS/NDLS and PRS/Secbad Networked
  8 Oct, 97
• Porting of CONCERT in PRS/Kolkata
  15 June, 98
• Networking between PRS/Kolkata,
• PRS/NDLS and PRS/Secbad
  19 July, 98
• Porting of CONCERT in PRS/Mumbai
  11 Jan, 99
• Mumbai Networked with Delhi, Kolkata Secbad
  31 Jan, 99
• Chennai Networked with Mumbai,
  18 Apr, 99
• Delhi, Kolkata Secbad

5
Projects handled by PRS Group

• NTES implementation on 1.8.1998 at Northern
  Railway.
• Y2K Compliance Project for PRS Systems.
• Website on internet enquiries launched in
  1999-2000.
• Season Ticketing Project launched in June2001.
• NTES Phase-II implemented in Aug-Sep, 2001 at all
  PRS sites.
• Alpha Migration from VAX to ALPHA Systems on all
  sites in Sep-Oct, 2001.
• RTR migration in March-June, 2002 at all PRS
  sites.
• Implementation of E-Reservation from Oct 2001 to
  Aug., 2002 for IRCTC.
• UTS implemented on NR at 10 stations on 15th
  August, 2002 and 13 more stations of Northern
  Railway on 2nd October, 2002.
• UTS implemented at Gorakhpur, Patna Kolkata

6
CONCERT(Country Wide Network of Computerised
Enhanced Reservation and Ticketing )

• Integrates five Regional Reservation Centres
• Judicious mix local autonomy with uniformity of
  business rules.
• Very complex Business transactions.
• Less than 1 sec for local transaction and 3 sec
  for network transaction.
• Comprehensive functionality

7
CONCERT NETWORK TOPOLOGY
kolkata PRS
Delhi PRS
2 MBPS (x2) Leased Line6
2 MBPS (x2) Leased Line
Mumbai PRS
2 MBPS (x2) Leased Line
Secunderabad PRS
2 MBPS Leased Line
Delhi
2 MBPS Leased Line
2 MBPS (X 2) Leased Line
Calcutta
Mumbai
SecBad
Chennai PRS
Chennai
8
Hardware Used in CONCERT

• Hardware Delhi Mumbai Kolkatta Chennai
  SBad
• ES 40 2 2
  2 2 -
• ES 45 1 1 1 1
  1
• 3. DS 20E 2 2
  1 1 3
• 4. RAID 1 1
  1 1 1 CRIS
  has been selected as one of the top ten companies
  by M/s. HP through an event organized by MIS
  Singapore based Magazine for issuing tickets to 1
  million passengers /day using minimal hardware

9
ENVIRONMENT

• Operating System Open VMS version 7.3-2
  Database In-house CRIS proprietary
• Middleware Digitals Reliable Transaction
  Router (RTR 4.2)
• Networking protocol DECNET
• Front End VAX Forms, C and FORTRAN as
  development tools
• Communication Systems CISCO routers and 2 Mbps
  BSNL lines
• Network Topology partially connected mesh
  topology.

10
PREVIOUS SET UP AT PRS/DELHI
FDDI CONC
SWITCH
VAX 7610
VAX 4705
VAX 4705
HUB
TS
TS
MUX
CI
DSSI
LD
MODEM
Fiber Ethernet Storage
LD
MODEM
MUX
T
RT
11
CONCERT APPLICATION ARCHITECTURE
Touch Screen
Press
IVRS Tele-Booking
Internet Users
WEB Server
Reservation
Charting
Database
IRCTC
Enquiry
Internet Client
FireWall
CONCERT Interconnect Bus
Delhi Servers
Mumbai Servers
Chennai Servers
Secbd Servers
Kolkata Servers
DB
DB
DB
DB
DB
12
FEATURES OF CONCERT

• Performs reservations for over 8,82,000 seats and
  berths (during peak rush it goes to as high as
  10,17,000) per day
• Available on over 2,998 trains nation-wide for
  various classes
• Bookings for over 7,000 destinations
• 4,262 reservation terminals
• Across about 1,171 locations.

13
Load on PRS
14
Passenger Reservation Load
15
REPORT OF TOTAL NO OF TERMINALS/ LOCATIONS AT ALL
PRS (Jan 2006)
16
REPORT OF RECEIPT/REFUND/NET EARNING
SITEWISE JAN 2006
17
REPORT OF NUMBER OF PASSENGER BOOKED/ CANCELLED
SITEWISE
18
PERCENTAGE OF NETWORK LOAD OF EACH PRS (JAN 06)
PRS FOR SEC FOR DLI FOR MAS
FOR HWH FOR BB SEC 61.47/ 56.63
5.60/ 6.11 15.29/ 18.10 9.17/ 10.03 8.50/
9.16 DLI 0.90/ 0.98 81.06/
78.00 2.71/ 3.38 8.15/ 8.69 7.19/ 8.97
MAS 2.93/ 2.71
3.93/ 3.93 85.22/ 84.22 2.10/ 2.28 5.84/
6.88 HWH 2.14/
2.25 12.21/ 11.96 4.81/ 6.06 74.62/ 72.27
6.24/ 7.49 BB
2.36/ 2.27 15.64/ 16.01 5.84/ 6.61 5.30/
5.69 70.88/ 69.44 Total
6.75/ 6.60 28.96/ 26.04 20.17/ 21.68
19.58/ 19.21 24.57/ 26.50
19
Benefits of PRS to the Passengers

• Transparency
• Universal counters for booking
• Instant update of status
• Instantaneous enquiry
• Reduced waiting time
• Reservation available at a number of locations in
  the country
• Customer satisfaction

20
Benefits of PRS to the Railways

• Increased efficiency
• Optimal utilisation of berths
• Real time availability of Accounting Reports
• Planning through MIS reports
• Analysis of traffic pattern for better overall
  planning
• Reduction in Revenue losses
• Saving on Manpower
• Eliminate possibilities of fraud

21
Meeting unique requirements
100 Availability Objective (Application Level)
Availability
Hours Lost/Year
P/Sysplex, Himalaya
2.2
99.99
Single Mainframe
8.7
99.9
AS/400, OpenVMS, HP3000
17.5
99.8
Solaris, HP-UX, Tru64, AIX
35.0
99.6
NT and Microsoft Cluster Server
69.9
99.2
Gartner Group, 2001
22
PRS Website www.indianrail.gov.in

• CRIS has implemented and hosts Indian Railways
  own web-site, namely www.indianrail.gov.in and
  offers PRS enquiries on the internet namely
• Trains between a pair of Stations
• Accommodation Availability
• PNR Status Enquiry
• Train Schedule/Fares
• Station Code Enquiry
• Short Messaging Service (SMS) on Mobile
• A maximum of 35 lakh hits per day have been
  recorded

23
PRS Website ENVIRONMENT

• Computers (Hardware) DS20s and DS10s
• Operating System TruUnix 64 and Open VMS
  version 7.3.2
• Middleware Digitals Reliable Transaction
  Router (RTR 4.2)
• Networking Protocol DECNET and TCP/IP
• Firewall Raptor EC version 4.1
• Communication Systems CISCO routers using 2
  Mbps and 64kbps DOT lines
• Web Server - Apache 7.3.27

24
Enquiries on www.indianrail.gov.in

• Trains between a pair of stations
• This enquiry gives all the trains between the
  selected source and destination station
• Accommodation availability
• This enquiry gives the latest seat availability
  position of the chosen class, date, train and
  route.
• PNR status enquiry
• This enquiry gives the latest updated status of
  the passenger
• Train Schedule
• This enquiry gives the complete path information
  of a particular train with the arrival and
  departure time at a station.

25
Static Information on www.indianrail.gov.in

• Rules
• Reservation Rules, Refund Rules, Break Journey
  Rules, Luggage Rule, Change in Name
• General Information
• Season Tickets, Circular Journey, Booking
  Locations, Concession Forms for Blind,
  Orthopaedically handicapped, Mentally retarded
  and Deaf Dumb persons, General Reservation
  Form, Tele Booking, Tatkal Booking
• Tourist Information
• International tourists information, Travel
  Agents
• Special Trains
• Palace on Wheels, Royal Orient Express, Hill
  Trains, Shivalik Deluxe/Palace Trains, Holiday
  Specials, Tatkal Trains, Rajdhani Trains,
  Shatabadi Trains

26
Enquiries on Cell Phones through SMS

• Train Schedule
• PNR Status
• Accommodation Availability
• Trains between stations
• Fare
• Available on Short code
• 676747
• 7886
• 8888

27
FORMAT/ KEY to send SMS

• Access No. 676747 (IDEA, AIRTEL, BPL, BSNL)
• To get your Ticket Status
• PNR ltPNR No.gt
• Checking for Trains running between two stations
  TL lt starting city gt lt ending citygt
• Checking for Ticket AvailablityTA lttrain number
  gt ltstarting citygt ltending citygt ltjourney date gt

28
(No Transcript)
29
(No Transcript)
30
PRS System Level Failures handled

• Year No. of Failures handled
• 2000 23
• 2001 20
• 2002 38
• 2003 28
• 2004 40
• 2005 8

30
31
Future Enhancements on www.indianrail.gov.in

• Improvements in the response time in the Dynamic
  (PNR and Seat availability) enquiries.
• Other transport information (Road/Air/Water) for
  major tourist locations
• Dynamic Enquiries in Hindi
• Providing dynamic enquiries for 24 hours.

32
National Train Enquiry System (NTES)

• National Train Enquiry System is a nationwide
  integrated on-line information system for
  monitoring running of passenger trains and
  providing reliable updated information regarding
  arrival and departure of trains to passengers.

33
Technology used

• Hardware
• DS20 Alpha machines under Tru 64 Unix 4.0 f
• Software
• C,RTR 3.2
• Sybase with Replication

34
National Train Enquiry System (NTES)

• Real Time Information of Train arrival /
  departure
• disseminated through
• Display Boards
• Interactive Voice Response System (IVRS)
• Automatic Announcement System
• Face to Face Enquiry counters
• Internet (web site launched at www.trainenquiry.co
  m)

35
NTES Website www.trainenquiry.com

• National Train Enquiry System is made available
  through Internet on www.trainenquiry.com
• Site provides the following Information
• Running Status of Trains
• Trains between two Stations
• Spot your Train
• Train Arrival
• Tourist Information
• Passenger Amenities at Station

36
Enquiries on NTES Website

• Spot Your Train
• Gives the running status along with the delay
  marked for a train at a station
• Find your Train
• Trains between two stations
• Arrivals/Departures
• Trains arriving/Departing at a given station in
  next few hrs
• Train Time Table
• Schedule Arrival/Schedule Departure
• Passing Through Trains
• Shows a list of trains passing through a station.

37
E-RESERVATION PROJECT FOR IRCTC

• The e-reservation website http//www.irctc.co.in
  was
• inaugurated on 3rd August 2002.
• The software developed by CRIS consists of
• Complete interface software between the IRCTC
  front-end server and the back end Alpha server.
• Complete e-reservation and enquiries back end
  servers. 
• Ticket printing and reset facilities in existing
  client.
• Accounting reports for the IRCTC transactions.
• Combination of HP and Intel.

38
New challenges

• Maintenance by remote login by vpn
• By HP engineers in US or Bangalore
• Regular proactive patch updation

39
SCOPE

• Passenger Coaching Refunds System (PCRS) meant
  for Tickets issued with reservations refund can
  be given through PRS for the cases
• Reporting before 12 hrs after departure of the
  train
• Who are reported after 12 hrs of the departure of
  the train

40
Frequent Rail Travellers Scheme

• FRTC club opened, Registration Fees is Rs. 500
  per year valid for three years and Renewal Fees
  is Rs. 300.
• Off peak Period 15 January 31 March and 15
  July 15 September.
• Points awarded for 10 of the total amount and in
  peak period 2 .
• Scheme applicable for all classes except 3 AC in
  Rajdhani, Shatabdi Jan Shatabdi Trains.
• PRS Software to be modified to store Card number
  and Journey details.

41
Data Warehousing

• Data warehouse on PRS is a collection of
  passenger information from 5 PRS sites intended
  for management reporting and decision making. It
  will facilitate the management to analyse the
  following-
• Earnings
• Passenger Traffic
• Wait List Analysis
• On daily weekly, monthly and yearly basis for
  premium train types, classes and pair of
  stations.
• Extraction/Transformation/Loading layers of
  processing is developed in house.
  

42

• Thanks