Syntax Literate: Jurnal Ilmiah Indonesia p�ISSN: 2541-0849 e-ISSN: 2548-1398

Vol. 7, No. 9, September 2022

 

ANALYSING FACTOR TO IMPROVE DATA QUALITY IN INTEGRATED OPERATION SYSTEM IN OIL AND GAS INDUSTRY AT XYZ ORGANIZATION

 

Hendradi Walujo

Engineering And Information Technology Master of Information Technology, Swiss German University, Banten, Indonesia

Email: [email protected]

 

Abstract

Back in 2012 Integrated Operating System known as SOT (Sistem Operasi Terpadu) was started to implement in order to conduct reporting Oil and Gas Production to all stakeholders such as related Government and Ministry, House of Representatives and Supervisory Agency. The program is always being improved to have better quality on both data, infrastructure, people and process to address some problem in regards with data completeness, accuracy and timeliness. In order to address the issue arises the study has been conducted to see the problem by discussing with multi parties, study of literatures and discuss the propose framework with SME�s. The well-known standard�� such as COBIT and DMM also support to mapping and having insight of the observed gaps. At the end this study come up with the plan of action on how the data quality is improved from many perspectives on how the policy and principle, culture and behavior, information and communication, skill of people and competencies, to management commitment and infrastructure.

 

Keywords: SOT, Integrated Operating System, PTK 053 and PTK 054, COBIT 5, Data Management Maturity.

 

Introduction

Oil and Gas (O&G) is an energy taken from fossil and one kind of natural resources in Indonesia where these resources are under protection of Undang-Undang Dasar 1945 (Constitution 1945) on article (pasal) 33 stated that natural resources are protected by the Government of Indonesia and to be utilized for all Indonesian people as much as possible for prosperity and welfare. Until these day O&G is one of accelerator for economic growth. In general, there are two part of O&G activities in Indonesia, known as upstream and downstream which the upstream activities are managed by XYZ while the downstream managed by BPH Migas.

XYZ, abbreviation from The Special Task Force for Upstream Oil and Gas Business Activities, is the institution which was established by Indonesian Government via Presidential Regulation Number 9 Year 2013 and having authority to conduct the management of upstream O&G activities based on Production Sharing Contract (PSC) with PSC Contractor (known as KKKS � Kontraktor Kontrak Kerja Sama) such as Pertamina, BP, ExxonMobil, Chevron, ConocoPhillips, INPEX and any others PSC Contractor with the main purpose to make the exploitation of stated-owned O&G contributing maximum benefits for the state of Republik Indonesia.

In order to conduct monitoring and reporting to all stakeholders such as the Ministry of Finance (Menteri Keuangan), the House of Representatives (DPR), the Ministry of Energy & Minerals Resources (ESDM) and Badan Pemeriksa Keuangan (BPK, Financial Supervisory Agency), the Division of Information and Technology in XYZ has the strategic function as the enabler to create system to collect, exchange, analyst and to report daily reporting from all PSC Contractor (around 60 PSC contractors) where the data sources itself having various format generated from various system that implemented on each production field.

XYZ requires an adequate system to develop an information system to support the integration and management of data related to the operational activities of the KKKS. The system is also known as the Integrated Operating System or Sistem Operasi Terpadu (SOT).

SOT whose initiative was taken in 2012 by following the Norwegian Leading Position method in the implementation of Integrated Operations. SOT itself is regulated under the Work Procedure Guidelines (PTK) number 054 issued by XYZ. The basic concept of implementing SOT is an integrated system based on business processes that connects several computerized systems of application software, both physically and functionally so that they can be integrated between XYZ and KKKS. By implementing SOT, both XYZ and KKKS will benefit from, among others, data and information transparency, accuracy, process speed, and accountability. According to the 2014 SKK Migas Annual Report, the integration between XYZ and KKKS through SOT can assist XYZ in carrying out its function as supervisor and controller of the upstream O&G business.

Referred the 2020 Annual Report of XYZ, it is known that when reporting its daily report, there is a dashboard that contains information on the daily gas balance report which is divided into the composition of gas distribution data, flaring, fuel, and impurities as well as data on gas utilization for consumers, such as electricity industry consumers, use for oil lifting, city gas, export, fertilizer industry and fuel gas station.

The data is connected to the IOC (Integrated Operating Center) from the KKKS database/system through an SOT which is gradually verified in daily basis. The integrated system can certainly improve transparency, accuracy, timeliness, and efficiency of the reporting process. In the context of digitizing the XYZ reporting process to the Ministry of Energy and Mineral Resources, XYZ has built a web service to channel several types of additional data and become a mechanism to accommodate data integration that can be accessed quickly and precisely.

However, to carry out daily operational activities related to the SOT system, both KKKS and XYZ must implement controls to mitigate disruptions to SOT operations. The problem arises from production data produced daily from thousands of Oil and Gas wells to production facilities at onshore and offshore facilities in many locations in Indonesia.

In order for all stakeholders to remain well informed and also the daily production dashboard needs to be reported to the Ministry of Energy and Mineral Resources, ideally the production data have to be presented in full number taken from the system. The daily production report itself consists of lifting and stock which is data for one day starting from 00.00 to 24.00 on the previous day. As depicted in figure 1.1 below.

 

Figure 0

Dashboard display of stock conditions at the KKKS terminal

Source: SKK Migas Annual Report 2019, (SKK Migas Annual Report 2019, 2020)

 

However, in reality the current SOT causes some incomplete data and there is a discrepancy between the data reported and the actual data in the KKKS. Therefore, it is necessary to analyse the improvement of problem solving resulting from daily reporting (SOT).

Based on the problem logs which is compiled by the IT service desk starting from January 2021, there are still numbers of error recorded per day with various problems related to incomplete data to send, IT infrastructure problems either network, servers and applications as depicted in figure 4.

Several previous studies have shown that the system used is the PSC contract monitoring system and the Integrated Operating System (SOT), but the SOT is widely used in the data collaboration process so that the level of caution in reporting the data needs to be increased (Kastella and Prabowo, 2020). In addition, the Integrated Operation System built by the XYZ Information System Management Division team is a form of optimizing the application of information technology and telecommunications in upstream oil and gas business activities that is able to create sustainable oil and gas management through increased efficiency, effectiveness, and a high level of calculation accuracy (Permana, 2015). System-related analysis can be explained using the SSM method so that it is easy for organizations to understand, implement and adopt data governance according to their needs (Prasetyo and Sureno, 2015).

 

Research Methodology

 

Figure 2

Research Methodology

 

Research Framework

 

Figure 3

�Proposed Research Framework

 

As depicted at the above framework we divided the component of framework onto five parts as they are input, processes, output, outcomes and impact. As stated earlier that we believe that the quality of data in the source of data which stored in KKKS�s repository will be affected also to the quality data (completeness, timeliness and accuracy) that ready to be processed to XYZ and in order to support that, along the way, there are some enablers as inputs that explained as following below. The seven enablers put as input of the process, as an improvement process requires iterative activity from output back to input and as well as conducting regular audit in both internal and external and also the self-assessment on how effective is the processes. �

Evaluation of Framework

The Evaluation of the framework will be conducted by interviewing seven subject expert maters from various working experience, position and also take outside organization expert to give opinion. The area that will be discussed is as following below; Policies, Principles and Framework, As already stated earlier in Chapter 2. Literature Review, many authors proved that the regulation or governance have significant impact to the data quality, therefor in this stage there will be some activities to conduct evaluation whether the current regulation is still adequate to address any issues arises in data quality, by first of all to conduct a mapping between current regulation PTK054 and PTK053 against COBIT 5 Processes the continue mapping to Data Management Maturity to observe more clearer gaps in correlation with Data Quality. This is will also discuss the importance of PPDM and PRODML to be considered in the component of the framework. The result then to be presented to the SME�s as evaluators to discuss the importance and relation to the success factor.

Organizational Structure Commitment of Top Management

As stated earlier in Chapter 2, many authors argue the commitment of top level of management will effect positively to data/information quality, also base on previous conversation with many KKKS that it obviously needs commitment, awareness and their priority to data governance and data quality, therefor in this research we will evaluate by compiling SMEs opinion in the importance of making awareness and commitment from top management in each KKKS by gathering opinion from SME�s.

People, Skill and Competencies, Dedicated Personnel and Competency

From the results of the literature study and also from interviews with KKKS regarding people, skills and competencies, it will then be tested whether these are things that can be a success factor to be implemented based on expert opinion.

Culture, Ethics and Behaviour

This section is to asses if organizations need to apply a focus on Value of Information / Data and need to apply motivation, concern and understanding of the importance of data / information quality.

Services, Infrastructure and Application

In this section will also be tested if the services in IT, supporting infrastructure, or supporting application will also need to improve as success factor of data quality.

Information

This section will evaluate if the communication forum between KKKS and XYZ in order to improve the quality of SOT Infrastructure, Data Management, discussion of SOT issues, brainstorming and sharing knowledge as well as support sharing will affect to data quality.

It has also a moderator factors as COBIT Enabler mentioned it as Principle, Policies and Framework which in this case we will be focusing on investigating the Pedoman Tata Kerja (Working Guidelines) PTK 053 as supporting to PTK 054. In this area those PTK will be mapping to the COBIT 5 Enablers and due to COBIT 5 Enablers don�t specifically have detail on how it correlated with Data Quality then mapping them to Data Management Maturity (DMM) provided by CMMI is required as see in figure 4.

 

Figure 4

Mapping Methods utilizing COBIT 5 and Data Management Maturity (CMMI)

 

Validation of the Framework

After conducting several activities in order to obtain evaluation and opinion by the SME�s, the result and framework than need to be validated via Forum Group Discussion with other expert which in this case obtaining validation from the Division Head, ITIL Expert, Department Head and Vice President. Focus group discussion is a common qualitative method for gaining a deeper understanding of social issues. Rather than a statistically representative sample of a larger population, the approach tries to acquire data from a purposively selected group of individuals (O.Nyumba et al., 2018).

 

Results And Discussions

Based on the results of descriptive analysis using SPSS, it is known that question A1 is related to the statement that SOT has implemented the Data Exchange Standard (PRODML) and the data storage/repository standard (PPDM), which the PTK does not include the two standards. The majority of respondents stated that it is essential for SOT to continue to apply these standards. Where even though based on the results of mapping PTK 054 it has not touched the points of Data Management Maturity (CMMI), but with the implementation of data-policy standards that are easy to follow, these standards will have a fundamental role as a success factor in the data.

In question A2, it is known that the majority of respondents answered that it is essential for XYZ to adopt several processes in COBIT to enrich PTK053 especially in relation to data. This is because PTK053 has been released for a long time so it is necessary to make adjustments to current conditions, especially in relation to IT Governance standards such as COBIT. In question A3, it is known that the majority of respondents stated that it is essential for XYZ to include data exchange standards (PRODML) and data storage/repository standards (PPDM).

 

Table 1

Percentage of Descriptive Analysis

Question

Rating percentage

Modus

Critical

Essential

Useful

Nice to have

Irrelevant

Don't Know

A1

20%

80%

0

0

0

0

Essential

A2

20%

80%

0

0

0

0

Essential

A3

0

60%

20%

0

0

0

Essential

 

For questions A4-A9, a two top box analysis (percentage of essential and critical answers) is used to show how much respondents agree whether the program is feasible to run. Figure 4.2 and Table 4.25, The total percentage of essential and critical answers shows "PRIORITY" while the total percentage of nice to have, irrelevant, and don't know answers shows "NOT PRIORITY". Based on the results of the two top box analysis, it is known that the priority program that must be carried out is the commitment of the KKKS top management (A4) this is because the top management of the KKKS has an effect on increasing Data Quality, people skill competencies (A6) both for increasing dedicated personal specifically handling SOT both in the field as well as in the office (A6a) as well as improving skills and competencies related to understanding the technology used in every application development and operation used for SOT (A6b), organizations need to apply a focus on Value of Information / Data and need to apply motivation, care and understanding of the importance of data / information quality as a form of improving culture, ethics and behavior (A7), as well as improving services infrastructure and application (A8).

The above programs need to be prioritized because they have a two top box value that reaches 100%. However, the majority of respondents stated that all of these programs are essential to be carried out so that the quality of data in KKKS can be further improved.

Figure 5

Program priority based on two top box analysis

�

Table 2

Percentage rating two top box

Question

Rating percentage

Two top box

Not Priority

Modus

Critical

Essential

Useful

Nice to have

Irrelevant

Don't Know

A4

20%

80%

0

0

0

0

100%

0

Essential

A5

20%

40%

40%

0

0

0

60%

40%

Essential and Useful

A6a

40%

60%

0

0

0

0

100%

0

Essential

A6b

40%

60%

0

0

0

0

100%

0

Essential

A7

20%

80%

0

0

0

0

100%

0

Critical

A8

60%

40%

0

0

0

0

100%

0

Essential and Useful

A9

20%

40%

40%

0

0

0

60%

40%

Essential and Useful

Rata-rata Prioritas

31.43%

57.14%

11.43%

0

0

0

88.57%

11.43%

 

 

Conclusions

The quality of the data is very dependent on the role of Data Management which is mentioned a lot in the literature review related to this. After being compared using the DMM Maturity Model and COBIT between the currently available governance guidelines, namely PTK 053 and PTK 054, it turns out that there is still a large gap, where there are a lot of process points that are not covered by the two PTKs. This was happening because during the preparation of the PTK was not considered about aspects of data governance or data management.

This situation also resulted in how the KKKS manage data in their system, it was identified during interviews that they did not yet have a policy regarding data management and some were in the stage of making standard policies related to data management.

The proposed framework model is acceptable to be applied for improvement in order to improve data quality based on the validation of Department Head of Data Management and Division Head of IT as well as the results of the questionnaire submitted to 7 (seven) subject experts who handle Data Management at XYZ every day that every detail of the components in the proposed framework can be implemented with a tendency of opinion stating important, and partially important and useful on average.

Beside rearrangement of PTK it comes also to the attention that standard data exchange(PRODML) and standard repository (PPDM), emphasizing commitment from top management of KKKS and top management level of XYZ as the supervisory body for the upstream oil and gas industry.

Also need for improvement of organization structure on each KKKS that builds roles, responsibilities, duties, accountability, decision rights, rules of engagement and communication, human factor related to dedicated personnel and well trained personnel also need to address as well as the knowledge to the technology used for SOT, focus on value on information and data also having high attention from the responder as well as conducting regular audit and communication forum. Beside the conclusion above the gap analysis is also provided as shown in table 3 below.

 

Table 3

Findings and Recommendation

Findings

Gap Analysis

Recommendation

PTK 054

Based on mapping using COBIT and CMMI it is found that there are not clausal related to the EDM domain,

The PTK it itself will lose control of Evaluate Direct & Monitor as in this case resulting in a lack of role from top management in KKKS due to the absence of direction in the EDM domain

It is recommend that PTK 054 also elaborate the EDM process to address the issues, the importance of EDM will direct KKKS in term of developing their own SOT governance which referring to PTK 054 and PTK 053, as well as the importance of resource optimization and stakeholder transparency�

PTK 054

Only 2 clausal found related to the APO (align, plan and organize) related to Manage Security

For KKKS which do not refer to another PTK 053 this will causing lack of alignment, planning and organizing phase, in particular based on last audit found it is stated the security issue with high vulnerability�

PTK 045 should also addressing more to the APO domain, especially to domain related to Manage Human Resources, manage Service Agreement and in particular Manage Quality which is even not stated on both PTK 054 and PTK 053 as described in table 4.10

In both PTK 054 and PTK 053 are not addressing Manage Change Acceptance and Transitioning and mana Knowledge and Manage Requirement Definition

Manage knowledge will be more importance to be utilized by either XYZ and KKKS as to solve the day to day SOT problems or accident, as also stated on audit findings that KKKS don�t have good problem recording related to SOT, this is also related to Manage Configuration which is not stated in PTK 054.

KKKS should be more aware on how they record the problem & accident. Using on the shelf application or tools would be also beneficial. It is also beneficial if the system is integrated between KKKS and XYZ.

Comparing with Data Management Maturity � CMMI as stated on Table 4.11 DMM Mapping to PTK 054 it clearly observed that in Data Management Strategy in detail on Communication and Program Funding are not address on PTK 054

The clear communication is an importance in order to ensure data quality, during interview with KKKS it is also discussed that some are lack of internal communication in handling SOT

On PTK should address the Communication process area and also program funding even actually it already covers on annual Work Program and Budget (WP&B). However it still necessary to put on PTK to prevent it uncovered anywhere.

Referred to PTK 054 mapping to DMM, there are found that PTK 054 are not addressing any Process Area in Data Quality�

It should address Data Quality Strategy and data profiling as this will be importance for KKKS in changing the way they manage Data Governance and data Quality that will also affected to Behavior and Culture.

It is also lack of clausal in regards with data quality assessment and data cleansing. This will be more in

 

Data Quality Strategy, Profiling, Assessment and Cleansing should be addressed on next PTK revision

Refer to mapping result between PTK054 to DMM � Platform and Architecture � Approach and Standard � as has been discussed in interview with one of big KKKS stated that they operation area are too long so that not easy as another KKKS to manage source of data.

This condition might be affected by lack of Architectural Approach and Standard as if the two processes are stated in PTK will then be useful guide for KKKS to address this issues

In the next PTK revision will need to elaborate the architectural approach and standard to assist KKKS on how they manage the infrastructure and data in the wide operational area.

 

As the overall study and conclusion provided in this thesis, it is confident enough to say that implementing this study will affect to improvement of data quality in SOT, and not SOT Production in particular but will be affecting to better future data quality on SOT Drilling, Financial Quarterly Report and others SOT which still in the development process. This is also will impact to better Data Governance that will be adopted by KKKS so that at least around sixty-five production KKKS have a benefit for better Data Governance and Data Quality as this also supporting Oil and Gas IOG 4.0.���


BIBLIOGRAPHY

 

Alhassan, I., Sammon, D. and Daly, M. (2019) �Critical Success Factors for Data Governance: A Theory Building Approach�, Information Systems Management, 36(2), pp. 98�110. doi: 10.1080/10580530.2019.1589670.

 

Brandon Vigliarolo (2019) �Data Management ( DMM ) Model Data Management�, (Dmm).

 

Chandranegara, I. S. and Hoesei, Z. A. (2019) �Policy concept and designs of oil and gas governance in Indonesia�s oil companies�, International Journal of Energy Economics and Policy, 9(3), pp. 121�127. doi: 10.32479/ijeep.7458.

 

Equinor (2021) Equinor (StatOil). Available at: https://www.equinor.com/.

 

Ghandi, A. and Lin, C. Y. C. (2014) �Oil and gas service contracts around the world: A review�, Energy Strategy Reviews, 3(C), pp. 63�71. doi: 10.1016/j.esr.2014.03.001.

 

Hotchkiss, D. R. et al. (2010) �Evaluation of the Performance of Routine Information System Management (PRISM) framework: evidence from Uganda � UNC Carolina Population Center�, Biomed Central, 10(188), pp. 1�17. Available at: http://www.cpc.unc.edu/measure/publications/ja-11-124.

 

House, C. (2016) �Guidelines for Good Governance in Emerging Oil and Gas Producers 2016�, Chatham House Research Paper, (July), pp. 1�58.

 

Huff, E. and Lee, J. (2020) �Data as a strategic asset: Improving results through a systematic data governance framework�, SPE Latin American and Caribbean Petroleum Engineering Conference Proceedings, 2020-July. doi: 10.2118/198950-ms.

 

Ibrahim, A., Mohamed, I. and Satar, N. S. M. (2021) �Factors Influencing Master Data Quality: A Systematic Review�, International Journal of Advanced Computer Science and Applications, 12(2), pp. 181�192. doi: 10.14569/IJACSA.2021.0120224.

 

ISACA (2012a) Enabling Information Superiority. Available at: http://www.globalservices.bt.com/static/assets/pdf/Insights and Ideas/DSiC_WhitePaper_190115.pdf.

 

ISACA (2012b) Enabling Processes, Cobit 5.

 

Liu, C. et al. (2018) �Achieving data completeness in electronic medical records: A conceptual model and hypotheses development�, Proceedings of the Annual Hawaii International Conference on System Sciences, 2018-Janua, pp. 2824�2833. doi: 10.24251/hicss.2018.357.

 

Mustafayev, N. (2015) �Production-sharing agreements in the petroleum industry of Azerbaijan�, Journal of World Energy Law and Business, 8(4), pp. 362�385. doi: 10.1093/jwelb/jwv017.

 

O.Nyumba, T. et al. (2018) �The use of focus group discussion methodology: Insights from two decades of application in conservation�, Methods in Ecology and Evolution, 9(1), pp. 20�32. doi: 10.1111/2041-210X.12860.

 

Permana, H. (2015) �Sistem Operasi Terpadu : Optimalisasi Sistem Informasi Dalam Mendukung Kegiatan Usaha Hulu Migas�, pp. 9�10.

 

PPDM (2021) No Title. Available at: https://ppdm.org/ppdm (Accessed: 13 December 2021).

 

ProdML (2021) No Title. Available at: https://www.energistics.org/portfolio/prodml-data-standards/ (Accessed: 1 August 2022).

 

Ruang Energi (2021) 5 KKKS Besar Produksi Minyak dan Gas di Indonesia, 17/5/2021. Available at: https://www.ruangenergi.com/ini-ya-15-kkks-besar-produksi-minyak-dan-gas-di-indonesia/ (Accessed: 8 January 2022).

 

SKK Migas (2021) Daftar Pedoman Tata Kerja SKK Migas. Available at: https://www.skkmigas.go.id/assets/daftar_pedoman_tata_kerja_skk_mi.pdf (Accessed: 1 August 2022).

 

SKK MIGAS (2018) �PTK-054 Tentang SOT�, pp. 1�29.

 

SKK Migas Annual Report 2019 (2020) Dashboard KKKS Terminal. Available at: https://www.skkmigas.go.id/assets/ar-skk-migas-2019-english.pdf (Accessed: 1 August 2022).

 

Williams, T. L., Becker, D. K. and Talburt, J. R. (2017) �Critical cultural success factors for achieving high quality information in an organization�, AMCIS 2017 - America�s Conference on Information Systems: A Tradition of Innovation, 2017-Augus(Redman 1992), pp. 1�9.

 

Zellal, N. and Zaouia, A. (2016) �An exploratory investigation of Factors Influencing Data Quality in Data Warehouse�, Proceedings of 2015 IEEE World Conference on Complex Systems, WCCS 2015. doi: 10.1109/ICoCS.2015.7483222.

 

 

 

 

 

 

 

 

 

Copyright holder:

Hendradi Walujo (2022)

 

First publication right:

Syntax Literate: Jurnal Ilmiah Indonesia

 

This article is licensed under: