Purushottam R

• Test and Control Methodology:

Advertisement agency conducts promotion of drug at hospitals premises like HCPs waiting rooms, Examination room.. etc to get a attention of HCPs and make them to write more prescriptions for the drug. Annually more than 400 such promotions are done for different drugs at different HCPs locations and such promotions have to be validated for its impact on the claims generated.

Performing Statistical significance test to prove the promotional activities have impact on sales after each new promotional activities, the impact on sales are validated and proven statistically to tell variation in the sales are not by a chance but due to new promotional activities itself.

Considering HCPs who got exposed to program as Test HCPs and similar characteristics Control HCPs are found from our database

• Ancova Model is used to analyze the impact of the program and other covariates
• Provides Sales insights as Monthly claims averages, Lift%, Zero writers, Conversion summary and decile distribution to understand more about the sales between Test and Controls. With statistical results the client can work on their tactics to improve the budget allocations and program effectiveness
• Different performance metrics that drives the business are also calculated like Total Claims, New to Brand claims, New Rx, Continuing Rx, Rejection claims, Reversal claims etc..
• As a custom requests, we closely researched FDA documents for drug administration instruction to build a logics to identify combinational therapy claims, initial loadings, maintenance loading etc..
• Automation of Test and Control process - Created a single automated code that drives the different category of Test and Control methodology
• Analyst need not to worry about the internal process and the analysis of statistical results to choose the best results Help the analyst to run the process with little knowledge
• Execution time of the project reduced by 1/5th of the original time.

• Technology Migration Projects (SAS to R) Helping the client to implement the process in Open Source Environment and to reduce the cost involved for licensed tool Aim to migrate all current SAS process into R environment for accessing new Amazon Redshift Database Validating created R process against current SAS process to ensure the correct migration and data validation within

• Weekly & Monthly NPA reports For tracking brand performance at nation level with different prescriptions type TRx, NRx, NTs, NBRx and Switch/Add-on Volume, Growth, Market Share are captured at brand level as well as Class and Market level Giving an insights about our brand performance against competitors and week by week trend representing New Patients addition in terms of Switch from competitors drug or New Starts KPIs are shown for different time period aggregations 1 week, 4 Weeks, 13 Weeks, 26 Weeks and YTD Also showing Goals, Actuals and attainment prescription behavior for each of our brands Tracking new products trend if any launched in the market to analyze its prescription behavior and growth week by week