Research Project Tracking System

Print
General Information
Study Number: TPF-5(467)
Lead Organization: Kentucky Transportation Cabinet
Solicitation Number: 1530
Partners: AL, AR, AZDOT, CO, DC, FL, KY, MO, MS, NE, NJ, NM, TX, VA, VT, WI
Status: Cleared by FHWA
Est. Completion Date:
Contract/Other Number:
Last Updated: Jan 20, 2023
Contract End Date:
Financial Summary
Contract Amount:
Total Commitments Received: $650,500.00
100% SP&R Approval: Approved
Contact Information
Lead Study Contact(s): Jarrod Stanley
jarrod.stanley@ky.gov
Phone: 502- 782-4090
FHWA Technical Liaison(s): John Moulden
john.moulden@dot.gov
Phone: 202-493-3470
Study Champion(s): Jarrod Stanley
jarrod.stanley@ky.gov
Phone: 502- 782-4090
Organization Year Commitments Technical Contact Name Funding Contact Name Contact Number Email Address
Alabama Department of Transportation 2021 $3,500.00 Kidada Dixon Virgil Clifton 334-353-6944 cliftonv@dot.state.al.us
Alabama Department of Transportation 2022 $46,000.00 Kidada Dixon Virgil Clifton 334-353-6944 cliftonv@dot.state.al.us
Arizona Department of Transportation 2021 $3,500.00 Dianne Kresich Angela Estrada (602) 712-8316 aringorestrada@azdot.gov
Arizona Department of Transportation 2022 $46,000.00 Dianne Kresich Angela Estrada (602) 712-8316 aringorestrada@azdot.gov
Arkansas Department of Transportation 2021 $3,500.00 Bethany Stovall Bethany Stovall (501)569-2279 bethany.stovall@ardot.gov
Arkansas Department of Transportation 2022 $46,000.00 Bethany Stovall Bethany Stovall (501)569-2279 bethany.stovall@ardot.gov
Colorado Department of Transportation 2023 $46,000.00 Thien Tran Thien Tran thien.tran@state.co.us
District of Columbia Department of Transportation 2021 $3,500.00 Stephanie Dock Stephanie Dock 202-671-1371 stephanie.dock@dc.gov
District of Columbia Department of Transportation 2023 $46,000.00 Stephanie Dock Stephanie Dock 202-671-1371 stephanie.dock@dc.gov
Florida Department of Transportation 2021 $3,500.00 Jennifer Clark Jennifer Clark 850-414-4614 jennifer.clark@dot.state.fl.us
Florida Department of Transportation 2023 $46,000.00 Jennifer Clark Jennifer Clark 850-414-4614 jennifer.clark@dot.state.fl.us
Kentucky Transportation Cabinet 2021 $3,500.00 Jarrod Stanley Jarrod Stanley (502) 782-4090 jarrod.stanley@ky.gov
Kentucky Transportation Cabinet 2023 $46,000.00 Jarrod Stanley Jarrod Stanley (502) 782-4090 jarrod.stanley@ky.gov
Mississippi Department of Transportation 2021 $3,500.00 Cindy Smith Robert Vance RVance@mdot.ms.gov
Mississippi Department of Transportation 2022 $3,500.00 Cindy Smith Robert Vance RVance@mdot.ms.gov
Missouri Department of Transportation 2021 $3,500.00 Jennifer Harper Jennifer Harper 573-526-3636 Jennifer.Harper@modot.mo.gov
Missouri Department of Transportation 2022 $46,000.00 Jennifer Harper Jennifer Harper 573-526-3636 Jennifer.Harper@modot.mo.gov
Nebraska Department of Transportation 2021 $3,500.00 Mark Fischer Mark Fischer (402) 479-3163 Mark.fischer@nebraska.gov
Nebraska Department of Transportation 2023 $46,000.00 Mark Fischer Mark Fischer (402) 479-3163 Mark.fischer@nebraska.gov
New Jersey Department of Transportation 2021 $3,500.00 Giri Venkiteela Giri Venkiteela 6099632239 Giri.Venkiteela@dot.NJ.gov
New Jersey Department of Transportation 2022 $46,000.00 Giri Venkiteela Giri Venkiteela 6099632239 Giri.Venkiteela@dot.NJ.gov
New Mexico Department of Transportation 2022 $49,500.00 Angelo Armijo Angelo Armijo (505)372-8757 Angelo.Armijo@dot.nm.gov
Texas Department of Transportation 2021 $3,500.00 Joanne Steele Ned Mattila 512-416-4727 ned.mattila@txdot.gov
Vermont Agency of Transportation 2021 $0.00 Emily Parkany Emily Parkany (802) 272-6862 Emily.Parkany@vermont.gov
Vermont Agency of Transportation 2022 $46,000.00 Emily Parkany Emily Parkany (802) 272-6862 Emily.Parkany@vermont.gov
Virginia Department of Transportation 2021 $3,500.00 Michael Fitch Bill Kelsh 434-293-1934 Bill.Kelsh@VDOT.Virginia.gov
Wisconsin Department of Transportation 2021 $3,500.00 Diane Gurtner Evelyn Bromberg 608-267-7360 evelyn.bromberg@dot.wi.gov
Wisconsin Department of Transportation 2023 $46,000.00 Diane Gurtner Evelyn Bromberg 608-267-7360 evelyn.bromberg@dot.wi.gov

Study Description

Each state in the U.S. has a transportation research program, typically managed by designated staff in the state DOT (or equivalent agency). While these programs vary substantially in size, complexity, staffing level, and resource availability, there are certain needs that are generally common to all programs. One of these needs is a tracking system for active and completed research projects. The tracking system can be used for numerous functions, including (but not necessarily limited to): • Tracking of active projects o A centralized source of key information for each project (name of PI and project manager, contact information, start date, planned completion date, budget, account number, etc.) o A centralized source of up-to-date status information for each project o Flagging of issues/problems (behind schedule, work versus spending, problems encountered, intervention required, etc.) • Tracking of research implementation • Tracking of submissions and approvals (initial work plan and budget, revisions to work plan and budget, deliverables, etc.) • A historical record of completed projects • Reporting o Generating program-wide reports for research program management o Generating periodic progress reports (e.g., quarterly reports) for individual projects • A repository for key project-related documents (proposals, work plans, budgets, meeting agendas and minutes, interim deliverables, final reports, etc.) In 2013, the Kentucky Transportation Cabinet (KYTC), in cooperation with the Kentucky Transportation Center (KTC) at the University of Kentucky, initiated an SPR project to develop and implement a web-based project management tool for research projects. This tool would provide easily-accessible, up-to-date information on project accomplishments and milestones, the current status of each project, and quick links to key project documents and deliverables. In addition to tracking the progress of active projects, the system would track and report the implementation of research results, following project completion. KYTC and KTC formed a Study Advisory Committee, developed functional requirements for the Research Project Tracking System (RPTS), hired a web developer/programmer, and developed the system, going live in July of 2015. The final report for that SPR project can be accessed here: https://uknowledge.uky.edu/ktc_researchreports/1678/ Over the past four years, KTC has continually enhanced the online system through a series of task orders issued to the original web developer/programmer. The result is a highly-functional system that is easy to use and meets most of Kentucky’s needs. It is accessible from any device with Internet access, and it works with virtually any web browser. However, because the system was internally developed using a single programmer, it is not easily updated to more state-of-the-art software packages, and Kentucky’s ability to maintain and upgrade the system long-term is highly dependent on the continued availability of the original developer. Thus, it is Kentucky’s desire to redevelop the system from scratch, using the most up-to-date software and industry standards and a stable, well established software development firm. The primary barrier to redeveloping the RPTS from scratch is the cost. For Kentucky to bear this cost alone would be challenging, perhaps even a show-stopper. However, Kentucky is not the only state that could benefit from such a system. So, we are proposing to carry out this development as a pooled-fund effort. We believe it is possible to develop common functional requirements that will meet the needs of multiple states and then use those functional requirements to guide development of a flexible, state-of-the-art system. With funding from multiple states, it should be possible to hire a top-notch developer without placing a financial burden on any individual state.

Objectives

Develop common functional requirements, a software solution and maintenance of the software solution for a Research Program Tracking System to be used by multiple DOTs

Scope of Work

By necessity, this project will be conducted in three phases. The success (or lack thereof) of Phase 1 will determine whether the project ceases at that point or continues into Phase 2. Phase 1: -- Development of Common Functional Requirements For Phase 1, a project steering committee will be formed, with representation from all participating states. KYTC intends to task the Kentucky Transportation Center with facilitating the development of common functional requirements for the new RPTS. Through face-to-face meetings and web-meetings with the steering committee, this effort will attempt to develop consensus on the functionality that the system must have to meet the states’ needs. Functionality that is desired (but not essential) will be identified as well. There may also be cases where an individual state (or a couple of states) want functionality that is of no interest to the remaining states. In such situations, a couple of options will be presented and considered by the state partners: 1. Go ahead and include this functionality in the core system, with the understanding that only one or two states will use it; or 2. Plan to provide this functionality as an add-on module, to be funded separately by the states that will use it. The product of Phase 1 will be a Functional Requirements Document (FRD) for the new RPTS. Each partner state will be involved in the review and approval of this document. The end of Phase 1 will be a decision point for the pooled-fund project. If, at this point, we have at least three states wanting to proceed into Phase 2, we will proceed. If not, the project will end at this point. In any case, each state will decide if they want to proceed with Phase 2. No state will be compelled to participate in (or provide funding for) Phase 2 if they choose not to participate. Phase 2 – Procurement of Software Developer and Development of RPTS The first step in Phase 2 will be development of a Request for Proposals (RFP) or Request for Qualifications (RFQ) to be used to solicit a software developer for development of the RPTS. Upon approval of the RFP/RFQ by the project steering committee, it will be advertised/distributed, and proposals/qualifications will be received. The project steering committee will review the proposals/qualifications and will select the vendor to develop the RPTS. A contract will be developed, specifying the work to be performed, system specifications, schedule, budget, acceptance and payment terms, software ownership and licensing requirements, training requirements, and methods of settling any conflict that may arise. The contract will also include a requirement for ongoing system support for a specified time period (to be determined by the steering committee). That support will be provided in Phase 3, described below. Once the contract has been approved and signed by both parties, the RPTS development will begin. Periodic status reports, demonstrations, and testing will be scheduled to ensure consistent oversight by the steering committee members. The development will proceed until the system is completed and accepted by the steering committee. At that point, each participating state will receive a license for unrestricted use of the system and training for system users (per the details spelled out in the contract). Phase 3 – Ongoing System Support Once the system has been delivered and is operational in each of the participating states, there will be a need for the system developer to provide ongoing support. This will include bug fixes, minor enhancements, and general technical assistance and follow-up training. A contract will be established (possibly a continuation of the original development contract) for this ongoing support. Each participating state will contribute to the cost of this support, thus minimizing the cost to each state. In the event that major enhancements are desired by one or more states, it may be necessary to establish

Comments

Phase 1 - $20,000 or $3,500 per state for the first year Phase 2 - $275,000 or $46,000 per state for the next year

Subjects: Planning and Administration

Documents Attached
Title File/Link Type Privacy Download
Quarterly Progress Report - 2nd Q 2022 TPF Quarterly Report Form - 2nd Q 2022.docx Quarterly Progress Report Public
Quarterly Progress Report - 4th Q 2022 TPF Quarterly Report Form - 4th Q 2022.docx Quarterly Progress Report Public
Quarterly Progress Report - 3rd Q 2022 TPF Quarterly Report Form - 3rd Q 2022.docx Quarterly Progress Report Public
Quarterly Report - Q4 2021 TPF Quarterly Report Form - 4th Q 2021.docx Quarterly Progress Report Public
Quarterly Report - Q3 2021 TPF Quarterly Report Form - 3rd Q 2021.docx Quarterly Progress Report Public
Quarterly Report - Q2 2021 TPF Quarterly Report Form - 2nd Q 2021.docx Quarterly Progress Report Public
Waiver Letter SPR Waiver Memo Solicitation#1530.signature.pdf Other Public
Quarterly Report - Q1 2021 TPF Quarterly Report Form - 1st Q 2021.docx Quarterly Progress Report Public
RPTS Updated Work Plan RPTS Pooled Fund Proposal-Updated-2021.pdf Work Plan Public
Acceptance Letter TPF 5(467) Acceptance Letter.docx Other Public
Documents Attached
Title File/Link Type Privacy Download
100% SPR Waiver Letter SPR Waiver Memo Solicitation#1530.signature.pdf Other Public

Research Project Tracking System

General Information
Study Number: TPF-5(467)
Lead Organization: Kentucky Transportation Cabinet
Solicitation Number: 1530
Partners: AL, AR, AZDOT, CO, DC, FL, KY, MO, MS, NE, NJ, NM, TX, VA, VT, WI
Status: Cleared by FHWA
Est. Completion Date:
Contract/Other Number:
Last Updated: Jan 20, 2023
Contract End Date:
Financial Summary
Contract Amount:
Total Commitments Received: $650,500.00
100% SP&R Approval:
Contact Information
Lead Study Contact(s): Jarrod Stanley
jarrod.stanley@ky.gov
Phone: 502- 782-4090
FHWA Technical Liaison(s): John Moulden
john.moulden@dot.gov
Phone: 202-493-3470
Commitments by Organizations
Organization Year Commitments Technical Contact Name Funding Contact Name Contact Number Email Address
Alabama Department of Transportation 2021 $3,500.00 Kidada Dixon Virgil Clifton 334-353-6944 cliftonv@dot.state.al.us
Alabama Department of Transportation 2022 $46,000.00 Kidada Dixon Virgil Clifton 334-353-6944 cliftonv@dot.state.al.us
Arizona Department of Transportation 2021 $3,500.00 Dianne Kresich Angela Estrada (602) 712-8316 aringorestrada@azdot.gov
Arizona Department of Transportation 2022 $46,000.00 Dianne Kresich Angela Estrada (602) 712-8316 aringorestrada@azdot.gov
Arkansas Department of Transportation 2021 $3,500.00 Bethany Stovall Bethany Stovall (501)569-2279 bethany.stovall@ardot.gov
Arkansas Department of Transportation 2022 $46,000.00 Bethany Stovall Bethany Stovall (501)569-2279 bethany.stovall@ardot.gov
Colorado Department of Transportation 2023 $46,000.00 Thien Tran Thien Tran thien.tran@state.co.us
District of Columbia Department of Transportation 2021 $3,500.00 Stephanie Dock Stephanie Dock 202-671-1371 stephanie.dock@dc.gov
District of Columbia Department of Transportation 2023 $46,000.00 Stephanie Dock Stephanie Dock 202-671-1371 stephanie.dock@dc.gov
Florida Department of Transportation 2021 $3,500.00 Jennifer Clark Jennifer Clark 850-414-4614 jennifer.clark@dot.state.fl.us
Florida Department of Transportation 2023 $46,000.00 Jennifer Clark Jennifer Clark 850-414-4614 jennifer.clark@dot.state.fl.us
Kentucky Transportation Cabinet 2021 $3,500.00 Jarrod Stanley Jarrod Stanley (502) 782-4090 jarrod.stanley@ky.gov
Kentucky Transportation Cabinet 2023 $46,000.00 Jarrod Stanley Jarrod Stanley (502) 782-4090 jarrod.stanley@ky.gov
Mississippi Department of Transportation 2021 $3,500.00 Cindy Smith Robert Vance RVance@mdot.ms.gov
Mississippi Department of Transportation 2022 $3,500.00 Cindy Smith Robert Vance RVance@mdot.ms.gov
Missouri Department of Transportation 2021 $3,500.00 Jennifer Harper Jennifer Harper 573-526-3636 Jennifer.Harper@modot.mo.gov
Missouri Department of Transportation 2022 $46,000.00 Jennifer Harper Jennifer Harper 573-526-3636 Jennifer.Harper@modot.mo.gov
Nebraska Department of Transportation 2021 $3,500.00 Mark Fischer Mark Fischer (402) 479-3163 Mark.fischer@nebraska.gov
Nebraska Department of Transportation 2023 $46,000.00 Mark Fischer Mark Fischer (402) 479-3163 Mark.fischer@nebraska.gov
New Jersey Department of Transportation 2021 $3,500.00 Giri Venkiteela Giri Venkiteela 6099632239 Giri.Venkiteela@dot.NJ.gov
New Jersey Department of Transportation 2022 $46,000.00 Giri Venkiteela Giri Venkiteela 6099632239 Giri.Venkiteela@dot.NJ.gov
New Mexico Department of Transportation 2022 $49,500.00 Angelo Armijo Angelo Armijo (505)372-8757 Angelo.Armijo@dot.nm.gov
Texas Department of Transportation 2021 $3,500.00 Joanne Steele Ned Mattila 512-416-4727 ned.mattila@txdot.gov
Vermont Agency of Transportation 2021 $0.00 Emily Parkany Emily Parkany (802) 272-6862 Emily.Parkany@vermont.gov
Vermont Agency of Transportation 2022 $46,000.00 Emily Parkany Emily Parkany (802) 272-6862 Emily.Parkany@vermont.gov
Virginia Department of Transportation 2021 $3,500.00 Michael Fitch Bill Kelsh 434-293-1934 Bill.Kelsh@VDOT.Virginia.gov
Wisconsin Department of Transportation 2021 $3,500.00 Diane Gurtner Evelyn Bromberg 608-267-7360 evelyn.bromberg@dot.wi.gov
Wisconsin Department of Transportation 2023 $46,000.00 Diane Gurtner Evelyn Bromberg 608-267-7360 evelyn.bromberg@dot.wi.gov

Study Description

Study Description

Each state in the U.S. has a transportation research program, typically managed by designated staff in the state DOT (or equivalent agency). While these programs vary substantially in size, complexity, staffing level, and resource availability, there are certain needs that are generally common to all programs. One of these needs is a tracking system for active and completed research projects. The tracking system can be used for numerous functions, including (but not necessarily limited to): • Tracking of active projects o A centralized source of key information for each project (name of PI and project manager, contact information, start date, planned completion date, budget, account number, etc.) o A centralized source of up-to-date status information for each project o Flagging of issues/problems (behind schedule, work versus spending, problems encountered, intervention required, etc.) • Tracking of research implementation • Tracking of submissions and approvals (initial work plan and budget, revisions to work plan and budget, deliverables, etc.) • A historical record of completed projects • Reporting o Generating program-wide reports for research program management o Generating periodic progress reports (e.g., quarterly reports) for individual projects • A repository for key project-related documents (proposals, work plans, budgets, meeting agendas and minutes, interim deliverables, final reports, etc.) In 2013, the Kentucky Transportation Cabinet (KYTC), in cooperation with the Kentucky Transportation Center (KTC) at the University of Kentucky, initiated an SPR project to develop and implement a web-based project management tool for research projects. This tool would provide easily-accessible, up-to-date information on project accomplishments and milestones, the current status of each project, and quick links to key project documents and deliverables. In addition to tracking the progress of active projects, the system would track and report the implementation of research results, following project completion. KYTC and KTC formed a Study Advisory Committee, developed functional requirements for the Research Project Tracking System (RPTS), hired a web developer/programmer, and developed the system, going live in July of 2015. The final report for that SPR project can be accessed here: https://uknowledge.uky.edu/ktc_researchreports/1678/ Over the past four years, KTC has continually enhanced the online system through a series of task orders issued to the original web developer/programmer. The result is a highly-functional system that is easy to use and meets most of Kentucky’s needs. It is accessible from any device with Internet access, and it works with virtually any web browser. However, because the system was internally developed using a single programmer, it is not easily updated to more state-of-the-art software packages, and Kentucky’s ability to maintain and upgrade the system long-term is highly dependent on the continued availability of the original developer. Thus, it is Kentucky’s desire to redevelop the system from scratch, using the most up-to-date software and industry standards and a stable, well established software development firm. The primary barrier to redeveloping the RPTS from scratch is the cost. For Kentucky to bear this cost alone would be challenging, perhaps even a show-stopper. However, Kentucky is not the only state that could benefit from such a system. So, we are proposing to carry out this development as a pooled-fund effort. We believe it is possible to develop common functional requirements that will meet the needs of multiple states and then use those functional requirements to guide development of a flexible, state-of-the-art system. With funding from multiple states, it should be possible to hire a top-notch developer without placing a financial burden on any individual state.

Objectives

Develop common functional requirements, a software solution and maintenance of the software solution for a Research Program Tracking System to be used by multiple DOTs

Scope of Work

By necessity, this project will be conducted in three phases. The success (or lack thereof) of Phase 1 will determine whether the project ceases at that point or continues into Phase 2. Phase 1: -- Development of Common Functional Requirements For Phase 1, a project steering committee will be formed, with representation from all participating states. KYTC intends to task the Kentucky Transportation Center with facilitating the development of common functional requirements for the new RPTS. Through face-to-face meetings and web-meetings with the steering committee, this effort will attempt to develop consensus on the functionality that the system must have to meet the states’ needs. Functionality that is desired (but not essential) will be identified as well. There may also be cases where an individual state (or a couple of states) want functionality that is of no interest to the remaining states. In such situations, a couple of options will be presented and considered by the state partners: 1. Go ahead and include this functionality in the core system, with the understanding that only one or two states will use it; or 2. Plan to provide this functionality as an add-on module, to be funded separately by the states that will use it. The product of Phase 1 will be a Functional Requirements Document (FRD) for the new RPTS. Each partner state will be involved in the review and approval of this document. The end of Phase 1 will be a decision point for the pooled-fund project. If, at this point, we have at least three states wanting to proceed into Phase 2, we will proceed. If not, the project will end at this point. In any case, each state will decide if they want to proceed with Phase 2. No state will be compelled to participate in (or provide funding for) Phase 2 if they choose not to participate. Phase 2 – Procurement of Software Developer and Development of RPTS The first step in Phase 2 will be development of a Request for Proposals (RFP) or Request for Qualifications (RFQ) to be used to solicit a software developer for development of the RPTS. Upon approval of the RFP/RFQ by the project steering committee, it will be advertised/distributed, and proposals/qualifications will be received. The project steering committee will review the proposals/qualifications and will select the vendor to develop the RPTS. A contract will be developed, specifying the work to be performed, system specifications, schedule, budget, acceptance and payment terms, software ownership and licensing requirements, training requirements, and methods of settling any conflict that may arise. The contract will also include a requirement for ongoing system support for a specified time period (to be determined by the steering committee). That support will be provided in Phase 3, described below. Once the contract has been approved and signed by both parties, the RPTS development will begin. Periodic status reports, demonstrations, and testing will be scheduled to ensure consistent oversight by the steering committee members. The development will proceed until the system is completed and accepted by the steering committee. At that point, each participating state will receive a license for unrestricted use of the system and training for system users (per the details spelled out in the contract). Phase 3 – Ongoing System Support Once the system has been delivered and is operational in each of the participating states, there will be a need for the system developer to provide ongoing support. This will include bug fixes, minor enhancements, and general technical assistance and follow-up training. A contract will be established (possibly a continuation of the original development contract) for this ongoing support. Each participating state will contribute to the cost of this support, thus minimizing the cost to each state. In the event that major enhancements are desired by one or more states, it may be necessary to establish

Comments

Phase 1 - $20,000 or $3,500 per state for the first year Phase 2 - $275,000 or $46,000 per state for the next year

Subjects: Planning and Administration

Title File/Link Type Private
Acceptance Letter TPF 5(467) Acceptance Letter.docx Other Public
Waiver Letter SPR Waiver Memo Solicitation#1530.signature.pdf Other Public
Quarterly Report - Q1 2021 TPF Quarterly Report Form - 1st Q 2021.docx Quarterly Progress Report Public
Quarterly Report - Q2 2021 TPF Quarterly Report Form - 2nd Q 2021.docx Quarterly Progress Report Public
Quarterly Report - Q3 2021 TPF Quarterly Report Form - 3rd Q 2021.docx Quarterly Progress Report Public
Quarterly Report - Q4 2021 TPF Quarterly Report Form - 4th Q 2021.docx Quarterly Progress Report Public
Quarterly Progress Report - 3rd Q 2022 TPF Quarterly Report Form - 3rd Q 2022.docx Quarterly Progress Report Public
Quarterly Progress Report - 4th Q 2022 TPF Quarterly Report Form - 4th Q 2022.docx Quarterly Progress Report Public
Quarterly Progress Report - 2nd Q 2022 TPF Quarterly Report Form - 2nd Q 2022.docx Quarterly Progress Report Public
RPTS Updated Work Plan RPTS Pooled Fund Proposal-Updated-2021.pdf Work Plan Public
Title File/Link Type Private
100% SPR Waiver Letter SPR Waiver Memo Solicitation#1530.signature.pdf Other Public

Currently, Transportation Pooled Fund is not supported on mobile devices, please access this Web portal using a desktop or laptop computer.