Explanation
This ordinance is the third of four renewals, (4th year of a 5 year) contract with Halcyon Solutions, Inc. initially authorized by ordinance 1426-2017, which passed on July 10, 2017 and resulted in the establishment of PO072480. It authorizes the Director of Finance and Management, on behalf of the Department of Technology, to associate all General Budget Reservations resulting from this ordinance with the appropriate State Term Schedule (STS033-534272, expires 10-28-20) authorized for the City’s use by Ordinance no. 582-87 with Halcyon Solutions, Inc. to continue licensing support for Tableau software and desktops at a cost of $97,442.16. The term period of this renewal is July 25, 2020 through July 24, 2021. The contract was most recently authorized through Ordinance No. 1317-2019, passed on June 10, 2019.
This ordinance also authorizes the extension of existing purchase order PO072480 (established with passage of ordinance 1426-2017), with Halcyon, for an additional year. This will allow for the use of any remaining funds on the purchase order, thus ensuring the availability of funds for the platform implementation of Tableau, which will continue through 2020 and into 2021.
Halcyon is not debarred according to the Federal excluded parties listing or prohibited from being awarded a contract according to the Auditor of State unresolved finding for recovery certified search. Tableau is a data visualization and business intelligence software that provides instantaneous insight by transforming data into visually appealing and interactive visualization. It helps the user see and understand the data quickly and find patterns that otherwise may be very difficult to detect and understand. Tableau connects to almost every database and its resulting visualizations can be easily shared with others both on and off City’s web pages. City departments are using this platform for data visualizations and better decision making.
CONTRACT COMPLIANCE NUMBER
Vendor Name: Halcyon Solutions, Inc.
DAX Vendor#: 005122 CC#: 31-1343200, Expiration Date: 02/28/2022
FISCAL IMPACT
Previous ordinances for the above-described purpose have been authorized in 2017, 2018, and 2019. In 2017, ordinance 1426-2017 authorized contracting with Halcyon Solutions and expending $610,933.50 with Halcyon Solutions, Inc. for Tableau software licenses, first year maintenance and support, professional services and training. In 2018 and 2019, ordinances 1240-2018 and 1317-2019 authorized the first and second renewals of that contract to for continued licensing at a cost of $73,150.00 and $84,550.00, respectively. This ordinance authorizes the third renewal for licensing and authorizes the expenditure of $97,442.16. These funds are available and budgeted in the Department of Technology’s Information Services Operating Budget.
Title
To authorize the Director of Finance and Management, on behalf of the Department of Technology, to associate all General Budget Reservations resulting from this ordinance with the appropriate State Term Schedule with Halcyon Solutions, Inc. to continue licensing support for Tableau software and desktops; to authorize the extension of existing purchase order PO072480 for a period of one year, to allow for the use of any remaining funds to continue with the project; and to authorize the expenditure of $97,442.16 from the Information Services Division, Information Services Operating Fund. ($97,442.16)
Body
WHEREAS, the Department of Technology is continuing to implement “Tableau,” a data visualization and business intelligence software, that provides instantaneous insight by transforming data into appealing and interactive visuals; and
WHEREAS, Halcyon Solutions, Inc. was awarded a contract from State Term Schedule STS033-534272 to assist with project implementation through the provision of hardware and software and licenses and maintenance support; and
WHEREAS, the Department of Technology wishes to renew the above-mentioned contract with Halcyon, allowable by the authority of ordinance 1426-2017; and
WHEREAS, to enable this renewal, it is necessary to authorize the Director of Finance and Management, on behalf of the Department of Technology to associate all General Budget Reservations resulting from this ordinance with the appropriate State Term Schedule (STS033-534272), authorized for the City's use by Ordinance No. 582-87, with Halcyon Solutions, Inc. to renew Tableau software licenses for a period of one year, from July 25, 2020 through July 24, 2021, at a cost of $97,442.16; and
WHEREAS, the Department of Technology also wishes to authorize the extension of existing purchase order PO072480 (established with passage of ordinance 1426-2017), with Halcyon, to allow for the use of any remaining funds, for a period of one year to continue with the project; and
WHEREAS, it is necessary to authorize the Director of the Finance and Management Department, on behalf of the Department of Technology, to associate all General Budget Reservations resulting from this ordinance with the appropriate State Term Schedule and to authorize the extension of existing purchase order PO072480 for a period of one year to continue Tableau, a data visualization and business intelligence software for the preservation of the public health, peace, property and safety and welfare; NOW, THEREFORE:
BE IT ORDAINED BY THE COUNCIL OF THE CITY OF COLUMBUS:
SECTION 1. That the Director of Finance and Management, on behalf of the Department of Technology, be and is hereby authorized to associate all General Budget Reservations resulting from this ordinance with the appropriate State Term Schedule (STS033-534272), authorized for the City's use by Ordinance No. 582-87, with Halcyon Solutions, Inc. to renew Tableau software licenses for a period of one year, from July 25, 2020 through July 24, 2021 at a cost of $97,442.16. This ordinance is the third of four renewals, (4th year of a 5 year) contract with Halcyon Solutions, Inc.
SECTION 2. That the extension of PO072480 for a period of one year is hereby authorized to allow for the use of any remaining funds needed to continue and complete the project.
SECTION 3. That the expenditure of $97,442.16, or so much thereof as may be necessary, is hereby authorized to be expended from the Department of Technology, Information Services Division, Information Services Operating fund as follows in the attachment to this ordinance. (see attachment 1248-2020 EXP)
SECTION 4: That the funds necessary to carry out the purpose of this ordinance are hereby deemed appropriated, and the City Auditor shall establish such accounting codes as necessary.
SECTION 5: That the City Auditor is authorized to make any accounting changes to revise the funding source for all contracts or contract modifications associated with this ordinance.
SECTION 6. That this ordinance shall take effect and be in force from and after the earliest period allowed by law.