History

Rockford Analytics provided business intelligence services from 2021 until 2025.

Domain Expertise


Drilling Engineer

 

Engineering project manager for 24x7 drilling operations. Directed work for 20-50 field personnel from multiple contractors ensuring project is on time & in scope. Forecast the cost and reconcile the variance. Approve $2,500,000 of invoices per month. Coordinate with a multi-disciplined team in the office. Present updates to management.

Project planning and cost estimation. Select vendors and procure materials. Communicate with regulatory agencies to meet all permitting and filing requirements.


Geosteering

 

Analyze streaming data from horizontal drilling ops. Interpret subsurface position relative to target formations. Update the roadmap to stay on target.


Financial Analyst

 

Provide capital, expense, and revenue accruals for accounting. Reconcile production statements. Calculate and track hedge positions. Track ownership payout status. Model cash flows. Evaluate NPV, MOIC, ROR, & NAV metrics. Financial modeling of gas gathering and processing agreements. Process non-operated JIB and revenue statements.

Lease Operating Statement creation, summary, and reconciliation. Compare with production data, settlement statements, and engineering cash flow models.

Audit production settlement, percent of proceeds, and gas processing statements. Compare with contracts, gas analysis, production surveillance, gas balancing, and accounting records.


Corporate Development

 

Full cycle modeling of upstream development projects. Incorporate surface, subsurface, lease records, infrastructure, regulatory, and operational data to form a development plan optimized to corporate strategy. Use geographic information systems to combine spatial data with other data sources.

Tools Expertise


Power BI

 

Certified Microsoft Power BI Data Analyst


Spotfire

 

Spotfire user since 2010. Utilize complex data functions (R and Python) to provide custom solutions. Set up automation for daily report distribution. Connect to multiple data sources (SQL, Oracle, GIS) using the Information Designer.


Python, R

 

Wrangle and process messy data. Automate repetitive tasks. Customize Spotfire & Power BI.


Excel, Visual Basic for Applications, Javascript, HTML, SQL, SSMS