Oracle EPM Cloud Expert

Job Title: Oracle EPM Cloud Expert - Planning (Free Form ASO)
Job Type: (Accounting/Finance, Admin/Clerical, Business Professional, Creative, Healthcare, Light Industrial, Scientific, Technical) Technofunctional EPM & Finance
Number of openings requested: 1
Title Type: (Plant, Non-Plant, Professional) Professional
Work Location: (Remote, City & State, or both for Hybrid) Hybrid (Client & Remote)
Requisition Owner Name: Sunil Kumar
Project Manager Name on Capital Project (NA if this is not a Capital Project):
Hiring Manager's Email Address:
Cost Center #: C0000000
WBS Element: (If not applicable, list Cost Center) CUS.IS26050.C91141.6401
WBS Element/Project Funding Total $$ (If not applicable, list N/A) ***
Hours Per Day / Hours Per Week: (Project Based Work) 40 Hrs/Per Week Minimum
Company Code: U025
Product Category / GL Account: 52000***0
Finance/ZBB Approver/Controllership (who is providing authorization for contingent request): We will be using the already approved funding
Finance/ZBB/Controllership Approval Method (email, TEAMS ping, other): Budget is approved
Finance/ZBB/Controllership Approval Date: T5PRJ0018770 (Will charge to approved project)
Pre-identified Supplier: All Suppliers
Job Description: (please attach) Provided
Scheduled Days of the Week & Hours: M-F 8:00am-5:00pm CST (onsite Tues-Thurs)
Pay Rate: ***
Bill Rate: ***
Start Date: ASAP
End Date: 3 months, potential to extend
Looking to Convert to FTE (full time employment):
(yes or no) No
Interview Process: (individual or panel, one or multiple)? Multiple
Interview Type: (video, call, in-person) 1st Video Conference / 2nd In-Person (onsite)
Must haves:
Strong hands-on experience with Oracle EPM Planning (EPBCS)
Deep expertise in Essbase (ASO + BSO cubes)
Advanced SQL (Snowflake preferred)
Experience with calculation scripts and Groovy scripting
Proven ability to troubleshoot data issues and reconcile across systems
Experience with EPM automation (EPM Automate, batch scripting)
Q&A:
Hands-On vs. Functional Ownership
How hands-on do you expect this resource to be in day-to-day development (e.g., Groovy scripting, calc scripts, debugging) versus providing functional or strategic support?
(SK- This role involves hands-on development work, including loading and reloading data in Oracle applications. It also includes validating data accuracy and supporting the business in performing reconciliation.)
Integration & Data Complexity
What are the most critical integrations this role will support (e.g., Snowflake, SAP CFIN), and how complex are the current data reconciliation challenges?
(SK - Integrations are from Snowflake; reconciliations are complex but mostly needs Advanced SQL knowledge to help with troubleshooting and reconciliation)
Top Priorities in First 30 Days
What are the immediate priorities this person will be expected to own (e.g., stabilizing batch jobs, resolving data discrepancies, supporting a planning cycle)?
(SK - Executing batch jobs, master data updates, calculations updates whenever requirement and resolving data discrepancies)
Role Summary
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 ASO and BSO architectures, strong calculation and Groovy scripting skills, and hands-on experience with batch processing, troubleshooting, and data reconciliation across multiple source systems.
Key Responsibilities
Design, develop, and support Oracle EPM Planning (EPBCS).
Demonstrate deep expertise in Essbase ASO and BSO concepts, including performance optimization.
Develop and maintain business rules, calculations, 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/downstream systems.
Write and troubleshoot Snowflake SQL queries to support data validation and issue resolution.
Collaborate with SAP teams and leverage knowledge of SAP Central Finance (CFIN) 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.
Required Skills & Qualifications
Oracle EPM
Strong hands-on experience with:
Oracle Planning (EPBCS)
Essbase ASO & BSO
EPM Automate Scripting
dvanced expertise in:
Calculation scripts
Groovy scripting
Performance tuning and optimization
Technical & Integration Skills
Proficiency in Windows batch scripting
Experience executing and troubleshooting EPM batch processes
Strong analytical and problem-solving skills for data discrepancies
Solid knowledge of Snowflake SQL
Experience working with SAP CFIN (integration and troubleshooting)
Process & Governance
Strong understanding of SDLC (Agile) methodologies
Experience with Change Management processes
Knowledge of SOX compliance, controls, and audit support
Soft Skills
Strong analytical and troubleshooting mindset
Excellent communication and stakeholder management skills
Ability to work independently in a staff augmentation model


EEO:


"Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."