Welcome to DiMSaMS Inc Consulting • Database Design/Reform • Analytics

What We Do



DiMSaMS Inc combines extensive experience in both the repair parts business as well as software development in order to provide unique tools to manage Diminishing Manufacturing Sources and Material Shortages issues. Data about parts and providers is stored in a relational database, and then extracted according to your specific informational needs.

The nature of a relational database means there are no limits. If a requirement can be conceived and defined, it can be done. While the basic core data structures remain the same from one system to the next consistent with the subject matter, there is total flexibility to deal with the details to whatever extent is required. 

SERA Studies

Developed in Detroit’s Defense Corridor with Automation Alley and TARDEC, a SERA (Sustainment Engineering Risk Assessment) study examines repair parts specific to a particular piece of equipment, and ranks the parts in order by risk of unsustainability. Results are presented as a database that allows system users to identify and evaluate the most critical items for remedial efforts.

The database is initially populated from PMR (Procurement Master Record) data. Either MIL-STD-1552 or MIL-STD-1388 format is acceptable. All of the contents are viewable by system users, and can be used to navigate through the data. Users can drill down through PCCN’s (Provisioning Contract Control Numbers) to UOC’s (Used On Codes) to individual PLISN’s (Provisioning Line Item Sequence Numbers).

Data about the system’s NIINs and CAGEs is collected from dozens of government and private sources and added into the database. Aspects such as contracts, usage, delivery times, engineering assistance requests, quality issues, and supplier financial considerations are examined. Over twenty parameters per part are evaluated and assigned a numeric score, which is used to determine total risk on a per part basis, as well as on an aggregate basis anywhere along the way up to the overall equipment score. Aggregated data is also used to provide system users a view of risk and associated details on a per supplier basis.

System data is periodically refreshed. Anytime changes are made to the PMR, the revised file is simply imported into SERA, and current data is obtained from all of SERA’s data providers. A new version is then published with revised rankings. Pertinent data is maintained in the system which provides for historical review of changes over time. Overall progress in risk reduction is quantifiable and measurable as new versions are released.

Contact Us


6539 Paul Revere Ln, Canton Twp, Michigan 48187, United States


Terry Perkon
(734) 812-7810