Problem:
A leading automobile parts distributor in Australia needed a centralized Offer Builder system to streamline the creation of complex customer offers. The existing process relied on data collation across multiple internal systems, creating delays, limited visibility into pricing and inventory, and concerns around offer accuracy.
An internally developed legacy platform from 2018 also struggled with low adoption due to complicated UX flows, poor accessibility, slow performance, frequent outages, weak error handling, and an aged codebase that limited enhancements. Delays in reporting further impacted operational efficiency.
Approach:
Centralized Offer Builder Application
- Developed a centralized Offer Builder application to automate and streamline customer offer creation
- Aggregated product, pricing, and inventory data from multiple internal systems into a unified platform
- Automated offer generation using configurable business rules and real-time inventory availability
- Implemented validation mechanisms to improve offer accuracy and completeness
- Introduced monitoring and alerting capabilities for faster issue detection and resolution
UX and Workflow Modernization
- Redesigned the legacy platform experience to improve usability, accessibility, and operational efficiency
- Replaced Excel-driven workflows with highly dynamic mud mapping capabilities
- Revamped the offer creation flow and SKU selection process to simplify user interaction
- Integrated Deadline Management at event level for improved operational tracking
- Implemented role-based access controls to improve governance and user management
Configurable Business Extracts/ app integrations
- Enabled on-demand generation of operational extracts directly within the platform to support faster commercial decision-making
- Reduced dependency on delayed external reporting systems by providing immediate access to operational datasets
- Generated SKU-level inventory viability outputs and detailed event-level offer extracts
- Automated creation of structured downstream files for Website and POS platform integrations
- Supported pre-sales planning and execution through configurable operational data outputs
Platform Engineering & Cloud Modernization
- Migrated hundreds of GB of data from on-premises systems to Azure PostgreSQL using custom SSIS packages with high data integrity and minimal downtime
- Automated package deployment and execution on client VMs using Bash scripts, improving reliability and reducing manual effort
- Designed and implemented scalable Azure infrastructure and CI/CD pipelines using reusable Bicep modules across multiple environments
- Built a secure cloud-native ecosystem including Function Apps, Web Applications, PostgreSQL, API Management, Service Bus, Redis, and Key Vault
- Implemented private networking, managed identity-based access controls, automated monitoring, and alerting frameworks to improve security and operational reliability
Impact:
Business Outcomes
- Reduced offer creation time by approximately 71% through centralized data aggregation and workflow automation
- Improved offer review efficiency by approximately 60% through streamlined workflows and optimized UX
- Enhanced operational decision-making through centralized visibility and immediate access to operational datasets
- Improved platform scalability, reliability, and maintainability through cloud modernization initiatives
Performance Improvements
- Reduced average offer load time from 20-50 minutes to 5-10 minutes, improving performance by nearly 75%
- Improved average offer review time from 10 minutes to 4 minutes, reducing review effort significantly
- Increased average weekly platform logins from 3.5 to 8, driving a 129% increase in user engagement
The modernization initiative transformed the Offer Builder into a faster, more reliable, and widely adopted platform capable of supporting complex customer offer workflows at scale while enabling efficient pre-sales execution and operational agility.
