Oracle Epm Consultant

Key Responsibilities

Design, develop, configure, and maintain Profitability and Cost Management (PCM) applications.

Work with Finance and business stakeholders to understand profitability, costing, allocation, and reporting requirements.

Develop and maintain cost allocation models, profitability models, dimensions, hierarchies, rules, and calculations.

Configure PCM applications to support complex cost and revenue allocation methodologies.

Develop allocation drivers and rules to distribute costs and revenues across products, customers, services, business units, and other dimensions.

Support profitability analysis and identify key cost and revenue drivers.

Develop and maintain EPM applications, business rules, calculations, forms, reports, and dashboards.

Perform data integration between PCM/EPM and source systems such as ERP, General Ledger, and data warehouses.

Perform data validation, reconciliation, and troubleshooting across EPM applications.

Analyze and resolve technical and functional issues related to PCM models and calculations.

Work with Finance teams to improve financial planning, budgeting, forecasting, and profitability reporting processes.

Participate in application enhancements, testing, deployment, and production support.

Prepare technical and functional documentation for PCM models, business rules, integrations, and processes.

Collaborate with offshore/onshore teams and business stakeholders throughout the implementation lifecycle.

Provide knowledge transfer and mentoring to junior EPM consultants.

Required Skills

Must have minimum 5+ years of overall experience in EPM/financial systems.

Strong hands-on experience with Profitability and Cost Management (PCM).

Strong understanding of cost allocation and profitability management concepts.

Experience designing allocation methodologies and allocation drivers.

Experience with EPM dimensions, hierarchies, metadata, business rules, calculations, and data models.

Strong understanding of Finance and accounting concepts.

Experience working with General Ledger (GL), cost centers, profit centers, products, customers, and business units.

Experience with data integration and data loading from ERP/source systems.

Strong SQL skills for data extraction, validation, reconciliation, and troubleshooting.

Experience in application testing, defect resolution, and production support.

Ability to analyze complex business requirements and translate them into technical EPM solutions