Previous Job
Project Manager - Level 3 with Hyperion Planning EPM OR PeopleSoft EPM experience
Ref No.: 17-15192
Location: Washington, District of Columbia
Start Date: 04/05/2017
Hyperion EPM Planning Experience o Implementation and integration experience or candidate possess advanced or power user

Knowledge or support of corporate and management reporting and analysis, planning, budgeting and forecasting processes and cycles
Seasoned experience in gathering business and technical requirements relating to planning and EPM activities
Public Sector planning or implementation experience Objective & Scope:
WMATA's Office of Management and Budget Services (OMBS) is preparing for the replacement of their current financial planning or Enterprise Performance Management solution with Oracle's Hyperion EPM solution set.
WMATA is currently using PeopleSoft's EPM module v9.1; however, Oracle plans to sun-set support for the current PeopleSoft version of EPM in 2018.
The Hyperion solution offers the organization a greater amount of planning flexibility in their core planning/budgeting tool offering as well as additional modules and functionality which allows for possible future solution expansion.
WMATA's scope for their planning solution includes the capabilities of formulating budget and forecasting activity for both operating and capital activities.
Capital planning requires program and project level activities; whereas, operating planning is performed at the department mode and account level, inclusive of position budgeting.
Additionally, WMATA desires to utilize Hyperion at the enterprise level for financial reporting with detailed analytical capability at the transactional level.
WMATA is seeking a well-rounded, experienced business analyst who has practical planning, analysis and EPM implementation and integration experience to drive the preliminary project, Procurement, implementation, and integration activities.

Specifically the tasks entail
Requirements gathering of requirements,
Completion of all required Procurement documentation, evaluation criteria and supporting information, comprehensive SoW/RFP to select an integrator to implement the solution.
Assess, evaluate, verify, and validate systems integrator resources/capabilities, project management approach, as well as the proposed solution architecture to include design, infrastructure, interfaces, technical and performance requirements,
Identify and substantiate potential gaps/shortcomings between the proposed solution and WMATA's business requirements, objectives, outcomes, and desired future state WMATA's planning process is based on three main operating modes or divisions encompassing Rail, Bus and Access (Paratransit) and related supporting activities as well as overhead type departments Finance, HCM, Legal, etc.
The budget is formulated at a granular level which can span across over 200 accounts for over 400 budget/cost center types of dimensions.
There are requirements for the integration of HCM position data to assist in formulating the labor budgets at a more accurate, realistic and reconcilable level.
Planning is also performed at the capital program and project level therefore, the requirements and solution design must satisfy this need.
Annually there are over (x) programs comprised of over 200 capital projects, which in some cases can span multiple years.
The capital programs and projects are sourced from grants which can be Federal or based on the 8 different jurisdictions which WMATA operates in.
Responsibilities, Required Skills, Abilities and Experience Specific Project Responsibilities
The documentation of detailed functional planning and forecasting requirements gathered from all WMATA divisions and departments.
o Requirements should be testable to ensure they are valid, appropriate, organized and measurable in a traceability matrix.
A detailed capture of requirements to support an enterprise approach to reporting and analytical data needs of the organization
Marketplace research for applicable bidders/integrators to perform the implementation and integration work

The production of a comprehensive Statement of Work incorporating the articulation of WMATA's needs, such as;
o Listing company generic background information and project intent
o Development and incorporation of specific bidder criteria used to filter/eliminate unqualified bidding firms
o Definition of project scope
o Listing of standard project management planning approach requirements, such as project plan, change management plan, testing plan, etc.,
o Segregation of requirements by OMBS area as well as the development of a requirements traceability matrix
o Listing of reporting and analytical requirements by functional area
o Integration of HCM position information as it relates to the planning process
o Listing of technical specifications inclusive of hardware needs, integration/interfacing and data storage
Completion of a technical architectural diagram depicting the technical landscape with integration activities
o Data conversion/cleansing approach The creation of functional system testing criteria and use cases
The completion of all required Procurement documentation supporting the RFP process inclusive of
o RFP written evaluation response templates
o Coordination of oral demonstration/presentations and evaluation criteria scoring sheet
o Consolidated scoring template needed to determine the winning vendor
o Ability to assess, evaluate, verify, and validate systems integrator's project plan solution architecture, and all deliverables
Act as a business liaison, point of contact, and/or technical systems expert from the client base and with Oracle on any product specific issues (managing the overall project expectations, architecture & deliverables) Oversee (SI) development teams recommendations, proposed solutions, provide direction, review all deliverables to ensure quality of solutions and validation of deliverables before client review
Identify and substantiate potential gaps/shortcomings between the proposed solution and WMATA's business requirements, objectives, outcomes, and desired future state
Oversee the overall solution architecture, solution delivery, project planning, execution and monitoring
Manage the System Integrators (SI) and advise Senior Management on the design, data architecture, infrastructure and financial modeling within the BI & EPM tool set Governance over the (SI) Solution Architects who will be responsible for driving the design and implementation of Hyperion Planning and peripheral components Specific position experience and skills Possess experience in development and management of annual budget and multi-year capital and operating programs.
Practical experience in organizing, leading, coordinating personnel and activities in the budget development, execution and/or monitoring process.
Experience in aspects of financial reporting and analysis
Preferable experience or knowledge in jurisdictional allocations, grants management and revenue forecasting
Prior coordination, experience or knowledge in the development and evaluation of revenue and ridership forecasts and economic analysis in support of budget development
Understanding of best practices as it relates to planning systems and solutions to assist in gathering and refining requirements
At minimum 5 years of practical business planning experience.
Well versed in Public Sector planning processes and understanding of the rules around the segregation of funding or the color of funds.
Experience in documenting requirements at large $1B plus companies
Participated at minimum in 2 full EPM solution implementation cycles for similar sized companies
Demonstrated knowledge of principles and practices of revenue forecasting, economic principles, budgeting, financial management, program analysis
Thorough knowledge of principles, practices and application of budget formulation and administration, knowledge of GAAP,
Preferable experience with grants management, capital program budget and program evaluation
Ability to develop and analyze quantitative data and proven analytical skills
EPM implementation experience
Responsibilities may require working some evenings and weekends, sometimes with little advance notice.