An 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

This image has an empty alt attribute; its file name is Divider-1.jpg
Pharma Consulting
Associate Consultant (Decision Analytics- Business Consulting) (July 2019- Present)

⦿ Developing Promotional Effectiveness model, SFE model, Digital analytics models for Pharma clients in 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 from the stakeholders to provide them with best possible analytical solutions using various tech platforms, Handling 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 resource management strategy, forecasting strategy and data science implementation for their digital analytics domain.
⦿ Strategize and deployed Omni channel Campaign Analytics project for multiple clients and acted as POC for building their engagement journey across various cloud-based platforms like Sales force cloud, Adobe orchestration engine.
⦿ Worked on building inhouse apps for client 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 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 hiring process as subject matter expect 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 product.
⦿ Automating the model using Tableau/Qlik sense, RPA, Alteryx.
⦿ Automated reports and process for across team 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 includes 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

This image has an empty alt attribute; its file name is Divider-1.jpg
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

Modelling Digital

Affinity
Python

Education

This image has an empty alt attribute; its file name is Divider-1.jpg
B. Sc Life Sciences
Dr BR Ambedkar University
M. Sc Biotechnology
Amity University Naida
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

Upcoming Webinar

Strategic Planning for Medical Affairs

Adding Value Efficiently

Featured Speakers

More Profiles

TO LEARN MORE ABOUT THIS OR OTHER AVAILABLE RESOURCES, PLEASE CONTACT

melissa

Melissa ArchuIeta

Director of Accounts and Resource Management