Standardized the data sets provided by different specialty pharmacies for the status and dispense data. Built the code and logic to automate the calculation of statuses of the patients based on certain business rules. Standard KPI metrics like counts, fills, time to fill, % conversion, adherence and persistency of cohorts of patients were standardized and automated as per the customized business rules