Project for Novartis
Secondary sales analysis with Navicon Pharma TDC
Task
Automate the import, cleansing, and standardizing of secondary sales data
Solution
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