About the client
The client is a major national security force within a Middle Eastern kingdom, operating as an independent branch distinct from the regular armed forces. Unlike other military units, this organization was formed with a focus on internal security and the protection of national leadership. The client plays a crucial role in safeguarding the country’s stability, ensuring the defense of key assets, and upholding the interests of the ruling administration. With its unique structure and mandate, the organization has a deep-rooted history and a commitment to maintaining national integrity.
Business need
- The Client’s NATO codification is being collaboratively handled with SLME and KSA by CODASOL.
- The project was initiated in FY 2015-16 and is currently active.
- NATO codes need to be generated for 100,000 items in various warehouses of the Client across KSA.
- CODASOL is responsible for coordinating the cataloging and technical development of applications for codification.
Project Scope
Manpower Supply for Physical Verification of 100k materials
Material Imaging for overall inventory
Application development for Cataloguing & Codification to NATO standard
Cataloguing & Codification of materials to NATO standard
Challenges
- The number of quarantine items in the warehouse is increasing because they do not comply with Industrial Standard Catalog (UNSPSC, NATO, and MESC).
- There is a risk of duplication when classifications are not properly defined.
- Manually creating items is necessary, and using other resources such as websites and third-party applications will be helpful.
- It takes more than 45 minutes to create a complete item catalogue that complies with industry standards.
- Manpower is needed to create, process, and quality check the catalogue.
Methodology for Client
- Step 1: Source Data manipulation & Scrubbing
- Step 2: Review & Classification
- Step 3: Electronic Data Verification
- Step 4: Physical item verification & Enrichment
- Step 5: NATO Codification & Enrichment (NMCRL)
- Step 6: Internal QA/QC
- Step 7: Client QA/QC
- Step 8: De-duplication
- Step 9: Upload to Live System
Propedia Overview
PROPEDIA is a database that contains 50 million cataloged products in the industrial segments, mainly targeting the oil & gas and steel industries. Customers will benefit from easy search options in PROPEDIA. Search options in PROPEDIA will be based on short text, long text, part number, material type, and description. If the requested catalog is not available in PROPEDIA, clients will be provided with the option to request the catalog.
Deliverables
- Our database contains 5.2 million MRO materials in the Industrial segments, primarily targeting the Oil and Gas industry.
- We offer a user-friendly search function that allows you to browse the catalog based on:
* Description Search
* Noun Modifier search
- The output of the user’s request will include material code, short description, long description, and units of measurement (UOM).
- You can receive the output in Excel or PDF format.- Access to the SAP clients database is available through an external link.
- ERP clients have the option to request the catalog if the searched catalog is not available in PROPEDIA.
Value offering from Propedia
- The client experienced a significant improvement in catalog access through the new solution.
- Previously, accessing the catalog took up to 45 minutes, but now, with seamless integration into their ERP system, the client can retrieve this information in under a minute.
- This quick access to an accurate and centralized data repository has enhanced data consistency, eliminated duplication, and supported more informed decision-making processes.
- The primary value offered was the ability to provide precise, cataloged material data at the click of a button.
- Plus, if a specific catalog was not immediately available, the client could easily request it, ensuring their operational needs were consistently met.
Benefits for our client
- Streamlined the material creation process to ensure a structured way of creating material codes.
- Avoided surplus procurement of spare parts and incorrect spares.
- Identified excess, idle, or damaged materials.
- Ensured on-time delivery of materials by specifying the correct material requirements.
- Reduced downtime by providing easily accessible and clear material specifications.
- Avoided rush orders, thereby reducing inventory procurement costs.
