Explanation
This ordinance is the first of four renewals of a contract initially authorized by ordinance 1426-2017 with Halcyon Solutions, Inc. 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-534354-51) 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 $73,150.00. The period of this renewal is July 25, 2018 through July 24, 2019.
This ordinance also authorizes 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. This extension will ensure the availability of funds for the platform implementation of Tableau, which will continue through 2018 and into 2019.
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.
CONTRACT COMPLIANCE NUMBER
Vendor Name: Halcyon Solutions, Inc.
DAX Vendor#: 005122 CC#: 31-1343200, Expiration Date: 02/28/2020
FISCAL IMPACT
Funds for this first renewal of $73,150.00 are available and budgeted within the Department of Technology, Information Services Division, Information Services Operating Fund. Ordinance 1426-2017 authorized the expenditure of $908,283.12 for this project. Of that amount, $610,933.50 was authorized for Halcyon Solutions, Inc.
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 $73,150.00 from the Information Services Division, Information Services Operating Fund. ($73,150.00)
Body
WHEREAS, the Department of Technology is implementing Tableau, a data visualization and business intelligence software that provides instantaneous insight by transforming data into visually appealing and interactive visualization; and
WHEREAS, Halcyon Solutions, Inc. was awarded a contract from State Term Schedule STS033-534354-51 to assist with project implementation through the provision of hardware and software and license and maintenance support; and
WHEREAS, 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-534354), 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, 2018 through July 24, 2019, at a cost of $73,150.00; and
WHEREAS, 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-534354), 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, 2018 through July 24, 2019 at a cost of $73,150.00.
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 $73,150.00 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: (see attachment 1240-2018 EXP)
Div.: 47-02 | Fund: 5100 | SubFund: 510001| Obj. Class.: 03 | Main Acct.: 63946 | Program: IT005| Section 3: n/a | Section 4: n/a | Section 5: n/a | Amount: $73,150.00 |
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.