title
Business Intelligence and Data Management Reporting System
end
|
DESCRIPTION: Reporting system that aggregates data from different sources within the organizations to produce meaningful reports to assist staff in making business decisions and reporting information to external stakeholders such as NTD |
AGENDA NO: 21-133 |
|
ACTION REQUEST: ☒ Approval ☐ Review Comment ☐ Information Only ☐ Other |
RECOMMENDATION:
recommendation
To authorize the CEO to award a contract to TranSight for scope of work outlined in RFP 2021-05. The installation cost will be $99,680.00, there will be an annual maintenance service fee, for three years at a cost of $ 231,817.00 for a total cost of $331,497 for four years. There is an option for two additional years of maintenance service for $169,697.00. If the additional two years of maintenance service is utilized the total contract amount will be $501,094 and a duration of six years, one year installation and five years of maintenance service.
end
ISSUE/BACKGROUND:
body
The RTA needs a Business Intelligence and Data Management Reporting system that aggregates data from different sources within the organization to produce meaningful reports for staff to assist in making business decisions and reporting to external stakeholders like NTD and FTA.
end
DISCUSSION:
The goal is to define and consistently implement best practices for financial and operational reporting. This will allow the utilization of data to improve service quality, while building an efficient and effective operation. The agency utilizes several data sources that will need to be integrated.
|
JD Edwards |
Enterprise Resource Planning Solution |
|
Trapeze |
Operator Scheduling, Dispatching, Work Management, Planning |
|
Clever Devices/Ridecheck Plus |
Operator/Fleet Performance, Automatic Passenger Count |
|
ADP |
Human Resource Data |
|
GenFare |
Fare System Data |
|
Ron Turley |
Maintenance Management System |
|
RouteMatch On-Demand and Para Transit |
|
|
Excel |
Various Data Points |
FINANCIAL IMPACT:
The project will be funded from local funds of $99,680 for year 1 and $231,817 to be paid over 3 years, with a possible $169,697 for additional 2 years of maintenance. Total of implementation and maintenance options $501,094.
NEXT STEPS:
Upon RTA Board approval, an award letter will be issued to TranSight and a purchase order will be requested.
ATTACHMENTS:
1. Board Resolution
2. Administrative Review Form RFP 2021-005
3. Procurement Summary RFP 2021-005 Business Intelligence
Prepared By: Sterlin Stevens, ssteven@rtaforward.org
Title: Director of Information Technology
Reviewed By: Lona Edwards Hankins, lhankins@rtaforward.org
Title: Deputy CEO of Planning and Infrastructure
Reviewed By: Gizelle Johnson Banks
Title: Chief Financial officer
9/20/2021
Alex Wiggins Date
Chief Executive Officer