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 suite including Planning (on premise and PBCS), Essbase, Financial Management, FDMEE, Smart View along with training 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.

DETAILED PROFESSIONAL EXPERIENCE:

Confidential

Hyperion Manager

Responsibilities:

• Provided support, to include Administration, Trouble Shooting and Developmental
• Management and Administration of several aspects of The Accounting and Reporting environment including changes and corrections, for each.

Environment: - Amazon Work Station, Oracle Public Cloud Budgeting Services

Confidential

Hyperion Techno Functional for In-House Administrator

Responsibilities:

• Provided 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 for Application Administration, Troubleshooting and Rework

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

Focus Area: - Hyperion Planning

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

Focus Area: Public Sector Planning and Budgeting

Confidential, Houston, TX

Technical Developer

Responsibilities:

• Served as the technical developer for the Full Life Cycle Hyperion Planning project.

Environment: Hyperion 11.1.2

Focus Area: Hyperion Planning

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

Focus Area: Custom Based Employee Planning, EPMA, Calc-Manager, Financial Reports

Confidential, Fort Worth, TX

Designer and Developer for Public Sector Planning

Responsibilities:

• Technical Lead in a team of two for a Full Life Cycle Development of Hyperion 11.1.2.2 Public Sector Planning and Budgeting Template to be used across seven universities.
• Each school has its own Public Sector Planning database for human resource and a Planning revenue/expense database along with two Aggregate Storage Option databases for reporting if needed.

Environment: Hyperion 11.1.2

Focus Area: Public Sector Planning and Budgeting, Essbase, Financial Reporting, Aggregate Storage Option

Confidential, Ann Arbor, MI

Designer and Developer for Optimization

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

Focus Area: Essbase, Block Storage Option, Aggregate Storage Option

Confidential, Houston, TX

Designer and Developer for Implementation

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

Focus Area: Financial Data Management, Essbase

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

Focus Area: Financial Data Management

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

Focus Area: Financial Data Management

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

Focus Area: Financial Data Management, Financial Management, Essbase

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

Focus Area: Financial Data Management, Financial Management, Planning

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

Focus Area: Planning

Confidential, Houston, TX

Contractor for Upgrade

Responsibilities:

• Performed with a team for 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

Focus Area: Smart View

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

Focus Area: Financial Data Management, Hyperion Planning

Confidential, 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

Focus Area: Financial Data Management, Planning

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

Focus Area: Planning

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

Focus Area: Essbase

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

Focus Area: Planning, Financial Reporting

Confidential, Fort Worth, TX

Developer for Implementation

Responsibilities:

• Designed and developed a global financial sales price, volume and exchange rate sensitivity across all product brands and SKUs.
• Played a major role in developing the SQL extraction.
• Along with Some Cognos Report Net Prototyping

Environment: Hyperion 7.x

Focus Area: Essbase

Confidential, Houston, TX

Architect and Developer for Enhancement

Responsibilities:

• Led the project to make the Financial Consolidation Cubes Sarbanes Oxley compliant, accessible via 2-phase authentication only and available for archiving purposes as well.
• Interacted with staff and several departments to design an approved and ongoing solution to their need

Environment: Hyperion 6.x

Focus Area: Essbase

Confidential, Coudersport, PA

Designer and Developer for Implementation

Responsibilities:

• Designed and developed a series of relational and multi-dimensional solutions to perform several sets of customer care analysis.
• Met with business users to design a customer care review and analysis over several Essbase cubes with relational drill back function.

Environment: Hyperion 6.x

Focus Area: Essbase