We’re trusted to deliver information systems that drive data integrity for federal agencies, including the Department of Homeland Security and the Department of Education, as well as state governments. Our enterprise clients are international firms spanning pharmaceutical, financial, utilities, telecommunications and other industries.
Read the solution briefs to see how FITS helped these organizations:
FITS supports federal, state and commercial enterprises. Here is a partial list of our clients served:
Free and Secure Trade System Expedites Commercial Travel
Customs and Border Patrol (CBP) is one of the Department of Homeland Security’s largest and most complex components, faCilitating approximately $2 trillion in trade each year. CBP’s mission is to keep terrorists and their weapons out of the U.S. It also secures and facilitates trade and travel while enforcing hundreds of U.S. regulations.
FITS designed the Free and Secure Trade (FAST) System Database for CBP. Truck drivers traveling between the U.S. and Mexico or the U.S. and Canada simply swipe their ID cards, which are pre-cleared in the FAST database. The database includes each pre-cleared driver’s picture and profile. With FAST, drivers no longer have to wait in long lines. In addition to enhanced security, the system has also introduced significant new efficiencies for CBP and their personnel.
Information Management and Architecture for Customs and Border Patrol
FITS was called to join a team to help develop data management and architecture for a critical CBP system for Foreign-Trade Zones (FTZs). Located in or near CBP ports of entry, FTZs are the United States’ version of free-trade zones. Foreign and domestic merchandise may be moved into these zones for storage, exhibition assembly, manufacturing, and processing.
FITS was called on to support this project because of the breadth and depth of experience we possess with the databases, platforms and technologies used by CBP. We were instrumental in designing, developing and implementing FTZ data models and databases using ERwin and DB2 RDBMS. We also provided the technical support for the application architecture. This secure web-based application uses Websphere® and runs on the Unix® platform.
Joint Venture with Customs and Border Patrol Assures Compliance Nationwide
The Automated Export System (AES) is a joint venture between CBP, the Foreign Trade Division of the Bureau of the Census (Department of Commerce), the Bureau of Industry and Security (Department of Commerce), the Directorate of Defense Trade Controls (Department of State), other federal agencies, and the export trade community. An important system with a large volume of users and transactions, AES is the central point where export shipment data required by multiple agencies is filed electronically to Customs. FITS was selected to convert, design and build the AES database system. AES is a secure, efficient and collaborative alternative to filing paper shipment forms.
With AES, export information is collected electronically and edited immediately. Errors are detected and corrected at the time of filing. AES is a nationwide system operational at all ports and for all methods of transportation. FITS’ database work achieved project goals of assuring compliance with and enforcement of laws relating to exporting; improving trade statistics and data; reducing errors and duplicate reporting to multiple agencies; and improving customer service.
FITS helped convert the AES database running on CA Datacom to DB2 RDBMS. FITS set up all the backup and recovery procedures and provided 24 x 7 production support. FITS also:
Unified Data Management and ERP Integration for MichCon Consolidated Gas
With more than 10 million clients and hundreds of valves and regulators installed, MichCon is a leading integrated energy company. They called on FITS to provide Information Engineering (IE)/Information Engineering Facilities (IEF) support to multiple project teams managing systems for regulator and valve eqUipment (RAVE) tracking, on-site collections and gas conservation and transportation.
FITS helped MichCon manage this diverse data from multiple sources to create a single cohesive system. FITS used IEF Encyclopedia as the central repository for RAVE and collection data. We made an innovative move and used rEF to include metadata objects, which were centralized and then distributed to multiple applications across the company. FITS successfully and seamlessly integrated the data into MichCon’s ERP system. We also:
Development and Migration for U.S. Department of Education Financial Systems
We supported the Department of Education by providing DB2jCooigen DBA for Direct Loan Servicing (DLSS), IEFARS and Pell Grant systems. We installed and configured UDB vS on their NT 4.0 platform and designed and created a database for Education’s Direct Loan Project. For this project, we:
With our structured methodology and project management skills, the FITS team led the migration to a newer version of DB2 and served as liaison between vendor project teams. Our work introduced a rigorous set of database change control procedures and guided the conversion from DB2 plans to packages. This included creating a series of special SQL queries to check for database anomalies.