Procurement Portal
CLOSED
CREATION OF PERFORMANCE MANAGEMENT DATABASE
Last updated by Addendum #3 on Dec 4, 2019 11:26 PM
Post
Big Blue Bus
20500, 92000
Project ID: 247
Release Date: Friday, November 15, 2019
· Due Date: Monday, December 16, 2019 3:00pm
Posted Friday, November 15, 2019 3:22pm
All dates & times in Pacific Time
Question & Answer
Questions and clarifications about the project
1. No subject Nov 19 2019 at 12:21 PM
- Anonymous Nov 19 2019 at 12:21 PMUser information is private
Are all systems in the list of Data Sources (RFP pages 4-5) in active use by the City? In short, we would like to clarify the distinction between historical data migration needs versus ongoing data synchronization needs. - Question is acknowledged
2. Reporting Nov 19 2019 at 12:21 PM
- Anonymous Nov 19 2019 at 12:21 PMUser information is private
Is the City able to provide any sample reports? - Question is acknowledged
3. User volume Nov 19 2019 at 12:22 PM
- Anonymous Nov 19 2019 at 12:22 PMUser information is private
We understand that the City is requesting "unlimited agency users" (per RFP pg 6), however, it would be helpful to understand anticipated usage volumes. Is it possible to provide an approximate user count and/or an estimate of concurrent users? - Question is acknowledged
4. User roles Nov 19 2019 at 12:22 PM
- Anonymous Nov 19 2019 at 12:22 PMUser information is private
Can the City provide examples of anticipated user roles? - Question is acknowledged
5. Database structure Nov 19 2019 at 12:23 PM
- Anonymous Nov 19 2019 at 12:23 PMUser information is private
Page 7, item c. states: "These reports shall include an SQL based data mart." Is an SQL based solution a strict requirement? Please clarify whether the City is open to NoSQL database solutions, provided that all functional requirements are met. - Question is acknowledged
6. Project schedule Nov 19 2019 at 12:28 PM
- Anonymous Nov 19 2019 at 12:28 PMUser information is private
Has the City determined a target go-live/launch date for the requested solution? - Question is acknowledged
7. Proprietary Systems Nov 20 2019 at 10:14 AM
- Anonymous Nov 20 2019 at 10:14 AMUser information is private
How will data in the proprietary systems be accessed? - Question is acknowledged
8. Training Nov 20 2019 at 10:15 AM
- Anonymous Nov 20 2019 at 10:15 AMUser information is private
Approximately how many people will require training? Will there be any need for ongoing training? - Question is acknowledged
9. BBB to conduct demonstration with qualified vendors Nov 20 2019 at 10:17 AM
- Anonymous Nov 20 2019 at 10:17 AMUser information is private
Please provide details. - Question is acknowledged
10. City Disaster Recovery Plan Nov 20 2019 at 10:17 AM
- Anonymous Nov 20 2019 at 10:17 AMUser information is private
Please provide a copy or general requirements - Question is acknowledged
11. Database fields and reports Nov 20 2019 at 10:20 AM
- Anonymous Nov 20 2019 at 10:20 AMUser information is private
Will the city provide guidance on the specific data fields to be captured from existing systems and the types of reports required? - Question is acknowledged
12. Data Cleansing Nov 20 2019 at 10:20 AM
- Anonymous Nov 20 2019 at 10:20 AMUser information is private
Will the city provide guidelines and standards for data cleansing? - Question is acknowledged
13. Useable and Meaningful Data Nov 20 2019 at 10:22 AM
- Anonymous Nov 20 2019 at 10:22 AMUser information is private
Please provide an example or description of the useful and meaningful data that the city desires to extract from the new database. A copy of the current BBB quarterly performance report would be helpful. - Question is acknowledged
14. 247 PERFORMANCE MANAGEMENT DATABASE Nov 20 2019 at 10:12 PM
- Anonymous Nov 20 2019 at 10:12 PMUser information is private
1. Whether companies from Outside USA can apply for this? (like,from India or Canada) 2. Whether we need to come over there for meetings? 3. Can we perform the tasks (related to RFP) outside USA? (like, from India or Canada) 4. Can we submit the proposals via email? - Question is acknowledged
15. Data Extracts and Cleansing Nov 21 2019 at 8:25 AM
- Anonymous Nov 21 2019 at 8:25 AMUser information is private
How frequently is data to be extracted from the data sources (daily, monthly, quarterly, etc.) and approximately how many data records will require some type of cleansing? - Question is acknowledged
16. No subject Nov 22 2019 at 8:39 AM
- Anonymous Nov 22 2019 at 8:39 AMUser information is private
1. The vendor selection approach identifies the following steps. Please explain the prototyping scope expectations and whether the prototype is performed under contract for a fee or if the City expects the prototyping services to be borne by the consultant. a. Establish a list of qualified vendors. b. Conduct demonstrations with qualified vendors. c. Develop a prototype and select a qualified vendor to provide a new data base solution. - Question is acknowledged
17. No subject Nov 22 2019 at 8:39 AM
- Anonymous Nov 22 2019 at 8:39 AMUser information is private
2. Does the Rideshare Plus SaaS have an API for data extraction? - Question is acknowledged
18. No subject Nov 22 2019 at 8:39 AM
- Anonymous Nov 22 2019 at 8:39 AMUser information is private
3. The RFP sites “The vendor would be required to complete every phase of the project, including data cleanup, design, building, integration of input systems, testing, implementation, training and provide support and maintenance services as required.” Please elaborate on the data quality issues that need cleanup and whether the cleanup will be a persistent problem as the source data continues to be updated. It is difficult to estimate the level of effort for data cleanup and whether there is an ongoing cost or just initial one-time cleanup. - Question is acknowledged
19. Technology Nov 22 2019 at 11:06 AM
- Anonymous Nov 22 2019 at 11:06 AMUser information is private
Does the City have a specific preference for a cloud provider? - Question is acknowledged
20. Technology Nov 22 2019 at 11:06 AM
- Anonymous Nov 22 2019 at 11:06 AMUser information is private
Does the City have a specific technology preference? - Question is acknowledged
21. Data Nov 22 2019 at 11:06 AM
- Anonymous Nov 22 2019 at 11:06 AMUser information is private
Does the data only have to be aggregated quarterly? If not what is the frequency? - Question is acknowledged
22. Data Sources Nov 22 2019 at 11:07 AM
- Anonymous Nov 22 2019 at 11:07 AMUser information is private
When are the data sources available for the quarterly reports? - Question is acknowledged
23. Data Sources Nov 22 2019 at 11:07 AM
- Anonymous Nov 22 2019 at 11:07 AMUser information is private
Is the structure of each data source always the same, or does it change every-time it's queried? - Question is acknowledged
24. Security Nov 22 2019 at 11:07 AM
- Anonymous Nov 22 2019 at 11:07 AMUser information is private
Does the City provide a secure way for the Vendor to query the data inside the firewall? Please explain how. - Question is acknowledged
25. Data Sources Nov 22 2019 at 11:08 AM
- Anonymous Nov 22 2019 at 11:08 AMUser information is private
Please provide an estimate of the size of each of the data source data for each quarterly report. - Question is acknowledged
26. Data Nov 22 2019 at 11:08 AM
- Anonymous Nov 22 2019 at 11:08 AMUser information is private
Please provide a sample of each data source data. - Question is acknowledged
27. Reports Nov 22 2019 at 11:08 AM
- Anonymous Nov 22 2019 at 11:08 AMUser information is private
Please provide a recent example of the quarterly report. - Question is acknowledged
28. Reports Nov 22 2019 at 11:08 AM
- Anonymous Nov 22 2019 at 11:08 AMUser information is private
Please provide a recent example of the legacy spreadsheet. - Question is acknowledged
29. Security Nov 22 2019 at 11:09 AM
- Anonymous Nov 22 2019 at 11:09 AMUser information is private
Does the City currently use Microsoft Active Directory for user authentication. If not please explain how users currently authenticate to access City IT resources? - Question is acknowledged
30. Security Nov 22 2019 at 11:09 AM
- Anonymous Nov 22 2019 at 11:09 AMUser information is private
Please provide the BBB's availability and recovery times (see Security item e). - Question is acknowledged
31. Data Privacy Nov 22 2019 at 11:09 AM
- Anonymous Nov 22 2019 at 11:09 AMUser information is private
Does the data sources contain any PII (personally identifiable information)? - Question is acknowledged
32. Data Storage Nov 22 2019 at 11:10 AM
- Anonymous Nov 22 2019 at 11:10 AMUser information is private
The City states Unlimited data storage. Please provide an estimate of data size for each quarter. - Question is acknowledged
33. Process Nov 22 2019 at 11:10 AM
- Anonymous Nov 22 2019 at 11:10 AMUser information is private
Section I(A)(3) mentions a prototype — is this prototype to be developed before Feb 12, 202 as part of the selection process? or is this part of the project implementation starting Feb 12. - Question is acknowledged
34. Timing Nov 22 2019 at 11:10 AM
- Anonymous Nov 22 2019 at 11:10 AMUser information is private
Does the City have an expected go-live date for the new solution? - Question is acknowledged
35. Golden Five Consulting Nov 25 2019 at 10:01 AM
- Nov 25 2019 at 10:01 AMCity of Santa Monica
What does proprietary application means? - Question is acknowledged
36. Golden Five Consulting Nov 25 2019 at 10:02 AM
- Nov 25 2019 at 10:02 AMCity of Santa Monica
What is the technology stack used for those applications? - Question is acknowledged
37. Golden Five Consulting Nov 25 2019 at 10:03 AM
- Nov 25 2019 at 10:03 AMCity of Santa Monica
Are you interested in lift and shift of those applications or need them to be in SharePoint? - Question is acknowledged
38. Golden Five Consulting Nov 25 2019 at 10:05 AM
- Nov 25 2019 at 10:05 AMCity of Santa Monica
1. What does proprietary application means? 2. What is the technology stack used for those applications? 3. Are you interested in lift and shift of those applications or need them to be in SharePoint? 4. Where is it used? 5. How much business critical those applications are? 6. What are perceived downtime for them? - Question is acknowledged