Enterprise Resource Planning Advisor (Oracle EPM FCCS Specialist)

We are currently seeking a Senior Oracle EPM Financial Consolidation and Close (FCCS) Specialist to join our team in New Jersey, USA. The Oracle EPM FCCS Specialist is responsible for supporting the enterprise financial consolidation, reporting, and close processes through expert-level functional and technical knowledge of Oracle Hyperion Financial Management (HFM) along with experience working across financial platforms such as Hyperion and Oracle Fusion Cloud Financials. This role partners with Finance, Accounting, and IT stakeholders to support, enhance, and optimize existing financial systems and integrations., Provide day-to-day functional and technical support for Oracle Financial Consolidation and Close (FCCS), including metadata management, consolidation rules, workflows, and process monitoring. Maintain and enhance FCCS metadata (DRM or EDMCS), scenarios, entities, accounts, and intercompany structures. Troubleshoot consolidation issues, data discrepancies, and financial reporting variances across source systems. Manage system operations related to the close process, including running consolidations, translations, calculations, and validations. Configure and maintain integrations between FCCS and other Oracle EPM Cloud applications (EDMCS, PCMCS, PBCS/EPBCS), ERP systems, data warehouses, and other enterprise platforms using Data Management (FDMEE) including data loads, mappings, validation rules, and error resolution. Collaborate with source system owners to ensure accurate data transfer from ERP systems (e.g., Oracle EBS/Cloud GL, SAP, or others). Maintain mapping tables, location setup, import formats, scripts, and load automation schedules. Collaborate with IT, data engineering, and application owners during integration projects, upgrades, and system migrations. Serve as a subject matter expert (SME) on FCCS functionality, Intercompany Matching and Eliminations rules, and Journal Management. Ensure reporting aligns with corporate accounting policies, financial structures, and audit requirements. Provide user training, guidance, and support for change request submission and hierarchy management. Document issues, enhancements, and process changes following ITIL standards (ServiceNow or similar). Support internal and external audit activities through documentation, controls, and system evidence. Recommend technology and process improvements that enhance financial operations efficiency. Work with cross functional teams to automate manual financial workflows using the appropriate tools. Mentor offshore EPM Administrators Identify opportunities to optimize metadata structures, automation, and data governance workflows.

5+ years of experience in finance. 5+ years of experience administering Oracle FCCS and/or Hyperion Financial Management with more than 2 FCCS implementations. 3-5 years of experience with FDMEE/FDM data integrations. Strong understanding of financial accounting, consolidations, intercompany eliminations, FX translation, and period-close processes.

• 5 years of experience with Oracle Cloud Narrative Reporting/Reports and/or Financial Reporting Studio Web +5 years of experience with Oracle Smart View (creating new reports, supporting ad hoc, break fix, etc.) 5+ years of Experience managing hierarchies, dimensions, and metadata governance processes. 5+ years of Hands-on experience configuring integrations, exports/imports, and connections to source/target systems. Strong knowledge of automation using Oracle EPMAutomate. Strong analytical, documentation, and problem-solving skills. Highly organized and detail-oriented. Strong communicator able to partner effectively with Finance, IT, and business stakeholders. Adaptable and proactive, with a continuous improvement mindset. Comfortable managing multiple priorities in a dynamic environment.

Nice to have: Experience with Oracle ERP Cloud, data warehouses, OCI, Oracle API Gateway. Basic understanding on Oracle ARCS, TRCS products knowledge. Experience with Oracle EPM EDMCS is preferred. Experience in the Banking sector is preferred. Ability to write Groovy rules, REST API calls, or SQL is preferred.