Debanjan Dan

India $45/hr Remote Full-time 1+ yrs exp 77 · Very Good

About

Hi I am a Decision Analytics Associate with consulting experience delivering commercial analytics, business intelligence, customer targeting, and sales force effectiveness solutions for Fortune 500 pharmaceutical organizations. Experienced in designing SQL-driven analytical solutions, Power BI dashboards, enterprise validation frameworks, and business insights that support strategic commercial decision-making.

Skills & Expertise (15)

SQL Advanced

8.3/10

Years Exp

Excel Advanced

8.0/10

Years Exp

Python Intermediate

7.5/10

Years Exp

Power BI Intermediate

7.0/10

Years Exp

Pandas Intermediate

7.0/10

Years Exp

Business Intelligence Intermediate

7.0/10

Years Exp

Tableau Intermediate

6.5/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

Forecasting Intermediate

6.5/10

Years Exp

Snowflake Intermediate

6.0/10

Years Exp

scikit-learn Intermediate

6.0/10

Years Exp

XGBoost Intermediate

5.5/10

Years Exp

SHAP Intermediate

5.0/10

Years Exp

DAX Intermediate

5.0/10

Years Exp

AWS Fundamentals Intermediate

5.0/10

Years Exp

Work Experience

Decision Analytics Associate

ZS Associates

Jul 2025 - Present

Collaborated with cross-functional consulting teams delivering commercial analytics, customer targeting, market sizing and enterprise reporting solutions for Bristol Myers Squibb and Johnson & Johnson. Developed SQL-driven segmentation and targeting models analyzing ~1M HCP records to support commercial planning. Designed and implemented an interactive Sales Force Sizing Model enabling business teams to simulate launch scenarios and estimate optimal field-force deployment. Validated 20+ enterprise analytics modules through backend SQL verification and business rule reconciliation. Automated dashboard refresh workflows, reducing manual reporting effort and ensuring timely delivery of commercial insights.