Abhijeet Singh

Omnichannel Analytics & KPI Tracking

• Led analytics for 5+ global pharmaceutical brands, including 2 in oncology, covering end-to-end tracking of sales, promotions (calls, emails by sales reps), and third-party vendor activities (banner ads, alerts, emails, website tracking).
• Delivered actionable insights to inform brand strategies, optimizing promotional effectiveness and driving data-driven decisions for cross-functional teams.

Tableau Dashboard Development & Automation

• Built and managed the Brand Performance and Executional dashboard in Tableau, from business rule alignment, data cleaning, and creating optimized SQL queries for processed data layers.
• Developed end-to-end visual wireframes and implemented views, ensuring KPIs were accurately represented while streamlining data job workflows for consistent refreshes and automation.

Exploratory Analysis & Uplift Measurement

• Conducted in-depth exploratory analyses, including Interactive Visual Aid (IVA) performance, outlier treatment, and A/B testing, to identify HCP behavior patterns and optimize channel mix.
• Analyzed reach and engagement metrics (impressions, clicks, CTR) for third-party promotions, providing insights to enhance promotional strategies and overall effectiveness.

Governance, Mentorship & Team Enablement

• Implemented a modular Data Quality Management (DQM) and Input Validation Reporting (IVR) framework, cutting QA efforts by 30% and reducing errors by 90%, saving 200+ analyst hours annually.
• Mentored 4+ junior analysts, created SQL playbooks to improve onboarding, reduce rework by 40%, and introduced agile planning methods to streamline workflows and enhance team productivity.