Description
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 ASAP as they cannot guarantee availability if any new issues arise. Failing to perform this upgrade means that the bank's 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 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 (eg 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 skill set
- Advanced knowledge of FDMEE
- Previous experience of several complex Oracle EPM 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 - eg 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.