Sonatrach is an Algerian government-owned company formed to explore the hydrocarbon resources of the country. It has some concessions in Libya, Mauritania, Peru, Yemen and Venezuela. Its diversified activities cover all aspects of production: exploration, extraction, transport, and refining


Marine department activity consists of executing offshore exploration campaigns.

To support a worldwide operations center, a new decisional solution had to be designed and deployed to:
• Follow up equipment supply chain for each campaign
• Control and monitor activity through KPIs for Financial, Human Resources, Purchasing domains.


Oracle BI Technologies:
• OBIEE 11g
• BIPublisher 11g

MS technologies:
• Power Pivot

Middleware technologies:
• Talend TOS
• Webservices Sharepoint

• Oracle Ebs R12
• Excel Files
• Essbase Cubes


Successfully launched new dashboards across business lines and geographies
• Quality control for all deployed equipment
• Head count based KPI’s
• Follow up of equipment shipping execution
• Financial KPIs

Improvement of data reliability
• Synchronization and coherence with ERP Oracle eBusiness Suite

meet the professionals

Related Cases