Nabaroon Acharjee

• Worked for a leading pharmaceutical company as a Project Leader where the responsibility was to work as a primary PoC for 4 brands and understand the business flow of these brands while working closely with on-shore counterpart, guide juniors and reportees to develop new reports and dashboards, streamlining process by automating standard reports wherever possible and Improved overall team performance by conducting regular performance evaluations and providing constructive feedback to facilitate professional growth.

Key Projects:

Hospital Promotion Effectiveness: For a newly launched LLAI brand created a case study at account level with activity (Calls, Frequency, Samples, Affiliated HCPs) and performance (TRx,NBRx for both accounts and affiliated HCPs) for different time period(current and previous weeks/months) which showcases accounts with higher utilization has a higher growth rate when compared with previous time period across all major promotional and performance KPIs.

This helped the business to understand the major chunk of accounts and their key driving factors to push that new LLAI brand over it’s competitors and other market basket brands.

Tools used: SQL,snowflake

Performance Scorecard: Developed a Power BI dashboard which captures information like demand attainment, call plan till date call activity, reach, TRx DoT and NBRx Units’ performance over time period against it’s competitors to understand on a regular basis the performance of the ALAI brand and if any area of concern needs to be reported.

• Propensity to Win

Developed ML model using real time data from Salesforce for a healthcare brand to understand the probability of an opportunity item to win the deal over it's competitors. Going further with the output, developed real time dashboard in SFDC to help the business leaders to understand it's most potential deals over different period of time. This model is automated for a bi-weekly refresh to help the leaders to take immediate action.

Tools Used: R,SQL,Knime,Salesforce

• Other Roles and Responsibilities:

Worked as a Lead Business Analyst and as a Scrum Master to develop new solutions based on the business input from stakeholders, developed wireframes using data from different sources (SFDC, SAP & other) to build new KPIs to track the performance of the business across different level.

• Market Mix Modeling and Media Spend Optimization

For a leading Indian multinational non-alcoholic beverage company had to create a medium-long term strategy to steer their flagship brand. In this context we have helped them to understand the impact of their various marketing initiatives, promotional campaigns, and pricing, mix household consumption in terms of elasticity and contribution.

Also optimized the client's media spend on each individual KPI drivers such as TV, Radio, Trade Promotion and Consumer Promotion

Tools Used: R

• Structural Equation Modeling

For one of the renowned beverage companies had analyzed the “Drivers of any Brand's Value