Oracle EPM Consultant (EPBCS/PBCS )

Clover Infotech; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Clover Infotech seeks an Oracle EPM Specialist in the United States to drive end-to-end Oracle EPM Cloud implementations, architect complex cube models (BSO/ASO), and customize FCCS/PBCS. You will automate data pipelines with EPM Automate and coordinate with corporate finance for UAT and training.

The role emphasizes hands-on design, data integration, and reporting across ERP sources, delivering scalable EPM solutions for financial planning and consolidation.

Qualifications

• Experience with at least 2–3 full lifecycle Oracle EPM Cloud implementations.
• Strong expertise in BSO/ASO with cube design and data modeling.
• Experience in FCCS and PBCS customization.
• Experience building data pipelines using EPM Automate.
• Ability to lead UAT and provide user training.

Responsibilities

• End-to-End Implementations: Led at least 2-3 full-lifecycle Oracle EPM Cloud implementations, driving projects from requirement gathering through deployment and post-go-live support.
• Solution Architecture: Designed complex BSO (Block Storage) and ASO (Aggregate Storage) Essbase cubes, data models, and entity dimensions to optimize system performance.
• Financial Customization: Authored custom Business Rules, complex allocation scripts, currency translations, and intercompany elimination rules in FCCS and PBCS.
• Process Automation: Built automated data pipelines using EPM Automate to seamlessly ingest data from ERP source systems (e.g., Oracle EBS, Oracle Fusion).
• Stakeholder Management: Acted as the primary technical point of contact for corporate finance teams, leading User Acceptance Testing (UAT) and providing user training.

Skills

Oracle EPM Cloud Modules

Scripting & Automation

Data Integration & Reporting

Stakeholder Management

Tools

Hyperion Suite

ODI

FDMEE

EPM Automate

Groovy scripting

REST APIs

Smart View

Job description

Job Descriptions:

Core Technical Skill Set

• Oracle EPM Cloud Modules: Expert proficiency in EPBCS/PBCS (Planning) with secondary skillset as FCCS (Consolidation & Close) and EPRCS.
• On-Premise Hyperion Suite: Good to have experience with integrating Oracle GL using ODI and FDMEE.
• Scripting & Automation: Advanced knowledge of Calc Scripts, Business Rules, Member Formulas, and EPM Automate for batch scripting and job scheduling. Good to have exposure to groovy scripting and REST APIs
• Data Integration & Reporting: Deep expertise in Data Management, Data Maps, Smart View, Financial Reporting (FR Web Studio), and Management Reporting

Key Responsibilities & Experience (67 Years Level)

• End-to-End Implementations: Led at least 2-3 full-lifecycle Oracle EPM Cloud implementations, driving projects from requirement gathering through deployment and post-go-live support.
• Solution Architecture: Designed complex BSO (Block Storage) and ASO (Aggregate Storage) Essbase cubes, data models, and entity dimensions to optimize system performance.
• Financial Customization: Authored custom Business Rules, complex allocation scripts, currency translations, and intercompany elimination rules in FCCS and PBCS.
• Process Automation: Built automated data pipelines using EPM Automate to seamlessly ingest data from ERP source systems (e.g., Oracle EBS, Oracle Fusion).
• Stakeholder Management: Acted as the primary technical point of contact for corporate finance teams, leading User Acceptance Testing (UAT) and providing user training.