Loading...
HomeMy WebLinkAbout14 - NB-2 - Presentation - 10/1/2019NB 2: LAND MANAGEMENT SYSTEM UPDATE Appropriation & Vendor Contract City Council Meeting October 1, 2019 MODERNIZE TECHNOLOGY INFRASTRUCTURE 3 CURRENT SYSTEMS ARE ANTIQUATED, INCOMPLETE, AND NOT INTEGRATED •Most systems are more then 20 years old. Including LMS, ERP, Cashiering, etc. We are using Pneumatic Tubes To Process Credit Cards. •The more current systems we do have are piecemeal and were acquired to plug process leaks not to implement a Citywide Solution. •Most systems are not integrated. Meaning anything that goes from one system to another requires additional data entry or a printed report. 4 GOALS & PRIORITIES •3(c) Modernize our City’s IT Infrastructure comprehensively and strategically to save City resources, improve constituent services, enhance the budget process and maximize other revenues •6(d) Improve transparency and accountability as well as increase checks and balances by, without limitation, improving the Budget/Finance Software (“ERP” or Enterprise Resources Planning) •6(f) Maintain up-to-date and accessible information about public works projects, significant private development sites, and other city activities 5 ACTIONS TO COME •Budget/Finance Software (“ERP” or Enterprise Resource Planning) •Information Technology Strategic Plan Completed •An Enterprise Geographic Information System NOW •Implement a new Land Management System (LMS) RECOMMENDATIONS 7 RECOMMENDATIONS •Approve a budget adjustment appropriating $1,974,693 from committed fund balance in the Information Technology Replacement Fund (ITRF) for the acquisition and implementation of a new land management system (LMS); •Approve the proposed software and implementation services agreement with Tyler Technologies for a not-to-exceed amount of $901,606; •Authorize the City Manager and City Clerk to execute the proposed agreement and future amendments to the agreement; •Authorize a contract contingency of up to $100,000, if needed; and •Authorize the City Manager to execute a purchase order with Dell Marketing, L.P. for the purchase of servers and support hardware necessary to implement the new system for a not-to-exceed amount of $52,157.75. BACKGROUND 9 CURRENT LMS SYSTEM IS ANTIQUATED We acquired our current system: •The year of the .com boom •A year before DVDs first went on sale to the public in 1997 •The year of the first Flip Phone was sold to consumers; Motorala’s StarTAC for $1,000.00 •When a typical personal computer averaged 500 MB of data 10 CURRENT LMS SYSTEM IS NOT SUPPORTED •The City’s version of Permits+ no longer receives software updates or fixes from the vendor •If the system were to fail, the immediate solution would be to process permits and other customer requests by hand 11 SOFTWARE SOLICITATION AND FUNDING •Began planning for replacement in 2016 •February 21, 2017: Secured a software selection consultant, Soft Resources. •March 7, 2017: $1.5 million to Information Technology Replacement Fund (ITRF) •November 22, 2017: Formal RFP was released •April 24 to May 9, 2018: Demonstrations by vendors •July- August, 2018: Evaluators participate in IT strategic plan workshops September – December, 2018: Due diligence completed •January 2019: Began negotiations with Tyler Technologies •February 19, 2019: City Council committed $700,000 into the ITRF •July 23, 2019: Completed proposed implementation plan •August 20, 2019: Completed proposed budget •September 18, 2019: Finalize contract with Tyler Technologies TYLER TECHNOLOGIES ENERGOV 13 TYLER TECHNOLOGIES IS USED BY MANY CITIES THROUGHOUT CALIFORNIA •Newport Beach •Ventura •Tustin •Simi Valley •Pasadena •Laguna Beach •Fullerton •Carlsbad •Temecula •Encinitas 14 ENERGOV: CITY-WIDE SOLUTION Energov HDL Permits+ QAlert OTHER Energov Planning Engineering City Clerk (Connect to Laserfiche) Business License Fire Code Enforcement Transportation Building 15 ENERGOV: SPATIALLY BASED SYSTEM 16 ENERGOV: PROVIDES A PUBLIC PORTAL 17 ENERGOV: EASY INFORMATION RETRIEVAL 18 ENERGOV: SUPPORTS PAPERLESS SYSTEM 19 ENERGOV: WORKS WITH MOBILE APPS FOR DATA ENTRY IN THE FIELD 20 ENERGOV: PROVIDES WORKFLOWS WHICH SUPPORT THE USER 21 IN SUMMARY •Provide additional work capacity •Enhance public service •Increase reliability of data •Increase potential for analysis •Streamline review and decision- making processes •Cost savings BUDGET 23 PROPOSED BUDGET Budget Item Amount Percent Share Tyler Technology Software and Implementation Services $901,606 40.9% Additional Third-Party Software $25,840 1.2% Hardware $133,551 6.1% Project Management/Staff Augmentation $833,390 37.9% Contingency $305,613 13.9% Total Project Budget $2,200,000 100% Less: Amount Incurred for Soft Resources Contract (85,752) Less: Programmer Analyst II (139,555) Budget Adjustment Requested $1,974,693 Ongoing costs would be budgeted annually as part of the IT Department’s General Fund Budget starting FY 20/21. Estimated ongoing annual costs of the proposed system is $146,540 and $146,717 for the Programmer Analyst II. 24 SUMMARY 1. The budget includes direct and indirect costs of launching a new Land Management System 2. Direct costs include: Software, Hardware, and Implementation Services Provided by the Vendors. 3. Indirect costs are costs not contracted for but that are essential for the successful implementation of the new system ( e.g. staff augmentation, additional licenses for existing software) 4. The cost of the implementation is covered by the existing committed funds 5. The entire implementation plan includes approximately 14% contingency IMPLEMENTATION PLAN 26 TIMELINE Stage 1 Initiate & Plan October 2019 – February 2020 Stage 2 Assess & Define February – March 2020 Stage 3 Build & Validate March – September 2020 Stage 4 Final Testing & Training September – November 2020 Stage 5 Production Cutover November – December 2020 Stage 6 Closure January – March 2021 27 ROLES AND RESPONSIBILITIES IN THE CITY Executive Sponsor(s) Economic and Development Services and IT Directors Steering Group: Directors of 6 Departments Project Manager: Daniel Inloes •Programmer Analyst II •Implementation Consultant •Functional Leads •Change Management Leads •Power Users •End Users (70) •Technical Leads (5, Including Programmer Analyst II) •Planning Interns 28 NEXT STEPS •ACQUIRE AND INSTALL SERVERS This is the reason for the request to authorize a purchase order for servers (Dell Marketing) •HIRE AN IMPLEMENTATION CONSULTANT This action will come back to City Council for approval once the consultant has been selected and the contract completed. Staff is already engaged in this process. •COMMENCE THE INITIATE AND PLAN STAGE WITH TYLER TECHNOLOGIES 29 RECOMMENDATIONS •Approve a budget adjustment appropriating $1,974,693 from committed fund balance in the Information Technology Replacement Fund (ITRF) for the acquisition and implementation of a new land management system (LMS); •Approve the proposed software and implementation services agreement with Tyler Technologies for a not-to-exceed amount of $901,606; •Authorize the City Manager and City Clerk to execute the proposed agreement and future amendments to the agreement; •Authorize a contract contingency of up to $100,000, if needed; and •Authorize the City Manager to execute a purchase order with Dell Marketing, L.P. for the purchase of servers and support hardware necessary to implement the new system for a not-to-exceed amount of $52,157.75. NB 2: LAND MANAGEMENT SYSTEM UPDATE Appropriation & Vendor Contract City Council Meeting October 1, 2019