Mandatory Qualifications:
Consultant should have a solid working knowledge of accounting, inventory, procurement, and payroll systems of equal or similar complexity to the following applications:
- SunGard Public Sector’s ONE Solution Finance suite (formerly known as IFAS) is used by OCTA for General Ledger, Accounts Payable, and Accounts Receivable.
- Ellipse Procurement System by Mitrais Mining Solutions is used by OCTA for Procurement, Contracting, and Materials Management.
- Lawson Payroll and Human Resources software.
- Microsoft Professional Suite (ACCESS, Excel, Word, PowerPoint, and Outlook), SQL Server 8.0, Business Objects, Visual Basic programming, Microsoft operating systems, and Adobe In-Design CS5 and higher.
Education: Bachelor’s Degree in information technology.
Roles & Responsibilities:
Hyperion
- Develops and maintains all account string and data maps.
- Lead all meetings, training, and otherwise as required with all OCTA staff.
- Develop a plan to complete the build of OCTA’s Hyperion system including but not limited to timelines, steps, and deployment.
- Design and build all Hyperion, Webforms, dashboards, documents, and reports. Provide low-level building and administrative training to FP&A.
- Sole Administrator and manager of Hyperion. Ensure integrity of connections to external systems as well as data within Hyperion.
- Train all OCTA users on the use of Hyperion via presentations, videos, and manuals/documentation.
- Design and build system(s) in ACCESS or otherwise to support areas of responsibility in FP&A that cannot be supported in Hyperion. These areas include, but are not limited to, budget transfers, requisitions, and M2 city reporting. Connect system built to external systems and ensure integrity of connections and data.
- Ongoing maintenance which includes, but is not limited to:
Maintain all system tables and data
Upload budget changes to the accounting system (IFAS)
Import of actuals from IFAS
Post budget transfers and amendments
Verify working budget is balanced throughout the year
Maintain, enhance, and create new reports based on evolving needs and changing analysis requirements
Extract actuals filled positions from Lawson to report against budgeted positions
- Develop and enhance budget book reports to respond to requests from management and ensure the accuracy of the report data.
- Map actual against pre-determined projects for purpose of budget-to-actuals reporting, as needed.
- Map proposed budgeted line items to the corresponding projects in preparation for presentations to Executive Management and the Board of Directors.
BUDBAR System
- Consultant shall provide the following support in BUDBAR until the Hyperion system build is complete.
- Development of new workspaces and views to expedite the extraction and analysis of data and to further improve the system.
- Ongoing maintenance which includes, but is not limited to:
Maintain all system tables and data
Upload budget changes to IFAS
Import of actuals from IFAS
Post budget transfers and amendments
Verify working budget is balanced throughout the year
Maintain, enhance, and create new reports based on evolving needs and changing analysis requirements
Extract actual filled positions from Lawson to report against budgeted positions
- Provide insight and recommendations to FP&A management regarding the impact of future technology trends to FP&A’s systems:
The pros and cons of migrating systems onto a web interface solution or other evolving technologies
Analysis of current systems and associated data to determine optimal relationships to enable analysis opportunities and ensure data integrity
- Enhance budget book reports to respond to requests from management and ensure the accuracy of the report data
- Map actuals against pre-determined projects for purpose of budget-to-actuals reporting
- Map proposed budgeted line items to the corresponding projects in preparation for presentations to Executive Management and the Board of Directors
PARSS
- Explore options to enhance the functionality of this system as it connects to both the BUDBAR and Procurement systems (currently Ellipse).
- Enhance and recommend new reports to identify:
Miscoding of requisitions against budgeted line items
Overcommitted requisitions against budgeted line items
Remaining availability of funds within a budgeted line item
New reports as requested by Executive Management
RATS
- Ongoing maintenance and enhancement of the RATS system.
- Periodic import of actuals and ensuring integrity of data.
- Research and propose alternatives to enhance the system.