FDMEE Integration Expert / IT Architects For YZ Upgrade Project - Bank

FDMEE Integration Expert / IT Architects For YZ Upgrade Project – Bank

FDMEE Integration Expert / IT Architects For YZ Upgrade Project required for a bank in Stockholm, Sweden.

Location: Stockholm

Statement of Work:

Support for the current version of Oracle EPM running on the YZ platform has expired. The platform needs to be upgraded to the latest version as soon as possible as they cannot guarantee availability if any new issues arise. Failing to perform this upgrade means that the banks reporting processes are at risk.
FDMEE implementation.
Due to the fact that Oracle is retiring FDM (Financial Data Quality Management) from EPM (Oracle Hyperion Enterprise Performance Management) in version 11.1.2.4 and it will no longer be compatible with HFM it means that to be able to succeed with the version upgrade we need to ensure that the new integration tool FDMEE is implemented and fully working by go-live.

Minimum requirements:
– Redesign of FINREP locations
– Minimize scripts by using multidimensional mappings
– Use of smartmerge/replace instead of delete locations
– Direct connection from Nordig to FINREP, GSIB3 and FINREP to GSIB3
– Minimize logic accounts by using separate data load rules in one location
– Healthcheck of Nordig and GMRR locations
– Minimize scripts by using multidimensional mappings
– Possible usage of Custom4 dimension for split of data source
– BAM tool data load status as currently
– Bulkload functionality for restatement periods
– Use of new functionalities for restatement
– Direct connections between two applications in cleaning process
– Use of smartmerge/replace
– Validate use of automated/semi-automated loads

Nice to have:
– Direct connections instead of flatfiles
– Mapping of factsconverter extract (FINREP)
– Other needs for HFM as source and “third party” as target

Scope of work:
– Analysing current solution,
– Application design – new setup to utilize the new features in the best possible way (e.g in terms of the performance, maintenance, etc.),
– Building integrations – Migrated FDMEE application on the banks development and test environments
– Integration testing – migrated applications tested in development and test environments
– Technical design FDMEE applications

Deliverables:
– Design document (including assessment of the replacement of flatfiles integration to direct connections)
– Scripting for interfaces not to be provided within multidimensional mapping
– Migration results and integration test reports
– Documentation of the interfaces

Requested role:
– FDMEE Integration expert

Required skillset
– Advanced knowledge of FDMEE
– Previous experience of several complex Oracle EPM 11.1.2.4 implementations
– Knowledge of current EPM setup (components, applications, integrations)
– Oracle EPM product prior training experience
– Advanced knowledge of EAL, FDMEE, HFM, Essbase

FDMEE training
– Closed Class FDMEE admin & development training – 10 trainees (2 days + 1 day).
– Training approach to be decided – e.g. division into 1 day of general training and 1 day of example-based migrations summary after implementation.

Replacement of the EAL:
– If possible, the project will remove EAL and replace it with integrations done using FDMEE instead.
– At first, project need to determine EAL replacement possibility as part of feasibility study.

Deliverables
– Feasibility study – analysis of using FDMEE for EAL integrations
– FDMEE implementation of EAL interfaces optional

English is the only language required for this role.

Whitehall Resources are leading ERP Recruitment specialist in the provision of SAP, Oracle & IT recruitment in the UK and Internationally.