The client operates in the aluminum recycling and liquid metal supply industry, serving high-pressure die-casting foundries across multiple locations. The industry is highly logistics-driven, requiring precise coordination and timely deliveries, as molten metal has limited holding time. Any delay can disrupt production, making reliability, efficiency, and supply chain visibility critical for operations.
A SQL Server dimensional model processes all three source systems through a 14-step ETL pipeline into 11 fact tables, with full-reload and incremental daily processing.
A secure, on-premises multi-agent assistant lets authorised users query the database in natural language and receive text, tables, and charts, retaining context across a conversation.
Built around existing data sources
No operational system was replaced; OPTIMA extends at the process and experience layers, preserving data ownership and protecting operational continuity.
Advaiya made service-failure time visible by machine, cause, shift, and customer, automated OTIF collation, and removed the data-analyst dependency for routine insight for CMR OTIF customers.
Advaiya’s solution significantly improved the visibility for OTIF (On-Time In-Full) performance, helping us to identify no-metal time and supply chain issues for our customers
IT – Marketing Executive
