Oracle/Hyperion EPM Functional Consultant - Mumbai

Sigma Allied Services; Mumbai; Hybrid; INR 1,400,000 - 1,800,000; Full time

Benefits offered by this job

Snowflake access

Job summary

Sigma Allied Services seeks an Associate II Oracle EPM Functional Consultant in Mumbai, hybrid role. The candidate will act as a functional SME for EPM-EPCM/PCMCS, design cost allocation models, and collaborate with Finance and Tech teams to improve P&L reporting.

Required 6+ years in Oracle EPM with profitability/cost management, strong SQL, and experience with Essbase, OAC, and Tableau. Hybrid work is offered.

Qualifications

• 6+ years in Oracle EPM module with Profitability and Cost Management.
• Experience with Oracle Fusion Cloud EPM-EPCM/PCMCS.
• Strong SQL and data analysis skills.
• Experience with cost allocation models using service catalogs.

Responsibilities

• Act as Functional SME for Oracle EPM-EPCM/PCMCS and cost allocation processes.
• Design and configure allocation models, rules, drivers, filters, metadata, and business logic.
• Troubleshoot allocation jobs, data discrepancies, and production issues using SQL & Snowflake.
• Translate Finance/business requirements into functional designs and solutions.
• Lead/support UAT, regression testing, release management, and environment migrations.
• Develop/support reporting using Essbase, OAC, and Tableau.
• Partner with Finance, Data, Technology, and Development teams on P&L reporting and Finance Transformation initiatives.

Skills

Oracle Fusion Cloud EPM-EPCM

Cost Allocation

SQL

Essbase

OAC/Tableau

ETL/ELT

Oracle EPM Cloud migration

Education

Bachelor's degree in Finance

MBA (Finance) / Information Systems

Tools

Snowflake

REST API

Smart View

OFSAA

Job description

Role & responsibilities

Hiring: Associate II Oracle EPM Functional Consultant | Cost Allocation
Location: Mumbai - Hybrid Mode
.
Shift: 1 PM 10 PM
Experience: 6+ years in Oracle EPM Module with Profitability and cost management
We are looking for an experienced Oracle Fusion Cloud EPM-EPCM /PCMCS Functional Consultant to join our Financial Reporting Systems team within the Office of the CFO & Controllership organization.

Key Responsibilities

• Act as a Functional SME for Oracle EPM-EPCM/PCMCS and cost allocation processes
• Design and configure allocation models, rules, drivers, filters, metadata, and business logic
• Troubleshoot allocation jobs, data discrepancies, and production issues using SQL & Snowflake
• Translate Finance/business requirements into functional designs and solutions
• Lead/support UAT, regression testing, release management, and environment migrations
• Develop/support reporting using Essbase, OAC, and Tableau
• Partner with Finance, Data, Technology, and Development teams on P&L reporting and Finance Transformation initiatives

Must-Have Skills

• Oracle Fusion Cloud EPM-EPCM / Enterprise Profitability and Cost Management/HPCM/PCMCS
• Cost Allocation & Service Catalog-based allocation models
• Strong SQL and data analysis skills
• Essbase
• OAC / Tableau
• ETL/ELT, data integration, mapping & transformation
• Oracle EPM Cloud migration across Dev/Test/Production

Good to Have

• OFSAA
• AI/ML exposure
• Snowflake / Cloud Data Warehouse experience
• EPM Automate / REST API / Smart View
• Preferred: Bachelors degree in Finance, MBA (Finance), B.E., or Information Systems
• Experience in Banking, Insurance, or Financial Services is preferred.

Note: Don't share end user profile we need consultant experience in oracle EPM