PreludeSys helped a leading California-based medical nutrition company modernize its manual data handling process for greater flexibility and improved business operations.
About the client
The client is a medical nutrition company that offers high-standard enteral formulae. Their plant-based formula is designed to improve tolerance with organic ingredients. They serve thousands of patients suffering from severe chronic diseases to less serious medical issues.
Client requirement
- The lack of a unified distributor onboarding process led to difficulties viewing orders and managing supplier performance.
- The manual data formatting and validation process was time-consuming and led to many data quality issues and rework.
- The existing system had limited flexibility to adopt changes in business logic.
- The customer had to pay for high maintenance workflows due to distributor-specific SSIS packages.
- The SSIS on-premises and SQL DB on the cloud made the client pay additional maintenance charges.
Solution
- The dynamic field mapping enabled them to gather and visualize distributor-wise input data
- PreludeSys optimized the workflows with the removal of redundant data staging steps
- Our experts simplified configuration setup for data validation and allocation logic
- Error logging with custom notifications at the data row level
Benefits
- Modernized to Pay-as-You-Go architecture model
- Simplified the process of onboarding new distributors (input data format)
- Reduced manual intervention in the entire business workflow
- Controlled allocation logic with quick adoption of changes
- Reduced maintenance costs involved in the SSIS setup
Technology
Azure Storage Account, Data Factory, Logic Apps, SQL DB & Power BI