Financial Systems Manager - GDG Finance

JOB OVERVIEW:

This position is responsible for administering and supporting the company’s Oracle Hyperion business intelligence suite – Planning Budgeting and Cloud Service (PBCS/FDMEE) used in the consolidation and management reporting of Global product, customer and vendor group data . This role is responsible for managing the ongoing maintenance, upgrades, development, and implementation of application enhancements for the benefit of a worldwide PBCS user community. Coordinate and participate in the onboarding of additional businesses into the global reporting system and provide a level of application training to secure successful consolidation of Management reporting processes. Assist in the management of end-user relations, including training needs, system outages, changes in application features and application updates.

Troubleshoot installations, manage security administration, modify existing applications and offer explanation to business use of specific applications. Work with Oracle EPM COE team on system events including client rollout, hardware requirements and installations and to coordination of worldwide entity and account structures. Prepare the application for loading of Actual data and some Budget and Forecast data.  We will be migrating this application from PBCS to Oracle Planning Cloud and this position is expected to play a key role in that transition.

KEY RESPONSIBILITIES: 

• Manage administration activities including monthly change management requests implementation process to the planning target applications, ensuring timely updates and accurate changes to applications.
• Assist local finance teams with integration of their data into the PBCS application, including FDMEE mapping and project management
• Lead conversion of application from PBCS to Oracle Planning Cloud
• Manage the process of regression testing for the application and document test results
• Participate in historical data verification, build and documentation of monthly validations
• Assist in the management of end-user relations, including training needs, troubleshoot installations, administer security access and system outages for a world-wide user community
• Manage the security rights for system access
• Responsible for reviewing, performing, testing, documenting, implementing, and communicating month-end metadata changes
• Work in redesigning, testing, documenting and implementing PBCS Calc Scripts changes
• Create and maintain the application for loading of Actual, Budget, and Forecast data
• Document existing system processes and updates for approve process change
• Work with the user community, and 3rd party contract help, by providing system enhancement solution options, for design, test and implementation
• Propose system solutions for requested system enhancements, design, build, test and document according to specifications
• Administer PBCS Security
• FDMEE mapping of local data warehouse reports to PBCS chart of accounts, validate and reconcile results
• Report creation via Smartview and Oracle Financial Reports
• Load of financial and statistical data into PBCS via FDMEE or Excel template
• Research system errors through advanced problem solvingproblem-solving skills and methodical elimination of variables
• Work with end users identifying the cause and provide solutions for system issues they are experiencing
• Work on PBCS to maintain and update metadata, create webforms, reports and task lists in Workspace
• Perform reconciliation of historical data during data migration and after implementation of structure changes
• Conduct training of system to end-users
• Engage in regression testing and document results
• Build validation rules in the system
• May perform ongoing application maintenance, upgrade, development, testing and implementation of application enhancements
• Participate in special projects and performs other duties as required

SPECIFIC KNOWLEDGE & SKILLS: 

• Oracle/Hyperion application administration and installation of PBCS Client software or Oracle Planning Cloud

GENERAL SKILLS & COMPETENCIES: 

• Excellent understanding of industry practices
• Strong proficiency with tools, systems, and procedures
• Excellent planning/organizational skills and techniques
• Excellent independent decision making, analysis and problem solving skills
• Outstanding verbal and written communication skills
• Excellent presentation and public speaking skills
• Excellent interpersonal skills
• Excellent conflict resolution skills and ability to deliver difficult messages
• Ability to build partnerships at all levels withi