Client Case Study

Financial Services

US East Coast Financial Services company moves from on-premises Essbase to cloud

PngItem_5313478

Financial Transformation

  • Industry

    Financial Services

  • Employees

    1200

  • HQ

    Rockland, Massachusetts, United States

  • Website

    www.qubix.com

  • Product & Services used

    Oracle Essbase, Oracle Cloud Infrastructure, Qubix Cloudbridge

Download case study

US East Coast Financial Services company moves on-premises Essbase to Oracle Cloud Infrastructure.

Our client is a full-service commercial bank headquartered in Massachusetts that offers a wide range of banking, investment, and insurance services to businesses and individuals through retail branches, commercial lending offices, investment management offices, and residential lending centres in Eastern Massachusetts and Rhode Island as well as through telephone banking, mobile banking, and the Internet.

Qubix has been engaged to migrate their existing Essbase estate from their on-premises 11.1.2.4 system to a new Essbase 19c environment running on Oracle Cloud Infrastructure. We worked closely with client users to understand the current reporting environment and its operational and maintenance pain points and handled complete application migration, development, and configurations.

In addition to a ‘direct’ migration, two further changes will be made to the end-state in the environment:

  • A development environment will be created in addition to the existing Production environment.
  • The existing administrator tools for the management of the application will be replaced. For metadata (i.e. dimension member) management, Qubix Cloudbridge will be used to provide a user-friendly, audited interface for making changes before deploying them to Essbase.

 

Challenges

  • Limited access to technical SMEs due to competing project priorities, mid-stride project manager replacement.
  • Changing governance and implementation approval steps/requirements throughout the implementation. 
  • The existing on-premises environment was not able to satisfy increasingly stringent FDIC security standards.
  • The client requested a zero on-premises footprint solution.
  • Load files presented two non-traditional scenarios that were submitted and acknowledged as bugs by Oracle:
    1. Double spaces were used as delimiters in their ledger’s auto-generated data files
    2. Upper case .TXT extension was not recognized, only .txt
  • The client's staff had little experience with application migrations and very limited  Essbase administrator skillset.
  • No support organization that could dependably maintain clients' on-prem Essbase application.

Solution

  • Implementation of Oracle Essbase 19c hosted on Oracle Cloud Infrastructure.
  • The final design leveraged a combination of the client’s legacy data migration tool and Qubix Cloudbridge to handle metadata and manage file movement in the cloud environment.
  • Custom scripts were developed to address challenging file scenarios in order to satisfy the needed deployment timeline.

Results

  • Successful migration to Essbase Cloud.
  • The inclusion of Cloudbridge in the overall solution simplifies the handling of model/metadata changes and its management can now be handled by functional client staff without being dependent on their (limited) IT support organization.
  • Oracle is continuously investing and improving the cloud platform including best-of-breed security features that satisfy FDIC’s requirements.
  • Availability of two environments - TEST and PRODUCTION - facilitates the qualifying of application changes prior to deployment.
  • The dual environment also provides client with a fallback system which was a significant risk in their prior single instance on-prem scenario.

Share

Why did the client choose Qubix?

" Qubix was able to show us the benefits of migrating to the cloud, and now we are enjoying a stable reporting application that is easily maintainable, complies with Federally mandated security standards, has the fallback capability and future upgradeability. "

 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 SEO
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