Menu
Discuss a project
Book a call
Back
Discuss a project
Book a call
Back
Back

Colibri Secures Live Sales Management (LSM) Platform

Rail Settlement Plan Limited (RSP) delivers essential services such as ticketing, travel information, and refund processing on behalf of its member companies. The Live Sales Management (LSM) platform (hosted on AWS and managed by Colibri) supports National Rail’s Ticket on Departure service, enabling customers to purchase tickets online or via third parties and collect them at their convenience.

Client
National Rail
Duration
Date
Partner
AWS

The client

A core component of LSM is its reconciliation process, which compares ticket sales with actual ticket issuance. This provides RSP and its retailers with vital data to accurately calculate profit and loss from ticket sales.

During a routine service review, Colibri identified several risks within the LSM reconciliation process that could compromise the platform’s security and reliability. The Reconciliation Risk Removal project was launched to address these issues and ensure continued operational stability. Key risks included:

  • Use of an outdated Infobright database version no longer supported by AWS.
  • Excessive use of AWS access keys in the configuration, increasing the risk of credential exposure.
  • Dependence on an outdated AWS SDK version, which risked incompatibility with future AWS updates.
  • An SFTP server requiring both operating system patches and an instance-type upgrade.
  • Use of a legacy EMR Hadoop/HIVE version to process large datasets.

Each of these posed a significant threat to the reconciliation process, potentially causing failures or delays in report generation. Such disruptions could have serious consequences for ticket retailers and train operating companies across the UK.

Solution

Giuliano Marrone
Senior Service Manager, Rail Delivery Group (RDG)

"RDG and Colibri have worked closely together for several years, consistently delivering solutions that strengthen and enhance the LSM processes. The goal of this project was to reduce risk, improve flexibility, boost efficiency and performance, manage costs, and future-proof the platform for RDG’s LSM service. This kind of innovative thinking and expert guidance is why we continue to trust Colibri with our cloud infrastructure. The reconciliation process is a critical part of the service we deliver to our customers, and this migration has not only lowered our costs but also increased visibility and opened the door to new opportunities. It has also improved efficiency and reporting capabilities across the TOC and TIS communities."

Mitigating risks with a calculated migration

Colibri’s in-depth analysis revealed that re-platforming the existing codebase, alongside updating the underlying AWS infrastructure, would effectively resolve all identified risks, without causing service disruption.

To ensure a seamless transition, the team designed and managed a carefully orchestrated migration, implementing the following key changes:

Infobright database: Migrated all reporting data to an AWS Aurora MySQL Serverless instance for improved performance and supportability.

AWS access keys: Replaced access keys with instance-based permissions across all LSM components, significantly reducing security risk.

AWS SDK: Repackaged the reconciliation code to ensure all AWS interactions used the latest SDK versions, improving compatibility and resilience.

SFTP server: Enhanced the isolation of the SFTP service within LSM, paving the way for a full rebuild (handled separately as part of an ongoing project).

EMR/HIVE: Upgraded from a legacy EMR image, including removal of deprecated roles, to ensure continued support and improved processing of large data sets.

These updates strengthened the LSM reconciliation process, enhancing its security, stability, and future readiness.

Results

Across-the-board enhancements

Beyond resolving the identified risks, the new solution significantly enhanced security, performance, resilience, and cost-efficiency.

Reliability
Migrating the Infobright reporting database from a hosted EC2 instance to AWS Aurora MySQL Serverless eliminated infrastructure, OS, and database risks. As a serverless model, it also reduced costs by charging only for usage.

Resilience
The move to serverless Aurora simplified disaster recovery, cutting Return-to-Operation time from over 12 hours to just 30 minutes in the event of a service failure.

Security
Replacing access keys with instance role permissions reduced the risk of credential exposure. Increased isolation of the SFTP service further improved overall system security and provided flexibility for future enhancements.

Cost reduction
Decommissioning the EC2-hosted Infobright instance and adopting a serverless, event-driven architecture lowered licensing and support costs. The EMR upgrade also led to a notable reduction in compute expenses.

Performance
Optimisations reduced EMR processing times by approximately 2 hours and cut report processing by 3–4 hours. Overall, the full reconciliation process now runs in 2–3 hours, down from 8–9.

Observability

Amazon CloudWatch was implemented to provide real-time monitoring, alerts, and detailed performance metrics. The restructured code also supports improved auditing and traceability across the platform.

Our solution

The outcome

Faster insights

Reduced to within 6-second lead time

Improved customer service

Faster predictions on customers' needs and capturing new opportunities

Team growth where it matters

+ 20 headcount in the data team

What others have to say

name
Job title goes here
Company name
SOLUTIONS

Scalable solutions to grow with your ambitions

Explore more
SOLUTION 1
Marv Gillibrand
Head of Product

Strategic advisory

Unlock growth, efficiency and innovation through data and AI

SOLUTION 1
Jared Magrath
Head of Data Practice

Data and analytics modernisation

Turning raw data into actionable, competitive insight

SOLUTION 1
Ben Wheeler
Head of Cloud Engineering

Enterprise modernisation

Modernise with purpose. Transform with data. Scale with AI

SOLUTION 1
Gelareh Taghizadeh
Head of AI and Data Science

Enterprise AI

Intelligent solutions built for real-world business impact

SOLUTION 1
Tracy Powell
Head of Managed Services

Cloud services

Empowering cloud-first operations with confidence

More Colibri success stories

B2B
B2B

Leading the AI revolution: A blueprint for realtime data

Colibri Digital partnered with Nomo Fintech to pioneer AI-driven fintech revolution. Together, we built a serverless data lake which resulted in real-time data processing, enhanced analytics, agility for innovative projects and more.

Consultancy
Consultancy

Top Tier Consultancy: Big Data Strategy and Architecture Vision

In 2015, a top-tier consultancy partnered with Colibri Digital to grow its London-based Big Data division. Colibri supported the company’s Fortune 500 clients on key initiatives, including retail analytics, IoT-driven maintenance for semiconductor manufacturing, and power supply optimisation across Europe.

Healthcare
Healthcare

Cloud-Native Expertise Ships Somark's Latest Product

Somark, a pharma-tech company, has spent the past two years trying to deliver an Azure cloud-native application to its clients in production. Colibri was approached to perform an architecture and security review and help push the application over the line.

Business Services
Business Services

Cloud Data Warehouse Improves Conversion Rates and Sales Intelligence

Regus, a leading multinational provider of white-label office space, needed a new way to track the conversion of sales leads to optimise its sales pipeline. Currently, the sales process is tracked across a multitude of in-house and third-party hosted Software as a Service (SaaS) system, making it incredibly difficult to trace an enquiry from source to conversion.

Financial Services
Financial Services

Dynamic Data Ingestion Offers Market-Leading Pricing Intelligence

Hiscox, a leading provider and underwriter of specialist insurance services, wanted a mechanism for performing real-time price comparison and market intelligence against their competitors in the UK market.

Energy
Energy

Cloud and Big Data Delivery Expertise Accelerates Delivery of New Analytics Platform

Colibri worked with Shell, one of the world's largest oil and gas companies, to deliver an Azure advanced analytics stack for its global lubricants business. Shell was struggling to design a solution capable of processing vast quantities of dirty data from various sources.

Education
Education

Ed-Tech Start-Up Unlocks New Strategies for Data-Driven User Engagement

Mana, a London-based ed-tech startup, was stepping into the next phase of its growth journey. The client's platform provides a curated directory of experts, which mainly includes tech leaders, career advisors, lifestyle gurus, and teachers. It allows users to bring content from YouTube, Instagram, Udemy, TikTok, and other platforms into a portfolio for their followers.

Financial Services
Financial Services

Cloud Architecture Redesign Ships New Digital Banking App for a Tier 1 European Investment Bank

The client, a leading Tier 1 European investment and retail bank, was creating a new digital banking app. With its enormous client base and highly sensitive data, the app’s backend was complex and required careful planning from a DevSecOps standpoint.

Hospitality
Hospitality

Enhancing Digital Services with AWS

Center Parcs UK and Ireland, a leading provider of family forest retreats, needed to upgrade its digital services strategy to improve online customer experiences while ensuring security and cost efficiency.

Hospitality
Hospitality

Strengthening Cloud Security with Root Login Monitoring

Center Parcs UK and Ireland, renowned for its family-friendly forest retreats, sought to improve the security of its AWS environment to meet stringent industry standards and ensure operational integrity.

Hospitality
Hospitality

Simplifying Security with Auth0 Migration

Center Parcs UK and Ireland, known for its family-friendly forest retreats, required an upgraded identity management solution to enhance security and meet growing demands.

Energy
Energy

Spanish Power Grid Predicts Outages with AWS

Spanish Power Grid provides critical energy and utilities for the nation. The variation in geography and weather across Spain meant that power generators needed to provide stable output in a wide range of conditions, creating complex operational requirements for the company. Outages were highly undesirable and penalised by the hour by the national regulator.

Financial Services
Financial Services

Azure Big Data Expertise Ships New Fraud Detection Platform

Ageas, one of the world’s largest insurance companies, processes an enormous number of daily requests for insurance quotes as well as underwriting approvals. Sometimes exceeding 5,000 requests per second, each of these requests needs to be screened by increasingly sophisticated algorithms to ensure validity and detect potential cases of insurance fraud.

Business Services
Business Services

Cloud Native Data Warehouse Delivers Cutting Edge Advertising Insights to the NHS

Fendix Media, a digital media agency, prides itself on offering unrivalled digital access to the NHS, assisting trusts with direct revenue generation through the placement of targeted adverts across the NHS intranet. Over the last couple of years, Fendix Media have grown rapidly and now offers digital media products to almost every major NHS trust in the UK.

Financial Services
Financial Services

New Serverless Data Analytics Platform

BB2, a startup financial firm based in London, had built a new digital bank on AWS using cloud-native technology, real-time streaming data feeds, and serverless components. Creativity and innovation have always been the cornerstone of BB2’s business model, and the bank is keen to reinforce this value through innovative digital and electronic banking services.

Developer Tools
Developer Tools

Azure Native Data and Machine Learning Architecture Accelerates Growth

Digital Taxonomy's client base continues to grow, rapidly attracting several large blue-chip enterprise clients, each bringing their complex requirements. Colibri Digital were approached to undertake this review, and to provide advice, designs, and implement solutions to ensure Digital Taxonomy were optimally positioned for their next phase of growth.

Hospitality
Hospitality

Overhauling Backup Technology to Future-proof a Leading Leisure Business

Center Parcs continues to grow and evolve, but its Arcserve tape backup solution had become outdated. They were costly, slow to restore from, and unable to meet the demands of a growing dataset.

Transportation
Transportation

Building a Cloud-Native Car Platform for Secure, Accessible Data

Jaguar Land Rover (JLR), a leading British manufacturer of luxury and sport utility vehicles, designs and develops vehicles under the Jaguar and Land Rover brands. To gain deeper insights from vehicle data and enhance both efficiency and competitiveness, JLR partnered with Colibri to design and build a tailored data platform capable of delivering actionable intelligence.

Transportation
Transportation

Hosting and Support Solutions for Eurostar to Reduce Downtime and Mitigate Risk

Since launching in 1994, Eurostar has transported over 150 million passengers, moving thousands beneath the Channel each day. To support its mobile booking and overbooking applications, Eurostar needed reliable hosting and support solutions.

Transportation
Transportation

Improving AWS Infrastructure for the National Rail Network

The NRE Modernisation (NREM) project, delivered in partnership with Train Information Services Limited (TISL), involved the redesign, build, and deployment of the AWS infrastructure supporting the latest version of the National Rail Enquiries (NRE) applications. NRE, operated by RDG, provides essential information on train times, routes, and fares for passengers across the UK rail network.

Transportation
Transportation

Colibri Guarantees Secure Customer Access to Essential Ticketing Platform

The Live Sales Management (LSM) service is a key component of the Ticket on Departure feature offered by National Rail, part of the Rail Delivery Group. It enables customers to purchase tickets online or via third parties in advance and collect them at their convenience. Managed by Colibri, LSM plays a vital role in improving both customer convenience and operational efficiency.

Transportation
Transportation

Colibri Implements New Security Features for Cloud Services

The Rail Delivery Group (RDG) unites Britain’s railway operators under a single organisation, aiming to deliver meaningful improvements in the customer experience. Colibri hosts several AWS-based services for RDG, but historically, each required separate credentials per user, creating both administrative complexity and security challenges.

Transportation
Transportation

Colibri Delivers an Improved Service Desk Experience for RDG’s Rail Data Marketplace

Over the past decade, Colibri has partnered closely with the Rail Delivery Group (RDG) to deliver essential services such as ticketing, travel information, and refund processing. This latest collaboration supports RDG’s Rail Data Marketplace (RDM), with Colibri providing service management capabilities.

Transportation
Transportation

New Analytics Platform to Track Costs and Performance of Business-Critical AWS Workloads

Colibri has built a strong, long-standing partnership with Rail Delivery Group (RDG), supporting the AWS-hosted applications and services that power its digital solutions. Most recently, Colibri deployed a new analytics platform to monitor the performance and cost-efficiency of these critical AWS services, ensuring they remain optimised, reliable, and aligned with RDG’s strategic goals.

Transportation
Transportation

Transforming Legacy Ticketing Systems to Deliver Cloud-Based Digital Services

As the industry moves towards digital, customer-first experiences, Rail Delivery Group (RDG) partnered with Colibri to modernise its legacy infrastructure and deliver cloud-ready solutions fit for the future.

Transportation
Transportation

Enabling Data Processing and Real-Time Customer Access with a Cloud-Based System

The Rail Delivery Group (RDG) brings together all the UK’s passenger and freight rail companies, High Speed 2, and Network Rail to work towards a shared goal: delivering a better railway for customers across Great Britain. As part of a recent initiative, RDG aimed to help National Rail Enquiries provide passengers with more accurate, real-time train location information.

Transportation
Transportation

An AWS Solution that Improves Connectivity and Enhances the Customer Experience

The Rail Delivery Group's (RDG) customers were facing performance issues with the National Reservation System (NRS) due to latency caused by the legacy Multiprotocol Label Switching (MPLS) network.

Transportation
Transportation

Colibri Enables AWS Cost Savings and the Flexibility to Meet Demands

The Rail Delivery Group (RDG) operates a large AWS estate managed by Colibri. In the wake of the COVID-19 pandemic, reduced passenger numbers and falling ticket revenue meant cost control became a top priority. With existing Reserved Instance (RI) plans nearing expiration, RDG saw an opportunity to reassess their approach and explore AWS's newer Cost Saving Plans to ensure long-term value.

Transportation
Transportation

Colibri Migrates RDG's Legacy Database to a New Cloud-Native Digital Architecture

Rail Delivery Group (RDG) provides the essential services and support needed to help its members succeed, from national ticketing and reservations to information systems for passengers and staff. A key part of this is the Live Sales Management (LSM) database, which has long been hosted on AWS EC2 instances. While the system performed well, it presented limitations during failure events and required ongoing manual management.

Not sure where to start?

Can’t find the answer you’re looking for? Please chat to our friendly team.

Discuss a project