Our Client in the Ontario Public Sector is looking for a Oracle Hyperion Consultant on a 12 month contract. 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. (latest version)3+ years designing and implementing customized front-end solutions using Smart View/Excel/VBA front-ends with Essbase back-endDemonstrated experience working with ODI to move data into and out of Hyperion Planning.AdvantagesWork From HomeLong Term ContractPayment every week.Working in the Ontario Public SectorRQ02230 ResponsibilitiesA 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 deliverableProvide the quality assurance/quality control of specific deliverablesAnticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectationsDevelops processes and procedures for implementing deliverablesPrepares reports and presentations including options, recommendations, implementation plans, etc.Works with clients to define the scope of a project and to determine requirementsDefines software, hardware and network requirementsAnalyzes I&IT requirements giving independent and objective advice on the use of I&ITDesigns, tests, installs and monitors new systems and develops solutions and implementation of new systemsFamiliar with change-management principles and methodologyKnowledge and understanding of Information Management principles, concepts, policies and practicesSkillsExperience and Skill Set RequirementsEvaluation Criteria for Skills and Experience as follows:QualificationsCore 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-endExperience 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.SummaryThe Data Collections Unit within the Data Collection and Decision Support Solutions Branch (DDSB) of Community Services I&IT (CSC) located at 777 Bay St. in Toronto supports a number of complex customized applications built around Hyperion Planning but enhanced and extended via other development tools. A very specific and specialized set of skills is therefore required to support and enhance this suite of business-critical applications. The Education Financial System (EFIS) Modernization project was a multi-year complex change management and system integration project that went live in March 2015 and is currently being used by the Ministry of Education to support the funding of school boards and child care agencies. In March 2017 this solution platform was extended to include the Financial Information Return (FIR) application for the Ministry of Municipal Affairs. Both applications use Hyperion Planning but also employ a mix of other components build using Oracle Data Integrator, Oracle APEX, VBA, Excel Macros, SmartView, Oracle BI Publisher, Word Press and Unix shell scripting (Korn Shell, Bourne Shell etc). This unit also supports similar financial applications for the Ministry of Colleges and Universities (MCU) that perform similar functions on a similar technology platform. The two MCU applications are the Funding Model Administration (FMA) system and the College Information System (CFIS).Objective: CSC is seeking a senior resource with strong Hyperion Planning skills along with a mix of the other specialized skills noted above to assist in managing the enhancement-release process for all of these enterprise systems as well as to lead ongoing support and maintenance activities . All of these modernized applications have been built using Oracle Hyperion Planning but include many custom extensions such as the ones to manage system interfaces and the underlying Essbase metadata. It is a very complex software platform supporting a complicated and critical business process. All of the noted applications have been recently upgraded to 11.2 of EPM (Hyperion Planning). CSC requires assistance in providing support and maintenance of these systems along with the ability to quickly implement any required changes and to apply any required patches. The main focus of this resource will be EFIS and FIR with core skills in Hyperion Planning (version 11.2) and experience with custom applications built using SmartView/Excel/VBA but will be required to provide backup support to the business critical MCU applications (CFIS, FMA). The successful candidate for this engagement will be a resource capable of working on a mixed team of ministry staff and consultants as well as liaise with the business users directly. This resource will perform specialized software services to ensure that business needs are met in an optimal fashion by the EFIS and FIR applications and that system support activities are carried out in a timely and effective manner.Scope: The assignment entails working with IT and business managers, team leads, program analysts, financial officers, project team members, stakeholders and subject matter experts from the Ministry of Education, the Ministry of Municipal Affairs and from Community Services I&IT Cluster throughout the project. The successful candidate will provide technical leadership as well as hands-on support and be able to complete any and all planned enhancements, as well as providing ongoing system maintenance tasks for tasks such as patches, break fixes, and performance tuning.Randstad Canada is committed to building a diverse workforce reflective of the diversity of Canada. As a result, we promote employment equity and encourage candidates, especially those who identify as a woman, an Aboriginal person, a person with a disability or a member of a visible minority group, and any others who may contribute to the diversification of our workforce, to apply.Randstad Canada is also committed to developing an inclusive, barrier-free selection processes and work environments.If contacted in relation to a job opportunity, you should advise your Randstad Representative or your local Randstad branch in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner.Information received relating to accommodation measures will be addressed confidentially.For all feedback on equity and accommodation needs, please contact your local Randstad Canada Branch.