Oracle EPCM Consultant

We are seeking a seasoned Oracle EPCM technical expert with in-depth knowledge of Essbase, PCMCS/EPCM and PBCS implementation experience to fill this hands-on role.

Responsibilities:

1. Design and configure Oracle EPCM modules including configuration, data management, and reporting.
2. Configure and customize EPCM modules including defining cost drivers, allocation rules, and reporting structures.
3. Provide in-depth technical knowledge of Oracle EPCM including its features, functionalities, and integration capabilities with other Oracle Cloud modules.
4. Manage data mappings, validations, and transformations within EPCM and integrate it with other systems.
5. Evaluate and align EPCM solution with organization's business processes and objectives particularly in areas like cost allocation, profitability analysis, and profitability reporting.
6. Expert in implementing Oracle PCM/EPCM from designing allocation rules, building custom (MDX) rules and allocation rules and rulesets, and fine-tuning for performance.
7. Work on direct integration to ERP GL and other EPM applications using Data Management.
8. Understand audit trail and balancing reports for allocations.
9. Developed projects with Oracle PCM and created artifacts starting from Metadata creation/updates, setting up rules, (EPM/EPCM) designing web forms and data grids, creating reports and dashboards.
10. Understand financial statements, close cycle, and related best practices.
11. Experienced in creating consolidated financial statements for customers.
12. Responsible for understanding project plans, timelines, regular status reports, risk, and issue logs, and working with appropriate teams to ensure delivery of required activities and tasks.

Qualifications:

• MBA Finance or Bachelor's Degree in computer or IT related subject. Finance background also applicable.

Required Skills:

• Overall 10+ years EPM/PCM experience in administration, design, analysis, development, and Support of applications in various domains and products related to EPM and PCM.
• Experience in PCM with strong Application Development process experience on Hyperion EPM Product Suite.
• Strong experience in PBCS Business rules - Design, Development and performance tuning.
• Experience in metadata integration with EDMCS and custom files for EPM modules - PBCS & PCMCS.
• Experience in designing and coding batch processes using epmautomate tool for EPM modules - PBCS & PCMCS.
• Experience in Requirement Gathering & Solution Design - PCM.
• Hands on experience in configuration of rules and rulesets in PCM.
• Hands on experience of administrative activities related to PCM.
• Data management skills to create data load rules, mappings and loading of data.
• Desired functional knowledge Understanding of Chart of Accounts and allocations process.
• Ability to work independently to identify, troubleshoot and resolve issues prior to their occurrence.
• Strong skills across MS word, PowerPoint, Excel, MS Office and other collaboration and unified communication tools.
• Open to adopt new technologies.
• Excellent experience in Oracle EPM applications. Good to have prior Finance modules experience.
• Good knowledge of ITIL concepts Incident / Problem / Change / Availability Management.
• Flexible to work for long hours overlapping with EST, CST and PST working hours.
• Good interpersonal and communication skills.
• Positive attitude.
• Understanding of business objectives and organization structure.
• Strong work ethics, trustworthiness, and self-confidence.
• Able to maintain confidentiality and integrity while working accurately with good attention to detail.
• Ability to work under pressure to achieve multiple daily deadlines for client deliverables with mature approach.

Preferred Skills:

• FCCS, EPRCS, ARCS.
• SQL, PL/SQL, Autosys Scheduling, Unix/Windows Shell Scripting.