030ADV24R0045 - Att. J-14 - TO 5 SOW - Reporting Support - UPDATED.docx

LCRS Reporting Support B.1 Order Type – This is an FFP order.

B.2 Order Period of Performance – base of six months and one, 12-month option C.1. Project Title LBFMS Support IDIQ - LCRS Reporting Support

C.2. Background The Library of Congress Financial Services Directorate (FSD) provides policy direction, review, and coordination of all budgetary and financial activities of the Library. Responsibilities include formulation, presentation, and execution of the Library’s budget; establishment of all budgetary and accounting standards; establishment and monitoring of financial systems controlling the expenditure and reporting of funds; management of the Library’s travel program, and the purchase card and travel card programs; disbursement, collection, and investment of funds; accounts payable; and financial reporting.

The Library of Congress Reporting System (LCRS) is a system that provides management level financial reports that supports execution and monitoring of the agency’s budget. The system is cross-serviced and currently used by the Library, Congressional Budget Office (CBO), Congressional Office of International Leadership (COIL), Medicare Payment Advisory Commission (MedPAC), and the Office of Congressional Workplace Rights (OCWR). The system utilizes SAP Business Objects version 4.3, Wiiisdom Ops for SAP Business Objects, an Oracle data warehouse for reporting, and an Extract, Transform, and Load (ETL) job to extract data from the Library’s financial system on a nightly basis into the Oracle reporting data warehouse. Business Objects and Wiiisdom are currently hosted in the Library’s data center and has Production, Staging, and Test environments. The Oracle data warehouse is currently hosted in the Microsoft Azure cloud and is supported by CGI Federal. The ETL jobs are currently maintained by FSD staff.

C.3. Scope Under this task order, the Contractor will provide technical support to FSD in support of their financial systems and processes. Work will include system administration support; bug fixes; system updates and patches; and support for integrations between systems. Specific systems in scope include:

· The Library of Congress Reporting System (LCRS) and Hosting Environment

· SAP Business Objects Version 4.3

· Wiiisdom Ops for SAP Business Objects

The Oracle data warehouse and the ETL job are not in scope for this task.

The scope of this task order falls under the following performance area of the Legislative Branch-Wide LBFMS Support IDIQ contract:

PERFORMANCE AREA NINE – Services to Support the LCRS C.4. Requirements The contractor will work with FSD and the Library’s Office of the Chief Information Office (OCIO) to plan and execute tasks in support of FSD’s systems with the OCIO’s primary Business Objects system administrator. Contractor staff will have access to FSD and OCIO Subject Matter Experts and will meet bi-weekly with a project lead to plan and track work. The project will use the Library’s development and project management support tools, including Confluence, JIRA, and GIT. The Library’s JIRA ticketing system will be used to assign support tickets from the government to the contractor for support as it is needed.

Specifically, the contractor will:

1. Administer the Library of Congress Reporting System (LCRS), Wiiisdom Ops, and hosting environment, including user management – to add, update, and delete users based on the exiting procedures – and serve as a backup for the Library’s primary system administrator to maintain and assign access based on user roles.

2. Provide SAP Business Objects (BOBJ) system administration and support, including

· BOBJ software (including patches) installation;

· Manage user accounts (creation, update, and deletion), provide BOBJ end user support when necessary (backup role), maintain and assign access based on user roles;

· Perform BOBJ upgrades as needed and ensure all related applications and services are also updated in the LCRS and hosting environment;

· Manage application configuration changes, ensure all configurations meet agency directives, modify system settings to facilitate new application functions;

· Implement and configure Active Directory for BOBJ after upgrades, including supporting single sign on to the application;

· Modify and support Tomcat configuration for application servers;

· Modify application environment to support OS upgrade;

· Support Splunk connectivity with the BOBJ environments for log tracking;

· Work with SAP support team to solve any technical issues of BOBJ implementation;

· Optimize BOBJ performance in L hosting environment;

· Support the Web Intelligence (WebI) tool in Business Objects, including creation and updates to universes as requested;

· Support LCRS report design or redesign, reporting performance optimization, and use of the latest reporting tools; and

· Trouble-shoot BOBJ technical issues in all the environments (Test, Staging, and Production).

3. Provide Wiiisdom Ops for SAP BusinessObjects (formerly 360 Suite) administration and support to install, configure, and maintain Wiiisdom Ops for SAP BusinessObjects (software that streamlinesand extends SAP Business Objects system administrator functionality). Manage application configuration changes, ensure all configurations meet agency directives. Modify system settings to facilitate new application functions as needed. Upgrade and patch the application, as necessary. Assist with report generation using 360 Eyes and 360 Cast. Assist with annual security password changes to BOBJ reports using 360 Suite.

4. Install, configure, and maintain other software for LCRS and hosting environment, including Oracle management tool (Toad), Crystal Reports, Oracle client, etc. Manage application configuration changes, ensure all configurations meet agency directives. Modify system settings to facilitate new application functions as needed.

5. Support Application and Server Security Compliance:

· Ensure all applications are compliant with all LOC Security directives

· Ensure all servers are hardened according to LOC requirements

· Ensure application and Operation system vulnerability are remediated in a timely manner

· Ensure SAP Business Objects applications are properly scanned.

6. Document system administration procedures and any problem resolutions.

C.5. Schedule of Events/Deliverables

C.6. Staffing and Key Personnel The contractor must identify an Application Engineer Level II as key personnel. This individual will be included in the key personnel clause for the task order and the contractor shall adhere to all requirements of the clause. The contractor personnel assigned to this role shall maintain the following minimum qualifications.

Application Engineer Level II

– Key

- US Citizenship

- Agile Methodology

- System Administration, including user management and system configuration

- SAP and Business Objects

- Reporting Applications, including Crystal Reports and Web Intelligence

- Windows Server environments

- Oracle Databases and supporting tools, including TOAD

- Wiiisdom 360 for SAP Business Objects

C.7. Government Furnished Property (GFP) The Government will provide access to the contractor via the Library’s VPN. The contractor shall be responsible for providing all reference tools, training tools, and additional supplies to its personnel, as required.

Contractor personnel will have access to existing system documentation and subject matter experts, as needed.

The Government will provide appropriate Contractor personnel with remote access to the development, testing and production environments in accordance with IT Security and OCIO directives and procedures.

C.8 Travel The Library will not separately reimburse contractor travel expenses incurred in performance of this contract.