Senior Oracle Technical Consultant

This role involves working as a senior-level technical consultant, specializing in Oracle EPM solutions.

The ideal candidate will have extensive experience in the implementation and configuration of Oracle Essbase, PCMCS/EPCM, and PBCS modules.

A strong background in data management, reporting, and integration with other systems is required.

• Technical Expertise
• Designing and configuring Oracle EPCM modules (in-depth knowledge of Oracle EPCM modules, including configuration, data management, and reporting)
• Configuring and customizing EPCM modules, including defining cost drivers, allocation rules, and reporting structures.
• Providing in-depth technical knowledge of Oracle EPCM, including its features, functionalities, and integration capabilities with other Oracle Cloud modules.
• Managing data mappings, validations, and transformations within EPCM and integrating it with other systems.
• Ensuring that the EPCM solution aligns with the organization's business processes and objectives, particularly in areas like cost allocation, profitability analysis, and profitability reporting.
• Expert in implementing Oracle PCM/EPCM starting from designing allocation rules, building both custom (MDX) rules and allocation rules and rulesets, and fine-tuning for performance.
• Working on direct integration to ERP GL and other EPM applications using Data Management.
• Good understanding of audit trail and balancing reports for allocations.
• Implemented projects with Oracle PCM and developed artifacts starting from Metadata creation/updates, setting up rules, (EPM/EPCM) designing web forms and data grids, creating reports and dashboards.
• Understanding of the financial statements, close cycle, and related best practices.
• Experience creating consolidated financial statements for customers.
• Responsible for understanding the project plans, timelines, regular status reports, risk, and issue logs, and working with the appropriate teams to ensure our teams deliver on the required activities and tasks.
• As a subject matter expert, he/she employs independent judgment in guiding moderately complex activities involved in the successful implementation of business solutions, ensuring project quality and timely delivery within budget and customer satisfaction.

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

• Overall 10+ years EPM/PCM experience in the areas of 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).
• Must be able 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.
• Should be open to adopting new technologies.
• Must have excellent experience in Oracle EPM applications. Good to have prior finance module experience.
• Good knowledge of ITIL concepts (Incident / Problem / Change / Availability Management).
• Should be flexible to work for long hours overlapping with EST, CST, and PST working hours.
• Should possess good interpersonal and communication skills.
• Should have a positive attitude.
• Should understand business objectives and organization structure.
• The candidate must have strong work ethics, trustworthiness, and self-confidence.
• The candidate should work accurately with good attention to detail by maintaining confidentiality and integrity.
• Ability to work under pressure to achieve multiple daily deadlines for client deliverables, with a mature approach and lead the team.

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