Oracle Epm Consultant

VService IT Solutions; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

VService IT Solutions is seeking an experienced EPM/PCM consultant to design, implement, and optimize profitability and cost management solutions. The role involves configuring PCM applications, developing allocation drivers, and integrating data from ERP/GL systems to support budgeting and forecasting.

The ideal candidate has 5+ years in EPM, strong SQL skills, and deep knowledge of cost allocations, dimensions, and business rules.

Qualifications

• Minimum 5+ years of experience with EPM/financial systems.
• 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.

Responsibilities

• Design, develop, configure, and maintain PCM applications.
• Collaborate with Finance and 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

EPM/financial systems

PCM

Cost allocation concepts

Allocation methodologies

EPM dimensions/hierarchies

Finance/accounting concepts

GL, cost centers, profit centers

Data integration from ERP

SQL

Testing/production support

Business requirements to EPM solutions

Job description

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