Senior Support Consultant, Oracle EPM FreeForm

This is a fully remote position, open to applicants in India.

📋 Description

• Deliver L2/L3 production assistance for Oracle EPM FreeForm applications.

• Address P1–P4 incidents within established SLAs.

• Diagnose intricate application, calculation, data, and performance challenges.

• Conduct thorough Root Cause Analysis (RCA) and execute permanent corrective measures.

• Aid in production deployments, migrations, and release tasks.

• Execute monthly Oracle EPM patch validation and subsequent post-patch testing.

• Offer user assistance and resolve functional or technical queries.

• Design and implement enhancements and change requests.

• Monitor and enhance cube, calculation, and application performance.

• Support data integration and synchronization efforts.

• Collaborate with application, infrastructure, business, and client teams to address critical challenges.

• Maintain technical documentation, support procedures, and knowledge bases.

• Facilitate knowledge transfer to support teams and stakeholders.

⛳️ Requirements

• Over 8 years of experience.

• Proficient hands-on production experience with both BSO and ASO.

• Expertise in advanced Groovy scripting.

• Extensive experience with Business Rules and Calculation Manager.

• Development and implementation of Runtime Prompts (RTPs).

• Performance tuning and optimization for BSO calculations.

• Experience with Data Maps and Smart Push.

• Skilled in EPM Automate and REST APIs.

• Troubleshooting complex calculation failures, data discrepancies, and business-rule mistakes.

• Proficient in BSO cube design, calculations, and data management.

• Advanced MDX development capabilities.

• Development and troubleshooting of ASO custom formulas.

• Expertise in ASO cube design, optimization, and aggregation strategies.

• Competent in ASO performance tuning and troubleshooting.

• Experience in data synchronization between BSO and ASO cubes.

• Ability to analyze and enhance ASO queries and reporting performance.

• Familiarity with supporting Oracle EPM Cloud / Planning / FreeForm production environments.

• Knowledge of Oracle EPM upgrades, patches, and migrations.

• Experience in enterprise production-support settings.

• Strong analytical and troubleshooting abilities.

• Capability to independently manage complex production challenges.

• Excellent communication and stakeholder management skills.

• Ability to thrive under pressure in a production-support context.

• Solid understanding of incident, problem, and change management processes.

• Skill in analyzing performance issues and recommending sustainable solutions.

• Candidates with solely functional EPM experience or limited production support exposure should not apply.

🏝️ Benefits

• Contract-to-Hire (CTH) option available.

• Remote work flexibility.

• Oracle EPM / Essbase certification is advantageous.