Hyperion Techno Functional For In-house Administrator Resume
SUMMARY:
- Senior consultant with a deep knowledge on both sides of the business intelligence equation that has excellent design and problem - solving skills.
- 21 years of experience including analytics, management, tax and consolidation accounting on the business side and Oracle’s Hyperion Essbase, Planning, Financial Management, FDM, Smart View along with in ODI and DRM as well as SQL, VBA and other advanced Microsoft skills.
- Specialty skill include Object Oriented Synthetics, that he devised, which are a very valuable aid for designing, re-designing, integrating and troubleshooting applications.
PROFESSIONAL EXPERIENCE:
Confidential
Hyperion Techno Functional for In-House Administrator
Responsibilities:
- Provide support, to include Administration, Trouble Shooting and Developmental Follow up for Hyperion 11.1.2 Public Sector Planning and Budgeting, Planning, Essbase, Financial Reports, Financial Data Quality Management, and Oracle Data Integrator for Sierra - Cedar clients.
Environment: Hyperion 11.1.2 Focus Area: Hyperion - PSPB, PBCS, Planning, Essbase, Financial Reports, FDMEE, EPMA. DRM
Confidential, Alpharetta, GA
Administrator and Developer
Responsibilities:
- Filled in for the departure of the previous team to keep the applications up and running along with making optimization and functional improvements.
Environment: Hyperion 11.1.2
Confidential
Consultant and Developer for Troubleshooting and Development
Responsibilities: -
- Troubleshot and manned the current implementation of the Hyperion Public Sector Planning and Budgeting project that was targeted for completion within the current month.
Environment: Hyperion 11.1.2
Confidential, Houston, TX
Technical Developer
Responsibilities:
- Served as the technical developer for the Hyperion Planning project.
Environment: Hyperion 11.1.2
Confidential, Dallas, TX
Developer for Position Employee Budgeting
Responsibilities: -
- Assist in the rewrite of the Employee and Position Planning and Expense cubes, business rules, calculation scripts and to create several reports.
- Solve all issues with the Hyperion Employee and Position custom cube and deploy it to production right on schedule.
- Make last minute adjustments to the Expense cube and it is slated to go live mid-month.
Environment: Hyperion 11.1.2
Confidential, Fort Worth, TX
Designer and Developer
Responsibilities:
- Implemented Hyperion 11.1.2.2 Public Sector Planning and Budgeting across seven universities.
- Each school has its own Public Sector Planning database for human resource and a revenue/expense database along with two Aggregate Storage Option databases for reporting if needed.
Environment: Hyperion 11.1.2
Confidential, Ann Arbor, MI
Designer and Developer
Responsibilities:
- Provided Hyperion 11.1.1.3 Essbase Block Storage optimization assessment and determined that the forecast cube would convert nicely to the Aggregate Storage Cube (ASO) option.
- Converted the forecast cube to ASO, along with the necessary exchange formulas, mxl, automation scripts and financial reports, to shave hours off the daily cycle.
Environment: Hyperion 11.1.1.3
Confidential, Houston, TX
Designer and Developer
Responsibilities:
- Served as a Hyperion 11.1.1.3 Financial Data Management (FDM) and Essbase developer responsible for overall technical and functional design and development of the FDM application and the integration to along with and corresponding Essbase scripting and operational integrity.
- Added a complex time matrix to the Essbase cube in order to provide various cross dimensional views for reporting and analytics.
Environment: Hyperion 11.1.1.3
Confidential, NY, NY
Consultant for Review
Responsibilities: -
- Served as an architect for Financial Data Management and various integration aspects with Essbase and Hyperion Financial Management.
- Critiqued and consulted about the architectural and functional concerns for different aspects of the Hyperion 11.1.1.3 suite accompanied with reviews and recommendations.
- Focused on FDM performance characteristics and data flow options.
Environment: Hyperion 11.1.1.3
Confidential, Chicago, IL
Consultant for Enhancement
Responsibilities:
- Served as an architect for Financial Data Management (FDM) and various integration aspects with Essbase and Hyperion Financial Management.
- Critiqued and consulted about the architectural and functional concerns for different aspects of the Hyperion 11.1.1.3 suite accompanied with reviews and recommendations.
- Focused on FDM performance characteristics and data flow options.
Environment: Hyperion 11.1.1.3
Confidential
Consultant for Enhancement
Responsibilities:
- Served as an architect for Financial Data Management (FDM) and various integration aspects with Essbase and Hyperion Financial Management.
- Critiqued and consulted about the architectural and functional concerns for different aspects of the Hyperion 11.x suite accompanied with reviews and recommendations.
- Focused on FDM performance characteristics and data flow options.
Environment: Hyperion 11.1.1.3
Confidential, Danbury, CT
Developer for Implementation
Responsibilities:
- Served as the Financial Data Management (FDM) developer for a Hyperion Financial Management (HFM)\Planning EPMA project mostly responsible for import formats, scripting and mapping, used two adapters for one application and used the same data loads to each of the 80 plus HFM locations to load to a sister Planning location.
Environment: Hyperion 11.1.2
Confidential, Ann Arbor, MI
Designer and Developer for Implementation
Responsibilities:
- Led the design and development for a Hyperion 11.1.2 system Planning project.
- Two applications with four Planning databases and three detail Essbase databases all custom built including custom workforce and capex cubes, web forms, reports and smart view.
Environment: Hyperion 11.1.1.3
Confidential, Houston, TX
Contractor for Upgrade
Responsibilities:
- Performed a total Hyperion 11 system reconciliation for a Hyperion Financial Management upgrade along with a partial split out to Planning and Essbase Aggregate Storage Option.
- It was a new install of Data Relationship Management along with the upgrade and change in dimensionality that required the extensive reconciliation.
Environment: Hyperion 11.1.2
Confidential, Houston, TX
Administrator and Developer from Administration
Responsibilities:
- Provided ongoing support and troubleshooting along with the IT department, along with a Planning upgrade and partial rewrite of the Planning metadata and calc scripts.
- Troubleshot Planning and Hyperion Financial Management (HFM) business rules, developed system 9 backup and restore procedures along with using the Synobjects concepts to architect an Essbase prototype to facilitate the data transfer between applications and reports.
Environment: Hyperion 11.1.1.1
Harris Corporation, Melbourne, FL
Developer for Upgrade
Responsibilities:
- Provided ongoing development and administration support and custom scripting to improve and upgrade two Essbase, one Planning and a Financial Data Management application from Hyperion 7 to 9.1 along with performing support work with financial reports, Smart View and Web Analysis.
Environment: Hyperion 7 to 9.1
Confidential, Houston, TX
Administrator and Developer for Administration
Responsibilities:
- Prepared the current Hyperion Planning system for the New Year. Performed the necessary Planning administration functions, upgraded the business rules and reconciled the results for the 2009 budget and forecasting processes.
Environment: Hyperion 4.x
Confidential, Chicago, IL
Designer and Developer for Implementation
Responsibilities:
- Completed the development on the WIP cube. Started with shell design, rethought and developed the Essbase cube, dynamic members, calculation logic and the legacy ETL.
Environment: Hyperion 9.x
Confidential, Houston, TX
Administrator and Developer for Administration
Responsibilities:
- Automated the SEC 10q and 10K reports along with several other internal reporting packages and researched and optimized Essbase automation and control procedures.
- Interacted with management and staff to obtain the necessary information while completing the development of the Hyperion Essbase and Reporting tools in order to complete the task at hand.
Environment: Hyperion 9.x