RQ08041 - Specialized IT Consultant - Senior

Description Note: This contract will require the consultant to work from the office location 3 days per week with the remaining 2 days being worked remotely. 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 organizations 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 SkillsExperience 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 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. Looking for development experience doing Solution Design. MUST 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: Oracle APEX