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
Business Challenges
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
We look forward to working with the Jade Global team on other initiatives as this initial engagement has demonstrated their ability to deliver to schedule, budget and quality.