RQ09957 - Specialized IT Consultant - Senior

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
  

Requirements

Experience and Skill Set Requirements:

Must Haves:

• Demonstrated experience building and designing on\-premises Hyperion Planning applications (version 11) including all core components: Forms, Reports, Business Rules, Task Lists, meta data loading, Essbase design and optimization with at least 7 years of solid design and development experience.
  


• Experience developing and maintaining custom\-developed front\-end applications using Excel/VBA and SmartView.
  


• Senior experience Demonstrated experience as a Hyperion Planning Developer \- more of a lead and solution designer
  

Nice to have:

• Oracle APEX
  

Skill Set Requirements:

Core Technical Skills:

• 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:

• 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:

• 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.