· Variety of Data Wrangling projects to support Sales and Use Tax, State Apportionment Income Tax, and Automated State Tax Workpapers· Design and document Alteryx data wrangling projects include type 5 and type 11 conversion workflowsTexas Comptroller severance tax audit support· Marketing cost - direct and indirect review

· New Mexico Indian Audit reconciliation project to align C-115, OGOR, and Form 3 filings· Texas Severance Taxes and Account Reconciliations · GLO Royalty Reporting and Account Reconciliations· Louisiana Severance Tax and Royalty Reporting and Account Reconciliations · Process and procedure testing and documentation · Training regulatory accountants on account reconciliations and Excel functionality to create desk efficiencies · Created process and reconciliation tool to catch all severance tax incentives and audit Oracle setup screens· User Acceptance Testing as new versions are implemented and data is moved between servers

· Analyzed and filed Texas, Colorado, and New Mexico Escheat· Lead on 1099-Misc filings· Analyzed contracts and developed a Lease Provisions grid for all operated Permian Basin newly drilled properties to track all special terms and provisions· Tested and implemented new upload functionality for EnergyLink and OGSYS· Resolved ONRR data requests and audits · Responsible for account reconciliations and cash reports to management

· Reconciled $9.2 million of ONRR Federal and Indian Estimates from 1984 to inception in one month which enabled recovery of over $3 million in overpaid royalty estimates· Lead project team for EOG’s initial unbundling and account reconciliation efforts· Lead the Regulatory team and working with IT to improve the Severance Tax process and test enhancements in PRIMO. Ran SQL scripts to mass update Severance Tax reporting corrections to automate updates that otherwise would be manually input· Drove PRIMO program enhancement design, creation, and testing a new reporting feature for GLO regulatory reporting. Lead project with Land Administration to clear up all unreported royalties and to reconcile and correct all outstanding balances. Continually worked toward accurate reporting and identifying old outstanding issues that need to be resolved and corrected. Cleared over 11,000 lines of missing reports and built a new process to reconcile GLO reporting to ensure no further reporting omissions or errors. · Worked with App Manager and Spotfire to build a reconciliation tool between RRC reported data, revenue bookings, and CONG severance tax reports to identify over and under payments and to verify accuracy and ensure regulatory reporting compliance.· Responsible for GLO regulatory reporting, account balance reconciliations, and audits· Responsible for Purchaser Crude Oil reporting and in the first month have reconciled the account and built the necessary cross references and tools to recover millions in overpayments and GL discrepancies· Managed a Texas Severance Tax Audit and reduced current assessments by over $36 million · Assisted in divestiture activity and created reconciliation tools to clear open University of Texas audits· Cross trained on New Mexico and Louisiana Royalty reporting and Severance tax

· Analyzed, reconciled, and recorded Residue, Liquids, Condensate, and Oil for the St. Jo Kinder Morgan processing plant in the Fort Worth/Tyler DST· Reconciled and calculated the Fort Worth/Tyler WASP and Barnett Shale Pool schematics and MJEs· Processed and reconciled over 350 High Cost Well incentives and independently identified and reported over $270,000 in tax refunds that would have otherwise expired· Initiated and performed a desk deck audit to verify all effective dated decks were being appropriated recorded to and recovered millions in erroneously paid revenue to owners originally paid out and never corrected to the appropriate ownership · Reconciled and recovered over $1 million in overpaid Texas Severance Tax· Performed user acceptance testing on Waterfield software and created process documentation.· Developed a HTML script tool to automate data input where no uploads were available. Setup was completed in under a day that otherwise would have taken weeks.· Implemented several new processes and query checks to identify errors and reconcile AR balances· Redesigned revenue spreadsheets to comply with new critical spreadsheet guidelines

· Supported Revenue, Production, Cash, and Regulatory Accounting departments with Enertia troubleshooting and system enhancements· Created custom queries, reports, and databases for management reporting and error identification· Supported ONRR and BIA reporting

· BOLO software troubleshooting, testing, and user support· Proficient in using BOLO software including development and use of ad hoc UniQuery/SQL queries· Developed and maintained Spreadsheet Interface and FRB reports used for management reporting· Provided system and query training to Accounting, Land, and Audit users as needed· Audited and developed SOX compliant user profiles, approval process, and mapped BOLO maintenance and process screens to tables· Audited owner records and identified setup issues that were incorrect. Initiated and managed a mass owner and revenue deck and component clean-up project to correct all free deduct and tax exempt codes on 100% of the decks being used· Coordinated and supported a Texas Severance Tax Audit and was granted a clean opinion· Developed spreadsheets for Texas and Louisiana Severance Tax filing that reconciled the state history to the severance tax payable account and correctly file monthly returns· Assisted IT to design and build an automated Severance Tax data retrieval and calculation solution· Processed and audited 2012 and 2013 1099-MISC federal and state filings· Implemented new standards and created documentation for IRS compliant naming conventions and audited and corrected the Name and Address File· Initiated and utilized TIN Matching to prepare for the company’s initial Escheat processing

· Texas Severance Tax – initiated and completed a major project to reconcile inception to date records andfile corrections for High Cost Well deductions and Low Producer incentives. Cleared over $1 million in prior year issues and out of balances in the severance tax payable account. Reversed and rebooked 4 years of history to clear all outstanding issues and completely reconcile the Severance Tax Payable account· Performed acquisition accounting and setup including design and implementation of all spreadsheets, databases, and processes· Performed price, marketing and transportation deducts, and prior period variance analysis and issued reports for the Financial Reporting Package· Assisted in BOLO upgrade implementation and testing as well as process documentation and process improvement projects· Performed internal spreadsheet audits to develop efficient SOX compliant workbooks· Assisted revenue as a lead accountant, trained new employees, and reviewed journal entries

· Accounting analysis and support activities for Poland, Angola, as well as numerous other international holdings· Analyzed and reconciled monthly cash calls, joint venture activity, and intercompany activity· Reconciled balance sheet accounts, foreign currency international bank accounts, vendor accounts, lease accounts, VAT and Withholding Tax accounts· Analyzed and recorded outside operated joint venture billing and applied overhead· Provided budget comparisons and sunk cost schedules to engineers and budget coordinators· Recorded time deposits, settle intercompany accounts, wire clearing, and record capital stock transactions· Designed and built a MS Access database for analysis of outside operated joint venture billing for offshore Angola· Provided support to Business Development, Audit, Financial Reporting, and Tax departments as needed· Prepared quarterly statutory financial statements for Angola, the Netherlands, and Poland· Verified compliance with the JOA and PSA as well as internal policy· Prepared quarterly Due Diligence documentation· Traveled internationally to train in-country accountants, attend financial committee meetings, and assist governmental auditors in the preparation of statutory financial statements

· Recorded residue, natural gas liquids, lease use, and condensate revenue at the lease and plant level· Designed, created, and maintained integrated excel workbooks to streamline desk procedures· Researched, audited, and responded to owner inquiries· Reconciled Accounts Receivable, Gas In-Transit / Deferred Revenue, and General Ledger accounts, and maintained gas balancing· Performed volume, value, and price variance analysis· Worked extensively with advanced excel spreadsheets as well as Access databases, Business Objects, Discoverer, Oracle Financials, and TIPS· Provided data and reports to various internal and external parties and state reporting agencies· Initiated and completed projects to correct TIPS setup, updated booking procedures, and documented revised procedures· Rotated through 4 desks in 1 year to rebuild spreadsheets and correct and resolve historical out of balances and rebook properties from inception to date

· Reported, accrued, and reconciled monthly Texas Severance Tax filings · Designed and implemented new processes to reconcile and report severance taxes and clear critical errors and adjustment notices. Reduced monthly processing time from 3 weeks to 1 day· Reconciled GL Severance Tax accounts· Assisted in Sarbanes-Oxley Testing and documentation· Worked closely with Revenue accounting to set up tax exemptions and incentives· Created and maintained MS Access databases for various departments for litigation support and audit requests

· Conducted auditing engagements· Evaluated general computer controls· Engaged in internal research team project· Developed MS Access databases for management