Advanced Analytics

Director, Commercial Analytics C00102

Published On

Profile-pic-150x150

Seasoned Business Analytics professional with expertise in Commercial pharmaceutical Analytics, Insights, and Strategy across therapeutic areas. Extensive experience in leading advanced analytical solutions & statistical modeling for commercial pharmaceutical projects -Promotion Response, ROI Assessment, Customer Segmentation & Targeting, Predictive Modeling, Market Mix Modeling, KPI performance reporting. Strong leadership experience in enabling Marketing Analytics and Commercial Effectiveness for in-line and launch products. Experience collaborating and interacting with several functions -BU leads, Forecasting, Finance, Market Research, Managed Markets, Digital, Field Force, Commercial Data & Reporting.

Industry and Project Experience

This image has an empty alt attribute; its file name is Divider-1.jpg
Pharma Consulting, Associate Director/ Sr. Engagement Manager Nov 2018 – Mar 2021

⦿ Leading and mentoring a team of Analysts and Managers
⦿ Designing solutions and POCs (Proof of Concept) for various analytics projects
⦿ Leading the delivery of projects requiring complex and large data volume (commercial pharma data – IQVIAXponent/PlanTrak, DDD, Specialty Pharma, APLD, HCOS, Veeva SFA/ CRM, etc.) and answering ad hoc analytical/ business questions on a daily basis Illustrative projects:

• Find patient attributes that are predictive of pneumonia vaccination using CDC data with 486K patients and 275 variables
• Analyze and predict seasonal flu activity across the US and facilitate the client to trigger promotional campaigns when the flu strikes, TRx’s surpassed last year peak by 45%
• Customer Affiliation – creating the data model and business rules for Master Data Management (M DM) of a large customer list (0.5 to 7.0 m)
• Design and create a workflow model to capture daily EDI sales and integrate with the CRM/ SFA system
(Salesforce.com – Veeva)
• S&M Reports design and development – complex reports having 700+ KPI s from subject areas like Sales, Promotion Activity, and Managed Markets using SSAS/ OLAP cubes for multidimensional data
• Led and mentored a team of analysts to build and standardize the data model of Bl platforms – Tableau, Qlik Sense

Enterprise Analytics Practice, Engagement Manager Apr 2009 – Oct 2011

⦿ Predicted the Erosion Rate of 3 hospital brands in the EU facing generic competition; identified factors affecting erosion using multiple linear regression. Laid foundation for future projects from client
⦿ Setup client’s Global Analytics Centre – set up a core-flex resourcing model to effectively answer commercial analytics requests from brand managers, sales operations team, and Executive Leadership.
⦿ Account has grown to 7 m+ annual revenue
⦿ Oncology and Diabetes Executive Analysis tool – Project requirement gathering, solution design, and client management onsite at client’s Indianapolis, US office for 2 months
⦿ Develop a Contract Pricing Optimization tool for sales management and corporate accounts of a large medical device company. Tool finally in targeted with client’s Bl platform
⦿ Develop People Placement tool to assign field reps to sales territory based on multiple variables including traveling distance from territory centroid to rep’s address, rep rating, territory potential, etc.

Pharma Consulting, Associate Jan 2006- Oct 2007

⦿ Salesforce sizing, restructuring, HCP/ Account segmentation, and targeting
⦿ Sales & Marketing KPI dashboards design/ development

Business Process Services, Workflow Analyst Apr 2005 – Dec 2005

⦿ Capacity Planning for a leading Risk Management and business information provider
⦿ Performance reporting and process automation

Software & Tech Services, Administrative Assistant Feb 2003 – Apr 2005

⦿ Process optimization, automation, and performance reporting for a large telecom client

Technical Skills

This image has an empty alt attribute; its file name is Divider-1.jpg
Expert-level SQL with experience using across multiple databases: SQL Server, Oracle, Cloudera, Hue, Hive, Impala
SAS (Base SAS, SAS/ STAT, SAS/ GRAPH)
Bl Platforms: Tableau, Qlik Sense, in MicroStrategy Excel and PowerPoint (expert level knowledge including VBA automation)
Data science enthusiast using Python and R

Education

This image has an empty alt attribute; its file name is Divider-1.jpg
Bachelor of Technology
National Institute of Technology (NIT), Calicut, India (2010 – 2014)
Get The Latest Updates

Subscribe To Our Monthly Newsletter

No spam, only the content you’ll want to read.

Details about how we process your Information is available in our 

Privacy Policy

Watch our Latest Event

Ready, Set, Launch

Why Technology is Key to a Successful Product Launch

Kun Liu

Patrick Retif