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

Share With Us Your Blockchain Case!
Get a Free Consultation!
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.

    Contacts

    Meet us in
    the UK

    Aleksey Zavgorodniy
    Chief Executive Officer
    Telephone
    Address
    2nd Floor, 6 Market Place, London, Fitzrovia, W1W 8AF
    Out of stock system for drugstore Out of stock system for drugstore

    Meet us in
    Cyprus

    Aleksey Zavgorodniy
    Chief Executive Officer
    Address
    Georgiou A', 14, Office 15, Potamos Germasogeias, 4047, Limassol
    Out of stock system for drugstore Out of stock system for drugstore

    Meet us in
    Singapore

    Glib Konotop
    Director Of Business Development
    Telephone
    Address
    The Signature, 51 Changi Business Park Central 2, Level 04-05, Singapore, 486066
    Out of stock system for drugstore Out of stock system for drugstore

    Meet us in
    Finland

    Dmytro Naumenko
    Business Development Director for Northern Europe
    Telephone
    Address
    Innova 1, Piippukatu 11, 40100, Jyvaskyla
    Out of stock system for drugstore Out of stock system for drugstore

    Meet us in
    the Netherlands

    Dmytro Naumenko
    Business Development Director for Northern Europe
    Telephone
    Address
    c/o Fluwelensingel 27a, 2806 CB Gouda
    Out of stock system for drugstore Out of stock system for drugstore

    Meet us in
    Germany

    Glib Konotop
    Director Of Business Development
    Telephone
    Address
    Bahnhofstr. 4a Planegg 82152 Munich, Germany
    Out of stock system for drugstore Out of stock system for drugstore

    Meet us in
    the USA

    Glib Konotop
    Director Of Business Development
    Telephone
    Out of stock system for drugstore Out of stock system for drugstore

    Meet us in
    Denmark

    Jawahar Lal Matu
    Regional Director
    Telephone
    Address
    Tuborg Boulevard 9, 1tv, 2900 Hellerup/ Copenhagen, Denmark jmatu@siac.dk
    Out of stock system for drugstore Out of stock system for drugstore

    Meet us in
    Ukraine

    Aleksey Zavgorodniy
    Chief Executive Officer
    Telephone
    Address
    39 Ivana Kudri str, office 11, Kyiv 01042
    Out of stock system for drugstore Out of stock system for drugstore