Brand Analytics (Pharmaceuticals - US)

Migrating Pharmaceutical Organization’s Data (Patient enrollment, Drug shipment, Activation) in PowerBI Optimizing Patient status process to the Sales Team to follow up with the HCPs for early recommendations Targeting HCPs across multiple Territories based on AI for recommending the drugs on priority.

o Building Weekly Sales Leadership deck to present actuals and forecast values of the Quarters

o Continuous optimization of all the process from Excel SharePoint to PowerBI

Approach: SQL, Excel, Power BI

Create Charts for displaying KPI indicators and filters, by data fetched from SpringCM.

Generating reports and merging with stakeholders for Business inputs

The project was to come up with eCommerce platform, where customers and register and purchase the product themselves, and skipping all the sales-driven processes