John Ross, MHA
Warren County,United States
Summary
Strategic and analytical professional with 7+ years of success in biopharmaceutical industry and healthcare administration. Talented in delivering advanced Excel and SQL reporting to plan, design, execute and evaluate report results. Highly adept in analyzing business needs using technical skills to provide data and information analysis to achieve continuous improvement. Proficient in advanced MS Excel formulas and functions to produce data-driven reports. Expert in creating reports writing SQL queries and analyzing SQL data.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Supply Planning and Reporting Analyst
Regeneron Pharmaceuticals, Inc
02.2023 - Current
- Manage the demand planning process and continuous improvement initiatives.
- Optimize Supply Chain planning and ensure compliance with FDA regulations and cGMP guidelines (e.g., implemented new process for document control issuance, printing, and reconciliation; biological product manufacture reporting).
- Present performance standards, develop joint improvement initiatives and implement feedback [Advanced Planning System (APS) integration analytics, Production Sequence Concept, optimize production schedules, ensure efficient use of resources].
- Create visually appealing dashboards that effectively communicate key metrics to evaluate overall plan/process efficiency.
- Oversee the data stewardship program during implementation of new APS program handling, operational maintenance. and data check requests throughout the department.
- Key Projects: assisted in establishing new department APS integration (Kinaxis RapidResponse), supported supply/demand planners for Regeneron’s approved commercial pipeline (including the strategic acquisition of Libtayo® (cemiplimab-rwlc), and designed data analytics tools for demand tracking and rapid response data migration/investigation.
Associate Inspection Specialist Quality Assurance
Regeneron Pharmaceuticals, Inc.
01.2021 - 02.2023
- Performed root cause analysis on identified defects, leading to targeted improvements in manufacturing processes.
- Controlled qualification room and supported logistics for facilitators during evaluations and qualifications of visual inspectors and qualification kits.
- Created a database housing qualification, evaluation, and training data for QA and manufacturing operators.
- Controlled qualification room and supported logistics for facilitators during evaluations and qualifications of visual inspectors and qualification kits.
- Collaborated with QA/Manufacturing to develop vial training kits and vial qualification kits for visual inspection (VI) operators.
- Assisted in the revision of standard operating procedures (SOPs) for qualification kit creation, maintenance, and qualification of VI operators.
- Managed risk identification and mitigation activities for input/output operations per second for Quality Risk Management (QRM).
- Prepared documentation for subject matter experts during internal audits for inspection readiness, and served as department liaison for continuous improvement initiatives (Medical Device, QRM, and QA).
- Key Projects: developed a suite of data analytics tools to conduct unit Probability of Detection (POD) tracking and to evaluate operator performance, created a dashboard that improved the presentation of data and data entry and identified duplicate entries for new and existing SOPs for the Fill/Finish site, centralized diverse data subsets by converting legacy data to a Structured Query Language (SQL) database enhancing reporting capability.
Associate Inspection Specialist (QRM)
Regeneron Pharmaceuticals, Inc.
06.2020 - 12.2021
- Supported compliance activities within Quality Assurance (Quality Risk Management) and organized the quarterly risk register to communicate overall risk status and mitigation.
- Processed, managed, and facilitated QRM engagement worksheets for change controls.
- Identified potential risk, safeguards, and post-implementation effectiveness monitoring.
- Developed data analytics tools for workload forecasts, risk assessment performance tracking and ad hoc requests.
- Key Projects: designed data analytics tools for project monitoring, workflow scheduling, and workload forecasting, created a metric measuring tool linking risk register data to reporting metrics for Key Performance Indicators (KPI) to assess and mitigate risk for applicable programs.
Quality Assurance Consultant
The Eclectic Global Consulting Group
09.2019 - 06.2020
- Developed data analytics tools for drug product quality and QRM to track and evaluate KPIs and other core metrics.
- Facilitated process improvements initiatives for QA batch record printing and review to optimize lead times.
- Supported a Quality Council comprised of individuals from relevant IOPS departments providing cross-functional input to evaluate deviations for impact on product quality and compliance.
- Participated in process improvement initiatives for Quality Assurance batch record printing and review to optimize lead times and streamline intake.
- Performed administrative support duties such as scheduling and coordinating meetings, creating presentations and flowcharts, notetaking, and managing documents.
- Key Projects: developed a workload tracking tool that monitored project progress and provided data for risk assessments and their respective facilitators; created data analytics tools for Drug Product Quality and Quality Risk Management to track key performance indicators, metrics, and other data points intended for business intelligence, project management, and continuous improvement activities; assisted Drug Product Manufacturing Project Specialists with SOP document identification/validation activity analytics for a future Fill Finish facility processing vials and pre-filled syringes.
Development Officer
Albany College of Pharmacy and Health Sciences
09.2010 - 10.2018
- Worked with industry and community pharmacists, population health and public health professionals, managing projects that included: business development and marketing for two student-operated pharmacies, development activities for research and promotional activities of service modules for point of care screening, assessments, patient education, referral, and navigation services for a health facility cooperative.
- Managed business development projects, activities for research and promotion for service modules assisting point of care screening, assessments, patient education, referral, and navigation services for a health facility cooperative and two pharmacies.
- Improved existing pipeline of associations with asthma and diabetes specialists in correlation with current research and community health education projects for the Collaboratory which achieved a $6.1M fundraising goal.
- Designed, delivered, and coordinated fundraising initiatives for the health center.
- Shaped partnerships for management functions that adapt and adjust to the health needs of a community within the college pharmacy and clinic serving forty-eight faculty healthcare/public health practitioners and 18,000 patients.
- Implemented data tracking metrics programs for presentations to stakeholders and assessments which included an 86% retention rate in funding ranging from $5K–$25K.
Education
Master of Healthcare Administration -
Utica College
Utica, NY 05.2001 -
Bachelor of Arts -
SUNY Oneonta
Oneonta, NY 05.2001 -
Skills
Data Visualization and Report Development
Quality Risk Management and Process Improvement
Project & Logistics Management
Power Query
APS Integrations
SQL Query Design
Power BI
Tableau
Qlik Sense
Python
Visual Basics
RapidResponse
Certification
Data Science with SQL and Tableau Certificate (Cornell University)
Timeline
Supply Planning and Reporting Analyst
Regeneron Pharmaceuticals, Inc
02.2023 - Current
Data Science with SQL and Tableau Certificate (Cornell University)
05-2022
Associate Inspection Specialist Quality Assurance
Regeneron Pharmaceuticals, Inc.
01.2021 - 02.2023
Associate Inspection Specialist (QRM)
Regeneron Pharmaceuticals, Inc.
06.2020 - 12.2021
Quality Assurance Consultant
The Eclectic Global Consulting Group
09.2019 - 06.2020
Development Officer
Albany College of Pharmacy and Health Sciences
09.2010 - 10.2018
Master of Healthcare Administration -
Utica College
05.2001 -
Bachelor of Arts -
SUNY Oneonta
05.2001 -
Similar Profiles
Nicole L. LangNicole L. Lang
Project Manager Consultant at Regeneron Pharmaceuticals, IncProject Manager Consultant at Regeneron Pharmaceuticals, Inc
Momodou W. JallowMomodou W. Jallow
Postdoctoral Fellow at Regeneron Genetic Center, Regeneron Pharmaceuticals, Inc.Postdoctoral Fellow at Regeneron Genetic Center, Regeneron Pharmaceuticals, Inc.
Sae Hyung LeeSae Hyung Lee
Clinical Outsourcing, Manager at Regeneron Pharmaceuticals IncClinical Outsourcing, Manager at Regeneron Pharmaceuticals Inc
Ray WardRay Ward
Senior Project Manager at Clune Construction CompanySenior Project Manager at Clune Construction Company
Aaron CostelloAaron Costello
Sales Associate/Driver, Warehouse Orders at Pinnacle Parts and Service CorporationSales Associate/Driver, Warehouse Orders at Pinnacle Parts and Service Corporation