The URL can be used to link to this page

Home My WebLink AboutFourthSquare Response to CITY OF TWIN FALLS, IDAHO CITY OF TWIN FALLS SFR V ING ENTERPRISE RESOURCE PLANNING (ERP) SYSTEM Response Due Date: October 12, 2023 [D FourthSquare FourthSquare, LLC 300 Decker Dr, Suite 335, Irving TX 75062 Tel: +1 214-406-7412 Fax: +1 866-325-6393 Email: supplierkfourthsquare.com m FourthSquare Enterprise Resource Planning(ERP)System Proprietary Nature of Proposals Every FourthSquare(`FourthSquare')proposal is prepared for the sole and exclusive use of the party or organization to which it is addressed. Therefore, FourthSquare considers its proposals to be proprietary, and they may not be made available to anyone other than the addressee or persons within the addressee's organizations who are designated to evaluate or consider the proposal. Other than for the purposes of evaluating this proposal, no part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, includingphotocopying and recording, or by any information storage or retrieval system, except as may be permitted by FourthSquare, LLC. FourthSquare submits this proposal with the understanding that it will be used only in accordance with the stated intent expressed by the addressee in its solicitation. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 2 of 71 1! FourthSquare Enterprise Resource Planning(ERP)System COVER LETTER FourthSquare LLC Private and Confidential 300 Decker Dr, Suite 335, Irving TX 75062 Tel : +1 214-406-7412 Breanna Howard, Email : supplier@fourthsquare.com Finance Director, 203 Main Ave E, www.fourthsquare.com Twin Falls, Idaho 83301. Dear Breanna Howard, Subiect: FourthScivare's Response to Enterprise Resource Planninu(ERP) System. FourthSquare is pleased to submit our detailed proposal in response to the City of Twin Falls Request for proposal (RFP)for ERP Software System.FourthSquare is partnering with TruePoint Solutions to provide the Utility Software. FourthSquare is confident that we are the best partner for this important initiative. As an Oracle Global Partner who provides 24x7x365 service to our clients, FourthSquare will provide the City with excellent customer service while working continuously to improve systems and processes. FourthSquare is excited about the potential to extend our relationship with the City. By using our insights into your business and technology, we can greatly assist in driving improvements within your organization. We believe we're the top choice for this initiative because we deliver: • Expertise. FourthSquare resources are 100% Oracle certified, have an average 15+years of experience and have experience working with large professional services organizations, bringing business acumen and maturity. Our resources come with prior Public Sector experience with similar project experience and background. Further, they have worked on specialized Oracle Cloud ERP, SCM, EPM, HCM, Recruitment and Performance Management projects in the public sector and government entities. • Approach. FourthSquare takes a unique approach.Because the solutions are highly configurable,we engineer the configurations to meet your business needs, workflows, and processes. We introduce end users to the application early in the process, during the design phase, thus user acceptance and change management is smooth. • Trusted. FourthSquare has a longstanding philosophy to be more than a typical vendor. We develop deep partnerships with our clients, becoming knowledgeable about their business and technology, as well as the culture and personnel. This enables us to provide superior service and successful execution of projects. Our goal is to be your trusted advisor for as long as you have your cloud/on-premises applications. Our team is fully committed to providing the best resources, approach and insights to help City meet and exceed the objectives of this initiative. If you have any questions about this proposal, please contact me directly at 1-859-492- 2829 or at kerry.boudreaux@fourthSquare.com we look forward to working with you on this important project. We acknowledge that we have received the addenda having file name "Compiled Summary Questions and Answers.pdf'. Respectfully submitted, Kerry S. Boudreaux,MBA Senior Vice President of Sales FourthSquare,LLC Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 3 of 71 FD U rth S Q U a re Enterprise Resource Planning(ERP)System COMPANYOVERVIEW October 12,2023 • TruePoint Solutions Breanna Howard, Finance Director Incorporated: • 2004 City of Twin Falls • 46 employees 203 Main Ave E Professional Services: Twin Falls, Idaho 83301 • Business Analysis • Configuration Dear Ms. Howard, • Data Conversion • Report Development • Event Scripting TruePoint Solutions is proud to offer the City of Twin Falls the following Interface Development proposal to fulfill—in partnership with FourthSquare—the City's requirements Consulting for a Utility Billing and Customer Information System (TrueBill). Training Industry: We would like to take this time to thank you for your consideration and State and Local appreciate the opportunity to demonstrate TruePoint's superior software Government technology and implementation services.We look forward to working with Industry Focus: you and to the prospect of building a successful, long-term relationship. • Utility Billing • Customer Information Systems • Cross-Connection Re ids, Control Programs • Asset Management _ l • Land Management and Permitting /ff • Business and Trade Licensing Kent John o • Code Enforcement TruePoint lutions • Electronic Document Review (916) 2594293 office • IT Consulting (916)607-4490 mobile Software Solutions: (916)256-1975 fax • Utility Billing/CIS www.truei)ointsoIutions.com • Backflow Management • Customer Information Portal Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 4 of 71 H! FourthSquare Enterprise Resource Planning(ERP)System TABLE OF CONTENT COVERLETTER......................................................................................................................................................................3 TABLEOF CONTENT............................................................................................................................................................5 PROPOSER PROPOSAL CHECKLIST................................................................................................................................6 A. PROPOSAL SUMMARY FORM.......................................................................................................................................7 B.COMPANY BACKGROUND .............................................................................................................................................8 C. SOFTWARE FEATURES.................................................................................................................................................11 D.HARDWARE,OPERATING SYSTEM,AND PROGRAMMING...............................................................................16 E.IMPLEMENTATION PLAN.............................................................................................................................................19 I. PROJECT MANAGEMENT APPROACH.................................................................................................................20 II. SYSTEM AND OPERATIONAL PROCEDURE DEVELOPMENT...............................................................................25 III. SOFTWARE INSTALLATION............................................................................................................................27 IV. DATA CONVERSION PLAN..............................................................................................................................28 V. REPORT DEVELOPMENT.....................................................................................................................................29 VI. INTEGRATIONS AND INTERFACES..................................................................................................................29 VII. TRAINING PLAN..............................................................................................................................................32 VIII. DOCUMENTATION DEVELOPMENT................................................................................................................34 IX. ESTIMATED TIMELINE...................................................................................................................................35 F.STAFFING PLAN...............................................................................................................................................................37 G.ON-GOING SUPPORT AND MAINTENANCE............................................................................................................40 H.SOFTWARE UPDATES AND DISTRIBUTION............................................................................................................45 1. SYSTEM PERFORMANCE AND RECOVERY..............................................................................................................48 J.PROPOSER REFERENCE INFORMATION.................................................................................................................50 K.TOTAL COST(SEE APPENDIX B-TOTAL COST SUMMARY).............................................................................52 L.PROPOSAL SIGNATURE FORM...................................................................................................................................56 APPENDIX A—INSURANCE REQUIREMENTS.............................................................................................................58 APPENDIX B—TOTAL COST SUMMARY.......................................................................................................................61 APPENDIX C—EXCEPTION FORM..................................................................................................................................64 APPENDIX D-REQUIREMENTS SUMMARY................................................................................................................65 Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 5 of 71 1! Fo u rth S q u a re Enterprise Resource Planning(ERP)System PROPOSER PROPOSAL CHECKLIST P Item Indicate"Included" Proposal or"Not Included" Section A. Proposal Summary Form Included B. Company Background Included C. Software Features Included D. Hardware, Operating System, and Programming Included E. Implementation Plan, including: Included Project Management Approach-details and costs Included System and Operational Procedure Development Plan Included Software Installation Plan Included Data Conversion Plan Included Report Development Plan Included Integration and Interfaces Plan Included Training Plan Included Documentation Development Plan Included Estimated Timeline Included F. Staffing Plan Included G. On-Going Support and Maintenance -details and costs Included H. Software Updates and Distribution-details and costs Included I. System Performance and Recovery Included J. Proposer Reference Information Included K. Total Cost-Itemized Included L. Proposal Signature Form Included Appendix A: Insurance Requirements Included Appendix B: Total Cost Summary Included Appendix C: Exception Form Included Appendix D: Requirements Summary Included Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 6 of 71 0! FourthSquare Enterprise Resource Planning(ERP)System A. PROPOSAL SUMMARY FORM Prime Vendor: FourthSquare Name of Company FourthSquare,LLC Software Brand Name Oracle Name of Preparer Mr. Venkatash Kovel Name of Primary Contact for Follow up questions Mr. Venkatash Kovel Contact Phone Number +1 214-406-7412 Fax Number +1-866-325-6393 Email Address supplier@fourthsquare.com Partner: TruePoint Solutions (For Utility Billing Software) Name of Company TruePoint solutions Software Brand Name TruePoint Name of Preparer Mr. Bradly Freeman Name of Primary Contact for Follow up questions Mr. Matthew Cohagan Contact Phone Number +1 (916)266-1619 Fax Number Email Address mcohagan@truepointsolutions.com Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 7 of 71 FlFourthSquare Enterprise Resource Planning(ERP)System B. COMPANY BACKGROUND FOURTHSQUARE 1. Please state the year Proposer started in the business of 2017 selling ERP system solutions. 2. Where is Proposer's closest facility/sales office in FourthSquare: Irving,Texas reference to the City of Twin Falls? Oracle Inc: Salt Lake City,Utah 3. Where is Proposer company's headquarters? Irving, Texas 4. Please list Proposer's sales in dollars for the previous 2022-$ 3.4 M three (3)years: 2021 -$ 1.02 M 2020-$ 363K 5. How many total employees does Proposer have in each Sales/Marketing—8 of the following categories: Management/Administration- 12 Help Desk Staff-4 Development Staff—22 Implementation Staff-66 Other- Total— 112 6. Specify the number of public sectors vs.private sector Public Sector: 150(Including Oracle clients. and FourthSquare) Private Sector: 1000+(Including Oracle and FourthSquare) 7. Indicate whether the business is a parent or subsidiary FourthSquare,LLC itself is a Parent in a group of companies. Company 8. Has this company or product been proposed ever Our company as well as the product been purchased or acquired by another company?If being proposed has never been yes,provide the name of the companies involved, purchased or acquired by another specific products affected and when such merger or company. acquisition(s)took place. 9. What percentage of revenues does this offered 70%Revenue coming from Oracle system represent to your company versus other SaaS solution. products/services? 10. Indicate if the company incurred an annual operating Our company has not incurred any loss in the last five(5)years. annual operating loss in the last five (5)years. 11. Has the company had a workforce reduction during the Our company did not have any past five(5)years? workforce reduction during the past five(5)years. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 8 of 71 Fo u rth S q u a re Enterprise Resource Planning(ERP)System 12. What is the percentage of annual revenues reinvested 12% of the annual revenue is into research and development? reinvested into research and development. 13. During November 2023, can the Proposer commit to Yes being available for two(2)consecutive days for an on-site demonstration? TRUEPOINT 1. Please state the year Proposer started in the 2011 business of selling ERP(Utility Billing)system solutions. 2. Where is Proposer's closest facility/sales office Sacramento, CA in reference to the City of Twin Falls? 3. Where is Proposer company's headquarters? Sacramento, CA 4. Please list Proposer's sales in dollars for the 2022-9M previous three(3)years: 2021 - 8.2M 2020-9.3M 5. How many total employees does Proposer have in Sales/Marketing—3 each of the following categories: Management/Administration-3 Help Desk Staff-3 Development Staff-4 Implementation Staff-35 Other- Total—48 6. Specify the number of public sector vs.private 100%Public Sector sector clients. 7. Indicate whether the business is a parent or Parent subsidiary in a group of companies. 8. Has this company or product being proposed ever Neither the company nor the been purchased or acquired by another company? proposed product have been If yes,provide the name of the companies purchased or acquired by another involved,specific products affected and when such company. merger or acquisition(s)took place. 9. What percentage of revenues does this offered 20% system represent to your company versus other products/services? 10. Indicate if the company incurred an annual No operating loss in the last five(5)years. 11. Has the company had a workforce reduction No during the past five 5 ears? 12. What is the percentage of annual revenues 25% reinvested into research and development? Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 9 of 71 11! Fo u rth S q u a re Enterprise Resource Planning(ERP)System 13. During November,2023,can the Proposer Yes commit to being available for two(2)consecutive days for an on-site demonstration? About TruePoint TruePoint was founded in 2004 with the primary goal of leveraging technology to deliver effective software solutions to local government. Over the last two decades,we have continued to adapt and evolve with the latest technological advances and government regulations to provide industry leading solutions in utility billing, customer information systems, and backflow management. We believe that our user-focused design philosophy and extensive automation tools create business processes and workflows that greatly improve staff efficiency and allow our customers to better serve their communities. TruePoint brings a substantial amount of valuable industry experience to the table. Our management team averages over 30 years of Public Sector IT experience with a focus on designing, developing, implementing, and supporting complex government-related applications and services. We are proud to have consistently received excellent feedback from our customers on our ability to implement our solutions on time and within the budget while ensuring the quality of our deliverables. In addition,TruePoint's customers routinely give our customer support team top marks for their response time,knowledge of the software,problem-solving ability, and communication skills. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 10 of 71 1! Fo u rth S q u a re Enterprise Resource Planning(ERP)System C. SOFTWARE FEATURES FOURTHSQUARE 1. Please explain how your product is licensed Our license are based on Hosted Employee and (concurrent, site,user or machine based). Hosted Named User How are additional licenses sold? 2. How long has the current version of Proposer The proposed solution been commercially software been in production? available since 10+years 3. What is the system architecture? Web-Based (web-based, client/server,mixed) 4. What is the query tool and report writer that You can use any SQL reporting tool to query Proposer is proposing? and report on the tables and views. 5. Please describe any workflow or event alerts and Notification and Event Alert are default notification capabilities the application provides. functionalities within the application. 6. Does the system provide global query function Yes so that users can search system wide based on name, account,range of values, or partial and wild cards? 7. Please describe all third-party We do not propose any third-party applications. software required or recommended for the solution, including report writers. 8. Does the system provide multiple levels of Yes, our solution provides multiple levels of data security control access by terminal, Data Security control access. transaction, and file? 9. Is the system integrated into Microsoft Office Yes Suite permitting the ability to import and export data to spreadsheets and documents? TRUEPOINT 1. Please explain how your product is licensed Our product is licensed based on a SaaS (concurrent, site,user or machine based). subscription model which entitles your How are additional licenses sold? organization to unlimited. users. 2. How long has the current version of Proposer Since 2011 software been inproduction? 3. What is the system The application is fully web-based with a architecture? (web-based, SQL server database backend. client/server,mixed) Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 11 of 71 11! Fo u rth S q u a re Enterprise Resource Planning(ERP)System 4. What is the query tool and report writer that The application has a native Search Proposer is proposing? Companion tool that allows staff to create and execute their own queries. The results can then be reviewed in the application or exported to Word,Excel,or CSV.For advanced reporting,the application leverages SQL Server Reporting Services and Microsoft's Report Builder tool. 5. Please describe any workflow or event alerts TruePoint provides the ability to configure and notification capabilities the application custom workflow and event alerts based on provides. different triggers within the application. In addition,these triggers can generate e-mail notifications to staff. The system also provides the ability to create e-mail and text message notification templates for scheduled or ad-hoc messaging to customers. 6. Does the system provide global query Yes,the system has a native Search function so that users can search system Companion tool that allows users to search for wide based on name, account,range of records based on any field, including partials values, or partial and wild-cards? and wildcards. 7. Please describe all third-party software Modern web browser(Chrome,Microsoft required or recommended for the Edge, Safari,Firefox) solution, including report writers. Microsoft Report Builder(Report Writer) 8. Does the system provide multiple levels of Yes data security control access by terminal, transaction, and file? 9. Is the system integrated into Microsoft Yes Office Suite permitting the ability to import and export data to spreadsheets and documents? Key Advantages Below is a list of key advantages provided by TruePoint software that set us apart from other solutions. Ease of Use One of the primary design goals of the TruePoint application is for users to be able to learn he software quickly to make their jobs easier. By embedding critical processes into user- friendly wizards,users complete complex tasks quickly and with greater accuracy. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 12 of 71 Fo u rth S q u a re Enterprise Resource Planning(ERP)System A_R�rtipg TruePoint provides multiple reporting options including the native Search Companion tool and SQL Server Reporting Services. Search Companion is an easy-to-use tool that staff can leverage to create their own queries which can then be exported to Excel. This works extremely well for simple to moderate reports. For more advanced reporting, TrueBill leverages the power of SQL Server Reporting Services. Using Microsoft's Report Builder tool, custom reports can be developed to meet complex organizational and governmental reporting requirements. AhOWell-Documented Data Model 11 aspects of the TruePoint data model are documented to show their relationships,data types,validation, and purpose. This ensures data collection efforts do not disappear into a mound of unusable information. When the next business challenge comes up that requires extracting information from your sea of data,you can be assured all the reporting aspects are clearly documented to make retrieving the data a simple process. Comprehensive Integration Platform TruePoint provides several methods for integrating and extending its application.Among them are workflows, an open Gateway API, and data export and import companions. TruePoint recognizes that the customer, connection,meter, and account information are. useful for other business processes in any organization and have developed standard. tools to make integrating with other systems a straightforward process. Workflows are processes triggered on system events that can initiate communication to external systems. Events can be configured to perform functions like sending text messages and email notifications or validating address information with an external system. TruePoint's Import/Export Companion allows authorized users to edit the configuration of the import/export files to account for changes in formatting without the need for code/software changes. The TruePoint API gateway provides authenticated web services for performing common tasks. The gateway also provides change sets to optimize data synchronization with third-party systems such as your GIS layers. Cityworks Partnership TrueBill is proud of our strong relationship with Cityworks and we are one of the only Utility Billing solution vendors to offer a true Cityworks integration out-of-the-box.We maintain a close working relationship with Cityworks founders and staff that goes back over 25 years and are a Gold level sponsor of the Cityworks RUGS and annual User Conference. Many of our TrueBill implementations feature an integration with Cityworks,which is unique to our software in that they don't require any 3rd party middleware. Due to our advanced system architecture, our integration with Cityworks is both direct and real- time,which makes it more functional,reliable, and easily supported than anything else on the market. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 13 of 71 Fo u rth S q u a re Enterprise Resource Planning(ERP)System ®True Browser-Based Application The TrueBill Utility Billing system is a 100%true browser-based application.It has been designed to work with the latest browser technology and supports modern browsers including Google Chrome,Microsoft Edge, and Safari. Benefits of a browser- based application include: • Application is always available with an intemet connection. • Application can be accessed on different devices regardless of operating system(Windows,Apple, etc.) • Deployment,maintenance,and updates are much easier than traditional desktop applications. • More flexible configuration and integration options IIWFinancial Visibilit Our internal AR system is configured to mimic your General Ledger to provide a seamless connection between Finance&Billing. Transactions are stamped with a unique batch identification number,making audits and reconciliation between GL. entries and billing data quick and easy. fi6 Dedicated Proiect Team From the start of the implementation,we assign dedicated resources to the project. This improves project efficiency as team members are not being pulled into other projects and can focus their full attention on meeting project deliverables. In addition,this makes the project team more agile since change only needs to be managed within a single project. Most importantly we have seen that this helps build an effective working relationship between our organizations which leads to a successful and long- lasting partnership. Customer Support Our customers consistently rate our support as one of the best among any of their software vendors.We pride ourselves on our quick response time and our knowledgeable support staff is dedicated to providing top-tier customer service with special attention to any priority issues.In addition,many of our customers wish to add new features, interfaces, or modules post go live as their operations grow and we are always available to support this growth. IIIEnterprise Licensin A reement To promote the inherent"access anywhere"advantages of this technology,we license the product on an annual subscription basis with unlimited user access. As your organization naturally grows and you add more users,your annual subscription fees remain the same. 4� Flexible Hosting Options Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 14 of 71 Fo u rth S q u a re Enterprise Resource Planning(ERP)System TruePoint supports both on-premises and cloud-hosting options depending on your specific needs. Many of our recent customers have opted to take advantage of our cloud-hosting services in which we fully manage the application environment through Amazon Web Services(AWS). Some of the benefits of our cloud hosting services include: • No hardware requirements/cost • No environment maintenance,this is all handled by TruePoint • Scalable Performance—as your business grows,the servers can grow without the need for costly hardware upgrades and installations • Single Sign-On/Active Directory Integration TrueBill— Utility Billing Solution TrueBill is a comprehensive customer service and billing solution that will improve processes,streamline workflows,automate manual tasks,and enable staff to serve your customers more effectively.The system provides efficient access to account details and user-friendly tools for performing tasks across key functional areas. Global Product Features " Fully browser based A Built-in notes and alerts Intuitive,user-friendly interface Document Management �► Granular User permissions 10 User-definable screens and queries Customer managed forms l� Customizable workflows Microsoft Office integration ° ° User-defined fields System Components Utility Billing 0 Water Conservation ® Account Management • Water Budgeting Accounts Receivable = Customer Portal (Payment/Inquiry) Debt Management Backflow Prevention&Testing Cashiering/Cash Management 0 Backflow Contractor Portal tell*% Meter Management � Routing Reading Review 0 Financials Integration Service Orders Standard Work Order/CMMS Integration Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 15 of 71 m Fo u rth S q u a re Enterprise Resource Planning(ERP)System D. HARDWARE, OPERATING SYSTEM, AND PROGRAMMING 1. What hardware platform(s)does Vendor's Our proposed solution is delivered through proposed application software currently a web site, as a result it does not require operate on? any underlaying hardware platform(s). The only requirement being a device capable of running a latest web-browser. 2. What operating system does Vendor's It is a SaaS Cloud Application and does not proposed application software currently require any particular operating system to operate on? run on.Most of the OS capable of running a web-browser are sufficient to access the solution 3. What database environments does Vendor's Oracle Database Environment proposed application software currently operate on? 4. Is Vendor committed to supporting the Yes above operating system, database and hardware platforms for the foreseeable future? 5. Does the application support native browser-based deployment for Oracle Cloud is accessible via most workstations?Which web servers and common Internet browsers.Browser browsers are supported? (IIS, IE 11, etc.) support includes: • Apple Safari 13+ • Google Chrome 80+ • Microsoft Edge 80+ • Mozilla Firefox 68+ Other third-party software may be necessary to take advantage of some desktop integration features. There are Microsoft plug-ins provided, at no additional cost,to support desktop integration. • Adobe Reader 9 and higher • Adobe Acrobat 9 Pro and higher • Microsoft Office 2007+(local install) A complete list of system requirements for Oracle Cloud Applications can be found at htlp://www.oracle.com/us/J2roducts/system- requirements/over-view/index.htmI Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 16 of 71 m Fo u rth S q u a re Enterprise Resource Planning(ERP)System 6. Does the system support deployment/usage The applications are delivered via the using remote access tools(e.g.,VPN)?Are internet as this is a browser based there any issues related to this type of accessing architecture. Hence,we do not utilization? require remote access tools for system support deployment/usage. TruePoint Details: 1. What hardware platform(s) Virtualized Server(details does Vendor's below) proposed application software currently operate on? 2. What operating system does Windows 10 Vendor's proposed application software currently operate on? 3. What database environments Microsoft SQL Server does Vendor's proposed application software currently operate on? 4. Is Vendor committed to Yes supporting the above operating system,database and hardware platforms for the foreseeable future? 5. Does the application support Yes. The application supports native browser based IIS and modern browsers deployment for workstations? (Chrome,Microsoft Edge, Which web servers and Safari,Firefox). browsers are supported?(IIS, IE 11, etc.) 6. Does the system support Yes,the application supports deployment/usage using remote this. access tools (e.g.VPN)?Are there any issues related to this type of utilization? The tables below contain the software and hardware requirements, both virtualized and physical alternatives, for optimum operation of the TrueBill Utility Billing Solution.This document is designed around a 20 concurrent user base for 20,000 utility billing accounts. All of these should be considered minimum recommendations with an expectation to handle 10 years of average growth in data size. NOTE:The virtualized and physical server requirements below only apply if you are planning to self-host the application software. If instead you select our cloud-hosting option,the server requirements do not apply. Required Server Software Application Version Edition Microsoft Windows Server 2016+ Any Microsoft SQL Server 2016(v14)+ Standard or Enterprise Microsoft SQL Server Reporting Services 2016(v14)+ Standard or Enterprise Windows Internet Information Systems 10+ NA .NET Framework 4.7.2+ NA Visual 1#-64 Bit 2.0 NA Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 17 of 71 0! Fo u rth S q u a re Enterprise Resource Planning(ERP)System Virtualized Minimum Server Compute, RAM, Storage, Storage TOPS, Network Throughput Server Compute RAM Storage Storage ICIPS Network TrueBill 2 Cores 4 GB 80 GB Write IOPS 100 1 GBPS LAN Read IOPS 300 TrueBill SQL 1 4 Cores 8 GB 300 GB Write IOPS 3200 1 GBPS LAN Read IOPS 3200 TrueCIP 2 cores 4 GB 60 GB Write IOPS 100 1 GBPS LAN Read IOPS 200 100 MBPS WAN Physical Server Hardware Recommendation Minimums Type CPU RAM Storage Storage ICIPS Network TrueBill INTEL®XEON°GOLD DDR4-2666 Enterprise Write IOPS 1300 1 GBPS LAN 64xx PROCESSOR Class SSD Read IOPS 3200 TrueBill SQL INTEL®XEON®GOLD DDR4-2666 Enterprise Write IOPS 1300 1 GBPS LAN 64xx PROCESSOR Class SSD Read IOPS 3200 TrueCIP INTEL®XEON® DDR4-2400 Enterprise Write IOPS 200 1 GBPS LAN SILVER 44xx Class SSD Read IOPS 200 PROCESSOR Required Workstation Software Application Version Edition Windows 10+ Professional or Enterprise Chrome 107+ NA Microsoft POS(Required forCashiering) 1.14 NA EPSON OPOS(Required forCashiering) 1.14.16E NA Cloud-Hosting Environment TruePoint uses Amazon Web Services for cloud-hosting for the many benefits it provides to our customers in terms of affordability,reliability,scalability,and performance.All hosting locations are within the United States and for City of Twin Falls,we would be using the us-west-2 availability zone located in Oregon. AWS Servers consistently maintains above 99.99%uptime and is known for their extremely robust and redundant infrastructure.As your organization grows and your computing requirements increase,AWS makes it extremely easy to allocate additional resources to the application or database environment to maintain optimal performance. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 18 of 71 E. IMPLEMENTATION PLAN FourthSquare 1. How many fully operational Local Govt.- installations has Proposer County Govt.-2 completed? State Govt. - Other-4 State overall percentage finished Total— before, on, or cost original client Oracle's Cloud Applications detailed customer implementation goal/deadline. information is proprietary and confidential due to our contractual obligations. Currently, Oracle has over 9,800 customers running Oracle Cloud ERP. The City can explore some of the customer success stories,which can be filtered by industry, on the website at: https://www.oracle.com/customers/?product=mpd- cld-apps Oracle has a growing Public Sector install base with over 150 customers including 22 State's and State Agencies,24 K-12 School Districts and 104 Local Governments. Our Michigan based government customers include; • City of Detroit • Wayne County • Wayne County Airport Authority • City of Taylor • City of Grand Rapids • Community Mental Health Board of Clinton,Eaton and Ingham Counties 2. What is the hourly rate for The rates will differ based on skillsets. implementation assistance beyond that which is included in? Average Onsite Rate$ 145 -$165 per hour Proposer proposal by skill set? Average Offshore rate$40- $45 Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. m11! FourthSquare Enterprise Resource Planning(ERP)System TruePoint 1. How many fully operational installations has Local Govt.-5 Proposer completed? County Govt.- 1 State Govt. - State overall percentage finished before, on, Other-43 or aAst original client implementation Total—49 goal/deadline. o 92/o Before or on original client's goal 8%past original client's goal 2. What is the hourly rate for implementation TruePoint charges a flat rate of assistance beyond that which is included in? $185/hour for all implementation Proposer proposal by skill set? services. i. Project Management Approach Provide an overall description of Proposer's project management approach toward this type of engagement. Project Management Approach As an Oracle specialized system integrator FourthSquare follows and practices proven PMI skills and project methodologies that have been crafted in the Project Management Book of Knowledge (PMBOK), we strive to have an unblemished record of successful project delivery to provide comprehensive and consistent program and project oversight and administration in addition to our functional and technical consulting services. The City receives the best possible attention from our executive management team for this mission-critical project. Project Charter To establish a strong foundation at the outset of the project, FourthSquare will work with the City to define and document project governance expectations in a Project Charter document. FourthSquare reaffirms the scope of the project, once the project team, and especially the PMO has been established. The PMO discusses and co-creates a project charter to clearly articulate scope,project controls,success factors, governance processes, deliverable review and approval processes, and other key aspects of the project. FourthSquare develops a draft based upon its understanding, discusses it with the client, and modifies the document to match the resulting, combined understanding from these discussions. The project charter becomes the primary source of truth that the PMO utilizes to direct the project throughout the engagement. Content from the charter should be referenced at an initial kickoff meeting to make sure all project team members have a common understanding of the goals,objectives,and expectations of the project. Project Plan FourthSquare develops a comprehensive project plan containing all required deliverables, tasks, milestones,resource assignments, stages, and waves of the project/program. The plan is reviewed with the PM and key project team members to incorporate all necessary input. Once finalized,it becomes the source for team task status content. By tracking status to the tasks and critical path of the project, it removes the subjective nature of status reporting and meetings and allows the PM to have a clear, objective view of the health of the project. Budget Management and Invoicing FourthSquare's project management team will create a project budget based on delivery schedules, resource loading and project milestones. All work done on the project is tracked against this project Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 20 of 71 FourthSquare Enterprise Resource Planning(ERP)System budget,variations are evaluated, and corrective action taken to ensure that there is no over-run. The management team also uses tools like the Earned Value Report to compare incurred costs to work completed and the remaining work. FourthSquare is proud of our 100%success rate in delivering projects for all of our customers. Once a deliverable has been approved by FourthSquare for submission,the City will have 2 days or pre- negotiated number of days(as in SOW)to review the deliverable and provide feedback to FourthSquare. FourthSquare will make any necessary changes to the delivery and will submit an Acceptance Certificate to the City. A signed Acceptance Certificate marks the completion of the deliverable and triggers invoicing to the client based upon negotiated terms of payment. Implementation Methodology FourthSquare will utilize the following Accelerated Implementation Methodology for this implementation and will collaborate with the City on their exiting methodologies, if any. This project methodology is tailored to meet Systems Development Life Cycle (SDLC) methodology and Oracle unified methodology(OUM)for cloud implementation projects.We identified areas that we can utilize the Agile methodology versus areas where we can utilize the traditional Waterfall methodology and developed our Accelerated Implementation Methodology (AIM) approach and methodology as a hybrid methodology using SDLC and Oracle's Unified Methodology (OUM) principles. Part of our approach is to educate your staff on how the methodology is designed and how it impacts the project. We feel it critical that team members understand the methodology and that everyone uses the implementation approach. Oracle Cloud Applications is more about configuration than customizations. Though customizations, is possible using Oracle's Platform as a Service(PaaS) suite of products, almost all of our clients have chosen not to customize and have utilized Oracle Cloud Applications' configurable functionality as Oracle Fusion SaaS product does provide an integrated,200+best practice business process flows that should fit your organization needs. However, Oracle has provided BI reporting capabilities (OTBI reporting), embedded in the system, and can be used for developing custom reports and dashboards. Our objectives for the Accelerated Implementation Methodology are simple: • Enable our clients to take full advantage of the Oracle Cloud's rich functionality to optimize their investments in Oracle Cloud Applications • Business transformation using Oracle Cloud Applications' available processes rather than starting from scratch. • Enable our clients to utilize industry leading practices overlaid with Oracle Cloud's functionality and our clients' unique business processes help ensure the success of the project. • Our clients have day jobs. Though some back fillings are done for resources pulled into the project,this is never sufficient. Hence,one of our objectives is also to reduce the time spent by our clients on the project and successfully deliver. The following exhibit depicts our methodology, which is based on the five major phases that occur within every implementation or upgrade project. Each of these phases includes multiple steps, tasks, and deliverables,as defined in this document. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 21 of 71 FourthSquare Enterprise Resource Planning(ERP)System n w� 0> — �? BUILD VERIFY TRANSITION 1 REALIZATION • Project&Change WManagme Data Conversion Mapping Confirm Configurations finalize Support Plan Resolve Go-Ltve issues Governance Structure Tech Development Validate Conversions Transition Plan • Requirements Mapping p Setup support organization • Security Definitions Train-the-Trainer finalize Cutover Plan Provide support to users • Conference Room Pilot(CRP) Training the Trainer User Testing(UAT) Cutover Execution Document lessons learned Data Conversion Design Iterative Application Testing Parallel Test(if applicable) Controlled Entry Identify areas of improvement • Integration si Reports Des Training Development Readiness Matrix(OCM) Go-Live project • S Integration Design Close Project M• ••- - Knowledge Transfer Change Management The major activities during the implementation include: • Plan and Design: During the Design phase our Functional Architect and Delivery Manager will work on the set of project planning and related deliverables along with the City assigned Project Manager. Our Functional Architect/Delivery Manager will work with City PM to agree upon deliverable expectations and formats needed. • Data Migration Approach: We will provide pre-defined templates to City to provide master and transactional data to be converted over to Oracle ERP. • Testing: Our team will develop User Test scripts based on the agreed upon business process flows. City will provide additional test scripts for user acceptance testing. • Solution Design: The Solution Confirmation cycle is one iteration of end-to-end functional unit testing using City data that has been input into the system. Sample data conversion will be done manually during this phase.Project team will be able to test and evaluate the prototype of a solution designed during Design phase. At this stage of the project, we HIGHLY recommend your SMEs to walkthrough the approved business process flows with end-user or super-user community to make sure end-users are in line with the design being approved. This will eliminate the risk of scope change later. • Go-Live Readiness and Cutover: Once user-acceptance testing is signed and approved using the "Conditional Acceptance" process, FourthSquare and City's designated resources will prepare to migrate all configurations and technical development into the targeted Production environment. Typically,this is done by FourthSquare while City SMEs can observe. This helps City staff have a full understanding of their applications. o FourthSquare will create and deliver a Cutover Plan. This plan has detailed steps that must be completed prior to go-live as well as timing for each step and the person who will complete the task. o Prior to executing the final conversion and cutover steps,a Readiness Assessment Matrix(RAM)is conducted to verify that all organizations,systems,and personnel are ready for the migration. This assessment results along with the Cutover Plan are completed and presented to the steering committee for final approval to move forward. o Data is extracted and loaded to the Production environment. Designated City staff will be assigned to validate the load of data by checking the data before it is loaded and by checking data in Oracle by viewing the information on the forms. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 22 of 71 FourthSquare Enterprise Resource Planning(ERP)System • Production Setup,Review,Go-Live—Upon signoff of UAT,FourthSquare and City resources will prepare to migrate all configurations and technical development into the targeted Production environment. Prior to executing the final conversion and cutover steps, a "Readiness Assessment" to verify that all organizations, systems, and personnel are ready for the migration is completed and presented to the steering committee for final approval to move forward. • Production Support — Post-production support begins immediately with the production cutover. The transition plan for system support will be finalized prior to cutover with specific details to be agreed upon,covering all aspects of support activities. o Go-Live and Immediate Post Go-live Support: Post-production support begins immediately with the production cutover. The transition plan for system support will be finalized prior to cutover with specific details to be agreed upon, covering all aspects of support activities. Immediate Post go-live support(also called"Hypercare")includes: o Support any new issues raised by user's post go live. o Address open issues remaining to close and provide directions for ongoing support. o Address parking lot items and provide directions for ongoing support. o Provide knowledge transfer of functionalities and processes, as needed. o Present Project close process System Configuration Our comprehensive Design approach (per our implementation methodology) involves analysis of the requirements and solution design by conducting workshops with a configured system / vision environment. Soon after we engage on the project,we will gather detailed requirements to understand the as-is process and perform GAP analysis. In ERP Cloud implementation cycles, we use Oracle provided 200+ Best Practice workflows and Level2, leve13 process flows to confirm to the requirements. We then create a prototype environment (PILOT) based on the requirements and with minimal data for application workshops. This step will help users to see the configured prototype environment for the first time and will help in understanding the future to-be processes and solution design. The initial design phase activities begin the knowledge transfer process. Client's Super Users are involved in hands-on,process-focused Workshops(e.g.,Procure to Pay,Record to Report, etc.). These Workshops combine a review of the business processes with demonstrations of features or processes within Oracle that will be used to support the requirements. FourthSquare as the Prime&Role of other partner firms FourthSquare is recognized as one of Oracle's public sector strategic partners. FourthSquare is a qualified MBE(with ownership structure)with Certification Pending.FourthSquare will be the prime vendor for this engagement and will be working with the following partners providing services as below. Firm Name Role of the Firm Contact Name FourthSquare, LLC Prime Vendor for the Implementation Venkatash Kovela Mythics,Inc. Oracle Software re-seller for Product Paul Brandt Licensing TruePoint Utility Billing Matthew Cohagan Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 23 of 71 FourthSquare Enterprise Resource Planning(ERP)System Mythics, Inc. -Potential Approved Contract Vehicle Partner: An authorized and approved Oracle Software reseller for this engagement. Mythics will be engaging with the City of Twin Falls to assist Oracle software installation. FourthSquare will be responsible for all coordination. Mythics is an Oracle partner of the year,an award-winning Oracle Systems Integrator,and ® an elite Oracle Platinum Resale Partner.Mythics represents the full catalog of Oracle cloud, software,hardware,Engineered Systems,appliances,training,and support products. Since MYTH I C S" our inception in 2000,Mythics has been 100%dedicated to providing Oracle products and services. For over 20 years, we have supplied Oracle solutions and provided consulting services and emerged as one of Oracle's most qualified and experienced solution providers.Mythics has become an Oracle leader in North America in technical and functional expertise and has grown to be a trusted IT advisor to thousands of organizations worldwide who conduct business in a wide range of sectors including State and Local Government,Federal,Healthcare,Utilities,and Higher Education. Mythics Inc.has been a key strategic partner to many public sector entities for nearly 20 years. During this time, Mythics has helped enhance citizen engagement via transformative technology projects by effectively and efficiently sourcing Oracle technology on behalf of our customers. We have worked diligently to become a trusted advisor and IT service provider to our clients across public sector. We are partnering with FourthSquare to present a unified bid wherein Mythics is the reseller of the Cloud Services subscriptions. For the purposes of RFP No. 05-23 Mythics is submitting this response in accordance with the terms and conditions of the Mythics Cloud Services Agreement (MCSA PSv122I), which shall be incorporated in any resulting City of Twin Falls purchase order. Mythics is contractually obligated by the manufacturer, Oracle America, Inc., to ensure all orders are subject to an approved End User Agreement governing the Oracle Cloud Offerings. The MCSA PSv1221 Contract shall solely be the terms and conditions that govern access to and use of the Oracle Cloud Services. Should the City of Twin Falls wish to entertain leveraging a pre-bid, fully negotiated cooperative purchasing contract for the software purchase, Mythics is able to provide several options, including US Communities (USC) and The Cooperative Purchasing Network(TCPN)or National IPA vehicles. Mythics has a proven track record of helping State and Local Government customers procure and consume cloud. We help assist customers in a variety of sizes from large Statewide Organizations of over 35,000 employees down to individual business units of 10 users. Mythics is proficient across Oracle's SaaS Suite of Products and helped Government customers consume Enterprise Resource Planning, Human Capital Management, Enterprise Performance Management, Customer Experience, and Supply Chain Management cloud services. With 55 specializations, Mythics is the most qualified Oracle solution provider based upon meeting Oracle's stringent resale criteria and earning Oracle-validated specializations. Our dedication and experience supporting customers with their Oracle technologies is best demonstrated with the recent awards Mythics has received from Oracle: ORACLE' 201412013 OracleWinner lox Excellence Award ORACLE SPECIALIZED PARTNER OF THE YEAR SPECIALIZED PARTNER OF THE YEAR Cloud I Software I Hardware I Engineered Systems —NORTH AMERICA These were awarded to Mythics out of thousands of Oracle partners. To achieve these awards, Mythics relies on our internal technical resources to become specialized in the various Oracle product Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 24 of 71 Fo u rth S q u a re Enterprise Resource Planning(ERP)System categories and also achieve resell rights to over 72 specific Oracle products and product categories. These resources, combined with the knowledge and years of experience of our sales and sales support organizations,uniquely positions Mythics to support complex,high volume business transactions and provide real value-added services to current and future Oracle customers. TruePoint Solutions.—Utility Billing Specialists: TruePoint was founded in 2004 with the primary goal of leveraging technology to deliver effective software solutions to local government. Over the last two decades, we have continued to adapt and evolve with the latest technological advances and government regulations to provide industry leading solutions in utility billing, customer information systems, and backflow management. We believe that our user-focused design philosophy and extensive automation tools create business processes and workflows that greatly improve staff efficiency and allow our customers to better serve their communities. TruePoint brings a substantial amount of valuable industry experience to the table. Our management team averages over 30 years of Public Sector IT experience with a focus on designing, developing, implementing, and supporting complex government-related applications and services. We are proud to have consistently received excellent feedback from our customers on our ability to implement our solutions on time and within the budget while ensuring the quality of our deliverables. In addition, TruePoint's customers routinely give our customer support team top marks for their response time, knowledge of the software,problem-solving ability, and communication skills. The TrueBill utility billing application provides a more productive, efficient, accurate, and effective experience for staff and has proven to significantly reduce costs for our customers servicing the water needs of their communities. In addition, the ease of use of the system will improve your staff s ability to serve your customers. Customer Solutions TrueBi I Business Intelligence Account Dashboard,Flexible User-friendly query creation, customer structures,Process ire Standard report library,Advanced Wizards,Owner/Renter reporting capabilities Management Bill Production&AR Customer Portal Management Online Account Management Online Water,Wastewater,&Sanitation Billing, Payment Processing,Auto-Pay Setup, Payments,Delinquency Management, Paperless Billing Setup,Billing& Financials Integration Operations Payment History,Consumption Graphs Service Orders,Meter Inventory, Meter Reading Import/Export,GIS Integration ii. System and Operational Procedure Development Proposer is expected to work with City in developing technical support and technical operational procedures to support the system. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 25 of 71 FourthSquare Enterprise Resource Planning(ERP)System FourthSquare's support approach is intended to give City team members the fundamental knowledge necessary to successfully use the system after go-live. It is intended for City Business Process Owners who are already performing similar functions using legacy systems or manual processes and who have been actively involved in the project. FourthSquare support is intended for the City Business Process Owners. Training sessions and corresponding materials will cover the core functionality of the system. City team members are expected to be motivated to learn the new system and have the ability to augment FourthSquare support with the in-application help content and other Oracle support sites,documentation and forums. In addition, Oracle provides a selection of traditional instructor lead and virtual training through Oracle University. All Oracle support sites,documentation,forums and training are owned and administered by Oracle. FourthSquare does not have control over the content, quality, availability or pricing of these resources which are mentioned here as a courtesy,however, are not considered part of this contract. There are several other support options available through Oracle website(software provider).These are generic training guides or tutorials to help with current and new release functionalities. Oracle Cloud Learning Subscriptions provide a powerful experience for learners that is unmatched in the industry. Oracle Cloud Learning Subscriptions include training for all cloud job roles. The new features and functionality in these learning subscriptions are designed to engage and motivate learners to achieve the skills required to competently perform their job in the cloud. ■ Releases training is now integral to Oracle Cloud Learning Subscriptions. ■ Ability to filter training by product release. ■ Learn through high-definition training videos delivered by Oracle experts. ■ Access your learning subscription at any time during your subscription period. ■ Learn by job role. ■ Learn by skills for your job role. ■ Learn by topics aligned to each skill. ■ Learning paths help guide you every step of the way. ■ Assess your understanding with skills checks. ■ Practice what you have learned with hands-on-labs. ■ Score points with embedded gamification designed to motivate learning and achievement. ■ Connect with Oracle through live training events from within your learning subscription. ■ Get answers to your questions directly from an Oracle instructor. ■ Take advantage of community events with access to the Oracle Applications Customer Connect More details about Oracle University training for Oracle Fusion Cloud Applications is available at https://education.oracle.com Oracle University Learning Subscriptions are not included in the proposal pricing and City can engage with Oracle directly to purchase any needed licenses. Knowledge Transfer&Handover(Approach & Plan) Approach Overview The knowledge required to effectively allow City to run their system in business-as-usual mode, train and support City users is primarily delivered through collaborative working of the project team (FourthSquare and City Team.We work closely together as a single team throughout the implementation and share our knowledge and expertise with City project team members to enable them to be able to spread the knowledge to different audiences as required. This is combined with regular show and tells through the project cycle, described further below. FourthSquare believes the key to a successful implementation is a collaborative project team involving: • Early customer engagement&clear responsibilities • Working together in partnership Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 26 of 71 FourthSquare Enterprise Resource Planning(ERP)System • Familiarization and knowledge sharing Best Practice for Early Engagement of City Team Prior to project start FourthSquare recommends that City teams are fully trained on the standard functionality of the product application(s). This is the best way to ensure a fast and efficient start to the project, the best way for the application knowledge to be absorbed during the design period as City project team understands the Oracle product terminology and functionality that the FourthSquare is designing.These courses are provided by Oracle University(OU),the specialist training arm of Oracle, and can be purchased directly from the OU website. Courses are available in different delivery methods, from online to classroom training at the users / company preference.We would be happy to discuss this further with City to present the pricing(pricing depends on numbers of users and different skill sets) At the start of the project (project kick off) roles and responsibilities of both organization are clearly defined and agreed between project managers from both companies, with a project plan drawn up and agreed. Working Together in Partnership Our experience tells us that working closely together as a single project team(City and FourthSquare - as a partnership)leads to a faster implementation time and more knowledge transfer and ownership.We recommend City identify potential System administrators and Super Users as early as possible in this selection process so these people can be allocated to work alongside the FourthSquare consultants and architects and learn the system as it is configured during the project. Familiarization and Knowledge Sharing Additional to the knowledge sharing that will happen from the close working partnership,we will also run show and tell sessions throughout the project to enable understanding and skills transfer. These are typically in-person sessions where FourthSquare Consultants will walk City project team members through City target system at various levels of detail starting with general familiarization sessions exploring the standard set-up and configuration options available, and finally the configurations that have been applied to City system.The system administrators will build on the product training from the start of the project and be the main administrators for business-as-usual management after the support/stabilization period is completed. Software Installation Proposer is expected to specify,furnish, deliver, install and support all system software. Oracle Fusion is a SaaS solution and product license and subscription would be done by Oracle. FourthSquare will configure environment and implement the functional Requirements. TruePoint will install the TrueBill software in a hosted/cloud-based environment using Amazon Web Services(AWS) and configure initial TrueBill Production&Test databases. TruePoint Responsibilities • Software Installation(Production&Test environments) • SQL Server database setup(Production& Test environments) • IIS setup and configuration(Production&Test environments) Customer Responsibilities • Make sure that TruePoint has remote network access during the installation and future activities (if applicable)Yes Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 27 of 71 m11! FourthSquare Enterprise Resource Planning(ERP)System iv. Data Conversion Plan Proposer is expected to perform electronic and manual conversion of data to the new system, including overall data conversion coordination, definition offile layouts, and data import and validation into the new system. It is anticipated that the information specified under "Data Conversion" (p. 17) of this RFP will be converted to the new system. Please provide details regarding whether Proposer has previous experience converting from an existing SQL database. FourthSquare Data Conversion Approach During the Design and Implementation phases of the project, we will work with City's data team to determine the exact data elements and quantity to be converted and prepare the Data Conversion Strategy. Standard data conversion templates along with detailed specifications will be provided to the data lead(s)with instructions on how to provide the data.At least two rounds of data conversion will be conducted prior to Production to ensure: • The templates capture all data elements required for conversion. • The data team has a defined plan to extract and transform the data. • Accurately estimate the time needed to complete each data conversion task for cutover planning. • Identify any issues with data in advance of Production data conversion. FourthSquare has performed data migration/conversion from legacy systems for all our clients. Data migration is done in two stages: data extraction from legacy systems and data upload to Oracle cloud. Data extraction and data cleansing is the sole responsibility of City. We will provide data templates to be completed by City's data lead and sent back to us for upload to Oracle cloud. Data Cleansingle Extract&Transform Data Upload&Error r Data Validation Data Reconciliation Reporting , Recognition&Sign off and issue Fix CRP Workshop Manual SIT Run UAT Run Go-Live Run Success% + PF i r TruePoint Data Conversion Plan TruePoint will be responsible for taking your existing data (including account and usage data) and converting it into our system. At the beginning of the project, we will request a copy of your data in a consumable format so that we can begin analyzing it and documenting the mapping rules between the old system and TruePoint in the Data Conversion Mapping Document. This is an iterative process that will require review sessions with your staff to answer questions about the data and to assist in defining the rules, so the data conversion is thorough and accurate. Our implementation team has extensive experience converting data from many different legacy systems and has developed standardized procedures for generating the various records within the TruePoint application. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 28 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System As each major step of the conversion is completed,our implementation team performs thorough testing to ensure the accuracy of the rules and mapping and will also schedule meetings with your staff to review the data together. Once the initial conversion has been completed, we schedule the installation of the software in your environment and our first training (Core Team Training). With this training, your staff will be given access to the test environment which they can use to review data and procedures as they become available through the rest of the project. TruePoint acknowledges the data conversion requirements identified in the RFP and has listed them below. • All information on all active, "final", "suspended", and "vacation" utility accounts including account notes. • All valid City addresses from GIS, including RPT#. • All information for the past seven years on all inactive accounts. • All information on accounts that have a balance. • All lots and detailed information for lots and meters that are active. • All deposits with balances. • Our data uses customer numbers as the account number,with a sequence.Conversion will have to take this into account. V. Report Development It is expected that the system willprovide the ability for end-user querying and reporting to beperformed without impacting the performance of the transactional system. It is also expected that the system will provide the ability to upload and download information ensuring integrity of uploaded information. Proposer is expected to provide assistance to City staff in the development of needed reports, via technical training on the tools used for report development, database schemas and architecture, etcetera. Oracle Cloud Applications are delivered with reporting tools that are real-time and report off the Oracle Cloud Application transactional database. Oracle Cloud Applications are delivered with reporting tools that leverage a centralized security model. Users are served up data based on their security role. The reporting tools support drill down actions allowing users direct access to transactions. Reports and dashboards are real-time. Users can log into the system to see reporting data OR reports can be delivered through email, mobile app, etc. Individual report settings include Reports can be scheduled or event based. The report definition can be sent as link OR the report itself can be delivered to a user. vi. Integrations and Interfaces Service Based—For loosely-coupled integration,Clients can use web services(SOAP,REST or ATOM) as a standardized way of integrating Cloud services with other disparate application systems.These web services, when invoked or initiated by an event, carry out business process functions. The function of each web service is described in a Web Service Description Language (WSDL) file. This simple architecture ensures that users need only invoke the required web services and expect the correct results, without going into further complexities. Delivered Oracle Cloud Application web services are documented and available for review via the Oracle Help Center (http://docs.oracle.com) or the API Catalog Cloud Service(hiips://apicatalog.oraclecloud.com/ui/). Integration approach is file based using Oracle Integration Cloud(OIC).OIC supports both batch/Bulk integration and file processing. The files are placed in the SFTP server, and the integration will fetch Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 29 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System the files, perform the data transformation, and import into ERP Cloud using the Import Bulk Data process. FTP to ERP Cloud Integration Architecture FTP r 'I- Send F BDI hW to F RP Cloud ORACLE' inaw wW Oela From SO" r aeo CatDactc event ERP CLOUD aouo i l API The integration will fetch the files periodically and import them to HCM. To create the connections required for the integration, Oracle HCM adapter is used which enables to create both inbound and outbound integrations. The adapter simplifies the Oracle HCM communication with other SaaS and On-prem applications. Once the connections are created, the integration can be created using the schedule orchestration style. Schedule orchestration is a multi-step integration flow invoking applications,integrations and processes triggered by a schedule. Standard oracle tools are leveraged to support integrations/interfaces like: - File Based—Clients can use File Based Loader or Spreadsheet Loader as a powerful and efficient method of importing bulk data into Oracle Cloud Applications.The upload process can be scheduled to reduce manual intervention in the integration process. In addition, File Based Loader and Spreadsheet Loader leverage the core business objects that serve as the foundation for the Cloud solution—meaning that all edits, business rules and validation logic that an online user would be subject to also govern all data being loaded into the Cloud Applications as well. Spreadsheet Loader allows business users to work with data within a familiar Excel format and upload bulk data into the system. - HCMData loader(HDL)—HDL is a powerful tool for bulk data loading and integration.It supports one-time conversions and incremental updates, multithreaded processing, flex fields, attachments, translations, and much more. HCM Data Loader imports data initially to stage tables, where some validation occurs. HCM Data Loader then loads valid logical objects from the stage tables to the application tables. - ystem Extract—Used for outbound integration,the data is extracted using OTBI for distribution to third party systems. - Web Services—Web Services are utilized as a standardized way of integrating Cloud Services with other disparate application systems. Our team proposes to apply a step-by-step evaluation process that consistently applies to each individual integration requirement to capture various aspects, expectations, technical infrastructure requirements and other dimensions. This would help City to reduce customizations and thereby keep the Total Cost of Ownership (TCO)down. Key steps to be performed include: - Determine list of required interfaces (based on existing integrations inbound and out, interim interfaces to legacy applications, as well as new required integrations) - Determine if interfaces can be consolidated,or removed,to streamline the integrations. - Validate origin,destination,frequency, data set. - Define required data transformations and level of complexity. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 30 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System - Determine system tooling to be applied. - Update requirements disposition,project documentation - Escalate gaps for additional solutioning. Our proposed solution has the following integration related functionality: FunctionalityDescription Delivered Integration Leverage the delivered Data Loader and Spreadsheet Data Loader templates to Templates facilitate bulk data loads into the Oracle Cloud Applications. API support Interact with the Oracle Cloud Applications via SOAP services and REST APIs, including the ability to expose Oracle Business Intelligence Reports via a SOAP service. Pre-built SaaS and On- Simply and securely connects SaaS with cloud and on-premises applications using Premises Connectivity an extensive library of pre-built adapters and recipes for enterprise grade integrations. The full requirements for each integration will be determined during requirements analysis (Design phase), based on factors like frequency of the interface and size of the file or data set, weighed and evaluated against the inventory already provided by the City. For Inbound integrations into the Oracle Cloud, we will provide the Oracle delivered File Based Data Import (FBDI) templates, which define the structure in which the data needs to be interfaced by the source systems,to the City. This can be extended where needed with additional templates. Administration and Management The ability to manage jobs using administrator privilege and access is provided natively in the form of graphical user interface with multiple features to make the process efficient and manageable. Similarly, integrations within Oracle Cloud are managed using a common framework to allow simplified training, simplified ownership,and overall efficiency.Oracle Integration Cloud Service provides developers and administrators monitoring dashboards with a comprehensive view on their integrations including message in-flow, failure rate and other key metrics. Users can also search for transactions of interest based on key business identifiers such as Order#,identify failed transactions,drill down for root-cause analysis, and review,resubmit, and abort errored transactions,all from a single monitoring dashboard. Point to Point integration and alternatives. We have proposed a solution that offers multiple ways for the City to integrate Oracle Cloud ERP with existing infrastructure and applications, including integrations based on real-time calls or batch transactions. • Inbound Integration For moving data into the Oracle Cloud, two options will be provided, (1) File Based Loader and (2) Spreadsheet Loader. These solutions include error correction functionality and support the same common set of objects that are required for integration. • Outbound Integration Our solution will take advantage of Oracle Cloud extraction tools that can be scheduled to run to automate the data extraction and delivery process.To export data from the Oracle Cloud,the solution generally leverages the Oracle Transactional Business Intelligence (OTBI)tool. - Oracle Transactional Business Intelligence (OTBI) - Oracle Cloud Applications support data export by leveraging OTBI and Business Intelligence Publisher(BIP) for ERP/HCM to export Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 31 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System any data of their Oracle Cloud. Users create export data sets based on queries. BIP offers the ability to export data into a variety of different formats, multiple delivery methods, data encryption, and scheduling capabilities to automate the entire process. - The HCM Extract tool is ideal for complex extraction needs on a defined set of HCM data objects. The data can be extracted into several different formats, including HR-XML, and delivered to destination systems through a number of different methods. • Web Services Oracle Cloud supports the use of SOAP and REST Web Services to provide a standardized way of integrating Cloud services with other disparate application systems. Atom feeds provide notifications of events and are tightly integrated with REST services. During our requirements gathering and design activities we will review and validate the City's integration requirements considering the following: - The current points of integration are shared by the City. - Revisions the points of integration inventory based on the future state system architecture vision and projected system retirements. - The capabilities of the Oracle application - The capabilities of the external parties of the integration and leading practices. This will allow us to select the most appropriate mode of integration without foregoing any efficiencies that may be available to the City overall. vii. Training Plan Proposer will provide scheduled initial implementation training including measurable goals. The core guiding principles for capability development involve two targeted training audiences.The two targeted audiences are: (1) project team members who will participate in the implementation process, and(2)end-users who will interact with the new system.Because the training requirements are different for each audience,two training methods are used. The two training methods are: Functional Team Training (FTT) - This training is a conceptual overview of Oracle Cloud products depicting its look and feel and high-level functionality for key business processes. System terminology and special features are also introduced. Team members will utilize this information to effectively participate in FourthSquare's Discovery Sessions led by FourthSquare's functional team members. End-User Training (EUT) -Methods for training end-users must ensure that learning experiences and supporting documentation are clear, concise, and user-friendly. Oracle Cloud was designed and developed using best business practices. Therefore,FourthSquare's EUT materials will reflect Oracle's best business practice approach in a clear,concise,and user-friendly manner while incorporating specific tailored functionality. Training Activities Deliverables Strategy • Determine training and delivery • Training plan mechanism. • Develop training curriculum of courses and maps to end users. • Comprehensive end-user training program Assessment • Map business functions and determine • Audience analysis training locations. • End user assessment • Understand training needs by business based on function and the end users involved Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 32 of 71 FourthSquare Enterprise Resource Planning(ERP)System implementation changes Material Development . Utilize past training experience and • Training outlines for materials for developing best practice instructor led web- manuals. based conferencing • Create additional training materials and self-paced training based on test cases along with new test cases identified during the implementation. • Enhance training material with up-to- date module functionality Environment and Data . Develop a training environment close to • Training environment Production environment. and data plan • Provide ability to learn and practice in the environment Logistics • Identify detailed training schedule. • Training logistics plan • Plan method of training based on locations and determine method Training sessions will be offered by business process and a combination of business processes to group them into a Training Course. The following are the Training Course types are suggested for this implementation. A detailed training strategy curriculum will be developed during the"Define Phase". FTraining Course Description Application Reviews After each build cycle,FourthSquare will demonstrate the core configurations completed in each module by walking through common business processes. Functional walkthrough of core business processes within each Functional Training Sessions module. Training content will be developed for each business process. A combination of Administrator Guides and live demonstration will be used during the training sessions. Self-Guided Application Review Self-guided application review is an opportunity after the Application Review and Functional Training conducted for City team members to become familiar with the system on their own. Technical 101 Technical walkthrough of fundamentals for Security Roles,User Administration,Workflow, OTBI Report Development,Integrations and Patch Cycles. Oracle Service Request(SR) and FourthSquare will provide an overview of how to log Service Support Process Requests(SR)with Oracle Support and the process to escalate requests when necessary. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 33 of 71 FourthSquare Enterprise Resource Planning(ERP)System Critical Success Factors for Training Based on our experience,the following are principles for a successful training strategy which prepares end users and technical teams to perform their jobs in the new environment: • Set early expectations. The business must have a clear understanding of how they will be impacted prior to attending the training and understand the business drivers behind the change. Training is not an event; rather, it is a process that begins well before students enter the classroom or begins the online course and continues after the training session. • Make it personal. Training content needs to be tailored to address real-life examples, scenarios, and business processes that students will encounter in their roles as a direct result of the implementation. They need to understand how their roles may change—both from a process and technology perspective. The content also needs to consider the differences between audience groups. For example, within the Finance function, training should focus on how the implementation will reduce transaction processing cost by elimination of manual activities in finance and accounting business processes and improve financial visibility into business transactions. • Provide the "what's in it for me"perspective. Users need to know how their world will change, and why they need to change with it. Training must provide the business vision and specific examples of where advantages to the new tools and processes exist specifically for them, as well as the possible straight talk for those changes that are unpopular. • Consider different learning styles. Using a variety of tools and delivery methods for training, including remote, computer-based, and in-person,will accommodate different learning styles and timing/scheduling requirements. Training Delivery Methods of Training Execution • A training workshop for the City trainers and/or Business Process Owners(train-the-trainer) o This will be coordinated between FourthSquare Lead Consultant (SME) /trainer and City trainer/Business process Owner. • Formal end user training sessions o City training coordinator will work with respective City Trainers or City business process owners to create a training schedule based on end-user availability and topic. • Web-based, Online training instance for practice and skills improvement(self-paced) o FourthSquare will create the training content based on the business processes and functions identified but it will be City trainer responsibility to coordinate and create end-user training content based on business variations. viii. Documentation Development It is desired to have the selected Proposer take the lead on development of end-user and technical training material. Proposer is expected to provide user manuals in digital format for use by City as part of the initial training and on-going operational support. FourthSquare will create training content for City's requirements and applicable business processes. Each business process will have a training course.Once we finalize the list of business processes during the defined phase,we will develop a detailed training curriculum. FourthSquare will be providing: • Training Needs Assessment and Strategy(MS Word) • Training Project Schedule(MS Project or MS Excel) • Training Course Outlines(MS Word or PDF) Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 34 of 71 FourthSquare Enterprise Resource Planning(ERP)System • Training Course Evaluation Form(MS Word or PDF) • Training Courses or Content based on defined business processes (MS Word or PDF) • FourthSquare Recommends providing learners with hard copy of materials. FourthSquare along with City Trainer/City Business Process Owner will be responsible for: • End user training • End user training content(modified version of training content developed by FourthSquare) and based on any applicable business variation. • Job aids, quick references(as needed) • Training delivery support(as needed) The preferred way of discoursing the training will be though online and documentation however physical training also can be arranged as per agreed upon terms in the SLA. ix. Estimated Timeline It is requested that an estimated timeline of implementation be included in the Proposal that the Proposer could commit to which would fully encompass the scope of the project. Please use an estimated project kick-off date of October 2, 2024. Implementation Plan & Approach Referring to the scope requested,with our experience and due to the nature of the public sector business, we have included the following Oracle SAAS Cloud integrated application modules mapped to your requirements. Oracle Cloud SAAS solution comes with flexible application suites that covers solutions in the respective areas like finance, human resources etc. but an integrated platform that is interconnected and share common application usability like people records, approvals etc. We will be able to sit down with you and layout clear objectives and goals to make the City successful and deliver a most efficient, one integrated solution in a cost-effective manner. Below is the list of modules/functionalities as part of scope— Phase Pilar Application Functionality Oracle Cloud Applications B91079-Oracle Fusion Enterprise Resource Planning Cloud Service; B91080-Oracle Fusion Enterprise Resource Planning for Self Service Cloud Service General Ledger,Accounts Payable, B73948-Oracle Fusion Document Recognition Cloud Service Accounting, B91082-Oracle Fusion Procurement Cloud Service; Phase lA Purchasing& Accounts Receivable,Fixed Assets B91083-Oracle Fusion Procurement Self Service Cloud Service Budgeting Project and Grant Accounting B91057-Oracle Fusion Supply Chain Execution Cloud Service Purchasing Budgeting B91074-Oracle Enterprise Performance Management Enterprise Cloud Service B91077-Oracle Additional Application for Oracle Enterprise Performance Management Enterprise Cloud Service B85800-Oracle Fusion Human Capital Management Base Cloud Service Phase 113 Human Resources Human Resources,Payroll,Time& B86334-Fusion Payroll Cloud Service for United States Labor B75365-Fusion Time and Labor Cloud Service B94933-Oracle Fusion Workforce Compensation Cloud Service ALL Common Applications Reporting&dashboards Transactional Business Intelligence TEST Environments Application rollout The "desired state" will include all the requested functions as in the RFP including converting data from the legacy systems, integrations, and reporting. For this RFP response and based on our public sector experience, we recommend taking a phase-wise approach (grouping of solutions) with flexible Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 35 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System options. For this size of project, it should take 9 months to go-live and we offer 6 Months of support for the core Finance and HR functionalities with parallel testing. Depending on City's plan to start the project we recommend the below plan in phases— Implementation Plan Planning Build&Develop 2ining Phase 1A Accounting,Purchasing&Budgetinglill""IltemrlrKvlellilT!!!!UA!T% Design/PILOT 6-monthsupport Phase 1B Human Resources,OTL,Payroll,WFC Phases same as above 6-month support The TruePoint Implementation for Utility Billing will also be executed in parallel to this with 9 Months. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 36 of 71 m11! FourthSquare Enterprise Resource Planning(ERP)System F. STAFFING PLAN FourthSquare considers this as critical for mutual success and will dedicate leadership team along with key project professionals that have prior public sector experience. FourthSquare team has mix of expert in functional area and cross-functional resources as well depending on the module/functional area. The city will be working with separate resources having expertise in their field of specialization as well as resources with cross-functional expertise. Key Leadership commitment: a) Paula Casey—Project Manager&Business Leader—FourthSquare b) Kerry Boudreau—Sr.VP, Sales—Account Executive The proposed resource pool includes FourthSquare SMEs by subject area as below: a) Project Manager b) HCM Lead c) Payroll&OTL Lead d) Technical Developers e) Finance Architect f) Finance Lead g) Planning&Budgeting Lead Paula Casey, PMP Project Manager, Business Leader Professional Summary Experience spans across a variety of industries like Healthcare, Higher Education,Government,and Defense. Professional Background In depth experience in Human Resources, Succession Planning, Position • Over 15 years of experience in Business Process Reengineering, Management, Compensation, Talent Management, Profile Management, Project Management, Human Resources, Benefits, Compensation and Human Supply Chain Methodology,and Agile Methodology. Talent Management consulting.Extensive experience in guiding clients Project Management of teams as large as 25+ members. Client in Business Process Re-engineering,Project Management,Testing,and Management as lead functional expert for multiple vendors Change Management. As an acting Senior Business Partner,she has helped executive-level clients take strategic organizational goals to Experience leading large teams, including managing multiple woexecutive-level fruition through technology, processes, reporting, and organizational streams to drive work toward project deadlines and deliverables that are change. on target and meet client expectations. This includes system design, deployment, business process flows, SDLC, testing, configuration, and • Has supervised many large and small department activities and led ongoing maintenance. numerous workgroups, committees, and consultants through numerous projects. Worked with many HR executives to translate their Decomposing high-level business and user-defined requirements into organization's strategic objectives into functional deliverables which system functional requirements and functional design document can be tracked and reported. Defining project attributes, interfaces, constraints and compliance Certifications: requirements • Oracle Global Cloud HR Professional Experience working on all project phases of HCM implementation including fit/gap,configuration,testing,and project management • Workday HCM and Talent Management • PMI certified Project Management Professional -Children's Hospital Colorado - • SPHR AND GPHR certification ava a p =3 CherryRoad Alcon �'� mrnnumgcs • Prosci®Certified Change Practitioner(PROSCI) —1'.4.+..1— Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 37 of 71 Fo u r t h S q u a r e Enterprise Resource Planning I ERP)System Arun Senapathi HCM&Payroll Cloud Architect,Functional Professional Summary Lead&Practice Leader • As Oracle HCM Cloud Solution Architect,architected clients to structure 40 their payroll solution that included Costing Setup,consolidationof payrolls, Professional Background configuration of Payroll elements,TRU&PSU Setup. • Over 27 years of experiencein IT as Oracle HCM Cloud Architect and Successfully managed and implemented Oracle HCM for countries like AU, Factional Lead,Oracle HCM Cloud Practice Leader,Oracle HCM NZ and CA-Involved from the'get-go',designed the project plan,led the Application Development Manager, Techno Functional Lead, and team through requirements gathering, analysis, design and post Projectmanager. implementation • Expertise in Program Management,and Implementation Experience at As Oracle HCM Cloud Practice Leader,built a team of great consultants, leading professional services firm&Deployed HCM and ERP for many developed Implementation methodology for HCM Cloud projects and large global customers including one of the largest banks in the USA played a technical strategy leader-Designed and built'Add-on'products having approx 140K employeesacross the globe-Led and delivered that support Oracle HCM Cloud suite of products to help clients to get 20 Oracle Cloud projects with Client footprint across the globe in last maximum benefits 8 year • As Oracle HCM Techno Functional Lead developed best practices for RICE • Expertise in advisory services as well m building and executing development, AIM based documentation system, SOPS for end user roadmops for multi-phased programs that maximize value, minimize processes,developed Roodmap,Standards,Best Practices,RICE elements risks,and enable organizations to deliverchange- and User Training using Oracle suppliedtools and proven methodologies • Has been a consistent and well-respected presenter at various Oracle Application User Group forums-Has been presenting at NCOAUG on •i,._„ various topics such as'How to maximize ROI b implementing Oracle :A ""` ' Identity Management'- peo Q RAC LE • Expertise in Oracle HCM Cloud Modules- Oracle Cloud Core HR, OIAEX' oA3�S Absence,Benefits,Time&Labor,US&CA Payroll,Recruitment and HIGMMfR Onboarding. HeftX__ �PTIC QFIM Health eHir--......,ou,.,, Madan Gallo Oracle HCM Cloud Lead +� Professional Summary Currently Payroll Cloud Functional Lead on a large Oracle HCM/Payroll Cloud Implementation(HCM,Performance Management,Payroll and Self- al Background Service) for a telecommunications. Responsible to gather customer Profession • Over al years of experience in HCM Functional Architect with relevant requirements and created FDD (Functional Design Document) with gap HCM experience in the capacity of HCM Functional Lead,Functional analysis;Designed Organizational hierarchy,Position hierarchy,Approval Solutions Architect and Systems Architect Hierarchy and process related to approvals. Implemented approval process in Core HR offering. This project is a complete Oracle Cloud • Leads projects to design, implement, upgrade, and support Oracle project implementation- HCM Cloud systems according to customer requirements.Coordinates all operational technical aspects of the project phases to deliver HCM Functional Lead; Performed Feasibility Analysis and Developed according to best practices and standards. Professional strengths Project plan,Business Requirements,Functional Specs and Test Strategies, include managing large projects budgets and leading large cross- Responsible for implementing Oracle Fusion HCM, Talent Management, cultural, cross-functional teams of up to 120 personnel in a matrix Compensation Management,Integrations (historical data,work structures onsite offshore global delivery organization. Currently seeking and GL Accounts), Time Keeping Benefits and Payroll; Responsible to professional opportunities as an Oracle HCM Consultant. Configured Fusion Global Benefits and Talent Management application; Configured Performance Management and Talent Management • Madan holds a Masters degree in Computer Science from Western Kentucky University,Bowling Green,Kentucky aiu119 (, Functional Expertise Backe�°aieh LM • Oracle HCM Cloud Functional Lead; (Core HCM, Payroll, Benefits, Talent Management&Compensation) i LUMENTUM NATIONAL • Data Conversion �' `' 79INSTRUMENTS • Extensive experience in architecting system solutions UBIQUi I i Adventist Health Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 38 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System Krishna Rao HCM, Payroll & Benefits,Absence and ProfessiorsalSummary OTL Experience in SDLC,Agile Process methodologies to implement Oracle projects Professional Background Experience of working in a different client environment(Direct • 13+ Years in Fusion/Cloud HCM Workforce Rewards (Payroll, business Interaction with clients)able to articulate technical jargon to Benefits,Compensation),Workforce Management (Core HR,Absence a non-technical audience_ Management,Time and Labor)Modules and Oracle E-Business Suite, Designed,Developed and implemented HCM Cloud Payroll.Custom • Involved in over 7 full I ifecyc le projects,Support and upgrade projects Balance Load Process Suite in diverse sectors handling several roles as Project Manager, Project Trained over 100+trainee associates on Oracle FusionCloud/EBiz Suite. lead, Solution Architect, Business Analyst, Functional Consultant, Created and demonstrated Time and Labor,Benefits POC for ANTHEM Technical Developer and Trainer_ customer.Rolled out critical implementation for NGHA Designed and Extensively worked on Functional Processes Design,Configurations and implemented new custom daily payroll process components Technical components Design,Development— Implemented acquisition on boarding engine process for new hires/rehires for different acquisitions of Humana Experienced in Solution design • Fast Formulas (OTL, Benefits and Payroll),Integration and Reports workshop and creating Configuration workbooks/Guides,Training (HCM Extracts,Cloud Reports 8 Analytics). manuals,Test Scripts etc for different phases of the project. • Trained on Fusion Global Human Resources Implementation,Fusion Expert in providing custom and workaround solutions and solution design Benefits,Fusion Payroll from Oracle University capabilities Certifications: 11111IJCIANTAS 1100 Jefferies .�v.aoor, • Oracle Payroll Cloud 2020Implementation • Oracle Global Human Resources Cloud 2016l nip lementation Anthem.09 Cognizant I I I I • Oracle E-Business Suite RI 2.1 Human Capital Management Specialist c—sy c ,�,r r Q Cisco sma crow TruePoint Staffing Plan Included below is a list of TruePoint personnel that will be assigned to your organization's implementation project along with their role and time commitment to the project. Name Title Time Commitment Jay Lum Senior Project/Implementation ManagerFull-time Drew Raab Data Conversion SpecialistFull-time Bradley VP,Product Strategy&Services art-time Freeman Robert Strouse Chief Technology Officer art-time Kevin Lachance Lead Support Engineer&Technology Consultant art-time City resources that will be needed during the implementation are dependent on your organizational structure and the distribution of knowledge as it relates to utility billing processes and procedures. The TruePoint team will need to engage with Subject Matter Experts in the various functional areas to analyze processes,review data conversion details,validate configurations, and test application procedures. These functional areas include but are not limited to Customer Service,Account Management, Finance,Billing, Delinquency Management, Service Orders,Meter Management,Reporting,and Integrations. We typically estimate that City staff will be required for 25%of the total estimated services hours for the project,which is about 340 hours total. These hours would be spread over the different Subject Matter Experts and over the course of the whole project. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 39 of 71 m11! FourthSquare Enterprise Resource Planning(ERP)System G. ON-GOING SUPPORT AND MAINTENANCE FourthSquare realizes the need for a sustained application support and training beyond the Go-Live period for successful adoption of the product by all the user groups within the organization.In consideration of the support need and based on our experience in similar projects, we have included a 6-month post Go-Live Application support service based on remote / shared services at no additional cost. Oracle Cloud product software comes with a no additional maintenance cost as this is already included in the product subscription(through the life of the subscription term). The FourthSquare resources providing this support will be the same resources who participated in the development and implementation of the system. This will ensure a smooth transition for the end-users in a manner that provides a "safety net" by keeping the key consultants available as and when needed. Once the system is live in production,FourthSquare shall provide the required level of post-production support. As part of the postproduction support, FourthSquare support team will attend to the logged issues as per the assigned severity and work towards the closure/fix. The teams can also raise service requests to Oracle Support services though support.oracle.com Oracle provides enhanced electronic-based and telephone technical support to customers with a current technical support services agreement.Customers have access to the largest and most advanced support organization in the world. The Hosting Support team or Technical Support Team will work closely with customers through the service request process to resolve any environment related issues. Service Services are available to resolve product issues quickly and accurately providing answers to product questions that are general or routine in nature. Technical support is provided for issues(including problems created by the user)that are demonstrable,running unaltered, and on an appropriate hardware, database,and operating system configuration, as specified in the customer order or program documentation. FourthSquare's proprietary Application Managed Services (AMS)approach MS-LITE fills in the gaps mentioned above. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 40 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System Managed Services (MS-LITE) Lean AMS Innovate Transform Extend •Lem Service Model •Automate Services Reduce Waste •Technology Agnostic •24/7Fo11ow the Sun Prorers Driven •Agile •Capabilities Across BUs •ITIL Based Predictive DevOps&Automation •Cloud Mmaged Services •SLAs ROI Bmed Robotic •Hybrid IT Benefits of Managed Services: • Reduced cost of managing your Oracle environment • Minimize application downtime • Dedicated remote resources • Routine maintenance of Oracle application fixes • Routine scheduled maintenance windows • Timely resolutions to identified issues • Routine review of environment and operations • One Solution for extended support and continuous improvement Oracle provides 24/7 online technical support as part of your subscription. Through MOS (My Oracle Support) login-in, City of Twin Falls would be able perform a variety of functions such as: Log a New Ticket, Manage SRs(Service Requests),Escalate Severity,Download and Receive Critical patch updates,and much more.More can be found by following the link: https:Hsupport.oracle.com/portal/. Help Desk Support for Oracle Cloud Services consists of- • Diagnoses of problems or issues with the Oracle Cloud Services. • Reasonable commercial efforts to resolve reported and verifiable errors in the Oracle Cloud Services so that those Oracle Cloud Services perform in all material respects as described in the associated Program Documentation. 0 Support during Change Management activities described in the Oracle Cloud Change Management Policy. • Assistance with technical service is requested 24 hours per day, 7 days a week. • 24 x 7 access to a Cloud Customer Support Portal designated by Oracle(e.g.,My Oracle Support) and Live Telephone Support to log service requests. • Access to community forums. • Non-technical Customer service assistance during normal Oracle business hours (8:00 to 17:00) local time. 0 Oracle outlines these policies in Section 5 of the Oracle Cloud Enterprise Hosting and DeliyM Policies. In addition to our 24/7 online support,Oracle provides its customers with a support community to discuss,share, and receive personalized feedback on any issues whether functional or technical in nature. Receive all relevant documentation for:Best Practice SR management,User and Admin on-demand training,and engage with Oracle development. Provided is a link to watching the video or option to download DOC ID 553747.2 Oracle Service Request Flow and Best Practices: Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 41 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System https://support.oracle.com/epmos/faces/DocumentDisplgy? afrLoop=28206558017635&parent=DOCUMEN T&source1d=553747.2&id=1540335.1& afrWindowMode=O& adfctrl-state=fbtnlmflb 45 Whether you are escalating the severity/priority, requesting a duty manager for a call back, or scheduling a development workshop in a time sensitive extreme case,this can all be done through your MOS Dashboard.The document below addresses how to set severity and process for escalations. DOC ID 199389.1 Service request resolution is a collaborative and iterative process which requires City's active participation. A well-formed service request includes a detailed description of the issue or question,troubleshooting actions already taken, and a description of the business impact.Large, complex problems reported to Oracle Support through service requests may take time to resolve.At times,the service request may not progress fast enough to meet your implementation or upgrade plans or project milestones. In such cases,you have these options: • Determine if the service request severity is set correctly Service request severity setting should comply with the categorization specified in the "Severity Definitions" section of Oracle Cloud Hosting and Delivery Policies.You can request Oracle to change the severity by contacting the Support Engineer through the service request or by calling your region's support contact phone number. Request management attention to the service request 1. Does Proposer have an annual User Conference? Yes 2. Does Proposer have a telephone support line? Yes 3. What hours is support available? (In MST/MDT)time) Customer service assistance during normal Oracle business hours(8:00 to 17:00)local time 4. What is Proposer's average response time(minutes) for a 15 mins telephone response to a service call? 5. What is Proposer's guaranteed maximum response time 480 mins (minutes)? TruePoint Utility Support I. Does Proposer have an annual User Conference? TruePoint hosts a User Conference once every two years. 2. Does Proposer have a telephone support line? Yes. 3. What hours is support available? (In MST/MDT Support is available from 8am-5pm time) MST/MDT. 4. What is Proposer's average response time 5 minutes (minutes) for a telephone response to a service call? 5. What is Proposer's guaranteed maximum response 60 minutes time(minutes)? TruePoint software subscriptions are annual agreements that entitle the licensed Agency to an unlimited number of users for the software product licenses and to the following technical support and maintenance services as follows: Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 42 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System 1. All major and minor updates, modifications, features, enhancements,bug fixes, error corrections,patches, and subsequent releases for the Software offered by TruePoint to any of its other customers or the general marketplace as they become available to said customers or the marketplace. 2. All current Documentation for the Software as it becomes available for any of TruePoint's other customers or the general marketplace. 3. Unlimited technical support, advice, consultation, and assistance for the Software, including, and without limitation, troubleshooting, configuration, and upgrade inquiries, promptly provided by qualified professionals of TruePoint during all normal business hours via telephone, fax, internet, and email,as well as onsite at the Licensee's main office. It is not expected that there will be issues which arise outside of normal business hours—however, TruePoint staff will be available to provide after-hours support during pre-arranged critical operational events. Subscriptions start at software installation and continue for 12 months. Annual subscription contracts are renewable each year by prepayment of the annual fee. TruePoint will notify customers via invoice well in advance of the subscription renewal date. If the Agency does not wish to continue the subscription,the Agency must provide TruePoint with written notification.Failure to pay the annual subscription fee promptly may result in contract suspension or termination. TruePoint will ensure faults are fixed in the product in a timely fashion to minimize any operational impact. Due to the nature of software,TruePoint cannot guarantee that the product will always be entirely free of faults, but TruePoint will commit to providing corrections as promptly as possible based on the priority of the issue. Phone Support—Telephone and email support is available Monday through Friday, from 7:00 a.m. to 5:00 p.m. (PT) and provides customers with assistance and information about the general software use support, troubleshooting, and detailed support on your organization's specific software solution. All support calls will be dealt with as promptly as possible. As a courtesy to other callers,training cannot be handled over the phone. Telephone support for Priority-Critical issues is available 24/7, Sunday through Saturday. Response Times and Escalation Most items are resolved within a day. Sometimes the issue is a question about the software and other times there is a bug that requires a fix to the software. If it is a bug,we will determine the priority and if there are any workarounds. Generally,we will fix the bug and schedule an update within days to a week. We achieved this goal by promptly viewing all requests to gain an understanding of the issue as quickly as possible. In many cases we will call directly or conduct a Zoom session to work with the user to gain an immediate understanding of the issue.Interacting in real-time with the user and seeing the issue firsthand can minimize the time required to determine the complete issue and its potential cause. Once identified as a bug, support staff will work with software development to develop a solution and fix. An outline of our categorization/prioritization of support issues and formal response/resolution commitments is listed below. Our goal is to provide customers with immediate response during regular support hours and resolve issues as soon as possible. • Critical —Customer is unable to use the application,or a system component has a failure such that normal work operation is significantly impacted —Response time to acknowledge issue and begin working on corrective action within two(2)business hours Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 43 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System — Commitment to continue working on problem until resolution, or an acceptable temporary fix (i.e., patch)is deployed • Standard —Issue exists with the application,but most functions are still usable and some circumvention or work- around is possible to provide service,or failing function does not significantly impact normal work operation —Response time to acknowledge issue is no more than eight(8)business hours — Provide resolution within thirty (30) business days (unless otherwise agreed between customer and TruePoint) • Minor — Issue does not affect the application's functions (i.e., text of message or report is poorly worded or misspelled) —Response time to acknowledge issue is no more than eight(8)business hours —Provide resolution within ninety(90)days(unless otherwise agreed between customer and TruePoint) Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 44 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System H. SOFTWARE UPDATES AND DISTRIBUTION Oracle provides quarterly updates as part of the service. Updates occur 4 times per year(every three months) and are included in the cost of the service subscription. Documentation,help,and release notes are updated with each release of the service at no additional charge. Updates are lightweight and nature and typically do not require additional end-user training. Typical Typical Vendor FrequencyUpgrade Types months) Low Cost High Cost Low Cost High Cost Version Upgrades 3 months Included with Included with N/A N/A uarterl subscription subscription Major Upgrades 3 months Included with Included with N/A N/A (quarterly) subscription subscription Minor Upgrades 3 months Included with Included with N/A N/A I(quarterly) subscription subscri tion Local customization and configuration are not affected when installing new releases. The proposed solution is for a SaaS deployment. Operational tasks such as installation, patches, ongoing maintenance, upgrades, monitoring, and backup and recovery are managed by Oracle Cloud Operations and those costs are included as part of the subscription costs. In order to benefit from rapid innovation, Oracle requires customers to uptake new releases as they are made generally available. Product enhancements (updates) to Oracle Cloud are provided quarterly, presenting our customers with an updated model focused around continuous improvement to their solution. These updates include software and infrastructure improvements,optimizing customer experience throughout the year. These updates are part of our customer's subscription and do not require additional charges. The City is responsible for the time and cost of testing quarterly updates in your environment(s). As product updates are released you will want to evaluate the functionality contained in each update and determine which, if any, functionality you want to enable. In addition, if any of that functionality impacts your existing interfaces to other systems, you will want to re-validate those interfaces. 1. Will Proposer provide all periodic enhancements to Yes,updates are included in software at no additional charge,beyond the Annual the cost of the current service Support Agreement? Next major upgrade included? subscription 2. Does Proposer provide product upgrades automatically or Upgrades are provided on demand? automatically. 3. How does Proposer normally release product upgrades or Updates are provided 4 times a enhancements? year(every three months).The upgrades are released and installed over the Oracle servers. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 45 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System 4. What is Proposer's process in the event an update fails to The oracle tests the release work properly? rigorously on the testing servers before being released to the production servers. However, as an additional cautionary measure Oracle releases the updates in the switched off mode. Means the customer can read documents, go through the training and then take a call on switching on the module. TruePoint Utility Software Updates Since the TruePoint platform is a true web-based platform, software updates only need to be performed server side and no client-side updates are required. As part of our Support& Maintenance agreement that is included with our annual subscription fees,TruePoint provides software update services for both on-premises and cloud- hosted solutions.In the case where the application is deployed on-premises,we would request access for specific TruePoint staff to be able to deploy software updates in coordination with the City. 1. Will Proposer provide all periodic enhancements to TruePoint provides all software software at no additional charge,beyond the updates at no additional charge beyond Annual Support Agreement?Next major upgrade the annual subscription fees. The next included? major upgrade would be included. 2. Does Proposer provide product upgrades TruePoint will typically schedule at automatically or on demand? least one update per year to keep our customers on the current version of the software.But we also provide updates on demand depending on the needs of our customers. 3. How does Proposer normally release product We provide release notes to our upgrades or enhancements? customers identifying new features and updates in the new software version. Customers then have the option of requesting an update. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 46 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System 4. What is Proposer's process in the event an update While this is a rare occurrence,we do fails to work properly? have a process in place in case this happens. Our Helpdesk team will create a ticket in our Zendesk system identifying the details of the issue and the severity. Someone will be assigned to troubleshoot the issue and depending on the findings,development will provide a hotfix for the issue. We would then test the hotfix internally to validate the issue has been resolved and then coordinate with the customer to apply the hotfix. Finally,we would identify any other customers that had the update applied and schedule the hotfix to be applied to their system as well. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 47 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System I. SYSTEM PERFORMANCE AND RECOVERY System Performance The Oracle Fusion Cloud is a true SaaS solution which runs on Oracle Engineered Systems,providing customers and partners with a high-performance, reliable, elastic, and secure infrastructure for their critical business applications. Oracle deploys Oracle Cloud Applications primarily on Oracle Exalogic Elastic Cloud and Oracle Exadata Database servers running Oracle Unbreakable Linux, Oracle Fusion Middleware and Oracle Database. By leveraging these proven software and hardware technologies, customers can be assured that they are receiving a platform that delivers extreme performance,redundancy and scalability. Oracle Cloud Applications leverage the next generation tenancy model which we refer to as `Advanced Virtualized Tenancy'. In this model each customer accesses their own private database instance,not a database shared with other cloud customers. Our customers still enjoy the advantages and benefits of the cloud in terms of broad network access, hardware resource pooling for unlimited performance and rapid elasticity for unexpected demand. Oracle engineered its Cloud on its own highly performance hardware and leading technology, offering the best possible performance and security-controlled environment. In addition, Oracle monitors cloud service activity 24x7x365 within the Oracle Cloud and takes immediate action to correct any performance inhibiting event. Oracle has also deployed specific strategies to minimize response times coming from Oracle to the customer by performing Load Balancing across all instances, monitoring the specific performance of each customer instance on a 24x7 basis taking proactive measures in the Data Center to ensure optimal performance of each instance, and have deployed Oracle Enterprise Manager to ensure that all components of our cloud are operating optimally.In addition,Oracle has also deployed tools like Akamai's TERRA Alta as a transaction accelerator to further minimize any latency on our solutions. The Oracle Cloud Customer Portal provides our customers with a number of different cloud management functions ranging from the real-time monitoring of the uptime and performance metrics of their cloud service to managing their subscription and notifications. Recovery Oracle deploys the Oracle Cloud Services on resilient computing infrastructure designed to maintain service availability and continuity in the case of an incident affecting the services. Data centers retained by Oracle to host Oracle Cloud Services have component and power redundancy with backup generators in place,and Oracle may incorporate redundancy in one or more layers,including network infrastructure,program servers,database servers, and/or storage. Oracle periodically makes backups of Your production data in the Oracle Cloud Services for Oracle's sole use to minimize data loss in the event of an incident. Backups are stored at the primary site used to provide the Oracle Cloud Services and may also be stored at an alternate location for retention purposes. Disaster Recovery for Oracle SaaS Public Cloud Services Disaster Recovery (DR) services for Oracle SaaS Public Cloud Services are intended to provide service restoration capability in the event of a major disaster, as declared by Oracle. Oracle will determine whether an event constitutes a disaster requiring the execution of the DR plan for the affected Oracle SaaS Public Cloud Service. Oracle has well-defined Service Continuity policies, as outlined in section 2 of the Oracle Cloud Enterprise Hosting and Delivery Policies. Oracle deploys a regional strategy for housing customer data. Currently the data centers for both production and disaster recovery environments in support of the North America region are located in the United States.The primary data center is located in Phoenix, AZ. The secondary and disaster recovery data center is in Ashburn, Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 48 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System VA. This provides operational excellence to bring Cloud Services back online at the secondary site, with matching service and security levels. The Cloud Services are designed to be available 24 hours a day, 7 days a week, 365 days a year, except during maintenance periods, technology upgrades and as otherwise set forth in the Cloud Services agreement. Oracle works to meet the Target Service Availability Level,or Target Service Uptime,of 99.9%,exclusive of scheduled downtime. The weekly/monthly Average Response Time for all OLTP or transactional access to the Cloud Services and the functionalities offered thereon, except any searches, reporting and analytics requests, data integration processes and document parsing, shall not exceed 4 seconds provided the application has not been customized either at the data model or at the user interface by business users ("Average Response Time"). Oracle will measure Average Response Time within the Oracle Cloud infrastructure as the time difference between first HTTP byte received and last HTTP byte sent for each request in the applicable month. TruePoint Utility Software TruePoint is extremely confident in the performance of the application based on our track record with our many customers. We have customers that bill tens of thousands of utility accounts per billing cycle and others that have up to 100 concurrent users at any given time and the application remains performant and stable.In addition, we are dedicated to providing our customers with a high-performing solution and take an active role in monitoring performance with the assistance of our customers. TruePoint maintains a secure backup solution, including non-database stored configuration data, to ensure redundancy and rapid emergency response to prevent catastrophic information loss or downtime. In addition, TruePoint will coordinate with your organization to ensure our risk mitigation plan meets your requirements. TruePoint optionally offers offsite backup retention for databases and configuration files in case of catastrophic data damage to infrastructure. In case of catastrophic damage to an on-premises server, TruePoint will support the emergency migration service to a new on-site server provided by the City, and if deemed necessary will provide temporary stop-gap service using TruePoint's hosted services built on AWS infrastructure. This stop- gap service provides access to key TrueBill components and can be prepared within 24 business hours upon notice of catastrophic damage from the City. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 49 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System J. PROPOSER REFERENCE INFORMATION FourthSquare References: Client Name: Valley Regional Transit(VRT), Idaho Contact Name: Jason Jedry Contact Phone Number: 208-258-2709 Been a Client Since: 2023 Date Current Version Installed: Implementation in progress Modules That Are Live: Oracle Cloud applications ERP and EPM Implementation Services—ERP (Finance,Procurement)and EPM Client Name: City of Hendersonville,NC Contact Name: Krystal Powell Contact Phone Number: +1 (828) 817-4569 Been a Client Since: 2020 Date Current Version Installed: 2020 Modules That Are Live: Oracle Cloud applications EPM,ERP and HCM Implementation Services. Modules Implemented=ERP, EPM,HCM,Pa.. rll2020,,Project Portfolio Management(2022), Oracle Time&Labor(2023) Client Name: Montgomery County, Tennessee Contact Name: Michael Swift(IT Manager) Contact Phone Number: 931-648-5778 Been a Client Since: 2023 Date Current Version Installed: Implementation in progress Modules That Are Live: Oracle Cloud applications HCM Implementation Services Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 50 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System TruePoint References: Client Name: _Ci1y of Meridian ID Contact Name: Karie A Glenn, Utility Billing Manager Contact Phone Number: Direct 208-489-0436, Office 208-888-4439, k lg enn(umeridiancity.org Been a Client Since: March 2015 Date Current Version Installed: 8/23/2023 Modules That Are Live: TrueBill, TrueCIP, Service Orders, Backflow Program Management, Integration w/Infor(Hansen) Asset management, GIS integration and Financials Integration Client Name: Redwood City Contact Name: Ms. Jun Nguyen, Revenue Services Manager Contact Phone Number: 650 780-7213 Been a Client Since: September 2020 Date Current Version Installed: 9/5/23 Modules That Are Live: TrueBill, Service Orders, Backflow Program Management, and Integrations with GIS, Financials, Infosend, Waterfluence, Smart Energy Water, and CoreBT Client Name: Ci of Arcadia Contact Name: Mr. Henry Chen, Financial Services Manager Contact Phone Number: 626 574-5427 Been a Client Since: December 202 Date Current Version Installed: 9/28/23 Modules That Are Live: TrueBill, TrueCIP (Customer Portal), Service Orders, Backflow Program Management, and Integrations with Elavon Online Payment Processing, Wells Fargo Lockbox Payment Import, Financials, and Watersmart. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 51 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System K. TOTAL COST (SEE APPENDIX B - TOTAL COST SUMMARY) FourthSquare The consolidated cost summary for Oracle Fusion Implementation+ Support. Please refer to Appendix B for complete cost related details. Pricing by Line Item LinT# L',ne Item Yearl Year2 Year3 Total 1 Oracle Software License $284,544.00 $284,544.00 $284,544.00 $853,632.00 2 Implementation Service Cost $1,097,544.88 $1,097,544.88 3 Go-Live Support(6 Months) $50,100.00 $50,100.00 4 Training Included as part of above scope $0.00 5 Data Conversion Included as part of above scope $0.00 b Travel" Included as part of above scope $0.00 Yearly Total $1,432,188.88 $284,544.00 $284,544.00 $2,001,276.88 Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 52 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System MY T H I C S`' PlatinumPartner 4526 Main St.Ste.1500 End User:City of Twin Falls Estimate Number: BUDGETARY QUOTE Virginia Reach,VA 23462 Prepared On: 10/10/2023 Anna Keane Contact:Breanna Howard Valid Thru: 12/31/2023 Phone.767-362-1863 Email:bhmard@?tfld.org Email:a krscc@mythi...com Cloud Subscription Services MCSA 1221 Budgetary,Subject to Final Oracle Approval NO New Subscription Ibm Orace Pan Service Service Nbr Cloud$ernes Number Ponied-Months Metric 1 Oracle Fuson Human Capital Manage ment Cloud Service B85B00 36 Hosted Employee 500 $102,600.00 2 Creole Fusion Workforce Compensation cloud Service B94933 36 Hosted Employee 500 $27,360.00 1 Oracle Fusion Payroll Cloud Service Ba6334 36 Hosted Employee 1000 $96,760.00 2 Oracle Fusion Time&Labor Cloud Service B75305 36 Hosted Named User 500 $20,520.00 1 Oracle Fusion Enterprise Resource Planning Cloud Service B91079 36 Hosted Named User 10 $86,500.00 2 Orecle Fusion EMemdw Resource Planning far Self Service Cloud B91080 36 Hosted Named User 100 $27,360.00 Silivice 1 grade Flnion Procurement Goud Service B91082 36 Hostetl Named User 10 $86,500.00 2 Oracle Fusion Procurement Self Service Cloud Service B91083 36 Hosted Named User 100 $10,944.00 1 Oreds Fusion Supply Chain Execution Cloud Service B91057 36 Hosted Named User 10 $47,880,00 2 CYacle Fusion Document Recognition Ooud Service B73948 36 Hostetl 1,000 Records 10 $8,208.00 1 Orade Enterprise performance Marogemem Enterprise Cloud Be 074 36 Hosted Named User 25 $171,000.00 Service 2 Oracle Additional Applicatbn for Oral Enterpdae Pedmmance B91077 38 Hosted Emironmenl 1 Management Enterprise Goud Service $ggg 1 Additional Test Environment for 0-1.Fusion Cloud Senilce B84490 36 Each 2 $171,000.00 Oracle SaaS Cloud Subscription TOTAL $563,632.00 Total Saes Cloud Subscription $863,632.00 e 72 (—kW. Pad Service Service Service Yearly Number Penod-Months Metric Quantity Service Price usion Human Resources Help Desk Cloud Service Ba73aBEmployee 500 $27,360.00 n Worklorce Health&Safely Incidents Cloud Service B894B2 36Hosted Employee 500 $27,360.00 ole Fusion HCM Communicate Cloud Service B954a9 36 Hosted Employee 500 $13,680.00 Oracle Sal Cloud Subscription TOTAL $88,400.00 Total Saes Cloud Subscription 468,400.00 Total Saes Cloud Subscription $922,032.00 Applicable Slab races.11 beadded unless an exemption la p—mixi. Pricing provided is budgetary in nature,based on the overall requirements of the RFP. Upon down selection,Mythics and FourthSquare will complete a final validation of the bill of materials,including all user counts,and a best and final offer will be provided at that time. This quotation estimate and is an invimtian for you to o8er to purchase cloud services frcm Mylhics.Your...—subject to Milmorl'—puss and to cloud service terms and conditions par reference to an.laud services agreemenVcontract or a newly executed cloud services accompanying your order. Mythics DUNSa:013358002 Mythics Fed Tax IDe 5 4-19 8 78 71 CAGE CODE:1TA34 NAIC:511210 Own services are provided under Oracle's then current Claud Hosting and Delivery Policies located m:hflp:iM .oracle.comluWwrporatelcodmetslockobhouing.delivery-policies-MM53.pdf In reliance on your order,Mythics will issue a non-cancellable order with its supplier for Cloud Services ordered.Therefore all ordem are non-cancellable. By confirming,referencing or placing an order based on this quote,you are agreeing that the Cloud Services bekrp purchased requires no transfer of tangible popeny. Data Center Region-North America Purchasing Instructions: Please reference Mythics Estimate Number BUDGETARY QUOTE and include the following statements in your Purchase Order: 1 This order is placed pusuant to the terms and conditions of,MCSA 1221 iReference Mylhics Quote BUDGETARY QUOTE 3.Reference Mythics Address 4525 Main St.Suite 1500 Va Beach,Va 23462 4.Payment Terms:Cloud Service QIA NET 30 Cloud Services:CIA, Email to akeane(a@mythia.eom By confirming,referencing or placing an order based on this quota,you are agreeing that life..it—.products being purdtased ere for hichoric delivery only and there is no transfer of tangible property. Page 1 CONFIDENTIAL quote Form 0911 Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 53 of 71 m11! FourthSquare Enterprise Resource Planning(ERP)System TruePoint(Utility Software) Cost Summary Product Summary The following products,modules, and interfaces are included in this cost proposal. Name Description TrueBill Customer Information System(CIS)/Utility Billing Core Application TrueCIP Customer Information Portal for utility customers to review account balance,make payments, sign up for automatic payments, sign up for paperless billing,review billing and payment history, and review account consumption. Cityworks Integration A real-time interface with Cityworks using their web services API along with TrueBill's TrueGateway API. When the service request is created in TrueBill, it will automatically create the work order in Cityworks.Any changes/cancelations will also be updated in Cityworks. Once the work order is completed/updated in Cityworks, the service request is automatically updated in TrueBill. InvoiceCloud Integration A real-time online payment processing integration with InvoiceCloud. FourthSquare Interface One-way interface from TruePoint to FourthSquare containing Journal Entries for given date range. Meter Reading Integration Two-way integration between TruePoint and meter reading systems based on import and export files. Infosend Interface One-way interface from TruePoint to Infosend containing billing details Payment Import Files(Multiple Sources) One-way interface from payment systems to TruePoint based on file import. TruePoint Solutions is providing the following pricing summary to detail the financial commitment and investment that would be required by your organization for this project and ongoing software services. The summary below is not a fixed price, but it is based on our current understanding of your organization's requirements. Additional software modules, integrations with other applications not identified in the product summary above, or additional custom reports could result in added expenses. TruePoint offers a yearly subscription for TrueBill and its related components.The yearly subscription is an enterprise license allowing for an unlimited number of users. The annual subscription is paid at the time of software installation, which occurs at the beginning of the project,following contract signing. A minimum three-year commitment is required, and after the first year a 3%annual adjustment will be added to the yearly subscription and hosting cost. The annual subscription provides access to unlimited product support via email or by phone, and rights to the latest software version with bug fixes and enhancements. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 54 of 71 Fo U rth S q U a re Enterprise Resource Planning(ERP)System CostsAnnual Utility Billing SaaS Subscription (Increases 3%Annually) $46,000.00 TrueCIP Customer Portal SaaS Subscription (Increases 3916Annually) $4,000.00 Cloud Hosting Fees - AWS (Increases 3%Annually) $15,000.00 Services Costs & Expenses M"M Data Conversion $88,800.00 Training Total $14,800.00 System Admin Training $3,700.00 Named Users $9,250.00 Departmental Users $1,850.00 Installation $7,400.00 Other Implementation Services (Analysis, Configuration, Testing, Integrations, Reports, Documentation, Go-Live) $129,500.00 Project Management $11,100.00 Travel Expenses (4 Trips) - Estimated, billed as incurred (Kickoff, Core Team Training, End-User Training, Go-Live) $8,000.00 Total Services $259,600.00 Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 55 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System L. PROPOSAL SIGNATURE FORM FourthSquare: The undersigned, as proposal responder, declares that he/she has carefully examined all the items of the Specifications and Instructions herein that he/she fully understands and accepts the requirements of the same, and he/she agrees to furnish the specified items and will accept, in full payment therefore, the amount specified below. Proposals shall include installation services,and the successful respondent shall obtain all required permits and pay fees required. Note: terms are firm for one hundred twenty(120) days. Total Price: $ 2,001,276.88 Proposer Name: Mr. Venkatash Kovela Date: 10-12-2023 Address: _300 Decker Dr, Suite 335,Irving TX 75062_ Telephone: +1214-406-7412 U& Signature: (Person executing response and official capacity) Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 56 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System TruePoint Proposal Signature The undersigned, as proposal responder, declares that he/she has carefully examined all the items of the Specifications and Instructions herein that he/she fully understands and accepts the requirements of the same, and he/she agrees to furnish the specified items and will accept, in full payment therefore, the amount specified below. Proposals shall include installation services, and the successful respondent shall obtain all required permits and pay fees required. Note: terms are firm for one hundred twenty(120)days. Total Price: $ 324,600 Proposer Name: TruePoint Solutions, LLC Date: October 12, 2023 Address: 774 Mays Blvd., #10-377 Incline Village,NV 89451 Telephone: 916-607-4490(Kent Johnson Mobile) Signature: (Pers n execut' esponse and official capacity) Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 57 of 71 Fo U nth S q U a re Enterprise Resource Planning(ERP)System APPENDIX A — INSURANCE REQUIREMENTS ACORO� CERTIFICATE OF LIABILITY INSURANCE DATE(MMIDDNYYY)04/27/2023 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 have ADDITIONAL INSURED provisions or 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). PRODUCER CONTACT Aksha NAME: y Reliance Group Texas,L.P. PHONE'AiC No. (972)556-0556 Fax 72)324J836 2770 W.Main Stl,Ste 111 ADDRESS: hel rBtlP• Frisco,TX 75033 INSURERS AFFORDING COVERAGE NAICM INSURER A: Hartford 30104 INSURED INSURER B: The Hartford FOURTHSQUARE, LLC INSURERC: Hartford 00914 300 Decker Dr Ste 335 INSURER D: Hartford Irving,TX 75062-8177 INSURERE: INSURER F: COVERAGES CERTIFICATE NUMBER: 00124362-0 REVISION NUMBER: 33 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 CONTRACTOR 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. R ADDLSUBTYPE OF INSURANCE IN%n wyn PO LICY NUMBER MM1DDDPOLICYEFF MMIDDIYYY POLICY EXP LTR LIMITS A COMMERCIAL GENERAL LIABILITY 46SBMAJ4GVP 11/10/2022 11/10/2023 EACH OCCURRENCE $ 1 000000 CLAIMS-MADE FRI OCCUR PREMISES Ea acwrrence $ 1,000,000 MED EXP(Any one $ 10,000 PERSONAL B ADV INJURY $ 1,000,000 GEN'L AGGREGATE LIMIT APPUES PER: GENERAL AGGREGATE $ 2000000 X POLICY D JEcT LOC PRODUCTS-COMP/OP AGG $ 2,000,000 OTHER: $ A AUTOMOBILE LIABILPTY 46SBMAJ4GVP 11/10/2022 11110/2023 RE,, d.,tSINCLELIMIT $ 1,000,000 ANY AUTO BODILY INJURY(Par person) $ OWNED SCHEDULED AUTOS ONLY AUTOS BODILY INJURY(Per accident) $ HIRED NON-OWNED PROPERTY DAMAGE $ X AUTOS ONLY X AUTOS ONLY Per aaldent B X UMBRELLAUAB IX OCCUR 46SBMAJ4GVP 11/10/2022 11/10/2023 EACH OCCURRENCE $ 6,000,000 -Cr-LU1B CLAIMS-MADE AGGREGATE $ 6,000,000 DED X RETENTION$ 10000 $ PER T `. WORKERS COMPENSATION 46WECAJ1CM6 11/10/2022 11/10/2023 X I STATUTE I I OEREE AND EMPLOYERS'UABIUTY O�ICEILM E ER EXRTNERIIE ECUrrVE YF NIA E.L.EACH ACCIDENT $ 1,000,000 (Mandatory in NH) E.L.DISEASE-EA EMPLOYEE $ 1,000,000 if yes describe under DESCRIPTION OF OPERATIONS below EL DISEASE-POLICY LIMIT $ 1,000,000 D E 8r O 46 TE 0362095-22 12/11/2022 12l112023 Per Occurance 3,000,000 DESCRIPTION OF OPERATIONS I LOCATIONS VEHICLES(ACORD 101,Additional Remarks Schedule,may be attached a more space is required) CERTIFICATE HOLDER CANCELLATION SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF,NOTICE WILL BE DELIVERED IN Valley Regional Transit ACCORDANCE WITH THE POLICY PROVISIONS. 700 NE 2nd Street,Suite 100 Meridian, ID 83642 AUTHORIZED REPRESENTATIVE (ZAS) ©1988-2015 ACO)IkID CORPORATION. All rights reserved. ACORD 25(2016/03) The ACORD name and logo are registered marks of ACORD Printed by ZAS on 04272023 at 09:44AM Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 58 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System TruePoint Proof of Insurance TruePoint carries significant business insurance through the Hartford Insurance company. Our policy number is 57 SBAAX4262 DX for Business Liability and 57 WEC RL0324 for Workers Compensation. Based upon our experience with other comparable agencies across the country,we have no doubt that TruePoint's coverage will meet or exceed your requirements for insurance coverage. As noted above,the insurer affording coverage is Hartford Insurance. It is provided through: George Peterson Insurance Agency Vitas Ins Agency-Lic. #OD87937 221 Cherry Ave. Auburn, CA 95603 Phone: 530-823-3733,Fax: 530-823-3640. Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 59 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System TRUEPOI-01 APERRY ACORO CERTIFICATE OF LIABILITY INSURANCE DATE(MMIDD/YYYY) 4111. / 8/3/2021 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 have ADDITIONAL INSURED provisions or 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 endorsements. PRODUCER License#0603247 k2jrCT George Petersen Insurance Agency,Inc. PHONE FAX PO Box 6675 Arc,No,Ext):(530 8233733 floc,No:530 8233640 Auburn.CA 95604ss,info@gpins.com INSURE S AFFORDING COVERAGE NAICY INSURER A:Sentinel Insurance Company Ltd 11000 INSURED INSURER B: TruePoint Solutions LLC IIISURERC: 3262 Penryn Rd.Ste.100-B NISURERO: Loomis,CA 95650 INSURER E: INSURER F: COVERAGES CERTIFICATE NUMBER: REVISION NUMBER:1 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. INSRLTR TYPE OF INSURANCE ADDL SUBR POLICY NUMBER RP,0UpQyyEF.F POLICY EXP LIMITS A X COMMERCIAL GENERAL LIABILITY EACH OCCURRENCE 1,000,000 CLAIMS-MADE [X]OCCUR X 57-SBA-AX4262 211/2021 211/2022 WISETORENTED 1,000,000 X Hired&NonOwned Aut 10,000 MED EXP An one person) PERSONAL B ADV INJURY $ 1,000,006 GENT AGGREGATE LIMIT APPLIES PER: GENERAL AGGREGATE f 2,000,000 X POLICY X LOC PRODUCTS-COMP/OP AGG $ 2,000,006 OTHER. ITHIRD PARTY CYB 500,000 A AUTOMOBILE LIABILITY COMBINED SINGLE LIMIT 1,000,000 ANY AUTO 57-SBA-AX4262 211/2021 211/2022 BODILY INJURY Per rson OWNED SCHEDULED AU�gqTEEO��S ONLY AUTOS yy p BODILY INJURY Per accident S X AUTOS ONLY X AUTOS ON�Y PPeracudent AMAGE $ A X UMSRELLALIAB X OCCUR EACH OCCURRENCE 3 2,000,000 EXCESS LIAB CLAIMS-MADE 57-SBA-AX4262 2/1/2021 211/2022 AGGREGATE 21000,000 DED I X I RETENTIONS 10,000 WORKERS COMPENSATION STAT PER UTE ER AND EMPLOYERS'LIABILITY YIN ANY PROPRIETOR/PARTNER/EXECUTIVE ❑ E.L.EACH ACCIDENT $ FICER EXCLUDED? N!A I tlFlI E.L.DISEASE-EA EMPLOYEE$ It yes.describe under DESCRIPTION OF OPERATIONS below E.L.DISEASE-POLICY LIMIT $ DESCRIPTION OF OPERATIONS/LOCATIONS/VEHICLES ACORD 101,Additional Remarks Schedule,maybe attached It more space is required) RE: Work performed by the named insured on Behalf of the certificate holder I CERTIFICATE HOLDER CANCELLATION SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF. NOTICE WILL BE DELIVERED IN ACCORDANCE WITH THE POLICY PROVISIONS. AUTHOO///TJJJRIIZZED REPRESENTATIVE ACORD 25(2016/03) ©1988-2015 ACORD CORPORATION. All rights reserved. The ACORD name and logo are registered marks of ACORD Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 60 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System APPENDIX B — TOTAL COST SUMMARY The total cost summary should be submitted as shown in the following chart in Appendix B and must include the following breakdowns: • Software Purchase and Licensing Costs (show breakdown by module and by user type). • Annual Maintenance Costs (show breakdown by module) • Total Data Conversion Costs. • Implementation/Installation Costs, including setup of workflows and reports. • Training Costs (Provide breakdown for system administrators, named users, and departmental users). • Travel costs. • Third-Party Software and Implementation Costs. • Project Management Costs. PROPOSER NAME: FourthSquare,LLC DATE: 10-12-2023 ANNUAL DATA INSTALLATION PURCHASE MAINTENANCE CONVERSION & PRICE TOTAL PRICE ITEM TRAINING MODULE Accounts Payable $ 121,068 The purchase Included as Included as $ 121,068 price part of part of mentioned is Implementation Implementation for 3 years Cost below Cost below license Accounts Receivable Included Above as part of Accounts Payable Bank Reconciliation Included Above as part of Accounts Payable Budgeting $ 171,000 $ 171,000 Cash Receipting Included Above as part of Accounts Payable Clearing House(if a separate module) [General Ledger Included Above as part Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 61 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System of Accounts Payable Procurement and Inventory $ 144,324 $ 144,324 Payroll& Compensation $ 123,120 $ 123,120 Time Tracking $20,520 $20,520 Project Management Included Tracking Above as part of Accounts Payable Human Resources $ 102,600 $ 102,600 Additional Test environment $ 171,000 $ 171,000 for Fusion Cloud Service Online Portal (employee Included self-service) Above as part of Human Resources Online Portal(utility $4,000 $4,000 customers) Utility Billing( $46,000 $88,800 $14,800.00 $ 172,200 (Increases 3%Annually) $7,400.00 Cloud Hosting Fees-AWS $ 15,000 SUBTOTAL :1 ITEM PRICE Oracle Fusion Implementation Cost(9 Month+6 Months support) $ 1,147,645 Oracle-Travel Costs Included as part of Implementation Costs TrueCIP Implementation Services(Project Management, $ 140,600 Analysis, Configuration,Testing,Integrations,Reports,Documentation, Go-Live) Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 62 of 71 m11! Fo u rth S q u a re Enterprise Resource Planning(ERP)System TrueCIP Travel Costs $ 8,000 SUBTOTAL GRAND TOTAL $ 2,325,877 Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 63 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System APPENDIX C — EXCEPTION FORM Section# Explanation No Exceptions Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 64 of 71 m11! Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System APPENDIX D - REQUIREMENTS SUMMARY FOURTHSQUARE ❖ Global Areas Y • Active directory integration with Azure Y • Audit trail for table changes,transactions,updates to code tables Y • Detailed reporting Y • Editable import/export configurations Y • Fields and fixed locations to work with Laserfiche connectors and repository Y • Global search capabilities Y • Government rated security Y • User defined fields Y ❖ System Access Security Maintenance Y • Customizable security for user and user groups Y • Manage data used in specific modules Y • Systemwide lookup tables (lots,bank accounts, etc) Y •'• Financial Y • Accounts Payable Y • Accounts Payable batch review before commitment Y • Accounts Receivable Y • Additional periods beyond 12 to account for Government-Wide adjustments Y • Automatic signatures on checks Y • Bank reconciliation Y • Budgeting Y • Cash receipting, including ability to import files that tie to a customer account or Y record a payment with payee details from someone who doesn't have a customer account Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 65 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System • Cash receipting date adjustment after commitment Y • Check number or date corrections after commitment Y • Clearing House Y • Duplicate invoice payment flagging in Accounts Payable Y • Field to separate vendor payments during check processing Y • Fixed Assets Y • General Ledger Y • Import cleared checks Y • Import of General Leder adjustments Y • Multiple account payment recordings on one receipt Y • Multiple billing cycles or categories Y • Positive Paycheck file generation for the bank Y • Project management tracking Y • Sales Tax calculation and reporting Y • Splitting deposits vs cash or check Y • Transfer of detailed information from identified subledgers to the General Ledger Y • Type codes and groups in Cash receipting Y • 1099 classification,reporting, and electronic generation for State and Federal Y government Human Resources Y • ACA tracking and reporting Y • Anniversary date fields in addition to hire date Y • Automatic tax table updates Y • EEOC classification trackability Y • Electronic W-2 generation for State and Federal government Y • Employee self service Y • IRS Social Security number validation Y Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 66 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System • Manual ability to enter pay information generated by a 3rd party system to generate Y a PERSI report • Multiple payroll cycles Y • Multiple accrual tables and rules Y • Outgoing ACH file creation Y • Pay code mapping to an accrual bank Y • Payroll,with payroll expenses following wages based on salary classification Y • PERSI reporting for General,Public Safety Class II,Public Safety Class D,and Y returning Public Safety Retirees • Report generation on how pay and deduction codes are configured for pay cycles Y • Salary payments, adjusted for leave codes Y • Specialty pay, including flat amounts tied to specific pay codes Y • Step or tier setup on deductions and benefits Y • Tow-way integration with Timeclock Plus Y ❖ Utility Billing Y • Auto pay and incoming ACH payment file generation Y • Billing exports to 3'party for printing,including bar code Y • Collection turnover report generation Y • Different billing cycle availability Y • Inbound IVR payment acceptance Y • Integration with meter reading software Y • Level pay/balanced budget Y • Past due,payment reminders, alerts&notice communication via phone,text and/or Y email • Payment arrangement tracking Y • Pressurized Irrigation fee calculation on lot size Y • Refund batch generation Y • Sewer based billing on water usage with calculated caps Y • Utility deposit recording and tracking Y Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 67 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System • Water, Sewer, Sanitation Y • Web payment setup Y • Winter averaging Y • Work orders/service request integration with City Works Y TRUEPOINT ❖ Global Areas Y • Active directory integration with Azure Y • Audit trail for table changes,transactions,updates to code tables Y • Detailed reporting Y • Editable import/export configurations Y • Fields and fixed locations to work with Laserfiche connectors and repository Y • Global search capabilities Y • Government rated security Y • User defined fields Y ❖ System Access Security Maintenance Y • Customizable security for user and user groups Y • Manage data used in specific modules Y • Systemwide lookup tables (lots,bank accounts, etc) Y Financial Y • Accounts Payable Y • Accounts Payable batch review before commitment Y • Accounts Receivable Y • Additional periods beyond 12 to account for Government-Wide adjustments Y • Automatic signatures on checks Y • Bank reconciliation Y Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 68 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System • Budgeting Y • Cash receipting, including ability to import files that tie to a customer account or Y record a payment with payee details from someone who doesn't have a customer account • Cash receipting date adjustment after commitment Y • Check number or date corrections after commitment Y • Clearing House Y • Duplicate invoice payment flagging in Accounts Payable Y • Field to separate vendor payments during check processing Y • Fixed Assets Y • General Ledger Y • Import cleared checks Y • Import of General Leder adjustments Y • Multiple account payment recordings on one receipt Y • Multiple billing cycles or categories Y • Positive Paycheck file generation for the bank Y • Project management tracking Y • Sales Tax calculation and reporting Y • Splitting deposits vs cash or check Y • Transfer of detailed information from identified subledgers to the General Ledger Y • Type codes and groups in Cash receipting Y • 1099 classification,reporting, and electronic generation for State and Federal Y government Human Resources Y • ACA tracking and reporting Y • Anniversary date fields in addition to hire date Y • Automatic tax table updates Y • EEOC classification trackability Y Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 69 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System • Electronic W-2 generation for State and Federal government Y • Employee self service Y • IRS Social Security number validation Y • Manual ability to enter pay information generated by a 3'party system to generate Y a PERSI report • Multiple payroll cycles Y • Multiple accrual tables and rules Y • Outgoing ACH file creation Y • Pay code mapping to an accrual bank Y • Payroll,with payroll expenses following wages based on salary classification Y • PERSI reporting for General,Public Safety Class 11,Public Safety Class D, and Y returning Public Safety Retirees • Report generation on how pay and deduction codes are configured for pay cycles Y • Salary payments, adjusted for leave codes Y • Specialty pay, including flat amounts tied to specific pay codes Y • Step or tier setup on deductions and benefits Y • Tow-way integration with Timeclock Plus Y ❖ Utility Billing Y • Auto pay and incoming ACH payment file generation Y • Billing exports to 3'party for printing,including bar code Y • Collection turnover report generation Y • Different billing cycle availability Y • Inbound IVR payment acceptance Y • Integration with meter reading software Y • Level pay/balanced budget Y* *Willing to develop during implementation at no additional cost. • Past due,payment reminders, alerts&notice communication via phone,text and/or Y email Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 70 of 71 Fo u r t h S q u a r e Enterprise Resource Planning(ERP)System • Payment arrangement tracking Y • Pressurized Irrigation fee calculation on lot size Y • Refund batch generation Y • Sewer based billing on water usage with calculated caps Y • Utility deposit recording and tracking Y • Water, Sewer, Sanitation Y • Web payment setup Y • Winter averaging Y • Work orders/service request integration with City Works Y Use or disclosure of data contained on this sheet is subject to the restriction on the Propriety Nature of this Proposal page of this proposal. Page 71 of 71