Oracle EPCM Developer

Responsibilities:

• 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

Skills:

● 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