Hyperion System Administrator/ Hyperion Consultant Resume

Title
Hyperion System Administrator/ Hyperion Consultant

Primary Skills
Over ten years Hyperion Systems especially in the area of designing, reporting, analyses and planning.

Location
Canada-ON-Toronto

Posted
May-14-09

EXPERIENCE PROFILE
• Extensive experience developing Enterprise Financial Systems using Hyperion System 9, Hyperion Enterprise, Hyperion Analytic Services, and Hyperion Financial Management in large companies.
• Proven experience in Accounting & Auditing specialized in financial reporting.
• Over one year of Oracle - OFA/Discoverer Reporting.
• Extensive knowledge of Financial Statements, Reconciliation, Payroll, A/R, A/P reporting and analyses, Capital Assets Management, Budgets, Forecasts using Hyperion, Oracle, Excel, Lotus, various General Ledgers and SQL.
• Ability to design, develop, upgrade, troubleshoot and maintain complex operational and financial systems; exposure to financial systems architecture/infrastructure.
• Developed systems documentation in support of business policies and procedures.
• Ability to plan and work on multi-task and balance multiple priorities.
• Implementation and support of continuous improvements of information systems.
• Assist and conduct end-user training in Finance applications.
• Proven track record of providing value-added service to the businesses.
• Self starter and team player with the ability to work under pressure in dynamic environments.


CAREER HISTORY
TRAVELEX INC Feb 2008 -- Apr 2009

Hyperion Financial Management

• Enterprise to HFM Global conversion Project
• Part of Global implementation responsible for North America
• Integration through FDM by business division
• HFM Training for North American counterparts
• Financial & Management & Statutory Reports
• Data Validations and Smart-view Reports
• SQL scripting and Crystal Reporting
• Divisionalization business by function
• Recommendation and implementation of changes to process.
• Monthly maintenance and Reporting.

INTRAWEST ULC Aug 2007 -- Dec 2007

Hyperion Financial Management Administrator

HYPERION System 9 Administration
• HFM/Analytic Services/BI+ Reporting system administration
• System update & maintenance
• Security maintenance for global users
• Stabilization of the system across the organization.
• Recommendation and implementation of changes to process.
• Monthly maintenance and Reporting.

THE NIELSEN COMPANY (AC NIELSEN CANADA) March 2006 -- July
Financial Reporting Accountant/Hyperion Administrator

HYPERION Systems 9 Administration & Data Maintenance
• Ensure consistency between SAP, Hyperion and Expense Planning.
• Update rollups according to organizational changes.
• Review and update Cost Centre list and Chart of Accounts.
• Maintain systems when updates are required.
• Define standard checks to ensure accuracy of data
• Complete monthly financial close and analysis.
• Meet due dates established by New York.
• USGAAP implementation

Month-end Financial Close Process -- Implemented new Departmental month-end report card
• Created month-end close calendar for the Department based on input from New York, Allentown, Controller and the Department; issued the calendar and posted to the intranet.

Global Business Initiatives --GBI Reporting
• Ensure that all GBI entries are completed and accurate per the month-end calendar.
• Accurately track the development costs for each new release.
• Roll over completed (FAS86) product releases on a timely basis.
• Maintain continuity schedule that provides support for amortized development costs.
• Deliver analysis and timely reports as requested by both internal and external clients.
• Review the new GBI report and make recommendations on how to implement the new GBU reporting.


STAN CONSULTANTS May 1999 -- May 2006
Self Employed Consultant
Worked with Financial Information systems for large companies such as Toronto Hydro, SIEMENS Canada, Publics Group SA, Alcan Aluminum, Sun Life Financial, Brookfield Properties, MDC Communication, Boliden, Canada Life and GEAC

HYPERION ENTERPRISE -- Consolidation Tool

• Developed systems solutions and modified or upgraded existing systems procedures as needed.
• Developed financial and management reports for companies and their subsidiaries including: Consolidation, Inter-company elimination and adopting GAAP principles.
• Completed various financial analyses which involved the administration of the financial reporting systems in Hyperion and spreadsheets.
• Developed systems documentation in support of business policies and procedures.
• Analyzed and evaluated business system needs and objectives for the customer community and developed proposals for solving business problems.
• Implemented software upgrades, quality assurance standards and document procedures.
• Performed Quality Assurance testing of the financial systems.
• Conducted Beta testing, developed test cases and managed the testing environment and backup procedures.
• Coordinated problem resolutions with Hyperion and IS representative.
• Assisted and conducted customer training in Finance applications.

HYPERION ESSBASE -- Planning Tool

• Built the designed solution for the district/area of responsibility:
o Hyperion Application links to load meta data
o Essbase load rules to load data
o Input Forms
o Hyperion Business rules or Essbase calc scripts for calculations
o Reports
o Security
• Ensured alignment of the Hyperion Planning tool with the client's districts business processes.
• Transferred knowledge.
• Assisted in implementing Hyperion Planning.
• Resource and Activity based budgets for Electric System Limited (95% of the company's Budget).
• Knowledge transfer and end-user training.


ORACLE OFA/DISCOVERER - Reporting Tool
Developed Oracle based reports for Corporate Reporting department


NN FINANCIAL (Member of ING GROUP) Jan. 1990 -- May 1999
Financial Systems Analyst
• Produced financial reports and other financial analyses for the company and its subsidiaries which involved the administration of the financial reporting systems in Hyperion and spreadsheets.
• Developed the Management Information Package (MTP) & Flash Reporting. Developed monthly Flash Report that captured financial information enabling management to monitor items that were critical to its success.
• Financial data base administration: strong working knowledge of Focus, Lotus, Excel, Hyperion and Capsil so that desired programs could be developed, run and updated as needed.
• Financial Management System development & Support (e.g., Hyperion & Focus): provided guidance, feedback and analysis in the Development of a financial management information system.
• Report for Parent Company in Amsterdam's and Atlanta's Management Groups.
• External Industry and association reporting: TRAC, A.M. Best, LOMA, Emap, Statistics Canada and CLHIA.
• Financial Analysis & Special Projects such as new Management applications.

EDUCATION

York University, 4 years fulltime studies; CMA Finalist

PROFESSIONAL AFFLIATION
Hyperion Certified Professional

TRAINING & PROFESSIONAL UPGRADING

University of Toronto -- Deeds Project - Dec. 2003
Hyperion Planning Training -- May 2002
Hyperion Essbase Boot CampTraining -- Dec 2001
Hyperion XA Upgrade Training - Jul 1998
Hyperion API Toolkit Training - Nov 1997
Hyperion Advance Reporting Training - Aug 1997
Hyperion Add-On Modules Training - Jun 1996
Ontrack System Administrator Training - Apr 1995
Hyperion System Administrator Training - Nov 1994
Finalist Certified Management Accountants of Ontario Jun 1992

E-Commerce Application Development using the Oracle 9i Database Server and the latest Internet technologies including JAVA, XML and .NET

Hyperion Users Conference: 1996 (Dallas, Texas), 1997 and 1998 (Orlando, Florida) and
2000 (Las Vegas, Nevada)
Genexus User Conference: 2004 (Uruguay, Montevideo)

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Toronto, ON | Resumes in Ontario

View other Hyperion System Administrator/ Hyperion Consultant resumes