Oracle EPM Cloud Expert

• The Oracle EPM Cloud Expert will be responsible for designing, developing, supporting, and optimizing Oracle EPM Planning solutions.
• This role involves working with Oracle Planning (EPBCS), Essbase, automation processes, integrations, data reconciliation, and cross-functional collaboration to ensure reliable financial planning and reporting solutions.

Responsibilities:

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

Skills:

• Oracle EPM.
• Oracle Planning (EPBCS).
• Essbase ASO and BSO.
• EPM Automate scripting.
• Calculation scripts.
• Groovy scripting.
• Performance tuning and optimization.
• Windows batch scripting.
• Snowflake SQL.
• SAP Central Finance (CFIN).
• Agile SDLC methodologies.
• Change management processes.
• SOX compliance and audit support.

Should Have:

• Strong analytical and troubleshooting mindset.
• Excellent communication and stakeholder management skills.
• Ability to work independently in a staff augmentation environment.

Qualification And Education:

• Strong hands-on experience with Oracle Planning (EPBCS), Essbase ASO and BSO, and EPM Automate scripting.
• Experience executing and troubleshooting EPM batch processes.
• Strong analytical and problem-solving skills for resolving data discrepancies.
• Experience working with SAP CFIN integration and troubleshooting.
• Strong understanding of Agile SDLC methodologies.
• Experience with change management processes.
• Knowledge of SOX compliance, controls, and audit support.