Army Materiel Command (AMC) AWCF Financial Auditing
AMC's Financial Audit readiness program provides auditability reporting and adherence to Federal Accounting Standards policies across the AMC enterprise. The financial audit is focused on the auditability of Army processes and controls for Army Working Capital Fund (AWCF) inventory.
CMAT spearheaded the development of AWCF reporting using the Army Vantage Platform. We modernize critical financial audit reports by migrating them to the Army Vantage platform and away from managed spreadsheets. This modernization process reduced human in the loop issue, automated the auditing process and provided a data visualization view of the financial readiness of the AWCF inventory.
Logistics Data Analysis Center (LDAC)
AMC's LDAC provides sustainment data, information technology and decision support to improve readiness and enable effective Army Senior Leader decision-making from the Strategic Support Area to the tactical point of need. In support of LDAC's analytics mission CMAT developed the Interface Auditing process for the Army Vantage Platform. Interface Auditing ensures that the transfer of data from the enterprise data sources to the Army Vantage platform occurs with strict adherence to transformation rules and the data is consistent. The Interface Audit process gives the enterprise confidence in the integrity of its big data and the information gained from that data.
LDAC Enterprise Data Quality Branch
The Enterprise Data Quality Branch serves as the Army lead for integrating & improving data quality across the Army enterprise so that data is accurate, consistent, & timely (ACT) throughout its lifecycle.
In support of The LDAC Data Quality Branch, CMAT developed a modernization process to migrate existing tools used to perform data quality assessments to the Army Vantage platform. The modernization process provided the Data Quality Branch a single platform to perform data quality, analytics and data visualization in a single platform for Army customers.
In support of The LDAC Data Quality Branch, CMAT developed the Authoritative Data Source Validation process. Utilizing the Army Vantage platform CMAT validates datasets coming from various enterprise systems and validates the quality of data. If the data is found to be accurate the dataset is moved in the data catalog within Vantage to be used for future analytic analysis. The datasets are documented within the Enterprise Data Service Environments. The Data Services Environment (DSE) is an enhanced dashboard that provides integrated registration and discovery capabilities for ADSs, services, service metrics, and related metadata artifacts. The DSE contains the structural and semantic metadata artifacts critical to successful development, operation, maintenance, and utilization of existing and future capabilities that support the DoD Net-Centric Data and Services Strategies.
LDAC Enterprise Data Management Office
As the Army's single sustainment activity for key foundational logistics data, the Data Management Division empowers the Army Materiel Readiness through data stewardship and data quality. This frontline approach focuses on core data quality dimensions rather than an individual logistics enterprise system.
In support of The LDAC Data Management mission, CMAT developed the Army Logistics Enterprise Glossary (ALEG) to provide stakeholders with a common understanding of logistics business terminology and its implementation across multiple business systems. ALEG creates a single collaborative repository that links the DOD end-to-end business scenarios, Army business processes models, Army Logistics business terms, SALE transaction, and information technology (IT) assets enabling total visibility of enterprise business operations. CMAT sustained ALEG in support of the organization’s lifecycle data management and data quality workstream missions. CMAT performed research and analysis to successfully represent the Logistic Domain business processes, business terms, and information technology assets. The objective of these efforts was to support a web-based glossary repository that is Common Access Card (CAC) accessible and adequately supports data governance, data quality, portfolio management and business re-engineering decisions with insight into IT impacts across the Logistics Domain as well as other functional domains that have relationships in how the business is conducted.
LDAC Portfolio of IT Management Services
In support of LDAC's mission of convergence, CMAT supported the implementation and execution of the LDAC Logistics Information Warehouse (LIW) and Program Management Office for Army Enterprise Systems Integration Portal (PM AESIP) integration and convergence. Integration is the consolidation of legacy databases into a modernized warehouse, as well as the sunset of capabilities no longer required.
CMAT helped develop and configure processes to perform extract, load, and transform (ELT) of data, with a preference for schema-on-read capability with minimal duplication of data. The data was securely received, distributed, processed and archived with the appropriate mapping identification.
CMAT supports the implementation of the Hadoop Data Lake Architecture that provides timely and trusted information through accessible, highly secure and around the clock availability of high-speed, global communications while reducing costs associated with hardware, storage, and software licensing. CMAT supported the modernization and consolidation of legacy databases and data interfaces in preparation for migration to the Data Lake.
CMAT assisted in developing baseline architectures, target architectures, developing documentation, artifacts, and sequencing plans to transition from baselines to the targets. CMAT supported establishing Enterprise Architecture (EA) programs that encompass current information systems, develop new systems and determine where to insert emerging technologies to optimize the IT mission value.
PEO EIS TIS
PEO EIS TIS combines complementary and collective capabilities of Transportation Coordinators’ – Automated Information for Movements System II (TC-AIMS II) and Radio Frequency In-Transit Visibility (RF-ITV). TC-AIMS II automates and manages the movement of personnel, equipment and sustainment cargo—maintaining visibility at the tactical, operational and strategic levels. RF-ITV produces, collects, and integrates movement and In-Transit Visibility (ITV) information through a worldwide infrastructure of mobile and fixed RF-ITV read and write stations, satellite transponder-equipped vehicles and servers to make ITV data available to users through a web-based tracking portal and shares data with 35 other DoD systems.
CMAT supported integrating the collective capabilities of TC-AIMS II and radio frequency devices for In-Transit Visibility. TC-AIMS II automates and manages the movement of personnel, equipment, and sustainment cargo—maintaining visibility at the tactical, operational and strategic levels. The solution’s components include TC AIMS II Unit Move,TC AIMS Theater of Operations, RFID, Java, C#, SQL Server, web services, IIS, Intermec Printers, ISO 1800-7 and Windows CE.