Cornerstone Overview - What have we been doing

Page 1


What Have We Been Doing? Starring:

James Dargan, Jacob Wheeler, Mark Abdoo, Alan Minton, David Summitt


What to Expect 1

Episode 1: The iQCX Platform

2

Episode 2: ResMarker & PCM

3 Episode 3: The “Exciting” & Technical Stuff 4

Episode 4: The iBank Platform


What did we do? •

Table enhancements

Schedules enhancements

Added Reporting capabilities

o Extended data columns from 10 to 20 o Ability to download only current page o Ability to download ResRules o Future Actions (Schedule Events) o o o o

6 new ticketing reports Transaction Count by Process Break by Schedule & Queue PNR Summary – by Date, by Agent Processing and QC errors


What did we do? • • •

Mobil accessibility 3rd Party Integration Information Links

What good things did you get? • • •

Ability to fit all information onto a hand held for easy view. A complete, multi­source trip management solution, with virtually no implementation effort One touch access to critical information via link i.e. weather, airport maps etc.


What did we do? • • • • • • •

Enhanced security Enhanced split and exchange capabilities Enabled split ticketing for ARC and non ARC ticketing in Wspan & Apollo Added ability to ticket off of PQ in Sabre Added ability to change TAW to reflect invoiced for car and hotel only bookings Enabled the ability to charge service fee to different card and store information in T remarks And many more!


Travets™


Travets™


Travets™


Travets™


Travets™


Travets™


5Â Facts 1

36Â deployments

2

749 enhancements

3

142,324,096 PNRs Processed

4

11,559,034 itineraries Delivered

5

3,597,958 tickets issues


Version 2.0 • • •

Added Amadeus Selling Platform Ability to open external text or HTML documents, or link to other URLs from a rule. Ability to open desktop email with pre­populated To:, CC:, Subject: and Body:

Version 2.1 • • •

Added Multi­GDS launch capabilities Added the capability of Multiple Roles on the desktop and ability to change roles. Added Variables for storing data

Version 2.2 • •

Introduced a Default Role so new users could install and Run with little configuration. Support for Sabre Red Workspace.


Click 2 Comply What did we do? • • •

Added ability to approve/decline directly from email Incorporated secure, one use links, with email confirmations Created customizable confirmation screens/emails

What Good things did you get? • • •

Streamline the authorization process into clients existing email workflow No longer required to login to the iBank to action authorizations Mobile travel authorization application


Security • • •

• • • •

Encryption in user tables Remove inactive user accounts every 90 days. Access Control: – no group, shared, or generic passwords. – user passwords changed at least every X days. – minimum password length of at least X characters. – enforce passwords containing both numeric and alphabetic characters. – do not allow an individual to submit a new password that is the same as any of the last X passwords used. – limit repeated access attempts Idle session of more than 15 minutes requires reactivation Authenticate all access to any database containing cardholder information. Use QualysGuard Suite Technology to self­certify PCI Compliant Contract with third party organization to perform an independent Vulnerability Threat Assessment


Internationalization • Currency conversion in iBank Travets • The addition of rail capabilities and cross data loading to iBank • iQCX Mail ­ numerous enhancements to support miscellaneous segment • Data Capture extensions especially Galileo and Amadeus – iQCX • Added foreign language capabilities • iBank/PCM ­ added German, French Canadian, Spanish • iQCX Mail – built templates for foreign language itinerary creation – French, Dutch, Chinese, etc.


Stability & Performance • • • • • •

New backup technology Virtual Machine clustering Addition of Border Gateway Protocol New backend storage array Upgraded to ColdFusion 9 Comprehensive power system upgrade


5Â Facts 1

66Â deployments

2

468 enhancements

3

591,571034 PNRs loaded

4

9,551,540 Reports Run

5

66% decrease in report run time


Rail Reporting What did we do? • • •

Normalized a Master Rail Database of Operators (136), Stations (71k), and Identifiers (122k) Enhanced our DataCleanser to map rail data to our Master Table Enhanced iBank Rail Reporting

What Good things did you get? • • •

Accurate Rail Reporting New Rail Reports Total control over mapping through the DataCleanser


Carbon Reporting What did we do? •

Added two new calculators: • CarbonNeutral • Offsetters

What Good things did you get? • • •

Additional global options for calculating carbon offsets: • CarbonNeutra • Offsetters User Defined Reporting Industry Mileage Table


Travets™


Special Thanks to


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.