IFMIS Consulting Services SOW.doc

STATEMENT OF OBJECTIVES

IFMIS Consulting Services

27 July 2009 Introduction

The purpose of this acquisition is to obtain functional and accounting consulting services for the users of the IFMIS/PARS application.

This consulting support shall include assistance in the areas of functional analysis, subject matter expertise, data analysis, data reconciliation, reporting, and other consulting support required to ensure effective use of the IFMIS application

Background

IFMIS Core is the official financial management system of record for FEMA and was awarded to Digital Systems Group, Inc. (DSG) in September 1994 as a Commercial Off-The-Shelf (COTS) software package through the GSA Schedule. The application underwent a major upgrade in 2002 and several additional enhancements since that time to maintain the JFMIP (FSIO) certification.

Definitions

The terms "IFMIS" and "application" shall include: the core IFMIS modules currently licensed to FEMA, the IFMIS run-time, the disaster screens, ICE, all tables, views, indexes, triggers, non-ORACLE files, etc. which comprise the IFMIS environment and database as well as all other software consequential to the execution of IFMIS and proprietary to DSG.

PARS is the integrated web-based Payment and Reporting System proprietary to DSG utilized to handle grantee payment requests and financial reporting.

Government Responsibilities

The Government shall:

Provide all tasking in writing Provide access to the FEMA production environment to the contractor’s staff based upon prevailing and applicable cyber security review and approval to facilitate data analysis and reconciliation efforts. This access entails both the application and the underlying database.

Contractor Tasks

The contractor shall:

Provide staffing with the appropriate skill set and level of expertise needed to perform the work required under this SOW.

Provide data analysis and data reconciliation support to the OCFO staff.

Assist in the creation of data analysis and reconciliation tools.

Support the OCFO staff in preparing functional analysis documents.

Provide guidance on compliance with Financial Systems Integration Office (FSIO) requirements.

Provide accounting consultation services to the OCFO staff.

Provide functional guidance related to user maintained system control tables. This will include Document types, Crosswalks and Transaction codes.

Provide functional support of Year-End closing activities.

This contract covers providing expertise in data analysis, reconciliation, development of requirements and overall consultation service. System Change Requests (SCR) will be drafted and submitted by the contractor to the Contracting Officer’s Technical Representative (COTR) for action. Upon government approval, the SCR will be implemented under a separate maintenance contract.

Assist in proposing and the technical write up of SCRs.

6 Deliverables

a) Data analysis results and queries used to perform analysis if applicable.

b) Data reconciliation results and queries used to perform reconciliation if applicable.

c) Written recommendations and documentation to support guidance provided to OCFO staff.

d) Structured Query Language (SQL) queries created or modified at FEMA’s request.

Reporting Requirements 7.1 The contractor shall use Microsoft Office software to develop all document and presentation deliverables. These documents shall be made available upon request.

7.2 The contractor shall keep the Contracting Officer Technical Representative (COTR) informed of its activities through the aforementioned text processing and project management reports once every two weeks. The contractor shall endeavor to provide a high-level of reliable and regular communication with the COTR.

7.3 The contractor shall provide FEMA with tailored project management controls, methodologies, and reporting based upon the DHS SELC governance and those prescribed by the Project Management Institute (PMI) Project Management Body of Knowledge (PMBOK).

Government Furnished Property FEMA shall provide the following government furnished equipment for use by one onsite contractor staff person and the Project Manager for the duration of the contract.

Desk and chair

Telephone

Workstation PC connected to the LAN, printer(s) and other computers and servers as required.

Period of Performance The period of performance shall be from September 1, 2009 through August 31, 2010; the first option period shall be from September 01 2010 to August 31 2011. Then four (4), three (3) month option periods completing the third year; a total of 36 months possible under this effort.