This role conducts analytics for the trade desks. The analytics are for power, natural gas, oil, and new energy markets.- Created several new Power BI dashboards for Oil, Environmental Commodites, Power, and consolidated dashboards for Management- Used machine learning and statistical analysis to assit power desk with predictive modeling. -- Modeled ERCOT Load by hour -- Modeled PJM Load by hour -- Modeled expected ERCOT heat rate for a given day or hour- Created a dashboard to track BTC mining profits given the power costs in ERCOT- Automated or improved several reports using python and Power BI- Nodal DC conference- Comfortable with YES Energy - Comfortable with weather data- Competitive natural gas storage predictions given Bloomberg Whisper

- Help support P2 Oracle applications- Manage the onboarding and decommissioning of new applications- Conduct due diligence for new applications and ERP systems- Use prior accounting skills to build project comparison features and costs

Built several Excel VBA workbooks to connect to the Oracle database- Reproduced several of the most commonly used reports which helped to speed up the Accountant's monthly booking processes.Revenue data analysis for the monthly accrual process- Calculated and paid Texas severance taxes, Texas GLO, and Wyoming severance taxes- Handled the 1099 process annually- Built Excel VBA platform to pull data from many different tables in Oracle using SQL- SQL code gets extracts this data into Excel pivot tables- Pivots are then used to run month-over-month data analysis for prices and volumes- Exceptions are automatically filtered and placed in stand-alone reports for further analysis/QC- Troubleshoot issues with Revenue Accountants (i.e. Oracle setup issue, DOI issue, etc)- Built VBA process using the SQL dump to systematically build a price analysis summary- VBA automatically produces volume/price/revenue metrics for managementBooked/Analyzed/Paid Texas Severance Taxes, GLO Royalties and Federal Backup Withholding

Responsible for revenue accruals for all products and internal companiesResponsible for monthly revenue analysisBook revenue for actuals on a monthly basis along with necessary PPA'sResponsible for monthly reconciliations (Accruals, Expenses, Royalty Payable and a few others)Complete needed invoices to be sent out to 3rd parties

Developed several macros for CAPEX, LOE, Revenue and a District Manager of OperationsIncreased delivery time of Revenue accrual by 50% through use of VBA macrosBuild VBA program to help LOE group process 5000+ well LOS’s for exceptionsDeveloped revenue price analysis file to QC before booking final accrualDeveloped JE templates for quick and accurate Journal EntriesProcess and analyze Revenue Accrual across 3 Funds

Responsible for booking Oil & Gas on ~3000 wells through production allocation and salesReconcile GL Accounts monthly (Revenue Receivables, Rev Netting, Cash Disbursement)Prepare multiple analysis for revenue results across, fields, districts, regionsLead PPA projects to clear up AR and identify incorrect DOI’s

Booked CAPEX accrual and worked directly with Engineers to ensure accuracy of spendDeveloped a method to check CAPEX numbers against plan and forecast (before booking)Worked with IT and P2 consultants to improve our accrual processLead and developed CAPEX department for an interim periodBooked monthly CAPEX accrual of ~ $350MMAnalyzed budget to actual on AFEs

Responsible for booking and analysis of CapEx for Operations Accounting groupBook monthly accrual for CapEx for both public and private portions of companyProvide CapEx accrual report to managementProvide Capital Reports to C level managementWork with Corporate Accounting to keep track of monthly and quarterly PP&E

Responsible for calculating and reporting on severance tax and royalties on a monthly basisDeveloped spreadsheets that allow for monthly revenue data to be processed efficientlyWorked with complex data for GLO reconciliations Led to developing skills in dealing with incomplete dataAnalyzed revenues and costs on wells using various statistical methods

Founded the University of Houston – Downtown’s first official Finance organization