+49 (800) 100-68-68
Close
Project for Novartis

Secondary sales analysis with Navicon Pharma TDC


Task
Automate the import, cleansing, and standardizing of secondary sales data
Solution
Navicon Pharma TDC
Timing
5 months

Project goals

Ensure prompt analysis of the secondary sales and leftover stocks on all of the company distributors
Adequately estimate the market demand for the products supplied to Russia
Plan the sales and purchases optimally
Figure out the bonuses for the sales reps

Project features

Three Microsoft SQL Server modules have been utilized: Master Data Services, Integration Services, Server Reporting Services
The project included integration with the local data warehouse
The system has been tested and documented in accordance with the project management routine accepted in Novartis

Results

Results in figures

2

The system became functional 2 months after the implementation had started
Results in figures

20

The solution allows to analyse the reports from over 20 distributors
Results in figures

50

users

Other sector projects

NovaMedica
Field sales monitoring
AstraZeneca
Navicon Pharma TDC: automated management of secondary sales
Petrovax Pharm
Implementation of Navicon Pharma CRM: the industry-specific CRM solution
R-Pharm
Data warehouse and BI implementation
R-Pharm
CRM-based automation of pharmaceutical field force
AKRIKHIN
BI-based comprehensive analysis of the company activities
CV PROTEK
Advanced budgeting capabilities for the pharmaceutical industry
Sotex «PharmFirm»
Data import automation, secondary sales analysis
Unipharm
CRM-based management of medical representatives
EVER Pharma
An ERP solution rollout based on Microsoft Dynamics AX
Merz Pharma
The consolidation and analysis of the Russian branch's distribution network data by Navicon TDC
Ipsen
Automation of sales planning with IBM Cognos Express