Sonatrach

Sonatrach

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

Challenges

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.

Solution

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

MS technologies:
• SSAS
• Power Pivot

Middleware technologies:
• Talend TOS
• Webservices Sharepoint

Sources:
• Oracle Ebs R12
• Excel Files
• Essbase Cubes

Results

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