Team Technology has supported ATF for nearly 10 years on various projects: TTI provides the Information Services Division (ISD), of the ATF technical expertise and hardware and software necessary to provide system development and support for a nationwide network of users. TTI provides system support services in order to deliver a complete turnkey solution that includes deployment of hardware and software applications at designated IM sites. System implementation services encompass the acquisition of all necessary hardware/software, system configuration and testing, onsite installation, training and ongoing technical support.

TTI, an IBM "Federal Systems Integrator" (FSI), Partnered with IBM, was engaged on a pilot initiative to deliver Websphere - the data quality management software, provide installation support, conduct an assessment of the ATF systems, data profiling/cleansing and provide knowledge transfer and mentoring for the ATF staff on the use of IBM’s toolset (Information Analyzer, DataStage, Quality Stage, and Information Services Directory). TTI was engaged in performing a full data investigation of the agency data source, examine the data, and formulate a detailed data quality report and plan of corrective action. The project effort was divided into five sections, which outline the tasks and deliverables for the Data Quality Initiative:

• Project Planning
• Technical Architecture Review
• Technical Installation and Configuration
• Data Integrity Analysis
• Mentored Development / Knowledge Transfer

As Phase 2 of the project, the task was to provide environment to build and deliver SOA-enabled services independent of the existing disparate databases and make data available for all processes. Data Migration efforts were directed towards establishing a Central Repository for Data as well as develop the process to integrate this data into the production environment through Service Oriented Architecture (SOA) applications – Websphere. Upon completion of the QualityStage cleansing effort, affected fields updated and duplicate records deleted in the central repository while DataStage used to transform and update fields and/or delete records.