Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
RFP - 8438 BUDGET ANALYSIS REPORTING TOOL SOFTWARE UPGRADE
Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 1 of 24 PROFESSIONAL SERVICES AGREEMENT WORK ORDER TYPE THIS AGREEMENT made and entered into the day and year set forth below by and between THE CITY OF FORT COLLINS, COLORADO, a Municipal Corporation, hereinafter referred to as the "City" and TECHNETRONIC SOLUTIONS, INC., hereinafter referred to as the "Professional". WITNESSETH: In consideration of the mutual covenants and obligations herein expressed, it is agreed by and between the parties hereto as follows: 1. Scope of Services. The Professional agrees to provide services in accordance with any project Work Orders for 8438 BUDGET ANALYSIS REPORTING TOOL SOFTWARE UPGRADE AND BREAK/FIX, issued by the City. A blank sample of a work order is attached hereto as Exhibit "A", consisting of one (1) page and is incorporated herein by this reference. A general scope of services is attached hereto as Exhibit “B", consisting of fifteen (15) pages and is incorporated herein by this reference. The City reserves the right to independently bid any project rather than issuing a Work Order to the Professional for the same pursuant to this Agreement. Irrespective of references in Exhibit A to certain named third parties, the Professional shall be solely responsible for performance of all duties hereunder. The term “Work” as used in this Agreement shall include the services and deliverables contained in Exhibit A and any Work Orders issued by the City. 2. The Work Schedule. The services to be performed pursuant to this Agreement shall be performed in accordance with the Work Schedule stated on each Work Order. 3. Time of Commencement and Completion of Services. The services to be performed pursuant to this Agreement shall be initiated as specified on each Work Order. Time is of the essence. Any extensions of any time limit must be agreed upon in writing by the parties hereto. 4. Contract Period. This Agreement shall commence February 15, 2017, and shall continue in full force and effect until February 14, 2018, unless sooner terminated as herein provided. In addition, at the option of the City, the Agreement may be extended for additional one year periods not to exceed four (4) additional one year periods. Renewals and pricing changes shall be negotiated by and agreed to by both parties. Written notice of renewal shall be provided to the Professional and mailed no later than thirty (30) days prior to contract end. 5. Early Termination by City/Notice. Notwithstanding the time periods contained herein, the City may terminate this Agreement at any time without cause by providing written notice of termination to the Professional. Such notice shall be delivered at least fifteen (15) days prior to the termination date contained in said notice unless otherwise agreed in writing by the parties. All notices provided under this agreement shall be effective when mailed, DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 2 of 24 postage prepaid and sent to the following address: Professional: City: Copy to: Technetronic Solutions, Inc. Attn: Dawn Lutz, President 3773 E. Cherry Creek N. Drive, Suite 575 Denver, CO 80209 dmlutz@techsoli.com City of Fort Collins Attn: Marija Balic-Wilson PO Box 580 Fort Collins, CO 80522 City of Fort Collins Attn: Purchasing Dept. PO Box 580 Fort Collins, CO 80522 In the event of any such early termination by the City, the Professional shall be paid for services rendered prior to the date of termination subject only to the satisfactory performance of the Professional's obligations under this Agreement. Such payment shall be the Professional's sole right and remedy for such termination. 6. Design, Project Insurance and Insurance Responsibility. The Professional shall be responsible for the professional quality, technical accuracy, timely completion and the coordination of all services rendered by the Professional, including but not limited to designs, plans, reports, specifications, and drawings and shall, without additional compensation, promptly remedy and correct any errors, omissions, or other deficiencies. The Professional shall indemnify, save and hold harmless the City its officers and employees, in accordance with Colorado law, from all damages whatsoever claimed by third parties against the City and for the City's costs and reasonable attorney’s fees arising directly or indirectly out of the Professional's negligent performance of any of the services furnished under this Agreement. The Professional shall maintain insurance in accordance with Exhibit C, consisting of one (1) page, attached hereto and incorporated herein. 7. Compensation. In consideration of services to be performed pursuant to this Agreement, the City agrees to pay the Professional on a time and reimbursable direct cost basis designated in Exhibit "B", consisting of fifteen (15) pages, attached hereto and incorporated herein by this reference. At the election of the City, each Work Order may contain a maximum fee, which shall be negotiated by the parties hereto for each such Work Order. Monthly partial payments based upon the Professional's billings and itemized statements are permissible. The amounts of all such partial payments shall be based upon the Professional's City-verified progress in completing the services to be performed pursuant to the Work Order and upon approval of the Professional's direct reimbursable expenses. Final payment shall be made following acceptance of the Work by the City. Upon final payment, all designs, plans, reports, specifications, drawings, and other services rendered by the Professional shall become the sole property of the City. 8. License. Upon execution of this Agreement, the Professional grants to the City an irrevocable license to use any and all sketches, drawings, specifications, designs, blueprints, data files, calculations, studies, analysis, renderings, models and other Work Order deliverables (the “Instruments of Service”), in any form whatsoever and in any medium expressed, for purposes of constructing, using, maintaining, altering and adding DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 3 of 24 to the project, provided that the City substantially performs its obligations under the Agreement. The license granted hereunder permits the City and third parties reasonably authorized by the City to reproduce applicable portions of the Instruments of Service for use in performing services or construction for the project. In addition, the license granted hereunder shall permit the City and third parties reasonably authorized by the City to reproduce and utilize the Instruments of Service for similar projects, provided however, in such event the Professional shall not be held responsible for the design to the extent the City deviates from the Instruments of Service. This license shall survive termination of the Agreement by default or otherwise. 9. City Representative. The City will designate, prior to commencement of the Work, its project representative who shall make, within the scope of his or her authority, all necessary and proper decisions with reference to the project. All requests for contract interpretations, change orders, and other clarification or instruction shall be directed to the City Representative. 10. Monthly Report. Commencing thirty (30) days after Notice to Proceed is given on any Work Order and every thirty days thereafter, the Professional is required to provide the City Representative with a written report of the status of the Work with respect to the Work Order, Work Schedule and other material information. Failure to provide any required monthly report may, at the option of the City, suspend the processing of any partial payment request. 11. Independent Contractor. The services to be performed by the Professional are those of an independent contractor and not of an employee of the City of Fort Collins. The City shall not be responsible for withholding any portion of the Professional's compensation hereunder for the payment of FICA, Workers' Compensation, other taxes or benefits or for any other purpose. 12. Subcontractors. The Professional may not subcontract any of the Work set forth in the Exhibit A, Statement of Work without the prior written consent of the city, which shall not be unreasonably withheld. If any of the Work is subcontracted hereunder (with the consent of the City), then the following provisions shall apply: (a) the subcontractor must be a reputable, qualified firm with an established record of successful performance in its respective trade performing identical or substantially similar work, (b) the subcontractor will be required to comply with all applicable terms of this Agreement, (c) the subcontract will not create any contractual relationship between any such subcontractor and the City, nor will it obligate the City to pay or see to the payment of any subcontractor, and (d) the Work of the subcontractor will be subject to inspection by the City to the same extent as the Work of the Professional. The Professional shall require all subcontractors performing Work hereunder to maintain insurance coverage naming the City as an additional insured under this Agreement of the type and with the limits specified within Exhibit “C”, consisting of one (1) page attached hereto and incorporated herein by this reference. The Professional shall DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 4 of 24 maintain a copy of each subcontract’s certificate evidencing the required insurance. Upon request, the Professional shall promptly provide the City with a copy of such certificate(s). 13. Personal Services. It is understood that the City enters into this Agreement based on the special abilities of the Professional and that this Agreement shall be considered as an agreement for personal services. Accordingly, the Professional shall neither assign any responsibilities nor delegate any duties arising under this Agreement without the prior written consent of the City. 14. Acceptance Not Waiver. The City's approval of drawings, designs, plans, specifications, reports, and incidental work or materials furnished hereunder shall not in any way relieve the Professional of responsibility for the quality or technical accuracy of the Work. The City's approval or acceptance of, or payment for, any of the services shall not be construed to operate as a waiver of any rights or benefits provided to the City under this Agreement. 15. Default. Each and every term and condition hereof shall be deemed to be a material element of this Agreement. In the event either party should fail or refuse to perform according to the terms of this Agreement, such party may be declared in default. 16. Remedies. In the event a party has been declared in default, such defaulting party shall be allowed a period of ten (10) days within which to cure said default. In the event the default remains uncorrected, the party declaring default may elect to (a) terminate the Agreement and seek damages; (b) treat the Agreement as continuing and require specific performance; or (c) avail himself of any other remedy at law or equity. If the non- defaulting party commences legal or equitable actions against the defaulting party, the defaulting party shall be liable to the non-defaulting party for the non-defaulting party's reasonable attorney fees and costs incurred because of the default. 17. Binding Effect. This writing, together with the exhibits hereto, constitutes the entire Agreement between the parties and shall be binding upon said parties, their officers, employees, agents and assigns and shall inure to the benefit of the respective survivors, heirs, personal representatives, successors and assigns of said parties. 18. Law/Severability. The laws of the State of Colorado shall govern the construction, interpretation, execution and enforcement of this Agreement. In the event any provision of this Agreement shall be held invalid or unenforceable by any court of competent jurisdiction, such holding shall not invalidate or render unenforceable any other provision of this Agreement. 19. Prohibition Against Employing Illegal Aliens. Pursuant to Section 8-17.5-101, C.R.S., et. seq., the Professional represents and agrees that: a. As of the date of this Agreement: 1. The Professional does not knowingly employ or contract with an illegal alien who DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 5 of 24 will perform work under this Agreement; and 2. The Professional will participate in either the e-Verify program created in Public Law 208, 104th Congress, as amended, and expanded in Public Law 156, 108th Congress, as amended, administered by the United States Department of Homeland Security (the “e-Verify Program”) or the Department Program (the “Department Program”), an employment verification program established pursuant to Section 8-17.5-102(5)(c) C.R.S. in order to confirm the employment eligibility of all newly hired employees to perform work under this Agreement. b. The Professional shall not knowingly employ or contract with an illegal alien to perform work under this Agreement or knowingly enter into a contract with a subcontractor that knowingly employs or contracts with an illegal alien to perform work under this Agreement. c. The Professional is prohibited from using the e-Verify Program or Department Program procedures to undertake pre-employment screening of job applicants while this Agreement is being performed. d. If the Professional obtains actual knowledge that a subcontractor performing work under this Agreement knowingly employs or contracts with an illegal alien, the Professional shall: 1. Notify such subcontractor and the City within three days that the Professional has actual knowledge that the subcontractor is employing or contracting with an illegal alien; and 2. Terminate the subcontract with the subcontractor if within three days of receiving the notice required pursuant to this section the subcontractor does not cease employing or contracting with the illegal alien; except that the Professional shall not terminate the contract with the subcontractor if during such three days the subcontractor provides information to establish that the subcontractor has not knowingly employed or contracted with an illegal alien. e. The Professional shall comply with any reasonable request by the Colorado Department of Labor and Employment (the “Department”) made in the course of an investigation that the Department undertakes or is undertaking pursuant to the authority established in Subsection 8-17.5-102 (5), C.R.S. f. If the Professional violates any provision of this Agreement pertaining to the duties imposed by Subsection 8-17.5-102, C.R.S. the City may terminate this Agreement. If this Agreement is so terminated, the Professional shall be liable for actual and consequential damages to the City arising out of the Professional’s violation of Subsection 8-17.5-102, C.R.S. g. The City will notify the Office of the Secretary of State if Professional violates this provision of this Agreement and the City terminates the Agreement for such breach. 20. Special Provisions. Special provisions or conditions relating to the services to be performed pursuant to this Agreement are set forth in Exhibit "D" - Confidentiality, DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 6 of 24 consisting of one (1) page, attached hereto and incorporated herein by this reference. THE CITY OF FORT COLLINS, COLORADO By: Gerry Paul Purchasing Director DATE: ATTEST: APPROVED AS TO FORM: TECHNETRONIC SOLUTIONS, INC. By: Printed: Title: CORPORATE PRESIDENT OR VICE PRESIDENT Date: DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 2/16/2017 President Dawn Lutz Senior Assistant City Attorney 2/16/2017 City Clerk Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 7 of 24 EXHIBIT A WORK ORDER FORM PURSUANT TO AN AGREEMENT BETWEEN THE CITY OF FORT COLLINS AND 8438 BUDGET ANALYSIS REPORTING TOOL SOFTWARE UPGRADE AND BREAK/FIX DATED: Work Order Number: Purchase Order Number: Project Title: Commencement Date: Completion Date: Maximum Fee: (time and reimbursable direct costs): Project Description: Scope of Services: The Professional agrees to perform the services identified above and on the attached forms in accordance with the terms and conditions contained herein and in the Professional Services Agreement between the parties. In the event of a conflict between or ambiguity in the terms of the Professional Services Agreement and this Work Order (including the attached forms) the Professional Services Agreement shall control. The attached forms consisting of ___ (_) pages are hereby accepted and incorporated herein, by this reference, and Notice to Proceed is hereby given. PROFESSIONAL By:_______________________________ Date:_____________________________ CITY OF FORT COLLINS By:_________________________________ Project Manager Date: ______________________________ By: _______________________________ Gerry Paul Purchasing Director (over $60,000.00) Date: ____________________________ DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 8 of 24 EXHIBIT B GENERAL SCOPE OF SERVICES General Description: The City of Fort Collins (“City”) is seeking a partnership between a single software development company (“Professional”) and the Information Technology Department to upgrade and provide maintenance and support for the custom Budget Analysis and Reporting Tool (“BART”) application that manages the Budgeting for Outcomes (“BFO”) process, including personnel service costing, revenue and expenditures as managed by City of Fort Collins Finance Budget Department as described below. Administration of the BART application will be performed by the City. The Professional will work with the City to upgrade and architecturally rewrite the BART application upon award of the contract including the accommodation of some 54 Change Requests (“CR”) and issues that mostly address defects in current functionality. The upgrade could include porting code base to more recent version of development environment and tools. The current architecture is to be rewritten for current best practice and removal of redundancy. Once implemented, the Professional will troubleshoot issues with the implementation of the application and perform requested modifications to provide the full functionality as designed. The Professional selected by the City will also provide ongoing maintenance and support for future application issues, modifications and enhancements. Current Product Description: The line count of all C#, ASMX, ASPX, and Java Script files is 1,781,276. The code is not otherwise architected to give any other size or complexity metric. The code and development environment is maintained on vendor servers with demonstrated security, version control, and disaster recover. The vendor uploads to the City’s Test and Production environments on new releases. The current BART Developer’s environment is configured as follows: o Visual Studio 2015 o .NET 4.5 o SQL Server 2012 o Telerik web controls version 2015.2.826.45 and runtime version v4.0.30319 o BART was developed organically over a period of 10 years and as such is a combination of C#, Java Script, and SQL code. Functionality and redundancy can occur in any combination of those 3 components. The projected BART Production environment platform: o VMs running Windows Server 2012 R2 o MS SQL Server 2012 SP3 o On client side, compatible with Windows 10 DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 9 of 24 Data Integration: There is a one way integration between BART and the City’s Enterprise Resource Planning system, JDEdwards EnterpriseOne (JDE). JDE data is imported into BART nightly, through scheduled SQL Server Integration Services (SSIS). The SSIS packages are separated into Financials and PSC imports. The JDE data is processed into the BART database tables. Generally, the current BART data is marked inactive, and then re-activated within the nightly imported data functions. BART Financial imports, including but not limited to the JDE Account Master, Business Unit Master, Account Ledger, and chart of accounts structure is imported via tables through SSIS. Packages include: o Service Area o Service Unit o Department o Division o Fund Master o Fund Group o Fund Type o Business Unit Activity Code o Business Unit Program Code o Business Unit Master o Business Unit Account master o JDE Ledger BART Financial imports run continuously throughout the budget and non-budget years. BART PSC imports, including but not limited to the JDE Employee Data, Pay Ranges, and Job Types are imported via flat files through SSIS. Packages include: o EEdata (employee data) o Pay ranges o Union code o Position master o Workers comp o Labor Distribution o Job Types BART PSC imports generally run through the first 4 months of the budget year, and are inactive through the rest of the budget year. BART PSC imports can be turned on during the non-budget year. The SSIS packages can also be called by the BART Administration, on demand via the Admin menu. DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 10 of 24 Scope of Work: BART is a Tier 1 Priority 1 Enterprise application for the City, and as such the Professional is expected to provide sufficient resource for this project to be a continuous effort without any significant delay due to Professional’s resource scheduling. Professional has defined 2-week release iterations targeted for Oct. 1, 2017 release to production. The City will walk the Professional through the current working product and its associated online help, Personnel Services Costing (PSC) flowchart and Roles and Rules matrix. The City shall maintain said product throughout the project life cycle as the User Requirements Specification. Other functional and non-functional requirements will be provided for system results and behaviors where not explicit in the interface. In addition to current working product, The City has maintained an Issues and Enhancements list for the BART application. The Issues and Enhancements are requirements and are to be addressed and resolved in the rewrite solution. City will create the project plan and provide a Project Manager. The Professional shall meet regularly with the Project Manager who will manage the project plan, lead team meetings, hold all resources accountable for on time delivery and milestones, manage vendor(s), and communicate to the project team stakeholders and management on a regular basis. City currently owns the code base and will continue to own the code base during the re- write project, upon code complete and beyond throughout the lifetime of the BART application. A copy of the current source code shall be maintained on City servers with a description of the development environment and any instructions necessary to recreate the development environment. The intent is that the City be able to recreate a BART development environment for any reason. Professional shall maintain the Development environment and show evidence of adequate security, version control, and disaster recovery including periodic source updates to the City on a schedule determined by both parties. Professional shall own the process to upload BART executables to the City’s new upgrade Test and Production environments. The releases shall be ready for execution without further configuration or installation by the City. Professional shall not effect database changes without express written permission by the City and only then after having demonstrated significant need. The existing database and schema are relatively simple and straightforward and have served well. The City anticipates little to no changes in the database; database changes can have far-reaching effects on reporting. Professional is likewise responsible for any BART data imports or extracts via current SSIS integration as they may be affected by BART database changes or any other functional or non-functional changes. BART import or extract processes are considered part of the BART product, but does not include reporting. Professional shall deliver a product that performs at or above current levels. At or above current levels is defined as user perceived performance. If user experience with application demonstrates performance levels less than the user is accustomed to, the user would enter Help Desk ticket. If the user would be prompted to enter Help Desk ticket, performance has degraded from current levels. DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 11 of 24 Professional shall define the code architecture and standard methodology and technology used for development and architectural re-write of application. Professional shall document said elements and conduct a review with the City IT staff before development begins. Said documentation shall be a final deliverable of the project. The intent is to allow others to inspect and alter the source code if it should become necessary for any reason. Minimally the City of Fort Collins would expect a comprehensive description of the architecture include documentation down to the object level including rules, attributes, parameters, behaviors, etc. Professional shall look for opportunities to provide Administrator configuration options where hard-coding exists today. For example, ruleset definition and role assignment currently require direct editing of the web.config file which can create work stoppage if mismanaged. Professional shall plan to attend occasional on-site meetings in Fort Collins in support of project. Schedule: The RFP will be awarded for work to commence in early Q1 2017. The Upgraded BART product must be in Production Oct. 1, 2017 for off-year adjustments made in Q4 of 2017. “In Production” means the product is code complete, tested, and accepted by the business after user testing. o Design and architecture documentation complete and reviewed no later than March 20, 2017 o The remaining code and testing efforts should run in parallel with an expected up front effort to construct sufficient infrastructure to deliver BART functionality in phases approximating the BART menus, but not necessarily in the order Revenue, Package/Offer Development, Rating/Ranking, Accept Offers, Budget, PSC and Admin. o Code Complete Code shall be system tested by Professional before being submitted to the City and perform as designed in scenarios where there are no user or data entry errors. Code shall be delivered in verticals as agreed to by the City and Professional in parallel with development; it is not practical to schedule all users to test a simultaneous “big-bang” delivery. o Test and acceptance Upon delivery of new bits to the test environment, the City IT team will verify with surface testing that system testing has occurred. BART can then be user tested, which could possibly include error testing. The Professional and the City will agree on an appropriate delivery schedule that allows sufficient time for significant development and sufficient time for surface and user testing. Once development is complete and BART is in Production, the Professional is expected to provide continuing on-call and next-day support for BART Production. On call implies a virtually immediate response while next-day is the next business day. During the biennial BFO process and at certain other times BART is a critical enterprise application and work stoppage must be addressed immediately. DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 12 of 24 The City may employ the continuing support statement of work on an agreed to fee schedule to add functionality to BART upon project completion. Professional’s Response to RFP: Summary Technetronic Solutions, Inc. (Professional) is pleased to present this proposal to upgrade the Budget Analysis Reporting Tool (BART) for the City of Fort Collins (City). Professional will work with City staff to define requirements, use cases, user stories and deliverables. Professional will take into account the future vision of BART by City so that the system possesses the flexibility and scalability to grow. Professional will utilize a proven project framework and best practices in developing the BART application. We look at these types of projects from a business perspective and functionally and technically design the solution to meet the customer’s needs using the tools available to us without over-engineering the solution. We need to ensure that the system meets the business requirements and is structured in such a way that it can adapt as City grows and changes. We will use the SCRUM methodology that will allow us to create use cases and user stories against the defined requirements. These then can be mapped into a set of releases. Section I – Methods and Approach A. Development Methodology Professional will work with the City to obtain an understanding of the envisioned business processes and system structure to configure the system. This will be done through further system reviews with the City’s team members. We feel this process is critical to driving out functionality and will allow the City to understand project options, deliverables, and risks of a successful delivery. Professional will capture the processes and application functionality through use cases or user stories. Professional will establish an architecture that will allow the application to leverage a service oriented framework. We will apply an agile methodology to reusable object design which will speed up development time if needed, reduce project cost and risk, and improve application functionality and usability. Our approach will also ensure proper security for both the administration and use of BART. These will be used to develop an architectural framework. The core principle in this approach is that framework should be developed around the basic components of the business practices of the City. The design of the solution begins with a concept of the business practices of the City, which identifies the critical components of relevant business processes, and which defines the parameters of the business services. Such services can be combined into a loosely coupled larger structure that, in turn, can be combined into an even larger entity. When designing the application architecture, the functional requirements must be implemented to support the non-functional requirements. The non-functional requirements that will be addressed in the design of the system are: Availability, Security, Scalability/Performance, Manageability, Reliability, Supportability, Standardization, and Integration. Availability: Since the system provides services to different types of users, high availability is required. The key to availability is to isolate service functionality from failures of individual components. The design of the system shall be deployed with a no single point of failure (NSPoF) topology. Exceptions to this design might include DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 13 of 24 external components provided by other vendors that the framework will need to interface. Security: The system contains confidential user information and protected content. This requires that security be addressed with a defense-in-depth strategy. This is an all- encompassing approach that applies security throughout the infrastructure. By addressing security at all levels of the system, we ensure that a single breach of security does not provide a complete and uncontrolled access to the system. To do this properly, the application architecture must be separated into zones (Domains) that can be further segmented. Scalability/Performance: As the usage of the system expands, the system must handle the increased demands without sacrificing performance. Web and Business Application Servers must be able to scale out to allow for increased usage. SQL Server might need to be scaled up to sustain performance and availability amid data growth. Manageability: No matter how great a system may be then if it is not manageable, it will not be a success. Considerations relating to the deployment, monitoring, alteration, and administration of the infrastructure must be taken into account when designing and implementing the new system. Reliability: A consistent and reliable deployment mechanism is needed to ensure the repeatable and consistent deployment of the system into testing, staging, production, and disaster recovery environments. Supportability: If the system is going to continuously adapt and change, it must be easy to support. Easy-to-use tools must be available that allow support personnel to discover, trace, and reproduce system behaviors. The system itself will leverage existing system tools and tracking mechanisms that already exist within the infrastructure rather than developing new tools. Also once corrected it must be easy to test and release the solution into the production environment. Standardization: Implementation of standardized infrastructure components utilizing standard development technologies and practices creates predictable and expandable products. When standardized tools and technologies are used to develop and deploy the product, there is a sound basis for the management of change and growth. Integration: By integrating with existing applications and solutions their power can be leveraged within the system. Additionally, by abstracting the integration through standard development practices and interfaces, changing the integration components will be easier and more cost effective. When designing the application architecture for the system, the functional requirements must be implemented to support the logical mapping. To facilitate this process, the organization and layout of the functional requirements must be considered. When the application architecture is discussed, terms are used to illustrate the organization and layout of the application such as component, layer, domain and tier. These terms and concepts help separate the functional requirements into views that allow the non-functional requirements to be addressed. A Component refers to a logical software module. A collection of components make up an application. By grouping components by functionality, duties or deployment scenarios, we can view an application by layers, domains, or tiers. A Layer refers to a logical partitioning of an application duties or tasks. Each layer contains components that perform similar duties across all application Domains. Applications are divided DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 14 of 24 into a presentation layer (e.g. User Interface), business (or services) layer (e.g. application logic) and a data layer (e.g. Interfaces to SQL Server or files). A Domain is a logical partitioning of application functionality (e.g. Web Site or Service). Each domain contains the components that implement a complete set of functionality across all layers (presentation, business, and data). Domains are divided into major functional elements of the system. The domain model of system is often the easiest model for non-technical project participants to understand because of its focus on the actual functionality. A Tier is a logical entity that defines the physical hosts (hardware or hardware clusters) that an application is deployed (e.g. handheld device, database server). The non-functional requirements of an application play an important role in the definition of application Tiers, more so than application functionality. Components must be developed so they can be deployed on various tiers without modification. Application Tier Web Tier Users Business Layer Service Interfaces Business Components Business Entities Business Workflows Data Layer Service Agents Data Access Logic Components Data Tier Data Stores External Services Other Non-Functional Requirements Security Communication Presentation Layer User Interface Components User Interface Process Components Figure 1: Architecture DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 15 of 24 B. Development Environment Version Control: GitHub Development Tools: Visual Studio 2015 Visual Studio Code Nuget ECMAScript 2015 ECMAScript 2106 jQuery 2.0 KnockOut.js 3.4.2 Angular 2.0 ASP.NET MVC 6.0 Web API 2.2 Entity Framework 6.0 D3.js React.js Database Tools: SQL Server 2012 SSIS SQL Server Data Tools Management Tools: Trello Kanban Microsoft Teams Slack Backup: GitHub OneDrive for Business Testing Tools: Visual Studio 2015 Testing Tools xUnit nUnit Moq Rhino Mocks TypeMock All development will be done on a standard set of workstations and will be stored and managed using GitHub. GitHub provides versioning and backs up all code in the repositories. The code will additionally be backed up and stored in OneDrive. The code will be deployed and tested to an internal deployment server running Windows Server 2012. A backup deployment server will be deployed to Azure. DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 16 of 24 C. 90-Day Work Plan Professional will work with the City to obtain a detailed and meaningful understanding of the current business processes around BART functions. This will be done through creation of basic use case descriptions. We feel this process is critical to creating an effective system and will allow the City to understand the solution options, deliverables, and constraints. Following are the tasks that Professional anticipates will be undertaken in the first 90 days: Task Initial Steps Kick Off Meeting Review roles and responsibilities with Fort Collins Define how use cases and user stories should be specified Advise on spin-up of client’s server environments, such as hardware resources and software versions Review/Detail Technical Requirements Define Architecture and Technology Methods Review Architecture and Technology Methods Review existing BART system Review existing artifacts and documentation, particularly current BART Help documentation, Roles and Rule Set Matrix and PSC flowchart. Determine Preliminary Requirements Meet with Fort Collins finance staff Meet with Fort Collins technical staff Design and create initial user stores Design and create initial use cases Design and create Domain Model based on user stories and use cases Domain Model Design and create domain events based on business process and workflows Create class model based on domain model Map activities and workflows into application events Create High Level Architecture Determine Authentication and Authorization Strategies Create Data Model Create integration plan with remote data stores Design and create Entity Framework objects to integrate with SQL Server Design and create T4 scaffolding that allows Entity Framework objects to templated for deployment Perform Risk Assessment Identify risks, and impacts on all the software components Define Escalation processes for issues Review Client Software and Hardware Review existing hardware Identify any software upgrades Plan Security Determine user roles DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 17 of 24 Assign user role to perform to specific tasks Define security methods Determine web application policies Review compliance requirements Plan failover and disaster recovery Establish requirements for disaster recovery Plan backup and restore procedures and process Design Architecture/Integration Framework Design Service Layer using WCF and Web API Design how services mapped to controllers Design and create controllers Domain model mapped to services and controllers Rest based workflow Create sequence workflow Create state machine workflow Create activity framework Create custom activities for decision nodes Design Model View Model with UI layer Create Object Models Map Object Models into Domain Model Map Domain Models into View Models Create Templates to Generate Domain Models, Services and Routers for the Layers Map MVVM into MVC Views Create Model and Views using Knockout Create Models and Views using jQuery templates Design Application Caching Create second level cache Create Caching and Load Balancing Modules Map between all key constraints Map between indexes Instrumentation Create Application Monitoring Console Monitor integration Design Monitor framework Integration of Workflow processing Elmah integration with IIS and MVC Integration of ASP.NET Web API Create Windows instrumentation for logs and exception handling Integration of Logging framework Integration of Exception framework Integration configuration of Configuration framework Unit test Enterprise Library DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 18 of 24 Section II – List of Project Personnel TSI Contact Dawn Lutz 3773 E. Cherry Creek N Drive, Suite 575 Denver, CO 80209 President 303-872-1619 dmlutz@techsoli.com Architect Donald Lutz 3773 E. Cherry Creek N Drive, Suite 575 Denver, CO 80209 Vice President/CTO 303-547-3101 delutz@techsoli.com Section III – Organization Chart/Project Team Section IV – Schedule of Rates, Cost and Work Hours The total number of hours for the project is estimated at 2,300. Cost per hour for resources assigned to this project is blended at $110 per hour. Total estimated Not to Exceed cost is $253,000. Ongoing support of the BART application will be provided at a rate of $110 per hour. DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 19 of 24 Section V – Statement of Work (SOW) Professional is planning releases in 2-week Scrum style iterations. These iterations can include design documents, use cases, user stories as well as code. In this plan, in addition to the release, each release will also be accompanied with relevant user stories and release notes. The release notes will note what is new in the release to help focus City's testing efforts. In addition to the typical software development phases of requirements, design, coding, testing and production release, the project is to be released iteratively as components are ready for testing. Coding and testing will occur simultaneously. The City suggests a project timeline representing iterative release and testing as pictured below. DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 20 of 24 Deliverables: Phase Deliverable Requirements/Design Design Documents (High Level and Detailed) User Stories Code > includes code walkthrough per module Domain Model includes models Domain Services including business logic API Interface and Services Controller Services Orchestration Services Page and View definition and layer including MVC and MVVM Definition of Page templates including JavaScript frameworks and CSS Repository including Data Access Layer with Entity Framework Integrate Security including Active Directory and JWT (JSON Web Tokens) for services Integration of all instrumentation and monitoring components Admin/Budget Modules Revenue Module PSC Module Package/Offer Module Rating/Ranking and Accept Offers Module Final Rework End to End Application Test Passes Updated documentation, including but not limited to an updated PSC Flow Chart Release to PROD In Production Oct 1 Section VI – Project Milestones The project timeline naturally implies key milestone dates with expected deliverables. Payment to be disbursed as mapped to key dates and deliverables. Payment Schedule: In consideration of the services performed and the subsequent product created; Professional shall be entitled to compensation upon City-verified progress of the following Milestones being achieved: Design Documents (High Level and Detailed) User Stories Domain Model includes models $36,142 Completion of Milestone 1 estimated March 30, 2017 Domain Services including business logic $36,142 Completion of Milestone 2 DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 21 of 24 API Interface and Services Controller Services estimated April 30, 2017 Orchestration Services Page and View definition and layer including MVC and MVVM Definition of Page templates including JavaScript frameworks and CSS $36,142 Completion of Milestone 3 estimated May 30, 2017 Repository including Data Access Layer with Entity Framework Integrate Security including Active Directory and JWT (JSON Web Tokens) for services Integration of all instrumentation and monitoring components $36,142 Completion of Milestone 4 estimated June 30, 2017 Admin/Budget Modules Revenue Module PSC Module $36,142 Completion of Milestone 5 estimated July 30, 2017 Package/Offer Module Rating/Ranking and Accept Offers Module $36,142 Completion of Milestone 6 estimated August 30, 2017 Updated documentation, including but not limited to an updated PSC Flow Chart End to End Testing passes. Release to PROD. $36,148 Completion - No Later than October 1, 2017 Project Total (Not to Exceed) $253,000 The City needs workable solution by Oct. 1, 2017. If new solution is not available, Professional will support existing solution through Dec. 31, 2017 at no additional cost. In the event that the new application is not complete by the October 1, 2017 deadline due to changes in scope or requirements, unavailability of necessary City personnel, unavailability of necessary hardware or software resources at City, or delays in reaching decisions or testing by City, Professional shall be entitled to charge City the rate of $110 per hour after October 1, 2017 to support the existing solution. Professional shall notify City of any such issues that may impact the October 1, 2017 date as soon as reasonably known. The City is utilizing a Professional Services Agreement Work Order Type contract for both the BART Upgrade project; and for Break/Fix on both the old/existing BART tool (while still in operation) and the new Upgraded BART tool, once it becomes operational. Once this Agreement is in effect, the previous BART Break/Fix Agreement will be allowed to lapse as it will no longer be needed. DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 22 of 24 BREAK/FIX SCOPE OF SERVICES Purpose and Scope of Work: Professional and City will work together to maintain the current and/or the Upgraded BART application functionality as directed by City (“Work”). Said Work may include such Enhancements and/or Issues in the current BART application backlog as necessary to expedite a solution at the direction of the City. Assigned Consultant personnel: City’s project representative shall be a duly appointed representative of the City’s ERP Information Services team as designated by the project manager for the Information Technology Department, and Professional’s project representative shall be Donald Lutz. Any changes to Professional’s project representative need to be approved in advance by the City’s project manager. Payment Terms: The City shall pay Professional net 30 days from the date of invoice. Professional shall invoice the City for Work satisfactorily performed on a monthly basis. Estimated Effort: This Work will be on a time and materials basis. Changes in scope or requirements, unavailability of necessary City personnel, unavailability of necessary hardware or software, or delays in reaching City decisions will negatively impact the actual time and costs. Assumption and Risks: This SOW assumes that the City will provide, at its expense, the hardware and software (including Telerik) necessary for the Work. The City shall provide remote access to its systems, access to necessary City personnel, documents, subject matter experts, and systems to Professional at dates and times reasonably acceptable to Professional. Location of Work: Services will be performed at Professional’s office. BREAK/FIX RATE SCHEDULE Onsite Application Support (Billed Hourly) $110/hour Phone Support (Billed on Quarter-hour Basis) $110/hour Service Level Agreement: Professional shall make best effort to respond to City requests within normal business hours on the same business day and to interact with the City during normal business hours, 8:00 AM to 5:00 PM Monday through Friday, unless the severity of the event dictates otherwise. DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 23 of 24 EXHIBIT C INSURANCE REQUIREMENTS 1. The Professional will provide, from insurance companies acceptable to the City, the insurance coverage designated hereinafter and pay all costs. Before commencing Work under this bid, the Professional shall furnish the City with certificates of insurance showing the type, amount, class of operations covered, effective dates and date of expiration of policies, and containing substantially the following statement: “The insurance evidenced by this Certificate will not reduce coverage or limits and will not be cancelled, except after thirty (30) days written notice has been received by the City of Fort Collins.” In case of the breach of any provision of the Insurance Requirements, the City, at its option, may take out and maintain, at the expense of the Professional, such insurance as the City may deem proper and may deduct the cost of such insurance from any monies which may be due or become due the Professional under this Agreement. The City, its officers, agents and employees shall be named as additional insureds on the Professional 's general liability and automobile liability insurance policies for any claims arising out of Work performed under this Agreement. 2. Insurance coverages shall be as follows: A. Workers' Compensation & Employer's Liability. The Professional shall maintain during the life of this Agreement for all of the Professional's employees engaged in Work performed under this Agreement: 1. Workers' Compensation insurance with statutory limits as required by Colorado law. 2. Employer's Liability insurance with limits of $100,000 per accident, $500,000 disease aggregate, and $100,000 disease each employee. B. Commercial General & Vehicle Liability. The Professional shall maintain during the life of this Agreement such commercial general liability and automobile liability insurance as will provide coverage for damage claims of personal injury, including accidental death, as well as for claims for property damage, which may arise directly or indirectly from the performance of Work under this Agreement. Coverage for property damage shall be on a "broad form" basis. The amount of insurance for each coverage, Commercial General and Vehicle, shall not be less than $1,000,000 combined single limits for bodily injury and property damage. In the event any Work is performed by a subcontractor, the Professional shall be responsible for any liability directly or indirectly arising out of the Work performed under this Agreement by a subcontractor, which liability is not covered by the subcontractor's insurance. C. Errors & Omissions. The Professional shall maintain errors and omissions insurance in the amount of $1,000,000. DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 No new insurance required Professional Services Agreement – Work Order Type 8438 Budget Analysis Reporting Tool Software Upgrade Page 24 of 24 EXHIBIT D CONFIDENTIALITY IN CONNECTION WITH SERVICES provided to the City of Fort Collins (the “City”) pursuant to this Agreement (the “Agreement”), the Professional hereby acknowledges that it has been informed that the City has established policies and procedures with regard to the handling of confidential information and other sensitive materials. In consideration of access to certain information, data and material (hereinafter individually and collectively, regardless of nature, referred to as “information”) that are the property of and/or relate to the City or its employees, customers or suppliers, which access is related to the performance of services that the Professional has agreed to perform, the Professional hereby acknowledges and agrees as follows: That information that has or will come into its possession or knowledge in connection with the performance of services for the City may be confidential and/or proprietary. The Professional agrees to treat as confidential (a) all information that is owned by the City, or that relates to the business of the City, or that is used by the City in carrying on business, and (b) all information that is proprietary to a third party (including but not limited to customers and suppliers of the City). The Professional shall not disclose any such information to any person not having a legitimate need-to-know for purposes authorized by the City. Further, the Professional shall not use such information to obtain any economic or other benefit for itself, or any third party, except as specifically authorized by the City. The foregoing to the contrary notwithstanding, the Professional understands that it shall have no obligation under this Agreement with respect to information and material that (a) becomes generally known to the public by publication or some means other than a breach of duty of this Agreement, or (b) is required by law, regulation or court order to be disclosed, provided that the request for such disclosure is proper and the disclosure does not exceed that which is required. In the event of any disclosure under (b) above, the Professional shall furnish a copy of this Agreement to anyone to whom it is required to make such disclosure and shall promptly advise the City in writing of each such disclosure. In the event that the Professional ceases to perform services for the City, or the City so requests for any reason, the Professional shall promptly return to the City any and all information described hereinabove, including all copies, notes and/or summaries (handwritten or mechanically produced) thereof, in its possession or control or as to which it otherwise has access. The Professional understands and agrees that the City’s remedies at law for a breach of the Professional’s obligations under this Confidentiality Agreement may be inadequate and that the City shall, in the event of any such breach, be entitled to seek equitable relief (including without limitation preliminary and permanent injunctive relief and specific performance) in addition to all other remedies provided hereunder or available at law. DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 The ACORD name and logo are registered marks of ACORD CERTIFICATE HOLDER © 1988-2014 ACORD CORPORATION. All rights reserved. ACORD 25 (2014/01) AUTHORIZED REPRESENTATIVE CANCELLATION CERTIFICATE OF LIABILITY INSURANCE DATE (MM/DD/YYYY) JECT LOC POLICY PRO- GEN'L AGGREGATE LIMIT APPLIES PER: CLAIMS-MADE OCCUR COMMERCIAL GENERAL LIABILITY PREMISES (Ea occurrence) $ DAMAGE TO RENTED EACH OCCURRENCE $ MED EXP (Any one person) $ PERSONAL & ADV INJURY $ GENERAL AGGREGATE $ PRODUCTS - COMP/OP AGG $ DED RETENTION $ CLAIMS-MADE OCCUR $ AGGREGATE $ UMBRELLA LIAB EACH OCCURRENCE $ EXCESS LIAB DESCRIPTION OF OPERATIONS / LOCATIONS / VEHICLES (ACORD 101, Additional Remarks Schedule, may be attached if more space is required) INSR LTR TYPE OF INSURANCE POLICY NUMBER POLICY EFF (MM/DD/YYYY) POLICY EXP (MM/DD/YYYY) LIMITS PER STATUTE OTH- ER E.L. EACH ACCIDENT E.L. DISEASE - EA EMPLOYEE E.L. DISEASE - POLICY LIMIT $ $ $ ANY PROPRIETOR/PARTNER/EXECUTIVE If yes, describe under DESCRIPTION OF OPERATIONS below (Mandatory in NH) OFFICER/MEMBER EXCLUDED? WORKERS COMPENSATION AND EMPLOYERS' LIABILITY Y / N AUTOMOBILE LIABILITY ANY AUTO ALL OWNED SCHEDULED HIRED AUTOS NON-OWNED AUTOS AUTOS AUTOS COMBINED SINGLE LIMIT BODILY INJURY (Per person) BODILY INJURY (Per accident) ACORD TM CERTIFICATE OF LIABILITY INSURANCE DATE (MM/DD/YYYY) 02/16/2017 PRODUCER Pinnacol Assurance 7501 E Lowry Blvd Denver, CO 80230-7006 THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. INSURERS AFFORDING COVERAGE NAIC# INSURED Realfax, Inc. dba Technetronic Solutions, Inc. 1414 S Uinta CT Denver, CO 80231 INSURER A: Pinnacol Assurance 41190 INSURER B: INSURER C: INSURER D: INSURER E: COVERAGES THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED. NOTWITHSTANDNG ANY REQUIREMENT, TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH POLICIES. LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. INSR ADD'L POLICY EFFECTIVE POLICY EXPIRATION LTR INSRD TYPE OF INSURANCE POLICY NUMBER DATE(MM/DD/YYYY) DATE(MM/DD/YYYY) LIMITS GENERAL LIABILITY COMMERCIAL GENERAL LIABILITY CLAIMS MADE OCCUR GEN'L AGGREGATE LIMIT APPLIERS PER: POLICY PROJECT LOC EACH OCCURRENCE DAMAGE TO RENTED PREMISES MED EXP(Any one person) PERSONAL & ADV INJURY GENERAL AGGREGATE PRODUCTS - COMP/OP AGG AUTOMOBILE LIABILITY ANY AUTO ALL OWNED AUTOS SCHEDULED AUTOS HIRED AUTOS N0N-OWNED AUTOS COMBINED SINGLE LIMIT (Ea Accident) BODILY INJURY (Per person) BODILY INJURY (Per accident) PROPERTY DAMAGE (Per accident) GARAGE LIABILITY ANY AUTO AUTO ONLY - EA ACCIDENT OTHER THAN EA ACC AUTO ONLY: AGG EXCESS/UMBRELLA LIABILITY OCCUR CLAIMS MADE CERTIFICATE HOLDER COPY City of Fort Collins PO Box 580 Fort Collins, CO 80522 IMPORTANT If the certificate holder is an ADDITIONAL INSURED, the policy(ies) must be endorsed. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s). If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s). DISCLAIMER The Certificate of Insurance on the reverse side of this form does not constitute a contract between the issuing insurer(s), authorized representative or producer, and the certificate holder, nor does it affirmatively or negatively amend, extend or alter the coverage afforded by the policies listed thereon. DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 DEDUCTIBLE RETENTION $ EACH OCCURRENCE AGGREGATE A WORKERS COMPENSATION AND EMPLOYER'S LIABILITY ANY PROPRIETOR/PARTNER/EXECUTIVE OFFICER/MEMBER EXCLUDED? If yes, please describe under SPECIAL PROVISIONS below 4061943 10/01/2016 10/01/2017 X WC STATU- OTHER TORY LIMITS E.L EACH ACCIDENT $500,000 E.L DISEASE - EA EMPLOYEE $500,000 E.L DISEASE - POLICY LIMIT $500,000 OTHER DESCRIPTION OF OPERATIONS/LOCATIONS/VEHICLES/EXCLUSIONS ADDED BY ENDORSEMENT/SPECIAL PROVISIONS 8438 BUDGET ANALYSIS REPORTING TOOL SOFTWARE UPGRADE AND BREAK/FIX CERTIFICATE HOLDER CANCELLATION 1774746 City of Fort Collins PO Box 580 Fort Collins, CO 80522 SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF, THE ISSUING COMPANY WILL ENDEAVOR TO NOTIFY 30 DAYS WRITTEN NOTICE TO THE CERTIFICATE HOLDER NAMED TO THE LEFT, BUT FAILURE TO NOTIFY SUCH NOTICE SHALL IMPOSE NO OBLIGATION OR LIABILITY OF ANY KIND UPON THE COMPANY, ITS AGENTS OR REPRESENTATIVES. AUTHORIZED REPRESENTATIVE Jennifer Schmitz ACORD 25(2001/08) Underwriter ACORD CORPORATION 1988 DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052 PROPERTY DAMAGE $ $ $ $ THIS IS TO CERTIFY THAT THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED. NOTWITHSTANDING ANY REQUIREMENT, TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH POLICIES. LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. INSD ADDL WVD SUBR N / A $ $ (Ea accident) (Per accident) OTHER: THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AFFIRMATIVELY OR NEGATIVELY AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. THIS CERTIFICATE OF INSURANCE DOES NOT CONSTITUTE A CONTRACT BETWEEN THE ISSUING INSURER(S), AUTHORIZED REPRESENTATIVE OR PRODUCER, AND THE CERTIFICATE HOLDER. IMPORTANT: If the certificate holder is an ADDITIONAL INSURED, the policy(ies) must be endorsed. If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s). COVERAGES CERTIFICATE NUMBER: REVISION NUMBER: INSURED PHONE (A/C, No, Ext): PRODUCER ADDRESS: E-MAIL FAX (A/C, No): CONTACT NAME: NAIC # INSURER A : INSURER B : INSURER C : INSURER D : INSURER E : INSURER F : INSURER(S) AFFORDING COVERAGE SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF, NOTICE WILL BE DELIVERED IN ACCORDANCE WITH THE POLICY PROVISIONS. TechInsurance 1101 Central Expy. South, Suite 250 Allen, TX 75013 800-668-7020 (877) 826-9067 Realfax, Inc. dba Technetronic Solutions, Inc. 3773 E Cherry Creek North Dr, Ste 575 Denver, CO 80209 Hartford Casualty Insurance Company 29424 Hartford Fire Insurance Company 19682 A 46SBAUB4758 ✔ Yes ✔ 2,000,000 10,000 5/3/2017 300,000 5/3/2016 2,000,000 4,000,000 4,000,000 A 2,000,000 ✔ ✔ Yes 46SBAUB4758 5/3/2016 5/3/2017 A ✔ ✔ Yes 10,000 46SBAUB4758 5/3/2016 5/3/2017 2,000,000 2,000,000 ✔ B Professional Liability (Errors and Omissions) 46 TE 0298806 11/6/2016 11/6/2017 $2,000,000 / $2,000,000 Certificate Holder is named as Additional Insured as their interests may appear in regards to general liability and umbrella excess liability. . City of Fort Collins PO Box 580 Fort Collins, CO 80522 2/16/2017 ✔ 114043 Realfax, Inc. dba Technetronic Certificate of Insurance (page 1 of 1) 02/16/2017 09:22:59 AM DocuSign Envelope ID: 108BAFFD-DFA4-431E-A367-026F89A50052