Objective
Develop a platform for the management of information flows from each of the more than 350 companies of Petróleos de Venezuela, S.A. (PDVSA) to the headquarters and the automatic generation of financial and operational regulatory reports to be submitted to the Board of Directors of PDVSA-CITGO and the national and foreign regulatory entities.
Overview
Venezuela, as a member of the OPEC (Organization of the Petroleum Exporting Countries), must comply with a vast and rigorous regulatory, which requires PDVSA-CITGO to periodically submit a large number of financial and operational reports that in turn are validated by an external audit (KPMG).
PDVSA-CITGO has an SAP platform for the management of its operations in each of the group’s companies that are not unified, so regulatory reports are delivered late and with poor data quality.
Our team worked with PDVSA for 4 years with more than 50 resources on site and 10 resources offshore and completed the following tasks:
A diagnosis of corporate BI was conducted and based on requirements, Open Source BI components were implemented, thus enabling comparison with private world-class platforms. Based on the findings and results of Adagio’s analysis and diagnosis, PDVSA selected Pentaho as their unifying BI platform for all groups.
Several analytical modules were implemented for strategic and operational management, including the analytic management of Internal Audit, Finance, Sales, Financing and Operations (upstream and downstream).
The implemented Corporate Integration Bus allows the dynamic and parametric configuration of the flow of processes and business rules, as well as the early detection of opportunities to improve the integration process. Technology: Pentaho, Bonita, MariaDB, WSO2, Red Hat and other technologies. In addition, we implemented the Treasurer and Financial Cash Flow in a new platform based on Microsoft and Pentaho technology for ETL processes using Pentaho (PDI, Reports and Dashboards), MariaDB, Bonita and WSO2.
Outcome
The new platform allowed PDVSA-CITGO to reach the regulatory requirements and also allowed it to audit its own information flow process, obtaining an almost real-time knowledge of the productive matrix of the group and the profitability of each of its companies, something unthinkable until that moment.
Adagio Tech provides expert Pentaho development and support services when you need them most. Learn more about our services and experience and connect with a Pentaho expert.