Oracle Epm Consultant

Role & responsibilities

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.

Preferred candidate profile

• 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