Hyperion Financial Systems Consultant
Confidential, (Multi Service Company, Systems development and consulting solutions)
September 2005 – Present
Implemented and rolled out Hyperion Financial Management Systems 9.
Engage in writing Hyperion Reports, Systems Development, Design, and Upgrades.
Engage in creating complex Smartview Retrieve Spreadsheets.
Engage in Systems Integration, Development of Web Forms, and Data Forms.
Engage in Data validation between Hyperion Enterprise and HFM.
Engage in Hyperion Enterprise systems Maintenance.
Assist with month end close and Load data from general ledger system to Hyperion
Generate Financial Statements – P&L and Balance Sheet and creating Automated Cashflow.
Reconcile all prior year data.
Accounting/Financial Systems Manager
Confidential, (Domestic / International Inter-Dealer Broker of Money market Derivative and Securities Products)
March 1999 – August 2005
Implemented and rolled out Hyperion Enterprise 4.3.1.
Converted/Upgraded Enterprise 4.3.1 to Hyperion Enterprise 6.5.
Wrote all Financial Statements Hyperion Reports for Management.
Coordinated Euro Brokers/Maxcor Worldwide Consolidation for over 5,000 legal entities.
Set up LedgerLink, Chart of Accounts, and Organization Structure.
Prepared Revenue Reports, Balance Sheet, and Income Statement.
Prepared Variance Analysis Reports including Budget, Forecast, and Actual.
Prepared GAAP, 10Q, 10K, Month End Closings, and Year End Roll-over.
Supervised two staff accountants.
- IT Environment: Hyperion Enterprise 5.0, 5.1, 5.3, 6.2, 6.3, 6.4, 6.5.
Worldwide Hyperion Enterprise System Administrator
Confidential,. (Premier Auction House)
February 1998 - March 1999
Completed the final phase of the Enterprise implementation system.
Set up Enterprise, Retrieve, and Reporting on the users desktop.
Corrected G/L mapping accounts to Hyperion accounts on LedgerLink.
Loaded financial statement data from North America, Europe and Asia into Hyperion database and run consolidation.
Participated in writing Hyperion financial statements reports and books.
Engaged in Hyperion Enterprise System conversion from 4.2 to 4.3.
Designed and developed new Enterprise application in line with SAP.
Responsible for HE support and maintenance function on a daily basis
- IT Environment: Hyperion Enterprise System 4.2/4.3, LedgerLink, SAP
- Financial Analyst/Hyperion System Administrator
Confidential, (Provider of Malpractice and Brokerage Insurance)
October 1994 – January 1998
Prepared budget, actual, forecast, and cash flow reports.
Conducted variance and profitability analysis.
Established profit/loss statement and balance sheet using the Hyperion Report Writer.
Organized consolidation of North America strategic business units.
Coordinated the implementation, set up, and training of Hyperion Enterprise, Hyperion Analyst, and Retrieve Hyperion.
Maintained Entity Hierarchy, Chart of Accounts, Logic, Multi-currency Applications.
Monitored the group quarterly reporting package including P&L, B/S, and taxation.
Created trend and performance reports including special projects assigned by VP.
Engaged in system maintenance, system extract & Load, name and account conversion table, namelist, attaching reports to book, underlying currencies, upload & download of data from Hyperion Enterprise to Excel.
Main point of contact for Hyperion support and maintenance.
- IT Environment: Hyperion Enterprise 1.8, Hyperion Report Writer, Hyperion Analyst, Retrieve Hyperion.
Various consulting positions in Accounting and Finance with clients including
Confidential,January 1991 - September 1994
Hyperion and SAP R/3 training and seminars
B. S. in Accounting
Hyperion Enterprise 6.5, Hyperion Financial Management System 9, Hyperion Reports, Smartview, Hyperion Enterprise Report Writer, Hyperion LedgerLink, Financial Data Quality Management, Hyperion, AutoPilot, Hyperion Retrieve and, K-Edit, MS Access, Microsoft Excel, Microsoft Word, Win Zip, Crystal Reports, Lawson G/L, SAP R/3, SQL, and Weblogic.
TRAINING: Hyperion Enterprise, Hyperion Financial Management, Hyperion Reports, and SAP R/3
training and seminars.