Controller/Mentor/Financial Reporting/Eye for Detail/Execution

KEITH A. ROBLING

Cell: 832-***-**** Email: *********@**********.***

https://www.linkedin.com/in/keith-robling-608047b/

SUMMARY

Finance professional with over 25 years of domestic and international oil, gas, chemicals, and renewable wind experience in supervision, preparation of financial statements, month-end closings and reporting, SAP systems upgrades, training and user support, debt leveraged financing, budgeting and variance analysis, fixed assets, auditing, internal controls, SOX and IFRS. As an SAP Super User, I desire a position as an Accounting Manager or contract professional at a multi-national firm with an SAP ERP system. Since my career has been built on solving complex and challenging, financial problems, with an eye toward finding and recovering money, my branding slogan is “your problems are my solutions!”

PROFESSIONAL EXPERIENCE

LYONDELLBASELL INDUSTRIES, HOUSTON, TX 2011-2018

Sr. Lead Accountant, GPS Inventory (Apr 2012 – Mar 2018)

Consolidate world-wide inventories for LIFO/FIFO model calculations, prepare monthly/quarterly actual and forecast LIFO models and explain variances to Business Segment Leaders for Refining and Technology, balance monthly exchanges, record bookouts, perform standard revaluation reclass Journal entries globally, prepare stock effect calculations, clear Open Item Managed GL accounts, review and approve account reconciliations, prepare annual inventory values for property tax assessments and expense budget, assign LIFO codes to materials, update monthly inventory metrics and issues, prepare and file Government reports, including the annual MA-10000 and monthly M3 which has to tie to US total inventory by Company/plant, trouble-shoot SAP issues and assist with 3rd party inventory reconciliations. Assisted with Revenue Recognition project. Key accomplishments included:

1)Being able to recognize errors, quantify their financial impact and articulate or make the necessary corrections. In Q1 2018, I identified that prior period sales for an exchange were understated and revenue had not been invoiced since 2016 by $4.9 million. At year-end 2017, my LIFO calculation resulted in additional income of $38 million for the Refinery for which they only anticipated $20 million. In 2014, I recovered $10.6 million, primarily related to Buy/Sell exchanges that were incorrectly expenses or deferred revenue true-ups not recorded.

2)By changing the method of calculating crude volumes in LIFO model from Contract Notional volumes to actual volumes, this resulted in a favorable earnings impact of $5 million.

3)Observed that the standard unit cost in LIFO model had constants for three materials, due to zero inventories in the prior month, instead of a formula to recalculate the unit cost, which resulted in a favorable impact of $2.5 million.

Sr. Inventory Accountant (Contract Feb-Apr 2012)

Handled Polymer inventory transactions for LIFO, standard revaluation, exchanges and price variances.

SAP Global Close Coordinator (Contract 2011-2012)

Stabilized the month-end closing process and closed three months of financials for 140 global companies within the first month in SAP 7.0. Managed the closing cockpit, including SOX documentation of closing processes. Created transfer files in Profit Center Accounting to upload to Hyperion Financial Management (HFM) and controlled user access to OKP1 and OB52 tables in SAP. Analyzed and ran assessments, distributions and foreign currency revaluations. Resolved missing profit centers and trading partners, and coordinated efforts with Asia and Europe to close the SAP source system within first seven days each month and eventually to 4 days. Assembled the close calendar, ran daily close meetings and resolved user issues during month-end closing. Ran year-end SAP roll forwards and trained a permanent employee.

SHELL OIL COMPANY, HOUSTON, TEXAS 2002-2010

Senior Financial Analyst, Shell WindEnergy Inc (2008-2010)

Implemented SAP ERP financial system with subsequent upgrades, including data cleanses, data conversion, validation, testing and role-mapping and provided training and support of FI/CO/MM/PTP modules. Served as Implementation Manager, Regional Business Lead, User Access Focal Point, Super User, Smarter Spender and training facilitator for SAP upgrades. Created Master Data configuration change requests for vendors, assets and bank accounts, set-up user access, resolved vendor payment issues and trained field staff to use the system. After implementation, primarily assisted Contracting & Procurement with vendor spend. Performed fixed assets accounting, including FAS-143 Asset Retirement Obligations and bonus depreciation, and assisted with month-end financial closings. Capitalized fixed assets totaling $543 million in SAP and coordinated external audit, including preparation of lead audit schedules and identification and resolution of $60 million in audit adjustments. Key accomplishments included:

1)Saved Joint Venture Company over $200,000 in annual property taxes.

2)Identified $178,000 in duplicate vendor invoices and pursued recovery.

3)Closed year-end accounting books in absence of Finance Manager.

4)Initiated and conducted SAP training for staff at remote wind farm sites and corporate office.

5)Reconfigured vendors, customers, materials, projects and users for Go Live SAP deadlines.

6)Successfully migrated transactional accounting activities offshore to lower cost Shared Service Centers and developed supporting procedural documentation manual.

Senior Project Analyst (2005-2008)

Conducted special accounting projects on behalf of service and business units, developed and tested SOX controls for Controllers Department, performed quarterly audits for Shell Learning to ensure compliance and recovery of commission-based contract, performed reviews and responded to audits of employee travel expenses, served as administrator for monthly reconciliations of 2,300 General Ledger accounts, and focal points for Export Control, Supplier Diversity and Ethics & Compliance. Key accomplishments included:

1)Resolved 7 accounting projects in 9 months and shared key learnings with management.

2)Recovered $162,000 in commission revenues during two years of audits.

3)Recovered over $34,000 from incorrect employee expense claims.

4)Successfully disputed an escheatment claim of $11,000 by the State of California.

Controller, Shell WindEnergy Inc. (2003-2005)

Prepared and reviewed monthly financials for start-up wind business and subsequent joint ventures, including Income, Balance Sheet and Cash Flow statements and management information reports for seven operating companies while supervising accounting staff. The Company grew from $300 million to $500 million in annual revenues with $14 million to $20 million in annual operating expenses. Developed asset models to track and explain actual versus budget variances. Set-up Joint Venture accounting and off Balance Sheet financing when Shell sold 50% of its wind farm assets in three business deals with a combined value of over $300 million. Key accomplishments included:

1)Simplified the reporting complexity from seven entities to one.

2)Implemented a controls and governance structure.

3)Joint ventured and debt leveraged all five equity wind farms as well as managed the construction of another large wind farm in the same year.

Senior Internal Auditor (2002-2003)

Led small teams in the performance of joint venture, financial, operational and compliance audits.

EQUIVA SERVICES LLC, HOUSTON, TEXAS 1998-2002

(A Joint Venture between Shell, Texaco and Saudi Aramco)

Project Manager

Led small teams in the performance of joint venture, financial and operational audits, issued reports to senior management and conducted financial fraud investigations.

TEXACO CARIBBEAN INC, KINGSTON, JAMAICA 1996-1998

Financial Director/Controller (expatriate)

Directed retail accounting activities for 86 service stations and 3 terminals with $6 million in annual expenses and $30 million in assets. Coordinated monthly financial closings and reporting, capital expenditures, budgets and information technology systems while supervising a staff of 10. Managed currency devaluation and purchased $1.2 million USD monthly to settle product imports. Key accomplishments included:

1)Implemented PP&E software to track and depreciate fixed assets.

2)Received best internal audit review in history of Company’s marketing operations in Jamaica.

3)Conducted sensitive terminal investigation that involved the disappearance of cash and lubricants and resulted in the termination of five employees.

TEXACO LATIN AMERICA/W. AFRICA, MIAMI, FL/NIGERIA, AFRICA 1993-1996

Staff Analyst/Investigator

Conducted financial investigations and issued reports to senior management on fraudulent activities in Latin America and West Africa. Conducted accounting projects in Nigeria (reconciliation of bank accounts, accounts receivables and plant property & equipment valued at a total of $8 million USD) for 18 months to update accounting records due to three years of negligence and kept write-offs to a minimum. Analyst for Texaco’s marketing operations in Brazil and Central America to review and consolidate monthly financial results.

EDUCATION/PROFESSIONAL ASSOCIATIONS

B.S. Accounting – Indiana University, Bloomington, IN

Certified Fraud Examiner – National Association of CFE’s, Austin, TX (Jan 1993-Dec 2016)

Competent Communicator – Toastmasters International

Student Manager, Indiana University Football Department – Holiday Bowl Champions

Eagle Scout

Contact this candidate