Project for Sotex «PharmFirm»

Data import automation, secondary sales analysis


Task
Consolidate and analyse the data on distributors' sales
Closing date
November 2012

Project goals

Speed up the import and cleansing of secondary sales data
Ensure timely analysis of the gathered data
Analyse the secondary sales up to the final salespoint
Increase the level of detail of the reports
Reduce the time required to process regular reports
Promptly analyse the stocks for various products
Consolidate the sales data from the distributors' reports

Project features

Automated processes of secondary sales data import, cleansing and normalization
The support of reports in any format
The automatic cross-check of postal address lines with KLADR (the official Russian state address database)

Results

Results in figures

1

hour to process daily reports
Results in figures

3

days to process monthly reports
Results in figures

1

hour to process weekly reports

Feedback

«We chose Navicon after an event held by the company where we could appreciate its specialists' expertise in the pharmaceutical industry. Besides, Navicon has its own solution which automates the processing of secondary sales data. That said, the solution had already proved successful in practice. This helped us to significantly reduce the project duration».
Andrey Smirnov, Head of Analysts Department at Sotex «PharmFirm»

Other sector projects

Bayer
Implementation of a secondary sales processing system in 14 days
Unipharm
CRM-based management of medical representatives
AstraZeneca
Navicon Pharma TDC: automated management of secondary sales
NovaMedica
Field sales monitoring
Petrovax Pharm
Implementation of Navicon Pharma CRM: the industry-specific CRM solution
Dräger
Full-scale automation of corporate activities
EVER Pharma
An ERP solution rollout based on Microsoft Dynamics AX
Ipsen
Automation of sales planning with IBM Cognos Express
CV PROTEK
Advanced budgeting capabilities for the pharmaceutical industry
Novartis
Secondary sales analysis with Navicon Pharma TDC
R-Pharm
Data warehouse and BI implementation
AKRIKHIN
BI-based comprehensive analysis of the company activities