Newly Modelled Data Warehouse with the power of AI delivers 15 percent reduction in expenditure

Newly Modelled Data Warehouse with the power of AI delivers 15 percent reduction in expenditure

Technology helps reduce spending and increase revenues by providing visibility into global spending while creating automated processes to classify spend data warehouse and identify opportunities for savings. Algoscale practiced big data analytics and predictive intelligence to bring transparency in supply chain management making the healthcare system more affordable and efficient. This enables hospitals and suppliers to effectively manage their daily supply chain operations and generate revenues.


The Client
Provider of a cloud-based SaaS purchasing platform designed to reduce costs and deliver better patient outcomes. The company‚Äôs cloud-based SaaS purchasing platform uses the latest data science and software technology to bring maximum transparency to both ends of the supply chain ‚Äď for benefit of both, and at expense of neither.


The Challenge
The client wanted to bring hospitals and suppliers on a single platform, enabling seamless collaboration and commerce between hospitals and suppliers. Hospitals use the solution to manage their daily supply chain operations and suppliers leverage the platform to generate revenues and collaborate with hospitals. In the healthcare supply chain, a lack of business intelligence can lead to increased costs and poor patient outcomes for hospitals, and loss of business opportunities and new customers for suppliers.


The project was aimed at moving the manual work model to an automated system for better visualization of insights on company‚Äôs expenditure over the time and various categories using their spending and consumption data. One of the challenges was handling enormous size of data in an unstructured format for over a decade (2007 ‚Äď 2017). This valuable data set existed in spreadsheets and has been there over the years but has never been looked into for gaining business insights.


Vital information had to be extracted from the 160,000 invoices in Spanish language containing products/services with their attributes and prices that had many uneven marks and noise. Besides, the client required an e-commerce portal for medical equipment to eliminate intermediaries from the supply chain in order to bring down healthcare cost.


The Solution
Algoscale built a one-stop solution for the entire healthcare supply chain for the client. The team began with building a global warehouse database for creating a product master to handle the enormous size of data over three years and standardize it across all regions. Information on product catalogs from major healthcare equipment industries was extracted by crawling across sources. Collection and cleaning of a large volume of data were undertaken followed by designing the taxonomy and data management to build the most enriched database for visualizing the insights. An enormous data warehouse equipped to handle 2 million x 300 data points and an ETL pipeline equipped to process 10 million + row items/cycle were modeled.


Purchase and consumption data were augmented with a cleaned product master and then spend analysis was done using a customized software application to leverage fine insights and the power of machine learning. For better visualization of data, a dashboard with custom filters based on user profiles was implemented.


Some of the purchase data were not cleaned and were present in form of scanned images of physical purchase invoices. Hence, additionally, an in-house OCR (optical character recognition) solution, that converts images of text into machine-encoded text, was developed to extract data from the supplier invoices by using the google tesseract engine. The image was pre-processed and the information was extracted via pytessaract tool.


Further, the team developed an end-to-end e-commerce platform inclusive of features like Live Chat, Automated email generation, etc. for the Indian market in the healthcare sector. Building a recommendation engine based on past order data simplified the inventory replenishment process for customers.


Algoscale built a platform to find opportunities for savings and generate new revenues for the client. A web application depicting spending and consumption (supply chain) analysis with over 80 thousand products and more than 10 thousand suppliers was made. Cost-saving opportunities were achieved to the tune of 15% of spend. The client now had a clear view of the total spend by them.


Technology Stack
Python, MySQL, ElasticSearch, Angular 4, NodeJs, Django, JavaScript, HTML5, CSS3, pytessaract, tessaract OCR & OpenCV.

Recent Posts

Subscribe to Newsletter

Stay updated with the blogs by subscribing to the newsletter