Ben Macfarlane Email & Phone Number

Denver, CO, US

Denver, CO, US

OO

Migrated multiple data reports from Tableau to Power BI by translating logic and replicating look and usability.

• Engineered and deployed automated workflows on Microsoft Azure, SQL, and Power BI to streamline data collection, processing, and visualization for oil and gas permits and production data.
• Created SQL stored procedures integrated with Azure Data Factory pipeline to forecast oil and gas production by county and month across 10 scenarios, optimizing strategic planning decisions.
• Condensed 80 million rows of production data into a concise Power BI dashboard, empowering users to analyze monthly production metrics and natural decline trends of 1.4 million U.S. wells, facilitating data-driven.

Edmond, OK, US

• Spearheaded the design and development of Power BI data reports analyzing drilling, completions, production, and financial metrics; resulted in a 60% reduction in data analysis time.
• Enhanced data quality by transforming and standardizing data from SQL and Athena databases; optimized database performance, resulting in improved query efficiency and streamlined data retrieval processes.
• Orchestrated cross-functional collaboration with key stakeholders, enhancing design based on user feedback.
• Validated data integrity and enhanced user interaction with dynamic visuals; pinpointed and resolved 50+ data discrepancies, ensuring reliable insights and a seamless user experience.

Denver, CO, US

• Championed creation of optimization model to determine ethane rejection levels for fleet of gas processing plants; collaborated with Commercial and Operations teams to validate results and communicate adjustments.
• Analyzed and forecasted throughput, cash flow, and net present value for high-value capital projects and M&A transactions of $150M - $3B, providing critical insights for strategic decision-making.
• Conducted comprehensive data analysis on oil, gas, and NGL markets; delivered regular executive reports on pricing trends, supply-demand imbalances, and market volatility, enabling leadership to make informed strategic.
• Executed financial planning and analysis of $1.5B in capital spend, scrutinizing budget deviations and performance against forecasts; delivered comprehensive reports ensuring heightened transparency and accountability.

New York, NY, US

• Analyzed, forecasted, and presented comprehensive market insights on supply, demand, constraints, and pricing of energy commodities, contributing to successful consulting engagements and client relationships, and.
• Devised and implemented automated data models and wrote content highlighting key insights in market reports distributed to >1,000 clients weekly, directly contributing to substantial ~5x surge in company revenue.

Denver, CO, US

• Operated natural gas processing plants and gathering systems to maximize throughput and recoveries while minimizing cost and risk.

Arlington, Virginia, US

• Managed five soldiers and the maintenance of 35 trucks and tracked vehicles and received an honorable discharge at the completion of enlistment term.

Master Of Science - Ms, Mineral & Energy Economics

Bachelor Of Science - Bs, Business And Religion