Oracle BI Application upgrade for maximized ROI | Jade

About the Client

Rambus Inc founded in 1990, is an American technology company that designs, develops, and licenses chip interface technologies and architectures that are used in digital electronics products.

Oracle Platforms Used

  • Oracle BI Applications
  • OBIEE
  • Oracle Data Integrator
  • Oracle EBS

Business Requirements

  • OBIA Upgrade Testing
  • Fix ETL and Data Mismatches
  • Sub Ledger Load performance Tuning
  • ETL Dashboard
  • Usage Tracking Dashboard
Download Case Study

Business Challenges

ROI

Seamless testing of BI platforms from multiple sources like PMO, EBS and flat files

ROI

Major performance hurdle in sub ledger reporting

ROI

Sub-Ledger state data appearing in the reports

The Solution

  • Tested around 375 reports and major critical reports
  • Fixed Informatica connectivity issue which helped in PMO migration to Production
  • Setup of Dev and QA environment
  • Implemented sub-ledger incremental logic which brought down the load process from 6.5hrs to 10 minutes.
  • Delete capture implemented to get rid of stale sub-ledger data from reports
  • Helped setup a standard process for development and migration activities

Benefits

  • Jade Global helped Rambus to validate their processes by comparing data from multiple sources and the upgraded environment
  • Personification report helped Business keeping track of the impersonators. Now they have proper control on the usage of the BI platform and now anyone cannot just impersonate and view confidential information
  • Standard Process implementation helped business reduce development time and development costs
Back to Top ↑