vsm pharma services - case study

Doctor data de-duplication and doctor profiling

VSM Software (P) Ltd“Not just software. Total business solutions”.

”Not Just Software. Total Business Solutions”

• Doctor Profiling is a very important exercise for any pharma company because a company wants to constantly re evaluate the potential and penetration of the doctor/HCPs it caters to.

• We have also seen that there are times when the same doctor would be called on by MRs across two or more divisions.

• This results in duplication within the database and hence the actual potential of the doctor cannot be evaluated.

Introduction

”Not Just Software. Total Business Solutions”

Process of De - Duplication

Step 1

Step 2

One time Clean up and completion of

existing records

Ongoing maintenance of the

database

2 step process

To address this, the data needs to be cleaned, de-duplicated and completed, so that a unique set of customers is available. This is done by us as follows

”Not Just Software. Total Business Solutions”

Process of De - DuplicationStep 1: One time Clean up and completion of existing records

Step 2: Ongoing maintenance of the database

Data Import

Data Cleanin

g

Data Validati

on

Data Complet

ion

Database update on a periodic basis

Validate against the existing database to avoid duplicates

Card Reader Application to help complete the Doctor Information

Automated De Duplication tool to clean up the database.

”Not Just Software. Total Business Solutions”

• Evaluate the actual doctor spend by the company

• Identify Loyalist doctors (doctors who have been prescribing multiple brands of the company)

• Gives a clear indication of which doctors can move from single brand prescription to multi brand prescription

• A unique list of completed information on doctors which can be used for segmentation and classification purposes.

• Combining with Rx information the results can also be analyzed to arrive at the doctor potential and penetration

Benefits of doctor de duplication and doctor profiling

”Not Just Software. Total Business Solutions”

Contact Us

Address: VSM Software Pvt. Ltd. #8, High Tension Park Road, Chandra Layout, Bangalore 560040Phone:: 080 – 42982121 Email: poornimarajan@vsmsoftware.com Website: www.vsmsoftware.com

Find us through our digital profiles!