Oracle EPM Consultant + PCM

Aventra.AI; India; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Aventra.AI in India seeks an experienced EPM Consultant to design, develop, implement, and maintain PCM solutions. You will work with Finance to capture profitability, costing, and reporting requirements, building cost allocation models, rules, and calculations.

Strong SQL and data integration skills are essential to support ERP/GL data flows. Applicants should have 5+ years in EPM/PCM, with the ability to collaborate with onshore/offshore teams and contribute to deployment, testing, and

Qualifications

• 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 with data integration from ERP/source systems.
• Strong SQL skills for data extraction, validation, reconciliation, and troubleshooting.
• Ability to analyze complex business requirements and translate them into EPM solutions.

Responsibilities

• Design, develop, configure, and maintain 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.

Skills

PCM

EPM

SQL

Cost allocation

Finance concepts

Data integration

GL

Job description

We are looking for an experienced EPM Consultant with strong Profitability and Cost Management (PCM) experience to support the design, development, implementation, and maintenance of Enterprise Performance Management (EPM) solutions.

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.