Client Case Study

Allied Irish Bank

Achieves greater financial visibility in their planning and forecasting by moving to the cloud

AIB Logo

Financial Transformation

  • Industry

    Retail Banking

  • Employees

    10,000

  • HQ

    Dublin, Republic of Ireland

  • Website

    https://aib.ie/

  • Product & Services used

    Oracle EPBCS, Qubix Journey to Cloud

Download case study

Allied Irish Bank delivers financial visibility and reduces risk by moving to cloud planning and budgeting.

 

Allied Irish Bank (AIB) is a financial services group operating predominantly in the Republic of Ireland and the United Kingdom. AIB provides a comprehensive range of services to personal, business and corporate customers in target markets and have leading market shares in banking products in the Republic of Ireland.

AIB recognised that improving its planning, budgeting and forecasting processes was a key element in delivering the financial visibility required to drive its growth strategy within the bank's appetite for risk. For this reason, long-term strategic planning and forecasts was an important area of focus in this engagement. AIB's current process relied on large and complex Excel models used by its numerous business units. Moreover, the number of spreadsheet models made the consolidation of data very difficult and time consuming. The underlying assumptions were not consistent and widely understood across the group.

 

"…the things we will be able to do that we were not able to
do before will include (a) Streamlined loading of actual data
(b) Much quicker turnaround time for running a version of
the plan (c) Capability to do rolling forecasts in a
streamlined and structured way, significantly cutting down
the time to do it (d) Significantly less operational risk than
running a planning process in Excel."

Headshot - Cyril Brennan

Cyrill Brennan
Head of Financial Planning and Analysis

 

The overall design and implementation of Oracle EPM Planning Cloud (PBCS) allowed AIB to address the issues that existed in the current models and processes. This began with a discovery phase to understand the challenges faced by each of the business areas (Mortgage, Credit, Deposit, Treasury, etc.) and legal entities (UK and US) to develop an "as-is" and "to-be" functional specification that ensured the solution delivered fit the unique needs of AIB. Qubix implemented the application using a "sprint-based" approach, releasing functionality every 3-6 weeks. The delivery was split across 7 Sprints, each sprint including weekly ‘Show & Tells’ and an end of sprint conference room pilot.

This engagement leveraged Qubix's Journey to Cloud methodology to achieve their finance transformation objectives - a best practice approach that combines our deep industry and technical expertise to design, implement and manage your migration to the cloud.

 

Challenges

  • Large cumbersome spreadsheets and the inherent issues this brought including:
  • Time-consuming and resource-intensive to run the Planning process.
  • Lack of transparency of process and data.
  • Only one user is able to work on one spreadsheet at a time.
  • Risk of spreadsheet errors and file corruption.
  • Time-consuming and complicated to implement process changes.
  • Difficulty in managing version control for what-if planning, multiple submissions and reporting on what if variances.
  • Unable to complete monthly Forecast at the required level.
  • Time-consuming during the aggregation of data from all business lines into a consolidated view due to the number and size of spreadsheets.
  • More time spent managing the process than analysing the data.
  • Loading and managing source data in spreadsheets

Solution

  • Implementation of Oracle EPM Planning Cloud Service (PBCS)
  • Qubix Journey to Cloud Methodology to accelerate delivery to the cloud

Results

  • Improved data accuracy and user confidence in the Plans and Forecasts.
  • Eliminated reliance on the large complex spreadsheets and minimising the inherent issues spreadsheets brought.
  • Reduced time in managing the process and more time to analyze data, the Planning tool does all calculations and aggregation of data.
  • Reduced effort in completing the Planning process with the elimination of manual processes.
  • Increased data transparency throughout the Planning process, Centre Team who have visibility of the Plans and Forecasts as they are created.
  • Standardised assumptions that drive the Plans and Forecasts for each product area and these are understood by the business.
  • Ability to create monthly rolling Forecasts at the required level.
  • Processes aligned across Legal Entities, providing a common understanding of how Plans and Forecasts are created.

Share

Why did AIB choose Qubix?

" Qubix provided pragmatic solutions and their PBCS knowledge and ability to execute on PBCS is very strong. The project executed in a smooth manner and Qubix were excellent overall. "

Logo Icon - AIB

Gareth Keenan

Chief Data Officer

 Related case studies

How we create client success

Luceco plc products
Finance Transformation

Finds consolidation and reporting efficiency in the cloud

Luceco plc ensures trust and confidence in their reports by reducing their dependency on spreadsheets with Oracle EPM Cloud Consolidation and Close.

Read case study
HS Featured Image - Hyde Housing
Finance Transformation

Streamlines their planning and budgeting processes in the cloud

London's largest housing association partners with Qubix to migrate their on-premises planning and budgeting application to Oracle EPM Planning Cloud in only 3 weeks for new efficiency, scale and insight.

Read case study
Case Study Page - Ocado
Finance Transformation

Adopts planning and budgeting in the cloud to scale for hyper-growth

Ocado adopted integrated planning, budgeting and forecasting solution covering finance, supply chain, and HR to support new business growth.

Read case study

Get in touch with Qubix

Please share some details with us, and we'll get in touch as soon as we can.

Contact Us