Executive Assistant & Board Administrator

POSITION PURPOSE

This position will serve as a Cash management technical expert in the Accountable Business Transformation (ABT) Program with the complex operating system Oracle EBS Cash management module that will be used throughout the County in multiple departments. The ABT Program is an Enterprise Resource Planning (ERP) program responsible for implementing multiple County-wide IT systems such as Oracle Financials Enterprise Business Suite (EBS), People Soft Human Capital Management (HCM) and the Cognos Operating and Capital Budgeting System across King County.

This position will consult with County agencies to refine and translate Cash management functional requirements into technical specifications for the Oracle EBS Cash management module. This position will conduct complex analysis and coding changes, develop customized reports and queries, troubleshoot, test and implement processes relevant to Cash management functions performed County-wide.

• Consult with Agencies on their Cash management functions and business needs and define, map and document the Oracle EBS Cash management module and system requirements.
• Consult with Agencies on their Cash management functions and business needs and create or modify and implement human resources processes, procedures for the Oracle EBS GL/Cash module and system requirements, processes, procedures and specifications.
• Consult with the Agencies on their Cash management functions and identify, evaluate and prioritize system changes based on design requirements and functional specifications.
• Conduct fit/gap analysis with all Agencies’ Cash management functions and the Oracle EBS Cash management module.
• Consult with Agencies and develop testing scenarios and with testing activities for the Oracle EBS Cash management module.
• Consult with Agencies and analyze their Cash management business needs and work with technical resources to develop functional design for Cash management reports and other developments.
• Analyze current Cash management business processes and facilitate transition to best practices as supported by Oracle EBS 12.0.
• Analyze and test proposed Oracle EBS Cash management module’s systems interfaces, enhancements, and upgrades prior to implementation.
• Evaluate existing and proposed Cash management applications for process efficiency and systems interface possibilities with the Oracle EBS Cash management module.
• Customize or modify fields and panels for the Oracle EBS Cash management module and monitor requests from Agencies for system changes and customizations.
• Lead and collaborate with Agencies and other functional analysts in tracking and resolving Oracle EBS Cash management module system problems and issues that require advanced Cash management technical expertise of the Oracle EBS Cash management module operating system.
• Coordinate activities of consultants, county agency staff and project team to install, configure and maintain Oracle EBS Cash management module development, testing, demonstration and training systems.
• Create Cash management business process documentation and write configuration and system data documentation for the Oracle EBS Cash management module.
• Create Cash management functional demonstration scripts and conduct system functionality demonstrations. Document and work to resolve functional gaps identified during the demonstrations.
• Investigate, troubleshoot and document complex Cash management functional system problems; develop solutions for more complex and critical Cash management production problems; ensure that Agency and module Cash management functional problems are resolved and that the solutions are documented.
• Develop and implement plans to assist in the IBIS Legacy system data clean up and data mapping; and defining user roles, responsibilities and security related to the Cash management function.
• Other duties as assigned.

• Bachelor’s degree in business administration or related field and at least three years financial system management experience or an equivalent combination of education and experience.
• Ability to configure Oracle tables
• Ability to create Oracle queries
• Functional knowledge of…