RFP 250000002044 - Bidder Questions and Answers.docx

DOCX document 247 KB Posted

Attached to
Custom-built Legacy System Replacement State and local contract opportunity
Solicitation number
RFP-171-250000002044-3
Issued by
Michigan

About this file

This document is a Request for Proposal (RFP) 250000002044 issued by the Michigan Department of Insurance and Financial Services (DIFS) for a custom-built, agency-wide business application to replace their legacy system. The RFP seeks a comprehensive solution to modernize their current PowerBuilder/Oracle-based system, with a target for full deployment rather than a phased approach. The project encompasses replacing multiple existing systems, including OBase, Access databases, and Excel spreadsheets, to create a unified platform supporting all DIFS business processes. The contract term is 5 base years with 3 optional 1-year extensions, and the proposal deadline has been extended two weeks to accommodate vendor questions and preparation.

The State of Michigan will host the solution and prefers a Microsoft .NET Core C# technology stack, with hosting options including government cloud within Microsoft Azure or on-premise. The system must support approximately 400-450 simultaneous office users and integrate with multiple external systems like NMLS, NIPR, and NAIC. The project requires comprehensive document management, workflow automation, reporting capabilities, and adherence to WCAG 2.1 AA accessibility standards. Pricing will be firm fixed-price, with the State not disclosing specific budget information. The vendor will be responsible for data migration, system development, and training, with an emphasis on creating a flexible, scalable solution that can accommodate future business needs without requiring significant modifications.

View the file

Other files for this state and local contract opportunity

Other files attached to Custom-built Legacy System Replacement, newest first.
File Type Posted
Schedule A Table 1 Business Specification Worksheet pt 1.docx DOCX document
RFP 250000002044 DATE CHANGES.docx DOCX document
RFP 250000002044 v1.docx DOCX document
RFP 250000002044.docx DOCX document
Schedule A Table 1 Business Specification Worksheet pt 2.docx DOCX document

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Michigan.gov/MiProcurement

BIDDER QUESTIONS & ANSWERS

RFP 250000002044

Custom-built Agency-Wide Business application for the Department of Insurance and Financial Services and optional maintenance and support.

NOTE: RFP has been updated to include the following:

· New date for question responses and proposal deadline

· Section 3. Purpose updated to include “The State may request additional enhancement work after go-live.”

· Removal of all mentions of Transition In Bidders are responsible for using the correct RFP document when submitting their proposals.

Q #
Document and Section
Page #
Bidder Question
Answer (to be completed by the State)
1
RFP 250000002044
101
Is the State open to using a Platform as a Service (PAAS) solution like Salesforce to host the required solution? The Salesforce platform is very flexible and we've built custom solutions like eDockets and Gas & Pipeline Safety for MPSC. Both eDockets and Gas & Pipeline Safety are custom solutions that meet the unique business needs of MPSC.
No
I am one of State of Michigan vendors. About the custom-built legacy system replacement, do you have the system name and what language or tool was used to build it?
OBase is the primary system we are replacing although there are assorted Access databases as well and stand-alone Power Builder applications. OBase is built in PowerBuilder/Oracle.
Considering the scope of the requirements, the timline for Questions & RFP response is very short. Will State extend the timeline for RFP response?
The deadline for submitting bids has been extended for two weeks.

The RFP cites several schedules. The only schedules available for download are Schedule A Specification Worksheets. Missing are at least D, E, and F.

Could you please post these at your convenience?

All other schedules are within the RFP 250000002044 document.

Can the State clarify expected timelines for each phase of the project? Is a phased rollout preferred, or is full deployment expected by a certain date?
The State prefers a full deployment rather than a phased approach and would prefer the project be done as expeditiously as possible.
Is Microsoft Azure an approved hosting platform for this project, in addition to AWS and Google Cloud?
The solution will be State-hosted. Hosting options do include government cloud within Microsoft Azure as well as on premise. Hosting selection will be at the discretion of the State of Michigan to determine most effective approach for functionality and financial needs for the department.

Are containerized solutions using Kubernetes (e.g., EKS, GKE, AKS) acceptable under the State's hosting guidelines?

Question Date: 2025-04-14 Containerized solutions are acceptable with hosting guidelines. Hosting selection will be at the discretion of the State of Michigan to determine most effective approach for functionality and financial needs for the department.

Does the State currently have licenses or vendor relationships with RedHat or OpenShift, including ROSA or ARO?
Yes, RedHat with onsite OpenShift is in use. No, DIFS is not using ROSA or ARO at this time.
Will the State provide existing data mappings and schemas for OBase and related systems, or is defining those part of this scope?
OBase data dictionary and schema will be provided. Creating data mapping will be in scope for the new system. This will be provided when a contract is signed with a selected vendor.
Does the State have defined benchmarks for expected system performance, concurrency, or usage patterns beyond 400-450 users?
At this time, DIFS has 400 simultaneous office users excluding any traffic that is coming in from the public facing portal. Portal traffic varies throughout the year into the 1000’s of concurrent users.

Vendor-built system should be designed to accommodate DIFS current staff count with consideration for larger use in the future. Benchmarks will be formulated alongside development.

Does the State require compliance with specific frameworks like FedRAMP, NIST, or SOC 2 for the proposed solution?
Yes
Will accessibility (WCAG 2.1 AA) compliance need third-party validation, or is vendor-led testing acceptable?
Final compliance will be determined by eMichigan, a unit of DTMB tasked with assuring WCAG compliance
Does the State have a preferred Agile framework (e.g., Scrum, SAFe), or may vendors propose their preferred methodology?
Vendors may propose their own methodology, but it must map to the SOM Suite methodology. This is done through tailoring sessions with DTMB.
Will the State provide current API documentation for systems like NMLS, NIPR, and NAIC, or is this discovery in-scope?
These will be provided after a signed contract with a selected vendor.
Does the State require specific formats or standards for training, documentation, and knowledge transfer?
The State does not have a set training standard. The vendor may propose best practice solutions for training, documentation and knowledge transfer. Proposed methods will need to be accepted by the State but is expected to be some combination of web-based, in-person instructor-lead with training guides and manuals.
What are the preferred tools and channels for post-deployment support, issue tracking, and SLA compliance?
The State standard and preference is Azure DevOps.

Project Scope & Requirements

· Legacy System Details: Can you provide a more detailed technical description of the current legacy system(s) being replaced (architecture, technology stack, integrations, databases, etc.)?

· Project Objectives: What are the primary business and operational goals for this system replacement (e.g., modernization, scalability, compliance)?

· Third-party Integrations: What existing systems or third-party platforms must the new solution integrate with?

As stated in the RFP:

Legacy System: The current system is built in PowerBuilder with an Oracle backend. There are also an assortment of business systems built in Microsoft Access and other key business data stored in Excel and SharePoint

Project Objectives: The goal is a single system to support all of DIFS business processes. It is a modernization and consolidation of legacy systems

Third Party Integrations: Refer to the integration section listed in the RFP.

Technical Expectations

· Technology Stack Preferences: Are there any preferred technologies, languages, frameworks, or platforms (e.g., Microsoft stack, open-source solutions)?

· Data Migration: Will historical data need to be migrated from the legacy system? If so, can you provide data volumes or complexities?

· API Requirements: Are there existing API specifications we should know about, or is API development expected as part of the scope?

· Accessibility Standards: Are there specific federal/state accessibility standards the system must adhere to (e.g., WCAG 2.1)?

Tech Stack:

The State preference is Microsoft .NET Core C# following DTMB Policies, Standards, and Procedures (https://www.michigan.gov/dtmb/policies/it-policies). All NuGet packages or open-source solutions will be subject to licensing requisition, vulnerability scanning and enterprise approval for use. The agency is open to both desktop and web solutions.

Data Migration: Migration of historical data based on the retention schedule is in scope. The retention schedule information will be disclosed after the contract is signed. The data volume information is provided in the RFP.

API: Other than development of an API to integrate with the public facing portal, API development is not expected as part of scope of this effort. Use of existing APIs is expected.

Accessibility: As stated in the RFP - Bidder must acknowledge that all deliverables provided will be in conformance with World Wide Web Consortium (W3C) Web Content Accessibility Guidelines (WCAG) 2.1 Level AA specifications

Team Composition & Key Roles

· Time Allocation: What is the expected full-time equivalent (FTE) percentage for each key role over the duration of the project?

· Subcontractors: Are there restrictions on subcontractor usage or specific reporting requirements for subcontracted personnel?

· Background Checks: The RFP outlines various background check and security clearance requirements for proposed staff. Could the State clarify the specific background check requirements (e.g., level of clearance, fingerprinting, etc.) for key personnel? Additionally, is there any flexibility or waiver process available for staff to reduce some of the burden, especially if their roles are limited in access to sensitive data?

Time Allocation: Unsure of what this question is asking. Full-time employees are 100% allocated to the project. State does not have specific percentages in mind for vendor-managed employees as it is the vendors responsibility to meet the deliverables on the project, hence the vendor can manage their own resource allocations.

Subcontractors: Offshore resources are not permitted. For additional information regarding subcontractors within RFP see “Disclosure of Permitted Subcontractors”, Disclosure of GDBE Background Checks:

Refer to section 20 Contractor Personnel Requirements in Schedule A – Statement of Work. Vendor resources will be expected to complete and sign the DIFS Confidentiality Agreement.

Timeline & Milestones

· Go-Live Expectations: Is there a target go-live date or mandated delivery deadline?

· Response Deadline: Can the response deadline be extended an additional 2 weeks to allow for a detailed response to be crafted following the release of the Q&A?

Go-Live: The target date is predicated on the proposal. State is not dictating a date.

Response Deadline: The deadline has been extended two weeks.

Pricing & Budget

· Budget Expectations: Is there a defined or expected budget range for the project that vendors should be aware of?

· Optional Services: What are the expectations for the optional support and maintenance components (duration, SLAs, on-call availability)?

· Pricing Format: Can we confirm whether a time-and-materials, fixed price, or hybrid pricing model is preferred?

Budget: Information relating to budgeting on the project will not be disclosed during the bidding process.

Optional Serv: State would like a plan that includes staffing and cost of ongoing support and maintenance. On-call support is not required. DIFS expects the system to have 99.99% availability during regular business hours 7 AM to 7 PM.

Price Format: Time and material pricing is not acceptable and will not be given consideration. This will be a firm fixed price contract as indicated in Schedule B - Pricing.

Evaluation & Compliance

· Weighted Criteria Clarification: Can you clarify how "Schedule A – Business Specifications Worksheet" will be evaluated (e.g., binary met/not met, qualitative scoring)?

· Security Requirements: Can the State provide an example or template for the required Security Accreditation Process referenced in Schedule E?

· Performance Metrics: What SLAs or KPIs will the solution and vendor be held accountable for post-deployment?

· Subcontractor: The RFP references a 20% target for utilizing underserved subcontractors. Can the State clarify if this target is a requirement for all bidders or only applies if a subcontractor is being used to fill capacity or capability gaps? Additionally, is there a waiver or alternative accommodation available for certified small businesses?

Weighted Criteria Clarification: No further detail will be provided outside of what was communicated in the proposal instructions.

Security Requirements:

The security accreditation process mimics the federal government ATO process. It is a review of NIST 800-53 moderate and applicable regulatory controls.

Performance KPI:

We will be using State of MI standard project metrics, examples include Overall Project Status (green, yellow, red), Milestone and Task Progress as % Complete, Number of Project Issues by Priority, Number of Project Risks by Impact & Probability, Number of Project Change Requests, Budget vs Actual Cost and Industry Standard Testing Metrics. We will work with selected vendor to define metrics to be used for the project and ensure they are captured and reported on a consistent basis.

Subcontractor: As indicated per the RFP, “If contractors plan to utilize subcontractors to perform more than 20% of the deliverables under this contract, at least 20% of that subcontracted work must be awarded to Michigan-based Geographically Disadvantaged Business Enterprises (GDBE).

There is no waiver, etc.

What technology is the public facing portal “Portal Service” currently built on?

MS Internet Information Services (IIS), .NET, MS SQL Server, and Oracle.

Can you clarify what you mean by the requirement “The system must utilize the portal previously built for LIAS, Web complaints, Complaint Statistics and Ratios, etc.”? Do you intend to keep the current external portal, and is the scope to integrate with this existing portal? Is this functionality as part of the “Portal Service” or a different portal?
The Portal is an externally faced customer website that must be integrated with any new solution. This is currently being built and will be in production when the vendor goes live.

The “Portal Service” is in reference to this Portal. They are one in the same.

It is our understanding that “DIFS MLO Management” is a separate intranet portal. Should the 'DIFS MLO Management' remain a separate portal, or should it be re-built with the main system?
DIFS MLO management will be part of new system, not a separate portal.
25
RFP
1
Given the scope and complexity of the requirements outlined in the RFP, we would like to respectfully request an extension of the submission deadline.

Response Deadline: The deadline has been extended two weeks.

26
RFP “IT PROFESSIONAL SERVICES CONTRACT TERMS AND CONDITIONS”
Page 61 and 81
We may propose a solution customized to meet your specific needs; however, to expedite the implementation process, we may include our proven proprietary framework and components that have been used in projects of similar scope, size, and functionality. Usable rights for state agencies listed in the contract are included to ensure the product functions as intended. We kindly request clarification on whether the expectations outlined in the clause below align with and meet the State’s needs.

Text from RFP:

· From Page 61: "7.3 Contractor Technology Ownership and License. Ownership of all Contractor Technology, including all Intellectual Property Rights therein, is and will remain with Contractor, subject to the following licenses:

(a) Contractor hereby grants to the State such rights and licenses with respect to the Contractor Technology that will allow the State to use and otherwise exploit perpetually throughout the universe for all or any purposes whatsoever the Deliverables to the same extent as if the State owned the Contractor Technology, without incurring any fees or costs to Contractor (other than the Fees set forth under this Contract) or any other Person in respect of the Contractor Technology."

· From page 81: "(a) Contractor has all necessary rights, title, and/or licenses required to create, develop, or generate Work Product and to transfer all ownership rights in Work Product to the State as set forth in Section 7."

Any IT professional services contract terms and conditions items will be addressed during evaluations or negotiations if necessary.

27
RFP- Schedule A

Section 20

134
Vendor has extensively worked with government clients and fully understands the importance and criticality of data security. We recognize and respect the restrictions related to the use of offshore resources, particularly regarding access to data and confidential information.

As highlighted above, to expedite implementation, we may leverage our proven proprietary frameworks and components. Some team members involved in implementing these proprietary tools may provide support from offshore locations, but they will have no access to client data or confidential information. Hope it aligns with the State’s data security requirements.

Could you please clarify whether such offshore resources—who do not access confidential data—are required to meet background check requirements, or are those requirements applicable only to key personnel with access to sensitive state data?

The State is expecting a fully customized solution that must be built in the United States. The State is not interested in any proprietary frameworks.

Per section 20, Background checks are required for all staff identified for assignment to this project. This includes Contractor personnel that will have access to or have the ability to control access to State Data.

28
RFP- Schedule B
134
Pricing : Does the State have any budget cap—annually, monthly, or for the overall project?
Information relating to budgeting on the project will not be disclosed during the bidding process.
29
RFP- Schedule B
134
Support Service Fee:

You have noted that the State will provide First Line Support prior to submitting a Service Request for Second Line Support from the contractor.

Could you please clarify if the contractor is expected to provide only technical support to ensure the application is up and running, or does the support also include assisting end-users—post-training—with application usage queries and administrative tasks?

The State is open to proposals for ongoing support as they are willing to explore options presented by the bidder. Ongoing support proposals for post-go-live ongoing vendor support should include maintenance and operations. It is expected that administrative tasks will be handled by the State. State will provide ongoing training after go-live.

30
RFP- Schedule D
153
If we choose the 'SCHEDULE D – SERVICE LEVEL AGREEMENT (STATE HOSTED)' option:

· Will the State be responsible for all infrastructure-related support, including backups, with the vendor only responsible for deploying and ensuring the application is up and running? Or is there any additional scope of responsibility expected from the vendor?

· In this scenario, should we exclude infrastructure-related costs from our proposal?

Additionally, can the contractor propose its own hosting environment within the RFP guidelines, subject to State approval? If so, should the infrastructure cost be included as part of the overall project cost?

The State of Michigan will host the solution. The State is responsible for infrastructure.

The State is not considering a vendor-hosted solution and no infrastructure-related costs for hosting should be included in any proposal.

31
RFP-
Is the State expecting the complete project to be implemented within a specific timeline?
The project timeline should be proposed by the bidder.
32
RFP
Does the State have any specific technology stack preferences for the platform on which the proposed solution must be built?"
Tech Stack:

The State preference is Microsoft .NET Core C# following DTMB Policies, Standards, and Procedures (https://www.michigan.gov/dtmb/policies/it-policies). All NuGet packages or open-source solutions will be subject to licensing requisition, vulnerability scanning and enterprise approval for use. The agency is open to both desktop and web solutions.

33
RFP
Did the state receive any help in preparation for this RFP;
No
34
RFP
Is the state willing to build a solution on any of the leading CRM
No
35
RFP
Did the state receive any demos from vendors before issuing this RFP?
No.
36
RFP - CONTRACTOR PERSONNEL REQUIREMENTS / Offshore Resources
138
Does the state have an expectation that this development will occur within its jurisdiction?

In Section 20 of the RFP it states Offshore Resources. Use of Offshore Resources is prohibited per the Schedule E – Data Security Requirements. Contractor must comply with the data security and other requirements in this Contract.

37
RFP - CONTRACTOR PERSONNEL REQUIREMENTS / Offshore Resources
138
Does the offshore restriction apply only to personnel involved in the database migration or those who have access to state data, or does it also include developers and QA analysts working on other aspects of the development?
All
38
RFP; Solicitation Timeline - General
Considering the size of the RFP and time required for vendor to study Q & A responses and provide a robust and cost effective proposal, can state provide additional timeline for Proposal deadline (RFP submission) ?
The deadline for submitting a proposal has been extended two weeks.
39
RFP; Solicitation Timeline
Is there a pre-bid meeting / conference on this RFP, so that the bidding vendor community can better understand the RFP requirements and allow interactive resolution of vendor questions?
There is not a pre-bid meeting for this RFP.
40
RFP; General
Does the State anticipate the user base to increase over time, if so, can you please projected rate of increase ?
The agency using this application does not anticipate any significant increases in the number of users. Any increases would not be enough to impact performance.
41
RFP; General
Is it safe to assume that any import of needed data from external interfaces would be available and that the scope of this project doesn't include any work needed for the data to be generated from a particular system? Please clarify.
No, not all needed data is available within the existing integrations. Some have beta environments however data within will require development and State staff to create scenarios themselves to fit requirements.
42
RFP; General

Does the proposed application need any data to be encrypted?

IF Yes, Does State require the vendor to propose solution for encrypting data for any sensitive data OR are there any existing services with State that can be leveraged. Please clarify.

All data classified as sensitive must encrypted inflight/at rest. The State has standards expected for RDBMS and algorithms for development which will be provided after signed contract with a selected vendor.

43
RFP; General
Please provide a copy of each application screenshots, number of screens, number of batch processes, integrations so that the vendors can assess the complexity of the current applications; The State can remove any sensitive data needed to protect the State.
Screenshots and the number of screens will be provided after a contract is signed with a selected vendor. The listing of integrations has already been provided in the RFP.
44
RFP; General
Please confirm the vendor can develop the new system in the vendor's development environment but use the State environment for system, integration and user acceptance testing.
This is not permitted. All development will be conducted on State infrastructure.
45
RFP; General
Please provide a copy of each current application system report(s) or application generates for the users so that the vendor can assess the complexity of the current application. The State can remove any sensitive data needed to protect the State.
A list of reports has been provided in the RFP. Additional work is currently underway to further clarify State reporting needs. Finalization on the reports required for the new system will take place during the design and discovery phase.
46
RFP; General
Please provide the Technical and Functional Architecture of the current system so that the vendors can understand the data and business process flows of the current application.
This information will be disclosed after a contract is signed with a selected vendor.
47
RFP; General
Will the State provide documented test case scenarios for vendor to use for verification and validation?
The State will document user stories to be used as test cases for verification and validation.
48
RFP; General
Is the current system documentation available for the vendors to review? Please share the same
Any existing documentation, will be disclosed after a contract is signed with a selected vendor.
49
RFP; General
Is the current system documentation accurate and complete?
Some system documentation exists which includes:

· Primary Business Function lists

· Business Process flows

Documentation under development includes:

· Obase business rule extracts

· non-Obase business rule extracts

· Report and Inquiry rule extracts Any user manuals or training videos available regarding the legacy systems will be provided after a contract is signed with a selected vendor although much of this information is not up to date. State resources can assist in providing insight on the current system.

50
RFP; General
Has the State evaluated any similar systems from other states that the state has concluded that meets greater than 50% of new system functionality? If so please share the details.
State of Michigan is an outlier in that other states do not combine insurance and financial institutions with shared entities. No single system solution has been identified.
51
RFP; General
Does State has Technical and Functional Subject Matter Experts for current system in-house and can they be dedicated full time to support as subject matter experts to answer clarifying questions in order for the vendor to complete its scope of work.
State has technical and functional expertise that will be made available, in some capacity, to the project. DIFS resources will have a percentage of time available based on their day-to-day workloads. DTMB Business Analysts will be fully dedicated to the project.
52
RFP; General
How many vendor resources can the State of Michigan accommodate at the SOM offices for the duration of this project?
Depending on the size of the vendor team, the State will work with the selected vendor to provide onsite workspace. State has a hybrid work schedule.
53
RFP; General
Will the State of Michigan team members work onsite and co-located with the vendor resources?
State currently works in a hybrid environment with two days a week required in office but is always subject to change at any time. If necessary, arrangements can be made for onsite meetings but most work will be conducted in a hybrid manner combining in-person and virtual.
54
RFP; General
Are the subject matter experts from the State of Michigan working onsite 5 days a week in-person OR does the State permit them to work hybrid (partially onsite and partially from home)?
State currently works in a hybrid environment with two days a week required in office but is always subject to change at any time.
55
RFP; General
Has state done any assessment of % reusability of existing Obase functionality with as-is conversion vs the modified and new functionality added? If yes, please share your findings.
OBase is written in PowerBuilder. Vendor would have to provide a means to reuse functionality utilizing some form of conversion tool to State standards tech stack. Even with conversion, there would be significant modification of the functionality as it currently exists as opposed to what is expected in the new system.
56
RFP; General
Can State share any existing user manuals, training video about the current system for vendor to understand the current functionality better ?
Any user manuals or training videos will be provided after a contract is signed with a selected vendor although much of this information is not up to date. State resources can assist in providing insight on the current system.
57
RFP; Proposal Instructions; Evaluation Process
4
Does the State has specific expectation on the project duration or Go-Live dates ?
Bidder should include duration and go-live dates in their proposal.
58
RFP; Attachment1, Resume Templates
20
In the RFP, Evaluation process for Scoring table states "Scoring for Table 1 - Business Specifications Worksheet". Does this include both Part 1 & Part 2 of Business Specifications? Or Part 1 alone ?
Both Part 1 and 2 will be evaluated.
59
RFP; Background
100
For key personnel, can one resource play more than one key personnel role? Will the State negatively score vendors who propose one resource to play more than one key personnel role?
One resource can play multiple roles. The only potential negative impact is if one resource is expected to fill too many roles. There is no set number that one individual can fill. The State reserves the right to give deficiencies if proposed staffing seems unreasonable.
60
RFP; Background
100
Is State expecting to have one data model to integrate all business functions in the target modernized application. Please confirm and share your preference and vision.
The State is expecting to have one integrated data model for all business functions. There are several primary business functions used by DIFS. The preference is to complete them in an order that makes the most sense to the business.
61
RFP; Background
100
Is State envisioning the solution as a single portal which will route the user to individual business line functionalities of each business line having their own data model? Please clarify
Yes, there will be a single portal with the data model integrated into a single data model.
62
RFP; Background
100
Does the current system use any software products, plug ins, and or any 3rd party technology tools to currently run/use the current system(s)? If yes, please list them.
Yes, the current system uses MS Access, MS Excel, Oracle, PowerBuilder, Snowflake, MS Power BI, AppWorx.
63
RFP; Background
100
What are the external 3rd party applications accessing OBase. Are these external to SOM? Please list them and provide details with mode of access with data exchange details.
No 3rd party applications access Obase, only the DIFS web applications.
64
RFP; Background
100
Who are the different type of users accessing this application? (Provide both internal & external)
Current access to this system is by internal users and external PSI users. PSI currently uses the current legacy system and could use the new system, however DIFS is open to this subset of users accessing their functionality in a different manner.
65
RFP; Background
100
How much data is in spreadsheets. Are these structured excel sheets? Is there a requirement to migrate the data from spreadsheets to Database? Please clarify & provide details
Spreadsheets are structures but may need modification due to duplicate data. There are requirements to migrate Excel sheet data to Database.
66
RFP; Background
100
Please confirm the below are the 12 business offices that are included in DIFS and Directors Office is not part of 12 business offices.

Office of Appeals, Legal Research, and Market Regulation (OALRMR) Office of Banking (OB) Office of Communications (OC) Office of Consumer Finance (OCF) Office of Consumer Services (OCS) Office of Credit Unions (OCU) Office of Financial and Administrative Services (OFAS) Office of General Counsel (OGC) Office of Innovation and Research (OIR) Office of Insurance Evaluation (OIE) Office of Insurance Licensing, Investigations, and Audit (OILIA) Office of Insurance Rates and Forms (OIRF) The Directors Office is part of DIFS. The list of other offices is correct.

67
RFP; Purpose
101
Which of the 9 business lines that has unique lines of business? Please provide additional details on their uniqueness.
All nine have some variation on the data they are required to collect, the processes they have to follow and the flow of their business. The details of the differences are in the business requirements. Detailed Workflows for each business line will be available to the selected vendor.
68
RFP; Purpose
101
What is the target application technology (including frontend, backend, integrations, database)? Will this be Cloud based or On-Premise application?
The State preference is Microsoft .NET Core C# following DTMB Policies, Standards, and Procedures (https://www.michigan.gov/dtmb/policies/it-policies). All NuGet packages or open-source solutions will be subject to licensing requisition, vulnerability scanning and enterprise approval for use. The agency would prefer to continue use of Oracle database infrastructure they have and is open to both desktop and web solutions.
69
RFP; Purpose
101
Can the vendor use AI tools to develop the code in their own development environment, as part of this modernization project?
Code development takes place in the State environment. Bidder should describe all tools used to create code including A.I. If interested, the State will further discuss in negotiations.
70
RFP; Purpose
101
Can the State provide a timeline by when they want the new system to be ready for UAT, Deployment and Go Live?
Timelines for items listed should be included in bidder’s proposal.
71
RFP; Purpose
101
As a follow-up to the above question, is there a business reason why the state would like to complete this project in this timeline?
There is no set timeline. Timeline will be detailed in the bidder proposals
72
RFP; Purpose
101
Since State requested a State Hosted solution, can vendor assume all hardware / software and associated licenses and setup will be the responsibility of the State? If not, please delineate the responsibilities expected of the vendor versus what the State will be responsible for?
Yes. It will be the responsibility of the State.
73
RFP; 4. IT Environment Responsibilities
107
What is the list of business functionality that would be deemed as "new business functionality" in the new system versus the existing functionality? Can you identify in Business Spec Part1 & Part2 documents.
There is no existing functionality that carries over to the new system. The current system is written in PowerBuilder and will need to be replaced. In addition, there is business functionality that is outside of OBase in MS Access, SharePoint etc. That will be incorporated into the new system.
74
RFP; 10. Software
107
Will State provide State Laptops for vendor team to avoid firewall restrictions with VDI's.
State will provide laptops
75
RFP - Schedule A SOW - General
99-101
Will State provide workspace in State's IT facilities or vendor to execute the project in their office locations.
Depending on the size of the vendor team, the State will work with the selected vendor to provide onsite workspace.
76
RFP, IT Environmental Responsibilities
102
How many SMEs will be allocated to this project during various phases (Planning, Requirements, Design, Development, Testing, UAT, Deployment) of the project for further clarifications, reviews etc.?
SMEs will be assigned in different numbers at different points throughout the project. Different functionality will involve multiple offices which will require additional SMEs. It is not possible for the State to provide a breakdown in SME resources in this manner other than to say they will be available to the selected vendor.
77
RFP, IT Environmental Responsibilities
102
Can the State provide a detailed description of the existing technology infrastructure, including platforms, systems, and software to be modernized or integrated?
Obase is a client server application built in PowerBuilder using an Oracle database.

With regards to Integration, this information is detailed in the RFP in section 12.

State of Michigan leaves open the possibility of maintaining existing Oracle database and not requiring migration of data.

78
RFP, IT Environmental Responsibilities
102
What are the specific data residency and compliance requirements for the systems and data to be hosted under this contract?
Data and documents must reside within the servers hosted by State of Michigan.
79
RFP, IT Environmental Responsibilities
102
What are the key performance indicators (KPIs) or metrics the State will use to measure the vendor’s performance during the contract period?
We will be using State of MI standard project metrics, examples include Overall Project Status (green, yellow, red), Milestone and Task Progress as % Complete, Number of Project Issues by Priority, Number of Project Risks by Impact & Probability, Number of Project Change Requests, Budget vs Actual Cost and Industry Standard Testing Metrics. We will work with selected vendor to define metrics to be used for the project and ensure they are captured and reported on a consistent basis.
80
RFP, IT Environmental Responsibilities
102
Will the State provide access to current system environments or sandbox testing environments during the proposal or implementation phase?
Yes. The selected vendor will have access to the current system.
81
RFP, IT Environmental Responsibilities
102
Are there specific tools or frameworks recommended by the State for project management and codebase version control?
State uses MS Project, Clarity, and prefers Azure DevOps. Git is the preference for codebase version control.
82
RFP, IT Environmental Responsibilities
102
Does any part of the solution require a native Mobile application to be developed or integrated with?
Not at this time. A native iOS or Android application does not fit a current business need.
83
RFP, IT Environmental Responsibilities
102
In order to better understand the functionality being developed, can the State of Michigan provide a demonstration of the current applications to the vendors?
The current application is mostly a licensing processing system for data with workflow. There is also a processing system for customer complaints. While the current system is highly customized, it is fairly standard in design. Demos will be conducted for the selected vendor.
84
RFP, IT Environmental Responsibilities
102
What is the technology stack of Obase? Please provide list of major technology component used.
Client server - PowerBuilder and Oracle
85
RFP, IT Environmental Responsibilities
102
Does the state have a specific technology preferences for development platform, language, etc.?
The State preference is Microsoft .NET Core C# following DTMB Policies, Standards, and Procedures (https://www.michigan.gov/dtmb/policies/it-policies). All NuGet packages or open-source solutions will be subject to licensing requisition, vulnerability scanning and enterprise approval for use. The agency is open to both desktop and web solutions
86
RFP, IT Environmental Responsibilities
102
The RFP states: "The State prefers to leverage either the on-premises State-hosted virtualized data center or a scalable State tenant in an externally hosted approved cloud platform. The State’s Infrastructure as a Service Program currently includes Google (GCP) and Amazon Web Services (AWS). The hosting platform must be approved by the State." Question (1) Does this mean that the State will only want vendors to propose solutions that leverage Google OR AWS? Question (2) Can the vendor proposal a solution using the Microsoft Azure Cloud considering Microsoft is also a State approved cloud vendor? Does the State have any preference?
Hosting options do include government cloud within Microsoft Azure as well as on premise. Hosting selection will be at the discretion of the State of Michigan to determine most effective approach for functionality and financial needs for the department.
87
RFP, IT Environmental Responsibilities
102
Would a proposed solution utilizing the Microsoft cloud stack be acceptable? (i.e. Azure, Azure logic apps, .Net 8+ Core, Azure cloud storage, Power BI, SQL server, etc.)
The solution will be State-hosted. Hosting options do include government cloud within Microsoft Azure as well as on premise. Hosting selection will be at the discretion of the State of Michigan to determine most effective approach for functionality and financial needs for the department.
88
RFP, IT Environmental Responsibilities
102
Are there any preferred technology stacks or integrations the State would like to prioritize for the modernization project?
All integrations are critical. The State preference is Microsoft .NET Core C# following DTMB Policies, Standards, and Procedures (https://www.michigan.gov/dtmb/policies/it-policies). All NuGet packages or open-source solutions will be subject to licensing requisition, vulnerability scanning and enterprise approval for use. The agency is open to both desktop and web solutions
89
RFP - Schedule A SOW - Integration
108
How many different Infrastructure environments needs to be created by Vendor as part of the scope ?
Expect DEV, TEST, UAT, Conversion, PROD. All infrastructure will be handled by the State.
90
RFP - Schedule A SOW - Integration
108-127
Can you please provide XML templates for NMLS and NCUS integration files?
This will be provided upon a signed contract with a selected vendor
91
RFP - Schedule A SOW - Integration
108-127
Can you please provide a template of the text file(s) used for Catalis connections?
This will be provided upon a signed contract with a selected vendor.
92
RFP - Schedule A SOW - Integration
108-127
Can we assume that new connections coming from Catalis will also be a text file as in existing connections?
Yes, we are not expecting any change in the new system.
93
RFP - Schedule A SOW - Integration
108-127
Can we assume that new connections coming from NIPR will also use XML SOAP as in existing connections?
Yes, SOAP returning XML and JSON.
94
RFP - Schedule A SOW - Integration
108-127
Can you please provide text template for files coming in NIPR via SFTP?
Templates will be provided upon a signed contract with a selected vendor.
95
RFP - Schedule A SOW - Integration
108-127
How is the PDF(s) currently added to the OPTINS system currently?
PDF is created through OBase and is manually uploaded into OPTINS by staff.
96
RFP - Schedule A SOW - Integration
108-127
For the files that come in via email, like in item #20 integration (Education Provider to System: Course Schedule Import ), is the State open to an alternate solution other that using email?
Yes. State expects the new solution with be integrated with the DIFS Public Portal. The State is interested in potentially utilizing a “Patient Portal” style method for interacting with the public.
97
RFP - Schedule A SOW - Integration
124
For integrations that are new to the system, is building a new API is an option for the future solution? (i.e. for the SIgma, C3, LARA, etc. inbound and outbound connections?
Non-OBase integrations have their own APIs or methodology to retrieve and send data. No, a new API is not an option.
98
RFP - Schedule A SOW - Integration
125-128
For integration point #41, RFP states "SOM to System: State of Michigan Statutes". What is the specific SOM system this integration is referring to? Please provide details
Point #41 – from the RFP, “This is a new integration and does not exist in the current system.” The specific system to be used will be determined at a later date. This link has an example of existing laws of the type of data that could be retrieved - https://legislature.mi.gov/laws/chapterindex
99
RFP - Schedule A SOW - Integration
128
For integration point 45-52 for public portal integration into system, what data from the public portal what information is needed to be pulled in? Is there a specific location for this data or is this data in a secure location?
The specific data will be provided upon a signed contract with a selected vendor. Data will be comprised of information needed for licensees to perform actions as needed by the business a well as provide public information for search and export. All data exists in the current database.
100
RFP - Schedule A SOW - Integration
108-127
For integration point 53, 54 please clarify the where the data flow destination in the system?
This information is available in the RFP Integration section.
101
RFP - Schedule A SOW - General
99-101
In addition to the list of integrations shared, can the State provide details on which of these integration connectivity will remain same and which of them need to be modified in the new solution?
The existing integration contacts will remain the same. The vendor will need to integrate the new system with the internal/external 3rd parties.
102
RFP - Schedule A SOW - Integration
108-127
Can you provide the integration architecture or flow diagram that lists the integration points for each office utilizes based on the existing system.
Yes. This will be provided upon a signed contract with a selected vendor.
103
RFP - Schedule A SOW - Integration
108-127
What is the State preference on new integration connection types? Please provide additional details for the integration points where the connection types are mentioned as "Unknown".
The Integration with connection type "Unknown" are new integrations. Vendor will be responsible for designing and implementing the new integrations. The State of MI team will provide support as needed.
104
RFP - Schedule A SOW - Migration
130
Can the State provide a list of internal/external 3rd party sources for integrated exchange of data? What is the data flow for each, and will it be the State's infrastructure team or the bidders responsibility to implement/communicate changes to these external sources that connections are changing?
The list of internal/external 3rd party integrations is provided in the RFP. The vendor will be responsible for implementing the integrations. The State of MI team will provide support as needed.
105
RFP - Schedule A SOW - Migration
130
For the Oracle Database does each "office" or unique line of business have there own Oracle database?
No
106
RFP, Data migration
130
Is the existing Oracle instance on-prem or cloud, and what version?
on-prem

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

107
RFP; 10. Software
130
What is the State's preference for the new system's database/data management system? Oracle, Postgres, SQL Server, etc. etc.
The current database is in Oracle and it is expected to remain in Oracle.
108
RFP; 12. Migration
130
Is the new system Data Model available? Can State provide details?
No
109
RFP; 12. Migration
132
RFP states "NOTE: Oracle Database – State of Michigan leaves open the possibility of maintaining existing Oracle database and not requiring migration of data."

What is the reason, SOM wants to maintain in Oracle DB? With all the additional business line functionality, will it not modify the existing data model? Please clarify your thought process.

The data is already in Oracle and the structure is sound. It is proposed that the State will see a time/cost savings by maintaining the current database structure with minor modifications made to meet departmental goals with entity management.

110
RFP; 12. Migration
132
Is migration of data from the legacy application(s) to the new proposed application in scope of this project?
Data will need to be migrated into the system that resides outside the current Oracle database. This includes Access, Excel and other external sources.
111
RFP; 12. Migration
132
If Data Migration is in scope, please provide the volume of data that should be migrated.
Data volume is contained in the RFP.
112
RFP; 12. Migration
132
If Data Migration is in scope, please provide the number of legacy database tables from where the data should be migrated.
This information is contained in the RFP
113
RFP; 14. Training
132
If Data Migration is in scope, please confirm if the state would be responsible for cleansing of existing data to be fit for migration.
The vendor will be responsible for identifying the cleansing requirement in the legacy systems. The vendor will be responsible for cleansing any data that can cleansed systemically. The state will be responsible for cleansing the data in the legacy systems that cannot be systemically cleansed.
114
RFP; 14. Training
132
How many number of training sessions to be conducted? What would be the duration of training sessions?
State requests vendor provide a training plan describing the number of sessions and duration.
115
RFP; 14. Training
144
How many days to be allocated for training timeline for this project
State requests vendor provide a training plan describing the number of sessions and duration.
116
RFP; 14. Training
144
What is the duration for Final End-to-End User Acceptance Testing to be allocated
Duration should be proposed by the vendor.
117
RFP; 14. Training
144
What is expectation on vendor in relation to training ? Is it end user training or training to state employees to understand system functionality and maintain the system on-going basis ?
The State does not have a set training standard. The vendor may propose best practice solutions for training, documentation and knowledge transfer. Proposed methods will need to be accepted by the State but is expected to be some combination of web-based, in-person instructor-lead with training guides and manuals.
118
RFP; 14. Training
144
What is State role in Training the end users and its employees in relation to roll out of the solution ?
State requests vendor provide a training plan based on their own best practices in terms of State involvement.
119
RFP; 24. Project Management
144
For class room training, where is the location of training going to be?
Training will either be virtual or at a State facility in the Lansing, MI area.
120
RFP; 24. Project Management
144
What is the time duration to be allocated for User Acceptance Testing for each MVP/Iteration Release.
Duration should be proposed by the vendor.
121
RFP; 24. Project Management
148
What is the duration for Go-Live readiness to be allocated as it depends on SOM business lines readiness for switch over
Duration should be proposed by the vendor.
122
RFP; 24. Project Management
148
What is SOM's involvement for Performance/Stress Testing & Security/Vulnerability Testing ? Is State team will be part of performing the testing's or expect the vendor to take care end to end.
SOM DTMB will be involved with testing in addition to contract recipient developers. Vulnerability scanning will include static code, dynamic and third-party library. The tools are provided by the State and will be disclosed to the recipient of the contract.
123
RFP; Schedule B - Pricing
152
What kind of Security/Vulnerability Testing is expected for this project? And what tools State will provide for Security/Vulnerability Testing?
Vulnerability scanning will include static code, dynamic and third-party library. The tools are provided by the State and include Fortify, Coverity and Black Duck.
124
RFP; Schedule B - Pricing
152
RFP Release tables states that " % of Milestone (Sprint %'s may be altered, but not exceed 50%)". Does this mean 50% of the release cost should be spread between the Sprints of that release and 50% of the cost is at Acceptable Delivery. Please clarify whether our understanding is correct.
That is correct.
125
RFP; Schedule B - Pricing
152

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .