JAMES P. REGAN

*** ********** ****

Forsyth, Illinois 62535

630-***-****

adjrfw@r.postjobfree.com

www.linkedin.com/in/james-regan-mba/

SUMMARY

An accomplished and results-driven financial reporting manager with a demonstrated track record of achievement in technical system administration, procedure development, business management, forecasting, and strategic planning. Comprehensive experience in project management, error resolution, variance reporting, process improvement, accounting, and audit compliance. Established capabilities in user training, process mapping, account management, data analysis/management, and quality assurance. An exceptional and meticulous leader who leverages highly-developed analytical skills to implement corporate policy and drive cost-saving initiatives.

EXPERIENCE

ARCHER DANIELS MIDLAND, Decatur, Illinois

Corporate Accounting EPM BI and Reporting Administrator, 2018-2020

Performed all system administration duties for Hyperion financial reporting, planning, Essbase, and Oracle Business Intelligence Enterprise Edition to ensure system security and data integrity. Supported business units with issues in monthly financial data report submission and other error resolutions. Facilitated user training sessions on Smartview, Hyperion Reporting, and OBIEE.

Automated delivery of various financial reports to internal customers.

Created new dashboards in OBIEE to improve metadata management process.

Senior Business Analyst, 2011

Served on project cornerstone technology and mapping teams and aided software selection committee. Led demonstration sessions on software capabilities. Evaluated and recommended consolidation and reporting software solution to management. Mapped general ledger data to Hyperion chart of accounts.

Directed RFP process for software installation partners.

Authored mapping guide for regional general ledger teams.

GLOBAL BRASS and COPPER HOLDINGS, Schaumburg, Illinois

Hyperion Administrator, 2013-2018

Performed all system administration duties for Hyperion financial management and financial data management to ensure system security and data integrity. Coordinated and supported business units in monthly financial data submission. Generated monthly financial reports for management. Maintained user access to banking applications. Reviewed SEC filings.

Managed process to map new ERP general ledgers to Hyperion chart of accounts.

Created numerous improvements to key supplemental data load forms.

ATKORE INTERNATIONAL, Harvey, Illinois

Financial Systems Manager, 2011-2013

Coordinated and supported business unit controllers in monthly actual and forecast data submission. Performed all system administration duties for Hyperion Enterprise and Financial Data Quality Management to ensure system security and data integrity. Prepared and reviewed SEC filings. Managed relationship with hosting support partner. Created validation templates for end users.

Created multiple new Hyperion reports to automate management reporting.

Initiated procedures to improve financial system change control and user access review processes.

ADDITIONAL EXPERIENCE

SUN TIMES MEDIA HOLDINGS, Chicago, Illinois, Manager of Financial Systems and Consolidations, 2004-2010. Prepared SEC filings, monthly financial statements, annual budget, and consolidated work papers. Performed all system administration duties for Hyperion Enterprise, financial data quality management, Oracle eBusiness Suite, and Microsoft Dynamics applications to ensure system security and data integrity. Served as project coordinator for successful implementations of Oracle eBusiness Suite and Hyperion Enterprise. Initiated processes and procedures to meet SOX compliance.

AUX SABLE LIQUID PRODUCTS, Morris, Illinois, Financial Accountant / Systems Administrator / Accounts Payable Supervisor, 2001-2004. Generated monthly financial statements. Maintained financial applications with GEAC Smartstream and EnteroVision. Coordinated month/year-end closings and annual external audits. Implemented new enterprise system EnteroVision with accounting department. Coordinated month-end closings and shortened closing timeline by 30%.

MONTGOMERY WARD & CO., Chicago, Illinois, Financial Reporting Manager, 2000-2001. Generated consolidated financial statements. Performed all system administration duties for Hyperion Enterprise to ensure system security and data integrity. Served as main contact to internal and external audit teams. Created efficiencies in financial reporting department. Leveraged system capabilities and allowed management to reduce department headcount 88%. Completed implementation of Hyperion Enterprise and achieved certified Hyperion Enterprise administrator status. Automated subtenant receivables process to accelerate cash receipts. Managed project to automate reporting to new parent company GE Capital.

Financial Reporting Staff Accountant, 1998-2000.

Lease Accounting Staff Accountant, 1997-1998.

EDUCATION

BENEDICTINE UNIVERSITY, Lisle, Illinois

M.B.A., 2005

NORTHERN ILLINOIS UNIVERSITY, DeKalb, Illinois

B.S., Finance, 1997

Software Administration Experience

Hyperion Financial Management, Financial Data Management, Essbase, Planning, SmartView, Enterprise, Oracle Business Intelligence Enterprise Edition, Oracle eBusiness Suite, Geac, Smartstream

Contact this candidate