N64267-16-T-0135_OBI_Solicitation_-1449.docx

Section B - Supplies or Services and Prices

ITEM NO SUPPLIES/SERVICES QUANTITY UNIT UNIT PRICE AMOUNT 0001

OBI Class 1 FFP FOB: Destination

NET AMT

ITEM NO SUPPLIES/SERVICES QUANTITY UNIT UNIT PRICE AMOUNT 0002

OBI Class 2 FFP

ITEM NO SUPPLIES/SERVICES QUANTITY UNIT UNIT PRICE AMOUNT 0003

OBI Class 3 FFP

N64267-16-T-0135 Page of

N64267-16-T-0135 Page of

Section C - Descriptions and Specifications

GENERAL

This is a Request for Quotation (RFQ) for a commercial item(s) prepared in accordance with the information in FAR Part 12.

SALES TAX EXEMPTION

The Contractor is hereby advised that the United States Government and Agencies thereof are exempt from State and Local Government tax by virtue of Article 6 of the United States Constitution. No exemption certificate is required.

GENERAL

1.0 INTRODUCTION

The Naval Surface Warfare Center (NSWC), Corona Division, Readiness Assessment Department, Code AR10 requires Oracle Business Intelligence Enterprise Edition 11.1.1.9 (OBIEE) training for Engineering Analysts. This course must be off-site, hands-on, instructor-led private training for groups of 20 or less. Course must include printed training material and web-based hands-on use of OBIEE with real-world examples. Training facilities, training equipment, and computers for use during the course must be provided by the source; training must be provided within 15 miles of Norco, CA area. The OBIEE instance used for training must be hosted by the source.

Course must cover the key elements of the OBIEE suite, including how to create tables, charts, narratives, pivot tables, and many other content objects available in OBIEE Answers; how to create and use OBIEE Dashboards to display those objects effectively; tools to build interactive dashboards; perform ad hoc analysis; configure information deliveries and alerts; and produce BI Publisher online reporting.

2.0 BACKGROUND

NSWC Corona has recently deployed OBIEE 11.1.1.9 to support Engineering Analysts. OBIEE will be used for ad-hoc analysis, custom dashboards for customers, and producing automated reports in RTF format. This training is required for the Engineering Analysts to become proficient in BI Answers, BI Publisher, and alerts.

3.0 REQUIREMENT

5-day course to cover the following topics: Oracle BI Answers Topics (3-days) :

-Oracle BI Answers Basics -Filters -Drilling and Navigation -Pivot Tables -Graphs -Compound Layouts -Additional Views -Advanced Topics and Techniques -New Features for Existing Functions -Master-Detail Linking -Hierarchies -Selection Steps -Dashboard Prompts -Dashboard Layout

-Populating Dashboard Contents -Saved Customizations -Creating and Configuring Agents -Appendix A: Graph Types Available in Oracle BI Answers -Appendix B: Variables -Appendix C: Dashboard Best Practices

Oracle BI Publisher Topics (2-days) -Introduction to BI Publisher -Creating BI Publisher Data Models -Creating a Data Model from an OBIEE Subject Area -Copying and Modifying a Data Model

-Creating a BI Publisher Reports and Layouts -Creating a Report and a Basic Data Layout -Exploring Report Properties

-Developing Custom Layouts with Form Fields -Creating a Table Manually -Adding Dimensional Columns -Creating a Nested Table with Subtotals -Formatting the Custom Table

-Custom Calculations -Row-level calculations -Group-level calculations -Report-level calculations

-Report Formatting -Applying Simple Conditional Formatting -Creating a Template Store (aka Subtemplate) -Applying Advanced Conditional Formatting -Applying Page Breaks and Page Numbers

-Running Totals and Context Specific Content -Crosstabs (Pivot Tables) -Creating Crosstabs -Imbedding a Pivot Table within a Repeating Group

-Charts

-Creating Vertical Bar Charts -Creating Pie Charts

-Parameters and Lists of Values -Creating Selection Lists -Creating Report Parameters -Filtering with Parameters -Creating Cascading Parameters

-Using BI Publisher Reports in Dashboards -Creating a New Dashboard Page

-BI Publisher Analysis Tools -Online Analyzer

-Advanced Exercises -Asymmetric Reporting -Using Hyperlinks to Drill and Navigate -Dynamic Data Columns

BI Answers Objectives:

-Learn to create BI Answers queries -Learn to create multiple query Views -Learn to create BI Interactive Dashboards -Learn to configure, schedule, and deliver Alerts

BI Publisher Objectives:

-Create an Oracle BI Publisher data model using a variety of data sources -Create RTF templates from scratch without the use of the BI Publisher wizards -Extend the simple templates by adding custom calculations and conditional formatting -Create and use charts and pivot tables -Enhance basic data models with parameters and selection lists -Enhance templates with advanced layout options -Distribute reports to multiple recipients through multiple delivery channels -Use BI Publisher reports in BI Dashboards -Use the built-in BI Publisher analysis tools

Offer must also provide:

1. Training facilities for 20 students

2. Printed training material

3. OBIEE 11.1.1.9 instance to support the hands-on training

4. Individual computers for each student to access the OBIEE instance

4.0 REQUIRED DELIVERY DATE:

Class 1: to be scheduled 3 weeks after award Class 2 and Class 3: to take place prior to 30 September 2017 with 3 weeks lead time

5.0 TRAINING LOCATION:

Within 10-miles of NSWC Corona, 1999 Fourth Street, Norco, CA 92860

Section E - Inspection and Acceptance

INSPECTION AND ACCEPTANCE TERMS

Supplies/services will be inspected/accepted at:

Section F - Deliveries or Performance

DELIVERY INFORMATION

CLIN DELIVERY DATE QUANTITY SHIP TO ADDRESS DODAAC

Destination

Destination

Destination

Section G - Contract Administration Data CLAUSES INCORPORATED BY FULL TEXT

252.232-7006 WIDE AREA WORKFLOW PAYMENT INSTRUCTIONS (MAY 2013)

(a) Definitions. As used in this clause--

Department of Defense Activity Address Code (DoDAAC) is a six position code that uniquely identifies a unit, activity, or organization.

Document type means the type of payment request or receiving report available for creation in Wide Area WorkFlow (WAWF).

Local processing office (LPO) is the office responsible for payment certification when payment certification is done external to the entitlement system.

(b) Electronic invoicing. The WAWF system is the method to electronically process vendor payment requests and receiving reports, as authorized by DFARS 252.232-7003, Electronic Submission of Payment Requests and Receiving Reports.

(c) WAWF access. To access WAWF, the Contractor shall--

(1) Have a designated electronic business point of contact in the System for Award Management at https://www.acquisition.gov; and

(2) Be registered to use WAWF at https://wawf.eb.mil/ following the step-by-step procedures for self-registration available at this Web site.

(d) WAWF training. The Contractor should follow the training instructions of the WAWF Web-Based Training Course and use the Practice Training Site before submitting payment requests through WAWF. Both can be accessed by selecting the “Web Based Training” link on the WAWF home page at https://wawf.eb.mil/.

(e) WAWF methods of document submission. Document submissions may be via Web entry, Electronic Data Interchange, or File Transfer Protocol.

(f) WAWF payment instructions. The Contractor must use the following information when submitting payment requests and receiving reports in WAWF for this contract/order:

(1) Document type. The Contractor shall use the following document type(s).

Invoice and Receiving Report (Combo), this is an invoice and receiving report (DD250) created at the same time.

(2) Inspection/acceptance location. The Contractor shall select the following inspection/acceptance location(s) in WAWF, as specified by the contracting officer.

Inspection Location: Destination Acceptance Location: Destination

(3) Document routing. The Contractor shall use the information in the Routing Data Table below only to fill in applicable fields in WAWF when creating payment requests and receiving reports in the system.

Routing Data Table* Field Name in WAWF Data to be entered in WAWF

(4) Payment request and supporting documentation. The Contractor shall ensure a payment request includes appropriate contract line item and subline item descriptions of the work performed or supplies delivered, unit price/cost per unit, fee (if applicable), and all relevant back-up documentation, as defined in DFARS Appendix F, (e.g. timesheets) in support of each payment request.

(5) WAWF email notifications. The Contractor shall enter the email address identified below in the “Send Additional Email Notifications” field of WAWF once a document is submitted in the system. CRNA_WAWF_COMPTROL@navy.mil, CRNA_FISC_MAILBOX@navy.mil, starr.whalen@navy.mil

(g) WAWF point of contact. (1) The Contractor may obtain clarification regarding invoicing in WAWF from the following contracting activity's WAWF point of contact.

(1) For technical WAWF help, contact the WAWF helpdesk at 866-618-5988 or WAWFHQ@navy.mil.

(2) Scott Wobken, (951) 393-5131, scott.wobken@navy.mil

(3) For vendor pay issues contact Dolores Gonzalez (951) 393-4459, dolores.gonzalez@navy.mil. (End of clause)

HQ G-2-0004 PURCHASING OFFICE REPRESENTATIVE

COMMANDER

Naval Surface Warfare Center, Corona Division P.O. Box 5000 N64267-16-T-0135 Page of

N64267-16-T-0135 Page of

Corona, CA 92878-5000 Telephone: 951.393.5638 Fax: 951.393.4013 Email: starr.whalen@navy.mil

Naval Surface Warfare Center, Corona Division P.O. Box 5000 Corona, CA 92878-5000 Telephone: 951.393.4496 Fax: 951.393.4013 Email: marlena.warren@navy.mil

PRODUCT DATA REPORTING AND EVALUATION PROGRAM (PEDREP) DEPARTMENT COORDINATOR

REPRESENTATIVE: ATTN: PEDREP POC

NAVAL SURFACE WARFARE CENTER

P.O. Box 5000 Corona, CA 92878-5000 Telephone: 951.393.XXXX Email: FIRST.LAST@navy.mil

(End of Text)

Note: Subject Matter Expert shall be used in lieu of contracting officers’ representative (COR).

HQ G-2-0009 SUPPLEMENTAL INSTRUCTIONS REGARDING INVOICING (NAVSEA) (APR 2015)

(a) For other than firm fixed priced contract line item numbers (CLINs), the Contractor agrees to segregate costs incurred under this contract/task order (TO), as applicable, at the lowest level of performance, either at the technical instruction (TI), sub line item number (SLIN), or contract line item number (CLIN) level, rather than on a total contract/TO basis, and to submit invoices reflecting costs incurred at that level. Supporting documentation in Wide Area Workflow (WAWF) for invoices shall include summaries of work charged during the period covered as well as overall cumulative summaries by individual labor categories, rates, and hours (both straight time and overtime) invoiced; as well as, a cost breakdown of other direct costs (ODCs), materials, and travel, by TI, SLIN, or CLIN level. For other than firm fixed price subcontractors, subcontractors are also required to provide labor categories, rates, and hours (both straight time and overtime) invoiced; as well as, a cost breakdown of ODCs, materials, and travel invoiced. Supporting documentation may be encrypted before submission to the prime contractor for WAWF invoice submittal. Subcontractors may email encryption code information directly to the Contracting Officer (CO) and Contracting Officer Representative (COR). Should the subcontractor lack encryption capability, the subcontractor may also email detailed supporting cost information directly to the CO and COR; or other method as agreed to by the CO.

(b) Contractors submitting payment requests and receiving reports to WAWF using either Electronic Data Interchange (EDI) or Secure File Transfer Protocol (SFTP) shall separately send an email notification to the COR and CO on the same date they submit the invoice in WAWF. No payments shall be due if the contractor does not provide the COR and CO email notification as required herein.

(End of Text)

Section I - Contract Clauses

CLAUSES INCORPORATED BY REFERENCE

N64267-16-T-0135 Page of

N64267-16-T-0135 Page of

DEC 2014

NOV 2015

FEB 2016

52.222-50 Combating Trafficking in Persons MAR 2015

52.223-18 Encouraging Contractor Policies To Ban Text Messaging While Driving

AUG 2011

52.232-39 Unenforceability of Unauthorized Obligations JUN 2013

52.232-40 Providing Accelerated Payments to Small Business Subcontractors

DEC 2013

52.233-3 Protest After Award AUG 1996 52.233-4 Applicable Law for Breach of Contract Claim OCT 2004

252.203-7000 Requirements Relating to Compensation of Former DoD Officials

SEP 2011

252.203-7002 Requirement to Inform Employees of Whistleblower Rights SEP 2013 252.204-7003 Control Of Government Personnel Work Product APR 1992 252.204-7008 Compliance With Safeguarding Covered Defense Information DEC 2015 Controls

DEC 2015

DEC 2015

Section L - Instructions, Conditions and Notices to Bidders

INSTRUCTION TO OFFERORS

Quotes must be valid for thirty (30) days after due date. Any amendment(s) issued to this RFQ will be published on this website. Therefore, it is the offerors responsibility to visit this website frequently for updates on this procurement.

CLAUSES INCORPORATED BY REFERENCE

52.212-1 Instructions to Offerors--Commercial Items OCT 2015

Section M - Evaluation Factors for Award CLAUSES INCORPORATED BY FULL TEXT

52.212-2 EVALUATION--COMMERCIAL ITEMS (OCT 2014)

(a) The Government will award a contract resulting from this solicitation to the responsible offeror whose offer conforming to the solicitation will be most advantageous to the Government, price and other factors considered. The following factors shall be used to evaluate offers:

(i) Technical capability of the item offered to meet the Government requirement

(ii) Past performance

(iii) Price

(iv) Lead time

Technical and past performance, when combined, are approximately equal to cost or price. (End of provision)

HQ M-2-0001 BASIS OF AWARD (NAVSEA) (SEP 1990)

ALL UNITS OF ALL ITEMS WILL BE AWARDED TO ONE OFFEROR. OFFERS, THEREFORE, MUST BE ON THE BASIS OF FURNISHING ALL UNITS OF ALL ITEMS.

(End of Provision)