John Holeman Email & Phone Number

Sugar Land, Texas

• Hyperion administrator for HFM, Essbase, Planning (including Workforce), and FDM.
• Manage metadata for all applications
• Manage all aspects of security, including user provisioning, application dimensions, and reports.
• Manage outlines, calculations, substitution variables and security in EAS.
• Manage data forms, task lists, calculations and data synchronizations in EPMA.
• Manage monthly consolidation and close process in HFM

Houston, Texas Area

• Hyperion administrator responsible for maintaining metadata, system calculations, financial reporting and SmartView reports, data forms and grids, financial statement certifications, and security.
• Manage monthly consolidation and close process for 110+ entities
• Review and approve chart of accounts mapping changes
• Review and reconcile all financial and statistical data from company loads
• Prepare and post all consolidating journal entries
• Manage internal end user and… Show more

Houston, Texas Area

• Fixed assets Oracle R12 implementation lead
• Led fixed assets process documentation and improvements initiative
• Created and maintained Microsoft Access database of FA module
• Reviewed and approved FA to GL account reconciliations
• Accounted for asset activity including additions, retirements, transfers, acquisitions, and divestitures and ensured accordance with US GAAP.
• Analyzed capital and construction in progress PP&E accounts for proper accounting

Houston, Texas Area

• MyAssets and MyAFE system administrator
• Led implementation of seven additional tax books in Oracle
• Created Oracle FA upgrade testing requirements and test scripts
• Created process to reconcile MyAssets system to Oracle
• Created rig sale procedure and standardized documentation process
• Created the MyAssets interface and intercompany business unit transfers automation program requirements

Houston, Texas Area

• Coordinated and prepared quarterly and yearly consolidated GAAP financial statements and footnote disclosures
• Prepared monthly cash flow, balance sheet, and debt/interest analysis.
• Prepared monthly corporate debt forms and gap analysis
• Prepared quarterly dossiers, management forms, and related forms and schedules.
• Prepared and consolidated estimates
• Calculated royalties

Houston, Texas Area

• Performed monthly FA system close for corporate book and nine tax books
• Maintained nine FA tax books (including additions, retirements, cost and depreciation adjustments, acquisitions, and divestitures).
• Prepared monthly analysis reports of corporate and federal tax gain/loss from the sale of FA, and federal tax and purchase nontax depreciation for use in the tax provision.
• Provided tax department with all FA-related, and several GL-related reports for federal, state… Show more
• Provided tax department with all FA-related, and several GL-related reports for federal, state, California, and short-year annual tax filings.
• Provided property tax department with FA reports for annual property tax reporting

Houston, Texas Area

• Managed A/P and A/R for eight subsidiary companies
• Prepared all A/P and A/R journal entries
• Prepared and filed state sales and use and corporate franchise tax returns for all subsidiaries
• Received, recorded, applied, and deposited all customer payments.
• Bank contact and lockbox administrator
• Assisted with bank reconciliations and daily cash report

Houston, Texas Area

• Entered AFE account and budget numbers in AS400 and maintained AFE log database in Microsoft Access
• Reviewed capital spending for coding accuracy and budget adherence and made necessary entries to correct
• Reconciled sub ledger to general ledger for all FA accounts
• Recorded additions, retirements, and transfers (including accounting for acquisitions and divestitures).
• Reconciled FA physical inventory lists to AS400
• Prepared various schedules for management, tax… Show more

Schofield Barracks, HI

Accounting, Business

Operations Management, Business