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• Create and post consolidating journal… Show more • 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• Create and post consolidating journal entries in HFM• Manage maps, control tables, import formats and scripts in FDM• Move and reconcile data within the applications• Maintain and create Financial Reporting and Smart View reports for all applications• Provide end user Hyperion and Smart View training• Provide end user support for all applications and Smart View• Test and validate all high-level system changes• Sync Test and Development environments with Production• Maintain forecast and budget logic, drivers and calculations.• Prepare monthly labor forecast and annual budget for FP&A team• Prepare monthly and quarterly headcount analysis• Work with FP&A team on monthly forecasts and annual budget Show less

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 • 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 third party Hyperion support requests• Maintain system process and change management documentation• Maintain training guides and conduct end user Hyperion training• Test and validate high-level system changes (upgrades, patches, migrations)• Manage budget and forecast processes, including loading and reporting.• Maintain Accounting and Financial policies on the company intranet• Assist with SEC reporting and filings (10Q, 10K, 8K)• Quarterly reports package for Board of Directors, and investor presentations for CEO and CFO.• Led implementation of Hyperion financial system• Created process to reconcile all intercompany activity that led to resolution of large differences between companies and numerous historical differences• Automated the corporate G&A expenses reports and created process to reconcile to source ledgers• Automated a significant portion of the consolidated SEC financials • Created process to reconcile all rollforward activity including the associated currency translation adjustment• Created numerous system calculations that improved ease of reporting, and numerous reports that helped improve analysis and reporting capabilities. Show less

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• Prepared… Show more • 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• Prepared monthly DD&A expense depletion unit and business unit variance report and reviewed calculation of DD&A• Created monthly FA to GL reconciliation of DD&A expense by company• Prepared monthly gain/loss schedules for financial reporting• Responded to PP&E requests from domestic tax department, oil & gas operations, auditors, and other financial departments. Show less

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• Created and implemented FA to GL retirements and gain/loss… Show more • 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• Created and implemented FA to GL retirements and gain/loss reconciliation• Performed monthly close and analysis of 10 Oracle FA books• Prepared monthly reporting package for corporate accounting• Prepared all FA tax reporting schedules for tax department • Reviewed and approved all capital and non-capital projects• Prepared quarterly depreciation forecasts for all business units• Lead contact for all internal and external audit requests Show less

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• Prepared working capital analysis• Prepared trade receivables and DSO… Show more • 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• Prepared working capital analysis• Prepared trade receivables and DSO analysis• Provided custom financial reports and data to management for use in planning and decision making Show less

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 • 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, California, and short-year annual tax filings.• Provided property tax department with FA reports for annual property tax reporting• Prepared monthly confidential reserve analysis report for management• Prepared headcount and personnel expenses reports for management• Performed analysis and reconciliation of balance sheet accounts• Provided information for various FA-related government reports• Assisted with the estimate process, audits, and the quarterly dossier management report.• Created policies and procedures for various FA tasks and all FA tax reporting processes and related reports Show less

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• Assisted with special projects and provided schedules and reconciliations to external auditors

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 • 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 department and property tax department. Show less

Schofield Barracks, Hi

Accounting, Business

Operations Management, Business