Job Description:
Responsibilities:

• A consultant specialized in Oracle Hyperion Planning, including the various software add-ons required to support it, including SmartView, ODI, Excel Macros, and VBA.
• The requirement is for a senior resource with 5-10 years of experience specialized in this particular software package with a focus on the on-premises version.
• Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, and work to improve the structure and efficiency of an organization s I&IT systems.
• The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures, and the enablement of major business processes through enhancements to IT.
• Provides subject matter expertise in their field and highly expert technical assistance.

General Skills:

• Acts as the technical advisor/expert on all aspects of a specific deliverable.
• Provides quality assurance/quality control of specific deliverables.
• Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations.
• Develops processes and procedures for implementing deliverables.
• Prepares reports and presentations including options, recommendations, implementation plans, etc.
• Works with clients to define the scope of a project and to determine requirements.
• Defines software, hardware, and network requirements.
• Analyzes I&IT requirements giving independent and objective advice on the use of I&IT.
• Designs, tests, installs, and monitors new systems and develops solutions and implementation of new systems.
• Familiar with change-management principles and methodology.
• Knowledge and understanding of Information Management principles, concepts, policies, and practices.

Experience and Skill Set Requirements:

• Evaluation Criteria for Skills and Experience as follows:

Core Technical Skills: 40%

• Demonstrated experience (at least 5 years) designing and creating integrated Oracle Hyperion Planning (OnPrem) solutions with version 11, including some demonstrated experience working with version 11.2.
• Demonstrated experience (at least 3 years) coding and sustaining applications using Excel macros and VBA.
• Demonstrated experience working with both business users and IT development teams to ensure business requirements are properly reflected in the system design, technical specifications, and final solution/prototype.
• Demonstrated experience working in small technical teams (2-3) of Hyperion Planning and data integration specialists.
• Demonstrated experience working with ODI to move data into and out of Hyperion Planning.
• Demonstrated experience working with automated scripts using custom-built Unix scripts to migrate and convert data and artifacts moving from one Planning application to another.

Application-Specific Skills: 40%

• Demonstrated experience building Planning applications for the purpose of managing the flow of transfer payments to public sector institutions.
• 3+ years designing and implementing customized front-end solutions using SmartView/Excel/VBA front-ends with Essbase back-end.
• Experience with Hyperion solutions (at least one required as per above) designed to integrate with OAM/OIM.
• Familiarity with the use of Oracle APEX as a tool for managing metadata in Hyperion Planning applications in conjunction with ODI batch routines.
• Demonstrated experience deploying and supporting Hyperion Planning applications deployed across the internet to large numbers of users (1000+).
• Familiarity with the funding models used in the education sector.

General Senior Consultant Skills 20%:

• Demonstrated ability to work effectively in small teams.
• Demonstrated ability to work and problem-solve independently.
• Demonstrated ability to work directly with clients in gathering requirements.
• Demonstrated ability to work with end-users to resolve issues.