Now you can Instantly Chat with Howard!
About Me
20 Years of Hyperion/ Oracle expereince with Infrastructure, Application Development, Performance Tuning and Disaster Recovery. I am Technical and functional with executive level and Senior Developers.. Proficient in multiple business intelligence...
Show MoreSkills
Portfolio Projects
Description
Provided architecture for upgrade of Hyperion upgrade to be move to a supported release before support
ended on current production running the network of hospitals.
▪ Stood up new VM servers, configured operating systems and applied patches for windows 2012 R2 on a
64bit machines.
▪ Installed configured and deployed Hyperion 11.1.2.4 on new environment.
▪ Migrate Hyperion Essbase, ODI, Enterprise Reports from old servers to new.
▪ Manage weekly migrations to keep Production and Non-Production environments in sync.
▪ Developed operational practices to sustain application after Migration.
▪ Work with other departments to implement continued migrations for other applications with Oracle.
▪ Document upgrade and migration process for client in PDF book as well as recorded video.
▪ Setup ODI processes to manage data from various data warehouses to be feed into the upgraded
general ledger and Essbase outline.
Description
Maintain legacy Hyperion Environments on premise and Cloud.
▪ Manage Servers and setup automated backups along with recovery routine.
▪ Manage weekly migrations to keep Production and Non-Production environments in sync.
▪ Manage user accounts and provisioning.
▪ Work with other departments to implement Cloud migrations for other city applications with Oracle.
▪ Update Financial reports and Planning Webforms for various budget cycles.
▪ Setup metadata updates for HFM and Essbase based on extracts from Peoplesoft for actuals.
▪ Manage all patching schedules and migrations for information management team.
▪ Provide training annually for Budget Team on entire application suite of Hyperion
Description
Performed the installation of new Hyperion Version 11.1.1.3 on a 64 bit platform in a virtual environment
▪ Provide migration of old production data, scripts and mapping from old environment and migrated to
new.
▪ As the Technical Delivery Manager I was responsible for the entire BI Architecture scaling it from
development to production.
▪ Translated business and technical requirements into well-engineered, tested, and deployed business
application systems. This included analysis, design, development, testing, installation, and maintenance
Page 5 of 9
of information systems, and included new code construction, modifications to existing modules, web
development and package implementation.
▪ Managed the entire Oracle EPM suite which included Essbase, Planning, HFM (Hyperion Financial
Management), FDM (Financial Data Management), MDM (Master Data Management), DRM (Data
Relational Management), IR (Interactive Reporting), FR (Financial Reporting), WA (Web Analysis),
Workspace, ODI (Oracle Data Integrator) implementing full life cycle management.
▪ Managed a team of employees and consultants to support the deployment to regional offices and also in
house development. Working with 9 different environments with a windows and Linux servers and
distributed architecture.
▪ Lead the design, build and test stages of a project from an infrastructure perspective.
▪ Maintained and enhanced established software to ensure the most efficient operation of the
departments.
▪ Serve as liaison between the project team and vendor resources.
▪ Design, deployed and maintain Tidal Scheduling Tool for automation purposes for moving data in and
out of the environment and application to internal and external organizations.
▪ Responsible for the implementation and support of applications and systems, analyzing clinical user’s
information system requirements and departmental information flows.
▪ Develop and provided general and special purpose user training in conjunction with the IT Education
team.
▪ Operated the change control principles and functioned in a cross site environment when making system
changes and modifications.
▪ Design and develop multi-database Hyperion Essbase applications
▪ Create, test and documented complex calculation scripts
▪ Create, test and documented Business Rules, Macros, Sequences
▪ Create, test and documented complex member formulas
▪ Design and create Hyperion Classic Planning applications
▪ Create, test and documented Hyperion Planning web forms
▪ Create, test and documented Essbase data load rules
▪ Experienced in designing application, dimensional and form security in a multi-application deployment
▪ Redesigned the ODI interfaces to receive and send data from Peoplesoft to Hyperion
Description
Migrate Hyperion Essbase, ODI, Enterprise Reports from On Prem to Oracle Cloud.
▪ Manage weekly migrations to keep Production and Non-Production environments in sync.
▪ Developed operational practices to sustain OACS after Migration.
▪ Work with other departments to implement Cloud migrations for other applications with Oracle.
▪ Setup Gateway for secure network with Certs between Production, Test, QA and Dev and Cloud along
with on prem environments.
▪ Document upgrade and migration process for client in PDF book as well as recorded video.
▪ OBIEE setup network interfaces between On Prem and Cloud
▪ Migrate HFM 11.1.2.4 on Premise to HFM Cloud. Rewrite some calc scripts and rule files to allow
for integration with ODI and additional roll ups for other cloud applications.