Product Information Management System (PIMS) for Australia’s Largest Pharmacy Retailer
Ray Business Technologies’ experience in delivering enterprise applications was trusted by Australia’s largest pharmacy retailer with stores all over Australasia, with the goal of improving customers’ healthcare outcomes through the most effective and efficient means, resulting in significant savings to the end user. The “PIMS Ireland” project was implemented for our retail client in Ireland to replace the existing Product and Vendor Master synchronization mechanism between the cloud-based Product Information Management System (PIMS) and ERP system with a faster and more streamlined ecosystem.
Executive Summary
Client required a robust centralized integration platform with guaranteed message delivery, high volume data handling, and secure communication capabilities as part of Product Information Management System (PIMS) to handle critical data flow between cloud-based ERP system (Microsoft Dynamics 365 Finance & Operations) and MS database (Microsoft Azure SQL Server).
Ray Business Technologies subject matter experts collaborated closely with stakeholders to understand the application’s business requirements. The modules were designed by the RBT team to be highly usable and to the satisfaction of the end users. This increased the company’s profit margins.
Challenges
· Our Retail Client maintains Products, Trade Agreements, and other related information in the PIMS Database, as well as Vendor Master records in Microsoft Dynamics 365 Finance & Operations.
· Highly critical Product Master data, such as Product Dimensions, Barcodes, Sales/Purchase Trade Agreements, Prepack, DimensionUOM, and so on, must be available in Microsoft D365 Finance & Operations end system, and Vendor Master data must be available in PIMS, resulting in multiple integration touch points.
· The need of the hour was for a dependable integration middleware that can handle streamlined, secure, and performance effective data transfer between the mentioned end systems with zero data loss, bulk processing capability, and robust error handling.
