About the client

Essilor USA is a France-based international ophthalmic optics company that designs, manufactures and markets lenses to correct or protect eyesight. It is headquartered at Charenton-le-Pont, France.

Oracle Cloud Used

Oracle Cloud Infrastructure (OCI)
OBIEE,
Oracle Data Integrator,
Oracle Essbase Cloud

Business Requirements

Essilor USA was looking to upgrade their Oracle BI Applications from the de-supported version to the latest and greatest
Migrate complex Informatica ETL mappings and relevant BI components to ODI ecosystem
Enable business teams (Procurement, Finance, Projects Accounting, SCM, Sales & Marketing) with advanced BI dashboards
Enable Self-Service capabilities to grant access of the enterprise data to the power users

Download Case Study

Business Challenges

The migration from Oracle BI Applications 7.9 to 11.x requires re-implementation as there is no direct upgrade path possible

High dependencies on the upgrade with other critical in-flight projects like rollout to Florida hospitals

Lack of in-house ODI experts and longer migration path estimated

The Solution

Implemented InfatoODI automated solution for migration and upgrade of OBIA reporting environment
Enabled availability of newer modules made available in the latest versions of OBIA
Extended out of the box ODI loads and mappings to augment the enterprise data warehouse required for business insights
Implemented new role-based dashboards to meet the enterprise dashboarding
Enabled self-service subject areas that augmented enterprise dashboards for ad-hoc analysis needs of the power users

Benefits

Accelerated Oracle BI upgrade to 4 months from 10 months of original estimates
Automated workflows reduced costs and risk, and increased the process quality by 60%
Faster data and dashboards delivery, and increased end user productivity