Oracle EPCM Developer

• Maintain multiple BSO/ASO applications in FreeForm and Planning. Includes multi-currency and Workforce modules.

• Support business units as solution needs arise. Effective time management and communications are key.

• Take leadership role related to system enhancements and implementation projects.

• Provide subject matter expertise managing third party vendors and internal staff.

• Responsible to work with business partners to gather, translate requirements and deliver business solutions as needed

• Test Oracle monthly patches in development applications to make sure they will work in production.

• Submit, track and work with Oracle to resolve open SRs which may arise / are needed to resolve solution issues.

• Configuration changes to application functionality, and assist with testing

• Maintain and write calc scripts in BSO/ASO languages with a strong understanding of Groovy.

• Maintain a Narrative Reporting application for reports, books, bursts, and scheduled jobs.

• Develop automated data interfaces and automations using EPM Automate and Data Exchange, FDMEE skills are a plus

• Knowledge of FDMEE/Data Exchange and REST APIs needed

Support month end close process, annual system roll forward, enterprise budget process and monthly forecast process support

• Bachelor’s degree (or equivalent experience) required

• Minimum of 5 years of experience managing solutions for Fortune 500 companies.

• Oracle Planning Cloud (Strategic Modeling, Financials, Projects, Capital, and Workforce modules)

• Oracle EPCM module development

• Strong Project leadership and system strategy direction

• Capable of effectively managing internal and third-party resources

• EPM Freeform ASO cube maintenance, development and administration

• Smart View, Narrative Reporting, and Management Reporting

• Knowledge to edit Groovy code

• EPM Instance security development and administration.

• Calculation Manager development and troubleshooting

• Provide technical support for access management related issues

Preferred Work Experience:

• Working experience with Oracle EPM FreeForm modules, Groovy code, Multi currency processing.

• Working experience with Data Relationship Management (DRM) and Freeform

• Support Annual SOX Audit review and evidence

• Test and monitor monthly system patches

• DRM knowledge a plus

• Ability to gather, analyze, and interpret data to solve problems and make decisions. Include critical thinking, research, data analysis, and creativity

• The ability to focus on and manage details, as well as to prioritize tasks and manage time.

• Understands core financial accounting concepts, metrics, processes and systems.

Skills:

• Self-motivated with strong work ethics.

• Knowledge of RPA tools like UiPath or Automation Anywhere, being UiPath the preferred one.

• Competent with programming languages such as C# and Python.

• Proficient in Power BI, Power Query, Excel, Access and VBA.

• Experience in process analysis, design, and implementation.

• Strong Project leadership and system strategy direction

• Capable of effectively managing internal and third-party resources

• Understanding of finance processes and systems.

• Ability to work collaboratively with cross-functional teams.

• Strong problem-solving and analytical skills.

• Excellent verbal and written communications skills.

• Experience managing projects. Prioritizing, scheduling, and completing multiple projects with competing resources.

• Oracle EPM, Hyperion ESSBASE, Financial Management, FDMEE, and Hyperion Financial Reports. EPBCS, EMDCS, NR and TRCS solutions for any enhancements

• SharePoint (Managing/Modifying)

• Proficient in Power BI, Power Query, Excel, Access and VBA.

• Knowledge of RPA tools (UiPath preferred)

• PeopleSoft (GL, Inventory, Fix Assets, Projects)

• Base understanding of programming languages such as C# and Python

• Lean Six Sigma