Oracle Functional Consultant

Oracle Fusion Cloud EPM-EPCM Functional Consultant – Cost Allocation
Experience: 8–10+ Years
Location: Mumbai
Job Summary
The Financial Reporting Systems Team is a part of the Office of the CFO and Controllership organizations. We are looking for an experienced associate for Oracle Fusion Cloud EPM-EPCM with strong expertise in cost allocation and Service Catalog-based allocation models with 8–10+ years of overall experience. The role owns functional design, configuration, production support, and continuous improvement of EPCM allocation processes, working closely with Finance, Business, Data, Technology, and Development teams.
Key Responsibilities
Act as Functional SME for Oracle Fusion Cloud EPM-EPCM and Service Catalog-based cost allocation processes.
Design, configure, and maintain allocation models, rules, drivers, filters, and calculation logic within EPM-EPCM.
Monitor production allocation processes; investigate job failures, data discrepancies, and perform root-cause analysis using SQL and Snowflake.
Translate Finance and business requirements into functional designs and configuration solutions.
Lead/support functional/technical testing, UAT, regression testing, and release management across Dev, Test, and Production environments.
Create reports using Essbase, OAC, and Tableau; support P&L Management reporting aligned with Office of the CFO requirements.
Assists with project management, including assessing reporting needs, determining data and reporting requirements, writing policies & procedures, and implementing systems and processes.
Experienced in data analysis, variance analysis, and competitive data analysis
Act as liaison to identify business critical information and knowledge, and its usage and availability
Partner with other Office of the CFO teams to develop P&L reporting aligned with evolving business requirements.
Required Skills & Experience
Hands-on experience in implementation and configuring EPM-EPCM allocation rules, drivers, filters, metadata, and business logic.
Strong SQL skills for data validation, reconciliation, and troubleshooting; experience with Snowflake or similar cloud data warehouse platforms.
Understanding of ETL/ELT, data integration, data mapping, and transformation concepts.
Experience in requirements gathering, functional design, testing, UAT, and release management.
Strong analytical, problem-solving, communication, and stakeholder management skills.
Familiarity with Oracle EPM Cloud environment migration across Dev, Test, and Production instances.
• Normally work independently, receiving little instruction on day-to-day work, receiving general guidance and review on new assignments.
Qualifications
• 8-10 years of experience in Oracle Fusion Cloud EPM-EPCM
• Bachelor’s degree in finance / MBA (Fin) / B.E or Information Systems preferred
• Experience in Banking, Insurance, or Financial Services
• Excellent communication and writing skills
• Advanced proficiency in MS Excel
• Proficient in Microsoft Office suite of products
• Excellent written and verbal communication skills, proven ability to work as an effective team player and ability to collaborate
• Demonstrated strength in analytical and problem-solving skills
• Ability to manage multiple competing priorities and achieve targeted outcomes
• A commitment to a culture of excellence and client service
• A sense of urgency, results orientation and thoughtful execution skills
• Highly organized, detail oriented, self-motivated, and positive work ethic
• Ability to take direction and work independently
Shift Timing: 1PM to 10 PM
Location: Mumbai
DESIRED/PREFERRED
Must Have: EPM-EPCM, SQL · Essbase · OAC / Tableau · Data Analysis
Good to Have: OFSAA · AI/ML Skills
Keywords to Search
Oracle EPM | Oracle Cloud EPM | EPM-EPCM | Enterprise Profitability and Cost Management | EPBCS | Cost Allocation | Service Catalog | Allocation Rules | Allocation Drivers | Cost Drivers | Dimensions | Metadata | Hierarchies | SQL | Snowflake | Data Warehouse | ETL | ELT | Data Integration | EPM Automate | REST API | Smart View | Finance Transformation | Profitability Management | Functional Consultant | Functional SME

Work arrangement
No