SunPharma Prescription System
Analytics platform that processes prescription data for 2024-2025, calculating total and yearly volume for Sun Pharma, the fourth largest global specialty generic pharmaceutical company.
Project Objective
The challenge: Sun Pharma, a global pharmaceutical leader operating in 100+ countries, needed to modernize how medical professionals accessed prescription data and forecasts. The objective: build a system significantly faster than their existing Excel-based workflow while migrating years of existing data. Doctors required instant mobile access to prescription lookups and forecasts, but the Excel-based system was slow, difficult to query, and impractical for mobile devices.
Development Process
01.
Discovery
Analysis of the Excel-based prescription system: data structure, query patterns, mobile usage requirements, and performance bottlenecks. Assessment of migration complexity.
02.
Design
Speed-focused architecture: optimized database schema for instant lookups, mobile-first interface, advanced search and filtering, and forecast visualization dashboard.
03.
Launch
Phased Excel data migration using Python with specialized libraries. Zero downtime with complete data validation. Sub-second response times replacing the previous workflow.
Deliverables
Technology Stack
Next.js
React
Golang
PostgreSQL
Python