Loading...
HomeMy WebLinkAboutOpening of Proposals - Utility Billing System - Tyler Technologies, Inc - Part 1CITY OF SOUT[i BEND, IN PROPOSAL, FOR UTILITY BILLING SYSTEM JANUARY 23 RD 2018 Subject to restrictions on disclosure identified on following page This proposal from Tyler Technologies, Inc. ("Tyler') contains proprietary and confidential information, including trade secrets, belonging to Tyler or Tyler's partners. Tyler is submitting this proposal on the express condition that the following portions, if included, will not be duplicated, disclosed, or otherwise made available, except for internal evaluation purposes: • Response to the Functional Requirements, or "Checklist" • Line -item pricing (total proposed contract amount may be disclosed) • Screen shots • Customized Statement of Work/Implementation Plan Each of these sections, if included, has separately been labeled "Proprietary and Confidential — Subject to Restrictions on Disclosure." To the extent disclosure of those portions is requested or ordered, Tyler requires written notice of the request or order. If disclosure is subject to Tyler's permission, Tyler will grant that permission in writing, in Tyler's sole discretion. If disclosure is subject to a court or other legal order, Tyler will take whatever action Tyler deems necessary to protect its proprietary and confidential information, and will assume all responsibility and liability associated with that action. Tyler agrees that any portions not listed above and marked accordingly are to be made available for public disclosure, as required under applicable public records laws and procurement processes. Because of the nature of this proposal, third -party hardware and software products may be mentioned by name. These names may be trademarked by the companies that manufacture the products. It is not Tyler's intent to claim these names or trademarks as our own. 1316 COUNTY -CITY BUILIANG 227 W, hTFEASON ROULINARD Sore i 13M), INDIANA 46601-1830 PHONii 574/ 235-9251 FAX 574/ 235-9171 TDD 574/ 235-5567 Cn,y()i,'Sotj't,fjBF',ND BOO AID OF PUBLIC WORKS Date: December 27, 2017 To: All Proposers From Linda M, Martin, Clerk, Board of Public Works Subject Addendum Number: 2 Project Narne: Utility Billing System Project Number: ACKNOWLEDGEMENT OF RECEIPT OF ADDENDUM Date Received: 1/17/18 This addendum is being forwarded to you for the above referenced project. Please sign below and acknowledge receipt of this Addendum by faxing this sheet to the Board of Public Works at (574), 235-9171 within 48 hours of receipt. A copy MUST also be included with your proposal package upon submittal. THIS ADDENDUM MAY AFFECT YOUR PROPOSAL. Notes: The attached documents are hereby added to the Specifications and Contract Documents and become a part of herein. Company: Tyler Technologies, Inc. Authorized Signature: Date: 1/17/18 Version 4/2/2015 1316COUNTY-Cury BUILDING 227 W. JEFFERSON BOULEVAIM sourli BENI), INDIANA 46601-1830 PHONE 574/235-9251 FAX 574/ 2,35-917 1 TDD 574/ 235-5567 CITY OF Sou'rii BEND PETF, BUTTIGIEG, MAYOR BOARD OF PUBLIC WORKS Date: January 18, 2018 To: All Proposers From Linda M. Martin, Clerk, Board of Public Works Subject Addendum Number: 1 Project Name: Utility Billing Systemi Project Number: I Date Received: 1/17/18 This addendum is being forwarded to you for the above referenced project. Please sign below and acknowledge receipt of this Addendum by faxing this sheet to the Board of Public Works at (574) 235-9171 within 48 hours of receipt. A copy MUST also be included with your I proposal package upon submittal. Notes: The attached documents are hereby added to the Specifications and Contract Documents and become a part of herein. Company: Tyler Technolo Authorized Signature: Date: 1/17/18 Version 4/2/2015 Table of Contents Section I Letter ofTransmittal ......... ......... _......... _—_—.............. ......... ............................... ~..5 Section Executive Summary ... —................. ...... —....... ............... ___—........ ........_........7 Section 3 Rnn OuaJNlcatiomo...................... .................. ........ .................. ................ -...................... 8 3.1 Form A ........ ....................................................... ---- ..... ...... ........... ............... —............... 8 Section Proposed Solution ... --- ...... _........ ................. —........ _._..................... ....... ..... 14 4.1�1 Tyler System Specifications .................................... ..................................................... 15 4.2 KMmmbUtility Billing OS__ ........... ....... ..... ................................... ........... _............. Z9 4.2.1 Mumis Utility Billing CIS ....... .......................... ...... ........................................ .................. 29 43 Third Party Integration ..................................................... ...... ............... —............... ........ 30 4'4 7ylerUmmpiemnertadon Methodm|oBV—.... ...... ...... —....... ................-....................... 32 4.5 Data Conversions ............. ................................ ...................................................................... .36 4.5.1 Assess and Define: Data Mapping and Design ............ -........... ............................. 37 4,5,2 Build and Validate: Conversions and ...... ..................... ....... 37 4.5.3 Production 0utnvecFinal Data Conversions ....... .......................................... _....... 38 � 4.6�4 Data Conversion Standards ..—.................. ........... ............ ............ ...... ................... .... 3B 4`6 Training Approach ................... ...................... --___---.......................... 43 Train|mgkHeth .............. ...................................... ............................ ....................... 39 43.1 Fundamentals Review ...... ....—..........._.....~..................................... —... 39 4.,7'2 Configurationand Power User Training .................................... ................................... 40 4.73 Train the Trainer .......... —............................. ......... ............ ............... .............. ..... 4D 4.7.4 Technical and System Administration Training ._............-........................ 40 4.7-5 End User Training. ................................... .................................. ........................ ........ 4O 4.8 Scheduling and Attendance .......................... .................................... ..................... .......... 41 4.9 Responsibilities ........ ...................... _--....... —__._......—........ ............. ....... ......41 SeoUmnS Optional Solution .......... ................................ ..................................................... ....... 42 Section Proposed Staffing and Project Organization ........................ ...... —................. ............. .43 6.1 TyierRenonrces_---..... --........... _..... ---- ...... ......_..............................4] 6.2 Form, F..................... ......... .............................. ................................................. ............ —... 45 Section Related Experience References —................... _—_-....-......... ..—_.......... ......... 5O 3 Section 8 Responses to System Requirements................................................................................ 52 8.1 Notes and Assumptions....................................................................................................... 52 8.1.1 Tyler Reporting Services............................................................................................... 52 8.1.2 Interfaces / Customizations......................................................................................... 52 8.1.3 Custom Modifications ................................... ......... ...-.................... ............................ 52 8.1.4 Future Functionality..................................................................................................... 52 Section9 Work Plan......................................................................................................................... 53 9.1 Project Planning................................................................................................................... 54 9.1.1 Project Schedule Development.................................................................................... 55 9.1.2 Proposed Project Schedule........................................................................................... 55 9.1.3 Proposed Project Phases.............................................................................................. 55 Section 10 Terms and Conditions...................................................................................................... 56 10.1 Sample license Agreement.................................................................................................. 56 10.2 Master Escrow Agreement.................................................................................................. 57 10.3 Certificate of Insurance........................................................................................................ 58 10.4 Corporate Resolution........................................................................................................... 59 10.5 Exceptions to the RFP.......................................................................................................... 60 Section 11 Safety Requirements/Violations...................................................................................... 62 Section12 Affidavit............................................................................................................................ 63 Section13 Appendices....................................................................................................................... 64 4 Tupsday, January 23, 2018 City ofSouth Bend, |N Linda Martin 1308County-City 8ui|din8 South Bend, |N456O1 RE: Response hnRFP F10TWOVARMA Tyler Technologies, Inc. (Tyler Technologies) ispleased torespond toCity ofSouth Bend, |M/sRequest for Proposal dated Friday, December1~ 2017,for Utility Billing System, The attached prmposolwi|| detail our complete offering, indwd|n&: 0 Munis software applications 0 Necessary consultation to define scope of services 0 Implementation of software and services Training on, and support of, provided software and services y In presenting the enclosed proposal, Tyler Technologies warrants that it is unaware of any known conflict of interest in responding to, or submitting, said proposal in response to City of South Bend, IN's REP. Tyler Technologies also warrants that it complies, and acts in accordance, with; * Federal Executive Orders reiadngtothe enforcement ofcivil rights • Federal Codes regarding 4nti-discdmination inEmployment • Title 6, Civil Rights Act of 1964 • Requirements ofthe Americans with Disabilities Act Vf1A9Ofor work performed due tothis REP This proposal and cost schedule shall hevuUdand binding for 120 days following the RFPdue date, Except as set forth in this proposal, this proposal may be r6eased in part or in total as public information in accordance with the requirements of the laws covering same. One or more individuals in the Tyler Technologies Contracts Department have read and accepted the terms and conditions of the REP and any amendments, except as modified by, taken exception to, or otherwise set forth inTyler Technologies' proposal. 5 � URygflk'nAh Bend, IN If you have any questions related to this proposal, please feel free to contact: Gary Dube, Sr, Account Executive 8010.772.2260 ext: 4130 gary.dube@tylertech.com Tyler Technologies, Inc. is a publicly traded corporation (NYSE: TYL) EIN: 75-2303920 Respectfully submitted, A ' ill Diaz Chief Legal Officer, Ty er Technologies, Inc. 6 ("lly of South Bend, IN Uldify Siff ng Systern Section 2 EXEcu"rivE SUMMARY Who are we? Tyler Technologies, Inc. is proposing it Munis Utility Billing CPS software solution in response. to the South Bend Board of Public Tyler Technologies, Inc, Employees: 4,000 Works' RFP for a Utility Wiling System, ML"* is A Slitte of frilly Clients: 1.5,000 integrated modules which includes applications for Financial Revenue: $645M Management, Procurement, Hurrian Capital mallagemelli, Utility NYSE: TYL Billing, Permitting, Cashiering, online. Self -Service and much more, wormlylertech.com Munis can be hosted at Tyler's I losting Centers or deployed on your organization's servers. What do we do? Develop ond deliver soffivore and all related Tyler rs the largest software company dedicated solely to the Us iervices exchisivelyfor the public secral- public Sector market. We have been delivering our Munis ERP software to municipal governments in Indionts for 35 yeam We have as thorough understanding, of the Ind kin What solutions do we offer? requirements and the result has been to trock record of success with Tyler Mur;45 "I ERP Softwore Suite Munis in Indiono, Additionally, we have several comparably sized Tyler EnerGov" Commonity Developnwnt municipalities in kidiana and many diverse municipalities nationwicle that count on lyler'lechnologies and Munis every day. Now many clients use our Munis software solution? Tyler has becin providing Financial & Humira Capital Management, 1,500 ­ All public sector; Including these to IN: software nand Otility Billing & Land Manarlement system to the - City of Andecson, IN public sector for 35 years. Although the, software his undergone 0yof(blumials, IN numerous revisions during this time, our custorners, have never City of Evansville, IN had to pay for a software upgrade or new release. This City of Fort Wayne, IN cornmitment, called Tyler's EverGreen apprOM11, COutribUteS Indianapolis Publir Sch ools greatly to our 98% client retention rate by protecOng our client's Indionotsofis-Marian County Public Ubrory initial investment in software licenses & implementation services, City of Hartford, CT City of Mionri Beoch, rL Notably, Tyler is a highly successful company by virtually any City of NopetvO16, It St, Louis ("Oon ty, MO MeaSUre, By focusing on one line of business, on takhig care of the City of Charlotte, NC customer & our employees, and on the continued iroproverrient of City of rolso, OK all operatiom - we have expericniced 67 consecutive profitable quoiters. This success enables Tyler to add & retapn, quaHfied Why considerpartneringwith Tyler? resources, enhance functionality & technology, and continually extend services & value to our clients. License $ credit toward Fit). MgmL system Veryfinoncially stable orgomizo tion Our experienced project managers utflize as proven rXclusively Pliblic sector focused Deep 5oflwore domain experience implementation Approach based upon the methodologies of the. Mature, comprehensive, integrotedsoftwore Project Management Institute (PMI) to achieve an all-time andon- Technologicolly current products budget implementation. Once live, your organization will have rull service provider - NO SYStCITI integrators many avenues, like Tyler U to engage with our Customer Support Proven implementation methodologies & ifelp Desk depts. to rec6ve Accurate and fimc4y information so Extenshoe development & supporl tesources your staff Card spend more firne focusing oil servicing, your citizens EverGreen to EverGuidt?-poelf)er.0)il)16rlife and on rneeOng the massion or your organi7ation. What is Tyler's relevant experience? Software functionality and technology ij!qr?R_wtth vendor focus - A long his torV of moccess of Munis In Indiollo and OabflNty is Ore key to the q4ccess of a Utility Biffing software -An active indianct Munis user group deployment. Tyler is the most experienced company, and Morlis -A modoloryet lotegratedsoftworesysteal is the best municipal system on the market - and it will be for the Supportfor yout required Inlegratiom long-term. Wewould welcolne the opportunity tO workwith you. Deep Way of modules for all departments Long thrre-hprizon for the Munis Solution Gary Dube gary.dubP@tyfe, (207)519-4130 City, clf: Soolh Betid, I'N (Athly Mffiml I;Yslmo Section 3 FIRM QUALIFICA-11ONS This section of the proposal should establish the ability of vendor(s) to satisfactorily perform the required work by reasons of: experience in performing work of a similar nature for similar clients (siize and account base) within the past five years; demonstrated competence in the services to be provided; educational qualifications; strength and stability of the firm; staffing capability; work load; record of meeting schedules on similar projects; and supportive client references. Vendor shall complete Proposal Form A as part of this section, If the proposed solution is a packaged partnership, then the significant sub Utility Belling System Section VI, "Proposal Submission Requirements"- Page 2 of 6 contractors shall also provide information for this section. Vendor must provide additional information in this section that will: 3 � 1. FORm A Company Name Chief Executive Tyler Technologies, Inc. John Marr1r, Prima j:y Street Address city State Zip Code I Tyier Drive Yarmouth ME 040,96 Primary Contact Pei -son for This Solicitation Contact Email Telephone Number Gary Dube Gary Dube@tyleirtech,com 800.7712260 Years in Business Number of Employees 51 Years 4,115 Full -Time 32 Part -Time Website https:�//www.tylertech.com/ Please describe your US and Canadian based staff organization and resource levels, within the: followina categories.. Resource Categorization Total Full -Time Equivalent (FTE) Staff of the Vendor 227 Business Analysis 772 Technical Support 8 Ofy oaf 5oulh Bend, IN i I � iM / 11111ir q) � " � cd r � 1,299 Training 763 1 Custom Development Included in the Custom Development number. Quality Assurance Included in the Custom Development number. Research and Development 4,146 Total FTE Vendor Staff in Any/All Areas SUBCONTRACTOR INFORMATION: Please list subcontra,ctoirs who are include in the proposal. Complete the following tables for each subcontractor. Company Name Chief Executive N/A Primary Street Address City State Zip Code Primary Contact Pei -son for This Solicitation Contact Email Telephone Number Years in Business Number of Employees Full -Time Part -Time Website Please describe subcontractor US and Canadian based staff organization and resource levels, within the.following categories. Resource Categorization Total Full -Time Equivalent (FTE) Staff of the Vendor N/A Business Analysis N/A Technical Support N/A Training N/A Custom Development 9 Chy q/ , (x,dh IN UNWy Quality Assurance Research and Development Total FTE Vendor Staff in Any/All Areas PENDING LITIGATION AND LIQUIDATED DAMAGES Please complete the following two (2) tables regarding any/all litigations and damages, if appiicable, encountered in the, pastfive (5) years. Does the Vendor Have Any Pending Litigati n? (Y / N) if Y, Client Name/P!Tject Name Date Description/Cause Piease see below Has the Vendor Been Sul�iect to Any Liquidated Damages? (Y / N) NONE if Y, Client Name/ Prgiect Name Liquidated Damages Description/Cause Imposed Amount Date Imposed Collected Amount Date Collected NONE * There is no pending litigation involving Tyler's ERP and School Division; however, a product sold out of Tyler's Courts & Justice Division known as Odyssey and an employment -related dispute in Tyler's Tax & Appraisal Division are currently the subjects of the following pending litigation, respectively: w ° OnJanuary g,2Ol7 a|awsuit was filed against Tyler, Shelby County, Tennessee, and various Shelby County officials inafederal district court in Tennessee, That lawsuit was consolidated with a November 2016 lawsuit that had been filed against the Shelby County Sheriff alone. The consolidated complaint, filed March 24, 2017, alleges that Shelby County and officials in the County unlawfully detained certain inmates imthe County jail. Tyler implemented its Odyssey case management system in Shelby County courts, but the lawsuit tries to claim that Tyler's software, was somehow connected to the aflegedly unlawful detentions in the County jail. On October 31, 2017, another class action lawsuit, alleging almost identical facts and claims against the same group ofdefendants, was filed bya second set ofplaintiffs lawyers onbehalf ofasecond set of alieged class action plaintiffs, Tyler has moved to dismiss the claim against it in the first -filed 18 � � {fly@fSoufh8em&0V suit, and is|mthe early stages nfassessing the procedural implications pfthe second -filed suit. Tyler is confident that all of the allegations against it are without merit. w ° �OmNovember 8, 2017, Vision sued Tyler in a Massachusetts Superior Court. Vision claims Tyler violated a no'n- disclosure agreement relating to Tyler's appraisal services business by hiring employees who had been employed by Vision. Tyler disputes Vision's claims, and looks forward to a vigorous defense. w Additionally, Tyler has had two completed litigations involving Tyler's ERP and School Division within the last five (5)years: w ° h2015,Tyler's ERP/kSchools division was sued by a single plaintiff in a New York federal district court oil claims relating to alleged employment discrimination. Tyler strongIycontested the pUn1Ufoallegations, and the parties were able to resolve the claims. The lawsuit was dismissed an mutually agreeable terms in]816. w ° : In, Z014,Tyler, onbehalf of its ERP&Schools division, filed a declaratory judgment action against software provider (V&[onvemnns, LLC) in aTexas fedoraUoour1. In response, VBCsued Tyler for copyright infringement and re8aied statutory violations in a California federal court. V8Cis referred to by many in the industry asa "tno|;," and Tyler successfully negotiated e mutua| release and setLUemon1. Each lawsuit was dismissed. (1) provide a brief profile of the firm(s), Including the types of services offered; Tyler Technologies, headquartered inPlano, Texas, isaleading provider ofemd-ho-nndinformation management solutions and services for local governments. Tyler partners with clients to empower the pubNc sector — cities, counties, schools and other government entities — to become more efficient, more accessible and more responsive to the needs of citizens. Tyler's client base includes more than IS,000 local government offices in all 50 states, Canada, the Caribbean, the United Kingdom and other international lncations. These mission -critical applications prov�dethe public sector with the ability to streamline and automate operations resulting in improved productivity and reduced costs. With decades of excl�usive public sector experience, Tyler is the market leader that provides integrated software and services; our singularfocu�s, subject matter experts a;nd in-depth products result in a sustainable client partnership that dehversthe imdustry's most comprehensive solution, We provide the industry's broadest line of software products, and offer cDents a single source for all their information technology needs, in several major areas: Financial 6L Human Resources, K-12 School Solutions, Public Safety, Courts &Justi:e, Property Appraisal 8^Tax, Permitting & Land 11 �OyNSmu III (fev if I, tA) Management, Public Maintenance Management, Citizen Services, Land & Vital Records, and Document Management. We are known forlong-standing client relationships, functional and feature -rich products, and the latest technology. In addffion to software products, Tyler provides related professiona I services including insLaUaUmn, data conversion, consulting, training, custmmization,support, disaster recovery, and application and data hosting. Tyler always puts its cients, first. VVesucceed because wetake our client's success seriously, and we have aproven record ofdelivering superior software solutions and services. The overwhelming majority of chents are up and running on time, and within budget. Whether it's developing, enhancing, and implementing our software, or providing excellent service and client support —we succeed because our clients succeed. VVewant clients for Ofe.|nfact, many mfTyler's first clients, across every solution, are stiil clients today— some with relationships that span decades. PUBLIC St[TOR Focus Tyler's business units have provided software and services to customers for more than fifty years and have long-standing reputations in the local government market for quality products and customer service. Tyler is the largest company in the United States focused solely on providing software solutions to the public sector. WhHe many of our competitors compete in multiple vertical markets, Tyler is singu|adyfocused mn the public sector. It's 100 percent ofour business. � Tyler recognizes that the public sector is generally stable,, risk averse, and craves community accessibility, security, and transparency, That iswhy local government and school entities seek reliable and efficient software and services from Tyler --a vendor who is professional, reputable, dedicated, and achieves results, Tyler has the experience tounderstand the unique requirements of the public sector, the necessary resources to invest in its products, and the ability tudeliver quality kde�sexpansive offering mfprofessional oervicesisdesignedtocomplennen1KssoftvareoMerinKx and produce the optimum working environment for Iocal government customers. * Consulting w Conversion • Customization • Training w Live ongoing support w Network management the year founded; Tyler Technologies was founded in 1966, 12 � (,fly ()] Southileno, IN form ofthe organization (corporation, partnership, sole proprietorship); Tyler Technologies is a publicly traded corporation listed as TYL on the NYSE. number, size, and location of offices; Tyler has office locations throughout the United States: Arizona, Colorado, Georgia, Illinois, Iowa, Maine, Massachusetts, Michigan, Missouri, Montana, New Hampshire, New York, Ohio, Ontario, South Dakota, Texas, Washington and Wisconsin number of employees; (2)provide ageneral description ofthe Nrmi'sfinancial condition; identify any conditions (e.g., baokrwptcy, pending litigation, planned office closures, impending merger) that may impede vendor's ability to complete the project or meet the vendor's obligation during the first five years of maintenance and support; Tyler consistently maintains a solid balance sheet aind strong cash flow and low debt, experiencing consistent revenue growth with 60 consecutive quarters of profitability, and a total revenue for 2016 mfS756million. While experiencing significant growth opportunities from an increase in staff and expanding territories, weanticipate additional product offerings and new technology will accelerate this growth xubstamt|aNyinthe future. We believe debt -free balance sheet, substantial cash reserves, and acommitted customer base put Tyler imagreat position inour industry Loweather any unexpected turbulence in the economy. (4) describe the fi�rm'sexperience |mperforming work ofasimilar nature tothat omNdted in this RFPw|tbin the past years for clients ofsimilar size and accounts, and highlight the participation insuch work bvthe key personnel proposed for assignment tothis project; and Please reference the Clients list on the Electronic copy due to page limitations. (5)identify sub -consultants bycompany name, address, contact person, telephone number, and project function; describe vendor's experience working with each sub-consulltant. 13 0y(,,)/ souhRmO, IN 0/0/y8Nwy�:/c/n Section 4, PROPOSED SOLUTION Vendor must provide a narrative which addresses how the proposed software will meet the system requirements and how the vendor wild approach the implementation of the SolUtloin. This Section shall: (1) For all proposed software components, Vendor shall clearly indicate the proposed version number and software name, the current version number and software name, the planned release date for the next version; Tyler is proposing Munis Software. Mullis Release Eady Generat Next Release Last product i Cus ers torn' i Release 20t9,3 V12 Type Adoption Avitflability Planning W-2 11,099 (EA) (GA) (NRP) Year End Gabxblb'act NA NA Sep 2020 2020 Retired (PR) Apr 2021 Live as of Dec 1, 2017 Not Available 20119.1 V12 Feature Feb 2019 Apr 2019 Apr 2021 2021 Apr 2022 Not Available 2018.3 V12 Contract NA NA Sep 2019 2019 Apr 2020 Not Available 2018.1 V12 Feature Feb 2018 Apr 2018 Apr 2020 2020 Apr'2021 Not Available 2017.3 V12 2017.1 V12 Contract Technology NA Feb 2017 lAA Sep 2017 Sep 2018 Apr 2019 2018 2019 Apr 2019 A1pl"2020 3 t 1 11.3 Final NA Jul) 2017 Apr 2019 2020 Apr 2021 195 11.2.5 Contract NA NA Sep 2017 2017 Api, 20118 8 M2 11.1.6 11.1 Feature Contract Feature Feb 2016 W Feb 2015 Apr 2016 May 2015 Apr 2018 Sep 2016 Apr 2017 2018 2016 2017 A,pr 2019 Api"2017 Apr 201A 690 4 186 10.6 Final N_, , , Sep 2017 2 018 Apr 21019 455 I (2) For the proposed software solution indicate the number of current installations and installations performed in the past 5 years, by type of utility (water, wastewater, electric, gas, etc.); Please reference the Client List on the electronic copy due to page limitations. 14 City of South Bend, IIV Wility ffiffloq (3) For proposed software, indicate all supported computing environments, indicated support for virtual/ph!ysical servers, operating system, and database management software; �.}. 1 TYLEkSYSTLM SP[(]H[ATIONS Tyler Technologies applications are designed to operate on systems that meet specific requirements. Systems that do not meet the required specifications may not provide reliaWe or adequate performance, and Tyler cannot guarantee acceptable results. Tyler SaaSclients should disregard any references of "m-p�remises"specific requirements. Overview Tyler supports several server envkonment deployment types including bare -metal and virtuahzed environments, high ovuHabiHtycnmfi8urations, and dedicated testing environments, Production and non -production application emvironments(e.g. train, test) are deployed iothe same servers unless otherwise noted ordesired bythe cQent. Operating ���database, and application software isincluded for reference only. Itisthe client's responsiNlity to properly license all third -party software, including OS and RDBMS, and procure required infrastructure. The following server specifications are provided as general guidance only. Clients should contact their sales representative or Tyler's Deployment Department for approval of des�red configuration prior to procurement orconfiguration ufproduction infrastructure. 15 It jh t WO General Server Requirements General Requirements Servers VM's dedicated to Tyler products Microsoft Windows Certified Server (nationally recognized brand) External backup solution Gigabit Ethernet RAID storage Dedicated partitions for OS, Tyler applications, and databases Operating System Microsoft Windows Server 2012 R2 or 2016 Standard Database Software Microsoft SQL Server 2012, 2014, or 2016 Standard or Enterprise [1] Additional System Software Microsoft components including Microsoft VCSASP, Visual C++ Runtime Libraries Java Runtime Environment (JRE), Java Development Kit (JDK) [2] Network Environment Microsoft Active Directory Domain and DNS services GIS Environment [3) Esri ArcGIS for Server 10+ or ArcGIS Online [1] All Trier applications except iasWorld, SQL Server Enterprise Edition is only required for clients who wish to use advanced RDBMS functionality including SQL AlwaysOn Availability Groups for high -availability, and SQL Server TDE for at -rest data encryption. [2] IRE required on TCM and ExecuTime application servers only. JDK required on TCM application servers only, [3] Dedicated GiS environment is required for use with Munis MapLink or EnerGov onlIy. Installation and maintenance of GIS environment is the responsibility of the client. Hardware Requirements Munis — Up to 25 Users The following server infrastructure is required for a Tyler implementation sized up to 25 concurrent Munis users, Database, Munis Application& 1 4 32 500 Presentation Server Content Management Server 1 4 24 200 External Web Server 1 1 12 150 TOTAL RESOURCES, 3 9 68 850 Munis — Up to 10,0 Users The following server infrastructure is required for a Tyler implementation sized up to 100 concurrent Munis users. Database, Munis Application Server 1 4 48 750 16 City Sof'W? Bend, Pad Mllhrq ')YVcm Munis Presentation Server 1 4 24 200 Content Management Server 1 4 32 200 External Web Server 1 1 12 150 TOTAL RESOURCES 4 13 116 1300 Munis — Up to 250 Users The following server infrastructure is required for a Tyler implementation sized up to 250 concurrent Munis users. Database, Munis Application Server 1 6 64 1000 Munis Presentation Server 1 4 24 200 Content Management Server 1 4 32 200 External Web Server 1 1 12 150 TOTAL RESOURCES 4 15 132 1550 Munis — Up to 500 Users The following server infrastructure is required for a Tyler implementation sized up to 500 concurrent Munis users. At this size, Tyler recommends hosting non -production application environments (e.g. Train, Test) on servers separate from production. Due to the added configuration complexity at this size and larger, clients should contact their Tyler Sales, Representative or Tyler's Deployment Department for further consultation, Production Environment Database Server 1 6 64 1500 Munis Application & 2 6 64 300 Presentation Server [1] Content Management Server 1 4 32 400 External Web Server 1 2 18 150 TOTAL RESOURCES 5 18 178 2350 . .. . . ..... [1] A hardware load balancer device is . .. ....... required for multipie application servers. Non -Production Environment 17 (0y o/ Soulh M�od, IN Wr01 fWjiwp 1,yOcm Database Server z 4 48 1500 MunioApplication & ^ 2 4 48 300 Presentation, Server (1) Content Management Server 1 4 24 aoo External Web Server 1 z 12 150 �������..... �����..... .... ...... TOTAL RESOURCES 5 13, 13,2 2150 hardware load balancer device is required for multiple application servers, Server Definitions DatoboseServer (DB) Hosts Microsoft SQL Server for all Tyler application databases. SQL Server Reporting Services, SQL Server Analysis Services, and SQIL Server Integration Services may also be installed for use with select Ty|erappUcairnns. Munis Application Server (MAS) Hosts Munis application server and ||S; accessed via HTTPS. The K4un|sapplication framework should be installed vnthe same server aothe SQL Server instance used with K4unis, except when multiple MmnisappUcat)mn servers are used. Munis Presentotion Server (MPS) Hosts Munis presentation server components, and IIS. Additional Tyler applications such as Tyier Hub, / Tyler Parks and Rec and TyierIncident Management may also behosted mnthis server. All applications are accessed via HTTPl Content Management Server (CMS) Hosts web and application framework for Tyler Content Manager, and TylerForms, Ad6tional Tyler applications such as FxecuTime may also be hosted on this server. Afl applications are accessed via HTTPS. External Web Server (EWS) Hosts Tyler self-service applications, mmbi<e services, and ||S; accessed via HTTPS. ||5AAR may also be configured on this server to provide external access to some internal hosted applications (e.g. ExecuTimemnbiUe). 18 Chy ofsouih0end, IN Configuration Diagram ^ Web Server Internal Access internal Users Tyler Web, Application, &Database Components Emterphse'|eve[redundant storage aroysusinQhiAh'bandwidth iSC&l orfiber channel backend ounnec ion/s should he used for all Tyler servers. Diskhnput/output (1/0) performance is also important for successful dep�oyment of Tyler applications. Ty�er recommends Microsoft's SQUO Disk Subsystem Benchmark Tool to measure disk performance and provide minimum 10 to run Tyler appNcatioms. Recommended 1/0 The following average L/0measurements from a large sampling ofERPclients with good storage performance and shouldbe used as a guidelinewhen configuring storage subsystems. SK mPS 18000 2700 mx mBs/sec 140 210 en Avg. Latency (m,) 13 1 128K-0Ps 6000 8000 zamu Mu*seo 450 8O8 zzuK Avg. Latency (m,) 7 6.5 19 bly (),[ ��mW� Mmd, IN Virtuolizadiom Support VMwanevSphereand Microsoft Hyper-Vare supported for vi/tumUidnOservers. It is a requirement that virtuaUzedguests are given dedicated memory and host virtual CPUs are not over committed. VM provisioniing is the responsibility of the client; Tyler Technologies does not offer any tra�ning or instaflation services for VMware or Microsoft Hyper-V, Tyler supports a variety of high availability (HA) server configurations. Tyler's recommended configuration is a virtualized environment used in conjunction with replication products such as VMware Site Recovery Manager or Veeam Backup and Replication. For environments requiring multiple SQL Server servers, SQL Server AlwaysOn Availability Groups is recommended (note, A|vvayn0nreVuipes SQL Server Enterprise Edition), A hardware -based network load balance appliance is required when using multiple application servers. Clients should contact Tyler Installation Services when considering these advanced configurations. Tyler mhUwork with every client tnhelp determine the best configuration tomeet their infrastructure needs, however it is typically the responsibility of the client (or their hardware vendor) to configure advanced HAenvironments. NETWORK AND SECURITY REQUlREMENTS Tyler appUcabonscommunicate over T[P/|P.On-premises clients must obtain a1O24-bit(minimmm) SSL certificate for ail servers to encrypt application communication over HTTPS. External /Internet Application Access Tyler applications such as mobile apps and self-service web portab are commonly accessed from outside aclient's network. Ty�ersupports most industry standard methods ofproviding external access to on -premises applications. These options include, but are not limited to; hosting web/application framework inmclient's DMZ, nrbehind uclient's firewaUusing NAJport mapping, Application Request Routing (ARR)with ||S,and VPN. Deployment and network configuration ofmn- prem�sesTyler applications isdependent mn thedhent's preferred method of providing this access. Bandwidth Requirements Bandwidth usage can vary depending on application user type and their daHy functions. Based on benchmarks through Tyler's Sza5data center and Test Lab, Tyler recommends the following bandwidth requirements: Dent to Server: 0 Minimum: Mobile broadband connection 20 \ 0hy qf,soulh@end, IN 0 30 Khps per concurrent user session Server tnServer (on-pramiamsonly): ~ 1GBpsnetwork connection Tyler highly recommends sites with many anticipated remote users request bandwidth utilization report for at least 1 month of recent usage from their ISP to ensure they have sufficient bandwidth avaHable to meet these requirements, especially those considering Tyler SaaS Hosting. Application Authentication Microsoft Active Directory (AD) is required for a uthienitiication with most Tyler applications, Once a user is authenticated, integrated application role -based security determines what applications, processes, records, and fields the user has access to. on -premises deployments use the clients ex�sdngAD environment and end users use their own AD credentials for application authentication. Tyler servers and back -office IRP workstations must be a member of, or trusted with the domain used for authentication. Active Directory setup and maintenance isthe responsibility ufthe client. Tyler SaaS deployments use a dedicated Microsoft AD environment hosted by Tyler and end users are assigned Tyler specific credentials for application authentication. End users can set their own password; site administrators can create, disable, and un:ockuser accounts, and reset passwords. Tyler also employs a password policy for all SaaS credentials. Dedicated s6f-service applications provide external access to employees, vendors, and citizens. All self-service applications use application -based authentication. Administrators can create and maintain user accounts and for many applications, end users can register to create their own, Many of these applications include password contro/s to set password complexity, password expiration, invalid login attempt lockout, and allow users to reset their own password. On -premises deployments can also use Active Directory authentication for Munis Employee Self Service. E-mail Server Integration AnSMTP/|MAPema�|server isrequired for sending apphcatimnnotifications. Microsoft Exchange is only required for the following advanced Outlook calendar integration. Sites without Exchange can perform these tasks using an integrated application calendar. 0 Munis Scheduler Central used with Munis Permitting, Munis Work Orders and Munis Utility Service Orders. • K4unisWork Order Facilities room reservations, w Appointment creation on records directly from select k4unlonpp|irahons. a EnerGov inspection, meeting, hearing, and task scheduling. 21 City of Sooth8end, IN END-IUSFR RFQUIREMFNIS Microsoft Windows Workstation Requirements Workstation Microsoft Windows Certified PC (Nationally recognized brand) Processor Intel Core 13 1.8 Ghz minimum; Intel Core i3 2,5 Ghz+ recommended Operating System Windows 7 and later Memory 4GBRAM Disk Space 500 MB Network Back office workstations: Member of same domain as Tyler application servers Screen Resolution General: 1280 x 800 minimum, 1920 x 1080 recommended EnerGov: 1680 x 1050 minimum, 1920 x 1080 recommended; ePlans Review: 2560 x 1600 Required Software Microsoft. NET Framework 4.5 [2) Microsoft Silverlight 5.1 [3] Java Runtime Environment 8 [4] Productivity Software Microsoft Office 2010, 2013, 2016 Microsoft Office 365 (requires desktop client) Microsoft Office 2007,is supported for Excel and Word exports only; Munis add -ins are not supported 11) Meeting the minimum PC requirements will ensure the Tyler applications will operate, but will not guarantee performance. All performance and benchmark testing is done with PC's that meet (or exceed) the recommended hardware configuration, (2) Microsoft NET required for Tyler Cashiering only. [3) Microsoft Silverlight required for CAFR Statement Builder, Tyler Incident Management, Tyler Meeting Manager, and select EnerGov applicati°°ions only. (4) Java is required for advanced Tyler Content Manager functionality only, Browser Compatibility Microsoft Internet Explorer 11 Supported with all Tyler applications, Google Chrome (latest version) Supported with Munis, ExecuTime, select EnerGov applications, and self- service applications. Microsoft Edge (latest version) Supported with Munis, ExecuTime, select EnerGov applications, and self- service applications. MoAlla Firefox (latest version) Supported with EnerGov and all self-service applications. Apple mocOS'Workstation Requirements For optimal user experience,. Tyler recommends ail Mac workstations used for back office application access (those excluding self-service applications) leverage macOS Keychain Access to store 22 ("'ity of, 5outh Bend, IN [)Wfly billh)q credentials or an authentication solution such as Microsoft Web Application Proxy. Refer to mocos Limitations for additional information regarding using Tyler applications with macOS, Operating System macOS 10.10 or later Processor Intel Core i3 1.8 Ghz minimum; Intel Core B 2.5 Ghz+ recommended Memory 4GI3 RAM Disk Space Soo MB Screen Resolution General: 1280 x 800 minimum, 1920 x 1080 recommended EnerGov: 1680 x 1050 minimum, 1920 x 1080 recommended, 2560 x 1600 for ePtans Review Required Software Microsoft Silverlight 5.112] Productivity Software Microsoft Office for Mac 2011, 2016 Microsoft Office 365 (requires desktop client) [11 Meeting the minimum PC requirements will ensure the Tyler applications will operate, but will not guarantee performance. All performance and benchmark testing is done with PC's that meet (or exceed) the recommended hardware configuration. [2] Microsoft SlIverlight required for CAFR Statement Builder, Tyler Incident Management, Tyler Meeting Manager, and select EnerGov applications only. Browser Compatibility Apple Safari 10 Auto -updates must be enabled. Mozilla Firefox (latest version) Supported with EnerGov and all self-service applications. Limitations with macOS Some Tyler applications or select application functionality are not supported on macOS. This functionality can be obtained using alternative solutions such as RIDS to a Windows environment or "Windows on Mac" virtualization solutions such as Parall0s Desktop for Mac and VMware Fusion. Munis Munis is fully supported on macOS with the following exceptions: • Microsoft Office for Mac does not support connections to SQL OLAP cubes, Due to this Microsoft limitation, Mac users cannot access Munis Cubes. • Munis Next Year Budget Entry (NYBE) for Excel is a Microsoft Excel add -on providing one of several ways users can input and maintain next year budget data. This add -on is only available for Microsoft Excel on Windows platforms. 0 Microsoft SQL Server Reporting Services reports cannot be created or modified. Tyler Content Manager 23 (Jly tVcnd, IN 001ily d30imdj "y0om Advanced Tyler Content Manager functionality such as batch document scanning is not supported on maws, Mobile Device Support Tyler offers many mobile options to access select Tyler applications and functions from a mobile and/or touch -enabled device, Munis Application Suite Web App Web App Web App Web App Munis Citizen & Vendor Self Service Mobile Web Mobile Web Mobile Web Mobile Web Munis Employee Self Service Mobile Web Apo App Mobile Web Munis Field Inspector App App Munis Workflow Email App App App Munis Work Orders App App App Tyler Incident Management Click2Report App App App: Native mobile app available for download from respective app store, Mobile Web. Mobile optimized web site, Not all devices validated. Web App: HTML applications only. Not all devices validated. Not all web applications optimized for mobile devices / smaller screens. Some applications may require remote access configuration by client. Email: Munis Workflow can send emails with actionable links to process workflow from any device. P'IRIPH FRALS Printers Most application output can be printed to any printer accessible from an end -user's device. Tyler recommends laser printers for universal compatibility for all applications, Workgroup class laser printers are required for select print jobs, HP or HP Compatible Laser Printer Yes Yes PCL 5 or above TylerForms Output Management Printer Requirements TyierForms merges your application data with electronic form design templates. The, results can be printed to your existing network printers, regardless where the hardware is physically located in addition to automatically emalling, faxing and archiving this output to Tyler Content Manager. TylerForms offers several libraries of form templates that are tailored to work specifically with your Tyler applications. 24 (Ay qf Sood) Reod, IN The following technical specifications must be met for all printers used with TylerForms Output Management. • HP PCL 5e personality or language instaked • Automatic duplexing included and enabled • Minimum memory - 64MB • Minimum of 80 internal TrueType scalabMe fonts (80 HP font set) • Minimum of 2 full input trays (manual feed tray not usable) • Accommodates letter and legal' -size paper stock. • Printers must have the latest firmware updates installed Check Printers The following technical specifications must also be met for check printing with TylerForms Output Management. • HP brand black/white laser jet networked printer with static I address • High speed USB 2,0 port Note: Tyler does not support HP printers that have been modified with TROY brand or any other 3rd party MICR security features for check printing, Recommended TylerForms Check Printers Please note that some of the following printers may not be available from HP directly as they change printer models often. They are generaily available from HP resellers and other retailers even if HP no longer offers them directly. HPU 3015x HPU M606dn* HPU M609x* HPU M501dn* HPU M607dn* HPU M712dn HPU M506dn*HPU M608dn* HPU M712xh HPU M506x HPU M608x HPU M806dn HPU' M605dn*' HPU M609dn,* * An additional input tray is required to meet the requirement of two full input trays.. Other (Non -Check) TylerForms Printers Some non -check form designs required duplexing capabilities. Munis is designed for and guaranteed to work with approved HP black and white laser jet printers meeting the minimum requirements. For non -check forms Tyler will make every effort to print to other networked printers if they meet the technical requirements. While Tyler routinely and successf0y print other forms to many brands of laser printers, if we are unable to print to a printer on your site, clients may be required to provide an alternate printer. 25 f. ly o.f' SC)vl h fd¢:'wl' /[V MiMr J f4ft oq ',yr�,t(-'w Tyler Content Manager (TCM) supports two methods of batch scanning documents, Documents can be scanned to a file system (e.g, network share), then batch imported |n1oTCM. Documents can also bescanned directly into TC&4using ascanner attached toaworkstation. The first method only requires a scanner capable of scanning to a file system. The second method reqmiresaTVVAiNcompliant scanner, though Ty�mrhighly recommends usln8anapproved scanner referenced in the Scanner Compatibility Chart below for full functionality, Tyler also recommends verifying driver compatibility with your operating system for any scanner considered. Canon cm9M Dn2s/oc nR'3O10C nn4nznC ox-5Vzoc DR-60S,OC DR-M14U onmza0 oxsoxoc Fujitsu F)-5750C R'59DDC R-59gOC R-6040Z FI-6110 Fi-7180 F|'6z10 Graphtex cssoopru* Hewlett Packard (HP) Scmn1et82s0* 3cvnJet*3S0* Panasonic xvs7075c mcS5m46n xv-sznm7 Xerox mocumate1s2* DR-7550C on7soo on-9nsoc on-9O8OC nn-mzsu DR-X18C mxC-125 DR-C175 R-6240Z R-677O pF/26m R-7280 m-51057C KV-S1027C m-Szousc * Not fully supported, These scanners have not been tested in our lab. They are in use by one or more customers and may have issues that have not been reported. Batch Invoicft using TCM requires a desktop bar code label printer for each workstation that enters invoices. At the time ufinvoice entry, u p|areholderdocument iscreated inTCM and the printer prints barcode label that's affixed to each invoice. When batch scanning / importing to TCM, the barcode is used to automatically link the invoice to the respective apphcation record. M. Qly (!�J�SoothBend, W Wh|�auny label printer capable ofprinting PDFimages will work, Tyler recommends one ofthe following certified models. zebmsx4zod Zebra z-Srlect4000na^xu^labels. Mfg. Part: z0oz0043 Mfg, Part: 5%42-202411-OUG Brother QL-700 Brother DK-1201 standard address labels 27 (4W�th Heloy, IN (4)Described mn'preNmiseversus software delivery options, Features and functionality are identical for on -premises and Tyler SaaS hosting. The biggest differences between the two hosting options are cost, infrastructure setup, and administration. On -premises clients license the software and pay annual maintenance that includes nokvvane support and future application updates, Tyler SaaS clients pay an annual subscription that also includes software support and application updates, but also covers hosting and administration for all Tyler applications. On -premises hosted clients are responsible for setup and maintenance ofall infrastructure, networking, and third -party licensing (OS, KDWK4I). Tyler SaaS hosting includes the following: w System Administration. Tyler performs daily administrative tasks. We address the installation, upgrade, support and file maintenance of the Tyler appfication and database servers, operating system, database and application fi{es. • Security Administration, Tyler provides secure data transmission paths from each client workstation tothe Tyler servers. 'User ids, passwords and appUcationaccess rights for the VPN and the Tyler application are administered by Tyler with the client's final approval. � Hardware Performance Maintenance. Tyler supplies and maintains all necessary hardware required to provide workstation acce,ss to the Tyler applications at standard industry ` performance levels. All repairs, upgrades, and replacements to server hardware are the � responsibility ofTyler, � � Disaster Recovery & Fault Tolerance. Tyler backs up all system & data fiIes and stores them in secure off -site location. We have fuDyredundant telecommunications access, electrical power, and required hardware to provide access to the Tyler applications in the event of a disaster or component failure, |(5)'prmvide a system overview, including amoverview ofthe tecbnicaUarchitecture and the proposed hardware environment; Tyler applications are multi'tiened, typica|iymnsisting of a 3-tier architecture; web, application, and database tiers. Tyier apphcations are deployed exclusively on industry �ading Microsoft stack uf technologies, utilizing Windows Server, SQL Server, Active Directory, Internet Information Services, Office, SQL Server Reporting Services, and SQL Server Analysis Services. Most industry standard server deployments are supported including bare -metal and virtualized environments, high availability configurations, and dedicated testing environments. 28 Cify of,Sou th Brmd, IN ~/ UtJxy80img�n/rm (6)describe each software module that iobeing proposed; /1,3 MUN!SNTl[|Ty B|LL|NG[`|S MunisUtility Billing Customer information System ([|S)streamlines theoomp|exprpcedu/ns associated with billing, scheduling and reporting utilities, and puts the focus onthe customeo. K4unis provides the tools tneasily maintain customer accounts, track service orders, generate utility bi|Is, and collect fees. Billing clerks, service managers and utility directors have access to detailed information in a seamless, real-time and intuitive manner. And local governments increase transparency and improve customer ser0ce. L"ca|G'wernments Simplifies the utility billing process * Accelerates revenue collection �Improves productivity, efficiency & responsiveness u,citizens Reduces redundant data entry and creates a"single version 'f the truth" wPuts the focus omthe citizen to * Automates repetitive tasks & improve customer service enhances workflow wEnables fast, informed decision - making 421. MUN|S [Ti |L|TYBILLING CIS Improves access to utility, account & payment information * Enableseasy bill payment �Increases confidence &support in utility services Utility Billing 0S processes all biHing functions easily, quickly and accurately. With it your staff can perform expected tasks such as billing water, sewer, electric and gas; and maintain muKip�e billing cycles active at the same time. Robust functionality enables users to manage all aspects of utility billing with features including easy account setup to view past, current and pending customers, easy access to all service deposits, assessments, and installments; as well as unlimited user defined fields for account location master, account customer, and services in a variety of areas. With centralized accounts Utility Billing CIS simpN0esproperty management. Integration with other K4unixprograms provides additional benefits: 0 Access usage and billing details, enter service requests, and pay online via Citizen Self Service a View billing history with images of past invoices through Tyler Content Manager (TCM) 0 Online payments flow directly into general ledger through integration with Tyler Cashiering and Accounts Receivable 29 O1'y of South Vend, /N w Track site access and repairs through built |nService Order tool * Verify address through MupUnkintegration • Set rules for bill adjustments and service requests using Workflow • Option todeliver bills via e-biHinA • Manage cut off selections, lien collections, and all notifications out of the account management screen * Interface with Tyler Notify provides reliable customer notification regarding late notices, service interruptions and other account notifications a Schedule service visits and inspection through Scheduler Central /1.3 Tu|RD P«RTYNTEGKATI(jN K4unisoffers avariety ufmethods ofinterfacing with external third party systems, including file -based import and exports and real-time integration usingweboervices.lhlslndudespre-deMned integration points out ofthe box, requiring little ornmsetup tmmany popular third -party systems such asMicrosoft Office, ElR|ArcG|Sand KrnnosTime and Attendance, Full Integrated ERPS61udjon When evaluating a new ERP system, it is very common chents are looking to replace several disparate systems with a single, integrated ERP. Since everyK4wnis application is integrated with one another, � sharing a single database, many existing interfaces are commonly eliminated when moving from several disparate systems. For example with Munis, an employee raise initiated by Human Resources personnel action, automatically updates Payroll and the General Ledger. File -based integration Munis includes a number of file -based interfaces which are performed using integrated Munis applications and geared towards end users rather than IT staff , Rather than needing your database administrator \oimport orexport data directly tuarfrom the system, most file -based interfaces include the ability to define and choose from interface templates. These templates define the order and1ypeofdalabeinginterfacedoofNexdon'tneedtohe|nn"Munisformat"andimsteadaUovvs users to choose the appropriate template for the system being integrated with. Munisalso includes interface templates for commonly used third -party systems out of the box. Munisimport applications import data into averification table within the database, which then processes any applicable workflow rules, Munis Workflow can be configured to notify or require approval based on any number ofbusiness rules xpedfictnthe data |mported. Business rules can be set on a variety of data conditions including whether data brings an account over budget, is over a certain dollar amount, or affects a speclfic department, commodity, or object code. After all workflow actions have been approved, imported is then moved into production database tables. Depending on the process, imports can also be rejected at the item or file level. Rejected imports can be 30 � Cily of''SouthWend, IN resubmitted at any time, Imports and exports can be scheduied for a one-time or recurring, automated interfaces, Microsoft Office Integration you use Microsoft products every day, so Tyler designed applications to easily integrate with, the Microsoft Office suite. Data can beexported toMicrosoft Word directly from many Tyler applications. Some appUcatioms even leverage Word's mail merge functionality ailowing users to easily create and maintain form templates for near limitless presentation options of application data. Word Mail Merge exports, also seam�essUyimteArate with Tyler Content Manager bvstoring electronic copies automatically. Microsoft Excel can be used with Tyler applications in a variety of ways. Many Ty�r applications allow users to easily export application data directly to Microsoft Excel. Excel exports aren't just raw data dumps; data is formatted acrnrdin&tn its original data type—daien are dates, currency is currency — and many exports include link back tothe correspondm8 record in app|icabom. Microsoft Excel is also one, of mainy formats supported for bulk data exports and imports, which can also be scheduled to occur automatically. Munis also offers an Excel add -in to process Next Year Budget Entry directly from Excel over web service, saving from having to retrain users on basica:ppUcaUom navigation each budget season Finally, calendars iomany TV�erapplications don't just work like Microsoft Outlook —they are MicrosoftOutlook. Full integration with MicrosoftExchange meamocalendar appointments and meetings, vacation requests, and workflow are fully synced with users' daily schedules. Some Tyler applications mciude Email and Schedule buttons allowing users tmeasily email record links or schedule an Outlook appointment regarding specific record set respectively. Finally, email notifications and alerts can besent using most email servers, including Microsoft Exchange. Direct Integration and Support Tyier has heavily embraced web services for use with application architecture and integration with other applications using industry standards. Munis includes arobust and growing library ofXK4Lweb services and leverages them for real time integration with third party systems through "plug and play" interfaces, SetUngmpanapp||caL|on|nicrfacmw|thimK4unbisassimp|easmpeninDanapp|ioa1ionsoreenand entering afew settings specific to that interface, Tyler develops and maintains all application interfaces clients, saving cflentsfrom worrying about APIs that require deve|mpmentsU|sets' and maintenance any time asystem changes, This includes all state and fudera8|ymandated interfaces included as part of every clients maintenance agreement. Tyler regularly works with state governments and vendors asthey develop strategies for sharing/obtaining information with local governments via, XMLand web services toensure our products comply with these spedficatiomsas they are introduced and continue tumeet our clients' changing needs. (1Q)describe the proposed implementation approach; 31 0�9ƒ�,ouffi Ml)(J, IN Tyler's implementation process demonstrates our long-term commitment to our public sector dlients. - Our imnp|ementabunprocess isaproject roadnmapthat takes you from software installation uptothe dait&normal use ofthe new software system. Tyler's goal istoprovide the best software, services and support to you, our clients, Your organization benefits from the fact that vva perform our own implementations and know our software better than anyone. Asa Tyler dient, you receive guidance throughout implementation from experienced Tyler professionals who have implemented TyIer products |nmore than 8,O0Opublic sector implementation projects. Tyler utilizes a proven stage -driven implementation approach., An approach of this nature is preferable because it allows for ongoing validation of system decisions throughout the project as improved knowledge islearned and shared during each stage. The stages build onone another, alIowing the project to progress with the goal of delivering a refined and mature solution which meets your policies and procedures, whHe taking into, account best practices recognized iin the industry. Moreover, this approach ensures that process -specific details are mastered prior to moving tneach subsequent stage, Aformalized sign off process, defined bymajor objectives, deliverables and outcomes, isthe key tnasuccessful implementation. Methodology Tyler's methodology bstraightforward and based nnthree vital foundations: industry experience, expert resources, and a globally -recognized project management approach. We combine our in- houseexperbseinsoccosofuyimp|ementat|nnsandimteQnatei1wlththeprinc�p|esofthe9mojeot Management InstituteO (PMI), a globally recognized organization dedicated to the project management profession, Ut|ldngthe five process groups outlined imthe PMI's pM80KI(ProjectMonugemen{Body of Knowledge) Guide -- Initiating, Planning, Executing, Monitoring and Controlling, and Closing -- we deliver a tested and proven approach to, every project. We have integrated industry tools and technologies from PM| with Tyler's implementation experience, toyield a proven approach that is tailored specifically to the public sector. Our project managers are trained to maintain the professional standards ofPML Tyler's trained personnel perform and guide all aspects of an implementation. Our staff consists of seasoned professionals with years of experience, and unique and proprietary skills, specialized in managing and delivering projects focusing onyour business processes. Our implementation processalso emphasizes the importance of cultural change management. This is how we guide you through the changes that accompany impIementation of a new software system and help to ensure a smooth transition. Our implementation staff is experienced in analyzing policies, procedures, and organizational needs. The proof of our approach is in the outcome — a successful implementation. 32 0y��ulh Bend, HV Thnnwghoutaproject, weestablish cnninoI po,ints(critical review points) bzensure your or8an�zotom fully understands and accepts the project progress. It is atthese check points that your stakeholders monitoring the overall project must formally accept the project to date. Once there �s formal acceptance, the project will proceed tothe next stage. Tyler takes pride |nour implementation procmssandddkmmb|es.VVefocunnnynuamdsetdm8youup for success. Our product experts strive togain understanding ofyour needs and current business practices, while recommending best practices to best leverage your new technology. Our implementation process positions you to successfully utilize Tyler products at go -live and to consume the new technology developments delivered through our software releases and upgrades, Implementotion Methodology Overview The Tyler approach, buflt upon PIVI I process groups and our industry expertise, is dep�cted on the following high-level iHustration. 33 ")"Outh Peta), IN U/Vky8N0�g1yscm � Work Breakdown Structure � PKA| utilizes Work Breakdown Structure, orVVBS, todepict overall project work, Tyler uses this key PM| tool to show our implementation approach in greater detail. 34 \ y City oJ '50tah Bend, //V Jtaoe2: Initiate &Flan This stage ofthe implementation proceocmmmencesomceacontrac1hasbeensigned.Thepnojec starts with the implementation team comprised of your executive sponsor, project leader and the Tyler project manager, who work together to define project expectations and establish a baseline project plan and schedule, During the Initiation stage, the Tyler team leads discussions with you to begin system infrastructure planning, outline goals and timelines, and finalize processes for the implementation ofall products imthe scope ofthe project. &xpart ofthe Planning step of this stage, project stakeholders within your orgmnization are identified. These stakeholders monitor the overall project and are essential to a successful implementation, They ensure that the project is aligned with your larger goals. This group, in conjunction with Tyler's project manager, is responsible for monitoring the project and providing formal acceptance of each stage, Once stakeholders are determined, functional leaders are chosen for the project to provide expertise on your business processes, Implementation Management Planis are provided to all, which outline the management ufscope, schedule, VuaUty/ esLmg, resources, communication, upgrades and risk. These plans may beupdated incooperation with the project team. The Planning and Initiation stage concludes with a high-level project schedule Stakeholder Presentation twall nfyour key project stakeholders, Stage 2/Assess fDDefine The Assess and Define stage starts with a fundamental review to provide your project team with a preliminary knowledge transfer of how the system functions, The goal of this stage is to exam�ne and analyze your unique business needs and to translate the findings into a system design plan as an output. Ty|er'scnnsu|tants and your subject matter experts perform a Current/Future State Analysis of your current and required future business processes. The system design plan addresses key business drivers, which ensures that all requirements for a successful implementation are presented and accepted. Additional outputs of this stage consist of a plan addressing and identifying data conversions, standard data exchanges to third party systems, and formis and reports. The Assess and Define stage concludes with a formal acceptance of the defined deliverables and project outcomes. Stage 3:Build 60W78dote ARerthexystemishui|t,yourintmrnu|teamwi||vvorkw|ihtMeTy|ertoam<oesLabl|shandvaKidate the system configuration and complete due diligence for systems readiness during the Build & Validate stage. Your project staff validate the system design, converted data, standard third party data exchanges, forms and reports. Astrategic component ofthis stage ensures the key individuals are trained and enabled for self-sufficient system operations. Once trained, validation and testing procedures commewce|nan|temUvefashion for data conversions, third party data exchanges, employee and citizen -facing forms, and key stakeholder reports. 35 City (,q Soulh fh!nd, IN This stage is considered completed when the primary/key users have reviewed the system configuration toensure that they are |nalignment with the business processes, goals and objectives nfthe project. Stage 4:Finol Testing & Training The Final Testing &Training stage lndesigned tofacilitate maximum, knowledge transfer. Together with the Tyler project manager and implementation consultants, we will develop a cutover plan which will detail the critical items that need to be completed in order to go live, such as: final trainings, interface testing and validation, conversion cutover schedule and timing, User Acceptance Testing (UAJ)and the training schedule toroil-out the system Prior toend-user training, your users will follow detailed test scripts through aUATprocess toensure proper validation of the system is performed. UAT ensures that all data and configuration needs have been met and that the software is ready for day-to-day business processing. This stage concludes with final training for your end users and formal approvalufthe system's readiness to support your business processes prior to moving forward to go -live. Stage 5:Production [utover The vital stage ofProduction Cutuveriscomprised ofproduction and post production support. Bna| data conversion is completed as necessary', All the, prior training and planning now culminates as your organization is seff-sufficient within the new Tyler environment. Now you are operating in the production environment with the support of the Tyler project team. If required or planned ulpon � during the initial stages, post -live education and training isimplemented, � The phase closes with atransition tothe product support team. Stage, 6: PhaselProject Closure The final stage of implementation, Phase/Project Closure, is to bring a formal closure to the project phases, or to the whole Tyler implementation if no additional phases are required. Through a formal project close-out meeting and acceptance from stakeholders, both teams formalize the completion of a successful Tyler implementation. The deliverables, completed through the project close-out meeting may include such topics as lessons learned, a review of accomplishments and final acceptance of the, project work completed. The data conversion process can bethe most time -critical element mfyour project plan. And assuch, Tyler develops crucial steps inour implementation procex tosupport asuccessful data conversions plan, Our resources conduct hundreds of data conversions for our implementation projects every year using a process involving data mapping from our clients' legacy system and programs/scripts written byour conversion programmers, 36 \ 8 (ify (4!)outh Bend, IN / 000�1 f0h Sy�,km While Tyler's data conversions teomhas extensive experience with data mining, conversion and migration, it your responsibility to provide Tyler with readable conversion data and' to review the converteddatafpreccu/aeyamdcunopleteness.YourTy|erimp|ementadon1eannguidesyouthromgh the process, starting with conversion analysis and mapping, followed by interactive data conversions and valiclations, and ending with final testing and loading into your production environment. Within three implementation stages, critical data conversion work packages outline the steps needed. Tyler does not provide services fordataex<ractionfrormyowrle8mtysyskym.Yourprojeetteann resources are responsible for extracting and providing the data from the legacy system tmowrin- hmusaconversionteamintherequiredformais.VVedomo{par<mervv|tbthirdpudyproviderntooffer thhsserviceandthus,camnmtidentifythenesourceo.VVecanrccommendturrenicUenLsvvhohave utilized third party services for more research nmthe client side. 4.5.1 AsSESS AND DEHNE: DATA MAPPING AND DEQGN At the beginning of the project, data from your legacy application is mapped to the Tyler system, You will be expected to ensure that the data extracted is well defined and conforms to the same format with each extract. The Assess and Define stage sets a path which, when followed precisely, leads to success with subsequent conversion activities in the remaining project stages. Th�s critical step includes, but is not limited to: 0 Comprehensive mapping and migration of legacy data • Creation of a road rnap defin:ing conve,rsion approach, data extract strategy,conversion and reconcNiatimnstra1egy • Outline of migration mandates and best practices govern�ng the layout of the destination storage environment Such communication will incUude: w Comprehensive review and evaluation of legacy system data with specific attention to general data quality, viability and identification of overt "scrubbing" necessities Tyler's conversion programmer examhnesyour data files and layouts, and uses the supporting materials to interpret, crosswalk and generally re -arrange the data from the legacy system into the new database. Working collaboratively, the tearns address conversion errors and report discrepancies. This iterative data conversion and validation stage includes: 0 Data loaded, tested, reviewed, and validated 0 Stakeholder acceptance of data quality, viabilfty and operability Much attention is given to data integrity during the testing phase by the conversion developers. The conversion developer spends time testing to ensure the data conforms to the database definition and standards. Your team and the Tyler implementation team work on testing the balances and output of 37 City ql'�(xdh lfefuJ, IN � processes after the conversion to allow you to be confident that the avakable datawas captured accurately. The final step in the process is the final data conversion into the production environment. Tyler extracts a final data packet, thus transferring ownership and maintenance of the data to you for all data in the Tyler system. Depending onthe scenario and bmefranne,you may need to manually create new record toreplace umelement that Tyler was unable tnconvert orwas created in the legacy system after the final data extraction. 4.5.4 DATA CONVIERSION STANDARDS Data Scrubbing and Reports Tyler /eoonnnmendsthat you conduct due diligence toensure that your team delivers clean data, us this will make data validation efforts more seamless and result in a higher quality migration. We recommend creating control reports and screenshntsfor use in proofing the conversion later in the process, Your team and the Tyler Project Managers decide wMch reports are required. For verification purposes, it is imperative that reports for proofing be run at the same time that data is created for transfer to Tyler, There should be no intervening transactions posted between the data transfer and the reporting. We emphasize this point as it is difficult to match the data to the output ` on the report if these standards are riot met. 4.6 TkA]0|NG/lPPR0A(I-I Akey part ufany implementation is training users at all levels. Fully trained users understand how to uooynurnuvvnoMwaresystenntorocordandrepmrtinfommadonthathe|psthemtodotheirjobs better. This is critical to user acceptance of the system and crucial to a successful implementation. Tyler offers several training formats toaccommodate our diverse dients'needs. Onehetminhng by Tyler staff provides hands-on learning in your own labs. Tyler also provides flexible alternatives including remote collaborative training technology, and may offer vIdnoand software tutorial media. Regardless of the scope or logistics, your resources receive consultative knowledge transfer sessions that are a combination of lecture and hands-on education, using your data., Tyler requests that managers attend training with their emiployees, This ensures that the managers can confirm the proper tra:nsfer of knowledge has occurred. This also allows employees to ask the manager policy- reIated questions about how the system will work within their department. Tyler has developed a dynamic set of training and education resources and services that are tailored to your needs, the Tyler products you are implementing and the scope of your project budget, 38 � (Ay gfSouth Bend, IN 4^7 TRAINING MBH{)DOU]GY A mutually developed education plan lays out the process of transferring knowledge between you andTWcr.VVeroferhoourp|ananmn°educationp8an°asopponedtma~trainingpXan"forsevem| reasons. First, the process of transferring knowledge is vital to the analysis phase of our project. During analysis we rev�ew the current environment, provide Tyler demonstrations, review questionnaires and flow charts, and ultimately arrive at a future state model. The future state model becomes the foundatmnfor user training. Second, training denotes aclassroom setting with teacher and pupil. While trainiing will occur, it is only a piece of the overall education needed to be a proficient Tyler user. Tyler believes inatraln-thetrainerapproach tmimplementation. This approach allows your resources (the Power Users and Functional Leaders) to be involved in the initial training and software configuration while limiting the amount of time that End Users are involved in the project. The Power Users and Functonal Leaders are then mvolved in training the end user community after all configuration is comphete, which heips to increase adoption, solidify knoMedge transfer, and lessen resistance totraining and process changes. Purpose The purpose of the education plan is to: • Communicate the process tostakeholders and functional leaders ° Answer specific questions (where will classrooms be established, what database environment will bemti|hzed'etc.) • Establish action items and link project personnel nsowners • Define measurement criteria to ensure the p�an has been successfully followed 4.7.1 FUNDAMENTALS REVIEW 8mthis step, your functional leadsandpmw ruenbecomefami|iarwhth the new Tyler system and its capabilities, language and processes before the start of the current/future state analysis. This allows users on your team to better engage with the Tyler implementation consultants during regular training hours, empowers your staff with experience and a more complete understanding of the system, and provides a strong foundation for ongoing conversations regarding the future state processing. Fundamentals review eases the transition into implementation and training, garnering better results and agreater understanding of new processes. Goals ~ Learn general Tyler Technologies terminology m Experience the basic functionality Vfyour new software solution m Explore the configuration options including data flow, connectivity, etc. * Fncourage discussions Mthin your organization of desired configuration for design and future processing Discover sorne of the software capabilities available for consideration 39 0yol South IN 0 Improve communication between you and Tyler through software knowledge This stage enables your power usem1ovalidate the new software based upon the output from the future state ana,lys|s.&high-level explorationofthe system results ingreater comprehension and retention of system features and functionality. Configuration training may include data conversions validation, configuration validation testing, third'partydata exchangeva|idation, forms/reports validation and cmstpm|uai|onvalidation. 4.73 TRANTHETkA|NER Tyler provides training to functional leads and power users throughout the impIementation, as the set-upknuw|ed8eiskeytoase|f-sufAdemtunecTy|erprovdextrain�ng0oynur|nterna|iraimar4whu in turn train the end user community. End user training isscheduled during the project and is usually done just prior to, orjust after, going live. TraWng materials will be provided and may be customized prior 10this training, Benefits • Powers users become |mmodiate stakeholders • Training between the power users and peers creates a comfortable environment � Reduced learning times and more flexible trainingscheduHmQ � 4.7A TECHN|CALAND SYs"TEK4/\Uk8|W|ITRATOMTRAINING Technical training begins, at the time of software installation. Tyler's installation team teaches the technical staff how the software isconfigured within the operating system, anwell asbasic system maintenance routines such as backups, loading releases, and refreshing training and test databases. System administration training is conducted after software installation to show usershow 1nupdate users, permissions, menu security, workflow administratIon, etc, from within Tyier's software. Your System Administrator necesnarDyattends these sessions; functional leaders should also attend to have a thorough understanding of the permissions and options available. 4.7.5 END[]SERTRA|W|N6 After the functional leaders and power users are trained, the system parameters and tables are set wpand/or converted, and processes anede0medandtested.EndumeoattendappAtaNeschndu|ed training. Many agencies conduct this training prior to go -live oothat these users may assist |n system testing and verification, and become familiar with their new processes. 40 \ City qf soull)0md, IN d., 8 SCHEDULING AND ATTENDANCE Tyler prefers aclassroom amdcurdcu|umapprouchfuronaitetrainin8tuensmo*knowledAetramshsr, comprehension, and retention, A successful user trahninE session is �n a classroom environment with a computer for each user (minimum of one computer for every two users, but ideally one per user), a whiteboard, a printer in the room or nearby, and one computer connected to projector. The s�zeof the class depends on the classroom size and the available computers for training, Ideally, a class size should be limited to tweUve (12) users in order to keep the ses5�on controfled and ensure that all users are receiving an appropriate �evel of personalized attention. The specific course topics are discussed and scheduled after analysis, depending on your agency's specific training needs. Attendance to the training is critical during implementafion, By participating in training courses, your emp|oyem*&a|ncMdca|handoomexpeMencevviththesysbem,amd|eerntheTy|urapprmach.Ty�e/s training staff will take attendance during classes, and relay that information back toyour Project Manager for review, This ensures that users get the complete benefit of training and reduces support incidents after Ko-|ive. 4.9 RESp[)NS|B|L|T|ES Both teamscollaborate onall aspects oftraining which will bediscussed and documented during the planning stage of the project, The expectation is for Tyler to provide one occurrence of each schedu:led training. You will be responsible for the logistics of the trainihng by completing such, tasks as scheduling resources and ensuring facilities are avaflable. These sessions are to be attencled by your key staff members so that they can then disseminate the information they learn to others in your organization if or when necessary. Tyler knows the value of being prepared for the use of our software in production, so we contribute to an ongoing education effort by recommending functional processes to be presented to specific departments, and share training materials used during our sessions. Our goal is to partnmrvv0 you and lend our expertise and best approaches based on our experiences, hnorder toallow your resources tobesuccessful at go -live. Changes tothese expectabomoare discussed during project planning, and are based upon your specific business environment and resources. 41 (JI yv/Sot� 11) Pei u], IN Section 5 01)"VIONAL SOLUTION Describe any optional solutions that are not included in Vendor's base, proposal. Tyler provides the lndustr/sbroadest Uineofsoftware produots, and offer clients asingle source for all their information technology needs, in several ma]mrareas: Financial & Human Resources, k-12 School Solutions, Public Safety, Courts & Justice, Property Appraisal & Tax, Permitting &Land Management, Public Maintenance Management, Citizen Services, Land &Vi1a| Records, and Document Management, 42 � ("fly@�mu[hBend, IN Section 6 PROPOSED STAFFING AND PROJECT ORGANIZKrION This section of the proposal should establish the qualifications and time commitment to project of the proposed project implementation and support staff. This section shall: (1) provide education, experience, and applicable professional] credentials of proposed project staff; 6.1 TYLURESOURCES Tyler actively seeks the best talent to help, us develop, implement and support our solutions for our clients. Our staff consists of seasoned professionals with unique and proprietary skills, and years of industry experience, who are focused into dedicated departments. Our product expertise is strengthened by the fact that many of our employees have, years of experience working at public sector agencies prior to joining Tyler. These professionals bring a unique perspective to Tyler's mission because they truly understand what our clients need to operate at their best. We recognize that our ability to hire the best candidates ultimately impacts our clients, We hire exceptional people who become part of the project team for the duration of the project. Upon award of contract, Tyler Technologies assigns a Project Manager and quality project team to ensure your implementation success, In reviewing and understanding your goals and requirements, we provide an implementation team best suited to deliver services to achieve your needs. We believe this is an important step in the implementation process aind appreciate your patience as we make arrangements for resources to be allocated to your project. Tyler staff perform services in a professional, workman -like manner, consistent with industry standards., Name Title Education Home Office Tenure Previous Experience Qualifications & Technical Skills Reference Projects Kathryn Implementation Director - Revenue Southern New Hampshire University Iowa City, IA 18+ Years Manager— Environmental and Business Development— 5 years Project Manager for more than 500, Munis/FnerGov Projects, Project Management Professional (PMP)O Proficient in MS Office, MS Project, Schaumburg, IL Anderson, IN Las Cruces, NM Broward, FL Tulsa County BOCC, OK Tatum ISD, TX Name I patty 43 City (�f Sotdh 8end' IN Mdil!y 1h1h1q) 'Sy�'fvlo Title Project Manager Education Quincy College Home Office Yarmouth, ME Tenure 10Yeam Previous Experience Project Manager —HRConsulting —5years Qualifications Q Project Management Professional (pKAp)O Technical Skills Proficient in MS Office, MS Access, &45@sim, 5SRS, OneNote 8us�nessProcess Consulting Experience Reference Projects Hayward, CA Hopewell, K4 Hollandale Beach, FL Gillette, WY | Sweetwater County, N/y Grove City, OH Name Kimbefly Title |mA|emantadonComsuUiamt Revenue Education University nfPittsburgh BS-ComputerSciemme BS-Accounting Microsoft Certified Trainer(KA[T) Home Office Pittsburgh, PA Tenure 3Years Previous Experience |TManager cfacontract packaging company 27years -Adjunct Instructor for Penn State Con(inu�n& Education Program -Adjunct Instructor for Allegheny Valley Institute nfTechnology Qualifications 8^ Microsoft Certified Technology Specialist (M[TS) Technical Skills Microsoft Certified IT Professional i(MC|lp) Reference Projects Bristol Township, R4 City 4fMonrovia, C4 City *fFlorence, S[ Prince George County, K4 | City ofLafayette, /N | City 4ƒLancaster, PA Name ]ennMer Title |mp|ementabmnCnmsu|tamt Education University ofMaine Home Office Charlotte, N[ Tenure 5+Yeam Previous Experience Accounting Manager—Sea[mast Management —4years Qualifications, 8^ Proficient in MS Office, Technical Skills Business Process [mnsuffin8Experience Reference Projects, Bountiful, UT Cambridge, MA 8oyumnd, CA Wichita Fulls, D< | Allen County, QK St. Augustine, FL (2) furnish brief resumes for the proposed Project Manager and mthur key personnel; 44 uhy of ScqdIN The resumes presented above inthis pro posa| reflect the ra|iberand experience that TyierwiUassign to this project,. Tyier managed employees implement al I of our projects rather than the need of a third party implementer orintegrator. Due b/the variable duration pfselection and contract processes, it is difficult for us to predict resources that would be available at project commencement. (3)indicate adequacy oflabor resources, utilizing atable projecting the labor hour allocation tothe project by individual task, see Proposal Form F; Tyler Implementation Methodology groups your team and Tyler resources based on their functional role within the project, This aUmwsfor easier staffing and communication both within and between the project teams, All pricing, including the daily rate for implementation consultants are shown in the Investment Summary. Our project approach is based on our experience and knowledge from working exclusively with public sector clients, Project Staffing Levels The amount of time each resource will actually spend working on the project will vary greatly, but the attached Form Festimates the hours, Within each phase time will vary from one stage nfthe project to another (e.g. Functional Leaders are more involved in the early analysis and planning while as Power Users are more involved later inthe pnoject) Task Description Vendor Sub- Hours Contractor Hours ity Staff Hours Fit Gap Analysis 142 NA 225 Functional Design Non -Production Environment Testing 283 142 142 NA NA NA 451 225 225 Training 354 NA 563 System Cut -Over to Production 142 NA 225 Final System Acceptance 71 NA 113 Mernos, Notes and Contact Records See below NA See below Employees See below NA See below Customers See below NA See below Accounts See below NA See below 45 � 0lyc'f Souolh8a"6AV Premises and Service Points See below NA See below Dunning See below NA See below Financial History - Payments, Billings, and A4justments See below NA See below Rates See below NA See below Meter and Device Inventory: Installed and Stores See below NA See below Meter Reads and Consumption History See below NA See below Service Order History See below NA See below Deposits, Auto pay See below NA See below Documents and Attachments See below NA See below All Conversions in scope 301 601 Integration Interactive Voice Response (IVR) — Outbound Dunning Supported, assuming use of preferred IVR vendor and assuming this is a delinquent account listing Vendor Sub- City Comment Task Description Hours Contractor Staff Hours Hours Interactive Voice NA Outbound Leak Response (IVR) — notification not Interactive Voice NA Supported, assuming Response (IVR) — use of preferred WR Meter Reading NA Standard Bill Printing NA Standard export Collections Letter NA Standard Excel export/MailMerge Payment File — FirstSOL11-CC NA Supported, assuming use of standard Real -Time Payment Posting NA Supported assuming use of existing Payment File — Metavante NA Supported, assuming use of standard Payment File — NA Supported, assuming Checl,,Free/Fisery use of standard Payment File — BillPay/MARS NA upported, assuming use of standard Payment File — PayNearMe NA Supported, assuming use of standard ACH Withdrawal — FirstSource NA Standard export 46 (hV fh,!nrl, IN