Explanation
BACKGROUND:
This ordinance is the second of four renewals, (3rd year of a 5 year) contract with Halcyon Solutions, Inc. initially authorized by ordinance 1426-2017 passed on July 10, 2017 establishing 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-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 $84,550.00. The term period of this renewal is July 25, 2019 through July 24, 2020. The contract was most recently authorized through Ordinance No. 1240-2018, passed on May 21, 2018 establishing purchase order PO0125838.
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 2019 and into 2020.
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/2020
FISCAL IMPACT
In 2017 and 2018 the Department of Technology legislated in (2017) under Ordinance number:1426-2017 $610,933.50 with Halcyon Solutions, Inc. for Tableau software licenses, first year maintenance and support, professional services and training and in (2018) Ordinance number: 1240-2018 ($73,150.00) for the second year of licensing maintenance and support. Funds for this third year of a five year maintenance and support renewal totaling $84,550.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 the software licenses, support, implementation and training cost.
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 $84,550.00 from the Information Services Division, Information Services Operating Fund. ($84,550.00)
Body
WHEREAS, the Department of Technology is continuing to implement throughout the City 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 licenses 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, 2019 through July 24, 2020, at a cost of $84,550.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, 2019 through July 24, 2020 at a cost of $84,550.00. This ordinance is the second of four renewals, (3rd 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 $84,550.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 1387-2019 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: $22,800.00 |
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: $61,750.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.