Howard Johnson, Mba Email & Phone Number

I have been implementing Oracle EPM / Hyperion systems for 25+ years now.I am working on making the transition into OneStream having worked on 3 projects now.I have the following certifications:EPBCS – Oracle Enterprise Planning and Budgeting Cloud Service 2017 Certified Implementation SpecialistOneStream Developer course completionOneStream Architecture: Designing an Application BadgeOneStream Essentials: Building Basic ReportsOneStream Essentials: Implementing OneStreamHyperion Certified Essbase ConsultantHyperion Certified TrainerAvailable for < 40 hour engagements and also full time project work.-hj

Denver, Colorado, Us

• Performing data loads and data validation from SAP to OneStream and OneStream (8 db’s) to OneStream 1db. This involved modifying transformation rules encompassing composite rules to derive a dimension assignment based on 2 dimensions.• Researching variances and identifying the breakdown usually due to GL Account mappings or missing / incompatible journal entries.• Cube view / reports development and dashboard creation which included creating dynamic calcs for reporting metrics and other hierarchy updates to meet reporting needs. • Migrated objects from development to UAT and Production environments.

Naples, Florida, Us

Developed cube views / reports per specifications. Included adding rollups and logic for reports to streamline reporting maintenance. Migrated objects from test to prod environments. Created report development guide for offshore team to use in the standard report creation process.

Worked through Huron to gather requirements and build solution to add additional dimensionality to existing budgeting allocation system. Involved requirements gathering, designing, build, test, go live.

-Reviewing current NSPB solution and proposing project plan to prioritize and implement fixes-Performance tuning of the system resulting in 80% improvement in end user retrieval time-Designing and building driver based budgeting and monthly forecasting into their current NSPB solution.-Building excel vba reporting solution to generate and email excel workbooks to users throughout the company.

Cedarburg , Wi, Us

Created financial reports using a combination of cube views and excel quickviews.Prototyped batching cube views into report books and datamangement jobs to automatically generate excel workbooks based on cube views.

Chicago, Il, Us

Some services I offer in the "fractional consultant" role include: -NSPB design and build -OneStream report writing -requirements gathering / business interviews -development -training -remote administration and development of Hyperion systems (hands on coding of calc scripts, allocations etc) -run design sessions to filter out the real business requirements that can be accommodated within the Hyperion framework and those that needs to be performed with another solution -production system review (perform system check to identify issues that will jeopardize your stability) -production administration My network includes those critical infrastructure guys who can bring back a dead Essbase server (just revived one 3 weeks ago).I have recently completed a 7 month engagement for a $2 billion retail company where I kept the system running the Hyperion Architect left the firm for other opportunities.#fractionalconsultant

Oak Brook, Illinois, Us

Created budgeting / forecasting application for international pasta business that performed sku level allocations via 6 different methods.Designed and created calculated metrics within Hyperion Planning to perform validation of sku level prices. This resulted in a savings of 2 man days a month during the forecasting / budgeting process.Rebuilt outbound interface from Hyperion Planning to Oracle for Hyperion Planning reducing cycle time by over 60%. This was needed to meet the SLA of the business.Managed and modified the designs for all Hyperion systems for 3.5 years including Hyperion Planning (4 apps 525 gig), a large consolidated Essbase ASO application, and 10 Essbase block storage applications.

Chicago, Illinois, Us

Took over the administration of all Hyperion systems. Implemented changes required to turn on budgeting and forecasting for a set of 4 Hyperion Planning applications for production materials planning and forecasting at the sku level. Design considerations for size were extremely important due to the total footprint reaching 525 gig for the applications.

Purchase, Ny, Us

Implemented changes to a production Hyperion Planning budgeting application for stretch forecasting at an annual level. This multicurrency application enables annual budgeting of the worldwide Mastercard products.Created a method for currency translation reconciliation between 3 databases where data is stored at monthly, quarterly, and annual levels.Implemented data integration changes between 4 Hyperion applicatinos due to the change in dimensions mainly business unit, products, accounts, and geography.

Dublin 2, Ie

The duties evolved through the 2 year project.I started out as the Hyperion Planning architect and my position evolved into developer. The end project I was involved in pertained to the design / creation of security and workflow for 30 Hospital Ministries resulting in excess of 10,000 users / groups being created.

Elmendorf Afb, Alaska, Us

Mckinney, Texas, Us

Us

Global, Us

Us

Purchase, Ny, Us

Project manager for the infrastructure of the Hyperion Planning project. This included all software install and configuration settings on 3 different Hyperion Planning environments.Identified and resolved multiple issues with the larger Hyperion Planning project design that would not have enabled the planning system as designed to go into production. (Watchdog over implementation team led by Hyperion)Designed and created all interfaces required for feeding and extracting from Hyperion Planning. Provided over all system tuning to reduce consolidation and retrieval times for all Hyperion Planning components, from Essbaes to the web servers.

Houston, Tx, Us

Responsible for the setup and design of budgeting system using Hyperion Planning 2.2, Analyzer 6.1, Reports 2.0, HAL, and Essbase 6.5.Redesigned existing forms. Performance of Hyperion Planning forms is highly dependent upon form layout. Forms performance times improved from 2 minutes to 10 seconds.Performed install and various upgrades of each of the planning components. Design of end user interface and model design based on user requirements.

Mckinney, Texas, Us

Chicago, Il, Us

Chicago, Il, Us

Implemented requirements analysis and design for reports using the SmartStream tool developed by Dunn and Bradstreet.

St Louis, Missouri, Us

Mba, Finance

Bsba, Logistics / Marketing

Bsba, Logistics / Marketing

Bsba, Marketing / Logistics