Loading...
HomeMy WebLinkAbout2013-05-14; City Council; 21224; Approval Amendment 7 Agreement with Tiburon IncCITY OF CARLSBAD - AGENDA BILL DEPT. HEAD/^i^ CITY ATTY. CITY MGR. AB# MTG. DEPT. 21,224 05/14/13 POLICE APPROVAL TO AND RATIFICATION OF AMENDMENT NO. 7 TO EXTEND AND AMEND THE MASTER SUPPORT AGREEMENT FOR COMPUTER AUTOMATED SYSTEM SUPPORT SERVICES WITH TIBURON INC. RECOMMENDED ACTION: Adopt Resolution No. 2013-106 to approve, ratify and authorize the execution of Amendment No. 7 to extend and amend the Master Support Agreement between the City of Carlsbad and Tiburon, Inc. for Computer Automated System Support Services related to the Police Computer Aided Dispatch and Mobile system. ITEM EXPLANATION: On September 12, 2003, the city entered into an agreement with Tiburon, Inc. (Tiburon) to provide a fully integrated Public Safety Information System (PSIS) including the major subsystems of a computer aided dispatch system, a police mobile data system, a message switch, a mobile mapping system, an automated field location system, and the components and interfaces for these systems. The Public Safety Information system was successfully implemented and has been operational since May of 2005. In February of 2009, the city entered into an agreement with Tiburon for annual computer aided support services (Support Agreement). Since 2009, five amendments to the Support Agreement have been executed for support, including enhancements to the system. On April 26, 2011, Council executed a ratification of Amendment No. 4 to the Support Agreement for upgrading the CAD and Mobile system to the most current version in order to comply with U.S. Department of Justice-Federal Bureau of Investigation Criminal Justice Information Services (CJIS) security policy. In order to provide the reliability and redundancy expected of a mission critical 24-hour public safety system, the upgrade specified that ail Tiburon applications would operate in a virtual server environment. Council approved funding of the upgrade with both IT replacement funds and federal asset forfeiture funds. City staff and Tiburon worked diligently to accomplish the CAD and Mobile upgrade but, in June of 2012, Tiburon announced that they would no longer support their software on virtual servers and was unable to complete the upgrade. City staff continued to work on other aspects of the upgrade project while negotiating an acceptable solution with Tiburon that would meet CJIS requirements. DEPARTMENT CONTACT: Maria Callander 931-2176 maria.callander(a)cartsbadca.gov FOR CITY CLERKS USE ONLY. COUNCIL ACTION: APPROVED CONTINUED TO DATE SPECIFIC • DENIED • CONTINUED TO DATE UNKNOWN • CONTINUED • RETURNED TO STAFF • WITHDRAWN • OTHER-SEE MINUTES • AMENDED • Page 2 City staff has negotiated Amendment No. 7 to the Support Agreement, encompassing an acceptable solution with Tiburon, which includes both virtual and physical servers, and provides the required reliability and redundancy. In order to compensate the city for the project delay, Tiburon has agreed to waive the annual increase to maintenance for FY 2013-14. In addition, city staff negotiated a $24,121 credit from Tiburon to reimburse the city for the purchase of additional required hardware. The CAD and Mobile upgrade will be implemented by January 2014. FISCAL IMPACT: The funding for the upgrade of the CAD and Mobile system of $127,572 was previously approved by Council as part of Amendment No. 4 and remains in the city's project fund for this upgrade. City staff negotiated a fee reduction/credit of $24,121 from Tiburon to reimburse the city for the purchase of additional hardware required for the upgrade. In order to compensate the city for the project delay, Tiburon has agreed to waive the annual increase to maintenance for FY 2013-14. ENVIRONMENTAL IMPACT: Pursuant to Public Resources Code section 21065 and CEQA Guidelines section 15738, this amendment does not constitute a "project" within the meaning of CEQA and therefore, does not require additional environmental review. EXHIBITS: 1. Resolution No. 2013-106 approving Amendment No. 7 to the Support Agreement between the City of Carlsbad and Tiburon, Inc. for Computer Automated Support Services. 2. Amendment No. 7 to the Support Agreement for Computer Automated Support Services. 9^ 1 RESOLUTION NO. 2013-106 2 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF CARLSBAD, CALIFORNIA, APPROVING THE RATIFICATION OF AMENDMENT NO ^ 7 TO EXTEND AND AMEND THE MASTER SUPPORT AGREEMENT BETWEEN THE CITY OF CARLSBAD AND TIBURON, INC. FOR COMPUTER AUTOMATED SYSTEM SUPPORT SERVICES 5 6 WHEREAS, on September 12, 2003 the City of Carlsbad entered into an 7 agreement with Tiburon, Inc. ("Tiburon") (collectively "Parties") to provide a fully ^ integrated Public Safety Information System, comprising of a computer aided dispatch system, a police mobile data system, a message switch, a mobile mapping system, an automated field location system; and WHEREAS, the Public Safety Information System was successfully implemented and has been operational since May of 2005; and WHEREAS, the Public Safety Information System was accepted in February of 9 10 11 12 13 14 J5 2009 and the city entered into a Master Support: Agreement with Tiburon in May of 2009 16 for annual support services; and 17 WHEREAS, on April 26, 2011 the City of Carlsbad executed Amendment No. 4 1^ to the Master Support Agreement for upgrading the system to the most current version; and WHEREAS, the Parties desire to enter into this Amendment No. 7 to Extend and Amend the Master Support Agreement for an additional fifteen (15) months to allow the contractor sufficient time to complete the upgrade as initially specified in Amendment Number 4 and as modified by Amendment No. 7; and WHEREAS, the funding for the upgrade of the CAD and Mobile system of 26 $127,572 was previously approved by council as part of Amendment No. 4 and remains 27 in the IT replacement fund for this upgrade; and 19 20 21 22 23 24 25 28 5 1 WHEREAS, the Parties have negotiated and agreed to a credit in the amount of 2 $24,121 to compensate the city for costs associated with the purchase of additional ^ hardware and software; and WHEREAS, the Parties have negotiated and agreed that Tiburon will waive the five percent (5%) annual maintenance increase for the 2013-2014 annual maintenance period in order to reimburse the city for costs associated with the implementation delay; and WHEREAS, the Parties have negotiated and agreed that Tiburon will maintain in IQ full force and effect the maintenance starting after July 1, 2013 on the city's Stratus 11 server and Oracle software until the upgraded system has been put into production and 12 final acceptance has been granted; and 1^ WHEREAS, Tiburon has executed Amendment No. 7 to Extend and Amend the Master Support Agreement for support services; and WHEREAS, Amendment No. 7 to the Master Support Agreement must be ratified because Tiburon continued to provide services without the benefit of this amendment; and NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of 14 15 16 17 18 19 2Q Carlsbad, California, as follows: 21 1. That the above recitations are true and correct. 22 2. That the City Council of the City of Cartsbad approves the Ratification of 23 Amendment No. 7 to Extend and Amend the Master Support Agreement for annual support services, including an acceptable solution with Tiburon, which includes both virtual and physical servers, and provides the required reliability and redundancy. 25 26 27 28 1 3. That the Mayor is authorized to execute Amendment No. 7 to Extend and 2 Amend the Master Support Agreement. 3 PASSED, APPROVED AND ADOPTED at a Regular Meeting of the City Council 4 of the City of Carlsbad on the 14*^ day of May, 2013, by the following vote to wit: AYES: Council Members Hall, Packard, Wood, Blackburn and Douglas. NOES: None. ABSENT: None. 9 10 11 12 13 MATT HALL: Mayor ATTEST: 14 15 16 17 18 19 (SEAL) 20 21 22 23 24 25 26 27 28 BARBARA ENGLESON, City Clerk RATIFICATION OF AMENDMENT NO. 7 TO EXTEND AND AMEND MASTER SUPPORT AGREEMENT FOR FOR COMPUTER AUTOMATED SYSTEM SUPPORT SERVICES TIBURON INC. This Ratification of Amendment No. 7 is entered into as of the /S^dav of t^Ciy , 2013, but effective as of the twenty-seventh day of October, 2012, extending and amending the Master Support Agreement dated May 19, 2009 that was effective as of February 19, 2009 (the "Master Support Agreement") by and between the City of Cartsbad, a municipal corporation, ("City"), and Tiburon Inc., a Virginia corporation, having its pnmary place of business at 6200 Stoneridge Mall Road, Suite 400, Pleasanton, California 94588, (hereinafter "Tiburon" or "Contractor") (collectively the "Parties"). RECITALS A. On May 19, 2009, the Parties executed the Master Support Agreement for support and maintenance services relating to a computer automated system previously developed and implemented by Tiburon for City which was effective February 19, 2009 to June 30, 2009; and B. On July 27, 2009, the Parties executed a ratification of Amendment Number 1 that was effective July 1, 2009 to extend the Master Support Agreement for one (1) additional year to June 30, 2010; and C. On August 19, 2010, the Parties executed a ratification of Amendment Number 2 that was effective July 1, 2010 to extend the Master Support Agreement for one (1) additional year to June 30, 2011; and D. On April 26, 2011, the Parties executed a ratification of Amendment Number 3 to add services for deleting old messages in the Computer Aided Dispatch ("CAD") message switch; and E. On April 26, 2011, the Parties executed a ratification of Amendment Number 4 to add services for upgrading the CAD and Mobile system to the most current version; and F. On August 24, 2011, the Parties executed a ratification of Amendment Number 5 that was effective July 1, 2011 to extend the Master Support Agreement for one (1) additional year to June 30, 2012; and G. On May , 2013 and concurrent with the execution of Amendment Number 7, the Parties executed ratification of Amendment Number 6 that was effective July 1, 2012 to extend the Master Support Agreement for one (1) additional year to June 30, 2013; and H. The scope of work required by Amendment Number 4 was required to be completed by October 26, 2012 and the Master Support Agreement expired on June 30, 2012; however. Contractor continued to work on completing the Amendment Number 4 services specified therein along with general maintenance/support without the benefit of an agreement; and I. The Parties desire to extend the Agreement for an additional fifteen (15) months City Attorney Approved Version #05.22..01 6 beginning on October 27, 2012 to allow the Contractor sufficient time to complete the upgrade to the CAD system as initially specified in Amendment Number 4 and as modified by the supplemental scope of work and project schedule, which is identified hereto as Exhibit "A" Scope of Work to this Amendment Number 7 and which is attached hereto and incorporated herein by this reference; and J. The Parties have negotiated and agreed to a credit in the amount of $24,121, to compensate the City for costs associated with the requirement for a physical server that will function as the CAD application and Message Switch server, a second database server, and additional software licensing; and K. The Parties have negotiated and agreed to the Fee and Payment Schedule as specified in Exhibit "A"; and L. The Parties have negotiated and agreed to a project schedule as specified in Attachment E, "Attachment E - Project Schedule" which is attached hereto and incorporated herein by this reference; and M. The Parties have negotiated and agreed that the Contractor will waive the five percent (5%) annual maintenance increase for the 2013-2014 annual maintenance period in order to reimburse the City for costs associated with the implementation delay; and N. The Parties have negotiated and agreed that Tiburon will maintain in full force and effect the maintenance starting after July 1, 2013 on the City's Stratus servers and Oracle software until the upgraded system has been put into production and final acceptance has been granted. NOW, THEREFORE, in consideration of these recitals and the mutual covenants contained herein. City and Contractor agree as follows: 1. The above recitals are incorporated herein. 2. The retroactive extension and Amendment Number 7 to the Master Support Agreement is ratified. 3. That the Agreement, as may have been amended from time to time, is hereby extended for a period of one year ending on January 27, 2014; and 4. That the fixed pnce fee for all services to be provided pursuant to Amendment Number 4 is $127,572 and that the services provided by this Amendment Number 7 will result in a fee reduction/credit in an amount of $24,121, as further set forth in Exhibit A. 5. All other provisions of the Agreement, as may have been amended from time to time, will remain in full force and effect. 6. All requisite insurance policies to be maintained by the Contractor pursuant to the Agreement, as may have been amended from time to time, will include coverage for this Amendment. (Remainder of Page Intentionally Left Blank) City Attorney Approved Version #05.22..01 7. All exhibits identified in this Amendment Number 7, and the attachments referenced in Exhibit A are incorporated into this Amendment to the Master Support Agreement. 8. The individuals executing this Amendment and the instruments referenced in it on behalf of Contractor each represent and warrant that they have the legal power, right and actual authority to bind Contractor to the terms and conditions of this amendment. CONTRACTOR (print name/title) (e-mail address) (sign here) (print name/title) C^fol\ (^TlL (e-mail address) CITY OF CARLSBAD, a municipal corporation of the State of California Mayor ATTEST: BARBARA ENGELSQ City Clerk If required by City, proper notarial acknowledgment of execution by contractor must be attached. If a Corporation. Agreement must be signed by one corporate officer from each of the following two groups. **Group B. [Secreiaoti^ Assistant Secretary, CFO or Assistant Treasurer Otherwise, the corporation must attach a resolution certified by the secretary or assistant secretary under corporate seal empowering the officer(s) signing to bind the corporation. "Group A. Chairman, President, or Vice-President APPROVED AS TO FORM: CELIAAvS^t^^R, City Attorney fant City Attorney City Attorney Approved Version #05.22..01 EXHIBIT "A" SCOPE OF SERVICES AND FEE Project Schedule All services listed herein will be performed according the Project Schedule attached hereto as "Attachment E - Project Schedule". Scope Description Tiburon will provide all services required to upgrade Cartsbad's Computer Aided Dispatch and Mobile/AVL system to the latest released version, currently Command CAD 2.8 and MobileCOM 5.3. All services listed herein are in addition to the services that were specified in Amendment Number 4, Exhibit A. Tiburon responsibilities: 1. Tiburon requires that the CommandCAD application be implemented on a physical server. All other Tiburon servers outlined in the updated exhibits attached hereto can be virtualized as specified in amended Attachment D. 2. Tiburon will redeploy all servers specified in amended Attachment D in the city provided VMWare environment. 3. Tiburon will deploy the Command CAD application server on city provided physical server. 4. Tiburon will provide at least six (7) days of additional onsite training. 5. Tiburon will provide the City the following data conversion services, which will be performed independently of each other based upon the agreed upon project schedule: a) Tiburon will work with Carlsbad to define and jointly perform audit on data conversion routines to validate accuracy and completeness. b) CAD File Maintenance conversion: In order to preserve configuration that was accomplished during training in August of 2012, some of the tables will be updated by Carlsbad and some will be converted. Cartsbad and Tiburon will work to identify which tables should be manually updated. Tiburon will compare the previously converted File Maintenance 2.8 tables to the current versions in CAD 2.2 to produce lists of updates that have been performed by Carlsbad in 2.2. Carlsbad will then manually update the 2.8 tables with the identified changes. c) Data Warehouse conversion: Initial extraction, conversion, loading and testing of the Data Warehouse database will be performed in advance of onsite training. d) CAD Histones conversion: Will be performed periodically according to the project schedule. City Responsibilities: 1. Work with Tiburon to define and jointly perform audits and testing of data conversion routines and validation of converted data. 2. Provide and install physical CAD application server including the install of Windows Server 2008 R2 Standard and configure according to City security policies. City Attorney Approved Version #05.22..01 C/ Fee and Payment Schedule The fixed price fee for all services to be provided pursuant to Amendment Number 4 is $127,572. This Amendment Number 7 will result in a credit to the City in an amount as further descnbed below. Tiburon will provide the City a credit of $24,121 spread evenly by percentage of the project payments in order to reimburse the City for costs associated with the following: • $6,371 for 50% of the estimated cost of a second database server • $12,500 for 50% of the estimated cost of a physical server for CommandCAD • $5,250 for 50% of the estimated cost of VMware licensing City will pay Tiburon according to the payment schedule below and within 30 days of achieving the milestone and Tiburon's invoice to the City. Percentage Amount Credit Payment Milestone 20% $25,514 $4824 $20,690 Execution of agreement with firm detailed scheduled included 20% $25,515 $4824 $20,691 Completion of training 20% $25,514 $4824 $20,690 Successful go-live of CommandCAD and MobileCOM as defined below 40% $51,029 $9649 $41,380 Final acceptance as defined below. Total $127,572 $24,121 $103,451 In addition, Tiburon will reimburse the city for the actual cost of leasing equipment to provide 10 PC workstations with dual monitors for training. The training environment will be established according to the dates included in "Attachment E - Project Schedule" and will be operational at least one week prior to onsite training and will remain in place until final acceptance is granted as defined herein. The City will provide Tiburon with copies of the invoices paid for equipment leasing and Tiburon will reimburse the City promptly within thirty (30) days of receipt of such invoice. Final Acceptance Criteria The "go-live" of CommandCAD or MobileCom will be considered successful ten (10) business days after the CommandCAD latest version and MobileCOM have been placed into production. If Client does not confirm completion with a sign off letter presented by the Tiburon project manager within ten (10) business days of submittal of such letter, or othenA/ise notifies Tiburon in writing why completion sign-off has not been provided any final invoice(s) will be issued and will be payable in accordance with the payment terms of this Amendment. City Attorney Approved Version #05.22..01 Final acceptance will be granted fifteen (15) business days after the CommandCAD latest version and MobileCOM have been placed into production and has been fully functional without any Priority 1 failures. If Client does not confirm completion with a sign off letter presented by the Tiburon project manager within ten (10) business days of submittal of such letter, or othen/vise notifies Tiburon in writing why completion sign-off has not been provided any final invoice(s) will be issued and will be payable in accordance with the payment terms of this Amendment. City Attorney Approved Version #05.22..01 Amended Attachment C - CAD Workstation Hardware Requirements (08/31/12) Below is the minimum specifications which are not specific to a brand, unless otherwise stated. In which case, such brand name is required: Operating System Windows 7 SP1 64-bit Processor Dual Core Intel 2.4 GHZ or greater Memory 4GB or greater Graphics 512 MB NVIDIA Quadro NVS 420, Quad Monitor, 4DVI or better Boot Hard Drive 80 GB SATA 3.0 GB/s or better Hard Drive Configuration C1 All SATA or SSD drives, no RAID for 1 Hard drive Floppy drive and media card Reader Options Not necessary Mouse USB Optical Mouse Chassis configuration Mini-tower chassis configuration CD-ROM, DVD and Read Write Devices 16X DVD-ROM Hard Drive Controller Integrated Intel chipset SATA 3.0 GB/s controller Energy Efficiency option No Energy Star Monitor 19" or larger IP Amended Attachment D - Carlsbad - CAD Server Configuration CAD server Model OS IP Address Computer Name CPU Memory Storage (Physical Server Provided by City) TBD Windows 2008 R2 192.168.31.XX TBD (virtual previously named SCCADAPPOIv) TBD TBD TBD Functions CAD LIVE, MSS LIVE, CommandCAD Interfaces and Maverick Mapping for CAD LIVE Recommendations This server is a physical machine on the same network speed as the rest of the workstations. CAD Database server (virtual) Model OS IP Address Computer Name vCPU Memory Storage VMware Windows 2008 R2 STD 192.168.31.22 SCCADDBOIv 1 8GB (System is connect to SAN) C: OS with 60GB D: App with 30GB E: Database 100GB F: Logs with 30GB G: Backup with 200GB Functions SQL Server, Live Database, Test Database,(CAD and MSS), File Maintenance Test, and Location Verification Services Test Recommendations E: Database partitions need have 2 times the current data space size. The G: Backup partition needs to be twice the size of E: partition. Data Warehouse server (virtual) Model VMware OS Windows 2008 R2 STD J. IP Address Computer Name vCPU Memory Storage 192.168.31.28 SCCADDWOIv 1 8GB (System is connect to SAN) C: OS with 60GB D: App with 30GB E: Database 100GB F: Logs with 30GB G: Backup with 200GB Functions SQL Server, Data Warehouse DB (Live & Test), SQL Server Reporting Services, CAD Distnbution, File Maintenance Distnbution, Map Distnbution, Map Update Service (corn- agent), and MobileCOM LIVE and TEST Distnbution Recommendations E: Database partitions need have 2 !4 time the current data space size. The G: Backup partition needs to be twice the size of E: partition. Webquery server (virtual) Model OS IP Address Computer Name vCPU Memory Storage Vmware Windows 2008 R2 STD 192.168.31.26 SCCADWEBOIv 1 4GB (System is connect to SAN) C: (OS 60G) and D:(App 30GB) Functions Authentication Services, WebQUERY Live/Test, File Maintenance Live and Location Verification Services Live Recommendations CAD TEST server (virtual) Model OS IP Address Computer Name vCPU Memory Storage Functions Vmware Windows 2008 R2 STD 192.168.31.27 SCCADAPPTESTOIv 1 4GB (System is connect to SAN) C: (OS 60G) and D:(App 30GB) CAD TEST, MSS TEST, Mavenck Mapping for CAD TEST and Test CommandCAD Interfaces Interface Server (virtual) Model Vmware OS Windows 2008 R2 STD IP Address 192.168.31.23 Computer Name SCCADiFaceOlv vCPU 1 Memory 4GB Storage (System is connect to SAN) C: (OS 60G) and D:(App 30GB) Functions This server supports the interfaces for CLETS, Paging Interface, Digi devices for Paging, CAD Live, MSS Live, and Mapping CAD MQ Server 1 (virtual) Model Vmware OS Windows 2008 R2 STD IP Address 192.168.31.24 Computer Name SCCADMQ01 v vCPU 1 Memory 4GB Storage (System is connect to SAN) C: (OS 60G) and D:(App 30GB) Functions MQ Series, Websphere, CLETS interface pnmary MQ Server 2 (virtual) Model Vmware OS Windows 2008 R2 STD IP Address 192.168.31.25 Computer Name SCCADMQ02v vCPU 1 Memory 4GB Storage (System is connect to SAN) C: (OS 60G) and D:(App 30GB) Functions MQ Series, Websphere, CLETS interface secondary 6 Attachment E - Project Schedule Attachment E - Project Schedule ID 1 2 3 4 5 6 7 8 9 ^0 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 % Como Task Name Duration Start Finish Resource Names February I Feb 0% Carlsbad CAD VMP (Ver 9) 100% On-site meeting 227 days Thu 3/14/13 Fri 1/24/14 1 day Fri 3/15/13 Fri 3/15/13 Billstone,Clark,Rutan,[ 0% Project Schedule 47 days Mon 3/18/13 Tue 5/21/13 0% Create schedule 5 days Mon 3/18/13 Fri 3/22/13 Billstone 0% Carlsbad and Tiburon review schedule 3 days Mon 3/25/13 Wed 3/27/13 Billstone.Callander 0% Adjustments made to scheudle 7 days Thu 3/28/13 Fri 4/5/13 Billstone 0% Carlsbad approves schedule 1 day Mon 4/8/13 Mon 4/8/13 Callander 0% Steering committee meeting 2 days Tue4/9/13 Wed 4/10/13 Carisbad 0% Write ammendment to agreement 5 days Mon 4/1/13 Fri 4/5/13 Carisbad 0% Carlsbad delivers agreement toTiburon 1 day Fri 4/12/13 Fri 4/12/13 Carisbad 0% Tiburon signs agreement and retruns to City 1 day Tue 4/16/13 Tue 4/16/13 Tiburon 0% Obtain council approval to proceed 1 day Tue 5/14/13 Tue 5/14/13 Carisbad 0% Purchase Stratus FT server 5 days Wed 5/15/13 Tue 5/21/13 Carisbad 0% Purchase VMWare licensing (vCenter) 1 day Wed 5/15/13 Wed 5/15/13 Carisbad 0% Call to discuss move from Hyper-V to VMWare 5.5 days Thu 3/14/13 Thu 3/21/13 (hardware/applications/interfaces) 100% Initial call 100% Followupcall 0% Hardware - Hyper-V Migration to VMWare 0% Build VMWare enviomment 0% Move Hyper-V servers to VMWare 0% Provide VPN Access to Servers 0% Sen/er review 0% Install new patches and updates 0%> Test applications on VM servers 0% Test databases on VM servers 0% Test interfaces on VM servers 0% Integration testing 0% Test workstations 0% Redeploy backup solution 0% Test CAD 0% Identify TSR's 0% Resolve TSR's 0% Retest of TSR fixes 0% Hardware - Stratus CAD Server 0% stage physical server 0% Server review 0% Deploy CAD 0% Test CAD 0.25 days 0.25 days 53 days 5 days 5 days 1 day 1 day 5 days 5 days 5 days 5 days 5 days 3 days 1 day 5 days 5 days 20 days 2 days 8 days 3 days 1 day 2 days 2 days Thu 3/14/13 Thu 3/14/13 Carisbad,Tiburon Thu 3/21/13 Thu 3/21/13 Mon 4/1/13 Mon 4/1/13 Mon 4/1/13 Thu 4/4/13 Mon 4/22/13 Mon 4/22/13 Mon 4/22/13 Mon 4/22/13 Mon 4/22/13 Mon 4/22/13 Mon 4/29/13 Mon 4/29/13 Tue 4/30/13 Tue 5/7/13 Tue 5/14/13 Tue 6/11/13 Wed 6/19/13 Wed 6/19/13 Mon 6/24/13 Tue 6/25/13 Thu 6/27/13 Wed 6/12/13 Fri 4/5/13 Fri 4/5/13 Thu 4/4/13 Mon 4/22/13 Fri 4/26/13 Fri 4/26/13 Fri 4/26/13 Fri 4/26/13 Fri 4/26/13 Wed 5/1/13 Mon 4/29/13 Mon 5/6/13 Mon 5/13/13 Mon 6/10/13 Wed 6/12/13 Carisbad Carisbad Carisbad Tiburon SSG Tiburon Deployment Tiburon Deployment Tiburon Deployment Tiburon Deployment Tiburon Deployment Carisbad Carisbad Carisbad Carisbad Tiburon Carisbad Fri 6/28/13 Fri 6/21/13 Carisbad Mon 6/24/13 SSG Wed 6/26/13 Tiburon Deployment Fri 6/28/13 Carisbad Project: Project schedule version 9 Date: Thu 4/25/13 Task Split Milestone Summary Project Summary Extemal Tasks Extemal Milestone Inactive Task Inactive Milestone • Inactive Summary Manual Task Duration-only Manual Summary Rollup mm Manual Summary start-only C Finish-only • Progress " Deadline Page 1 n Attachment E - Project Schedule ID % Task Name o Como 44 45 0% State Interface 46 0% CLETS MQ Install and testing 47 48 0% Training Room Setup 49 f 0% Order computers 50 f 0% Setup training room 51 52 0% Training 53 0% LVS 54 • 1 0% Provide new maps to Tiburon 55 1 0% Verify LVS access from training room 56 0% LVS training 57 M 0% Reimport maps 58 m~ f 0% Develop mobile map 59 1 0% Refine Mobile Map 60 i 0% Field testing Mobile Map 61 62 0% Cutover Plan 63 0% Tiburon delivers cutover plan 64 65 0% Tiburon Training 66 f 0% Deliver Training Plans 67 SB 0% Reformatter 68 0% File Maintenance 69 £ 0% Dispatcher 70 0% Mobile 71 0% Identify TSR's during refresher training 72 f 0% Resolve TSR's 73 74 0% Testing 75 f 0% Testing VMWare implementatiion 76 • f 0% Test Interface Integration 77 IS 0% Develop test plan for critical use cases 78 • " 0% Test critical use cases 79 • " 0% Develop test plan for dispatch unit new functioality 80 i 0% Test dispatch unit new functionality M' 0% Develop test plan for critical prior functioality 82 0% Test dipatch critical prior functionality 83 M 0% Develop test plan for mobile new functionality 84 f 0% Test mobile unit new functionality 85 Pi ' 0% Develop test plan for mobile critical prior functionality Duration ' Start Finish Resource Names 10 days Wed 5/1/13 Tue 5/14/13 10 days Wed 5/1/13 Tue 5/14/13 Tiburon.Carisbad 16 days Thu 7/4/13 Fri 7/26/13 5 days Thu 7/4/13 Thu 7/11/13 Carisbad jFebman i Feb 10 days Fri 7/12/13 Fri 7/26/13 Carisbad 42 days Mon 6/10/13 Tue 8/6/13 42 days Mon 6/10/13 Tue 8/6/13 1 day Mon 6/10/13 Tue 6/11/13 Carisbad 1 day Wed 6/19/13 Thu 6/20/13 Carisbad 31 days Tue 6/25/13 Tue 8/6/13 1 day Tue 6/25/13 Tue 6/25/13 Tiburon.Carisbad 1 day Wed 6/26/13 Wed 6/26/13 Tiburon.Carisbad 30 days Wed 6/26/13 Tue 8/6/13 Carisbad 30 days Wed 6/26/13 Tue 8/6/13 Carisbad 196 days Thu 3/14/13 Thu 12/12/13 1 day Thu 7/25/13 Fri 7/26/13 Billstone 26 days Fri 8/2/13 Fri 9/6/13 1 day Fri 8/2/13 Mon 8/5/13 Tiburon 1 day Mon 8/19/13 Mon 8/19/13 Tiburon.Carisbad 1 day Tue 8/20/13 Tue 8/20/13 Tiburon.Carisbad 1 day Wed 8/21/13 Wed 8/21/13 Tiburon.Carisbad 2 days Thu 8/22/13 Fri 8/23/13 Tiburon.Carisbad 5 days Mon 8/19/13 Fri 8/23/13 Tiburon.Carisbad 15 days Mon 8/19/13 Fri 9/6/13 Tiburon 196 days Thu 3/14/13 Thu 12/12/13 5 days Mon 4/22/13 Fri 4/26/13 Tiburon 5 days Wed 5/15/13 Tue 5/21/13 Tiburon.Carisbad 101 days Mon 4/15/13 Mon 9/2/13 Carisbad 85 days Tue 5/7/13 Mon 9/2/13 Carisbad 101 days Mon 4/15/13 Mon 9/2/13 Carisbad 85 days Tue 5/7/13 Mon 9/2/13 Carisbad 101 days Mon 4/15/13 Mon 9/2/13 Carisbad 85 days Tue 5/7/13 Mon 9/2/13 Carisbad 101 days Mon 4/15/13 Mon 9/2/13 Carisbad 85 days Tue 5/7/13 Mon 9/2/13 Carisbad 101 days Mon 4/15/13 Mon 9/2/13 Carisbad Project: Project schedule version 9 Date: Thu 4/25/13 Task Split Milestone Summary Project Summary Extemal Tasks Extemal Milestone Inactive Task Inactive Milestone Inactive Summary Manual Task Duration-only Manual Summary Rollup Manual Summary Start-only Finish-only Progress Deadline Page 2 Attachment E - Project Schedule ID % I Como Task Name Duration Start Finish I Resource Names 86 f 0% Test moibll unit critical prior functioality 85 days tue 5/7/13 Mon 9/2/13 Carisbad 87 : 0% Develop Data Warehouse conversion test plan 5 days Thu 7/4/13 Thu 7/11/13 Carisbad 88 i 0% Test Data Warehouse data conversion 5 days Fri 7/19/13 Thu 7/25/13 Carisbad CD OOi O CD 0% 0% Develop CAD histories data conversion test plan Test initial CAD histories data conversion 5 days 3 days Thu 3/14/13 Thu 3/14/13 Wed 3/20/13 Carisbad Mon 3/18/13 Carisbad 91 \ 0% Test periodic CAD history data conversion 3 days Thu 3/14/13 Mon 3/18/13 Carisbad 92 i i 0% Test final CAD histories data conversion 3 days Wed 12/4/13 Fri 12/6/13 Carisbad 93 i i 0% Final test of Data Conversion after cutover 1 day Fri 12/6/13 Fri 12/6/13 Carisbad 94 95 96 : f 0% Tiburon testing assistance 167 days Mon 4/15/13 Tue 12/3/13 Tiburon 94 95 96 : 0% Quality Gate 1 day Fri 8/30/13 Mon 9/2/13 97 : • 1 0% Verify all functionality wori^ing appropriately 1 day Fri 8/30/13 Mon 9/2/13 Carisbad CD CD CD 00 0% Mobiles 159 days Mon 5/6/13 Thu 12/12/13 100 : f 0% Build mobile config 10 days Thu 8/22/13 Wed 9/4/13 Carisbad 101 ; • 1 0% Mobile unit testing of new functionality 10 days Thu 9/5/13 Wed 9/18/13 Carisbad \ 102 ' 103 • 1 0% 0% Mobiel unit testing of critical prior functioality Order and receive additional RAM 10 days 10 days Thu 9/5/13 Mon 5/6/13 Wed 9/18/13 Carisbad Fri 5/17/13 Carisbad 104 • * f 0% Install additional RAM in mobiles 15 days Mon 5/20/13 Fri 6/7/13 Carisbad 105 \ i 0% Install Mobile App 5 days Fri 12/6/13 Thu 12/12/13 Carisbad 106 107 : 108 f 0% Deploy mobile map 5 days Fri 12/6/13 Thu 12/12/13 Cartsbad 106 107 : 108 0% CAD Workstation 100 days Mon 9/9/13 Fri 1/24/14 109 I • f 0% Check Windows7 images on wori^stations 5 days Mon 11/4/13 Mon 11/11/13 Carisbad 110 111 112 0% Reimage all wori^stations 5 days Mon 1/20/14 Fri 1/24/14 110 111 112 0% Carlsbad Training 30 days Mon 9/9/13 Fri 10/18/13 113 m 0% Develop lesson plans 5 days Mon 9/9/13 Fri 9/13/13 Carisbad 114 0% Dispatcher training 10 days Mon 9/16/13 Fri 9/27/13 Carisbad 115 £ 0% Officer training - Mobiles 22 days Mon 9/16/13 Tue 10/15/13 Carisbad 116 0% TSR's identified during training 22 days Mon 9/16/13 Tue 10/15/13 Carisbad 117 118 ' 119 f 0% Resolve TSR's 25 days Mon 9/16/13 Fri 10/18/13 Tiburon 117 118 ' 119 0% Data File Conversion 183 days Wed 3/27/13 Fri 12/6/13 120 0% Data Warehouse Conversion 110 days Mon 7/8/13 Fri 12/6/13 121 f 0% Develop data conversion testing plan 3 days Mon 7/8/13 Thu 7/11/13 Tiburon.Carisbad 122 0% CAD/DataWarehouse conversion 1 day Thu 7/18/13 Fri 7/19/13 Tiburon Deployment 123 f 0% Testing/Validation 1 day Fri 7/19/13 Fri 7/19/13 Carisbad 124 0% Tum on CARS/Data Warehouse - after cutover 1 day Fri 12/6/13 Fri 12/6/13 Tiburon Februan Feb Project: Project schedule version 9 Date: Thu 4/25/13 Task Split Milestone Summary Project Summary Extemal Tasks Extemal Milestone Inactive Task Inactive Milestone Inactive Summary Manual Task Duration-only Manual Summary Rollup Manual Summary Start-only Finish-only Progress Deadline Page 3 n Attachment E - Project Schedule ID : % ! Como 125 0% 126 0% 127 0% 128 • f 0% 129 f 0% 130 • 1 0% 131 0% 132 f 0% 133 • 1 0% 134 f 0% 135 • 1 0% 136 137 0% 138 139 0% 140 i 0% 141 0% 142 ' 0% 143 144 0% 145 146 0% 147 148 0% 149 150 • 0% [Task Name FM Conversion Send list of tables needing a compare Tiburon run compare Review compare Manual entry of data Any changes made in 2.3 FM need to be made in 2.8 FM CAD Histories Conversion Develop data conversion testing plan Test CAD History data conversion Final CAD History conversion Test Final CAD Histories data conversion 0% Readyness Gate Freeze system Freeze map Tiburon PM. SSG. GIS. Deployment & Trainning support Duration I 180 days 8 days 5 days 5 days 85 days Start I Wed 3/27/13 Wed 3/27/13 Mon 4/8/13 Mon 4/15/13 Mon 4/22/13 Finish Resource Names Tue 12/3/13 Fri 4/5/13 Carisbad Fri 4/12/13 Tiburon Fri 4/19/13 Carisbad Fri 8/16/13 Carisbad February Feb 162 days Mon 4/22/13 Tue 12/3/13 Carisbad 88 days Mon 8/5/13 Wed 12/4/13 1 day Mon 8/5/13 Mon 8/5/13 Carisbad.Tiburon 1 day Tue 8/20/13 Tue 8/20/13 Carisbad 1 day Tue 12/3/13 Tue 12/3/13 Tiburon 1 day Wed 12/4/13 Wed 12/4/13 Carisbad 1 day Mon 11/18/13 Mon 11/18/13 Carisbad 10 days Frill/22/13 Thu 12/5/13 1 day Fri 11/22/13 Fri 11/22/13 Tiburon.Carisbad 1 day Frill/22/13 Fri 11/22/13 Tiburon.Carisbad 3 days Tue 12/3/13 Thu 12/5/13 Tiburon.Carisbad 1 day Mon 12/9/13 Mon 12/9/13 Cartsbad 1 day Mon 12/9/13 Mon 12/9/13 Carisbad 1 day Fri 12/6/13 Fri 12/6/13 Carisbad 1 day Fri 12/6/13 Fri 12/6/13 Carisbad Project: Project schedule version 9 Date: Thu 4/25/13 Task Split Milestone Summary Project Summary Extemal Tasks Extemal Milestone Inactive Task Inactive Milestone • Inactive Summary Manual Task Duration-only Manual Summary Rollup Manual Summary Start-only Finish-only Progress Deadline Page 4 John Coates From: Sent: To: Subject: HI John, Greg Hermann Tuesday, May 14, 2013 2:36 PM John Coates Follow Up from Council Briefing AH Receive - Agenda Item # / ^ 0. For the Information of the- ' CITY COUNCIL ACM \/^ CA v£ CC i/'" Date ^ City Managerlg^^ Below please find the follow Information requested during Council briefing: t" 'S::^^:^ S« nt with .^uron for issues and covers all of the ^^"Z^:^^^^ - all support and maintenance the police vehicles. components of the CAD system in the communications center and In upgrade old hardware. """"^ Department of Justice security policies and .as manv ...a, and p.vs.a, ^^J^Z:^^:^::::^ ZSlr'"'"'^'^^ secure cloud in the future. However t^ese tleTlf rhi^^^^^ """""^ enforcement servers into a extensive review and approvar Du \o DoVsecurS r«t^^^^^^ H' '° police servers that cental confidential ^!^:::2:X2:Z:::::2::::^' Please let me know if you have any questions. Greg Date: S/lWf^ DMributi6m' City Clerk Asst. City Clerk Deputy Clerk _ Book