2nd round questions answers.xls
XLS spreadsheet 44 KB Posted
- Solicitation number
- 74BAI-S2436
- Issued by
- Clark County, Nevada
About this file
This document is a Question and Answer file related to a Request for Proposal (RFP) for the Claims and Regulatory Data System (CARDS) Enhancement Project issued by the State of Nevada. The project is focused on enhancing the existing CARDS application, which is used by the Workers' Compensation Section (WCS) of the State of Nevada. The RFP covers a wide range of requirements, including upgrading the application's user interface, improving document management and search capabilities, integrating online payment functionality, and incorporating existing custom applications. The RFP is open to all vendors, with no set-aside requirements mentioned. The proposal submission deadline has been extended by one week to accommodate the additional Q&A.
The RFP does not specify pricing terms, but it does mention the need to integrate with the state's financial system of record and handle various payment types, including credit cards. The current environment includes user-developed spreadsheets that are filling gaps in the existing CARDS system functionality, and the RFP aims to address these gaps. The funding source for the project is not explicitly stated, but it is likely to be state and potentially local (Clark County and Las Vegas City) funding.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1st round questions received -answers.xlsx | XLSX spreadsheet | |
| Attachments for Signatures 2023-04-13~1.pdf | ||
| Cost Schedule IT - CARDS Enhancement Project.xlsx | XLSX spreadsheet | |
| IT Scope of Work RFP 74BAI-S2436.docx | DOCX document | |
| Reference Questionnaire 2023-04-13.docx | DOCX document | |
| Letter of Intent - CapTech.pdf | ||
| Requirements Matrix - Claims and Regulatory Data System Enhancement Project.xlsx | XLSX spreadsheet | |
| Standard Form Contract .pdf | ||
| Terms and Conditions for Services 2023-04-13~1.pdf | ||
| 74BAI-S2436 CARDS Enhancement RFP~1.docx | DOCX document | |
| Quote Instructions.pdf | ||
| Evaluation Questions - Vendors.docx | DOCX document | |
| Insurance Schedule - RFP.pdf | ||
| Proposed Staff Resume 2023-04-13~1.docx | DOCX document |
Show all 14
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Bid Q&A for Export Report
| Bid Q&A | ||||
| QUESTION_NBR | CREATED_BY | QUESTION_SUBJECT | QUESTION_TEXT | ANSWER_TEXT |
| 1 | SYNAP22 | Subcontractor developer location restrictions | Are there any restrictions on the use of subcontract software developers that are not US citizens and live in other countries? For example, could we as a primary vendor use software developers from Brazil? If the answer relates to being "key personnel", would software developers working on portions of the application be considered key to the project? | |
| 2 | SYNAP22 | Subcontractor background checks | Are subcontractor staff subject to the same Background Check requirements as contractors, listed in section 9.1 of the ?IT Scope of Work RFP? document? | |
| 3 | SYNAP22 | Vendor information response form | Does the vendor information response form need to be completed if we are registered on Nevada ePro? | |
| 4 | SYNAP22 | Demonstration of system with integrated online payments | Regarding Presentation Factor #3, Demonstration of system with integrated online payments and external web portal functionality, under section 7. ?Evaluation? of the ?CARDS enhancement RFP? document, can the State of Nevada please clarify whether they are seeking demonstrated experience developing these systems, or are they seeking a demonstration of such a system? | |
| 5 | SYNAP22 | Required resumes | Is a resume required for all staff engaged on the project, or only for the "Key Personnel": Project Manager, Technical Lead, and Implementation Lead? Do all resumes need to be within the proposed staff resume template? | |
| 6 | SYNAP22 | CARDS demo | Can you provide a demo of the most common use cases for CARDS? It's difficult to get an idea of the complexity and UI/UX quality without seeing the application. | |
| 7 | SYNAP22 | Data warehouse | Do you currently use a data warehouse for BI queries, or do you run them against the production database or a copy of the production database? A data warehouse can improve the usability of BI tools. | |
| 8 | SYNAP22 | Use of cloud infrastructure providers | Would the state consider using AWS, MS Azure, or Google Cloud for the cloud infrastructure? Cloud providers offer far more infrastructure capabilities that would maximize the value delivered. For example, AWS has an amazing Elastic Computing platform which would allow super scalability that would not be anywhere near as easy on in-house Windows servers. They also have low cost object storage, versioning, and archival which would be ideal for all of the documents in CARDS. They have identity management services. They have edge servers which can improve performance. There are many other services that this system would also benefit from. Security would definitely be better using a cloud provider due to the well tested firewalls and security controls. | |
| 9 | SYNAP22 | Angular update | It's not practical to upgrade from Angular 1.x to the current version of Angular 16. Angular version 2.x introduced major fundamental changes in the architecture. In addition, the current system relies on outdated technologies such as jQuery which are strongly recommended against when developing a frontend Angular app. So our assumption is that this would be a complete rewrite using Angular 16+ and ensuring it's modernized, but that the core business logic is retained/adapted. Is this a correct assumption for bidding purposes? | |
| 10 | SYNAP22 | Existing code quality | How can we find out about the quality of the current backend server code? If it's poorly architected or if it uses very old technologies, will we have the option to rewrite the server application. For bidding purposes, should we plan for a complete rewrite, but preserving the core business logic? | |
| 11 | SYNAP22 | Use of .NET | Is .NET a requirement, or would you be open to other languages if the server needed a major rewrite? With the current state of AI tools it would be relatively quick to translate existing .NET logic to a different language thus preserving the investment in the logic while keeping the development firm efficient by allowing them to use their preferred technology stack. | |
| 12 | SYNAP22 | Text search functionality | I would imagine with a tool such as this with so many documents, it would be vital to have a powerful full-text search engine as part of the functionality. Does the current system use ElasticSearch or anything comparable for searching documents and data using stemming, synonyms, etcetera? | |
| 13 | SYNAP22 | Resumes for developers | At what point will we need to provide resumes of the engineers who will be dedicated to the project? | |
| 14 | SYNAP22 | CI/CD process | Will our team be plugging into existing CI/CD pipelines or can we use our own? | |
| 15 | SYNAP22 | Containerization | Do you use containerization, in particular through the use of Docker? This is a huge improvement in terms of scaling over virtual machines and can run on VMs. All cloud providers use containerization now for improved scalability and as a move toward what is referred to as "serverless". Can we either use a cloud provider or have Docker installed on the state VMs? | |
| 16 | SYNAP22 | Dev Ops Engineering | Who will be responsible for DevOps engineering tasks? How much control with we as the vendor have over this? | |
| 17 | SYNAP22 | UI/UX design | Who is responsible for the UI/UX designs of the application? It's very subjective, so how can we reasonably control the time spent on UI/UX design? | |
| 18 | SYNAP22 | Quality Assurance Monitor responsibilities | Will the Quality Assurance Monitor be someone who is highly technical and understands software development in depth, or will it be more focused on functionality, usability, performance, etc? | |
| 19 | SYNAP22 | Database | If during the planning process it appears that a document style database (e.g. - MongoDB) would be better suited than a relational database (e.g. MS SQL Server), would there be any issues with that? | |
| 20 | SYNAP22 | Operating System for the server API | Could the application run in a Linux container (using Docker) even if it had to run on a Windows server? | |
| 21 | SYNAP22 | Server application architecture | Currently is there only a single API process running on the server or are there additional server application processes or micro services in use? Can you provide an architecture diagram? | |
| 22 | SYNAP22 | Data structure diagram | Would you be able to provide a data structure diagram for the current system so we could see the complexity of each database currently in use? | |
| 23 | SYNAP22 | Server code struture | Swagger is a widely used tool for documenting RESTful APIs. It allows you to annotate your ASP.NET Web API controllers with attributes that describe the API operations, parameters, and response types. Swagger UI then generates interactive API documentation that can be accessed through a web browser. Would you be able to generate and provide Swagger documentation to help vendors understand the complexity of the current server code base? | |
| 24 | SYNAP22 | Mobile | Mobile responsiveness is obviously necessary, but would you want the app developed such that it could someday turned into an iOS and Android app? | |
| 25 | SYNAP22 | Progressive Web App (PWA) | A lot of modern apps are being designed as PWAs so that they can be "installed" on mobile devices and desktop machines. They are not true mobile apps, but they allow for a lot of mobile functionality. Would you want the CARDS app to be a PWA? | |
| 26 | SYNAP22 | API | Historically most apps have used RESTful APIs, but modern apps now more often use GraphQL APIs which more easily allow for selective queries. GraphQL is a query language for an API. Would the vendor be able to use GraphQL APIs? | |
| 27 | SYNAP22 | Automated Testing | Is automated testing required? If so, is it required just for services, all core functions, or does the vendor also need to provide automated E2E testing? Or is this at the discretion of the vendor? | |
| 28 | CSHERRARD | BI Platform (3.4.19) | What Visualization tool(s) are you currently using today? Is there a specific reason for choosing Yellowfin Embedded BI, or are alternatives acceptable (Ex. PowerBI, Tableau)? | |
| 29 | CSHERRARD | BI Platform (3.4.19) | How many reports do you plan to need in the future? How many standardized? How many ad-hoc? |
How many reports do you plan to need in the future? How many standardized? How many ad-hoc?
| 30 | CSHERRARD | BI Platform (3.4.19) | To support the BI solution, are there attribute based security needs? Are there row based security needs? |
| 31 | CSHERRARD | BI Platform (3.4.19) | Are there any complex semi-additive metrics (e.g. balance forward, running aggregation, scenario comparison) or non-additive metrics (ratios, KPIs, etc.) that need to be considered? If so, what do those look like? |
Are there any complex semi-additive metrics (e.g. balance forward, running aggregation, scenario comparison) or non-additive metrics (ratios, KPIs, etc.) that need to be considered? If so, what do those look like?
| 32 | CSHERRARD | BI Platform (3.4.19) | How do you define "publish" reports? |
| 33 | CSHERRARD | BI Platform (3.4.19) | Does the reporting need to be more ad-hoc or more standardized with various filters/cuts? |
Does the reporting need to be more ad-hoc or more standardized with various filters/cuts?
| 34 | CSHERRARD | Industry Reports (3.4.13) | Do Insurers/TPAs currently have the ability to "flexibly design and create reports based on needs"? If not is this an external user requirement for the BI solution or another existing tool? Can you explain the expectation for "flexibility" designing and creating reports as an external user? |
| 35 | CSHERRARD | Language | Can you please confirm that the system will only be required to support English? |
| 36 | CSHERRARD | RFP Response | Should the Requirements Matrix be filled out and returned in the Excel attachment, or should it be consolidated into the technical proposal document? |
Should the Requirements Matrix be filled out and returned in the Excel attachment, or should it be consolidated into the technical proposal document?
37 CSHERRARD RFP Response In the RFP document it mentions that the Technical Proposal shall include C. Response to Mandatory Minimum Requirements and D. Response to Critical Items. Please confirm that the Requirements Matrix is the same thing as the Response to Mandatory Minimum Requirements in addition to responding to the Requirements provided in the SOR. Also, please confirm that Critical Items include: Contract Form, Insurance Schedule, Vendor Background.
In the RFP document it mentions that the Technical Proposal shall include C. Response to Mandatory Minimum Requirements and D. Response to Critical Items. Please confirm that the Requirements Matrix is the same thing as the Response to Mandatory Minimum Requirements in addition to responding to the Requirements provided in the SOR. Also, please confirm that Critical Items include: Contract Form, Insurance Schedule, Vendor Background.
| 38 | CSHERRARD | Stakeholder Engagement (3.4.3 / 4.5.3.4)Stakeholder Engagement (3.4.3 / 4.5.3.4) | Is there a WCS Communications Resource / Team to partner with for external stakeholder communications and onboarding new stakeholders? |
| 39 | CSHERRARD | Technology (including 3.4.21) | Will the State consider recommendations to include new software, frameworks, and/or virtual hardware to meet storage and performance requiremetns? For example: NoSQL, Object/BLOB/CLOB storage, server configuration.? |
| 40 | CSHERRARD | Training (2.1.4) | Is the requirement to train 5 functional units, plus the additional external stakeholders? Or will the functional units train their external stakeholder groups? |
| 41 | CSHERRARD | Training (4.7.2 F) | Does CARDS have a training repository or way to link and provide access to training documentation / guides for users? |
Does CARDS have a training repository or way to link and provide access to training documentation / guides for users?
42 CSHERRARD Current State (2.3.3) Could you describe the "gaps" in functionality that the user-developed spreadsheets are currently filling?
Could you describe the "gaps" in functionality that the user-developed spreadsheets are currently filling? Are the gaps addressed in the RFP's requirements or will they need to be integrated or incorporated into the CARDS enhancement in any way?
| 43 | CSHERRARD | Financial system of record (p.8, 3.4.10) | What is the financial system of record? What is the method of integration for CARDS to this financial system of record (ex. API, SFTP)? If possible please provide links to online documentation for this system. | WCS is still working with the Department of Tresurery to pick a 3rd party vendor to provide the financial system, so no documentation can be provided at this time. Interacting with an the 3rd parties API to send and receive payment information and tie it back to outstanding CARDS Monetary Assessments or other imposed fees. |
| 44 | CSHERRARD | External User Types (p.7, 3.4.3) | What are the critical tasks that each external user group is expected to want to complete? | Assessments in regards to reporting, Claims activity report, and invoicing, payments, and D35s and other online forms. Certain online forms should have esignature capabilities. External users will have the ability to create their own accounts. Public can go on and have general external user access. Insurers will need permissions. The ability to add attachments. |
| 45 | CSHERRARD | Integrations (p.9, 3.4.21) | The RFP mentions incorporating functionality from existing WCS custom applications where possible like DTapps and Sputnik. What specific functionality from these systems will need to be incorporated? What existing applications besides Dtapps and Sputnik would functionally be expected to be incorporated from? Can you provide a specific list of applications and functionality that needs to be incorporated? | DTapp functionality regarding debt collection, invoicing, payment processing, form generation, user maintenance, and reporting should be incorporated into CARDS. |
| 46 | CSHERRARD | Integrations (p.10, 3.4.23) | Please describe the FRED functionality. What specific functionality will need to be incorporated? | FRED is used by B&I staff to calculate assessments, create invoices, and track assessment related payments. CARDS will incorporate these functions and allow internal staff to generate activity reports like daily transactions. Internal staff will be able to handle check/cash transactions and record payments including split payments along with other types of payment methods like credit cards, etc. |
| 47 | CSHERRARD | Insurer/TPA Audit Process Automation (p.8, 3.4.5) | Please describe in further detail what functionality you are looking for with the Insurer/TPA audit process automation. Ex. What types of audits does the system need to handle? What key actions would an Insurer/TPA need to take as part of the audit process on the external portal? | Insurers are audited at least once every 5 years. WCS wants to be able to communicate with individual insurers and send notifications like audit reminders and other important audit information to insurers. Insurers/TPAs will be able to submit audit documents to WCS electronically and track audit status. |
| 48 | CSHERRARD | Extension of RFP response submission | In an effort to better incorporate answers from this second round of questions, would WCS consider a 1 week extension of the proposal due date? | Yes, a one week extension of the proposal due date is agreed. |
File details come from the government source that posted it. Updated .