Azfar Imam Niyazi

Client: GSK USA

• Project: Healthcare Revenue Cycle Management

A data lake was created for Revenue Cycle Management (RCM) in the healthcare domain. The goal was to centralize, clean, and transform data from multiple sources, enabling healthcare providers and insurance companies to streamline billing, claims processing, and revenue tracking.

• Project: Unified Commercial Data Lakehouse for Pharma Sales Insights

Built a platform that consolidates multiple data sources related to pharmaceutical sales, marketing campaigns, HCP (Healthcare Professional) interactions, and prescription data to enable real-time reporting and analytics for the commercial team.

• Project: Pediatric vs Adult Indication Segmentation

Built a data pipeline to segment and analyze pharmaceutical sales, Rx patterns, and rep activities by pediatric vs adult indications — using attributes like HCP specialty and age-based formulation.

Client: Dell USA

• Project: Key Metric Tracking

Tracking the key metrics Revenue, Units, Margin, Site visits generated through the online channels for ten markets of Dell on a daily basis and producing insightful results to the marketing team for achieving results for paid and unpaid media.

Client: GSK USA & CANADA

• Project: Customer Value Measure

Worked on a voice of customer survey-based project for different therapeutic areas to measure the effectiveness of its sales force and understand the responses of the HCPs using NET PROMOTER SCORE and present the same to the respective therapeutic heads.

Client: AVON Brazil

• Project: Marketing Data Preparation and Summarization

Data cleaning, transformation and creating new variables using SAS and excel functions and presenting highly accurate data to a retail client.