Pharma Business Automation Web Platform Development [Case Study]

• The client received a web application that integrates all key business operation processes with data and product-management features.
• The client was introduced to simplified data management and order-processing workflows.
• The client reported increased financial performance due to faster order processing and shipment. 
• TATEEDA GLOBAL’s efforts resulted in new opportunities for the client to acquire more business partners.

TATEEDA GLOBAL was hired by the client, a Canadian pharmaceutical business, to design and build a web-based application/system to automate the processes of ordering, processing, and shipping prescription drugs for the client’s partners within the U.S. and achieve higher efficiency within their own staff in Canada.

Project Abstract

TATEEDA GLOBAL was hired to deliver a custom web-based application intended to automate and facilitate a number of business processes for a pharma product vendor. This included ordering, processing, and shipping of prescription drugs to local U.S. corporations and distributors.

Project Mission

To help the client get rid of many obsolete technologies while implementing an up-to-date software solution to facilitate existing practices and achieve better business results.  

Challenges Faced by the Client  

• Manual product database management with Excel spreadsheets 
• Manual client database management 
• Use of multiple applications for processing prescriptions, converting to U.S. equivalents, shipping orders, and tracking 
• Time-consuming manual report generation 
• Manual tracking of company operations (cost, revenue, and profits) with Excel spreadsheets. 

Project Goals

• Create a centralized database of patients, prescriptions, and orders. 
• Differentiate management of the application according to roles within the organization. 
• Implement automation of processes.
• Integrate web application with postal services. 
• Add order-tracking records. 
• Build historical reports. 
• Create automated financial reports: calculate cost of shipment and products plus revenue and profit. 
• Create a one-stop application for all business operations and financial reports.

TATEEDA GLOBAL delivered the following: 

• Created a centralized database of patients, prescriptions, clients, and shipping orders
• Created visual dashboards for pharmacists, eligibility managers, case managers, and doctors 
• Automated the process of entering U.S. prescriptions into the system 
• Conversion of U.S. prescriptions to their Canadian equivalents 
• Automated the process of physician authorization and verification  
• Automated processing and shipping of orders 
• Automated calculation of pricing for different partners 
• Integrated web app with the Canadian postal service 
• Automated the creation of shipping labels
• Automated the process of the prescription shipping and delivery 
• Built historical and financial reports. 

Tech

• .NET 5
• Angular 9 

Agile/Other

• Jira
• Scrum

• The client’s web application integrated all business operation processes, including data and product management, thereby gaining multiple benefits and facilitations. 
• The client reported significant improvement in their financial performance, thanks to optimized order processing and shipment. 
• The client obtained new opportunities to acquire more business partners in the U.S.