Healthcare sector

Maximizing savings by streamlining the procurement of medication across the hospital network

CUSTOM BACKEND BIG DATA

Creating a new version of an existing stock control solution, to process millions of medical records from external supplying systems within seconds?
Challenge Accepted!

Maximizing savings by streamlining the procurement of medication across the hospital network

Our client wanted to upgrade their existing stock control system for better efficiency and extended capabilities for importing, storing, and synchronizing data between the platform and external systems.

Through the streamlined management of product stocks, while following business best practices and government regulations, the client was able to make substantial savings. Group purchases of medication allowed them to channel more funds towards providing better quality care for patients.

Process & Story

Problem

The client needed a system that would maximize savings by optimizing product purchases through better control of stocks, the application of business rules, and full compliance with government regulations. It involved importing, storing, and processing millions of supply records from multiple external systems.

Most importantly, records in the system needed to be updated in real-time. This can be increasingly challenging with the growth of big data. Because the existing solution was entirely based on SQL Server Integration Services, it had some limitations. New and more complex business rules, along with constant data growth, forced our client to reach for a new approach.

Solution

The existing solution was upgraded to one based on microservices and leveraging the cloud. The goal for the new version was to create a solution that is testable, easy to maintain, and performs well under huge loads. Because the processing flow consists of particular ‘steps’, we separated existing logic and created a microservice for each one.

Data from files is divided into chunks that are sent and processed between services. However, they can’t be processed completely independently as records are connected to logical sets. To fulfill that requirement, we developed an internal balancer that ensures messages are processed within the logical sets and with respect to given resources such as a database.

The new system is much more efficient and easier to develop and maintain. The onboarding process for new clients is also now much easier and faster.

Case Study Schema Maximizing savings by streamlining the procurement of medication across the hospital network

Tools

Azure

Azure

C#

C#

.Net"

.Net"

MSSQL

MSSQL

Azure Functions

Azure Functions

Service Bus

Service Bus

Have a similar project in mind?

LET'S TALK!

Challenges

Ingesting data from multiple sources
It was prerequisite that the system quickly integrates new data sources. We unified the way incoming data is processed by standardizing the format and excluding differences in configuration modules.

Rapid processing speed is essential
The client needed to process data in seconds or minutes instead of hours and days. Compared to the old approach, we achieved almost real-time data processing speeds.

Missing data and errors
To more efficiently handle the huge amounts of ingested data and avoid potential processing issues (missing data, errors in code), we needed to implement a pre-processing stage. This allowed us to separate actual data processing from ingestion. First, the raw data is sent to a database, and only then it’s queued for pre-processing. In case of any issues in the pre-processing stage, we can quickly resume processing – starting from the records which generated issues, which saves a lot of time in the process.

Monitoring the system and correlating events
Proper monitoring is a must for a system that processes such amounts of data. We introduced complex logging and monitoring tools so the system can be tracked in terms of general usage, numbers of exceptions, or even rows processed by a particular service. The alerting system handles unusual situations and sends proper notifications.

Our other projects:

Insurance Sector

Auto Insurance Fraud Claim Detection

Developing an AI model that can detect car insurance fraud based on car accident claims?
Challenge Accepted!

Fraud Detection Predictive Modeling

Fintech Sector

Loan Application Fraud Detection

Developing a model that can identify fraudulent loan applications for a financial institution?
Challenge Accepted!

Fraud Detection Predictive Modeling

Fintech Sector

Predicting Bank Loan Defaults for Profit Maximization

Developing an AI model for loan default prediction and using it to increase bank profits?
Challenge Accepted!

Predictive Modeling

See more projects

This site uses cookies for analytical purposes.

Accept Privacy Policy

In the interests of your safety and to implement the principle of lawful, reliable and transparent processing of your personal data when using our services, we developed this document called the Privacy Policy. This document regulates the processing and protection of Users’ personal data in connection with their use of the Website and has been prepared by Nexocode.

To ensure the protection of Users' personal data, Nexocode applies appropriate organizational and technical solutions to prevent privacy breaches. Nexocode implements measures to ensure security at the level which ensures compliance with applicable Polish and European laws such as:

  1. Regulation (EU) 2016/679 of the European Parliament and of the Council of 27 April 2016 on the protection of natural persons with regard to the processing of personal data and on the free movement of such data, and repealing Directive 95/46/EC (General Data Protection Regulation) (published in the Official Journal of the European Union L 119, p 1); Act of 10 May 2018 on personal data protection (published in the Journal of Laws of 2018, item 1000);
  2. Act of 18 July 2002 on providing services by electronic means;
  3. Telecommunications Law of 16 July 2004.

The Website is secured by the SSL protocol, which provides secure data transmission on the Internet.

1. Definitions

  1. User – a person that uses the Website, i.e. a natural person with full legal capacity, a legal person, or an organizational unit which is not a legal person to which specific provisions grant legal capacity.
  2. Nexocode – NEXOCODE sp. z o.o. with its registered office in Kraków, ul. Wadowicka 7, 30-347 Kraków, entered into the Register of Entrepreneurs of the National Court Register kept by the District Court for Kraków-Śródmieście in Kraków, 11th Commercial Department of the National Court Register, under the KRS number: 0000686992, NIP: 6762533324.
  3. Website – website run by Nexocode, at the URL: nexocode.com whose content is available to authorized persons.
  4. Cookies – small files saved by the server on the User's computer, which the server can read when when the website is accessed from the computer.
  5. SSL protocol – a special standard for transmitting data on the Internet which unlike ordinary methods of data transmission encrypts data transmission.
  6. System log – the information that the User's computer transmits to the server which may contain various data (e.g. the user’s IP number), allowing to determine the approximate location where the connection came from.
  7. IP address – individual number which is usually assigned to every computer connected to the Internet. The IP number can be permanently associated with the computer (static) or assigned to a given connection (dynamic).
  8. GDPR – Regulation 2016/679 of the European Parliament and of the Council of 27 April 2016 on the protection of individuals regarding the processing of personal data and onthe free transmission of such data, repealing Directive 95/46 / EC (General Data Protection Regulation).
  9. Personal data – information about an identified or identifiable natural person ("data subject"). An identifiable natural person is a person who can be directly or indirectly identified, in particular on the basis of identifiers such as name, identification number, location data, online identifiers or one or more specific factors determining the physical, physiological, genetic, mental, economic, cultural or social identity of a natural person.
  10. Processing – any operations performed on personal data, such as collecting, recording, storing, developing, modifying, sharing, and deleting, especially when performed in IT systems.

2. Cookies

The Website is secured by the SSL protocol, which provides secure data transmission on the Internet. The Website, in accordance with art. 173 of the Telecommunications Act of 16 July 2004 of the Republic of Poland, uses Cookies, i.e. data, in particular text files, stored on the User's end device.
Cookies are used to:

  1. improve user experience and facilitate navigation on the site;
  2. help to identify returning Users who access the website using the device on which Cookies were saved;
  3. creating statistics which help to understand how the Users use websites, which allows to improve their structure and content;
  4. adjusting the content of the Website pages to specific User’s preferences and optimizing the websites website experience to the each User's individual needs.

Cookies usually contain the name of the website from which they originate, their storage time on the end device and a unique number. On our Website, we use the following types of Cookies:

  • "Session" – cookie files stored on the User's end device until the Uses logs out, leaves the website or turns off the web browser;
  • "Persistent" – cookie files stored on the User's end device for the time specified in the Cookie file parameters or until they are deleted by the User;
  • "Performance" – cookies used specifically for gathering data on how visitors use a website to measure the performance of a website;
  • "Strictly necessary" – essential for browsing the website and using its features, such as accessing secure areas of the site;
  • "Functional" – cookies enabling remembering the settings selected by the User and personalizing the User interface;
  • "First-party" – cookies stored by the Website;
  • "Third-party" – cookies derived from a website other than the Website;
  • "Facebook cookies" – You should read Facebook cookies policy: www.facebook.com
  • "Other Google cookies" – Refer to Google cookie policy: google.com

3. How System Logs work on the Website

User's activity on the Website, including the User’s Personal Data, is recorded in System Logs. The information collected in the Logs is processed primarily for purposes related to the provision of services, i.e. for the purposes of:

  • analytics – to improve the quality of services provided by us as part of the Website and adapt its functionalities to the needs of the Users. The legal basis for processing in this case is the legitimate interest of Nexocode consisting in analyzing Users' activities and their preferences;
  • fraud detection, identification and countering threats to stability and correct operation of the Website.

4. Cookie mechanism on the Website

Our site uses basic cookies that facilitate the use of its resources. Cookies contain useful information and are stored on the User's computer – our server can read them when connecting to this computer again. Most web browsers allow cookies to be stored on the User's end device by default. Each User can change their Cookie settings in the web browser settings menu: Google ChromeOpen the menu (click the three-dot icon in the upper right corner), Settings > Advanced. In the "Privacy and security" section, click the Content Settings button. In the "Cookies and site date" section you can change the following Cookie settings:

  • Deleting cookies,
  • Blocking cookies by default,
  • Default permission for cookies,
  • Saving Cookies and website data by default and clearing them when the browser is closed,
  • Specifying exceptions for Cookies for specific websites or domains

Internet Explorer 6.0 and 7.0
From the browser menu (upper right corner): Tools > Internet Options > Privacy, click the Sites button. Use the slider to set the desired level, confirm the change with the OK button.

Mozilla Firefox
browser menu: Tools > Options > Privacy and security. Activate the “Custom” field. From there, you can check a relevant field to decide whether or not to accept cookies.

Opera
Open the browser’s settings menu: Go to the Advanced section > Site Settings > Cookies and site data. From there, adjust the setting: Allow sites to save and read cookie data

Safari
In the Safari drop-down menu, select Preferences and click the Security icon.From there, select the desired security level in the "Accept cookies" area.

Disabling Cookies in your browser does not deprive you of access to the resources of the Website. Web browsers, by default, allow storing Cookies on the User's end device. Website Users can freely adjust cookie settings. The web browser allows you to delete cookies. It is also possible to automatically block cookies. Detailed information on this subject is provided in the help or documentation of the specific web browser used by the User. The User can decide not to receive Cookies by changing browser settings. However, disabling Cookies necessary for authentication, security or remembering User preferences may impact user experience, or even make the Website unusable.

5. Additional information

External links may be placed on the Website enabling Users to directly reach other website. Also, while using the Website, cookies may also be placed on the User’s device from other entities, in particular from third parties such as Google, in order to enable the use the functionalities of the Website integrated with these third parties. Each of such providers sets out the rules for the use of cookies in their privacy policy, so for security reasons we recommend that you read the privacy policy document before using these pages. We reserve the right to change this privacy policy at any time by publishing an updated version on our Website. After making the change, the privacy policy will be published on the page with a new date. For more information on the conditions of providing services, in particular the rules of using the Website, contracting, as well as the conditions of accessing content and using the Website, please refer to the the Website’s Terms and Conditions.

Nexocode Team