Previous Job
Project Manager - Level 3
Ref No.: 17-15221
Location: Chantilly, Virginia
Position Type:Contract
Start Date: 04/05/2017
 Client : WMATA
Location : Jackson Graham Building Washington DC
Duration : One Year
Hyperion EPM Planning Experience o Knowledge of products, system design, architecture, and configuration, Implementation and integration experience or candidate possesses advanced or power user skills/experience.
Knowledge or support of corporate and management reporting and analysis, planning, budgeting and forecasting processes and cycles.
Seasoned experience in conducting discovery, producing business and technical requirements and translating requirements into a traceability matrix, relating the Hyperion products to planning and EPM activities Public Sector planning or implementation experience
Objective & Scope:
WMATA Office of Management and Budget Services (OMBS) is preparing for the replacement of their current financial planning or Enterprise Performance Management solution with Oracle Hyperion EPM solution set. WMATA is currently using PeopleSoft 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 than the current planning/budgeting tool, as well as additional modules and functionality which allows for possible future solution expansion. WMATA scope for their planning solution includes the capabilities of formulating the 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 project manager/business analyst who has practical planning, analysis and EPM implementation and integration experience to drive the preliminary project, pre-solicitation, implementation, and integration activities. Specifically these tasks entail; Requirements gathering Completion of all required pre-solicitation documentation (evaluation criteria, supporting information, comprehensive SoW/RFP) 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 and/or shortcomings between the proposed solution and WMATA business requirements, objectives, outcomes, and desired future state WMATA 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 multiple programs that make up 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. 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. Familiarity and knowledge of systems integrator marketplace and performance  The production of a comprehensive Statement of Work incorporating the articulation of WMATA needs, such as; Listing company generic background information and project intent Development and incorporation of specific bidder criteria used to filter/eliminate unqualified bidding firms o Definition of project scope. Listing of standard project management planning approach requirements, such as project plan, change management plan, testing plan, etc., Segregation of requirements by OMBS area as well as the development of a requirements traceability matrix Listing of reporting and analytical requirements by functional area o Integration of HCM position information as it relates to the planning process 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 Data conversion/cleansing approach The creation of functional system testing criteria and use cases The completion of all required pre-solicitation documentation supporting the RFP process inclusive of o RFP written evaluation response templates o Coordination of oral demonstration/presentations and evaluation criteria scoring sheet Consolidated scoring template needed to determine the winning vendor o Ability to assess, evaluate, verify, and validate systems integrators 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 Systems Integrator (SI) development teams recommendations, proposed solutions, and provide direction and review of 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 business requirements, objectives, outcomes, and desired future state Oversee the overall solution architecture, solution delivery, project planning, execution and monitoring  Manage the Systems Integrator (SI) and advise Senior Management on the design, architecture, infrastructure and financial modeling within the business intelligence (BI) & enterprise performance management (EPM) tool set Governance over the Systems Integrator (SI) Solution Architects who will be responsible for driving the design and implementation of Hyperion Planning and peripheral components Steward project from implementation/integration through completion and acceptance of the solution from the Systems Integrator (SI) to WMATA 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.