From Data Migration to Optimization: The Full Project Lifecycle of MCT

(1)

CONNECT . COLLABORA TE. INNO V A TE.

From Data Migration to Optimization:

The Full Project Lifecycle of MCT

Marco Fehmer, DSP General Manager

(2)

Nice to meet you

Marco Fehmer

DSP - General Manager

Since 1986, DSP provides IT solutions and business operations consultancy for the shipping industry. DSP is certified NAVIS Implementation Partner and First Line Support Centre

DSP is active on international TOS projects and collaborate with industry key players

TOS Professional Services  Project Management

 Data migration

 Installation and Configuration

 Product Trainingand Best Practice

 Go-Live assistance

 Field Development

 Operations Shadowing

 First line Maintenance & Support

 NAVIS SPARCS Optimisation: Prime Route, Expert Decking, Autostow

 Automation Integration

(3)

MCT January 30

th

2015

Contship Italia Group’s MEGA-HUB in Gioia Tauro, received the largest ever containership to call at a port in Italy. MSC London 184.100 tons

16.652 TEU

(4)

“Performance levels at Contship' maritime terminals continue to be stretched in support of our valued customers.

During the first AM1 service call in Gioia Tauro, a record performance was achieved by Medcenter Container Terminal (MCT) on m/v MSC Bettina. Berth operations involved over 5,000 moves and during the third shift of February 17th on crane 19, our MCT team handled 237 container in just 5.5 hours for a Gross Crane Productivity (GCP) of

43 moves/h

.”

(5)

MCT Med Center Container Terminal

3.391

mt berth 1.600.000 sqm yard

22

Quay Cranes

110

Straddle Carriers 1.200 employees

3.5

Mio TEU

(6)

Past Functional Architecture

COSMOS

EDI Data interchange layer

HR Roster Reporting and KPI Terminal Dashboard PDS Customs Reefer Web Access Technical Department Finance, Treasury, Accounting, Cost Control, Purchase, Warehouse

CTCS SPACE TRAFFIC SHIPS

Payroll, Access Control, TVCC, ….. Custom System Billing

(7)

TOS Functional Architecture

SPARCS N4

BILLIT Tariff and

billing

Data interchange layer HR Roster Reporting and KPI Terminal Dashboard PDS N4 Extensions Reefer Technical Department Finance, Treasury, Accounting, Cost Control, Purchase, Warehouse Container Control (bookings, Bill of Lading, Holds, Inspections) Yard Planning Ship Planning Rail Planning Berth Planning ECN4 _{Optimisation:} Prime Route Expert Decing Autostow Payroll, Access Control, TVCC, ….. XPS Custom System N4 Mobile Customs EDI Web Access N4 Integration

(8)

Project Scope

SPARCS N4

BILLIT Tariff and

billing

Data interchange layer

Container Control (bookings, Bill of Lading, Holds, Inspections) Yard Planning Ship Planning Rail Planning Berth Planning ECN4 _{Optimisation:} Prime Route Expert Decing Autostow XPS N4 Mobile N4 Integration N4 Extensions

(9)

Project Team

NAVIS • Support • N4/XPS consultant • N4 Field Developer • Optimisation consultants • Infrastrcture consultant Contship Italia • Operations Support • IT development MCT • Project Manager

• Operations Key Users • IT developers • IT systemist DSP • Project Coordinator • N4 Consultant • XPS Consultant • N4 Field Developer

(10)

Approach

1 SANDBOX

2 WOODBOX

3 BRICKBOX

4 CRYSTALBOX

Delivery of solutions Integration End-to-end process tests Final training Procedures approval Soft Go Live Go Live

Post Go Live Support O&A

GAP analysis Solution design

(interfaces, modules, …) Project plan definition Core N4 configuration Key users and project team training Procedure reviews In house SW Development N4 configuration and customization Interfaces

Test cases definition Tests by modules Tuning requirements IT infrastructure

Data Migration strategy

Tuning of operations process

optimisation (i.e. SC global pooling) Role assessment Yard Planning Strategy

(11)

Key Milestones

Feb 2013

Kick off meeting

Jan 2014 DSP Billing System Go Live Jun 2013 Feb 2014 SN4 2.5.6 SN4 2.4.3.4 SN4 2.5.9.2 May 2014 Soft Go Live Wi Fi Go Live 12th June 2014 Go Live SN4 2.5.2.1 2.5._6.1

sandbox woodbox brickbox crystalbox

Oct 14 8 months 5 months October 2014 Upgrade 2.5. 13 8 months 5 months

(12)

Challenge

General risks

 Day by day business. Terminal is working H24 at high capacity

IT Infrastructure

 New

Wi-Fi

deployment

 Hardware architecture to be renewed (from AS400 to

Microsoft

platform)

EDI concept



EDI

engine in house product

 Business logic out of N4 (no business rules)

Training

 Huge number of users to be trained

(13)

EDI

Elements:

N4 Integration

Development Tools: Java, Spring, Hibernate, Quartz Scheduler

Application Server: Tomcat Database: PM,JEDI,JTOS

JMS Queue Manager: ActiveMq (open sourse)

(14)

Challenge

Interfaces and integrations

 Interface with in-house operational

monitoring

systems

 Connection to exisiting

Customs

system on AS400

 Interface with Maintenance Department



Reefer

management



GPS

and PDS integration

New automated billing system

(15)

Main Gaps



_{MULTI TRAILER}

Management

(in house development + ECN4web)



Split move concept (

state model – yard move filters)



Prevent 4th tier SC to serve older and smaller QCs (

groovy

)

(16)

(17)

Infrastructure stress test @ 3.5 Mio Teu

XPS N4 clus te r EC N 4 Da ta bas e

3.5 Mio TEU avarage peak reccomandation

N4 center and cluster 17% 35% nn

XPS 33% 66% nn

ECN4 20% 27% nn

Database 30% 40% 24 CPU Cores - 64 Gb RAM - 1.5 TB Disk Phisical hardware for SQL

(18)

The Go Live Chronicles

(19)

16 months : from kick off to go live

40.000 hrs : Total man hours deployed

1.200 : Number of MCT people trained

1 pm

: Stop of commercial operation

2 hours

: Data Migration

35.674 : Containers in yard migrated

7 pm

: Go Live with NAVIS N4

(20)

Go Live Strategy



Complete vessel operations along quayside



Send EDI



Stop all activities



Data Migration



Legacy software parameter changes



Switch of first pool of equipment RDTs to ECN4



Check of data migration

(21)

Customer is always right

Intial Go Live plan has been

re-worked

2 hours before stop of operations Strong pressure from the customer forced to add a new Vessel to initial go live planned scenario:

• Discharge shall be completed with Cosmos

• Load shall be performed with N4 (…..think about restows, EDI, customs declarations)

(22)

(23)

Ship Planners

Ship planners had to change their habits:

 From «stand alone» to real time operations

 Setting up the

Quay Commander

 Monitor the paper process quayside

(24)

Drivers and Checkers

SC Drivers

:

 With Cosmos they pushed for instruction, with XPS they are pooled by the system

 Initial Job stepping unreliability

Hatch Clerks

:

 Hard to monitor their actions and support them

 All system warning should have been translated in Italian

 Differente habit, tally in real time, not stick on paper and than update off line in checker cabin

(25)

IT systemists

AS400 (i5) mainframe is a different in respect of

Microsoft

Server and Microsoft

SQL

Server

IT Infrastructure is not running in the backgroung anymore shall be

maintened

and

monitored

Some example:

• Database crash  MS SQL Server patch to be applied

• Temp DB oversize: stop of updates  DB crashed  huge queue of messages from XPS that took hours to recover

(26)

Post Go Live

To reduce risks,

OPTIMISATION

and planning strategies updates/changes have been postponed, waiting for personnel to be confident and pratical on N4

 review

yard planning strategy

(from SPACE to Expert Decking)

 Pooling by Vessel as a must

 decrease of yard

shiftings

by use of weight classes and weight inversion penalties

 Fill the training weakness

(27)

Next Steps

Global

Pool

ing

 Review of terminal viability to facilitate mix of SC flows from to yard/berth

 Equip all SCs with new radio (automatic group switch)

 Tune PR parameters

Optimised discharge load transition

 dispatching of load moves before completion of discharge (double

cycling) shall be enabled automatically accordingly to each QC buffer capacity

(28)

Larned Lessons

 do not underestimate the role of the

IT systemist

and the key role that infrastructure plays on terminal perfomances



TRAINING

to end users performed by terminal key users shall be double checked. Collecting signatures «I was there» is not enough, better request a formal certification/exam

 Staff properly the TOS team, with special attention to Post Go Live support

(29)

Thank you for your attention!

Meet us at DSP booth Contact us: www.dspservices.ch [email protected] Linkedin DSP