Case Study
POM360
A Versatile Pharmacy Order Management & Customer Service System
For a Leading Pharmacy Chain, UK
Client Background
- Client is a large pharmaceutical company having global operations across multiple countries. The client manufacturers, distributes and sell the pharmaceutical and cosmetic products across several countries globally.
- The client was looking for a comprehensive software solution for managing orders, customer service functions, and generating operational, MIS & executive reports.
Business Challenges & Needs
- End client was facing order fulfillment issues, customer service glitches, and was not happy with the performance of legacy system.
- There were SKU /Product Identification Code related errors causing incorrect product assignment leading to customer grievances and ineffective operations.
- Overall product development and schema needed continuous monitoring & managing; involvement of new activities & data structures were required to be added.
Solution Overview
- Cognisun team reverse engineered the legacy system; carried out in-depth exercise of analyzing the client requirements, shortcomings of the legacy system and conducted JAD sessions with business stakeholders to understand their wish list.
- Corrected the data modeling schema and migrated the legacy system data into the newly redefined database schema.
- Developed comprehensive and versatile web application to facilitate order management, order fulfillment, purchase order and customer service processes. The product is also backed up with versatile reporting module.
Key Technologies
PHP
MySQL
Bootstrap
jQuery
Linux
Highlights & Benefits
Solution Highlights
- Designed a flexible, effective and scalable database schema for ease of future maintenance and enhancements
- Easy to use, responsive and intuitive user interface compatible across various browsers, devices and screen resolutions.
- Scheduled Cron jobs running round the clocks for efficient data mining and processing.
Business Benefits
- Efficient order fulfillment cycle leading to better customer satisfaction and increased sale.
- Ease of maintenance and future enhancement.
- Cost saving due to reduced dependencies on the third party vendors.
Global Presence
