← Back to Projects

Wukong - Big Data Pharma Distribution Management System

DEPLOYED: 01/08/2025

Project Overview

A one-stop pharmaceutical distribution data governance platform built on a big data architecture. It addresses the challenges of data fragmentation and analysis latency in the China region, enabling real-time monitoring and intelligent analysis of sales data for large-scale pharmaceutical enterprises.

Industry Pain Points

Data Fragmentation & Integration Difficulty

Sales data is scattered across various distributors and channels with inconsistent formats. Manual aggregation is inefficient and prone to errors, making it difficult to form a unified view of the market.

Analysis Latency

Traditional systems struggle to process tens of millions of sales records efficiently, leading to significant delays in business reporting and missed decision-making windows.

Lack of Standardization

The absence of unified master data standards for drugs, institutions, and personnel hinders effective data asset management and cross-dimensional analysis.

Innovative Solution

Core Methodology

The system establishes a closed-loop data governance framework:

  1. Unified Data Ingestion: Automated collection and cleaning of flow data from multiple sources.
  2. Master Data Management (MDM): rigorous standardization of core data dimensions (Products, Hospitals, Representatives).
  3. Intelligent Analytics: Real-time calculation of sales metrics with automated appeal handling workflows.
System Architecture
Figure 1. Big Data System Architecture
Management Dashboard
Figure 2. Unified Management Dashboard

Technical Implementation

  • High-Performance Architecture: Adopting Spring Cloud microservices backend combined with Spark for big data processing to ensure scalability.
  • Hybrid Storage Layer: Utilizing PostgreSQL for relational data, Elasticsearch for high-speed search, and Redis for caching.
  • Enterprise-Grade Security: Implementing Shiro + JWT for robust access control and data security.
  • Observability: Integrated Prometheus + Grafana for real-time system monitoring.
Data Analysis Visualization
Figure 3. Intelligent Sales Data Analysis
Data Detail View
Figure 4. Detailed Data Management Interface

Value Delivered

  • Massive Data Processing: Successfully achieved real-time processing capability for over 10 million flow data records.
  • Efficiency Leap: Through digital transformation, operational costs were reduced, and overall management efficiency improved by more than 40%.
  • Standardization: Established a unified data standard system, transforming raw data into valuable corporate assets.