Barrett Mand

About Barrett Mand

Using 15 years of healthcare experience across a wide range of disease states for pharmacy and medical therapies, I combine data analytics and meaningful insights to help patients access life-changing therapies while showcasing the impact of field teams. My extensive background in pharmacy, leading field teams, and analyzing team performance provides a unique perspective on what makes teams effective.I’m skilled in leveraging a variety of platforms, including business intelligence tools like Power BI, CRMs such as Salesforce and Quickbase, and Microsoft solutions, including Power Query and Power Automate. By utilizing these tools, I enable efficient data capture, in-depth analysis, and real-time performance monitoring, empowering field teams and their leaders to identify opportunities and make informed decisions.

Experience

1. Director of Data & Operations

   Cencora

   Aug 2023 — Present

   Utilize Business Intelligence (BI) platforms such as Power BI and Qlik to provide real-time insights and perform complex analysis for field reimbursement teams.Enable teams to self-monitor KPI metrics and quickly identify opportunities to keep patients moving toward life-changing therapies affordably. • Facilitate design of CRM platforms, such as Quickbase and Salesforce to aggregate data in a meaningful way across a multitude of therapeutic areas and insurance benefit structures. This includes providing third-parties guidance on needs and creating custom CRMs as needed.• Consult with pharmaceutical companies on CRM and data strategies that provide meaningful data about what field teams do best.• Lead a team of highly skilled field reimbursement managers in the rare disease space.• Lead a team of highly skilled field reimbursement managers in the dermatology space.• Aggregate data from many sources, such as 867 distribution data, specialty pharmacy data, hub data, field team data, etc. and develop strategies to merge unrelated data sets to provide new field monitoring approaches, including descriptive and predictive analysis.• Create presentations using PowerPoint to support weekly, monthly, and quarterly reports to use internally and for external client discussion.• Engage with accounting and finance teams to manage account receivables and account payables for correct invoicing, revenue forecasting and monitoring, and creating documentation for audit purposes.• Create automation using Power Automate to minimize workflow redundancy, increase efficiency, and ensure continuity of processes.• Design and maintain rules of engagement and company standard operating procedures (SOPs) and the SmartSolve system they are housed in.• Perform onboarding processes, such as design new training, maintain existing training, coordinate all pre-onboarding processes, and lead onboarding training.

Education

• University of Wisconsin - Fond du Lac

  Associate of Arts and Sciences, Pre-Medical

  2012 — 2013

• The University of Arizona Global Campus

  Bachelor of Science - BS, Information Technology

• University of Wisconsin-Milwaukee

  Bachelor of Arts (B.A.), Anthropology

  2013 — 2018

• University of Wisconsin-Milwaukee

  Bachelor of Science (BS), Cell/Cellular and Molecular Biology

  2013 — 2018

• Mohave Community College

  Certificate of Proficiency, Pharmacy Technology

  2009 — 2010

• Goodrich High School

  High School Diploma, High School

  1998 — 2001