Job ID: 13-063 BH
Job Title: .Net Developer
Job Location: CO - Denver
Job Type: Contract
Job Duration: 3 + Months
Client is seeking contractor services to develop and implement an application to support the Highway Users Tax Fund (HUTF) program. The WebHUT Backend (WebHUTBE) system will effectively provide with a utility to retrieve, process and store data across web-based and internal SQL and Oracle database platforms. WebHUTBE will provide a number of business process capabilities to the Division of Transportation Development (DTD), specifically with regard to Highway Users Tax Fund (HUTF) reporting. Essentially, it will allow staff to load, compare, verify, edit and report on tens of thousands of tabular edits received annually by local governmental users as required by HUTF, while implementing a well-defined set of business rules to ensure synchronization with master data sets complies with established organizational standards.
BACKGROUND, OVERVIEW, GOALS:
Current Methods of Data Integration for HUTF Roadway Information
Each local government in Colorado that participates in the Highway Users Tax Fund (HUTF) is required to submit information on their roadway systems to Client on an annual basis. The roadway information each jurisdiction submits to Client is eventually synchronized to a master tabular database residing at client. Reports from this master database are then sent to the Colorado State Treasury to be used in allocation formulas to distribute HUTF funds. Out of 332 reporting jurisdictions (cities and counties), approximately one half use online WebHUT Frontend (FE) reporting software. The software is based on a .NET framework running on a SQL server platform. It allows for local governments to view, edit, add, delete, and transfer (in cases of annexation) their tabular roadway information. The FE detects changes initiated by local governments and stores history and metadata for changes committed online. The WebHUT Backend (BE) software will contain functionality that brings this information stored externally in SQL tables by the FE back to client internally for analysis, processing, reporting and ultimately synchronization with an Oracle master database. An application for this purpose does currently exist, but due to limitations in analysis, reporting and synchronization capabilities, would require significant modification to achieve levels of reliability and sustainability that client desires. A new application at a minimum should be designed and developed to perform the functions that exist within the current application.
Project Objectives and Goals
client is seeking contractor services to design, develop and implement a .NET-based application to be used internally by multiple users for reviewing, editing and processing tabular roadway data submitted online by local government users for Highway Users Tax Fund (HUTF) program reporting. The WebHUT Backend application will be responsible for 5 processes:
Loading data from an internal Oracle database tables out to SQL database tables that exist outside of firewall in the WebHUT Frontend application,
Consuming altered roadway information and metadata from the WebHUT Frontend system and bringing it through firewall for review and comparison to static historical tables as well as live Oracle tables.
Provision of tools for staff to compare, accept, reject and/or alter data consumed in the previous step on a jurisdiction-by-jurisdiction basis; Log metadata and implement existing business rules for actions that occur within this data review process.
Posting the processed data to an internal Oracle database table, and,
Creating static and configurable reports for use by staff that reflects detected data changes in the previous three steps or actions taken during processing.
The application will allow staff to generate reports whose output will be utilized by HUTF staff, other business units, as well local government users. This application will need to consider databases in separate platforms and locations: SQL frontend tables that exist outside of firewall, and Oracle tables that exist internally and detail the original (static) state of the data as well as the current (dynamic) state. The application will need to evaluate
fields of data from each of these tables in a format that will be easy for the user to manipulate for creating the best possible view environment for decision-making. The application should adhere to the application requirements found in Functional Specification section below. The users of this application will be limited to staff; there will be no external users such as local governments.
2.3.4 WORK EXPERIENCE:
Proposal must list all relevant work experience and qualifications related to how expertise will be applied, the proposal should list and describe all relevant work experience and qualifications, including but not limited to:
Demonstrate expertise in the business requirements of a state DOT.
Proven expertise and success in .NET platform-based desktop application development within SQL and Oracle database environments.
Proven expertise and success in transportation database model development and implementation.
Understanding and experience in developing tools to support editing of highway/roadway data including Linear Referencing Systems and event layers. Previous experience developing work flow and linking multiple applications and processes.
Experienced in Agile Project Management and development.
HUTF – The Highway User Tax Fund.
WEBHUT Frontend - a web-based application for the Highway User Tax Fund (HUTF) program that allows updating of roadway inventory data by local government staff