Tab 21 ETRS RFP Questions and Answers.xlsx
XLSX spreadsheet 16 KB Posted
- Solicitation number
- 6973GH-20-R-00138
About this file
This document provides details for a federal solicitation seeking an enterprise transactional reporting solution. The Federal Aviation Administration's Enterprise Services Center is seeking to replace its unsupported Oracle Discoverer reporting tool with a new scalable solution to support approximately 2,000 reporting users and up to 250 existing reports. The proposed solution must include a reporting tool supporting multiple data sources, a pre-built automated Discoverer migration utility, and pre-built EBS transactional reports and data model. The acquisition will award a single contract for implementation, consulting, and training services over a potential nine-month base period and six-month option. Questions are due by September 4th and proposals are due by September 25th by email only. The selected contractor will own the licensing for the new reporting tool.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 6973GH-20-R-00138 ETRS Attachment 03 SOW Template.docx | DOCX document | |
| 6973GH-20-R-00138 ETRS Attachment 02 Labor Category Descriptions.xlsx | XLSX spreadsheet | |
| 6973GH-20-R-00138 ETRS Attachment 04 Past Performance Questionnaire.docx | DOCX document | |
| Tab 21 SIR Amend 6973GH-20-R-00138-00001 ETRS.pdf | ||
| 6973GH-20-R-00138 ETRS Attachment 01 Statement of Objectives.docx | DOCX document | |
| Tab 16 SIR 6973GH-20-R-00138 ETRS.pdf |
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
Sheet1
| Question | Answer |
| Is ESC open to leveraging technology already owned or does it need to be a new software acquisition? | new software acquisition |
| Can there be 2 solutions offered to meet FAA's needs such as Tableau and Oracle? | No, we are looking for a single reporting tool for transactional reports |
| In reference to SIR 6973GH-20-R-00138 (ETRS), will the government consider changing the NAICS code from 541990 to 541519 (Other Computer Related Services) with a size standard of $30M? This change will result in more competition, is aligned with the scope of services, and while maintaining small business set-aside. | yes, the NAICS will be updated to 541519 via solicitation amendment. |
| Section AC1045 PREPARATION OF TECHNICAL PROPOSALS (JAN 1997) Letter d; 2-5 refer to Aircraft and simulator training. Is this something we must address for the reporting solution? | Clause is removed in amendment. |
| Are resumes apart of the 20 page count | No |
| Can we submit a separate cover sheet? | Yes |
| If so, does it count towards the 20 pages for the Technical Proposal? | No |
| Is ESC open to leveraging technology already owned or does it need to be a new software acquisition? | new software acquisition |
| Does the technology have to work on Internet Explorer or is Chrome sufficient? | Per section 4.1 of Attachment 01 Statement of Objectives, "User Interface is: Operating system, web browser, and device independent" |
| Page 7 of 26 of document “6973GH-20-R-00138 ETRS Attachment 01 Statement of Objectives.doc” – Could you please elaborate on the Pre-built EBS-based reporting data model and Pre-built transactional EBS reports for Financials, Procurement, and Projects and provide further details on the expected specifications of the “pre-built” models and reports? | The Enterprise Transactional Reporting Solution must include a reporting tool that supports multiple data sources for relational, non-relational and analytical databases. It must also include a pre-built automated Oracle Discoverer migration utility. |
To facilitate ESC’s implementation of the new reporting solution, pre-built transactional EBS reports and an EBS-based reporting data model must be included. Please refer to section 4.2 Task 4 & Task 5 of Attachement 01 Statement of Objectives for more information.
| Page 67 of document “Tab 16 SIR 6973GH-20-R-00138 ETRS.pdf” – Section M 4.1.2 bullet # 3 a-e – Could ESC please confirm the mapping of CLINS with the request for Fixed Price and Labor hours and Expenses. The content in the table on pages 2 and 3 of this document does not appear to be aligned with information in this bullet point. | The list at M 4.1.2 is correct with respect to the CLIN structure and types. CLINs 0005, 0008, & 0010 are labor hour, requiring the proposal of a burdened labor rate. CLIN 0009 is travel and does not require any proposed amount. The remaining CLINs are fixed price. |
| For CLIN 1, does the Government prefer an Oracle-based proposed solution? | No preference |
| For CLIN 1, does the Government prefer a cloud-based proposed solution? | Per the Considerations section of Attachment 01 Statement of Objectives, "Indicate the deployment models available for your solution. o On premise o Cloud-based – e.g. Software-as-a-Service |
| For CLIN 1, can the proposed solution be COTS? | Yes |
| How did the Government estimate the hours for tasks CLINs 4, 5, 8 & 10? | Hours per month times number of months times number of resources |
| For CLINs 6 & 7, how many training sessions does the Government estimate? | For CLIN 6, per section 4.3, Task 7 of Attachment 01 Statement of Objectives, "KNOWLEDGE TRANSFER: The act of a contractor communicating to designated customer staff, providing a variety of wisdom, insight and tacit knowledge and information including, but not limited to the product, processes, procedures, best practices, lessons learned, learn-by-doing, and tips. The contractor should identify, capture and share critical expertise and practice knowledge. The contractor should use various means of communications to transfer that knowledge which can include but is not limited to: one-on-one mentoring, observation/shadowing paired programming, question and answer sessions, group discussions, documentation references, and white board discussions. Contractor will provide opportunities for ESC staff to apply knowledge (learn-by-doing) that is transferred" |
For CLIN 7 per section 4.3 Task 8 of Attachment 01 Statement of Objectives, "a total of four (4) Enterprise Transactional Reporting Tool formal training workshops with a mutually agreed upon agenda and duration between the vendor and the ESC staff."
For CLINs 6 & 7, how many students for each training session and total does the Government estimate? For CLIN 6, per section 4.3 Task 7 of Attachment 01 Statement of Objectives, "the contractor personnel must engage appropriate ESC staff in a variety of ways including but not limited to, observation, learning by doing, and question/answer sessions."
For CLIN 7, up to 20 students per formal training workshop
| For CLINs 6 & 7, can training be provided virtually or is it required to be in person, on site? | Per section 6.3 of Attachment 01 Statement of Objectives, "Telework capability may be authorized but must be approved by the COR, and CO." Task 3 must be performed on-site. |
| For CLIN 9, how many trips does the Government estimate? | 3 for Implementation Services and 4 for Training Services |
| Is the primary place of performance on the Government’s or contractor’s site? | Per section 6.3 of Attachment 01 Statement of Objectives, "The contract is to be performed primarily at the Mike Monroney Aeronautical Center (MMAC), 6500 South MacArthur Blvd, Oklahoma City, Oklahoma, unless otherwise mutually agreed upon between the Government and the Contractor. " |
| Comment/Question: This section references an attached Statement of Objectives (SOO), but there is no attachment to the document or link on Beta SAM. Will you provide the SOO? | It is in the PDF attachments (paper clip on the left toolbar) |
| Comment/Question: This section lists four attachments; 1. SOO, 2. Labor Category Descriptions, 3. ETRS SOW Template, and 4. ETRS Past Performance Questionnaire but there are no attachments to the document or links on Beta SAM. Will you provide the attachments? | It is in the PDF attachments (paper clip on the left toolbar) |
| Question: What features of the current solution (Discovery) does the Government want to retain? | Oracle Discoverer is the ESC customers most relied upon transactional reporting tool due to its ability to meet standard, flexible reporting and ad hoc data consumption needs. |
| Question: What features of the current solution (Discovery) does the Government dislike? | The product is in Sustaining Support Sustaining Support and does not include: |
- New program updates, fixes, security alerts, and critical patch updates
- New tax, legal, and regulatory updates
- New upgrade scripts
- Certification with new third party products/versions
- 24 hour commitment and response guidelines for Severity 1 service requests as defined in the Severity Level section below
- Previously released fixes or updates that Oracle no longer supports Question: What new features, if any, would the Government like to see in the proposed solution? Per section 4.1 Task 1 of Attachment 01 Statement of Objectives provides the minimum requirements
| When does the agreement with Oracle Discoverer (including EBS) expire? | Oracle Discoverer has been in Sustaining Support since December 2014. |
| What other transactional, and non-transactional, reporting tools reside within ESC? | Oracle Discoverer and Oracle Business Intelligence Enterprise Edition (OBIEE) |
| What technology do you use today for data storage, processing, engineering/integration, orchestration/preparation, visualization and advanced analytics? | Oracle Databases running on Exadata. |
| Has a preference between cloud vs on prem vs hybrid data and analytics architecture been established? | Per the Considerations section of Attachment 01 Statement of Objectives, "Indicate the deployment models available for your solution. o On premise o Cloud-based – e.g. Software-as-a-Service |
| With regards to FedRAMP authorization, is that a requirement of the contractor bidding on this RFP or is that a requirement of the selected vendor providing cloud services? | For a cloud-based solution, the contractor must possess and maintain a Federal Risk and Authorization Management Program (FedRAMP) Moderate Software as a Service (SaaS) authorization |
| How many source systems are being considered for use with the new platform? Are there data sources outside of Oracle that will need to be integrated into the new platform? | Per section 2 Objective of Attachment 01 Statement of Objectives, "ESC’s Discoverer End User Layer (EUL) is primarily based upon the Oracle Federal Financials EBS and Unison Procurement Request Information System Management (PRISM) data model designs with some custom folders included for specialized reporting. While these two data sources are noted specifically, additional sources exist." |
| Are there considerations for additional scope to include things like Change Management and UX design? | This is not included in the scope of this procurement. |
| What is the expectation with regards to the five environments being set up? Is the contractor just establishing those environments or is the expectation for the contractor to establish processes around SDLC and provide the resources to support migration through those environments (testing resources, etc.)? | Per Attachment 01 Statement of Objectives, "The contractor must configure and implement the Enterprise Transactional Reporting Tool in a development environment for multiple data sources. The contractor must provide guidance and support to ESC staff to enable them to configure and implement the solution in a test environment." |
| Can you clarify your expectation between the duration of engagement (9 months with 6 month optional extension) as it relates to the deliverables (discovery, future state assessment, design, platform evaluation, procurement, installation, oversight) as it pertains to this RFP? | 9 months for Implementation Services and Knowledge Transfer & Training Services. 6 month extension for Consulting Services Only. |
| Is the bidder expected to own the licensing for the new transactional reporting tool, or are they expected to assist with the selection and negotiation process? | Expected to own the licensing for the new transactional reporting tool |
| Can you elaborate on the estimated duration of 20 days for Task 1? | Per page 2 of SIR, Task 1 has delivery 05/31/21. |
| Is the expectation to migrate the 250 reports to the new platform with the current format, or is there a desire to leverage modern visualization techniques to maximize usability and reduce the number of reports needed? | Per section 4.2 Task 6 of Attachment 01 Statement of Objectives, the expectation is "Migration of up to 250 existing ESC Discoverer Reports" |
| Is the plan to migrate all existing 45,000 workbooks, or will a rationalization / streamlining effort be used to find the optimal subset or workbooks to migrate? | ESC is performing analysis of existing ESC Discoverer Workbooks to limit overall scope of migration |
| What internal FAA resources, and what proportion of their time, will be dedicated to support this engagement? | ESC has multiple reporting teams available to support this effort. |
| Can you confirm that contractor is permitted to propose personnel in addition to the 3 roles noted (Project Manager, Reporting Tool Expert(s), Discoverer Migration Expert(s))? | The contractor may propose additional personnel. However, the labor hour CLINs will not change. |
| Regarding the procurement cost of the reporting tool, how many users would need to access this tool? How many existing Discoverer reports FAA has? | Per section 2 Objective of Attachment 01 Statement of Objectives, "It currently contains approximately 55 subject areas, 2,000 folders and 45,000 workbooks. ESC’s Discoverer supports approximately 2,000 active reporting users, of which, roughly half construct their workbooks. |
| For EBS 12.2, do you have the HR module installed? | Shared Install |
| What is the formula or criteria to come up with the travel cost as we rarely see the travel cost ceiling with decimal points? | Number of trips times number of resources times Per Diem |
| Would the FAA allow contractors to work and deliver the final reporting tool remotely? | No. Per section 4.2 of Attachment 01 Statement of Objectives, Task 3 must be performed on-site. All other tasks, telework capability may be authorized but must be approved by the COR, and CO. |
File details come from the government source that posted it. Updated .