--The Army Operational Employment Database

Notice of Intent to Award the Purchase of the Army Operational Employment Database (AOED) from DFI International, Inc. The Contracting Center of Excellence (CCE), Army Contracting Agency, intends to negotiate on a sole source basis with Detica DFI located at 1717 Pennsylvania Avenue NW, Ste 1200, Washington, DC to provide a current and comprehensive record of the worldwide cumulative demands on Active Army, Army Reserve, and National Guard Forces, which can be used to support a wide array of analytical requreiments for the Center for Army Analysis for the period of 30 September 2007 to 29 September 2008. This announcement is in accordance with FAR 5.101(a)(2). Interested persons may identify their interest and capability statements no later than 23 August 2007 3:00pm EST. The capability statements should include the company name, address, contact inform ation, business size, and detailed explanation of how your organization can meet the requirement described herein. All statements should be submitted via email to Ms. Yong N. Foston, Contract Specialist at [email protected]. Individual response s containing company proprietary information must be marked accordingly. Such information will not be released outside the Government. Furthermore, the Government shall not be liable for or suffer any consequential damages for any technical information id entified (e.g., limited and/or restricted rights). Army Operational Employment Database (AOED) STATEMENT OF WORK (SOW) 1. GENERAL. The Army Operational Employment Database (AOED) is a relational database of historical data on U.S. Army deployments to Lesser Contingency and Major Combat Operations from September 11, 2001 to the present time. The primary objective of the database is to provide a current and comprehensive record of the worldwide cumulative demands on Active Army, Army Reserve, and National Guard forces, which can be used to support a wide array of analytical requirements. This work will update and maintai n the database to keep it current, while improving and modifying the database to better support the analysis of emerging force management issues. 2. BACKGROUND. a. During the 2001 Quadrennial Defense Review (QDR), the lack of accurate historical records on Army deployments inhibited the Armys analysis of major combat and lesser contingency operations. Following the 2001 QDR, the G-8 Army QDR Off ice contracted the development of a centrally managed repository of Army operational deployments. In 2004, the Center for Army Analysis (CAA) assumed the Contracting Officer Responsibility (COR) for the database. The AOED is now used to support the analy sis of a wide range of force management and employment issues, particularly the analysis of the cumulative demand on Army forces. Although the Army maintains a number of different data sources which report the types and number of soldiers deployed to spec ific types of operations, the ability to identify and analyze total force employment and utilization trends using these sources is significantly limited by incomplete information, varying data formats, and the lack of sufficient querying capabilities. The AOED is the only centrally managed database which can be used to accurately and rapidly show the total demand on Army forces. b. However, the AOED must be continually updated with the most recent operations to remain useful and new capabilities are requir ed as new force management issues arise. Although the AOED data for operations outside the U.S. has high fidelity, data on Homeland Defense (HLD) and Defense Support to Civil Authorities (DSCA) missions within the U.S. is incomplete. The AOED currently c aptures Title 10 Guard deployments, but it has only limited personnel data and no unit data on Title 32 and State Active Duty missions. Additionally, exporting the amount of data required to show selected deployment trends over time currently exceeds MS E XCEL capability, hindering an a nalysts ability to quickly produce graphs and charts of these trends over time. Analysts can export data from the AOED to MS ACCESS, manipulate the data, and import the data to EXCEL pivot tables, but the process is currently straining the capability of analyst PCs and will only get worse as the database grows larger. Analysts must be able to use the AOED to rapidly produce charts and graphs showing deployment trends and demand on Army forces. c. Significant Benefit to the Army: The Army can use the A OED to obtain an accurate and comprehensive view of the historical demand on Army forces, which will help senior leaders make critical force management decisions. Additionally, the AOED queries can identify the capabilities used in specific types of opera tions (particularly Global War on Terrorism (GWOT) and irregular warfare) so that Army leaders can examine the sufficiency of the programmed force to execute future missions. The Army can use an up-to-date and comprehensive AOED to support Army participat ion in developing Defense Planning Scenario (DPS) language and building Army force lists for Multi-Service Force Development (MSFD) scenarios. In the long term, the Army will benefit by maintaining a single repository of deployment data which can be acces sed rapidly to support the analysis of Operational Availability (OA-08) and the 2009 Quadrennial Defense Review (QDR) issues related to force strategy. 3. OBJECTIVE. The contractor will collect, integrate, and maintain deployment data within the AOED, a comprehensive, secure, relational database of all Army training and operational deployments and major exercises for the Center for Army Analysis. Additionally, the contractor will assist the Center for Army Analysis in constructing representative forces l ists and analyzing Army deployments since 11 September 2001. Force deployment information on all named operational deployments; including but not limited to: the employment of forces in major combat and lesser contingency operations, HLD and DSCA operati ons, Joint and Combined exercises, support to other services, coalition/partnership training, State Department taskings, NATO or other allied security cooperation agreements, and forces which may be deployed in support of experimentation or to Combat Train ing Centers will be collated and integrated into the database. For the purpose of populating the AOED, a major training exercise will, at a minimum, equate to a deployment away from local training area involving CINC provided funds. This data will includ e reserve component activities of the Army National Guard (ARNG) and the U.S. Army Reserve (USAR). The contractor will not provide data to third parties without explicit approval of the Center for Army Analysis. The contractor will maintain a capability for rapidly creating graphs and charts of the data which show deployment trends over time. 4. CONTRACT TYPE. Time and materials. 5. PLACE OF PERFORMANCE / HOURS OF OPERATION. Generally, all work will take place at the contractors facility. If the contract does not have access to SIPRNET, a SIPRNET terminal will be available at the Center for Army Analysis for use by the contract or to gather deployment data required to populate the AOED. 6. PERIOD OF PERFORMANCE. This effort is for a period of 12 months. 7. SECURITY. The data required for the tasks in this SOW could be classified up to the SECRET collateral level. Occasional access to SECRET/REL NATO may also be required. All contractor personnel supporting this contract must have at least a SECRET clearance. The contractor will adhere to DD Form 254, Contract Security Classification Specification, which would be incorporat ed into the task order at time of award. The contractor will fax security clearance information of personnel performing under this task order to Center for Army Analysis, Attn: CSCA-R (Ms. Johnson), 6001 Goethals Road, Fort Belvoir, VA 22060-5230. Securi ty Point of Contact is Ms. An gela Johnson 703-806-5059, Fax 703-806-5723. 8. QUALITY CONTROL. Standard contracting practices are acceptable. The contractor will establish and conduct a Design Review process as necessary and schedule them periodically with the COR. At least biweek ly project status reports will be provided to the COR. These reports may be via hardcopy, fax, or email. 9. KEY PERSONNEL. The contractor will identify key personnel and attach their resumes to the Technical Proposal. 10. GOVERNMENT POINT OF CONTACT. Ms. Trudy Ferguson, Force Strategy Division, Center for Army Analysis, 6001 Goethals Road, Fort Belvoir, VA 22060-5230. Phone: 703-806-5537 Fax: 703-806-5750. Email: [email protected]. 11. CONTRACTING OFFICERS REPRESENTATIVE. Same as paragrap h 10. 12. GOVERNMENT FURNISHED ITEMS. The Government will provide the following: a. Workspace during periods when contractor personnel are visiting the Center for Army Analysis, Fort Belvoir, VA. The primary purpose of the visit would be to download dep loyment data from SIPRNET sources. The COR will arrange to have the data transferred to a data CD which would then be provided to the contractor. The workspace would include a government provided desk, telephone, and PC with access to the SIPRNET classif ied computer network and its inherent capabilities including, but not limited to print services. b. Access to relevant government organizations, information, and documentation, personnel, manuals, texts, briefs, documents, and associated material as requir ed. This access will be coordinated with the COR. c. Initial familiarization and orientation provided on-site by the Government. 13. SPECIFIC REQUIREMENTS. The contractor will perform Tasks 1, 2, and 5. If funding permits, the contractor will additiona lly address Tasks 3 and 4. a. TASK 1. Data Collection, Integration, and Maintenance of the Army Operational Employment Database. The contractor will collect data on recent operations, exercises, and training events and integrate the data into the existin g AOED tables. If a complete set of data cannot be obtained from authoritative sources, business rules for filling in data holes must be approved by the COR and annotated in the database. Highest priority will be given to capturing data on Army deploymen ts to operations. Collecting and integrating training and exercise data will be given a lower priority. The database, code, executables, and any data acquired or generated by the contractor in the performance of the contract shall be the property of the Government. The contractor will update and maintain the AOED by accomplishing the following subtasks (the list is not all inclusive):Unit Table a.) The contractor will update the Unit Table every six months standardizing unit names in accordance with t he Current Forces Database unit names. b) The contractor will obtain and integrate the standard requirements code (SRC), branch, component (COMPO), troop program sequence number (TPSN), unit name, authorized unit strength, and home location for each unit in the Army force structure. The contra ctor will standardize branch codes to match the U.S. Army Force Management Support Agencys branch codes whenever possible. c) The contractor will obtain and integrate state codes for ARNG units on non-Title 10 missions. Event Table a) The contractor will update the Event Table quarterly by obtaining and integrating data on all major combat operations and the majority of lesser contingency operations contained in CAAs Lesser Contingency Database to include non-Title 10 operations in the U.S. Northern Command (NORTHCOM) Area of Responsibility (AOR). b) The contractor will standardize new event names with the assistance of the COR. c) The contractor will identify the event category for each new event in the database with the assistance of the COR. Dep loyment Table a) The contractor will update the Deployment Table quarterly b) The contractor will obtain and integ rate the unit identification code (UIC), location, and start and end dates which reflect embarkation and debarkation dates as contained in Department of Defense (DOD) source records. When applicable, the contractor will obtain and integrate mobilization a nd demobilization dates. c) The contractor will obtain and integrate the number of personnel in a unit who actually deployed to each operation from Department of Defense (DOD) source records. These sources may include U.S. Army Forces Command, Combatant Commands, and HQDA in unique databases. Access to this data will generally be via the SIPRNET. d) The contractor will assure that lookup tables supply rotation, event type, deployment time, AOR, data source, and unit event purpose for each reported depl oyment. 4) Queries and Analyst Edit Capability. a) The contractor will assure that the query capability can easily retrieve data from new fields as they are added to the database. b) With each update of the database, the contractor will assure that the analyst edit capability provides a capability for the analyst to change any fields (including new fields) while maintaining an audit trail of each change. The contractor will also assure that event and unit names are consistent with names used in other database tables. b. TASK 2. Improve and modify the AOED. Maintain the current database and with approval of the COR, make improvements and modifications to the AOED. The contractor will provide the COR with cost estimates for extensive enhancements prior to approval. Under this task, the contractor wil l add fields or capabilities needed to support the analysis of new force strategy issues. This work may include adding new fields such as a requirements or branch group field, collecting non-Title 10 deployed personnel and unit data and integrating this d ata into the Deployment Table, developing a capability to make custom graphs, tables, and reports using the MS SQL server, changing query menus, or improving the analyst edit capability. c. TASK 3. Assist in the analysis of Army deployments trends. 1) When required, the contractor may be required to develop a series of graphs, supported by spreadsheets, that can be used on a regular basis and which would clearly demonstrate the numbers, types, size, duration and location of major combat and lesser con tingency operations which the Army has been involved in since 11 September 2001. The contractor will provide an export to MS ACCESS/EXCEL or SQL Server capability to create the graphs. 2) These graphs/spreadsheets would characterize Army deployments by showing the following (the list is not all inclusive): Number of soldiers deployed by day by COMPO a) Number of soldiers deployed to specific operations by COMPO b) Number of soldiers deployed to each AOR by day by COMPO c) Number of soldiers deployed OCO NUS for exercises by day d) Number of soldiers deployed for exercises by AOR by day e) Number of soldiers supporting HLD by COMPO by day f) ARNG deployments by duty status (Title 10 or Title 32) by state g) Number of each branchs deployed units by SRC and day h) Number of units deployed over days by type i) Number of troops by type of lesser contingency and COMPO j) Number of units by type of unit and type of lesser contingency l) Personnel deployed over days by branch group n) Number of personnel deployed over days by branch and by operation d. TASK 4. Develop a comprehensive list of forces used for Operation Noble Eagle. The list would be in the form of a spreadsheet that would list to the SRC level of detail, the types, numbers, and descriptions of uni ts, authorized and deployed personnel. The sum of the soldiers deployed by unit must closely match Army troop strength reported in the Army Operations Center or NORTHCOM daily briefings or other DOD source. e. TASK 5. The contractor will submit a final r eport on the development and status of the AOED to CAA at the conclusion of the period of performance. The report will update the technical documentation on the database. As a minimum, it will include data flow, assumptions, data definitions, data traceability matrix, data processing procedures, database scripts, and database naming conventions. All document ation shall be the property of the Government.