Intrinsyx designed and built a Data Warehouse solution to support the Next Generation Air Transportation System (NextGen ATM) project at NASA Aviations Systems Division. NASA has a requirement to improve the efficiency and effectiveness of research and analysis of flight and surface data so that it can support the Federal Aviation Administration (FAA) National Airspace System (NAS) goal of increased safety and capacity and reduced congestion and delays.
 
- We built an Oracle-based Data Warehouse that stores over 6 Terabyte of data files and meta data.

- We delivered a rich web-based reporting and analysis solution to allow a user to analyze weather, delays caused by weather, taxi times, surface congestion points, queuing times, arrival and departure runway assignments, terminal area flight profiles and times, and taxi routing procedures.

- The web-based solution also provides a dashboard report and allows a user to search and download any data files from the Data Warehouse.

- We also implemented Application Programmatic Interface (API) to allow a user to query and retrieve any data from the Data Warehouse by using software such as MATLAB. This enables a Single Authoritative Source (SAS) of data for research and analysis over all data sets.

- The Data Warehouse solution is an-ongoing effort and it is delivered through multiple phases to deliver frequent releases of features to the users.

- Extraction, Transformation, and Loading (ETL) of all data files into the Data Warehouse is performed on a daily basis so that users can have timely access of the data they need in one single place.