International Freight Data System (IFDS) at DOT

As the lead in a Joint Venture with ProLogic, MORI is developing International Freight Data System (IFDS) Data Warehouse for Research and Innovative Technology Administration (RITA) as a Task Order under DOT-OCIO IDIQ contract. The IFDS will be jointly shared by seven Operating Administrations (OAs) of the Department of Transportation (DOT). The IFDS Data Warehouse will integrate specific data elements from Customs and Border Protection’s (CBP) Automated Commercial Environment/International Trade Data System (ACE/ITDS) and other discrete data sources into single decision support environment.

Technical Services

  • Data Warehouse Requirements and Design Implementation: MORI-ProLogic has reviewed the available CBP and other discrete data and is working on identifying a strategy for cleansing the data and then storing the data within the warehouse. This includes performing complex data calculations to identify the amount of storage space and the operational requirements for all of the servers used within the project. MORI is also defining a strategy for placing the CBP and other discrete data sources into a common frame of reference. MORI-ProLogic performed a detailed requirements analysis among the seven DOT modes that will use the data and identified the data requirements. The team then used this data to design the data warehouse structure, and the ETL processes necessary to collect and upload the data.
  • Data Warehouse Test and Deployment: MORI-ProLogic has developed a working prototype of the system to resolve several design considerations. After running initial tests, it appears that MORI-ProLogic will meet all design and performance requirements.
  • Security Requirements: The data center design has been met all DOT requirements, including a security evaluation. MORI-ProLogic also met DHS safety and security requirements as a prerequisite to transferring CBP data to DOT.

Innovative Solutions to Satisfy Technical Requirements

  • Because of budget shortfalls, DOT has not been able to deliver the equipment necessary to develop the first stage of the Data Warehouse. MORI has responded by purchasing the equipment and developing a prototype which allowed system design to proceed through this potentially dangerous schedule set-back.
  • MORI is using a Problem and Risk Management set of processes in order to identify risk and quickly correct the problem. Risks are reviewed monthly in formal Program Management Reviews with the customer and MORI Senior Management. This has allowed MORI-ProLogic to be aware of issues as they occur and quickly provide technical and program level recommendations. As a result of implementing these processes, MORI has not had any quality issues.

Results

The IFDS initiative is primarily to design, develop, test, implement and maintain a decision Support and Business Intelligence System for the participating DOT Modes. The IFDS will increase user effectiveness by providing one source of authoritative information for decision support, business intelligence and reporting, and provide information for enforcement, analytical, and policy decisions. MORI is developing this data warehouse using the Kimball data warehouse design methodology. MORI has helped RITA outsource the data as well as design and build the Federal Enterprise Architecture (FEA)-compliant data center architecture.