Mark Stell Email & Phone Number

Juno Beach, Fl, Us

- Generated cashflows in ARIES and PHDWin- Generated economic inputs used in economic runs based on seller provided lease operating statements.- Standardized all seller provided databases into the same standard ARIES format to be able to have consistency across all of the different potential deals.- Converted databases from ComboCurve and PHDWin to ARIES.- Updated forecasts and economic inputs for wells in ARIES for generating financial runs for our finance team.- Used ComboCurve’s proximity tool to quickly generate type curve forecasts for wells with little or no production.- Used Spotfire and incorporated R code to compare projected cashflows with historical values in lease operating statements.- Managed databases and pulled public data from DrillingInfo for all operators near Nextera’s areas of interest.

Houston, Tx, Us

- Modeled economic inputs used in economic runs based on information provided by potentialsellers such as lease operating statements, marketing contracts, and plant statements.- Forecasted wells, built type curves, and entered in economic inputs for running wells inARIES and ComboCurve to evaluate possible acquisitions in many different basins.- Converted databases from ARIES to ComboCurve, and vice versa.- Continuously updated forecasts and economic inputs for Rushmore’s wells in ARIES andComboCurve for generating financial runs for our banks and private equity backer.- Built multivariate statistical models in R to better quantify the relative effect changes incompletion type had on well performance within a given area and reservoir.- Used Spotfire and incorporated R code to evaluate existing acreage and to compare projectedcashflows with historical values in lease operating statements.- Wrote Python code to perform tedious calculations on large well sets. Used Python toiteratively solve for the decline after scaling the initial rate and estimated ultimate recovery.- Wrote SQL queries and linked our SQL database with daily production to our Spotfire dxps tocontinuously update production data in all of our tools.- Managed a database and pulled public data from DrillingInfo for all operators nearRushmore’s producing acreage to keep track of everything going on in their area.

Oklahoma City, Oklahoma, Us

- Forecasted wells and applied economic parameters for running economics in both Aries and ComboCurve.- Built and managed several databases for potential acquisitions nationwide. Pulled several ARIES databases into ComboCurve for potential acquisitions and exported back into ARIES MS Access format for the bank.- Forecasted producing wells, built type curves, and applied scheduling and economic parameters for deal evaluations.- Pulled a mixture of public and proprietary data from multiple sources and used it to evaluate undeveloped upside potential in areas of interest.- Investigated capital and operating expenses as well as price differentials to build economic models for a potential deal.- Built Spotfire dashboards and wrote R code for analyzing areas of interest, building type curves, and building plots for presentations.- Wrote R script to calculate well spacing from wellbore trajectory data exported from Enverus.

Houston, Texas, Us

- Managed over 30 different accounts, provided training, answered questions, and helped import production and economics to ComboCurve.- Converted several ARIES databases to and from ComboCurve.- Tested and reported bugs for new releases.- Built acquisition projects for clients to complete for ComboCurve certification.

Houston, Texas, Us

- Performed financial analyses, generated cash flows. Highly proficient in both ARIES and PHDWin and converted numerous PHDWin databases into ARIES databases.- Worked in conjunction with clients, engineers, geologists, and group leaders to verify all information is accurate, up-to-date, and accessible for coworkers to run economics. Updated volumetric forecasts, working or revenue interests, capital and operating expenses, pricing etc.- Evaluated unconventional and offshore basins throughout the US and Gulf of Mexico.- Evaluated conventional reserves worldwide and spent a month in Abu Dhabi.- Built and maintained several large databases including the Ryder Scott Permian, Eagle Ford, and Marcellus corporate databases from a mixture of data sources. Efficiently gathered massive amounts of data and built tools for the data to be easily accessible for the end users.- Built several Spotfire dashboards and type curve tools to generate type curves from the immense quantity of production and completion data. Regularly employed data functions and R code in Spotfire to improve dashboards and regularly used the multivariate regression tool.- Built R code to create well trajectory shapefiles, calculate well spacing, and to automate many iterative calculations.- Used JMP, Spotfire, and R to generate numerous multivariate regression models to aid in type curve prediction. These models were used to quantify the relative effects of various horizontal well completion parameters on production volumes, which were used to adjust the assigned type curve volumes of the undeveloped wells.

Houston, Texas, Us

- Gathered and organized horizontal well completion data from multiple online public data sources such as oil & gas regulatory agencies, state websites, IHS, and Drilling Info.- Maintained Access databases for use in ARIES and Spotfire.- Built VBA macros in Microsoft Excel to determine flow regime and fluid phase.- Wrote code to automate the process of pulling well completion data overnight and without the need for human intervention.