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 insights.

• 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.

• 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, resulting in a substantial $1 million/month increase in earnings.• 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 decisions and capitalize on emerging opportunities.• 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.

• 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 establishing credibility as a thought leader in the oil and gas industry.• 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 between 2007 and 2012.

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

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