Yudi Setiadi Email and Phone Number

• Created a system to accelerate monthly production data reconciliation calculation process from manual calculation using spreadsheet tools to semi-automatic using python and SQL script. This system can save 90 percent processing time faster.• Managed and created any report Using SQL Server Report Service (SSRS) tools to present any data from AVOCET database such as well test and operation data, OpenWells such as drilling and well works and DSS such as production surveillance data.• Ensure that Back Allocation process of Production data to each active well is executed correctly • Ensure that all data source and daily reporting process of production data is executed correctly• Managed and created SQL Procedure to create new reports or calculations in AVOCET database.• Ensure that all production databases such as AVOCET, SRRS server and SOT run well. • Maintain operation and production databases and Production Surveillance databases such as AVOCET and DSS.• Created and Maintained operation and production reports using SQL Server Reports Services, Microsoft Excel Macros and PowerBI.

• Developed a clean Exploration subsurface database. Loading more than 1000 seismic lines, 5 3D seismic survey and 130 wells data into from various data sources.• Speed up the seismic data loading by using process by using python scripts and application workflows. We only need a few hours to load, create standard naming and seismic amplitude balancing.• Run data management QC of Well and Seismic data completeness, such as, well header, well curves, time-depth data, seismic data type etc.• Created well and seismic data quality by using GIS technology

• Lead the team in making BI dashboard to manage stake holder expectation related with the data analysis and visualization.• Work and collaborate with Junior BI Developer, Data Engineer, and Database Administrator to created Dashboard and Report more efficient and match with the requirement.• Supervise and guide Junior BI Developer for any Business Intelligence task as a knowledge transfer and part of development.• Develop the capabilities of Junior BI Developer as a way to share knowledge and improve efficiency in solving BI tasks or problems.• Create a PowerBI class in order to share the new method/technology related with data analysis, visualization and reporting to any stake holder

• Created subsurface data project and took Data Management QC to minimize data duplication, navigation, and other problems before the interpretation stage was started.

• Lead and Managed 100.000+ seismic data and 8.500+ wells from Indonesia Master Data Repository. • Created master database using PostgreSQL.• Developed and designed seismic and wells warehouse database.• Performed data tracking by using GIS and Business Intelligence technologies.• Created python workflows/pipeline which can read any seismic, navigation, velocity, well curves data and its metadata and stored it in the database. • Extracted any metadata of each seismic and well data.• Created spatial database by using PostGIS (PostgreSQL spatial database) and created Web Map Service and displayed some information as map service from other applications.• Developed and designed Web Application that can visualize maps and well data.• Adopted Digitalization and Digital Transformation to improve business processes in Subsurface area.

• Implemented data archiving process by creating SQL, python, and shell script and Petrel workflow to optimize its results and time.• Successfully migrated and QC 27000+ seismic data, 1400+ wells, and all interpretation data from Openworks to Petrel on time.• Provided data tracking using Business Intelligence (BI) tools.

• Lead, Managed and Consolidated and QC 10.000 Seismic Line and 1000 wells data from any sources and any format into Petrel on time.• Create database tracking using Business Intelligence tools.• Created any workflow to increase the data management performance.

• Developed Business Intelligence (BI) system to perform better business strategy. Created an automatic reporting system and reduced manual system. • Implemented ETL processes for compiling 10 years of sales data to obtain new insight and valuable information.• Analyzed and visualized sales and performance data using DAX, PowerQuery and PowerBI.• Developed Sales data modelling to support data reporting.• Modernized and transformed Performance Reports by using BI tools.

Develop automatic report system of Subsurface, production and Drilling data in one single place. Save time from days to minutes when we need to analyze and generate a report. Stakeholders can access it through Web browser or their smart device (phone or tablet), any decision can be made quickly based on that report.Modernized and Transformed any subsurface data, Production and Drilling data report by using Business Intelligence (BI) methods to seek any valuable information. Report can be made based on stakeholder needed by connecting to the raw data and be analyzed by using any BI tools.Developed Quality Control and Tracking system of Subsurface Data and Create Master Data repository to store Final Data. Increase reliability of final data to 100 % and easy to find trustworthy data.Developed tape and media uncatalogued and tracking. Over 75000 media/tape had been documented, cataloged and easy to find.Solved any data management task or Application problem by using ‘Agile’ methods. Increase productivity and finish task/job quickerManaged Subsurface, production and drilling data.Managed Real-Time data transfer during drilling campaign.Developed and applied strategy of sustainable Subsurface Data Management.Collected and connected Subsurface, production and drilling database into one “Mini Data Lake”.Managed seismic data from field to front-end seismic data which ready to interpret by any stakeholders. Trans-crypted any seismic and wells data from/to tape media.

Make and manage good relationship between company and their client.Maintained system administration of G&G Application from/to OpenWorks.Maintained OpenWorks Database.Maintained Application licenses usage.Disk Monitoring.Managed G&G Data, load and un-load G&G Data.Maintained OpenWorks Instance (Installing and Tuning).G&G Data Reporting.Created Data Loading and Un-Loading Procedures.Configured OpenWorks R5000 Installation in BP environmentAnalyzed and cleaned up OpenWorks R2003 data before upgrade processUpgraded and QC OpenWorks data from R2003 to R5000 versionGave an overview of OpenWork R5000 to BP userHelped and created Standard Naming Policy of BP Interpretation Data.Created Standard Naming system of BP Interpretation DataRenamed BP Interpretation data follow the BP Standard Naming Policy by using Unix and SQL script.

Supported customer if they have any OpenWorks System Administration, Geophysical application such as SeisWorks, ZMAP, GeoProbe and ProMAX problemProvided a Workflow and troubleshooting G & G Landmark application to customerProvided technical support for Asia Pacific regionExperienced in providing best practice to help Geosciences Application Users to perform their work (Workflow Support)Performed seismic data loading, either new or old data from either tape or disc media for further processingPerformed presentation on a new technologyPerformed either one-on-one or group training on Geosciences ApplicationWorked with Many OS environments such as Linux, UNIX (Solaris, AIX), and Windows 98/NT/2000, XP (Installation, networking, device controlling and shell scripting)Programming Language such as SQL, shell, sed and awk.Administering, monitoring disk space allocation usage.