Out of Stock System for Drugstore

OUT OF STOCK SYSTEM FOR DRUGSTORE

Predictive analytics module

Situation

One of Unicsoft clients, a large pharmaceutical network came up with request for a collaboration regarding development and implementation of OOS (Out of Stock system). For that current moment, Client had over 2000 drugstores all around the country and a reporting module comprised of reports concerning revenues and daily turnover.
 

Solution

The main goal was to set up a proper ETL process and perform a predictive analytics module intended to predict absence of drugs & remedies alongside with BI-tool deployment for ad-hoc reports and predictive analytics. Subsequently, the request evolved into not only a analytics & reporting module, but a complex solution providing access for suppliers to let them see the picture considering sales & trends of their products in any point of sale.

Unicsoft started from setting a dedicated team comprised of data architects and engineers to establish and consequently maintain data migration process. Considering necessity of being able to do close to-real-time analytics as well as requirements of DB consistency and availability, a noSQL architecture was considered as the most suitable. Thence, a several data scientists were involved to manage data enrichment and munging process. Having this step completed, a predictive analytics module was implemented to calculate estimated risk of product absence and predicting sales trend. As a copestone, a BI module was added providing a visualization of predictive module outputs.

 

Result

Client underlined well-organized and orchestrated delivery process from Unicsoft side, and, consequently, this case of collaboration led us to establishing a successful cooperation along with new projects for pharmaceutical industry.

TECHNOLOGY & TOOLS: noSQLPythonTableauXGBoostBig Data

Have an idea for an Artificial Intelligence or Blockchain project?

Let’s discuss it!

You will receive a reply within 24 hours.

    *As a result of submitting completed “Contact Us” form, your personal data will be processed by Unicsoft. We are committed to respecting your privacy. Read our Privacy Policy.
    Meet us in the UK

    Aleksey Zavgorodniy

    Chief Executive Officer

    Telephone +44 204 577 07 94

    Address 2nd Floor, 6 Market Place, London, Fitzrovia, W1W 8AF
    Other countries
    Meet us in Ukraine

    Aleksey Zavgorodniy

    Chief Executive Officer

    Telephone +38 091 481 99 97

    Address 39 Ivana Kudri str, office 11, Kyiv 01042
    Other countries
    Meet us in Singapore

    Glib Konotop

    Director Of Business Development

    Telephone +65 315 949 98

    Address The Signature, 51 Changi Business Park Central 2, Level 04-05, Singapore, 486066
    Other countries
    Meet us in Finland

    Dmytro Naumenko

    Business Development Director for Northern Europe

    Telephone +358145473477

    Address Innova 1, Piippukatu 11, 40100, Jyvaskyla
    Other countries
    Meet us in the Netherlands

    Dmytro Naumenko

    Business Development Director for Northern Europe

    Telephone +3197010280650

    Address c/o Fluwelensingel 27a, 2806 CB Gouda
    Other countries
    Meet us in Germany

    Glib Konotop

    Director Of Business Development

    Telephone +4908995457096

    Address Bahnhofstr. 4a Planegg 82152 Munich, Germany
    Other countries
    Meet us in the UAE

    Johnny Huntington

    Business Development Director (Middle East)

    Telephone +971 058 513 4869

    Other countries

    READ OUR LATEST INSIGHTS

    Get Inspired by our Blog