Manager, Commercial Analytics C00104

The analytical leader with excellent business acumen focused within the pharmaceutical consulting industry. Expert supervisory skills including project management, stakeholder management, and team management. Highly specialized in advanced analytics, promotion mix modeling,
patient-level data analytics, brand analytics, and sales force effectiveness.

Industry and Project Experience

⦿ Developing Promotional Effectiveness model, SFE model, Digital analytics models for Pharma clients in the US, Europe
(France/Germany), Japan and China.
⦿ Majorly work on strategy projects on resourcing and deployment which includes segmentation, sizing, targeting, alignment, placement, PR, and budget optimization projects (Market mix/ Promotional response).
⦿ Managing the client, handling the onshore, understanding the requirement of the stakeholders to provide them with the best possible analytical solutions using various tech platforms, Handling a team of 4-5 associates, and training fresh associates for domain expertise.
⦿ Worked on major integration of two big pharma giants in revenue optimization as well as a resource management strategy, forecasting strategy, and data science implementation for their digital analytics domain.
⦿ Strategize and deployed Omnichannel Campaign Analytics project for multiple clients and acted as POC for building their engagement journey across various cloud-based platforms like Salesforce cloud, Adobe orchestration engine.
⦿ Worked on building in-house apps for clients to calculate digital affinity using R and ML algorithms.

Pharma Consulting, Business Associate (Decision Sciences) (Oct 2018 – Jul 2019)

⦿ Developing predictive analytics model using techniques like the random forest, clustering, decision trees for pharma clients.
⦿ Developing revenue optimization models like mmx model and promotion response model.
⦿ Training associates for Alteryx to help them transform their processes from various interfaces and automate them.
⦿ Involve in the hiring process as a subject matter expert for Alteryx.
⦿ Building Forecasting models as well involve in patient-level data analytic models.

Large Pharma, Business Analyst (Market Effectiveness Strategy) (Feb 2018 – Sep 2018)

⦿ Performance tracker dashboard using various KP ls to enhance Franchise /Product decision-making.
⦿ Communicate with stakeholders to understand the business requirement, propose solutions, demonstrate mock-ups and roll out deliverables to develop business reports.
⦿ Region-specific Forecasting Strategy Models for Oncology as well as Immunology franchise.
⦿ Work with cross-functional teams to develop the forecasting model for pipeline products as well as in-market products.
⦿ Automating the model using Tableau/Qlik sense, RPA, Alteryx.
⦿ Automated reports and processes for across teams using various tools to reach zero manual intervention by transforming the model/dashboards (SAS, VBA, Access) along with regular work using RPA, Alteryx, Qlik sense.
⦿ Worked on a Small NLP project to develop the interactive user-based interface using Python (Django framework)

Business Process Management, Business Analyst (Jul 2016- Dec 2017)

⦿ Worked on several market analytics projects for blue-chip pharma companies, primarily involved in analytical projects for companies in US/Europe. Worked extensively on project models based on MS Excel, MS PowerPoint, Dashboard development for pre-launched products as well as marketed products based on VBA.
⦿ Worked on Patient level data analytics to identify the various key problems for the stakeholders.
⦿ Creating Business Intelligence Reports (Bl R’s) for companies which include a business overview, financial analysis, SWOT analysis, strategies, etc., & Creating Strategy-Opportunity-Structure (SOS) reports.
⦿ Creating Industry/Country reports that cover the trends, forecasts, facts & figures, key developments, and major players of the industry.
⦿ Slicing and dicing the datasets on SAS, Excel and exporting them to the reporting tool using various SAS Procedure

Technical Skills

Business Consulting Project Management Client Handling
Team Handling Resource Management Tableau
Alteryx
Forecasting Advanced Excel &VBA PowerPoint
SQL
SAS
Spotfire PowerBI RPA
Qlik sense
R (Shiny, ggplot, plyr) Regression Statistical Modeling Mmx Modeling Digital Affinity
Python

Education