pharma-analytics

Ranks the opportunity spaces in the India Cardiac market where Cipla has a sustainable right to win. A deterministic engine computes every figure; the model only narrates what the tools return.

Pharma commercial analytics project — SQL Server star schema + Power BI dashboard covering product, geography, channel, concentration, sales-force, and time-trend analysis.

US GLP-1 market opportunity and prescriber analytics on CMS Medicare Part D data (2020-2024): market sizing, prescriber segmentation, 2025 forecast, brand-team memo and Tableau extracts.

End-to-end pharma commercial analytics on synthetic data: SQL Server data-quality pipeline, star schema, Power BI (101 DAX measures), insights.

Pharma commercial performance and sales force effectiveness analysis using Excel, SQL Server and Power BI visibility.

Power BI case study on NovaMed’s 2023 sales, customer segments, and product performance across global markets.

SQL-based pharmaceutical data analysis project using MySQL to analyze drug sales, revenue, inventory, expiry, and supply-chain insights.

Pharma commercial analytics on CMS Open Payments + Medicare Part D. dbt + Postgres + Streamlit + Groq LLM. Live demo linked.

Do pharmaceutical payments to physicians still move prescribing in the GLP-1 era? Causal estimates from public CMS data (Medicare Part D linked to Open Payments, 2019 to 2024), with every design first validated on simulated ground truth.

Every row accounted for: a PySpark medallion lakehouse where bronze_in = silver_kept + quarantined + deduped is asserted per batch and re-runs are checksum-verified no-ops. YAML contracts gate each layer, violations quarantined with reasons. 1.22M rows through bronze/silver/gold in 236.6s on 2 cores. Fabric/Databricks pattern, runs on a laptop.

Interactive Streamlit web app for 365 Emirates Pharma monitoring sales performance, SLA compliance, discount capping, and cold chain storage thresholds.

Decile call lists miss the doctors whose network is converting: graph features vs node2vec/GraphSAGE for HCP launch targeting, measured under a fixed call budget