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.
-
Updated
Jul 27, 2026 - Python
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.
SQL-based pharmaceutical data analysis project using MySQL to analyze drug sales, revenue, inventory, expiry, and supply-chain 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.
Medicare Part D GLP-1 market and prescriber analysis (2023–24): Mounjaro share shift, prescriber targeting and whitespace. MySQL + Python on 752K CMS records.
End-to-end pharma commercial analytics on synthetic data: SQL Server data-quality pipeline, star schema, Power BI (101 DAX measures), insights.
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
Medicare Part D GLP-1 case study: market sizing, growth drivers, state launch priority and back-tested scenarios (CMS data, Python).
Bayesian MMM budget simulator for a fictional oncology brand in Korea, Taiwan and Hong Kong. Synthetic data, lift-test calibration, interactive demo.
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.
Air-gapped multi-agent text-to-SQL system for synthetic pharma commercial analytics (prescriptions, hcp activity, geo access), built on LangGraph, Ollama and DuckDB with zero external LLM API calls.
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.
To associate your repository with the pharma-analytics topic, visit your repo's landing page and select "manage topics."