John MacDonald

Senior Pharmaceutical Data Analyst at Keen360
  • Claim this Profile
Contact Information
Location
West Point, Pennsylvania, United States, US

Topline Score

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 2 ratings
  • (2)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

You need to have a working account to view this content. Click here to join now
Adrean Turner MBA, MAM, PCC

John is an astute professional. During our time together at Merck John was very resourceful often times without prompting. He possess the ability to excel in challenging situations and he will go the extra mile to support his team. John is a conscientious project leader. His analytical skills and experience have lead to the successful delivery of key assignments.I highly recommend John for excellence in performance.

Elaine Homola Bradshaw

I worked with John while he was at D&B. He was involved in our account and provided us with on-time positive results. From the data perspective, he is very knowledgeable and willing the share his experiences. John is very detailed oriented, asks great questions and a complete professional. Any firm that has John on their team will have a great asset.

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.
You need to have a working account to view this content. Click here to join now

Experience

    • United States
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Senior Pharmaceutical Data Analyst
      • Oct 2021 - Present

      Contracted to Janssen Contracted to Janssen

    • Senior Analyst
      • 2019 - Oct 2021

      Establish and closely monitor key metrics to guarantee alignment of bulk electric system (BES) with NERC Protection and Control (PRC)-005 Protection System Maintenance standards▪ Facilitate meetings and oversee senior electrical engineers in recognizing and bridging gaps in testing plans and schedulesCareer Highlight:✓ Served as the key person behind the PPL’s consistent fulfillment of NEC PRC-005, while continuously maintaining zero compliance failures Establish and closely monitor key metrics to guarantee alignment of bulk electric system (BES) with NERC Protection and Control (PRC)-005 Protection System Maintenance standards▪ Facilitate meetings and oversee senior electrical engineers in recognizing and bridging gaps in testing plans and schedulesCareer Highlight:✓ Served as the key person behind the PPL’s consistent fulfillment of NEC PRC-005, while continuously maintaining zero compliance failures

    • United Kingdom
    • Software Development
    • Senior Data Analyst
      • Jun 2018 - Sep 2019

      Analyze trends within the Specialty Pharmacy Market to improve patient adherence and outcomesQC patient and pharmacy data, ensuring accuracy Conduct weekly client calls, to discuss project plans and issue resolutionDevelop SQL code to generate analysis and QC STAR Portal, a client facing analytical toolImproved existing SQL performance times by more than 50% Analyze trends within the Specialty Pharmacy Market to improve patient adherence and outcomesQC patient and pharmacy data, ensuring accuracy Conduct weekly client calls, to discuss project plans and issue resolutionDevelop SQL code to generate analysis and QC STAR Portal, a client facing analytical toolImproved existing SQL performance times by more than 50%

    • Pharmaceutical Data Analyst contracted to Janssen Pharmaceuticals
      • May 2017 - Jun 2018

      Generate analysis utilizing SAS to identify sales trends and opportunities within the Immunology marketDrive process improvement in the creation and distribution of SPP metrics Align with Janssen partners to ensure integration of accurate and actionable dataObtain,QC, and Integrate SPP data providers informationParticipate in weekly partner calls, discussing action plans, improvement opportunities and issue resolution Generate analysis utilizing SAS to identify sales trends and opportunities within the Immunology marketDrive process improvement in the creation and distribution of SPP metrics Align with Janssen partners to ensure integration of accurate and actionable dataObtain,QC, and Integrate SPP data providers informationParticipate in weekly partner calls, discussing action plans, improvement opportunities and issue resolution

    • Sales Analytics Consultant
      • Jun 2009 - Apr 2017

      Evaluation, management, and interpretation of Retail Pharmacy data for Merck VaccinesPlanning and implementation of a customer-facing performance review process to provide the capabilities to understand vaccine performance within their regions, divisions, and pharmacy district managers’ territories over 60,000 retail pharmaciesActive involvement in the annual sales budgeting process to present detailed trend analyticsAssessment of ROI for direct-to-consumer newspaper, in-store, and radio advertisements in collaboration with the Quantitative Science Team Development of a model for a new commercial offering within the retail pharmacy to maximize contract opportunitiesFacilitation of trainings on several analytical tools to Merck Vaccine account executives as well as pharmacy sales and leadership teamsOptimization of the field account management implementation process for targeted accounts and enhancement of customer engagementSignificant increase of vaccination rates by initiating innovative customer reporting tools and reports with near real-time analytical capabilities for Merck Vaccine Retail Pharmacy and Integrated Delivery System TeamIdentification of specific locations of a competitor’s product within the Retail Pharmacy space by structuring a proxy model, which enabled the Merck Account Team to target these accounts for second dose opportunityDeployment of Merck’s first-ever Retail Pharmacy Sales Team as analytics leader for new Merck Vaccine Pharmacy Sales Team with senior and executive directors of Merck Vaccines Sales and Strategic Planning departmentsEffective recommendations on a rightsizing effort to reflect the changing market along with the oversight of the Vaccine Pharmacy Account Executive Team, thus leading to a three-person reduction headcountAttainment of recognitions on various occasions for innovative analytical leadership with Merck vaccines as well as various awards for excellence, leadership, and team and task force recognitions

    • Senior Program Manager
      • 2005 - 2008

      Integration of proceedings of a $1.5B organization and facilitation of pre-merger clean-room environment as contracted by Fortune 500 company to propose go-to-market recommendationsExpert identification of current market coverage and new penetration strategies along with the development of sales staff acceptance of a sales force automation package by providing effective recommendations to C-level executivesProvision of in-depth consultation services to customer base by formulating a detailed understanding of customer business requirements, thus addressing business issues; enhancing product, services, and processes; identifying new opportunities; and boosting revenue by 12%Significant decrease of error rates by more than 50% through the development of a data fulfillment methodology, thus leading to six-figure cost savingsAchievement of three Customer Excellence awards for consulting engagements

    • Retail Office Equipment
    • 700 & Above Employee
    • Corporate Services Marketing Manager
      • Jan 2003 - Jan 2005

      Utilization of company data from Dun and Bradstreet through in-depth analysis of corporate customer baseCollaboration with a key strategic partner in developing differentiated tools which enabled customers and sales field to analyze an organization’s total burdened document spendExecution of a robust analysis of the company’s customer base by creating the first capability in the company’s history, wherein the data was utilized by C-level executives and board of directors in implementing go-to-market strategiesAssessment of territory alignment for all sales professionals across the company

Education

  • Bridgewater State College
    BS Political Science, Law
    1985 - 1991

Community

You need to have a working account to view this content. Click here to join now