Position title
Oracle EPM Developer
Description
The EPM Developer will act on design and development via Oracle's EPM Cloud Software Suite for Enterprise Planning and Budgeting Cloud Service (EPBCS) and Financial Consolidation and Close Service (FCCS). The candidate will also provide reporting solutions to the business partners using innovative tools and solutions. The candidate works closely with both our technical and business partners on requirements gathering to design, develop, deliver, and support system functionality.
Responsibilities
- Develop Complex Business Rules in both calculation manager and Groovy.
- Script using Python/Groovy/CDM APIs and utilize EPM Automate to automate data admin activities.
- Build integration artifacts in Cloud Data Management and FDMEE, such as locations, maps, custom/import scripts, using Python Scripts.
- Will serve as a SME in maintaining and enhancing budgeting, forecasting & long-term planning systems.
- Support multiple Planning and Consolidation applications in Oracle EPM Cloud.
- Responsible for providing innovative reporting solutions using Narrative, Management, Financial Reporting & Dashboards.
- Responsible for performance tuning and optimization of Planning and Consolidation applications.
- Working knowledge of Income Statement, Balance Sheet, and Cash flow concepts and KPI's
- Ability to work both individually and within a team environment.
- Proven experience in providing system support and direct contact with users to solve issues with business applications.
- Conduct testing, including system, integration, performance, and user acceptance testing.
- Prepare and maintain necessary documentation including design documents, test documentation, training materials, and administration/procedural guides.
Qualifications
- 2+ years' experience in Oracle EPM Hyperion Planning design, development and administration with 3+ years on EPM Cloud including EPBCS (Finance Modules, Freeform, Hybrid BSO, ASO), FCCS, Narrative and Management Reporting, Data Management, EPMAutomate & metadata management. Must have hands on EPM Cloud experience.
- Expert knowledge in Oracle EPM Cloud and On Premises Hyperion Architecture using Hybrid Application methodology and Financial Modules. Should be proficient in analyzing when to use Financial Modules vs FreeForm Applications.
- Must Have – Proficient in writing complex code in Calculation Manager Business Rules.
- Must Have – Proficient in writing complex code in Groovy Scripting.
- Must Have – Proficient in integrations within EPM cloud across cubes and also integration with other corporate systems like JDE, Anaplan, Snowflake etc.
- Expert knowledge of all components of EPBCS including metadata administration, outlines, dimensions, complex calculations, business rules, calculation scripts, creating snapshots, backups, data and artifact migrations, security setup and configuration, data forms, charts & graphs, menus, task lists, as part of application development and configuration.
- Expert in BSO, ASO & Hybrid cube design.
- Expert knowledge on Performance Optimization of Planning application which includes data load process / Business Rules / Cal script and reporting Methods.
- Expert knowledge of creating financial reports (pdf), charts, pivots, dashboards, books, batches, snapshot reports etc. using financial reporting.
- Expert in automation, SQL, batch scripting and EPMAutomate.
- Expert knowledge in automations of data Loads and integrations using FDMEE/data management.
- Expert knowledge on Metadata Upload Process through incremental files and creating automations to seamlessly load metadata.
- Expert in SQL development and maintenance of Stored Procedures (PL), Triggers and Queries.
- Ability to be proactive in providing alternatives based on best practices and application functionality.
- Financial process and functional knowledge required.
- Expert knowledge in analyzing business needs and developing solutions.
Hiring organization
Employment Type
Full-time
Job Location
Date posted
May 17, 2024