CANCELLED Request for Proposal for a New Centralized GDF Data Warehouse: System Integration And Evolutionary Maintenance Services to the Global Drug Facility (Stop TB Partnership)

New clarification added: Q68: In Form C: Financial Proposal Form - Table 1 – Provision of Professional Services for A. System Integration, can we add rows to include the cost of Corrective Maintenance services, travel cost etc. For Ex. A.8 Corrective Maintenance services, A.9 Travel cost and Onsite Subsistence allowances, etc. Kindly confirm.A68: As per Form C the Corrective Maintenance shall be included in the Total Price offered for the System Integration Service. On-site unit price shall include administrative costs, travel costs and all other related expenses. The Form C: Financial Proposal Form cannot be modified.

New clarification added: Q54: Please Explain the current reporting and analytics model at UNOPS?A54: The analysis of the current reporting and analytics model at UNOPS-GDF/STB will be part of the activities to be executed in the context of this RFP (cfr. Par.4 pag.3 Activity A).Q55: Please Explain the expected reporting and analytics model at UNOPS?A55: The analysis of the expected reporting and analytics model at GDF/STB will be part of the activities to be executed in the context of this RFP (cfr. Par.4 pag.3 Activity A).Q56: How many reports are currently in use at UNOPS ?A56: The analysis of the reports currently in use at GDF/STB will be part of the activities to be executed in the context of this RFP (cfr. Par.4 pag.3 Activity A).Q57: How many reports are expected in the new system?A57: The analysis of the expected reports will be part of the activities to be executed in the context of this RFP (cfr. Par.4 pag.3 Activity A).Q58: How many dashboards/KPI are currently in use at UNOPS ?A58: See answer 56.Q59: How many dashboards/KPI are expected in the new system?A59: See answer 57.Q60: How many automated, manual reports are produced from the current DWH?A60: See answer 56.Q61: Do you have any reports that need to be generated ?A61: See answer 56.Q62: How do non UNOPS person access those reports at present ?A62: Currently, only UNOPS personnel can access STB/GDF reports. Part of the expectations toward the central data warehouse is that it will allow remote access and data sharing with STB/GDF partners and clients.Q63: Kindly share details of the complexity of reports expected as part of this project ?A63: See answer 56.Q64: Will the reports need to be based on standard templates provided by UNOPS or Datamatics team have to design the same?A64: See answer 56 and 57.Q65: Does the training need to happen at UNOPS office at Geneva or can we impart the training remotely using Web Conference tools? Also please share expected topics to be included?A65: In the context of this RFP, the Service Provider should propose its own training strategy and main training topics to be provided.Both initial training sessions for GDF users and system administrators should preferably occur on-site, with follow-up remote support sessions (RFP cfr. pag.4 Activity A.6)Q66: How many users from UNOPS will participate in training?A66: The entire GDF unit will take part in the GDF user training. Currently, the GDF unit consists of +/- 30 employees, which may increase in the future.4-6 persons will take part in the GDF system administrator training session.Q67: Will this project involve database design ?A67: Yes. This will be part of one of the activities to be executed in the context of this RFP (cfr. Par.4 pag.3 Activity A1).

New clarification added: Q47: As per our understanding the pricing for given contract will be Fixed Cost and not on Time and Material basis. Kindly confirm.A47: We confirm this is a Fixed Cost contract for service A. System Integration Service. Regarding service B. Evolutionary Maintenance the pricing will be made for each request and based on the estimation of the effort and the cost of each profile needed for the specific Professional Services. The Form C: Financial Proposal Form cannot be modified and shall be completed accordingly.Q48: As stated in the Form C: Financial Proposal Form - 'Provision of Professional Services' should be cosnidered for Fixed Cost contract and not for Time Material based service? Kindly confirm.A48: See answer 47.Q49: As it is a Fixed Cost contratc, is it mandatory to provide the cost break for each profile in detail?Q49: We confirm that it mandatory to fill the requested forms as they are provided in the Form C.Q50: Considering 3 years of contract duration and 30 weeks (7.5 Months) of System Integration services, the Corrective Maintenance service post Go-Live will be approximately for 28.5 Months. Kindly confirm.Q50: We confirm that if the Service Provider provides a 7.5 Months plan, which is the maximum duration, for the System Integration services the Corrective Maintenance service post Go-Live will be approximately for 28.5 Months + 2 years of potential renewal.Q51: For Corrective Maintenance services, you expect a team of dedicated team members or can we provide shared support services (limited hours in a month) to optimize the cost? A dedicated support by one team member may increase the project cost substantially.shared support services, the given SLAs need to be revised and can be finalized mutually. Kindly confirm if this is accepted.Q51: In the context of this RFP, the Service Provider should propose its own approach for Corrective Maintenance services.Q52: In Form C: Financial Proposal Form - Can we propose multiple pricing options for Corrective Maintenance services? Ex. Dedicated support, shared support, limited monthly hours etc.Q52: The Form C: Financial Proposal Form cannot be modified. The bidder shall provide one single pricing structure (Form C) based on its own selected approach for the Corrective Maintenance service (see answer 51).Q53: Do we have to give payment Milestones in our Financial Proposal (Form C: Financial Proposal Form) or it will be discussed and finalized during the contract finalization?A53: The Form C: Financial Proposal Form cannot be modified. Payment Milestones will be discussed and finalized during the contract finalization.

New clarification added: Q45: In 'RFP_Section_II...' document, page 4 sec 4 A.8, it is mentioned that the Service Provider is required to develop a web-based platform for trouble ticketting. The ambiguity here is whether a tool for ticket management is required or a dashboard to report the tickets is required? Further to this(a) If a tool is required, a different skill-set (Non BI) is required to fulfil the requirement. Please share the expected tool here.(b) If a dashboard is required, what is the ticketing tool used for logging the issues?A45: As specified in the RFP (page 4 sec 4 A.8): “A web based, GDF customized IT platform for trouble ticketing shall be provided / developed by the selected vendor”. This means that the IT platform should be made available to GDF/STB in the context of the System Integration Service provision to raise tickets, track issues, and support project management functions. This tool should also be made available as supporting tool for the Corrective Maintenance Service and Evolutionary Maintenance Service.Q46: To set-up Dev/QA env, following are the dependencies which must fundamentally agree to resolve:(a) Access to all data sources and a sufficient size data dump of all relevant sources - please confirm whether the actual data dump will be shared?(b) Type/format of sources (xls, xml/html, flat-file(del, text quoted), messaging queue etc) - please confirm the number of each source files.(c) Clarity on Data acquisition layer - please confirm whether it is unix or windows?(d) How many new reports are expected to be build?(e) How many existing reports need to be modified based on new WHS solution? (f) Architecture diagram shows MS Analysis Server as existing reporting layer - are there any expectations to move the existing reports to new reporting platform? If yes, please confirm the number of reports.A46: As the central data warehouse is a new project in UNOPS STB/GDF the analysis of points (a), (b), (c), (d), (e) and (f) indicated in your question will be part of the activities to be executed in the context of this RFP (cfr. Par.4 pag.3 Activity A). 

New clarification added: Q36: Are separate development, test and UAT environments required to be deployed for the new BI platform?A36: The development, test and UAT environments required to be deployed for the new BI platform are to be provided by the Service Provider at its best convenience.Q37: Report will pick data from Data Marts, Cubes or DWH? Kindly suggest.A37: It will be an implementation choice based on reporting requirements.Q38: What training is expected (Product Training / Power User Training / Admin Training) as part of the BI implementation?A38: Product training for reporting and models to end user. Admin training to IT staff (cfr. Annex (1): GDF HIGH-LEVEL REQUIREMENTS and specifically GR4) other than supporting documentation.Q39: Do you have a preference of location for the vendor? We propose to execute the project using Onsite-Offshore delivery model to optimize the project cost? Is this acceptable?A39: There are no constraints about the location for the Service Provider having in mind that there are specific SLAs to be respected and specific professional profiles to be involved in the implementation project.Q40: What is BI implementation scope and areas for ex. Finance, Procurement, Supply Chain, Marketing, Sales and QA?A40: See answer 2. Examples areas (list not exhaustive):·         Finance·         Procurement·         Supply Chain·         Sales·         QA·         potentially any other activity related to the Stop TB Partnership (grant management)Q41: Do you have any plan for implementation of mobile apps in future?A41: Yes if the BI solutions can provide those mobile capabilities GDF is willing to have it available for its staff, clients and partners.Q42: Are there any plan to move to Azure platform in future?A42: At the moment there are no specific plans to move to Azure platform in future.Q43: As stated in the RFP, the corrective maintenance services are required during the business hours Monday-Friday. Do you have historical data wherein team members have to work on weekends/holidays? Any anticipated number of days of support required on weekend/holidays?A43: GDF team members, clients and partners work/travel all over the world in different time zones, all year round, and rely 24/7 on the availability of the CDW and BI tools.Being a new project, no historical data is available and UNOPS cannot give a fair estimate of anticipated number of days of support required.Q44: Can Sample Data from source table will be made available ? (Before Discovery Phase)A44: No.

New clarification added: Q22: Please share details of number of excel files from which data needs to be sourced, no. of sheets within those excel files and the average number of fields in each file? And Is the excel data in a standard row-column format?A22: See answer 11.Q23: What is the data volume of individual source systems including Historical Data?A23: See answer 11.Q24: Can we assume that the sources mentioned shall not undergo any enhancements/upgrades/migration during this BI implementation which may impact the design?A24: The data sources to be considered and integrated in the new centralised DWH will be assessed at the beginning of the project (cfr. Par.4 pag.3 Activity A). On the bases of the initial analysis phase, the implementation of the BI / new centralised DWH will not be impacted by any enhancements / upgrades / migration of those data sources.Q25: How many more data sources are anticipated in future?A25: See answer 2. The solution must be flexible and must accommodate possible future data sources.Q26: How much historical data in terms of years is available in the current systems?A26: See answer 2. Historical data goes back to year 2005.Q27: How do you handle MDM (Master Data Management)A27: UNOPS does not handle MDM. The selected vendor shall propose MDM model after the initial phase of the project.Q28: What is the expected data retention period? How many years of data will be required to be online on the BI System?A28: Unlimited period/years.Q29: Are you looking for CDC (Change Data Capture) and SCD (Slowly Changing Dimensions) to be implemented as a part of DWH if yes then at what level?A29: CDC/SCD has to be evaluated during the initial analysis phase at the beginning of the project (cfr. Par.4 pag.3 Activity A).Q30: Data processing Frequency: Interactive or Batch or Real time frequency?A30: Data processing frequency for most flows is batch. Some flows however need to be processed “near real time” (cfr. Annex (1): GDF HIGH-LEVEL REQUIREMENTS and specifically GR2).Q31: How is the quality of data from source? Any concerns on data quality of the source systems. If yes, please provide details.A31: There are no specific data quality activities currently performed at data sources level.Q32: What kind of metadata is available in the current source systems?A32: There are no metadata useful to optimize data load activity. This should be developed during the initial analysis phase at the beginning of the project (cfr. Par.4 pag.3 Activity A).Q33: How many analytical models are required to be built in the BI System?A33: See answer 2.Q34: Does a consistent, system-wide data dictionary exist across all the data sources?A34: Currently no data dictionary is available across data sources, but this must be defined during the initial analysis phase at the beginning of the project (cfr. Par.4 pag.3 Activity A).Q35: In case of On-Premise solution will the infrastructure procurement and capacity planning be done by UNOPS?A35: Yes, we confirm that in any case the Production environment, including infrastructure procurement and capacity planning, will be done by UNOPS.

New clarification added: Q10: What is the current stage and how UNOPS operates with sample data and reports?A10: Currently UNOPS has a set of reports based on raw data coming from different sources. Tools used by UNOPS are Microsoft Excel and Microsoft Access. Additional reports will need to be created. Additional data will also need to be mapped, connected and integrated.Q11: What are the number of source tables from which data needs to be extracted from each database and the average number of fields in each table?A11: A representation and description of the data sources are presented into Annex (2): TARGET LOGICAL ARCHITECTURE and Annex (3): DATA SOURCES (additional details and specifications) of the TOR. At this stage it is not possible to identify the number of source tables from which data needs to be extracted since one of the activities to be executed in the context of this RFP is the definition of the definition of the Target Data Model (cfr. Par.4 pag.3 Activity A1).Q12: Data Is Structured, Semi structured or Unstructured?A12: There are different data sources and different set of data: Structured, Semi-structured or Unstructured.Q13: As per the scope of work mentioned in RFP document, this project include building a new structured Data warehouse and data flows. Do you envisage to implement Big Data concepts and related solutions for effectively handling the unstructured data in coming future?A13: At this stage there is no strategy for GDF/STB to implement Big Data. Any guidance, expert advice or proposals related to a Big Data strategy will be welcome.Q14: Are there any unstructured data sources to be considered as part of scope of this implementation? What are they? Please provide the sample data and what is your way to handle this and why is it needed.Q14: See answer 12.Q15: As mentioned in the RFP, when this phase need to be consider "2. Scope and objective(s) of the assignment"A15: Not clear. Please rephrase.Q16: Please give some example/sample data for unstructured data, Ex. Social Media files Audio Video, Json, XML, PDF etc.A16: UNOPS/StopTB-GDF is working to end TB in the world. Many sample data related to Tuberculosis (TB) can be found on our official website (www.stoptb.org) or are available on the internet.Q17: What is the current/expected data Volume per day/hour/minA17: See answer 2.Q18: At what Granularity Data will need to be stored in DWH? Or what level of granular data is expected? Bottom level of data you would like to see? For Example: want to see sales report on daily basis so the granularity here is at daily level.A18: See answer 2. Generally, we aim at the lowest level of data. Q19: What is the average number of source tables from which data needs to be extractedA19: See answer 11.Q20: As per our understanding, the data source mentioned in RFP contains Structured Data? If No, please elaborate.A20: Yes but not only structured data. See answer 14 and 12 as well as Annex (3): DATA SOURCES (additional details and specifications) of the TOR.Q21: What is the average expected Data Size of DWH.A21: See answer 2.

New clarification added: Q1: As per our understanding, the Dev/UAT/Production environment will be setup by UNOPS team and the vendor will access the same remotely for application development/testing etc. It would be more convenient and secured approach. Kindly confirm. In case vendor has to setup the development environment, do we need to factor the cost of software licenses in our financial proposal?R1: We do not confirm. Only the Production environment will be provided by UNOPS and the cost will be borne by UNOPS. As mentioned in the TOR (cfr. Par.2 pages 1-2):Additionally, the Service Provider shall rely on its own environments (i.e. development, testing, pre-production) and hosting services based on the SW components listed above, in order to start the implementation of the new centralized DWH. That is, the Service Provider should not rely on GDF hosting services and HW infrastructure during the implementation phase but should ensure the support for the migration of the developed new centralised DWH system to the server in production. The financial proposal will have to be provided using the form included in the tender documentation.Q2: What is the current overall data size in GB/TB?A2: This should be defined during the initial analysis phase at the beginning of the project (cfr. Par.4 pag.3 Activity A).Q3:What is the data volume in terms of GB/TB of individual source systems mentioned in the RFP?A3: See answer 2.Q4: What is the approximate year on year data growth in terms of %? (Current System)A4: See answer 2.Q5: With respect to members and suppliers, please specify the anticipated user traffic and expected annual growth rate of these users?A5: See answer 2.Q6: As per our understanding the all the software licenses and hardware infrastructure required for development/UAT/Production environment will be provided by UNOPS and the cost will be borne by UNOPS. Kindly confirm.A6: We do not confirm. Only the Production environment will be provided by UNOPS and the cost will be borne by UNOPS. As mentioned in the TOR (cfr. Par.2 pages 1-2):Additionally, the Service Provider shall rely on its own environments (i.e. development, testing, pre-production) and hosting services based on the SW components listed above, in order to start the implementation of the new centralized DWH. That is, the Service Provider should not rely on GDF hosting services and HW infrastructure during the implementation phase but should ensure the support for the migration of the developed new centralised DWH system to the server in production.Q7: As per our understanding the required Tableau licenses (server and client/user) will be provide by UNOPS. Which licenses of Tableau are currently used? How will you provide us the access for the development?A7: The licenses currently used are: Tableau Desktop 10.4  The Service Provider will be in charge of the development environment. As mentioned in the TOR (cfr. Par.2 pages 1-2):The Service Provider should not rely on GDF hosting services and HW infrastructure during the implementation phase but should ensure the support for the migration of the developed new centralised DWH system to the server in production.During the development and testing phase GDF users/testers will use their own BI desktop license (Tableau or Power BI). The selected service provider will need to have their own license for their own infrastructure.Q8: How many hours during the discovery frequency will be allotted for UNOPS to perform discoveries?A8: Question unclear. Please reformulate the question, define discovery frequency and provide details of activities part of the discovery frequency. UNOPS guarantees availability of staff during discovery.Q9: As stated in the RFP, there are several challenges and GDF is keen on creating a new centralized data warehouse (DWH) and establishing a new and improved data flow. What are these challenges?A9: Main challenges encountered by GDF in its Data Management processes currently in place can be summarised as follow (not exhaustive list):·         Data Quality·         Data Coherence between different data sources·         Operational challenges (i.e. poor automatization, repeated operation)·         Lack of data mapping/interexchange between sources·         Incomplete technical documentation