Vraj Patel

I’m a results-driven Data Analyst focused on building Power BI dashboards, DAX-based KPI models, and trade data intelligence systems in the pharmaceutical industry. I turn raw datasets into actionable insights that support strategic decisions for senior leadership.

In my Advance Pharma Dataset project, I built an end-to-end Power BI sales analytics dashboard on product-wise revenue, regional performance, and sales rep KPIs. I created DAX measures for dynamic KPIs like revenue vs. targets, profit margins, MoM growth, and regional contribution, with drill-through analysis across territory and product line.

At West Coast Pharmaceutical Works, I built Power BI dashboards and DAX KPI models analyzing trade data, sales performance, and regional market trends used directly by senior management. I automated previously manual Excel reporting through Power BI integration, reducing reporting time by ~40% while improving data accuracy.

I also delivered an International Trade Intelligence Dashboard by ingesting 3-year import/export datasets for four CIS and Eastern European markets, engineering DAX models for CAGR, supplier concentration ratio, and therapeutic demand. The output was adopted by management for CIS distributor outreach and regional entry strategy, and I completed it as a solo project within the first 6 months.