SOLICITATION NOTICE
D -- Commander's Resource Integration System (CRIS)
- Notice Date
- 10/22/2004
- Notice Type
- Solicitation Notice
- Contracting Office
- Steven Brumfield;4225 Logistics Avenue ; Wright-Patterson AFB, OH 45433-5755
- ZIP Code
- 45433-5755
- Solicitation Number
- FA8770-05-R-0013
- Description
- The Air Force is seeking contractors interested in continuing operations and sustainment for the Commander?s Resource Integration System (CRIS). CRIS provides Headquarters Air Force level, MAJCOM level, Wing Commanders, Financial Managers, and Resource Managers with the ability to make informed decisions concerning resource allocation through a set of decision support tools. The CRIS data warehouse is a set of distributed hardware and customized software components providing data analysis tools applied to a large subset of Air Force financial, logistics, Civilian Pay, Civilian Personnel, and operations data sourced from existing legacy systems. The Commander's Resource Integration System uses advanced technologies to provide the users with analytical tools that greatly enhance visibility to data required for sound decisions. These main technologies are Extract, Transform, and Load (ETL) tools, a suite of database/data warehouse tools, application tools in the form of query tools and web views, and Online Analytical Processor (OLAP) tools. ETL: Source (legacy) system data is gathered via a specialized File Transfer Protocol (FTP) tool from: the General Accounting and Finance System (GAFS), the Command Budget Automated System (CBAS), the Standard Base-Level Supply System (SBSS), the Fuels Enterprise System (FES), the Reliability and Maintainability Information System (REMIS), Central Procurement Accounting System (CPAS), Commanders On-Line Accounting Reporting System (COARS DBT), and Airlift Services Industrial Fund Integrated Computer System (ASIFICS), Civilian Pay, Civilian Personnel, and Reserve Pay. ETL tools facilitate the extraction of the data from the source systems, its transformation for use, and its load into the warehouse, driven by business rules. Database: The data warehouse is the collection of data from many systems, stored in multiple databases specifically structured for query and analysis using star schemas. The CRIS technical team has developed this data warehouse using Microsoft's SQL Server 2000. The Commander's Resource Integration System has developed relationships between the data from these legacy systems that provides analysts the ability to quickly research all required execution aspects of the program. The data warehouse is accessed via views. Access is controlled via role-based security. The data warehouse tools include query management, load leveling, and data mart management. Application: The CRIS technical team also developed two different tools for the analyst. The first tool provides a Web interface that displays detailed information. The Web reports have limited customization but provide a quick means to view the data and the ability to locate variances in the program being queried. The CRIS tool allows analysts and leaders at all levels to quickly identify problem areas, resolve issues, and reallocate resources to meet current and future needs. The second tool is a client tool that provides the user very detailed and tailored information. This tool provides for previously unheard of granularity detailing data on a near real-time basis. The query analysis tool produced by the CRIS technical team uses technology called Online Analytical Processor (OLAP). OLAP has proved very useful for analyzing data from multiple legacy systems and producing results quickly. CRIS exists as a single logical system consisting of a set of SQL Server 2000 Databases, tightly integrated with a set of Dell Web Servers and managed using a mid-tier server. Authorized users can access CRIS from anywhere on the ?.mil? network using either Internet Explorer or Netscape. The Web and Database servers operate on Windows 2000. Users Supported: 11,500 plus and growing Interested sources should provide a capabilities package (limited to 5 pages with the cover letter excluded from the page count), which demonstrates the experience necessary to successfully support CRIS. Each package shall include small business status (large business, small business, small disadvantaged business, 8(a), HubZone, etc.) within the NAIC 541519. Specifically, the capabilities package should demonstrate the following: Experience providing web application development using SQL Server 2000, Visual Basic, Dell Storage Area Network (SAN) in a warehousing environment and Experience supporting the financial functional community as it relates to the Department of Defense. In addition, Past Performance references (minimum of 3, maximum of 5) shall be provided that demonstrates the above experience (does not count against 5 page limit). Electronic submissions are preferred in Microsoft Word format and delivered either on a 3 ? floppy, or compact disk media. Capability packages are due within 5 business days from the date of this announcement (27 Oct 04) and shall be sent to: Mr. Steven T. Brumfield MSG/PKB Bldg. 266 Rm S216 4225 Logistics Avenue, Room S216 WPAFB, OH 45433-5755
- Web Link
-
Commander's Resource Integration System (CRIS)
(http://www.herbb.hanscom.af.mil/esc_opps.asp?rfp=R949)
- Record
- SN00697962-W 20041024/041022211911 (fbodaily.com)
- Source
-
FedBizOpps.gov Link to This Notice
(may not be valid after Archive Date)
| FSG Index | This Issue's Index | Today's FBO Daily Index Page |