Rafael Laurentin, Mba Email & Phone Number

Irving, Texas

Responsibilities included, but were not limited to:• Booking Oil, Gas, and NGLs to assigned properties• Booking transportation charges and other deducts for assigned properties• Make prior period adjustments due to volume or price changes by producers•. Analyze Accruals using LOS report for the last twelve months• Prepared monthly Accrual spreadsheets for upload into accounting system• Accounts Reconciliations, General Ledger Reconciliation for assigned accounts• Helped revenue supervisor in special projects, such as working on old items needing recon• Worked closely with production accountants to accurately book assigned properties• Revenue Agreements set up per land department and contractual agreements

Orcutt, California

Responsilbilities Include, but not limited to: • Sole revenue accountant for start-up company Pacific Coast Energy Company after split off from Breitburn Energy• Acted as Marketing analyst Calculating monthly pricing by utilizing average prices and average gravity from the four major oil and gas companies in order to calculate Bbls sales price• Worked on Revenue Accrual calculations for the finance department to complete the Net Profit Interest report for company’s Trust• Calculated payment to five royalty owners before bookings per contractual agreement• Worked the following areas of revenue bookings, allocations, accruals, prelist, check write, check voids, check print out, check mailing, accounts reconciliations etc.• Set up property masks, and purchasers.• Reported directly to company controller • Interacted with Engineering and production departments on a daily basis

Irving, Texas

Responsibilities included, but were not limited to:• Booking Oil, Gas, and NGLs to assigned properties• Booking transportation charges and other deducts for assigned properties• Make prior period adjustments due to volume or price changes by producers• Make prior period adjustments on properties per land department depending on ownership • Prepared monthly spreadsheets for upload into accounting system• Accounts Reconciliations• Helped revenue supervisor in special projects, such as working on old items needing recon• Worked closely with production accountants to accurately book assigned properties• Revenue Agreements set up per land department and contractual agreements

Houston, Texas Area

Responsibilities included, but were not limited to:• Booking Oil, Gas, and NGLs to assigned properties• Booking transportation charges and other deducts for assigned properties• Make prior period adjustments due to volume or price changes by producers• Make prior period adjustments on properties per land department depending on ownership • Prepared monthly spreadsheets for upload into accounting system• Accounts Reconciliations• Helped revenue supervisor in special projects, such as working on old items needing recon• Worked closely with production accountants to accurately book assigned properties• Revenue Agreements set up per land department and contractual agreements

Houston, Texas Area

Responsibilities Included, but not limited to working full revenue accounting cycle• Make prior period adjustments as needed by the company• Accurately record monthly revenue, royalty, and transportation costs for assigned properties• Prepare reconciliations and variance analysis for property activities• Booking value adjustments only• Support Owner Relation inquiries• Cooperate with other departments in providing information as required or requested• Well set up in Oracle, and POS software’s• Set up excel spreadsheets for uploads into system• Journal entries• Document processes and procedures for revenue and royalty accounting• Manual party transactions• Identify and work on accounts reconciliation issues• Work on big PPA projects as needed by the company

Houston, Texas Area

Responsibilities include, but are not limited to working on different projects set forth by revenue manager such as.Reversing and rebooking wells for the last five years in order to reallocate as mandated by contractual agreement and audit request.Compare upload spreadsheets to journal entries to determine whether the allocations are correct for reversal.Assist full time revenue accountants on issues and projects as needed.Account reconciliationsPrepare reversal spreadsheets for PPA'sTest upload sheets in test mode for accuracyNew software set up validationCash posting for other accountants

Houston, Texas Area

Responsibilities Include, but are not limited, to managing the entire revenue process of oil, gas and natural gas liquids wells.Allocated production volumes to wells according to percent of proceed statements on Gas and Natural Gas Liquids.Transferred allocated volumes from production to each facility in the property allocation spreadsheetCalculated production allocation percentages to different wellsCompared total gross volumes per each property from operator data to data entered into the property allocation spreadsheetsChecked for correct product pricingCompared the company's sales volume from the marketers invoice to the property spreadsheetVerified sales by batch report to ensure accuracy to the property allocation spreadsheetProcessed gross sales calculation to calculate the necessary deductions such as taxes for each wellCalculated the revenue distribution process to perform distribution to all owners by wellAnswered owner calls with inquiries regarding the production and revenue issues on certain wellsWork on purchasers account receivables to determine if what was paid was in accordance with reportingCalculate prior period adjustments due to well production changes or ownership changesCalculate severance tax and regulatory tax for federal tax reporting groupApplied cash to accounts to offset production bookings and moved cash from cash clearing account into different bucketsWork with Excalibur accounting software

Tulsa, Oklahoma Area

Responsibilities include, but are not limited to, managing the entire production process and revenue of gas wells.Set up new gas production wells.Set up royalty contracts Enter estimated journal entries on well that have ownership has not been received from Division Order.Accounts receivable reconciliationProcessed joint venture changes Processed payoutsExpense and Payables Accounting Asset and Cost information ManagementCalculation of prior period adjustments due to well head production changes or decimal allocation changesCalculate Advalorem taxes on Harrington Federal wellsUnapplied cash reports and reconciliationChange of Ownership on wells, from temporary set up to permanent set upsWork with SAP system in Production and Revenue Accounting

Responsibilities include, but are not limited to: Assist students to fill out the Free Application for Financial Student Aid (FAFSA) in conjunction with the University's Financial Aid Website (FAW).Knowledge of Sarbanes-Oxley Act of 2002.Maintained the Family Education Rights Practices Act (FERPA) in order to comply with federal regulations.Student Matriculation.Certify students for additional funds in accordance with amount of scheduled classes, completed paperwork, loan amounts in comparison with completed credits or credits transferred.

Tulsa, Oklahoma Area

Managed and oversaw operations, maintenance, and administrative functions for residential property valued at $9 million .Planned, scheduled, and coordinated general maintenance, major repairs, and remodeling and construction projects for residential propertyProcessed accounts payables for vendors who provided services to facilitiesEntered payroll hours and calculated overtime hours accordinglyProcessed accounts receivables from leasers and entered into accounting system for accreditationWorked closely with annual company budgetRecruited, hired, and trained managerial, clerical, and maintenance staff, and contracts with vendors for security, maintenance, extermination, and groundskeeping personnelMaintained records of sales, rental and usage activity, special permits issued, maintenance and operating costs, and property availabilityPrepared reports summarizing financial and operational status of property and facility on a weekly basisConferred with legal authority to ensure transactions and terminations of contracts and agreements were in accordance with court ordered, laws, and regulationsAssembled and analyzed construction and vendor service contract bidsPurchased building and maintenance supplies, equipment, and furnitureDirected and coordinated the activities of staff and contract personnel and evaluated performanceDirected collection of monthly assessments, rental fees and depositsProvided support to complex owners in translating marketing brochures from English to Spanish for the Mesa, Arizona and surrounding areasParticipated in marketing events to increase occupancy in five apartment complexes managed by Tipton Group

Bs Businesss Accounting, Business Accounting, 2007

Mba, Masters In Business Administration

Revenue Accounting, Revenue Accounting

Oil and Gas Revenue Accounting