Project for Bayer

Implementation of a secondary sales processing system in 14 days


Task
An easy and convenient system to process secondary sales data
Timing
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

Results in figures

10

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

60

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

50

users

Feedback

«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

Sotex «PharmFirm»
Data import automation, secondary sales analysis
NovaMedica
Field sales monitoring
AKRIKHIN
BI-based comprehensive analysis of the company activities
Unipharm
CRM-based management of medical representatives
Petrovax Pharm
Implementation of Navicon Pharma CRM: the industry-specific CRM solution
AstraZeneca
Navicon Pharma TDC: automated management of secondary sales
Ipsen
Automation of sales planning with IBM Cognos Express
EVER Neuro Pharma
An ERP solution rollout on Microsoft Dynamics AX
CV PROTEK
Advanced budgeting capabilities for the pharmaceutical industry
Novartis
Secondary sales analysis with Navicon Pharma TDC
Dräger
Full-scale automation of corporate activities