Badges
Certifications
harish87nikam has not earned any certificates yet.
Work Experience
Associate Consultant
IQVIA• October 2021 - Present
Skills: Microsoft SQL Server, Big Data Analytics, Strategic Consulting, Patient, Prescriber, and Payer Analytics, Market Access, Python (Programming Language), Tableau, Microsoft Excel 1. Analyzing discount card usage across pharmacy channels ● Created a report to help the client understand claim volume distribution across channels and MOP ● Adopted DBeaver to generate the extract, reducing turn-around time by 40% 2. Amplifying market access of 2 oncology drugs for a leading pharma ● Created competitor analysis report depicting o Higher rejection rate than competitors due to payer restrictions: PA, Step Therapy, Non-coverage o Higher abandonment due higher final cost exposure than competitors 3. Monthly KPI tracker of a preventive migraine drug and its analogues ● Created a Brand performance, Market access, and Utilization management tracker with recommendations and insights, helping the client in 3 key payer wins 4. Boosting market access for an antipsychotic drug ● Evaluated payer channel mix for LTC, retail and non-retail pharmacies ● Recommendation to include Copay charities helped the client in reducing the drug's final out-of-pocket cost by 28% ● Code optimization led to reduction in the cycle times by 75% 5. Led an Internal POC in which IMS Rx pharmacy claims data was integrated with IMS One key (i.e. HCO HCP affiliations) to rollup claim volume and financials at GPO, IDN, and ACO level ● HCOS-LAAD integration code is being used as stencil by payer analytics teams ● Best affiliation code helped internal teams to save up to 40 hrs. per month spent on running multiple instances of affiliation process 6. Forecasting tool: Working on the dynamic brand planning, which uses bottom-up forecasting approach, for recently launched drugs or drugs in the pipeline 7. Led DBeaver trainings for 54 onshore professionals and 6 Market Access-101 trainings for more than 200 campus hires to drive seamless adoption 9. Analyzing payer control and patient cost exposure of a competitor biologic before client’s biosimilar launch 10. Creating a detailed post-launch performance report of 11 antipsychotic drugs for a biopharmaceutical firm
Education
VIT, Pune (Vishwakarma Institute of Technology)
Chemical Engineering, B.Tech• May 2011 - May 2015
● Successfully completed Rio+20 India program with excellence grade "A‟ [April-13] ● Participated in events such as Mind spark, engineering today. [Aug-13] ● Attended Plant design workshop held at VIT, Pune. [Feb-14]