Director, Commercial Analytics C00102

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

⦿ 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

Education