Optimizing on-premise BI Applications leveraging OAC and ADW | Jade

About the Client

Transaction Network Services (TNS) is a privately held, multinational company that has been in the payments, financial and telecommunications industries. TNS is the supplier of networking, integrated data and voice services to many organizations in the global payments and financial communities, as well as a provider of telecommunications network solutions to service providers.

Oracle Cloud Used

  • Oracle Analytics Cloud (OAC)
  • Oracle BICS
  • Oracle Cloud DB
  • Oracle Fusion ERP Cloud
  • Oracle Planning Cloud
  • Oracle Data Sync

Business Requirements

  • To migrate existing on-premise OBIEE/OBIA to Oracle BI Cloud solution for monitoring performance across the enterprise with the goal of reduce spending
  • Primary Objective is to deliver a centralized reporting for following Analytic Solutions
    • Lift & Shift of Existing Custom BI
    • Reports
    • FP&A Reporting
    • Financial Analytics (Oracle GL, AP, AR
    • Profitability, Sub-Ledger Reporting)
    • HR Analytics
    • Procurement & Spend Analytics
Download Case Study

Business Challenges

ADW

To reconcile and manage data and metadata which resides in the Oracle ERP and other reporting/transaction system using EXCEL/Spreadsheets

ADW

There is no true Ad Hoc, drill down analysis that can be performed due to the manual nature of the forecast and budget processes

ADW

Integration is quite complex - Budgeting & Forecasting and Actuals come from different sources

ADW

Drill-down capability and analysis to Oracle sub-ledgers

The Solution

  • Jade Global’s accelerators and agile-hybrid methodology helped Sunflower teams identify the required metrics and potential executive dashboard designs
  • Design & build (ETLs and Data Models) and deployed Custom Reporting solution by Integrating Budget/Forecast and Actuals (FP&A Reporting) with Currency Translations and PBCS based Scenarios
  • Created multiple data-models from scratch to perform historical and drill-down analysis based on single and multiple source data
  • Published multiple Financial Income Statement Reports based on FSG structures and Aging Reports

Benefits

  • Helped their IT road map to Cloud Reporting
  • Automated FSG hierarchy changes to BICS
  • Integrated Reporting on Cloud and On-Premise (ERP+PBCS)
  • Sub-Ledger Accounting allows the user to go deeper into more specific layers of the data or information being analyzed

"Jade Global was proactive, was prepared with their accelerator toolkit including documentation, best practices and solutions to help us with a smooth transition. We are extremely pleased with their level of commitment, flexibility and drive to make us successful"

Back to Top ↑