EPBCS Analyst

Key Responsibilities

EPBCS Application Design & Development

• Design and implement EPBCS applications covering:
• Financial Planning (Revenue, Expense, OPEX, CAPEX)
• Workforce Planning
• Capital Asset Planning
• Profitability and cost allocation models
• Configure:
• Cubes, dimensions, hierarchies, and metadata
• Forms, dashboards, and task lists
• Business rules and validation logic

Business Rule Development & Automation

• Develop and maintain calculation logic using:
• Business Rules (Calculation Manager)
• Groovy scripts (for validation and automation)
• Implement:
• Allocations
• Driver-based planning
• Currency conversions
• Forecasting models
• Optimize calculation performance and data processing efficiency.

Data Integration & Management

• Manage data integrations between EPBCS and source systems (ERP, data warehouses).
• Work with:
• Data Management (FDMEE / EPM Data Integration)
• Smart Push / Data Maps
• REST APIs (where applicable)
• Perform data validation, reconciliation, and troubleshooting.

Reporting & Analysis

• Build and support financial reports and dashboards using:
• Smart View (Excel-based reporting)
• Management reports / Financial reporting tools
• Support ad hoc analysis for FP&A teams and business users.

Production Support & Enhancements

• Provide L2/L3 support for EPBCS applications.
• Troubleshoot application, data, and performance issues.
• Support monthly/quarterly budgeting and forecasting cycles.
• Handle enhancements, change requests, and system improvements.

Business Collaboration

• Work closely with finance, FP&A, accounting, and business stakeholders.
• Translate business requirements into EPBCS design and configurations.
• Facilitate requirement gathering, solution design, and UAT support.

Testing & Deployment

• Lead testing activities, including:
• Unit testing
• System integration testing
• UAT support
• Manage migrations across environments (DEV / TEST / PROD).
• Ensure proper documentation of releases and changes.

Governance & Documentation

• Maintain functional and technical design documents.
• Ensure compliance with financial governance and audit requirements.
• Support change management and release processes.

Qualifications

Qualifications

Required Skills & Qualifications

• Bachelor's degree in IT, computer science, finance, accounting, or a related field.
• 35 years of experience in Oracle EPM / Hyperion / EPBCS implementations.
• Strong hands-on experience in:
• EPBCS configuration and administration
• Financial planning and forecasting models
• Business rules and calculation logic
• Strong understanding of FP&A processes (budgeting, forecasting, variance analysis).
• Experience with:
• Data integration tools (FDMEE / Data Management)
• Smart View reporting
• Metadata and dimensional modeling

Preferred Skills

• Experience with **Oracle Enterprise Planning and Budgeting Cloud Service implementations**.
• Knowledge of Groovy scripting in EPM Cloud.
• Exposure to Essbase architecture and optimization.
• Experience with REST APIs and automation.
• Strong Excel and financial modeling skills.
• Experience in Agile project environments.

Soft Skills

• Strong analytical and problem-solving skills
• Excellent communication with finance and IT stakeholders
• Ability to handle financial close and planning cycles under deadlines
• Strong attention to detail and accuracy
• Stakeholder management and requirement translation skills