Loading...
HomeMy WebLinkAboutAgenda Report - June 1, 2016 C-13CITY OF LODI COUNCIL COMMUNICATION AGENDA ITEM C-13 AGENDA TITLE: Adopt Resolution Awarding Three -Year Professional Services Agreement for Electronic Content Management System, Software Support, and Implementation Services using Laserfiche Software to Complete Paperless Solutions, of Anaheim ($30,114 / Annual Maintenance of $4,560), Authorizing the City Clerk to Execute Two One -Year Extensions, and Appropriating Funds (CLK) MEETING DATE: PREPARED BY: June 1, 2016 City Clerk RECOMMENDED ACTION: Adopt resolution awarding a three-year Professional Services Agreement for Electronic Content Management System, Software Support, and Implementation Services using Laserfiche Software to Complete Paperless Solutions, of Anaheim, in the amount of $30,114 (implementation cost) and annual maintenance of $4,560, authorizing the City Clerk to execute two one-year extensions, and appropriating funds. BACKGROUND INFORMATION: Since the early 2000s, Lodi has managed an in-house electronic content management system, known commonly as e -Records, which provides staff and public access to records such as minutes, resolutions, ordinances, Council Communications, campaign statements, and budgets. Over the last two years, the system has been steadily failing: users are often unable to access the system; only partial search results are returned; and staff is unable to enter current data because many of the features, such as indexing and optical character recognition searches, no longer function properly. At the 2015 City Council goal -setting session, the e -Records replacement project was listed as a priority goal of the City Clerk's Office. A Request for Information was posted on the City website and approximately 38 vendors were directly notified of the posting. Proposals were received from the following five firms: Vendor Name Product ECS Imaging, Inc. Laserfiche Complete Paperless Solutions (CPS) Laserfiche Hines EDM Contentverse NEKO Industries OnBase WAVE Technology Solutions Group EMC & Lexmark A selection committee composed of four City staff independently evaluated the proposals based upon the following criteria: qualifications and experience of the firm; financial stability and price; and technical resources, work plan, and training programs. While price was not the sole determining factor, implementation costs ranged from a high of $133,000 to a low of $23,000*, with most quoting 20 percent of the software cost for the annual maintenance fee. *Proposals vaned on the number of concurrent licensing packages, which could cause a final cost to increase or decrease based on staff's desired licensing needs. APPROVED: ephen abauer, City Manager Adopt Resolution Awarding Three -Year Professional Services Agreement for Electronic Content Management System, Software Support, and Implementation Services using Laserfiche Software to Complete Paperless Solutions, of Anaheim ($30,114 /Annual Maintenance of $4, 560), Authorizing the City Clerk to Execute 2 One -Year Extensions, and Appropriating Funds (CLK) June 1, 2016 Page Two In addition to independent evaluations, the top two vendors provided on-site demonstrations to approximately 10 staff members representing the City Clerk's Office, Information Technology Services, and a variety of departments, many of whom are frequent users of the current e -Records system. Final price quotes were requested of both vendors, based on discussions and outcome of the demonstrations, in order to compare similar proposals. Staff recommends awarding a Professional Services Agreement to Complete Paperless Solutions for a three-year contract and the ability to execute two one-year extensions. The Agreement will provide four named user licenses (three for the Clerk's Office and one for Information Technology) and 10 concurrent licenses for staff and public, as well as system set up and data migration, built-in records retention and destruction notification, workflow and form creation capabilities, training, and support services. Initial cost to implement the program is $30,114, with an ongoing annual maintenance fee of 20 percent of the software cost ($4,560). FISCAL IMPACT: System implementation is $30,114 with annual maintenance at 20 percent of software cost, $4,560. Total cost over five years is $48,354. FUNDING AVAILABLE JMF/pf Attachments Funding for implementation is in the City Clerk's budget (10005000) for Fiscal Year 2015/16 and will be transferred to the Equipment Replacement Fund by the attached Appropriation Request. Future annual maintenance will be included in the City Clerk's budget. Jordan Ayers, Deputy City Manage ► Jennifer M. Ferraiolo City Clerk AGREEMENT FOR PROFESSIONAL SERVICES ARTICLE 1 PARTIES AND PURPOSE Section 1.1 Parties THIS AGREEMENT is entered into on , 2016, by and between the CITY OF LODI, a municipal corporation (hereinafter "CITY"), and COMPLETE PAPERLESS SOLUTIONS, LLC, a California Limited Liability Corporation, (CPS) (hereinafter "CONTRACTOR"). Section 1.2 Purpose CITY selected the CONTRACTOR to provide the services required in accordance with attached Scope of Services, Exhibit A, attached and incorporated by this reference. CITY wishes to enter into an agreement with CONTRACTOR for Electronic Content Management System, Software Support, and Implementation Services using Laserfiche Software (hereinafter "Project") as set forth in the Scope of Services attached here as Exhibit A. CONTRACTOR acknowledges that it is qualified to provide such services to CITY. ARTICLE 2 SCOPE OF SERVICES Section 2.1 Scope of Services CONTRACTOR, for the benefit and at the direction of CITY, shall perform the Scope of Services as set forth in Exhibit A. Section 2.2 Time For Commencement and Completion of Work CONTRACTOR shall commence work pursuant to this Agreement, upon receipt of a written notice to proceed from CITY or on the date set forth in Section 2.6, whichever occurs first, and shall perform all services diligently and complete work under this Agreement based on a mutually agreed upon timeline or as otherwise designated in the Scope of Services. CONTRACTOR shall submit to CITY such reports, diagrams, drawings and other work products as may be designated in the Scope of Services. CONTRACTOR shall not be responsible for delays caused by the failure of CITY staff to provide required data or review documents within the appropriate time frames. The review time by CITY and any other agencies involved in the project shall not be 1 counted against CONTRACTOR's contract performance period. Also, any delays due to weather, vandalism, acts of God, etc., shall not be counted. CONTRACTOR shall remain in contact with reviewing agencies and make all efforts to review and return all comments. Section 2.3 Meetings CONTRACTOR shall attend meetings as may be set forth in the Scope of Services. Section 2.4 Staffing CONTRACTOR acknowledges that CITY has relied on CONTRACTOR's capabilities and on the qualifications of CONTRACTOR's principals and staff as identified in its proposal to CITY. The Scope of Services shall be performed by CONTRACTOR, unless agreed to otherwise by CITY in writing. CITY shall be notified by CONTRACTOR of any change of Project Manager and CITY is granted the right of approval of all original, additional and replacement personnel at CITY's sole discretion and shall be notified by CONTRACTOR of any changes of CONTRACTOR's project staff prior to any change. CONTRACTOR represents it is prepared to and can perform all services within the Scope of Services (Exhibit A) and is prepared to and can perform all services specified therein. CONTRACTOR represents that it has, or will have at the time this Agreement is executed, all licenses, permits, qualifications, insurance and approvals of whatsoever nature are legally required for CONTRACTOR to practice its profession, and that CONTRACTOR shall, at its own cost and expense, keep in effect during the life of this Agreement all such licenses, permits, qualifications, insurance and approvals, and shall indemnify, defend and hold harmless CITY against any costs associated with such licenses, permits, qualifications, insurance and approvals which may be imposed against CITY under this Agreement. Section 2.5 Subcontracts Unless prior written approval of CITY is obtained, CONTRACTOR shall not enter into any subcontract with any other party for purposes of providing any work or services covered by this Agreement. Section 2.6 Term The term of this Agreement commences on June 15, 2016 and terminates upon the completion of the Scope of Services or on June 30, 2019, whichever occurs first. Section 2.7 Option to Extend Term of Agreement At its option, City may extend the terms of this Agreement for an additional two (2) one (1)-year extensions; provided, City gives Contractor no less than thirty (30) days 2 written notice of its intent prior to expiration of the existing term. In the event City exercises any option under this paragraph, all other terms and conditions of this Agreement continue and remain in full force and effect. The total duration of this Agreement, including the exercise of any option under this paragraph, shall not exceed five (5) years. ARTICLE 3 COMPENSATION Section 3.1 Compensation CONTRACTOR's compensation for all work under this Agreement shall conform to the provisions of the Fee Proposal, attached hereto as Exhibit B and incorporated by this reference. CONTRACTOR shall not undertake any work beyond the scope of this Agreement unless such additional work is approved in advance and in writing by CITY. Section 3.2 Method of Payment CONTRACTOR shall submit invoices for completed work on a monthly basis, or as otherwise agreed, providing, without limitation, details as to amount of hours, individual performing said work, hourly rate, and indicating to what aspect of the Scope of Services said work is attributable. CONTRACTOR's compensation for all work under this Agreement shall not exceed the amount of the Fee Proposal. Section 3.3 Costs The Fee Proposal shall include all reimbursable costs required for the performance of the Scope of Services. Payment of additional reimbursable costs considered to be over and above those inherent in the original Scope of Services shall be approved in advanced and in writing, by CITY. Section 3.4 Auditing CITY reserves the right to periodically audit all charges made by CONTRACTOR to CITY for services under this Agreement. Upon request, CONTRACTOR agrees to furnish CITY, or a designated representative, with necessary information and assistance needed to conduct such an audit. CONTRACTOR agrees that CITY or its delegate will have the right to review, obtain and copy all records pertaining to performance of this Agreement. CONTRACTOR agrees to provide CITY or its delegate with any relevant information requested and shall permit CITY or its delegate access to its premises, upon reasonable notice, during normal business hours for the purpose of interviewing employees and 3 inspecting and copying such books, records, accounts, and other material that may be relevant to a matter under investigation for the purpose of determining compliance with this requirement. CONTRACTOR further agrees to maintain such records for a period of three (3) years after final payment under this Agreement. ARTICLE 4 MISCELLANEOUS PROVISIONS Section 4.1 Nondiscrimination In performing services under this Agreement, CONTRACTOR shall not discriminate in the employment of its employees or in the engagement of any sub CONTRACTOR on the basis of race, color, religion, sex, sexual orientation, marital status, national origin, ancestry, age, or any other criteria prohibited by law. Section 4.2 ADA Compliance In performing services under this Agreement, CONTRACTOR shall comply with the Americans with Disabilities Act (ADA) of 1990, and all amendments thereto, as well as all applicable regulations and guidelines issued pursuant to the ADA. Section 4.3 indemnification and Responsibility for Damage CONTRACTOR to the fullest extent permitted by law, shall indemnify and hold harmless CITY, its elected and appointed officials, directors, officers, employees and volunteers from and against any claims, damages, losses, and expenses (including reasonable attorney's fees and costs), arising out of performance of the services to be performed under this Agreement, provided that any such claim, damage, loss, or expense is caused by the negligent acts, errors or omissions of CONTRACTOR, any subcontractor employed directly by CONTRACTOR, anyone directly or indirectly employed by any of them, or anyone for whose acts they may be liable, except those injuries or damages arising out of the active negligence, sole negligence, or sole willful misconduct of the City of Lodi, its elected and appointed officials, directors, officers, employees and volunteers. CITY may, at its election, conduct the defense or participate in the defense of any claim related in any way to this indemnification. If CITY chooses at its own election to conduct its own defense, participate in its own defense, or obtain independent legal counsel in defense of any claim related to this indemnification, CONTRACTOR shall pay all of the costs related thereto, including without limitation reasonable attorney fees and costs. The defense and indemnification obligations required by this Agreement are undertaken in addition to, and shall not in any way be limited by the insurance obligations set forth herein. 4 Section 4.4 No Personal Liability Neither the City Council, nor any other officer or authorized assistant or agent or City employee shall be personally responsible for any liability arising under this Agreement. Section 4.5 Responsibility of CITY CITY shall not be held responsible for the care or protection of any material or parts of the work described in the Scope of Services prior to final acceptance by CITY, except as expressly provided herein. Section 4.6 Insurance Requirements for CONTRACTOR CONTRACTOR shall take out and maintain during the life of this Agreement, insurance coverage as set forth in Exhibit C attached hereto and incorporated by this reference. Section 4.7 Successors and Assigns CITY and CONTRACTOR each bind themselves, their partners, successors, assigns, and legal representatives to this Agreement without the written consent of the others. CONTRACTOR shall not assign or transfer any interest in this Agreement without the prior written consent of CITY. Consent to any such transfer shall be at the sole discretion of CITY. Section 4.8 Notices Any notice required to be given by the terms of this Agreement shall be in writing signed by an authorized representative of the sender and shall be deemed to have been given when the same is personally served or upon receipt by express or overnight delivery, postage prepaid, or three (3) days from the time of mailing if sent by first class or certified mail, postage prepaid, addressed to the respective parties as follows: To CITY: To CONTRACTOR: City of Lodi 221 West Pine Street P.O. Box 3006 Lodi, CA 95241-1910 Attn: Jennifer M. Ferraiolo, City Clerk Complete Paperless Solutions 4025 E. La Palma Avenue, Suite 204 Anaheim, CA 92807 Attn: Claude Schott, Vice President of Sales Section 4.9 Cooperation of CITY CITY shall cooperate fully and in a timely manner in providing relevant information it has at its disposal relevant to the Scope of Services. 5 Section 4.10 CONTRACTOR is Not an Employee of CITY CONTRACTOR agrees that in undertaking the duties to be performed under this Agreement, it shall act as an independent contractor for and on behalf of CITY and not an employee of CITY. CITY shall not direct the work and means for accomplishment of the services and work to be performed hereunder. CITY, however, retains the right to require that work performed by CONTRACTOR meet specific standards without regard to the manner and means of accomplishment thereof. Section 4.11 Termination CITY may terminate this Agreement, with or without cause, by giving CONTRACTOR at least ten (10) days written notice. Where phases are anticipated within the Scope of Services, at which an intermediate decision is required concerning whether to proceed further, CITY may terminate at the conclusion of any such phase. Upon termination, CONTRACTOR shall be entitled to payment as set forth in the attached Exhibit B to the extent that the work has been performed. Upon termination, CONTRACTOR shall immediately suspend all work on the Project and deliver any documents or work in progress to CITY. However, CITY shall assume no liability for costs, expenses or lost profits resulting from services not completed or for contracts entered into by CONTRACTOR with third parties in reliance upon this Agreement. Section 4.12 Confidentiality CONTRACTOR agrees to maintain confidentiality of all work and work products produced under this Agreement, except to the extent otherwise required by law or permitted in writing by CITY. CITY agrees to maintain confidentiality of any documents owned by CONTRACTOR and clearly marked by CONTRACTOR as "Confidential" or "Proprietary", except to the extent otherwise required by law or permitted in writing by CONTRACTOR. CONTRACTOR acknowledges that CITY is subject to the California Public Records Act. Section 4.13 Applicable Law, Jurisdiction, Severability, and Attorney's Fees This Agreement shall be governed by the laws of the State of California. Jurisdiction of litigation arising from this Agreement shall be venued with the San Joaquin County Superior Court. If any part of this Agreement is found to conflict with applicable laws, such part shall be inoperative, null, and void insofar as it is in conflict with said laws, but the remainder of this Agreement shall be in force and effect. In the event any dispute between the parties arises under or regarding this Agreement, the prevailing party in any litigation of the dispute shall be entitled to reasonable attorney's fees from the party who does not prevail as determined by the San Joaquin County Superior Court. 6 Section 4.14 City Business License Requirement CONTRACTOR acknowledges that Lodi Municipal Code Section 3.01.020 requires CONTRACTOR to have a city business license and CONTRACTOR agrees to secure such license and pay the appropriate fees prior to performing any work hereunder. Section 4.15 Captions The captions of the sections and subsections of this Agreement are for convenience only and shall not be deemed to be relevant in resolving any question or interpretation or intent hereunder. Section 4.16 Integration and Modification This Agreement represents the entire understanding of CITY and CONTRACTOR as to those matters contained herein. No prior oral or written understanding shall be of any force or effect with respect to those matters covered hereunder. This Agreement may not be modified or altered except in writing, signed by both parties. Section 4.17 Contract Terms Prevail All exhibits and this Agreement are intended to be construed as a single document. Should any inconsistency occur between the specific terms of this Agreement and the attached exhibits, the terms of this Agreement shall prevail. Section 4.18 Severability The invalidity in whole or in part of any provision of this Agreement shall not void or affect the validity of any other provision of this Agreement. Section 4.19 Ownership of Documents All documents, photographs, reports, analyses, audits, computer media, or other material documents or data, and working papers, whether or not in final form, which have been obtained or prepared under this Agreement, shall be deemed the property of CITY. Upon CITY's request, CONTRACTOR shall allow CITY to inspect all such documents during CONTRACTOR's regular business hours. Upon termination or completion of services under this Agreement, all information collected, work product and documents shall be delivered by CONTRACTOR to CITY within ten (10) calendar days. CITY agrees to indemnify, defend and hold CONTRACTOR harmless from any liability resulting from CITY's use of such documents for any purpose other than the purpose for which they were intended. Section 4.20 Authority The undersigned hereby represent and warrant that they are authorized by the parties to execute this Agreement. 7 Section 4.21 Federal Transit Funding Conditions ❑ If the box at left is checked, the Federal Transit Funding conditions attached as Exhibit D apply to this Agreement. In the event of a conflict between the terms of this Agreement or any of its other exhibits, and the Federal Transit Funding Conditions, the Federal Transit Funding Conditions will control. IN WITNESS WHEREOF, CITY and CONTRACTOR have executed this Agreement as of the date first above written. ATTEST: CITY OF LODI, a municipal corporation JENNIFER M. FERRAIOLO STEPHEN SCHWABAUER City Clerk City Manager APPROVED AS TO FORM: COMPLETE PAPERLESS SOLUTIONS, LLC JANICE D. MAGDICH, City Attorney By: By: Name: CLAUDE SCHOTT Title: Vice President of Sales Attachments: Exhibit A — Scope of Services Exhibit B — Fee Proposal Exhibit C — Insurance Requirements Exhibit D — Federal Transit Funding Conditions (if applicable) Funding Source: Doc ID: CA:Rev.01.2015 (Business Unit & Account No.) 8 ELYjiiPir Al City of Lodi — Laserfiche Installation, Training, and Conversion Statement of Work — SOW10026 cpsI Complete Paperless Solutions Version 1.0.0 Table of Contents Purpose 3 Abbreviations and Naming Conventions 3 Objective 3 Deliverables 3 Definition of Tasks 4 Requirements Descriptions 4 SOW10026-0: Project Management/Planning 4 SOW10026-1: Laserfiche Server Installation 5 SOW10026-2: Laserfiche Workflow Installation 5 SOW10026-3: Laserfiche Public Portal Installation 5 SOW10026-4: Laserfiche Audit Trail Installation 6 SOW10026-5: Laserfiche Workstation Installation 6 SOW10026-6: Laserfiche Training 6 SOW10026-7: Web Portal Conversion 7 Assumptions 8 Risk Assessment 8 Initial Risk Assessment 8 Project Management Approach 9 Project Roles and Responsibilities 9 Issue Management 9 Approvals 11 Signoffs 11 PURPOSE This document serves as a statement of work for a Laserfiche Installation and eRecords migration to Laserfiche. The statement of work will cover the following: Objective Scope Assumptions Constraints — Project Management Approach ABBREVIATIONS AND NAMING CONVENTIONS There are abbreviations throughout this document that may be new to the audience. Here is a breakdown of the abbreviations: • CPS = Complete Paperless Solutions (Vendor) • LF = Laserfiche • SQL = Microsoft SQL Server • L = Low risk level • M = Medium risk level • H = High risk level OBJECTIVE The objective is to successfully install and implement the Laserfiche System and perform a complete conversion from eRecords. DELIVERABLES The Laserfiche installation comprises of a series of application installations and training. This document serves as a statement of work for the deliverables of this project. The deliverables of this project are: • Project Management/Planning • Laserfiche Server Installation • Laserfiche Workflow Installation • Laserfiche Web Access Installation • Laserfiche Audit Trail Installation • Laserfiche Basic End User Training • Laserfiche Basic Administration Training • Laserfiche Basic Workflow Training Definition of Tasks This section describes each and identifies them for future references. iiiimiii_ imummirriprrr -7,717. SOW10026-0 Project Management/Planning Project planning methodology 8 hours 1 SOW10026-1 Laserfiche Server Installation Laserfiche Server Installation and repository creation 1 Hour 2 SOW10026-2 Laserfiche Workflow Installation Laserfiche Workflow Installation and Setup 1 Hour 3 SOW10026-3 Laserfiche Public Portal Installation Laserfiche Web Installation of Public Portal 1 Hour 5 SOW10026-4 Laserfiche Audit Trail Installation Laserfiche Audit Trail Installation and Setup 0.5 Hour 4 SOW1002f Laserfiche Workstation Installations Laserfiche thick client workstation installations 4 Hours 6 SOW10026-6 Laserfiche Training 4 Levels of Laserfiche Training 8 Hours 8 SOW10026-7 Web Portal Conversion to Laserfiche Web portal documents conversion to Laserfiche. 16 Hours 7 Requirements Descriptions SOW10026-0: Project Management/Planning The formal work plan will serve as the master schedule by which progress will be measured. The work plan will track all project -related activities and generate scheduled and ad hoc progress reports. No work on the project will begin until we have developed the work plan that both parties agree upon. The work plan will include the following: • Requirements Gathering • Implementation Plan Sign offs • Hardware Requirement Sign offs • Server Software Requirement Sign offs • Conversion Requirements Gathering Laserfiche insrailatlori a n a o n • Conversion Sign offs • Installation • Installation Sign offs • Training Schedule Sign offs • Training • Training Sign offs SOW10026-1: Laserfiche Server Installation Laserfiche Server is the heart of the Laserfiche system. All modules and Laserfiche software connect to the Laserfiche server to obtain licensing, authentication, and content. Laserfiche Server serves as a prerequisite for all other installations. Laserfiche Server handles all requests to obtain content from within the software. Due to the varying applications connected to the Laserfiche Server, certain ports have to be opened to allow proper communication between the calling applications and Laserfiche Server. Ports The ports can be configured if the specified ports are already taken. Port 80 governs all connections to the Laserfiche Server. If port 80 is not a desirable port, it can be replaced with an alternate port 5050. The alternate port is utilized when port 80 goes through a proxy. The Laserfiche Server uses port 5051 for notifications to connecting components. Port 5048 is used to verify the validity of the Laserfiche Server license. The installation will consist of installing the Laserfiche Server, Laserfiche Full Text Server, Laserfiche Client, and Laserfiche Administration Console. SOW10026-2: Laserfiche Workflow Installation Laserfiche Workflow lets you to build repeatable patterns of activity (i.e., workflows and business processes) that interact with entries in a Laserfiche repository, sync with external databases, send notifications, and provides reporting. Each action in a pattern can be completely automated and easily configured. The Workflow Designer, Workflow Subscriber and the Workflow Server will all be installed with the Laserfiche Server. Ports 80 (or 5050), 5051, and 5048 are required to be opened for proper communications between Workflow and the Laserfiche Server. If the email notification functionality of Workflow is required, then an SMTP Server, SMTP Server port, and Authentication will be required to complete the setup of this functionality. Laserfiche Workflow also requires the enabling of Messaging Queue which is a role in the Windows Server. This allows Workflow to queue request provided by the Laserfiche Server. The installation of Workflow can occur on the same machine as the Laserfiche Server. SOW10026-3: Laserfiche Public Portal Installation Laserfiche Public Portal is a user-friendly public portal to Laserfiche. Laserfiche Public Portal publishes documents in a Laserfiche repository to an intranet or the Internet in read-only form. Public Portal can easily be customized: you can customize your site's Theme, Welcome Page, Navigation, Document Viewer, Search Results, and Search Options. It is recommended that the Public Portal installation occur on a different machine from the Laserfiche Server. Since the application will be exposed to the public, it is strongly advised that the application be separated from the Laserfiche Server. SOW10026-4: Laserfiche Audit Trail Installation Laserfiche Advanced Edition meets the needs of organizations in most highly regulated industries. It includes the following functionality of tracking: • Login and logout • Creating, editing, printing or deleting documents • Creating, editing, or deleting templates, fields and annotations • Adding security tags • Exporting documents, volumes or briefcases • Sending documents to the Recycle Bin • Granting or revoking login rights for Windows accounts • Adding or removing users from Laserfiche groups • Modifications to access rights • Modifications to repository -wide The installation consists of creating an Audit Trail database and a setup of the Audit Trail Reporting interface. Audit Trail is a web application and will require Windows IIS 7 enabled as a role on the server in which it is installed. Other roles such as ASP.NET and .NET Framework 3.5 may also require enabling. SOW10026-5: Laserfiche Workstation Installation Laserfiche Client is the Laserfiche UI in which users will be able to create, modify, and remove documents from the repository. The installation consist of the Laserfiche Client (OCR engine included), Laserfiche Snapshot, Email, and Laserfiche Scanning. SOW10026-6: Laserfiche Training Laserfiche has different levels of training. One or more training sessions may be required depending on the role of the users. The goal of the training is to empower the users to be comfortable with the Laserfiche suite of products. Here are summaries of the training to empower the users: Laserfiche Laserfiche training will focus on navigation, search, creation, and modification of content in the Laserfiche repository. Users will learn how to move around the Laserfiche client, be taught time -saving searches, and provided general best -practices. Workflow Laserfiche Workflow training is a beginner's class which will instruct workflow designers how to create basic workflows. The class will specifically focus on taxonomy, data collection, and workflow triggers. This class is intended for Laserfiche Administrators only. Laserfiche training is a prerequisite for this training and should not be taken until Laserfiche training is complete. Administrator Laserfiche Administration focuses on the repository's back end (database), metadata, and security. The training includes the creation of the repository, volume architecture, metadata management, and user security. Public Portal Public Portal training covers the Weblink Designer interface which allows administrators to create customized search forms to provide a better search experience to users who don't necessarily know how to use Laserfiche. SOW10026-7: Web Portal Conversion The conversion of files from eRecords to Laserfiche is required. The conversion is the first step of transitioning to Laserfiche Public Portal. eRecords documents are to be migrated from source Windows and SQL Server locations to the Laserfiche repository. The customer will define the taxonomy of the eRecords documents in Laserfiche. The taxonomy will be limited to the metadata associated to the documents in eRecords. The conversion will assume that all documents in eRecords have a file type of PDF and will be treated as such during the import into Laserfiche. ASSUMPTIONS The following assumptions were made in preparing the Statement of Work: • Change requests made after deliverables will result in project delays and affect the entire timeline of project delivery. • CPS will be provided administrative access to all related servers. • SMTP Email Server is required to create notifications in Laserfiche Workflow. SMTP Email Server will be provided by customer. This will not be provided by CPS. RISK ASSESSMENT The risk assessment attempts to identify, characterize, prioritize and document a mitigation approach relative to those risks which can be identified prior to the start of the project. The risk assessment will be continuously monitored and updated throughout the life of the project. Because mitigation approaches must be agreed upon by project leadership, it is necessary to allocate time into each meeting, dedicated to identifying new risks and discussing mitigation strategies. The Project manager will convey amendments and recommend contingencies as conditions may warrant. Initial Risk Assessment Project Scope Creep Laserfiche Installation and a l L Scope initially defined in project plan, by both client and vendor to prevent undetected project scope creep. Communication becomes very important to prevent this risk from ever developing. 1 PROJECT MANAGEMENT APPROACH Project Roles and Responsibilities Role Responsibility Project Sponsor CPS Project Manager CPS Technician CPS Account Manager • Ultimate decision -maker • Provide project oversight and guidance • Review and approve project elements • Provides overall project direction • Documents all communications and project developments • Handles project scope documentation • Tracks staff's progress for project • Handles problem resolution • Assigns staff to project ■ Installation • Testing and Implementation • Training • Technical Support • Handles all business regarding pricing and purchasing • Contributor in project meetings Issue Management The information contained within the Project Plan will likely change as the project progresses. While change is both certain and required, it is important to note that any changes to the Project Plan will impact at least one of three critical success factors: Available Time, Available Resources (Financial and Personnel) , or Project Quality. The decision by which to make modifications to the Project Plan should be coordinated using the following process: ■ As soon as a change which impacts project scope, schedule, staffing or spending is identified, the CPS Project Manager will document the issue. • The CPS Project Manager will review the change and determine the associated impact to the project and will forward the issue, along with recommendation, to all interested parties for review and discussion. • If required due to lack of consensus, the Project Sponsor shall review the issue(s) and render a final decision on the approval or denial of a change. • Following an approval or denial, the CPS Project Manager will notify the original requestor of the action taken. There is no appeal process. APPROVALS Signoffs Project Sponsor Project Manager Account Manager Signature Date Signature Date Signature Date Pricing Laserfiche So are cps Complete Paperless Solutions EXhIB!T� Software Description Quantity _ Public Price Laserfiche Avante Server (SQL Server), incl. Workflow 1 $5,000.00 Full Named Users, incl. Email, Snapshot, WebAccess, 4 $2,400.00 Mobile, Scanning & OCR Laserfiche Advanced Audit Trail, incl. Watermark 1 $400.00 Laserfiche Public Portal —10 concurrent users 1 $15,000.00 Software Total $22,800.00 Professional Services Service Description Quantity Public Price Laserfiche Introduction 2 $400.00 Laserfiche Installation, incl. Server, 4 Users, Workflow, 5 51,000.00 WebAccess & Audit Trail Laserfiche Taxonomy & Indexing 2 5400.00 Laserfiche set Up 2 $400.00 Laserfiche Public Portal & Design 4 $400.00 Laserfiche End User Training (2 groups) 4 $400.00 Admin Training 3 $600.00 Conversion 1 $2,500.00 Professional Services Total $6,100.00 Laserfiche SoFt',are Support (LSAP) Support Description Quantity Price Laserfiche Avante 1 $1,000.00 Laserfiche Named Users 4 $480.00 Laserfiche Advanced Audit Trail 1 $80.00 Laserfiche Public Portal 1 $3,000.00 LSAP Total $4,560.00 City of Lodi LASERFICHE Laserfiche Turnkey Solution cps Complete Patneleas Solutions Item Description Price Laserfiche Software Professional Services Laserfiche L5AP Total $33,460.00 Special Discount - 1d% $3,346.00 Total Turnkey Solution $30,114.00 City of Lodi 1 LASERFICHE $22,800.00 $6,100.00 54,560.00 EXHIBIT C Insurance Requirements for Contractor The Contractor shall take out and maintain during the life of this Agreement, insurance coverage as listed below. These insurance policies shall protect Contractor and any subcontractor performing work covered by this Agreement from claims for damages for personal injury, including accidental death, as well as from claims for property damages, which may arise from Contractor's operations under this Agreement, whether such operations be by Contractor, or by any subcontractor, or by anyone directly or indirectly employed by either of them, and the amount of such insurance shall be as follows: 1. COMPREHENSIVE GENERAL LIABILITY $1,000,000 Each Occurrence $2,000,000 General Aggregate 2. COMPREHENSIVE AUTOMOBILE LIABILITY $1,000,000 Combined Single Limit Such insurance shall cover liability arising out of any vehicle (including, owned, hired and non -hired vehicles) operated in performing any and all services pursuant to this Agreement. Coverage shall be written on ISO form CA 00 01 12 90, or a later version, that provides liability coverage at least as broad as this form. 3. ERRORS AND OMISSIONS / TECHNOLOGY $3,000,000 Per Claim $6,000,000 Annual Aggregate Covering all acts, errors, omissions, negligence, network security and privacy risks, including but not limited to unauthorized access, failure of security, breach of privacy perils, wrongful disclosure, collection, or other negligence in the handling of confidential information, privacy perils, and including coverage for related regulatory defense and penalties; data breach expenses, and payable whether incurred by City of Lodi or Contractor, including but not limited to consumer notification, whether or not required by law, computer forensic investigations, public relations and crisis management firm fees, credit file or identity monitoring or remediation services in the performance of services for, or on behalf of, City of Lodi. Such insurance shall be maintained in force at all times during the term of the agreement and provide an Extended Reporting Period (ERP) for a period of one year thereafter, for services completed during the term of the agreement. All limits are to be designated strictly for the City of Lodi, its elected and appointed boards, commissions, officers, agents, employees, and volunteers. All deductibles or self-insured retentions (SIR) must be disclosed to City's Risk Manager for approval and shall not reduce the limits of liability set forth hereinabove. Insurance policies containing any deductible or SIR provision shall provide, or be endorsed to provide, that the deductible or SIR may be satisfied by either the Named Insured(s) or the City of Lodi. It is required that any available insurance proceeds broader than or in excess of the specified minimum insurance coverage requirements and/or limits set forth above, shall be available to City as an additional insured. Furthermore, the requirements for coverage and limits shall be (i) the minimum coverage and limits specified in these insurance requirements; or (ii) the broader coverage and maximum limits of coverage of any insurance policy or proceeds available to the Contractor; whichever is greater. Contractor agrees and stipulates that any insurance coverage provided to the City of Lodi shall provide for a claims period following termination of coverage which is at least consistent with the claims period or statutes of limitations found in the California Tort Claims Act (California Government Code Section 810 et seq.). A copy of the certificate(s) of insurance with the following endorsements shall be furnished to the City: (a) Additional Named Insured Endorsement Pursuant to a separate endorsement (ISO form CG 2010 (11/85) or a later version, that provides liability coverage at least as broad as this form) such insurance as is afforded by this policy shall also apply to the City of Lodi, its elected and appointed boards, commissions, officers, agents, employees, and volunteers as additional named insureds. An additional named insured endorsement is also required for Auto Liability. (b) Primary and Non -Contributory Insurance Endorsement Additional insurance coverage under the Contractor's policy shall be "primary and non-contributory" and will not seek contribution from City's insurance or self-insurance and shall be at least as broad as ISO form CG 20 01 04 13. Page 1 1 of 2 pages Risk: rev.03.2016 Insurance Requirements for Contractor (continued) NOTE: (1) The street address of the CITY OF LODI must be shown along with (a) and (b) above: 221 West Pine Street, Lodi, California, 95240; (2) The insurance certificate must state, on its face or as an endorsement, a description of the project that it is insuring. (c) Waiver of Subrogation Include a waiver of subrogation against the City of Lodi, its elected and appointed boards, commissions, officers, agents, employees, and volunteers. A waiver is required for General Liability and Auto Liability. (d) Limits of Coverage The limits of insurance coverage required may be satisfied by a combination of primary and umbrella or excess insurance. Any umbrella or excess insurance of Contractor shall contain, or be endorsed to contain, a provision that such coverage shall also apply on a primary and non-contributory basis for the benefit of the City before the City's own insurance or self-insurance shall be called upon to protect the City as a named insured. (e) Severabilitv of Interest Clause The term "insured" is used severally and not collectively, but the inclusion herein of more than one insured shall not operate to increase the limit of the company's liability. (f) Notice of Cancellation or Change in Coverage Endorsement This policy may not be canceled nor the coverage reduced by the company without 30 days' prior written notice of such cancellation or reduction in coverage to the Risk Manager, City of Lodi, 221 West Pine St., Lodi, CA 95240. (g) Continuity of Coverage All policies shall be in effect on or before the first day of the Term of this Agreement. At least thirty (30) days prior to the expiration of each insurance policy, Contractor shall furnish a certificate(s) showing that a new or extended policy has been obtained which meets the minimum requirements of this Agreement. Contractor shall provide proof of continuing insurance on at least an annual basis during the Term. If Contractor's insurance lapses or is discontinued for any reason, Contractor shall immediately notify the City and immediately obtain replacement insurance. (h) Failure to Comply If Contractor fails or refuses to obtain and maintain the required insurance, or fails to provide proof of coverage, the City may obtain the insurance. Contractor shall reimburse the City for premiums paid, with interest on the premium paid by the City at the maximum allowable legal rate then in effect in California. The City shall notify Contractor of such payment of premiums within thirty (30) days of payment stating the amount paid, the name(s) of the insurer(s), and rate of interest. Contractor shall pay such reimbursement and interest on the first (1st) day of the month following the City's notice. Notwithstanding and other provision of this Agreement, if Contractor fails or refuses to obtain or maintain insurance as required by this agreement, or fails to provide proof of insurance, the City may terminate this Agreement upon such breach. Upon such termination, Contractor shall immediately cease use of the Site or facilities and commence and diligently pursue the removal of any and all of its personal property from the site or facilities. (1) Qualified Insurer(s) All insurance required by the terms of this Agreement must be provided by insurers licensed to do business in the State of California which are rated at least "A-, VI" by the AM Best Ratings Guide, and which are acceptable to the City. Non -admitted surplus lines carriers may be accepted provided they are included on the most recent list of California eligible surplus lines insurers (LESLI list) and otherwise meet City requirements. Workers Compensation Insurance The Contractor shall take out and maintain during the life of this Agreement, Worker's Compensation Insurance for all of Contractor's employees employed at the site of the project and, if any work is sublet, Contractor shall require the subcontractor similarly to provide Worker's Compensation Insurance for all of the latter's employees unless such employees are covered by the protection afforded by the Contractor. In case any class of employees engaged in hazardous work under this Agreement at the site of the project is not protected under the Worker's Compensation Statute, the Contractor shall provide and shall cause each subcontractor to provide insurance for the protection of said employees. A waiver of subrogation is required for workers compensation insurance. This policy may not be canceled nor the coverage reduced without 30 days' prior written notice of such cancellation or reduction in coverage to the Risk Manager, City of Lodi, 221 West Pine St., Lodi, CA 95240. NOTE: The City reserves the right to obtain a full certified copy of any insurance policy or endorsements required. Failure to exercise this right shall not constitute a waiver of the City's right to exercise after the effective date. Page 2 1 of 2 pages Risk: rev.03.2016 1. AA# 2 JV# CITY OF LODI APPROPRIATION ADJUSTMENT REQUEST TO: Internal Services Dept. - Budget Division 3. FROM: City Clerk 4. DEPARTMENT/DIVISION: 5. DATE: 6/1/16 6. REQUEST ADJUSTMENT OF APPROPRIATION AS LISTED BELOW FUND # BUS. UNIT # ACCOUNT # ACCOUNT TITLE AMOUNT A. SOURCE OF FINANCING 100 10005000 72313 City Clerk IS software $ 30,114.00 401 40100000 50001 Equipment Fund Transfer In $ 30,114.00 B. USE OF FINANCING 100 10095000 76220 General Fund Transfer Out $ 30,114.00 401 40199000 77030 Equipment $ 30,114.00 7. REQUEST IS MADE TO FUND THE FOLLOWING PROJECT NOT INCLUDED IN THE CURRENT BUDGET Please provide a description of the project, the total cost of the project, as well as justification for the requested adjustment. If you need more space, use an additional sheet and attach to this form. Purchase of electronic content management system If Council has authorized the appropriation adjustment, complete the following: Meeting Date: Department Head Signature: Res No: Attach copy of resolution to this form. 3:p_A„,4 8. APPROVAL SIGNATURES Deputy City Manager/Internal Services Manager Date Submit completed form to the Budget Division with any required documentation. Final approval will be provided in electronic copy format. RESOLUTION NO. 2016-85 A RESOLUTION OF THE LODI CITY COUNCIL AUTHORIZING THE CITY MANAGER TO EXECUTE A THREE-YEAR PROFESSIONAL SERVICES AGREEMENT FOR AN ELECTRONIC CONTENT MANAGEMENT SYSTEM, SOFTWARE SUPPORT, AND IMPLEMENTATION SERVICES USING LASERFICHE SOFTWARE WITH COMPLETE PAPERLESS SOLUTIONS, OF ANAHEIM; AUTHORIZING THE CITY CLERK TO EXECUTE TWO ONE-YEAR EXTENSIONS; AND FURTHER APPROPRIATING FUNDS WHEREAS the current in-house electronic content management system has been steadily failing over the past two years; and WHEREAS, a Request for Information for a replacement electronic content management system was posted on the City website and approximately 38 vendors were directly notified of the posting, resulting in proposals from five firms; and WHEREAS, following evaluation of the proposals, the top two vendors provided on-site demonstrations to City staff; and WHEREAS, staff recommends that the City Council award a three-year Professional Services Agreement to Complete Paperless Solutions, with the option of two one-year extensions. NOW, THEREFORE, BE IT RESOLVED that the Lodi City Council does hereby authorize the City Manager to execute a three-year Professional Services Agreement for an electronic content management system, software support, and implementation services using Laserfiche software with Complete Paperless Solutions, of Anaheim, California, in the amount of $30,114 for implementation and $4,560 for annual maintenance; and BE IT FURTHER RESOLVED that the Lodi City Council does hereby authorize the City Clerk to execute up to two one-year extensions; and BE IT FURTHER RESOLVED that funds in the amount of $30,114 are hereby appropriated for this project. Dated: June 1, 2016 I hereby certify that Resolution No. 2016-85 was passed and adopted by the City Council of the City of Lodi in a regular meeting held June 1, 2016 by the following vote: AYES: COUNCIL MEMBERS — Johnson, Kuehne, Mounce, and Nakanishi NOES: COUNCIL MEMBERS — None ABSENT: COUNCIL MEMBERS — Mayor Chandler ABSTAIN: COUNCIL MEMBERS — None A, :'JENNIFER 111. FERRAIOLO City Clerk 2016-85