 |
Skylon Technologies Engineer provided leading technical and functional enterprise data management expertise to support the Total Lifecycle Management project headed by the Business Enterprise Office, Headquarters Marine Corps Installations and Logistics (HQMC I&L).
The project focused on the item induction process in Marine Corps Logistics application systems.
Our main tasks included amongst others:
 Identification of data quality issues in various Marine Corps logistics systems by performing data profiling, implementing business and transformations rules based on functional inputs from subject matter experts. Working with stakeholders to develop and implement remediation as well as monitoring to produce scorecards for decisions makers. Implementation of data validation and filtering rules using the data profiling and other business intelligence tools including but not limited to Informatica, Talend Open Studio and Oracle Business Intelligence Suite.
Analysis of the Marine Corps item induction process, with special focus on interactions between the Marine Corps Technical Data Management System (TDMS) and the Federal Logistics Information System (FLIS). Identification of thousands of occurrences of improper item cataloging of the Federal Stock Number in Authoritative Data Sources System and proposed automated solution.
Analysis of the interface control document between the Marine Corps Total Force Structure Management System and both the Marine Corps Technical Data Management System and Item Applications System to highlight breakpoints and downstream effects of referential data quality issues.
Writing custom programs using Natural, COBOL and JCL (Job Control Language) to extract National Item Identification Numbers and characteristics from the Marine Corps Logistics Mainframe System.
Writing Java Routines to transform TDMS nightly report files for data loading and analysis.
Recommendation for business process changes to help streamline Marine Corps logistics systems by removing data redundancies, clearly identifying critical data elements and their respective source systems.
Drafting a Standard Operating Procedure (SOP) for extraction of technical data from the mainframe-based Marine Corps Technical Data Management System.
|
