By using this web site you accept our use of cookies. More information about cookies
Accept
Infopulse - Expert Software Engineering, Infrastructure Management Services
By using this web site you accept our use of cookies. More information about cookies
Accept
Infopulse - Expert Software Engineering, Infrastructure Management Services
Infopulse - Expert Software Engineering, Infrastructure Management Services
reCAPTCHA
Send message Please fill in this quick form and we will send you a free quote shortly.
* Required fields
Your privacy is important to us. We will never share your data.
Subscribe to our updates Be among the first to get exclusive content on IT insights, innovations, and best practices.
* Required fields
Your privacy is important to us. We will never share your data.
Subscribe to our New career opportunities Please fill in this quick form to be among the first to receive our updates.
* Required fields
Your privacy is important to us. We will never share your data.
reCAPTCHA
* Required fields
Your privacy is important to us. We will never share your data.
Photo of Infopulse Send an email to Infopulse Please fill in this quick form to contact our expert directly.
* Required fields
Your privacy is important to us. We will never share your data.
Read the Full Case Study Don't miss the most interesting part of the story!
Submit this quick form to see the rest and to freely access all case studies on our website.
* Required fields
Your privacy is important to us. We will never share your data.
Infopulse - Expert Software Engineering, Infrastructure Management Services

Cloud-Based Corporate Transfer Solution for a Large Pharma Producer

Addressing the transportation issue during the COVID-19 pandemic with a custom application

Client: Large Pharma Producer
Industry: Pharmaceuticals
Location: Ukraine
Employees: 1,000+

Business Challenge

The announcement of the nationwide quarantine due to the COVID-19 pandemic affected the business continuity of our client, one of the biggest producers of medicinal products in Ukraine, and interfered with many internal processes. The strict restrictions on public transport usage limited our client’s employees in terms of available transfer options that could ensure their safety and comply with the quarantine requirements.

To address the transportation challenges and provide a safe alternative, the company initiated a project that would encourage employees who drive their own cars to pick up their colleagues while driving to and from work. The customer turned to Infopulse, as its trusted digital services partner, to assist with the project implementation.

Solution

Infopulse experts implemented a transfer advisor solution built within the Azure cloud environment to match car-owners with employees without cars in the most efficient way based on transfer route preferences:

  • Designed and deployed a cloud-based corporate worker advisor solution;
  • Integrated the solution with SharePoint Online to gain access to the corporate human resource system and enable automated data update, such as work schedule, home addresses, etc.;
  • Ensured seamless data transition between the solution components with Azure Data Factory;
  • Enabled a secure data storage, prompt data retrieval and processing with Azure SQL database;
  • Implemented Azure Maps for computing optimal routes with custom-configured requirements;
  • Utilized Azure Function, a serverless hosting, to enable faster and cost-efficient production;
  • Configured Power BI to ensure service analytics;
  • Provided automated notifications generation and distribution with the LogicApp service.

Technologies: SharePoint Online, Azure Data Factory, Azure SQL, Azure Function, Azure Maps, Power BI, Logic App

Business Value

The corporate transfer solution supplemented the Business Continuity Plan of our client and ensured a safe and secure transportation option for employees without cars. The implemented platform favored the company thanks to the following aspects:

  • A scalable, cost-efficient cloud solution;
  • A high rate of successful routes computed that meet the pre-set requirements: up to 70% of employees without cars are delivered to and from office;
  • Automated e-mail notifications about calculated routes for employees’ direct managers;
  • Enabled visualization of the final routes on the Bing Maps for simpler management;
  • Provided a general overview and analytics on calculated routes and completed and non-completed transfers.

Download Case Study in PDF format