Medical Devices – Real Time Insights for Inventory forecasting and Optmization

Think AI got involved with client to help them guide on how to best utilize their siloed databased to single source of truth.
A leading Medical Devices company with heavy global presence having 1.5B dollars in revenue and 5000+ employees, 12+ facilities across the world and having 1000+ medical devices in their portfolio. They are the world’s leading provider for Orthopedic and mobility devices.

Business Challenge
Exchanging and analyzing data with Suppliers and Retailers and integrating Orders , Invoices , Advance Shipment Notice used to a huge challenge due to manual data entry or export/import of this information. Also, the company has multiple ERP system which were inherited with several acquisitions across the world. Moreover reporting and sending data has a Realtime needs. Also, certain parts of data that lives in excel sheets needs to manage as master data and solution must accommodate master data management as well.

The Solution
Think AI was tasked for this challenge and within 6 months of time , we have implemented a true and elastic Datawarehouse using Snowflake and Power BI. We have also used Apache Kafka to provide Realtime Advance shipment notices , inventory levels and eCommerce Sales. Master data for Product Information management is managed and maintained using a .NET Core application on Azure using MongoDB (CosmosDB) as the backend database.

Technology Used
MongoDB, .NET Core, Snowflake, Power BI, Apache Kafka

Benefits

  1. Reduce data entry and errors.
  2. Data exchange is cheaper, faster.
  3. More accurate forecasts
  4. Improve inventory predictability.
  5. Gain visibility and respond quickly.
  6. Focus more on your business
Scroll to Top