Oracle Functional Consultant

HTC Global Services · India

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