Oracle EPM Reporting Analyst

Interview Type: In Person USC hybrid Short Description: Oracle EPM Technical Narrative Report Specialist • • Hybrid--local DMV candidates only • • Complete Description: 1\.           Design and develop business rules, including Groovy rules for financials, workforce, projects, and custom cubes. 2\.           Configuring and developing with EPM Cloud Planning workforce module and associated business rules, forms, and integrations with PeopleSoft. 3\.           Design and develop reports, packages, doclets, using narrative reporting for annual financial reports and Budget book reports. 4\.           Configuring Financial close and consolidation modules in integration with Oracle ERP General ledger for developing annual financial reports. 5\.           Design, develop, and deploy EPM Planning, and Narrative reporting RestAPI using Groovy Scripting and business rules. 6\.           Expertise in Python scripts utilizing the EPM cloud RESTAPI and EPM Automate to extract, transform, and load ERP data into EPM planning using. Experience working with the Oracle ERP OIC as needed. 7\.           Design, develop, and support data integrations using data management, data exchange, and loading data for EPM cloud. 8\.           EPM planning integrations for ERP General ledger, budgetary control, and projects and awards modules, as well as experience integrating with PeopleSoft. 9\.           Analyze, debug, and interact with Oracle Support to resolve Oracle Planning environment and development issues. 10\.         Provide ongoing support throughout the SDLC process, including the development and maintenance of Oracle planning artifacts. 11\.         Assess the impact of potential changes and implement solutions to mitigate negative outcomes Education: Bachelor’s Degree in MIS, Computer Science, Math, Engineering or comparable major or 4 Years of experience. Qualifications: 1\.          Minimum (12) years of technical experience with Oracle Budget Applications such as Hyperion, EPM Cloud, and EPBCS 2\.          Professional experience with 2+ large Hyperion, EPM Cloud, and Oracle Planning implementations in the Public Sector. 3\.          Demonstrates intimate abilities and/or a proven record of developing management reporting, Dashboards, SmartView for Narrative reporting, Annual Report production and/or Budget Book production. 4\.          Minimum (5) years’ experience developing planning forms, data management integrations, business rules, reports with EPM cloud and/or EPBCS planning, narrative reporting, and Financial close and consolidation applications. 5\.          Minimum (3) years’ experience implementing Oracle EPM Groovy business rules 6\.          Minimum (3) years of technical experience with Oracle EPM, Hyperion, EPM Automate and Python to load/extract data and associated scripts. 7\.          Ability to interact with stakeholders, manage expectations, provide regular updates and conduct requirement definition sessions Skill Required / Desired Amount of Experience Technical experience with Oracle Budget Applications such as Hyperion, EPM Cloud, and EPBCS Required 12 Years Developing planning forms, data management integrations, business rules, reports with EPM cloud and/or EPBCS planning, narrative reporting Required 5 Years Technical experience with Oracle EPM, Hyperion, EPM Automate and Python to load/extract data and associated scripts Required 3 Years Experience implementing Oracle EPM Groovy business rules Required 3 Years Professional experience with 2+ large Hyperion, EPM Cloud, and Oracle Planning implementations in the Public Sector. Required Developing management reporting, Dashboards, SmartView for Narrative reporting, Annual Report production and/or Budget Book production Required Experience interacting with stakeholders, manage expectations, provide regular updates and conduct requirement definition sessions Required