CEFMS II Preproposal Conference 11222022.pptx

US ARMY CORPS OF ENGINEERS

FINANCIAL MANAGEMENT SYSTEM

(CEFMS) II

Pre-Proposal Conference

USACE FINANCE CENTER (UFC)

5722 Integrity Drive, Building 787 Millington, TN 38054

November 28th, 2022

10:00 AM – 12:00 PM CST

AGENDA

10:50 – 1:25 pm Overview of CEFMS II Requirement & Mission Cynthia Blevins, UFC Director

1:30 – 2:30 pm Submission of Written Questions & Industry Networking

ACQUISITION OVERVIEW

CEFMS II REQUIREMENT

Pre-Proposal Conference 28 November 2022

Presented by:

SALLY M. WILLIAMS

Contracting Officer, HECSA

CEFMS II REQUIREMENT

NAICS code 541511 Custom Computer Programming Services

Size Standard $30,000,000.00

These services are primarily comprised of the maintenance and modernization of a custom Government owned software application.

PSC Code DA01 - IT and Telecom - Business Application / Application Development Support Services

CONTRACTOR QUALIFICATIONS

Knowledgeable of DoD and Civil Works financial management laws, regulations, policies, and generally accepted accounting standards.

Familiar with pertinent Office of Management and Budget (OMB) policies and federal financial management systems requirements.

Knowledgeable of US Treasury USSGL pro-forma logic for federal accounting transactions and rules for both proprietary and budgetary general ledgers.

Knowledgeable of DoD Standard Financial Information Structure(SFIS) data elements and the interworking related to accounting events.

Expert knowledge/understanding of Oracle products and the ability to draw upon additional resources and maintain a “reach-back” knowledge base capability that can be utilized as needed.

Expert knowledge of DoD End-to End (E2E) Integration framework and business processes including, but not limited to, procure-to-pay, acquire-to-retire, order-to- cash, budget-to-report, plant-to-stock, environmental liability, service-to satisfaction, proposal to reward, and cost management.

CLAUSES

The Final Solicitation was issued under the Standard Form 33 (SF33) – Solicitation, Offer and Award format

Noncommercial contract clauses

Contract Data Requirements List per each Task Order

No Wage Determination – contract is for professional services

U.S. Army Corps of Engineers Finance Center – https://ce-ais.usace.army.mil/cefms

FAR 52.204-23/25: Make sure your SAM banned telecommunications equipment representations are correct; make sure all your SAM reps and certs are up to date.

Data Rights: CEFMS II is a Government Off The Shelf product. Data rights belong to the Government.

CLAUSES (Cont.)

CLAUSES (Cont.)

Small Business Provisions and Clauses

The Government incorporated FAR flow down clauses applicable to a Small Business Set‐Aside

The Government is not requiring nor and evaluating a Small Business Participation Plan

CURRENT CONTRACT SUPPORT

In 2018 an IDIQ contract under Contract Number W912HQ-18-D-0007 with a Period of Performance of 31 October 2018 – 30 October 2022 and a six-month extension until 30 April 2023, was awarded to Gradkell Systems, Inc. with a maximum capacity of $75,000,000.00. This contract’s capacity was later increased to $110,100,000.00. There are no union contract-based agreements applicable to this contract; and there are no unions.

CURRENT REQUIREMENT

Competitive Noncommercial Requirement 100% Small Business Set-Aside $150M Estimated Maximum Ceiling Performance Work Statement (PWS) Firm-Fixed Price (FFP) Formal Source Selection procedures One (1) Base Year; Four (4) One-Year Options (1 May 23 through 30 Apr 28) and one six-month option to extend IAW FAR 52.217-8 Six (6) months Phase-In/Phase-Out Plan may be required

CURRENT REQUIREMENT

Contract Data Requirement Lists (CDRLs) for all Reports/Documents to be included RFP was posted to Contract Opportunities on SAM.gov on 14 November 2022; Proposal response due 16 December 2022 at 430PM EST The CEFMS II Software Management and Development (page 24) will require 20% of staff located in Millington, TN Conduct Post-Award Conference – TBD if virtual or in-person

SUBMISSION REQUIREMENTS

Section L describes the submission requirements: multiple Factors separated into volumes.

Volume 1 – Technical (150 pages) Factor 1 Response to First Task Order Project Technical Approach (See TO PWS – Attachment 4)

- Factor 3 Experience

- Factor 4 Management Approach and Transition Plan

Volume 2 – Factor 2 Past Performance (35 pages) (USACE PPQ on Attachment 3)

Volume 3 – Factor 5 Price (Attachment 5)

Volume 4 – Administrative (no limit)

EVALUATION FACTORS

FACTOR 1 – RESPONSE TO FIRST TASK ORDER PROJECT TECHNICAL APPROACH:

Offerors shall submit a technical and price proposal response to the first Task Order that includes the Offeror’s proposed level of effort using the provided format in Attachment 5, and Offeror’s technical approach to performing the requirement as described in the Task Order PWS (Attachment 4)

Demonstrate how you will perform the required services

Part of Volume I – Technical

EVALUATION FACTORS

FACTOR 2 – PAST PERFORMANCE

Factor 2 goes in volume 2. Past performance has a separate evaluation team from the other technical factors.

Recent + Relevant + Quality = Confidence ratings A Past Performance Questionnaire (PPQ) was included in the RFP Major subcontractors (more than 15% of work) are part of evaluation

EVALUATION FACTORS

FACTOR 3 – EXPERIENCE

Offerors shall propose the Key Personnel identified by the Government for this requirement and submit resumes demonstrating the appropriate education and experience. Resumes should include proposed job title, education, certifications held, special qualifications, and experience (listing the job title, specific duties, responsibilities, and the respective dates)

The RFP is the minimum. More is better so long as it is relevant.

Submit with Volume 1 – Technical

EVALUATION FACTORS

FACTOR 4 – MANAGEMENT APPROACH AND TRANSITION PLAN

Approach to satisfy the support needs of the CEFMS II program as outlined in the SATOC PWS How can your team support multiple requirements simultaneously?

Risk management Uninterrupted service during transition

Submit with Volume 1 – Technical

EVALUATION FACTORS

FACTOR 5 – PRICE

Propose labor rates for each labor category listed above in Section B. See PWS – Attachment 1 [SATOC] and Attachment 4 [TO#1]

Labor rates must reflect differences in skills, complexity of various disciplines, and professional job difficulty.

Labor rates proposed for SATOC and for first Task Order. Task Order rates cannot exceed SATOC rates.

OFFICE OF SMALL BUSINESS PROGRAMS

CEFMS II REQUIREMENT

PRE-PROPOSAL CONFERENCE

NOVEMBER 28, 2022

Presented by:

Beth White Interim HECSA Small Business Program Manager

SMALL BUSINESS

Preliminary Market Research Analysis Small business set-aside Leveraging Past Performance Past performance of subcontractors will be considered Signed documentation by both offeror and subcontractor for cooperative efforts must be provided to have past performance considered

Joint ventures can leverage the past performance of both companies JVs resulting from a SBA Mentor Protégé Program should provide documentation indicating acceptance into the program.

Limitations on Subcontracting 52.219-14 Services: The Government will not pay more than 50 percent of the amount for contract performance to subcontractors that are not similarly situated entities as the prime contractor. Any work that a similarly situated entity further subcontracts will count towards the prime contractor's 50 percent subcontract amount that cannot be exceeded. When a contract includes both services and supplies, the 50 percent limitation shall apply only to the service portion of the contract

SMALL BUSINESS

Resources:

Proposal Review Assistance and Potential Partner Identification PTAC/PTAP (Procurement Technical Assistance Centers/Programs) Help for Government Contracting - APTAC - Association of Procurement Technical Assistance Centers (aptac-us.org) Finding subs/teaming partners SBA’s SUBNET DSBS (Dynamic Small Business Search) Networking within Pre-Proposal Attendees Solicitation Interested Vendors (SAM.gov) HQ, OSBP Website (Enterprise Contractor Database) https://www.usace.army.mil/Business-With-Us/Small-Business/USACE-Contractor-Database/

SMALL BUSINESS

SUBNET

SMALL BUSINESS

Small Business Participation will not be evaluated given that the RFP is a total small business set-aside

Historical LOE was approximately 70-75 FTE O&M historically has been approximately 50 FTEs Modernization has been approximately 25 FTEs Some FTEs work both O&M and modernization.

Number of FTEs can change based on current requirements

OVERVIEW OF CEFMS II REQUIREMENT AND MISSION

Pre-Proposal Conference 28 November 2022 Presented by:

Cynthia Blevins, UFC Director Teresa Brown, Functional Project Manager Terry Burgin, IT Project Manager

CEFMS II SYSTEM DESCRIPTION

The Corps of Engineers Financial Management System (CEFMS) is the USACE enterprise financial management system for managing and transacting financial and accounting business processes CEFMS II integrates USACE project management functions with accounting requirements prescribed under U.S. Treasury Standard General Ledger (USSGL) policies CEFMS II enables full transparency of funds execution within the USACE for all fund types and projects encompassing the USACE mission CEFMS II provides integrated, end-to-end electronic financial business processes supporting military, civil works, support for others, and environmental programs for its 35,000 users

CEFMS II SERVICES ARE CURRENTLY UTILIZED AT ALL USACE LOCATIONS IN

THE UNITED STATES AND WORLDWIDE

CEFMS II

Lifecycle Status: Sustainment/Modernization Stakeholders & Customers: Military, civil works, and environmental programs, all USACE employees, DA, DoD, OMB, Treasury, EPA, FEMA and a multitude of other federal agencies, states, local Governments and contractors.

System requirements are determined based on requirements of laws, regulations, USACE policy and input from stakeholders

CEFMS II

Government off-the-shelf (GOTS) software Web-based ORACLE Relational Database Single Source Entry & Data perpetuation CAC Enabled – PKI Digital Signature Auditable consecutive “unmodified” opinions since 2009 Source Documentation, Compliance Edits Universe of Transactions Integrated Roles & Permissions – Enforces access and internal control Standard Financial Information Structure (SFIS)/Standard Line of Accounting (SLOA) Compliant

SYSTEM ARCHITECTURE

CORE FINANCIAL REQUIREMENTS

CURRENT SYSTEM ARCHITECTURE

Operating System Red Hat Linux Oracle Database Multitenant for Oracle Databases Real Application Cluster Partitioning Oracle Advance Security Oracle Database in Memory Oracle Golden Gate Oracle Data Integrator Directory Service WebLogic Server Enterprise Data Quality Profile and Audit Enterprise Data Quality Standardization and Match Oracle Analytics Server

PVCS

DBSIGN

Hyperion

SQR

Oracle Forms Oracle Reports Oracle Access Manger Oracle HTTP Server Oracle APEX Oracle Real Applications Testing CPC/WPC/CHCI Cloud Environments 28 Interfaces with both Internal & External System

TECHNICAL REQUIREMENTS

CEFMS II Application Maintenance, Development and Support Financial System Application Development, Operations and Maintenance Oracle Database and Application Design and Administration UNIX and Systems Administration Electronic signature software– CAC/PKI Interface Support Configuration Management Cybersecurity CEFMS II Documentation Oracle Analytics Server New Application Modernization Conversion Support Mobile applications

Note: The CEFMS II source code, technical data, and user manuals are copyrighted materials owned by the Government.

SCOPE OF WORK

Over 70 areas of functionality 62 field operating activity (FOA) production databases Corporate Reporting Database Data Manager Database 15 development/testing databases Each database has approximately 1350 tables and 200 views each.

Approximately 2500 data entry, help, view, and report selection screens (Oracle Forms).

300+ database views 800+ SQR reporting programs 400+ Oracle Report programs 10,000+ database procedures/functions

Maintain CEFMS II system operations Resolve system issues Modifications to maintain compliance with laws, regulations, policies and generally accepted accounting principles.

System design, development, and management technical services Modernize CEFMS II application to migrate from Oracle Forms to Oracle APEX.

Modernize CEFMS II infrastructure and migration to Cloud Environments.

Maintain Repository, Metadata and Reports

CEFMS II INTERFACE/DATAFLOW

CURRENT PERSONNEL INVOLVED

Corps Government Functional Contractor Analysts and Developers Data Base Administrators (DBAs) System Administrators Configuration Managers Government Site POC End Users

CORPS FUNCTIONAL RESPONSIBILITIES

Research and analyze public laws, and regulatory or policy guidance from governing agencies to determine proper application of business rules and resulting system requirements.

Office of Management and Budget(OMB) Department of Defense (DoD) – DoD Financial Management Regulation (FMR) Department of Army General Accounting Office Financial Management Service (FMS), Department of Treasury Corps of Engineers Regulations (ER) All HQUSACE policy guidance.

CORPS FUNCTIONAL RESPONSIBILITIES

Chief Financial Officer’s (CFO) Act Federal Financial Management Improvement (FFMIA) Digital Accountability and Transparency Act (DATA) Federal Information Security Management Act (FISMA) Federal Managers Financial Integrity Act (FMFIA) Water Infrastructure Finance and Innovation Act (WIFIA) Prompt Payment Act Joint Travel Regulations (JTR) Defense Financial Management Regulation (DoD FMR) Engineer Financial Regulation

(ER 37-1-30)

US Department of the Treasury Financial Manual

OMB Circulars OMB Circular A-134 Financial Accounting Principles and Standards OMB Circular A-123, Management’s Responsibilities for Internal OMB Circular A-11, Preparation, Submission and Execution of the budget OMB Circular A-129, Policies for Federal Credit Programs Ensure Financial System meets Federal Laws, Regulations and Policies:

CORPS FUNCTIONAL RESPONSIBILITIES

Work with interfacing applications to define, implement and maintain data sharing requirements Real Estate Information Management System (REMIS), Project Management System (P2) Integrated Army Travel System (IATS) Defense Civilian Pay System(DCPS) Resident Management System (RMS) Treasury offset program(TOPS) Intra-governmental Payment and Collections System(IPAC) G-Invoicing Support annual Financial and IT audit activities, including data populations, analyzing and addressing findings.

CORPS FUNCTIONAL RESPONSIBILITIES

Address system issues as identified in the Problem Reporting System Provide requirements and work with Developers in resolving Problem Reports (PRs) Server as Product Owners using Agile Methodologies to modernize CEFMS II legacy forms to APEX application.

Establish test data to reproduce error conditions at reported sites.

Test PR changes to ensure issue is resolved with no adverse effects of change Test CEFMS II Applications/Screens for upgrades to Software or Operating Systems (Oracle D/B, Oracle Forms, Solaris, etc.)

CORPS FUNCTIONAL RESPONSIBILITIES

Approve release of PRs to production Develop and maintain system documentation Train USACE team members Participate in review groups and committees as assigned Continually strive to automate and improve functions using the latest technology

CONTRACTOR ANALYSTS AND DEVELOPERS

Work with USACE in analyzing system requirements Finalize system change requirements, error correction strategies and design changes Diagnose database errors Modify code to satisfy requirements, correct errors Create data correction scripts Perform change testing prior to Corps Functional testing Monitor routine system processes: reconciliation, G/L posting, report stacks and CRON execution Participate in committees and review groups as assigned

CONTRACTOR DBA

Monitor development database health Diagnose, correct database problems Assist in identifying, correcting program execution errors, performance problems Assist ACE-IT in production database support Maintain Oracle software, including IAVA compliance Manage CRON execution for all production sites Perform data correction script execution Monitor security posture of production databases Build and support prior year databases for both testing and production phases Coordinate and Prepare CEFMS II Training databases Support interface connectivity to external systems Plan for Oracle product migration to maintain supported platforms

CONTRACTOR SYSTEM ADMINISTRATORS

Monitor and maintain development servers

Diagnose and correct server problems

Assist in identifying, correcting program execution errors and performance problems

Develop and administer server backup plan

Assist ACE-IT in production server support

Plan for server product migration to maintain supported platforms

CONTRACTOR CONFIGURATION MANAGERS

Build and maintain Configuration Management software and utilities Manage source code archives Assist developers in resolving source code configuration issues Apply approved changes to development databases Release approved changes to production

GOVERNMENT SITE POCS

Assist End Users in initial problem diagnosis and resolution if possible Submit Customer Inquiries (CIs) in the PR System Submit error documentation for CIs Receive notification of production releases and disseminate to users

CHANGE MANAGEMENT

Who initiates system changes?

Site POC – system problems or requested enhancements Corps Functional – system changes identified based on Headquarters policy changes, Army, OSD, OMB and Treasury directives

How are they recorded?

Documented in Problem Report System

How are they assigned?

Local CCB reviews the descriptions an determines assignment Each Functional in Systems is assigned areas of expertise.

Functional reviews and assigns category.

Functional assigns a required date based on mission requirements.

Functional schedules meetings as needed to discuss requirements with developers.

CHANGE MANAGEMENT

How are changes completed? Tested? Approved?

Developers complete coding Developers perform initial testing Functional tests for errors and correct updates Functional approves for release if requirements are satisfied.

How are they released to production?

Release biweekly on Tuesday/Thursday Corporate Reporting Module on Wednesday Time & Attendance on Wednesday Emergency Releases

CHANGE MANAGEMENT TERMS

CI - Customer Inquiry PR – Problem Report CCB – Configuration Control Board ECP – Engineering Change Proposal DBC – Database Change DBCRB – Database Change Review Board

INFORMATION ASSURANCE PROGRAM

Annual activities Security Review Security Test and Evaluation COOP Testing Risk Management Framework (RMF) Process IT Audit support IA training requirements

KEY PERSONNEL

Project Manager Senior Oracle DBA System Engineer/Architect Senior Forms Developer Senior APEX Developer Senior Technical Writer

CEFMS II MODERNIZATION

Objectives:

To take advantage of improvements in hardware and networking.

To utilize virtual and cloud computing and big data processing tools(OBIEE) To allow application to be accessed and updated remotely via mobile devices The ability to access and share data across multiple devices and platforms To make the system more intuitive to users with more web-based features.

To improve performance of system To improve security Cloud Migration Configuration that supports Cloud computing CHCI Cloud Environments Improved failover and disaster recovery Implement Oracle Products to Improve CEFMS II performance Oracle Multitenant, DataGuard, GoldenGate, Real Application Clusters

CEFMS II MODERNIZATION

Oracle Access Manager – Single Sign On Oracle Advanced Compression Improves performance and reduces storage costs.

Oracle Advanced Security Encrypts data at rest Redacts data to prevent exposure in applications Migration of Forms to Java HTML user interface Mobile Applications

CEFMS II REPORT CONVERSION

Transition to more Modern Reporting Tools Migrating SQR and Oracle Reports to BI and Repository Oracle Analytics Server Oracle Business Intelligence Publisher (BI)

QUESTIONS

image5.png image6.png image7.png image12.png image13.png image4.png image1.png image2.png image14.png image15.png image16.png image17.png image18.png image19.png image8.png image9.png image10.png image11.tiff