I recognized an opportunity to save $150K/ year and enable future growth
Took initiative to develop the company ETL platform to save cost and removed the barrier to onboarding of the new smaller accounts.
My employer was using a few data integrator service provider to manage the related transactions that were taking place in different systems.
The nature of the 3PL branch of the business required level of flexibility to support a growing number of small accounts.
The licence structure and price model from service providers, was making their services financially less attractive for the smaller accounts while larger accounts were still generating a significant ongoing cost.
Customization projects were time consuming and expensive.
In house solution developed using Microsoft PowerAutomate Desktop, Microsoft Azure, Microsoft Power Query and Microsoft SharePoint
Providing consolidation and interchange solution platform between NetSuite, Shopify, 2Ship
Event and log based notification system
Interactive monitoring solution
Saving 150K/ year
Expanded total available market by removing the onboarding barrier for smaller size accounts
No incremental cost to existing operational cost
Rapid deployment and support for future projects