Andrew Yanke

About Andrew Yanke

Data Scientist / Geophysicist with 10yrs experienceMy current projects include the following- Create/ implement machine learning models for US onshore & offshore producing and planned drilling locations. Results are back-tested, 20% more accurate, and approved by third-party auditors. Wrapped forecasting utility in a Power App that summarizes results into a pdf, and well economics for Aries exported to your email! Models made in python, run autonomously in Azure- Automate ingestion and storage of PVT (pressure & temperature) data originally stored in 100’s of dispersed, unstructured.xlsx files (some 20yrs old) into a database users can query. This work unlocks substantial opportunity to analyze well tests at a scale previously inaccessible. Also exploring the use of AI agents and RAG LLMs in this solution- Create an algorithm in R code to analyze equity markets and indicate when to buy and sell equities or commodities, daily- Create dashboards integrating SQL, Power BI, Power Apps, and Power Automate to collect updated onshore and offshore production data and present in a summarized format.My Journey: A geophysicist by training, I\'ve worked deepwater exploration in the Gulf of Mexico (namely Mexico Perdido, Salinas Sureste, and Yucatan) and shale reservoir characterization in the Eagle Ford shale. The scale of my work traversed from regional play identification to maturing prospects with detailed seismic interpretation, AVO, and rock physics studies. After several years, I moved from Houston to Stavanger, Norway as part of Equinor\'s Crude Oil Evaluation team to gain exposure to the downstream half of Equinor. In Norway, I learned how value is assigned to crude oils and their products based on technical, freight, and market elements. I created digital solutions that enabled market analysts, traders, and executives to assess the oil/liquids market, quality control our forecasts of crude/product prices, and track LPG cargos all over the world. These solutions are in Power BI, Power Apps, Python, and Spotfire. I repatriated to Houston 2 years later to become the data scientist for Equinor\'s assets. This career move came after I took a 9 module data scientist certification program from Harvard. Extensive experience in data wrangling, python, ML, dashboards, some CI/CD, time series forecasting.

Experience

1. Data Scientist Onshore and Offshore Assets

   Equinor

   Dec 2021 — Present · Houston, TX, US

   Create and maintain CI/CD pipelines and machine learning applications to forecast oil/gas production per well (undrilled and drilled) and estimate EURs from geology, completion parameters, and neighboring production. Proficient in Python, Microsoft Azure, Microsoft Power Platform, base R, scikit-learn, caret, & keras. Create applications in Power BI, Power Apps, and Spotfire to consolidate live production data and compare it to our forecasts. These dashboards are effective for summarizing production information, finding missing production, and reporting errors from the operators.Automate ingestion and storage of PVT (pressure & temperature) data originally stored in unstructured.xlsx files dispersed throughout a legacy file system. The data now lives in a modern database that auto-refreshes regularly.

Education

• Colorado School of Mines

  Valedictorian Bachelor of Science (B.S.), Geophysics; Geology minor

  2010 — 2014

• The University of Texas at Austin

  Master of Science (M.S.), Geophysics

  2014 — 2016

Skills

• Geophysics
• Petroleum Geology
• Matlab
• Structural Geology
• Stratigraphy
• 3d Seismic Interpretation
• Inversion
• Geology
• Earth Science
• Electromagnetic Fields
• Geophysical Data Processing
• Well Logging
• Geological Mapping
• Geophysical Surveys
• Coding Experience
• Petrel
• Quantitative Seismic Interpretation
• Sequence Stratigraphy
• Seismic Imaging
• Digital Signal Processing
• Reservoir Geology
• Electrical Methods
• Seismic Amplitudes
• Cross-Team Collaboration
• Rock Physics