Oracle Consultant

Oracle EPM Cloud Expert

Employment Typ e: Contract

Locatio n: Chicago, IL (Hybrid )

We are seeking an experienced Oracle EPM Cloud Expert with strong functional and technical expertise in Oracle Planning (EPBCS) . The ideal candidate will have deep knowledge of Essbase ASO and BSO architectures , advanced scripting capabilities, and hands-on experience with integrations, automation, troubleshooting, and data reconciliation across multiple enterprise systems.

Key Responsibilities

• Design, develop, and support Oracle EPM Planning (EPBCS) solutions.
• Develop and maintain business rules, calculation scripts, and Groovy scripts.
• Demonstrate expertise in Essbase ASO and BSO concepts, including performance tuning and optimization.
• Create, execute, and troubleshoot Windows batch scripts for EPM automation processes.
• Monitor, execute, and troubleshoot EPM batch jobs and integrations.
• Analyze and resolve data discrepancies across EPM, source systems, and downstream reporting platforms.
• Perform data reconciliation between Oracle EPM, Snowflake, SAP, and other integrated systems.
• Write and troubleshoot Snowflake SQL queries to support data validation and issue resolution.
• Collaborate with SAP teams to investigate and resolve integration and data flow issues, including SAP CFIN environments.
• Participate in Agile SDLC activities, including sprint planning, stand-ups, reviews, and retrospectives.
• Support production releases, deployments, and change management activities.
• Ensure compliance with SOX controls, audit requirements, and documentation standards.
• Partner with Finance, IT, and business stakeholders to improve system reliability and resolve production issues.

Required Qualifications:

Oracle EPM Expertise

• Strong hands-on experience with Oracle Planning (EPBCS)
• Deep expertise in Essbase ASO and BSO cubes
• Experience with EPM Automate scripting
• Advanced knowledge of calculation scripts and Groovy scripting
• Performance tuning and optimization experience

Technical Skills

• Proficiency in Windows batch scripting
• Experience executing and troubleshooting EPM batch processes
• Strong analytical and problem-solving skills
• Advanced Snowflake SQL skills
• Experience supporting SAP CFIN integrations and troubleshooting

Process & Governance

• Strong understanding of Agile SDLC methodologies
• Experience with change management processes
• Knowledge of SOX compliance, controls, and audit support

Soft Skills

• Excellent analytical and troubleshooting abilities
• Strong communication and stakeholder management skills
• Ability to work independently in a fast-paced environment

If you have a strong Oracle EPM background and enjoy solving complex planning, integration, and data challenges, we'd love to hear from you.