RAK Proposal Oct 16 2003

1
Transport Information Technology Company IT PLAN
for Egypt Railways
Cairo June, 2008
2
ENR Strategy Direction
3
Who is to execute strategy?

• Transport Information Technology Co. ( TransIT)
  is the executive arm of ENR to execute its
  strategic IT plan.
• TransIT is incorporated as an IT OUTSOURCING
  company to provide IT consulting, execution
  operation services to transport sector.
• TransIT is a private enterprise totally owned by
  ENR.

4

Organization Structure
Coordination committee
ENR services
Trans IT CEO
Human Resources
IT Strategy
Contract Management
Finance Admin
Demand Mgrs
Service and Contract Mgrs
Infrastructure and Support Services
Business IT/ Demand Mgmt
ApplicationServices
Infrastructure Services
ENR Business IT
Metro Business IT
ApplicationSupport/CoE
NetworkService Mgmt
ERP
Roads and BridgesBusiness IT
TrainingCoordination
Operations
Hosting
Harbors Business IT
Commercial Apps Cargo
End User Service Mgmt

Commercial Apps Passenger
PM Pool
Project Mgrs
PM Pool
To be implementedat later stage
5
General Procurement plan
Tendering Process
Bid Evaluation
Due Diligence
Final Negotiations

• Issue RFP documents
• Coordinate questions and answer process to
  vendors
• Collect bid documents (technical and financial)

• Evaluate vendor technical proposals based on
  pre-defined selection criteria
• Selection of short-listed vendors
• Perform further vendor presentation to clarify
  scope and intensify evaluation process

• Conduct detail clarification workshops with
  short-listed vendors
• Agree on timeline scope
• Decide on sub-contractors/ system vendors
• Statement of Work
• Revise financial proposal
• Final selection of vendors to negotiate with

• Finalize Statement of Work
• Financial negotiations with selected vendors
• Contract award

Objective
6 weeks
4 weeks
8 weeks
4 weeks
Timeline
TransIT Del.
RFP
Evaluation documents
Re-worked evaluation documents
Contract signature
Vendor Del.
Proposal (technical and financial)
Response to specific inquiries
Contract signature
Expert contributionrevised proposals (technical
and financial) Sow (no detailed Business
Blueprint)
6
IT Components of ENR Business Architecture
7
Implementation is expected to be completed in
three years for all applications except revenue
management
Calendar
From IT Masterplan
ERP CRM
People, Organization Infrastructure
TBC in Year 4
Rail Sales
Rail Operations Management
8
main Functional Building Blocks of the project
Financial Mgmt.
Strategic Planning
1
2
4
3
Rail Sales Management Cargo
Rail Sales Management Passenger
ERP
Rail Operations Management
Bus. Intel.
Budgeting Forecasting
Controlling
Strategic Planning
Financial Accounting
Consolidation Legal Reporting
Demand Forecast
Supply Chain Mgmt.
Intercompany Accounting
Financial Analytics
Corporate Performance Mgmt
Inventory Warehouse Mgmt
Materials Requ. Planning
Human Resources
Procurement Supplier Mgmt
Vendor Catalogue Mgmt
Inbound Outbound Logistics
Maint. Eng.
Payroll
Time Clocking
Employee Master Data
Benefits
CRM
Training Management
Performance Management
Maintenance and Repair
Asset Register
In scope of Signaling Project
Account and Contact Mgmt
Campaign and Promotion Mgmt
Customer Database
Customer Analytics
Complaint Mgmt
Infrastructure
5
6
7
End-user Computers and Devices
Data Center
Communication Network
9
Passenger Sales
10
Comprehensive systems support of the Passenger
Sales processes encompasses a broad set of
Functional Building Blocks
Functional Building Blocks of Rail Sales
Management - Passenger
Offer Generation
Reservation
Sales
Strat. Planning
Prod. Service Definition
Payment
Sales Planning Pricing

• Timetable inquiries
• Price inquires
• (Price Quota Mgmt.)
• Inform about/ agree terms conditions display

• Availability-check of seats
• Validation of general quotas
• Seat blocking

• Reservation of seats
• Agreement of payment methods terms
• Generation of confirmation

• Strategic Planning
• Demand Forecasting Methodologies
• Sales Planning

• Product design definition
• Service design definition

• Planning and setting of fares for products
  services prices
• Definition of pricing scheme
• Zone
• Distance-based

• Determination of payment methods
• Cash
• Credit card
• Debit card
• Invoice
• Voucher

Ticket Validation
Ticket Issuing
Revenue Acc.
Revenue Mgmt.
Comm. Inform.
Support Functions

• Validation of ticket media

• Generation of tickets across different medias
• Print paper
• Codify cards
• Issue eTickets
• Produce code for machines

• Accounting and Reporting of key sales figures

• Manage revenues, i.e. yield management
• Adopt capacity
• Adopt prices
• Manage last minute offers

• User administration
• Ticket media administration
• Sales Device adm.
• Agency adm.
• Logging tools
• Recovery

• Information to passengers reg. timetable, e.g.
• Announcements
• Websites
• Visual displays

11
ENR is currently considering to deploy smart
cards for sub-scriptions and multi-ride tickets
only
ENR eTicketing Requirements
Implications to Consider
ENR Requirements
Sub-scriptions

• Replacement of paper with smart-cards only
• Interdependancies with other solution components
  (e.g. gates, sales systems, etc.)

• All subscriptions should be issued using
  smart-cards

Multi-ride Tickets

• Interoperability
• Sales system to support selling Cairo Metro
  tickets
• Inter-modal settlement required

• Multi-ride tickets (ENR and Cairo Metro) should
  be issued using smart-cards

12
Freight and Cargo system
13
The Functional Building Blocks of the Cargo
system are aligned around the processes of Sales
Management
Functional Building Blocks of Rail Sales
Management - Cargo
Offer Generation
Contract Mgmt.
Strat. Planning
Prod. Serv. Definition
Pricing Sales Planning
Order Mgmt
Capacity Mgmt.

• Sales according existing customer contracts
• Sales as addition to existing customer contracts
• Sales based on requests for information/ ad-hoc
  sales

• Administration if contracts related to the
  offered transport products and services

• Preparation and fine-planning of
• Transport Orders
• Service Orders
• Empty Cars Orders

• Strategic Planning
• Demand Forecasting Methodologies

• Product design definition
• Service design definition

• Planning and setting of fares for products
  services prices
• Pricing based on tons, kilometers
• Flexible combinations
• Discounts, etc

• Validation of required capacity on
• Network
• Rolling Stock
• Checking of addl train scheduling
• Reservation of capacity

Claims Mgmt.
Comm. Info.
Revenue Acc.
Billing
Revenue Mgmt.
Support Func.
Prepare Billing

• Support claims management of customers
• Investigation
• Determine compensations
• Initiate and process compensation

• Communication of train-status to
• Cargo SBU
• Customers

• Accounting and Reporting of key sales figures

• Compilation of the bill according to data of
  preparation
• Production of bills
• Distribution of bills

• Manage revenues, i.e. yield management
• Adopt capacity
• Adopt prices
• Manage last minute offers

• User administration
• Agency adm.
• Logging tools
• Recovery

• Arrangement of the billing relevant data.
• Compilation of billing relevant data of the
  contract / one-time agreement

Time Table
Prices
Products
Customers/ Contracts
14
Operations Traffic Management
15
system platform supports the Operations Traffic
Management processes
Functional Building Blocks of Operations
Management System
Engine Car Mgmt.
Ops. Controls
Ops. Support
Timetable Construction
Staff Mgmt.

• Plan for train composition (passenger and cargo)
  based on
• Supporting the forecasted demand
• Maximizing cars turnover
• Assign individual engines and cars based on the
  routes and forecasted demand

• Timetable real-time alteration based unplanned
  events such as disruptions, technical failures
  etc.
• Commercial prioritization of delayed train to
  reduce losses incurred from SLAs and connections
• Communication with CTC and operation control unit

• Reporting capabilities including
• Delays
• Issues
• KPIs
• Operations
• Distribution of relevant information to customers
  and staff i.e.
• Timetable update
• Crew rosters
• Ground-staff duties
• etc.
• Interface with Passenger Information System

• Develop a regular timetable based on the planned
  forecast (yearly activity)
• Update continuously the regular timetable to
  account for disruptions, maintenance etc. (weekly
  or daily activity)
• Run simulations to optimize the timetable

• Plan for duties and shifts supporting the
  timetable and the train composition of each route
• Develop crew roster
• Identify planned work-orders and plan for the
  required resources
• Allocate ground staff to specific duties in the
  yards, warehouses and workshops

Timetable
Assets (ERP)
Employees (ERP)
Shifts
Duties
16
The IT Project includes all systems required for
planning activities Signaling Project covers
all aspects of infrastructural operations
Train Operations Management
Operations Planning
Timetable Construction
Resource Management
Rolling Stock Mgmt
Operations Analytics
IT Project
Central Planning/ Local Access
Local CTCs
InformationDistribution(1)
CMS
Operations Control
Signaling Project(1)
Operations Control
Train Control(1)
Local Production
TrafficControl
TrainProtection
Shunting
(1) Signaling project incorporates the renewal
of signaling infrastructure and related updates
of Centralized Traffic Control (CTC) center.
Automatic Train Control (ATC) rolled out in
separate project. Renewal of information
distribution at Cairo Ramses Station is part of
another project
17
Enterprise Resources Planning
18
that need to be supported by key functional
modules of the according system platforms
ERP
Revenue Accounting
Revenue Accounting
Financial Management
Budgeting Forecasting
Intercompany Accounting
Controlling
Consolidation Legal Reporting
Business Intelligence
Financial Analytics
Corporate Performance Management
Supply Chain Management
Inventory Warehouse Management
Materials Requirement Planning
Inbound and Outbound Logistics
Procurement Supplier Management(Tender Mgmt.)
Vendor Catalogue Management
19
The numerous interfaces between the different
systems Ensure seamless integration
Overall Application and Interface Landscape
Description

• Revenue data of different sales systems (by
  revenue-driver)
• Sales data for Financial Accounting
• Historical data (sales, volumes, etc.) required
  for planning
• To Sales Capacity validation dataFrom Sales
  Planned sales data feeding into schedule
• To Ops Control Timetable data required to
  execute daily operation From Ops Control
  Timetable alterations data resulting from
  operations
• Real-time schedule data for information
  distribution
• Employee master data (e.g. vacation days, etc.)
• Maintenance schedule of engine and cars Asset
  master data
• Asset master data (e.g. cars layout, capacity,
  etc.)
• Car/ engine status data for maintenance schedule
• Real-time timetable data for staff planning
• Real-time timetable data for engine/car rostering
• Status data on schedule for information
  distribution
• Claims data forward to customer DB and vice versa
• Sales data to Data warehouse required for
  reporting

20
IT infra-structure
21
Infrastructure projects to support operational
systems
Data center Communication and network End-user
computers and devices
22
The Data Center is designed according to
established standards
Data Center Technology Overview
Key Design Dimensions

• An established industry standard is TIA-942
  Telecom Infrastructure Standard for Data Centers,
  published in 2005. it specifies requirements and
  guidelines for data center infrastructures and
  covers cabling distances, pathways, site
  selection, space, and layout

• TIA-942 specifies the following key functional
  areas in the data center
• One or more entrance rooms houses carrier
  equipment and the demarcation point
• A main distribution area (MDA) houses the data
  center's main cross-connect
• One or more horizontal distribution areas (HDA)
  houses horizontal cross-connects and is the
  distribution point for cabling to the equipment
  distribution areas
• A Zone Distribution Area (ZDA) a structured
  cabling area for floor-standing equipment that
  cannot accept patch panels
• An Equipment Distribution Area (EDA) houses
  equipment racks and cabinets in a hot aisle/cold
  aisle configuration to dissipate heat from
  electronics
• TIA-942 also provides a tier classification with
  specified availability and guidelines for
  equipment, power, cooling, and redundancy

Source The Three Principles of Data Center
Infrastructure Design, ADC 2006
23
ENR Network Infrastructure

• WAN LAN topology
• Net ware products and vendor selection
• Implementation approach
• Cost estimates
• Resources requirements

24
??????? ????? ? ???? ???? ? ?????? Thank you for
listening ?????? Muchas gracias Merci
beaucoup Vielen Dank ??????? ???????