Provided revenue accounting systems support primarily focused on royalty compliance reporting to the Federal ONRR agency and state agencies, as well as tax reporting to state agencies. • Prevented reporting penalties and fines by developing a series of reports to identify inconsistencies in the master data setup used to generate royalty compliance reports for various state and federal agencies. • Worked with Business Intelligence group to pilot moving ad-hoc reporting from IBI Web FOCUS environment to SAP S/4 HANA environment with reports written in Tibco Spotfire or WEWBI • Logged/documented production support issues in ServiceNow, a service request/incident logging application.• Worked directly with application users to analyze production support issues and provide instructions to resolve reported issues; worked with users and IT department to develop custom transactions in SAP/PRA.• Reported software issues to SAP/outside firms, and coordinated testing/implementation of software changes.• Provided data extract support to assist Revenue Accounting, Compliance and Tax Accounting, Marketing and Land Administration groups in decision making, audit support, etc.• Represented Apache in SAP/PRA Roadmap meetings. (Roadmap is a major redevelopment effort of the PRA application within SAP).

Served as support analyst for internally developed natural gas scheduling and settlements accounting systems. • Developed a report that cut the time required for gas marketing teams to generate Force Majeure documents when hurricanes caused or threatened the shutdown of natural gas production in the GOM. (Received an Outstanding Achievement award for this.)• Supported the implementation of an in-house-developed natural gas scheduling and accounting application and provided an analysis of the expected transaction volume which showed that the application could not support the number of expected transactions in other offices. • Logged/documented support issues in Remedy, a service request/incident logging application. • Worked directly with users to analyze issues and suggest work-arounds when needed.• Coordinated investigative efforts with environment support groups to resolve issues with the application environment.• Provided data retrieval support to improve the user’s ability to respond to audits, perform data analysis and respond/interact with third party information demands.• Coordinated deployment of software releases with the Software Release Team.• Coordinated Production Data Requests (PDRs) and conducted other appropriate testing (in conjunction with other NAGP Technical Teams) to ensure business requirements and compliance were met.• Analyzed current processes and information flows to identify strengths and weaknesses and provided technical trouble shooting as needed.

Provided data integration/retrieval support for all departments needing data from oil and gas revenue accounting and related systems, i.e. production, land, marketing, gas supply, financial accounting and tax systems. Data was used to defend litigation, provide information to business partners and assist accounting groups with daily activities and monthly close activities. • Developed a report to determine the financial impact of reversing and rebooking oil and gas revenue accounting transactions that was frequently within 50 cents of being accurate, exceeding client expectations. • Provided the detailed documentation needed to give the legal proof that all reports given to the SEC were accurate, thus disproving the plaintiff’s suspicion of inaccurate reporting and saving the client millions in legal fees and settlements. • Designed and implemented a weekly out-of-period accounting transaction report, extracting data from the PREMAS revenue accounting system mainframe DB2 data structures and downloading into a MS Access application for storage and reporting.• Designed and implemented SQL based data queries using a combination of Information Builders EDA SQL product and MS Excel/Query to support a revenue accounting desk documentation project, improving upon a system which relied on printing mainframe screens and consolidating results in another application.• Coordinated testing/verification of various data structures/platforms that were migrated to a Unix/Oracle platform for legacy system reporting.

Provided data integration/retrieval support for all departments needing data from administrative systems, including: production, land, revenue accounting, marketing, gas supply and financial accounting. Concurrently performed Hyperion System Administrator duties. Also installed/upgraded software products and maintained in-house software. Assisted with company’s web development strategy and choice of products for web application and client server system development. • Designed and implemented a weekly revenue monitoring and tracking system which cut costs 10,000%, from $150,000/year to $1,200/year. • Designed and implemented a Tax Credit Monitoring and Reporting system to track $100 million in annual Federal Tax Credits and provide audit support for audits conducted by the IRS.• Worked with the Revenue Accounting, Financial Accounting and Business Analysis departments to accelerate monthly accounting close process giving the company and an edge in reporting to investors.• Reduced the time it took top perform certain jobs from days to minutes/hours by designing and implementing a client server based application to allow clients from various departments to retrieve data from mainframe DB2 databases and transfer data directly to MS Excel.