John Frame Email & Phone Number

▪ Data Analysis and Visualization:- Collaborate with stakeholders to gather business requirements, understand processes, and design and implement actionable, data-driven solutions.- Implement interactive dashboards and visualizations using tools like Spotfire, Plotly/Dash, and Power BI.- Conduct analytics focused on operational efficiency, preventative maintenance, and predictive failure.▪ Data Engineering:- Develop data ingestion, cleaning, and transformation workflows using tools such as Alteryx, Pandas, and other Python libraries (e.g. Requests, Beautiful Soup).- Create automation and data scraping workflows to streamline business processes and drive efficiency through time savings.- Design and implement data architectures and frameworks for data storage and delivery (e.g. Snowflake Data Marketplace).▪ Project Management and Leadership:- Lead and mentor teams of analysts.- Present findings and recommendations to management teams and stakeholders.- Design narratives, documentation, and reporting for datasets.Notable Projects:▪ Water Operations Analytics Automation for an Energy Company:- Designed dashboards and overhauled processes to automate ingestion of water operations data generating new insights containing geospatial, real-time cost analysis, and logistics components. Centralizing and automating these data resulted in a time savings of 400+ hours per year.▪ Flow Meter Hierarchy Transformation for an Energy Company:- Engineered processes to transform and visualize oil & gas flow meter data that previously could not be extracted from software due to database design constraints. Leveraged Spotfire and Python to rebuild hierarchical data flow to resolve reporting obstacles.▪ SAP/Product Implementation for a Manufacturing Company:- Led the data conversion efforts of over 20 disparate on-prem systems and facilitated product implementation to a centralized SAP solution. Resulted in a successful transformation coming in on time and under budget.

Westlake Village, California, Us

▪ Operational analytics focused on preventative maintenance and predictive failure for gravity-based energy storage systems.▪ Developed data ingest, cleaning, and visualization workflows in Palantir Foundry and AWS, utilizing Glue, Athena, and SageMaker.▪ Evaluated operations for inefficiencies and identified areas for improved solutions, automation, and tool development for efficiency gains.▪ Lead and mentored a small team of analysts.

Denver, Colorado, Us

▪ Design and implement web applications using Plotly and Dash in Python utilizing AWS datastores for interactive visualization of geomechanical, drilling, and completions data sets.▪ Data analysis, dashboard creation in Spotfire and Python using Numpy, Pandas, and Scikit-Learn.▪ Process automation in Python using REST APIs and web scraping of public/private data (Requests, Beautiful Soup).

Denver, Colorado, Us

▪ Built and maintained geospatial databases for geological/petrophysical data for use in data comparison and analyses.▪ Assisted drilling team with designing and implementing data conditioning workflows for use in drilling analyses.▪ G Suite Business admin and hardware/software procurement, configuration, troubleshooting, and repair.

▪ Built and maintained geospatial and geophysical databases using SQL Server and PostgreSQL.▪ Automated internal processes and scraped public data from websites in C#.▪ Windows server administration and hardware/software configuration, troubleshooting, and repair.

Oklahoma City, Oklahoma, Us

▪ Served as an operations geophysicist for an interdisciplinary team of geoscientists and engineers to optimize and develop the Bakken and Three Forks Formations in the Williston Basin Asset.▪ Performed pre/post-drill geophysical analyses of planned/completed wellbores for a 40-60 well per year drilling program focusing on geohazards during well geosteering phase and completions. ▪ Worked iteratively with geosteering and drilling teams by generating and updating geophysical depth surfaces. ▪ Provided guidance to the completions team to avoid geohazards and optimize hydraulic fracture staging. ▪ Interpret and tie-in extensive 2D and 3D datasets, including horizon and fault mapping, synthetic generation, and time to depth conversion.▪ Designed, created and distributed unique customized software applications using C# that significantly increase user productivity, data integrity, and flow of data between engineering and geological public software applications. Examples include: web-based data miner for the NDIC website and an application for correcting directional survey drift of exported geosteering top picks from Paradigm. ▪ Programmatically increased geophysical workflow efficiencies from four hours down to 20 minutes per well by automating data collection and depth surface generation.

Oklahoma City, Oklahoma, Us

▪ Served as a member of a technical interdisciplinary team of geoscientists and engineers to optimize and develop tight-gas Mesaverde Formation sands in the Piceance Basin. ▪ Performed routine petrophysical interpretation of well logs and other geological data. Responsible for wireline data QC of cased hole resistivity logs, calculating petrophysical reservoir statistics, and customizing petrophysical, geological and engineering data for analysis by engineers and geoscientists. ▪ Performed interpretation of geophysical 2D/3D datasets, including horizon and fault mapping, synthetic generation, and time to depth conversion.▪ Evaluated and tested new software packages looking for increased functionality and efficiency gains and troubleshot existing software packages. ▪ Provided unique engineering and geoscience software solutions in C#, VB.NET, and Excel incorporating the use of API’s and ODBC. Examples include development of customized software tools to optimize well planning for development geoscientists, automation of geologic and completion prognoses (time savings of 20 minutes per well per completion engineer), recreating external petrophysical iterative log calculations from other software packages for use with the Petra API and custom interfaces designed for automatic data gathering from state and vendor resources (COGCC, NDIC, IHS). Received two internal Champion Awards for unique solutions that significantly increased employee productivity and efficiency.Recognition and Achievements:Received promotion from Geoscientist I to Geoscientist II, Feb 2011Received promotion from Geological Technician II to Geoscientist I, Feb 2010

▪ Served as quality control geophysicist managing land seismic acquisition operations in various basins in the US.▪ Provided quality control of seismic acquisition and survey data, preparation of production and testing reports, troubleshooting of computer systems, basic seismic processing, and customized programming. ▪ Designed custom software solutions that significantly increased and improved efficiency of acquisition data quality control.Recognition and Achievements:Received promotion from Junior Seismic Engineer to Seismic Engineer