Scott Adair

Specialty pharmacy data analyst with 18+ years of hands-on experience spanning operations, analytics, and systems implementation. Deep expertise in CareTend and Snowflake SQL including CTEs and window functions, with a strong background in URAC accreditation support, financial period close, inventory management and KPI development. Particularly effective with pharmacy organizations that own and warehouse their own data and need custom reporting beyond CareTend BI limitations.

Known for bridging the gap between pharmacy operations and data — translating what the business needs into queries and data systems.

CareTend Application Analyst (Contract) at TEKSystems (2025-09 – 2026-01)

Supported CPR Plus to CareTend workflow migration and customization

• Supported CPR Plus to CareTend workflow migration
• Pharmacy label and Delivery ticket customization
• Advised cross-functional workgroups on CareTend configuration options
• Performed User Acceptance Testing on Specialty and Infusion workflows

Lead Technical Consultant at MedEdge Solutions (2023-12 – 2025-06)

Delivered technical consulting to specialty and infusion pharmacy clients

• Delivered technical consulting to multiple specialty and infusion pharmacy clients
• Converted legacy CPR Plus reports to CareTend for clients transitioning platforms
• Developed custom SQL queries in Snowflake for financial and operations support
• Led virtual training on CareTend reporting for pharmacy report developers
• Pharma partner reporting and Compliance support

Sr. Pharmacy Analyst at PerformSpecialty (2019-12 – 2023-11)

Managed financial period close, inventory systems, and accreditation support

• Managed monthly financial period close, ensuring data integrity before close execution
• Troubleshot and resolved inventory system errors using SQL queries
• Produced data and reporting packages supporting URAC and ACHC accreditation processes
• Designed Excel dashboards monitoring KPIs and Quarterly Business Review metrics
• Supported CareTend platform updates through User Acceptance Testing
• Assisted with UIPath and mobile platform development
• Built custom performance dashboards to drive team accountability and healthy competition
• Salesforce admin and utilization reporting

Principal Consultant at DataPrana (2018-01 – 2019-12)

Led platform transitions and established UAT protocols for pharmacy clients

• Led transition from CPR Plus to CareTend for pharmacy clients
• Established User Acceptance Testing protocols for CareTend updates
• Rebuilt key reports and controls within CareTend BI environment
• Pharma partner reporting and Compliance support

Director of Analytics at SpecialtyRx Consultants (2015-04 – 2017-12)

Built and managed analytics function for start-up specialty pharmacy

• Built and managed analytics function for start-up specialty pharmacy
• Supported Sales, Operations, and Finance with custom data extracts and analysis
• Reviewed new data contracts and evaluated reporting feasibility and HIPAA compliance
• Translated business requirements from Sales, Operations, and Finance leadership into analytical deliverables

Informatics Consultant at Independent (2014-12 – 2015-04)

Provided reporting and analytics support for start-up specialty pharmacy

• Provided reporting and analytics support for start-up specialty pharmacy
• Supported RFP process and data requirements documentation
• Pharma Partner report generation

Sr. Manager, Reporting & Analytics at iCore Healthcare (now Magellan Rx) (2006-07 – 2014-11)

Progressively promoted through multiple roles to Sr. Manager of Reporting & Analytics

• Progressively promoted from Accounts Receivable Clerk through Quality Specialist and Quality & Training Manager to Sr. Manager of Reporting & Analytics
• Led workforce management and reporting analytics teams
• Established quality program and developed initial KPI framework
• Developed reports for operations, sales and other key business units
• Delivered HIPAA compliance training across multiple departments covering patient data handling and interaction protocols
• Access and VBA automation to provide daily metrics and weekly trends
• Supported URAC Specialty accreditation
• Served as internal CPR Plus backend specialist and primary reporting resource
• Mentored two team members into analytical roles, developing internal talent and expanding team capacity

Computer Science studies in Computer Science – Valencia College (2014 – 2016)

Six Sigma Green Belt in Six Sigma – SixSigma.us (2007 – 2007)

A.S. Electrical Engineering Technology in Electrical Engineering Technology – ITT Technical Institute (1996 – 1998)