INTELERA || Digital Transformation

Back to Case Studies

Industry

Healthcare / Medical Equipment

Product

Order Management System (OMS)
Enhancement

Technology Stack

ReactJS

HTML5

CSS3

Bootstrap4

Redux

NodeJS

MongoDB

Twilio

Push Notifications

Grafana

Snowflake

Quick Summary

The client, a leading medical equipment supplier based in the USA, faced challenges with a manual, error-prone process for extracting and managing orders from a complex database. IntelERA developed a digital solution that automated data extraction, implemented an instant alert feature for sales teams, and improved the overall order management system, leading to increased business growth and efficiency.

Problem Definition / Challenges

The manual process of extracting data from a complex Snowflake database into XLS files daily was time-consuming and error-prone, requiring a 4-person team.
The existing Order Management System lacked an alert feature, causing delays and requiring sales personnel to manually check for updates, leading to missed orders.
The absence of a secure digital platform hindered 24/7 access to critical order information.
The manual processes contributed to inefficiencies and missed opportunities, impacting overall business performance.

Our Approach / Solution

IntelERA developed and implemented a comprehensive digital solution, transforming the client's manual workflows and improving efficiency across various operations. The process included the following steps:

Data Extraction and Automation:

We automated the process of pulling over 3000 required records monthly from the complex Snowflake database. The system seamlessly synced data, eliminating the need for manual intervention and ensuring accurate, real-time data availability.

Custom Dashboard Development:

Our team built insightful, user-friendly dashboards for both the client and their sales team. These dashboards provided a centralized view of all relevant data, improving decision-making and visibility into order status.

Order Management System Enhancement:

We enhanced the existing Order Management System (OMS) by integrating an instant alert feature. This allowed sales personnel to receive automated notifications for any updates, reducing the need for them to manually check for order status and increasing operational efficiency.

Web Application for Sales Team Management:

A robust web application was developed to manage over 150 sales team members. This application provided easy access to order information and allowed sales representatives to update order details on-the-go.

Alert System Implementation:

We introduced a seamless alert mechanism that triggered over 500 daily notifications via email and SMS to ensure that sales personnel were immediately notified of order changes. This feature reduced manual follow-ups and streamlined communication. Additionally, we configured over 50 notification templates for customized email and SMS alerts.

The Result

Turnaround Improvement:

A 50% improvement in turnaround time, contributing to a 20% annual growth in business.

Cost Savings:

A cost savings equivalent to 1,600 hours of manual work per month.

Order Closures:

A 25% increase in weekly order closures due to the instant alert feature.

Customer Retention:

Enhanced customer service and stronger brand value, leading to a 15% increase in business from existing customers.

Continuous Improvement:

Continuous improvements through Agile/Scrum principles, ensuring the solution evolves with business and client needs, resulting in quarterly feature releases and a 30% reduction in time-to-market for new features.