Contract Title: RMS Sustainment

Contract #: FA 8770-06-A-0003  - (Ingenium ING-06-0003-013)

Award Whole $ Value: 963,997.45 base year (Total value not currently available) Approximately 5.5 Million

Period of Performance: 07/05/07 – 07/04/10 (Many years prior support under previous contracts)

Buying Agency: Air Force

Prime/Sub: Ingenium

Prime Contact: : No longer available / Air Force contact: Larry Hill USAF AFMC 754th ELSG/ILSR 937-904-0674, Sheree Etter, 937-257-8144,

Requirements Managements Systems (RMS)

EXCEL provides Software Maintenance, Systems Sustainment and Systems Surveillance to the Requirements Management System (RMS). The RMS is complex and specialized bearing directly on critical wartime aircraft readiness and sustainability, requiring no degradation or disruption of operations, without impacts to the Global War on Terrorism and the United States National Defense. RMS encompasses the automated and manual functions involved in the Air Force Materiel Command (AFMC) materiel requirements process. This process forecasts and controls procurement and repair requirements of materiel needed for logistics support of weapon systems operated by the Air Force. RMS subsystems include:

a. Secondary Item Requirement System

b. Aircraft Availability Model

c. Central Secondary Item Stratification

d. Weapon Systems Data Exchange

e. Web Item Re-computation

EXCEL supports the lifecycle development of the enhancements and changes to RMS which include: modeling the information contents of the data; database administration, data extraction and reporting; hosting of the en-tier web-base legacy system; understanding the data migration requirements to ECSS.

EXCEL Specific RMS Sustainment Support:

System Test: Responsible for organizing the System Test department for testing requirements that come from the AF via Detailed Technical Analysis (DTAs) and Discrepancy Report (DRs) vehicles. This includes all of the above mentioned subsystems in various software environments which encompass IBM mainframe processing as well as PC testing in the Microsoft environment. This requires knowledge of the requirement change(s) and how it affects each system. It involves researching time estimations required to complete testing each DR, what Test Plan (PT) changes/additions (known as redlining) are needed, the appropriate testing strategy for each DR, and what data will be needed to complete the testing. Redlining involves writing updates to Detailed Test Requirements (DTRs) in the (PT) along with any updates to data queries, SAS jobs, JCL procedures, overrides in job libraries and other test related programs. This could also require writing new DTRs and data queries.

Executing cycle runs in the RMST/TEST mainframe regions and/or software applications on the PC to verify or dispute the changes made by the Development staff. If defects are found in the software, reject the requirement vehicle (DR) back to Development staff for further analysis, coding and unit testing. Testing can be on program changes, screen changes, JCL changes or procedure changes, etc.

Running Extracts/Backups and Restores/Loads jobs on the mainframe for RMST/TEST regions to ensure data integrity for testing purposes. Populate briefing charts, System Test Reports, System Test Checklists and assemble documentation known as DR packages with all hardcopy test results annotated for the customer according to AF guidelines for their approval/disapproval that the software changes meet the DR requirements. Maintain spreadsheets for DR and DTR statistics and documentation. Attend weekly staff meetings, Technical Interchange Meetings (TIMs), and peer reviews. Responsible for training new System Test personnel.