John MacDonald

About John MacDonald

Senior Data Analyst | Pharmaceutical Data Integration Expert | Proficient in IQVIA, ConcertAI, IntegriChain | Leader in Predictive Analytics & Business Strategy | Strategic Driver of Enhanced Sales & Patient Outcomes

Experience

1. Senior Consultant - Data Strategy

   Insight Global

   Feb 2025 — Present

   Served as a key subject matter resource for Specialty Pharmacy (SP) and Infusion Service Provider patient and account data, supporting its responsible use across the organization and maintaining oversight of the SP data quality and governance framework.• Collaborated with cross-functional partners including Legal, HCC, Privacy, Finance, Brand Teams, and Commercial Insights to manage SP and ISP data throughout its lifecycle and ensure appropriate use, compliance, and alignment with business needs.• Represented Data Strategy team as a member of the weekly ATC/PSC touchpoint calls, to identify data issues and coordinate with data aggregator for investigation and needed corrective action.• Oversaw the end-to-end management of SP and ISP data procurement, including proposal development, fair market value review, contract pricing committee approval, contracting, development, testing, quality control, governance oversight, and ongoing renewals.• Served as the Data Strategy representative for 31 CPC meetings and subsequent recommendations, across all Therapeutic Areas.• Worked closely with the organization’s data aggregation partner and specialty pharmacies to establish data layout requirements, coordinate FTP connectivity, support onboarding and testing activities, and ensure compliance with reporting requirements.• Advised brand and commercial teams on supplemental data initiatives, including expected costs, aggregation considerations, and status updates related to new or expanding SP and ISP data assets.• Oversaw approval and processing of SOWs and associated budgets related to supplemental data aggregation and integration activities.

Education

• Bridgewater State University

  BS Political Science, Law

  1985 — 1991

Skills

• Consultation
• Sales Force Effectiveness
• Analysis
• Integration
• Crm
• Customer Relationship Management (Crm)
• Microsoft Excel
• Sales Effectiveness
• Business Process Improvement
• Business Analytics
• Territory Analysis
• Marketing
• Strategic Planning
• Integrichain
• Client Segmentation
• Process Improvement
• Cross-Functional Team Leadership
• Territory Planning
• Project Management
• Sales Operations
• Demand Generation
• Sales
• Sas
• Business Intelligence
• Valuetrak
• Sales Analytics
• Vertical Marketing
• Strategy
• Access
• Segmentation
• Management
• Sales Improvement
• Analytics