Project for Bayer

Implementation of a secondary sales processing system in 14 days

An easy and convenient system to process secondary sales data
2 weeks

Project goals

Reduce the time spent on consolidating, processing and cleansing the data coming from distributors and pharmacy chains
Check the accuracy of the data provided by pharmacy chains
Analyse the secondary sales point-by-point
Assess medical representatives' efficiency
Track the stock balance at distributors' warehouses
Analyse the data by regional branches
Compare regional plans with actual sales
Keep obtaining up-to-date information on secondary sales

Project features

The use of Microsoft SQL Server MDS (Master Data Services) to manage reference data
Consolidating the data from distributors' reports with the CRM data
The use of Pyramid Analytics system for data visualisation
Record timing (2 weeks)
Flexible possibilities for solution scaling


Results in figures


The time required to prepare sales reports has been reduced to 10 minutes
Results in figures


distributors' reports and 90 pharmacy reports are processed every day
Results in figures




«The implemented system has allowed us to significantly cut expenses and reduce the amount of time spent on secondary sales data and stock balance data consolidation. When we were processing information manually, it would take about half an hour to standardise one report, now it takes 5-10 minutes. One just needs to indicate the logic of data storage in a report, after which the system will automatically load all the reports of similar structure. We have appreciated the professionalism and high quality of work of Navicon experts and are planning to continue our collaboration»
Natalya Lastochkina, controller-analyst at Bayer prescription department in Russia

Other sector projects

Full-scale automation of corporate activities
Sotex «PharmFirm»
Data import automation, secondary sales analysis
Data warehouse and BI implementation
CRM-based management of medical representatives
BI-based comprehensive analysis of the company activities
Advanced budgeting capabilities for the pharmaceutical industry
CRM-based automation of pharmaceutical field force
EVER Pharma
An ERP solution rollout based on Microsoft Dynamics AX
Secondary sales analysis with Navicon Pharma TDC
Automation of sales planning with IBM Cognos Express
Petrovax Pharm
Implementation of Navicon Pharma CRM: the industry-specific CRM solution
Navicon Pharma TDC: automated management of secondary sales