Description
Responsibilities:

A consultant specialized in Oracle Hyperion Planning including the various software add-ons required to support it including SmartView, ODI, Excel Macros, 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, work to improve 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
Provide the 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

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 the 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 artefacts 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 Smart View/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.

If you are available, please send your resume to sujata.gaimar@2iresourcing.ca OR refer someone interested