12-2 - 26RFP14 Williamson County EAM RFP - Attachment A.docx

Attachment A – Proposal Forms Respondent shall complete each of the Tabs 1 – 14 and submit per the instructions provided in the RFP. Any Exhibits provided by the Respondent are to be inserted at the end of each applicable tab. Respondents are permitted to make changes to the footers, and necessary formatting changes to tables, to optimize the presentation of information.

Respondent is instructed to organize Proposal in a tabbed format, and to insert the completed tab forms (Attachment A) in the corresponding tabs as a part of their Proposal response. In addition to the information captured through the questions and tables in Attachment A, Respondent is requested to provide complementary narrative information, diagrams, and images to help substantiate and support their proposal response to each tab section. Any such information may be provided in Respondents preferred formatting/branding.

Tab 1 – Company Introduction and Relevant Experience

TRANSMITTAL CERTIFICATION

By signature on the Proposal, the Respondent certifies that it complies with:

1. The laws of the State of Texas and is licensed or qualified to conduct business in the State of Texas

2. All applicable local, state, and federal laws, codes, and regulations

3. All terms, conditions, and requirements set forth in this RFP

4. A condition that the Proposal submitted was independently arrived at, without collusion

5. A condition that the offer will remain open and valid for the period indicated in this solicitation; and any condition that the firm and/or any individuals working on the contract do not have a possible conflict of interest

6. The following Non-Collusion Affirmations

· I affirm that I am the Respondent, a partner of the Respondent, or an officer or employee of the Respondent’s corporation with authority to sign on the Respondent’s behalf.

· I also affirm that the attached has been compiled independently and without collusion or agreement, or understanding with any other Respondent designed to limit competition.

· I hereby affirm that the contents of this Proposal have not been communicated by the Respondent or its agent to any person not an employee or agent of Williamson County (County).

If the Respondent fails to comply with the provisions stated in this paragraph, the County reserves the right to reject the Proposal, terminate the contract, or consider the Respondent in default.

Table 1-01: Transmittal Certification and Primary Contact Information

Name of the Respondent Representative

Title

Name of Company

Address

Telephone Number

Email Address

Signature of Authorized Officer of the Firm

A signature provides the County with the Respondent’s acknowledgement and acceptance of the RFP terms, requirements, and conditions, and the execution of same during the discharge of any succeeding contract.

TRANSMITTAL LETTER

A Transmittal Letter, printed on letterhead, shall be submitted and signed by an authorized representative of the Respondent, such as the owner, partner, or in the case of a corporation, the President, Vice President, Secretary, or other corporate officer(s) that address the following:

a. A statement naming the Respondent (legal name and if corporation, whether corporation has corporate seal) and stating the type of entity for the Respondent and any joint Respondent or subcontractor (e.g., corporation, limited liability company, partnership, sole proprietor, etc.)

b. A statement identifying, in summary, the name of the proposed software solution and any third-party partners included as part of the proposal;

c. A statement of acknowledging that all addenda to this Request for Proposal have been reviewed by the Respondent; and

d. A statement disclosing whether or not the proposal contains confidential information, trade secrets or other proprietary data the Respondent does not want to be subject to public inspection.

COMPANY BACKGROUND AND HISTORY

i. Respondent to provide a comprehensive history statement of the firm, including any mergers, assignments, or other corporate changes during the past 10 years.

ii. Respondent shall complete the Company Background and History Table as provided below.

If a partnership with third-party company is a part of the Proposal, the Company Background and History table shall be provided for each entity. It is expected that all points shall be addressed for each company involved in the Proposal, prime or third party. Respondent to copy the table as needed for each Partner/Third-Party Firm proposed and fill out for each.

Table 1-02: Company Background and History

Name of Respondent:

(Copy form and Complete if applicable for each) Name of Partner/Third-Party Firm:

Total number of employees

Type and number of employees committed to the product and support being proposed

Office locations (City and State)

Government:

Total number of active Private Sector EAM clients

Total number of active Government Sector EAM clients

Total years offering proposed software systems

County:

Other:

Total number of completed implementations of the proposed product and version

Total number of active government clients using the proposed product version

Largest active government installation, including population

Smallest active government installation, including population

Other products offered by the company

RELEVANT EXPERIENCE

i. Please describe your relevant experience working with Texas entities (Counties, Municipalities, etc.).

ii. Please describe any relevant experience working with similarly situated Counties, including any unique factors that arise during the implementation process.

iii. Identify two recent project implementations that are most comparable to the County’s proposed implementation, and provide a project profile for each, including: scope of modules; project duration; any unique requirements or circumstances that were a part of, or came up during, the project; the legacy system converted from; etc.

iv. Please describe implementation barriers or challenges that have been experienced working within Texas on implementations. What proactive steps are planned in this proposed project to mitigate against similar challenges?

v. What sets the product(s) and services that your firm proposes apart from competitors’ products and services? Why should the County select your firm to partner with?

USE OF SUBCONTRACTORS

i. The Respondent shall identify any of the required Services that are proposed to be subcontracted, if any. This table is to be copied and filled out for each proposed subcontractor.

Table 1-03: Subcontractor Questions

Does your firm complete the implementations of the product being proposed or is this effort outsourced?

Has or will any portion of the proposed work be completed by subcontractors or contract employees?

This below portion of the table is to be copied and filled out for each proposed subcontractor.

Name of subcontractor and address

Summary of Service and estimated percentage of Work the subcontractor will be providing.

Reasons for subcontracting

Experience

Detailed subcontractor responsibilities

Previous history of projects using the named subcontractor

Any additional relevant information

The County reserves the right to request a copy of the prime Respondent/subcontractor contract verifying the prime Respondent has the sole responsibility for any and all Services under this RFP and is financially liable, without exception, to the County for all Services contracted by the Respondent and the subcontractor under this RFP.

The County reserves the right to request additional information regarding the subcontractor(s) as it relates to references, history of the firm, and other relative information that has been required of the Respondent to submit in this RFP.

The substitution of one subcontractor for another may be made only at the discretion and prior written approval of the County.

ii. By signature (electronically or via ink) below on the Certification of Subcontractors/Partners, the Respondent and the Subcontractor/Partner certify that the Respondent has received the permission of the third-party to include the scope of software and services under the cover of the submitted proposal.

Table 1-04: Certification of Subcontractors/Partners

Respondents are instructed to return a copy of this Certification table signed by an authorized firm agent as part of proposal responses.

X. ________________________________

VI. ACKNOWLEDGEMENT OF ADDENDUMS:

Addenda: Respondent shall acknowledge below the receipt of any addendum posted to the County’s purchasing website.

COUNTY REQUIRED FORMS

Conflict of Interest Form: Exhibit submitted Yes No Certificate of Interested Parties – Form 1295: Exhibit submitted Yes No Code of Ethics Form: Exhibit submitted Yes No

Tab 2 – Software Solution

SUMMARY DESCRIPTION OF EACH FUNCTIONAL AREA

Respondent to provide a summary description of the capabilities for each functional area contained in the RFP, in narrative format (minimum two well-developed paragraphs per functional area). The purpose of this summary is so that the County has a high-level understanding of the proposed solution. The narrative should be written for an audience of the end-user community. Descriptions should be included for any products proposed by third parties to meet the capabilities described in the Functional and Technical Requirements in Attachment B.

Marketing materials should not be submitted on the proposed functionality.

SOFTWARE DOCUMENTATION FEATURES AND FUNCTIONS

Respondent to provide a summary of their software documentation that describes the features and function of the proposed application software. Identify what makes your documentation user friendly and useful to the end user and technical user of the software.

PROPOSED SOFTWARE MODULES TABLE

Respondent to complete the table below. Proposed modules that are required to satisfy the requirements associated with the functional areas identified below cannot be proposed as complementary or optional.

Table 2-01: Proposed Functional Areas/Modules Proposed Software Information

Product Component/Suite (Name and Version of the Proposed Software Solution)

Time on Market

Release Date of Most Current Version

Next Major Release Date

Next Minor Release Date

Was the product proposed originally developed by your firm, or, was the product acquired from another developer/entity?

If the proposed product was acquired, what was the date of acquisition?

What is the future roadmap for the proposed product? Is there an end of sales or support date for the product?

Does your company have plans to release a differing product that offers the same or similar functionality in the next 5-10 years?

Licensing

Describe how the software is licensed (e.g., named user, concurrent users, enterprise/site, power user) and the options available for licensing.

How many licenses have been proposed?

Are the same licenses required for all users, or, would some users have a different license type than other users (e.g., mobile)?

How are new users added to the system? Are there incremental costs per user?

If an existing user separates from service at the County, may their license be re-assigned to a new staff member, or, must a license remain assigned to that staff member in order to maintain employee records/retiree, etc.?

Deployment Model

Deployment Models Proposed to the County (Corresponding Attachment C1 Cost Worksheets shall be completed for each separate deployment model proposed)

Summary of Modules Proposed

*Successful integration should include only those instances where both the software and the client are in production environments.

OPTIONAL AND COMPLEMENTARY MODULES

What other system modules or products, not included in the scope of your proposal, would the Respondent recommend to be complementary or optional to the Project Scope?

Table 2-02: Optional and Complementary Modules

PARTNERSHIPS/THIRD-PARTY PRODUCT RELATIONSHIP

i. Respondent to fill out the below table for each of the Partnership/Third-Party software product proposed.

– Not applicable, no Partnership/Third-Party software proposed Table 2-03: Partnership and/or Third-Party Product Identification

ii. For each product proposed as a Partnership/Third-Party product, detail the options available to the County as it relates to contracting relationship between the County and the Partnership/Third Party.

iii. Respondent to provide the approach and responsibilities for managing the implementation and acceptance testing for each of the proposed Partnership/Third-Party products.

iv. Respondent to provide the approach and responsibilities for the SLA/maintenance related to the Partner/Third-Party provider.

v. Respondent to submit references and qualification statements for each of the proposed Partners/Third-Party firms and attach as an Exhibit to Tab 2 (Refer to Tab 11 for Reference instructions).

Confirmed, Exhibit attached.

vi. Respondent shall indicate if the proposed approach utilizes a systems integrator or consulting firm as the third-party.

General

i. Respondent shall clearly indicate the deployment model(s) proposed from among the three categories presented in a – c below. If more than one product is proposed, please clearly identify the deployment model for each product proposed:

a. On Premise (locally hosted at the County on a virtualized server, perpetual licenses)

b. Respondent hosted (hosted and managed by the Respondent, perpetual licenses

c. Software as a Service (SaaS or subscription-based models)

ii. Respondent shall fully describe the integration/interface/data exchange capabilities of the proposed system, including available APIs, middleware, web services, etc.

iii. For available APIs, does the proposed pricing include access to the entire API library? What functionality is exposed in the systems’ APIs?

iv. Please describe how the proposed solution(s) support accessibility and ADA compliance, in addition to the following specific questions.

a. Does the software provide keyboard equivalents for all mouse actions, including buttons, scroll windows, text entry fields, and pop-up windows?

b. If information is provided in an audio format, is it also capable of being displayed by the user in a visual format?

c. Does the application support user-defined color settings system-wide? Does the software ensure that color-coding is never used as the only means of conveying information or indicating an action?

d. Is special training available/provided for users with disabilities that will enable them to become familiar with the software and learn how to use it in conjunction with assistive technology provided as an accommodation?

v. Describe your proposed reporting features native to the system, and how the County staff will be trained to develop and configure their own reports.

vi. What strategic decisions or direction is your firm taking or making related to the product being proposed today?

vii. Does your firm offer data conversion alternatives, such as data warehousing?

viii. What are the 3 – 5 most innovative and unique features or functionality that your software offers that would, from your firms’ perspective, drive process improvement for an organization such as the County? For example, use of Artificial Intelligence/Machine Learning, automated invoice scanning/voucher creation, etc.

ix. The County is interested in learning more about capital project management information system (PMIS) functionality.

a. Does your firm provide PMIS functionality for the management of capital projects either natively within the proposed EAM solution or as a standalone product?

b. Does your firm have experience integrating your proposed EAM solution with third-party PMIS solutions? If yes, please describe recommended best practices for establishing data exchanges between the two systems including interface protocols, data mapping strategies, and synchronization methods.

x. The County’s current asset data inventory is incomplete and is currently tracked through various methods (e.g., GIS, spreadsheets, paper forms). The County understands that having a comprehensive, accurate asset inventory is essential to maximizing the value of its investment in a new EAM solution and aims to capture missing asset data as part of the EAM transformation initiative.

Does your firm offer or partner with firms that offer services related to asset data collection? If yes, please describe your approach, including the methods, tools, and standards you use for collecting and validating asset data. Explain how you ensure accuracy and completeness, and how the collected data is formatted and structured for seamless integration into your proposed software solution. Include any best practices, lessons learned from past projects, and options for ongoing data governance. In addition, please include any related cost considerations as optional in your response to Attachments C1 and C2 of this RFP.

No:

Yes (please describe):

Tab 3 – Project Approach and Implementation Methodology

1. PROJECT APPROACH

Respondent to provide a description of the proposed approach for providing the Scope described in the RFP, including a comprehensive description of the proposed implementation methodology for the Project. The description should include how the Respondent has developed this methodology to both incorporate lessons learned from experiences as well as to meet the needs described in the RFP.

i. Based on information provided in this RFP and experience in working with other localities, what is the Respondent’s perspective on the most significant risks to this Project, and how do you plan to mitigate these risks?

ii. With what frequency will Respondent’s Project Team staff be on-site at the County during implementation? Will staff be on-site for full or partial weeks?

iii. Describe in detail the approach to developing interfaces/integrations/data exchanges. What is the division of responsibility between the County and Respondent project teams? What technical skills are required of the County staff for this work?

a. Following go-live of the software, what is the role of the Respondent in supporting the ongoing maintenance of developed interfaces/integrations/data exchanges?

iv. Describe in detail the approach to configuration and set-up activities. Will the Respondent team complete the majority of the configuration based upon information gathered from the County subject matter experts, or will the County be expected to perform much of the configuration?

v. Describe any additional assumptions made in the Proposal, not already identified in detail. These should include any assumptions related to the current the County technical environment, staffing, project management approach, and the County resources available during implementation and support phases.

1. DEPLOYMENT

Respondent to provide a detailed narrative description of how the implementation approach will vary between the deployment methods proposed (i.e., a traditional County-hosted model, a Respondent-hosted and/or a subscription-based solution, etc.).

1. GO-LIVE AND ONGOING SUPPORT

Respondent to describe what level of pre- and post-go-live support is available under the proposed fee structure. If varying levels of support are available, this section of the RFP response should clarify these potential support services and highlight the level of support that has been proposed. Respondent shall use Attachment C1, Cost Worksheets, to clearly identify the varying fees based on the varying levels of support that are available.

i. What are the standard hours that support is offered, and through what means (telephone, web ticket submission, etc.)?

ii. Are afterhours and weekend support offered, and if so, is this part of the standard support offering or part of a different tier/offering?

iii. Describe the support that is offered to assist in potential situations where the County is unable to conduct certain mission-critical processes, such as processing payroll, due to emergency situations.

iv. Is product support offered by Respondent, through the software developer/provider, or sub-contracted?

v. Are there optional, “enhanced” support tiers or offerings above and beyond what has been proposed?

vi. How often are releases provided, how is advance notification provided to customers of upcoming releases, and what is the process to test each release?

vii. Would the County be able to test releases in a test environment prior to pushing updates to a live environment?

viii. Does the system have the ability to roll back updates should challenges or bugs be encountered?

ix. Describe how often major and minor software updates are provided, as well as the level of the County resources required for a major update and the level of resources required for a minor update.

x. Please describe the major/minor upgrade process that is required if the solution requires a client-based installation.

xi. Are there future costs associated with upgrade processes? For example, costs associated with purchasing licensing for upgrades, professional services costs associated with implementing upgrades, etc.? Respondent to describe the frequency of upgrades and any price ranges for anticipated upgrades.

xii. What is the role of the County in providing ongoing support and maintenance of the system proposed? How many FTE are typically required to support the system on the client-side, and what tasks are entailed?

xiii. What organizational change management (OCM) resources will be made available during implementational to support users during the transition?

IV. STATUS REPORTING

Respondent to detail their approach to providing status reports throughout the course of the Project. This section should include an example of the recurring status report and identify the expected delivery mechanism that will be used to provide the report to the County as an exhibit to Tab 3.

Exhibit submitted Yes No

1. RESOURCE HOURS

Respondent shall include the proposed resource levels for the County Implementation Project Team and their Project Teams by completing the tables below.

Table 3-01: Project Team Resource Hours Project Team Resource Hours

Instructions: The Respondent is asked to provide the number of resources that will be committed to the Project in terms of number of hours. These numbers should be based on the functionality the County desires, included in the detailed Functional and Technical Requirements (Attachment B).

Assumptions: Any assumptions related to the number of Project Team staff for the Respondent or the County teams, roles of staff, and duration of involvement used in the development of the resource hour estimates should be included here:

Respondent Team

Respondent shall include the anticipated resource hour’s levels for the County Implementation Project Team based on typical project role by completing the tables below. Any comments related to the anticipated hours, any phase-specific involvement, or other assumptions should be noted in the Additional Respondent Comments column.

Table 3-02: Anticipated Hours by Project Role Anticipated Hours by Project Role

County Project Role (e.g., Project Sponsor, Project Manager, Conversion Lead)

Executive Sponsor

Steering Committee

Project Manager

Project Management Team

Functional Area Lead(s) – Assuming one lead per tab of Attachment B

Subject Matter Expert(s) – Note: one SME may serve as SME on two or more modules/functional areas

Integration Lead

Data Conversion Lead

System Administrator

Reporting Lead

Organizational Change Management Lead

Training Lead

Other Respondent-Defined Roles (list below)

Respondent to provide their overall estimated split/division of the work effort as shared between the County and the Respondent teams (example: the County owns 20% of the work effort, and the Respondent owns 80% of the work effort) along with any narrative to support this estimate.

Table 3-03: Anticipated Work Effort Division Anticipated Work Effort Division

Estimated number of individuals required for Project Team

Approximate Percentage of Work Effort Owned

General Comments

1. IMPLEMENTATION PLAN

Respondent to provide their overall objectives and approach to the County’s implementation. Discuss timing as being chronological, in parallel, etc., for all of the modules proposed.

Respondent shall submit a Sample Implementation Plan as an Exhibit to Tab 3.

Exhibit submitted Yes No

1. PROJECT MANAGEMENT PROCESS

Respondent to provide their overall approach for managing the County’s Project, including the following areas:

i. Scope Management: approach for managing the Project Scope and the process used to request changes to Project Scope. It is the County’s desire to use the proposed software system “as is” and, as such, any changes (e.g., customizations or modifications to the software) must be reviewed and approved by the County’s Implementation Project Team.

ii. Schedule Management: approach for managing the County’s Project Schedule and the process used to submit requested changes to the schedule.

iii. Risk Management: their approach for documenting Project risks, providing recommendations for mitigating the risk, and how this will be communicated to the County’s Implementation Project Team.

iv. Quality Management: approach/policies to assure that all written deliverables have received appropriate reviews for quality before being submitted to the County.

v. Communication Management: approach that will be used to provide the County with a detailed communication plan.

vi. Organizational Change Management: process, tools, and techniques they will use to manage the people side of change.

vii. System Interface Plan: approach and process that will be used to perform the County desired interfaces.

viii. Resource Management Plan: approach to resource management and managing resource allocation for the County and Respondent teams.

Tab 4 – Key Proposed Personnel and Team Organization

1. ORGANIZATIONAL CHART

i. The County anticipates that any Respondent staff assigned to the Project will remain assigned to the Project, unless the County deems the services to not meet expectations at which point the Respondent and the County will work together to remedy such non-conforming services. Respondent to identify the approach to assignment and (as necessary) replacement/removal of Respondent staff during the implementation process.

ii. Describe the proposed approach to staffing for the implementation process. Will the County be working with separate resources on the Respondent team based on functional area (e.g., public portal, inventory management) or will the County work with a more limited number of resources that may provide cross-functional expertise?

a. Does your firm provide certification(s) for staff based on knowledge/achievement in understanding the software solution? If so, will all staff assigned to the implementation be certified in the software product(s) proposed?

iii. Respondent to submit as an Exhibit to Tab 4, an Organizational Chart including subcontractors and reporting structure of the entire team proposed to work on the County’s project.

Exhibit submitted Yes No

1. PROJECT TEAM RESUMES (RESPONDENT)

i. As an Exhibit to Tab 4, resumes shall be provided for the implementation team, as well as additional personnel involved in the proposed project governance structure, including any partners/subcontractors. Resumes shall be specific to the actual personnel to be assigned to this Project for all primary roles (e.g., Project Manager, Conversion Lead). Resumes to include listing of past software implementation projects and certifications held for each team member.

Exhibit submitted Yes No

ii. Summary of Project Team: Respondent shall complete the table on the following page listing a summary of the Project Team Members including any partners/subcontractors.

Table 4-01: Respondent Project Team Members Respondent Project Team Members

Tab 5 – Project Schedule

1. PROJECT SCHEDULE

i. Respondent shall submit a proposed Project Schedule with the major milestones, activities, and timing of deliverables for the Scope of Work described in the RFP. In addition, the response should reflect Project predecessors, successors, and dependencies.

· The County requests that the sample Project Schedule be in a Gantt chart format.

· The County would expect implementation to begin in August 2026.

· Respondent to submit as an Exhibit, a sample Project Schedule and insert in Tab 5.

Exhibit submitted Yes No

1. PROJECT DELIVERABLES, MILESTONES, AND PAYMENT APPLICATIONS

i. Respondent to include a list of deliverables and milestones of the Project and should describe exactly how and what will be provided to meet the needs of the County.

ii. Respondent to submit their payment schedule, tied to the listed deliverables and milestones for review by the County, as an exhibit to Tab 5. This schedule shall be consistent with the terms provided in Attachment C2 of the RFP (Cost Narrative) and should not include the dollar amounts for payments, but rather the events that would trigger payments. Notation should be made as to the payment structure for services (e.g., fixed fee, time and materials).

Exhibit submitted Yes No

1. PROJECT SCHEDULE QUESTIONS

Table 5-01: Project Schedule Questions Project Schedule Questions

1. Based on current obligations, what is the earliest you can begin implementation after contract signing?

2. What activities would the Respondent expect to occur within the first 60 days of contract signing?

3. How long does the typical implementation of the product being proposed take for an organization of similar size to the County?

4. What special considerations are there related to the timing of go-live activities? Does it vary based on functionality?

1. PROJECTED GO-LIVE DATES

The County anticipates that implementation activities would begin in October 2026. The County would like to target October 2027 as a potential go-live date for all modules. The County follows an October 1 – September 30 fiscal year. Respondents are encouraged propose phasing and timelines that best align with the Respondents implementation approach.

Table 5-02: Projected Go-Live Dates

I

II

III

Tab 6 – System and Application Architecture

1. GENERAL OVERVIEW

Respondent to provide a description of the proposed system and application architecture for the proposed application.

1. SYSTEM AND APPLICATION ARCHITECTURE QUESTIONS

Table 6-01: System and Application Architecture Questions System and Application Architecture Questions

1. What is the source language(s) of the product?

2. How many environments are available with your proposed solution at no additional cost (e.g., test, training, production)?

3. Describe how often major and minor software updates are provided, as well as the level of the County resources required for a major update and the level of resources required for a minor update.

4. Please describe the major/minor upgrade process that is required if the solution requires a client-based installation.

5. List all browsers that are certified for use with the application and describe any required browser add-ons, function enablement, etc.

6. The underlying architecture of the application design is important to the County. Please describe your system architecture model and explain the capabilities and features of this model that led to your use of it in developing this system.

7. Please describe how data privacy and security compliance is supported within your proposed software solution.

8. Describe your approach to ensure scalability of the product. This includes transaction growth, upgrades, and replacements of components of the architecture, technology, and application.

9. List all hardware/operating system/database platforms upon which the product is supported. Provide specifications in terms of processors, processor speed, memory requirements, and other sizing and capacity factors to assist the County in budgeting for and acquiring hardware. List which industry standard benchmarks or guidelines measures are used to establish this recommendation.

10. Describe the design philosophy of your application. Include in your response the degree to which there is a common design philosophy across all modules, common programming languages and tools, and the extent of shared software code across all applications.

Tab 7 – Data Conversion Plan

1. APPROACH

Respondent to detail their approach to developing and implementing the data conversion plan, and what processes will be undertaken by the Respondent’s project team to convert existing data, as well as to interface with identified source systems. Include methods of quality control and testing that will be utilized specific to data conversion.

Describe your organization’s recommended approach toward retention of legacy data. Please describe what options are available, and supported, within your proposed solution. Also, please provide any relevant references of organizations that have successfully addressed legacy data with your solution.

1. ROLES AND RESPONSIBILITIES

The Awarded Respondent will assist the County in the conversion of both commercially available software-based data, and any applicable data maintained in Microsoft Excel and Access, in to the new system as further described in the sources identified in Attachment B, Data Conversion tab.

It is expected that the County will be responsible for data extraction from current systems and data scrubbing, and that the Awarded Respondent shall be responsible for overall data conversion coordination, definition of file layouts, and data import and validation into the new system(s). Awarded Respondent should plan to have converted data ready for the User Acceptance Testing (UAT) phase of the Project.

As part of the resulting Project, the Awarded Respondent shall develop and provide a detailed Data Conversion Plan that describes how files will be converted to the proposed system (e.g., through software conversion aids/utility programs or special programs that must be written, the actual conversion procedures). A conversion schedule should identify planned conversion steps, estimated hours, and what resources will be required (by the County or Awarded Respondent) for all pertinent legacy data.

A. Respondent to confirm their proposal includes providing the services identified in this Section (Item II Roles and Responsibilities) and provide any additional services that are also provided as part of your Data Conversion Plan/Program.

B. Respondent to specify or provide the format in which legacy system data should be extracted and provided to the Respondent for conversion activities.

C. Respondent to specify if the County will receive a database or a data key of how everything is associated to each other in the records.

1. RESPONSIBILITY OF DATA CONVERSION ACTIVITIES

Respondent shall complete the table below based on whether the roles identified are supported by the proposed data conversion methodology and approach. The roles defined in Table 7-01 and Table 7-02 contain the indicators that Respondent shall use to report their support of the identified roles. Any conflicts shall be noted with a comment. In the event additional activities are proposed, the Respondent shall identify the roles for both the County and their Implementation Project Teams.

Table 7-01: Definition of Roles

Table 7-02: Summary of Response Indicators

Table 7-03: Responsibility of Deliverables

Tab 8 – Security and Software Hosting

1. GENERAL OVERVIEW

Respondent to provide a description of the proposed application security features/functionality as well as the underlying technology used to support hosting and access to the software by clients.

1. SECURITY QUESTIONS

Respondent to respond to the following questions related to system security and access controls.

Table 8-01: Security Questions

1. Is Active Directory integration and/or single sign-on supported? Please provide applicable diagrams and/or details to substantiate the level of integration and compliance with published internet standards (i.e., LDAP and DNS).

2. Does the solution integrate with any 2-factor solutions such as Duo, Okta, or Authenticator?

3. Respondent shall detail the ability of the proposed system(s) to integrate with Active Directory Domain Services implemented in accordance with published internet standards such as Security Assertion Markup Language (SAML) and Microsoft Azure Active Directory. If such integration is not offered, Respondent shall explain the identify management solution that is provided.

4. Describe how the SaaS application/service provides two-way user and group synchronization with Active Directory (AD). (e.g., As users and groups are added to and removed from AD, these changes are reflected in the SaaS applications). Would the County AD be able to push, and the SaaS applications able to receive, user profiles and groups?

5. When a user is added to AD, are the proposed solutions automatically provisioned and, conversely, when a user is removed from AD, access is automatically revoked?

6. Are users able to sign on to the Windows network once, and then easily gain access to the proposed applications without having to enter an additional set of credentials?

7. Will Respondent require remote access to the County systems/network to provide support/management of the solution either during implementation or post go-live? If yes, please describe in detail what type of access is required.

8. If any access, remote or physical, is required for accessing the County’s systems/network, will Respondent agree to reviewing and having applicable staff consent to follow applicable the County Security Policies?

9. Will Respondent staff resources be accessing the County systems/network remotely from outside the United States? If yes, please describe in detail the reasoning and how security will be managed.

10. Describe in detail the password requirements and account management standards for the system.

· Can complex password requirements be enforced on the software along with aging requirements if SSO is not available?

· Can accounts be locked-out automatically after ## failed login attempts?

· Are session timeouts enforced in the system?

1. SOFTWARE HOSTING QUESTIONS

Respondent to respond to the following questions regarding their software hosting platform proposed for the County.

Table 8-02: Software Hosting Questions

1. Where are the data center and storage facilities?

2. What is the total number of active clients currently served by hosted/SaaS solutions provided by your company?

3. How many years has your company provided hosted/SaaS solutions?

4. How are hosted/SaaS software applications deployed for use by numerous customers?

5. What availability and response time do you guarantee?

6. How many instances of unplanned outages have any of your customers experienced within the past five years? Describe the nature of any such outages, including the mitigating steps that have been established to minimize repeat outages.

· What has been the duration and scope of such unplanned outages?

7. What is your process notifying the County in the event of a data breach or compromise of your software? Please include details on the communication timeline, escalation procedures, and your action plan for remediation and prevention of future incidents.

8. What are the standard relief schedules for unplanned system downtime/outages?

· In how many instances has your firm had to pay client relief for unplanned outages?

9. What is your process for notification of standard maintenance and downtime? What is your process for notification of unplanned outages and downtime?

10. What data security and system redundancy capabilities are available at Respondent’s data center and storage facilities?

11. How often is data backed up and how often are backups tested?

12. Will data be encrypted at rest, and in transit? Please explain any applicable protocols.

13. How many years has your company provided SaaS solutions?

14. What is the total number of active clients currently utilizing the proposed software as a SaaS deployment provided by your company?

15. Provide relevant documentation related to any recent certifications pertaining to the Respondent’s hosting technical and operation capabilities or that of their subcontracted provider for these services.

16. Provide detailed information on the way(s) in which the County will access the software if deployed in a SaaS or hosted environment. Such information should include how the software is accessed when on or off the County network, as well as any additional hardware/software that may be required for accessing the software.

17. How is data stored? Would the County data be physically or logically segmented from other client data?

18. Please describe the database storage capacity of the proposed solution.

i. Are there limits on the amount of data that can be stored in the proposed solution?

ii. If applicable, what tiers of storage are offered in the hosted/SaaS environment?

19. What disaster recovery services are provided under your standard hosting agreement? If not standard, is there a separate agreement/cost associated with disaster recovery?

20. Please describe the anticipated cost savings or cost avoidance (e.g., reduced hardware needs, maintaining failover sites) that may be realized through selecting a SaaS deployment model. Specific figures from past projects that can be substantiated may be included.

Tab 9 – Testing & Quality Assurance Plan

1. APPROACH

Describe your standard approach to testing and quality assurance.

1. SAMPLE PLAN

Submit a Sample Testing and Quality Assurance Plan that would be very similar to the plan utilized for the County’s Project. Respondent to submit as an Exhibit a Sample Plan in Tab 9.

Exhibit submitted Yes No

1. PLAN DETAILS

Awarded Respondent will be responsible to provide a Testing and Quality Assurance Plan that describes all phases of testing that may be used: unit, system, interface, integration, regression, parallel, and user acceptance testing (UAT). It is the County’s expectation that the Testing and Quality Assurance Plan govern all phases of the Project and that the Respondent will also provide assistance during each testing phase involving the County users. The Awarded Respondent will develop the initial UAT plan, provide templates and guidance for developing test scripts, and will provide onsite support during UAT. The Awarded Respondent will also provide a plan for stress testing the system, which will occur during or after UAT. Respondent to confirm their proposal includes providing the services identified in this Section (Item III Plan Details) and provide any additional services that are also provided as part of your Testing and Quality Assurance Plan not listed.

1. LEVELS OF SUPPORT

What levels of support will be provided by the Respondent during the County testing phases (e.g., parallel and UAT)? Will Respondent resources be onsite during certain testing phases? Are varying service levels offered for testing support?

Tab 10 – Training Plan

1. PROPOSED TRAINING APPROACH/STRATEGY

Respondent to describe the proposed approach to training users of the system, including the frequency of training, timing in the overall sequence of the implementation, as well as training resources/materials that will be provided to trainees.

Respondent to provide their approach to the training plan and what makes their training plan successful and effective for system implementations. Include your approach to when and why you choose to use on-site training versus a webinar or a train-the-trainer format.

Respondent to detail the knowledge transfer strategy proposed to prepare the County staff to maintain the system after it is placed into production.

Respondent to detail the approach to conducting training using webinar (e.g., GoToMeeting, Zoom, Teams, Skype), including how Respondent staff will monitor staff comprehension and, if applicable, provide assistance to trainees on navigation through the system.

Respondent to identify the requested analysis/training room environment requirements and any other requirements related to the training facility/room/equipment. Requirements may include any presentation equipment, whiteboards, seating style, number of computers, printers, and other amenities needed to support on-site implementation activities.

Respondent to detail specific training resources or programs that are available to users post go-live, and how can they access them to maximize their proficiency with the new system.

1. TRAINING PLAN AND RESOURCE HOURS

Respondent to provide a chart detailing the proposed training plan and resource hours allocated for the County’s project. A sample format of the chart is detailed below. Cost Worksheet provided in Attachment C1 to coincide with the hours and resources proposed.

Table 10-01: Training Plan Legend Legend

Table 10-02: Training Plan