OneStream Software Developer

Minimum (Required) : insert specific minimum skills for this Contract Position) Years Skills / Experience 6 Experience with general IT SDLC processes 6 Experience with Financial Reporting tools such as Hyperion or OneStream 4 Experience with OneStream to create Cube 4 Experience with OneStream to create a Dashboard Maintenance Unit, and Dashboard Groups

Experience with OneStream to create financial statements through report books using OneStream ITSAC Level (1, 2, 3) (Required) :

DESCRIPTION OF SERVICES : (Required)

TxDOT requires the services of [1] Software Developer hereafter referred to as Worker, who meets the general qualification of Software Developer 2 and the specifications outlined in this document. The OneStream Software Developer is contract position working closely with the Financial and Information Technology (IT) Division TxDOT Toll Department to support the delivery and maintenance of the FIN Forecasting Phase II project. The Phase II effort with expand the existing OneStream application, workstreams, cubes, reports, and exporting of data.

The worker's responsibilities and skills must include :

• Assist with the configuration of OneStream including but not limited to : Workflows, Data Sources, Transformation Rules, Business Rules and Calculations, Dashboards, Data Management Sequences, Cube / Master Data, System Security
• Create and build OneStream applications, cubes, dimensions, calculation scripts using vb.net or C# and SQL, data management jobs, workflows, and transformation rules.
• Create and Modify Cube Views and Dashboards in OneStream
• Modify and update Financial Model, data management, and dashboard extender business rules.
• Creates and maintains controls and analysis through financial modeling and presentation, as well as financial systems design in response to business requirements.
• Creating workflows from new data files.
• Mapping and Transformation of data for new workflows

The workers' responsibilities and skills must include : WORKER SKILLS AND QUALIFICATIONS (Required) 4 Use Spreadsheet / Excel add-In to create reports within OneStream 4 Experience with OneStream to create a Dashboard Maintenance Unit, and Dashboard Groups 4 Experience with OneStream to configure different Data Adapter types

Years Skills / Experience

OneStream Training Credentials : Designing an Application, Implementing, and

Building Basic Reports

OneStream Training Credentials : Building Basic Dashboards

OneStream Training Credentials : Application Build for Administrators TERM OF SERVICE (Required) : 12 mo. @ 2080 hrs.

Note : Working overtime may be expected in order to meet tight deadlines.

WORK HOURS AND LOCATION