John Roach Email & Phone Number

Louisville, Kentucky, United States

• Employ Snowflake's machine learning framework (Snowpark ML for Python, Cortex) to model and stratify patients into risk tiers for various medical conditions.• Integrate large language models with custom-built risk models to provide real-time, concise explanations of patient risk factors for physicians.• Use SnowflakeSQL to query current and historical patient data and construct variables informed by findings in medical literature.• Deploy MLOps pipelines using Python scripts and Snowflake’s task framework for automated model orchestration.

• Migrated 6 ETL workflows for customer-facing reports from legacy systems to Alteryx and PostgreSQL, allowing the reports to be updated daily instead of weekly.• Collaborated with master's students on their eCommerce analytics capstone project by building and cleaning their datasets in Google BigQuery and Adobe Analytics.

• Acted as product manager in the early agile development of an iOS application aimed at streamlining MSC’s Vendor-Managed Inventory implementation process.• Improved sales-client relations for 8 large accounts by leveraging Alteryx and Excel to automate customized reports used by sales associates.• Selected to participate in MSC’s annual leadership and development program with a small cross-functional cohort, receiving extensive training in self-awareness and people leadership.

Davidson, North Carolina, United States

• Contributed to a 50% reduction in vending customer cancellation rates by building a logistic regression model in R that identified and explained key indicators of cancellation risk.• Communicated relevant findings and recommendations from analysis to high-level stakeholders who prioritized the new customer retention initiative, including the CEO of MSC.

Statesville, Nc

• Interned at a local nonprofit with the overarching goal of ending child abuse (https://www.iredellscan.org).• Completed an overhaul of many social worker spreadsheets in Excel, making them significantly more efficient and user-friendly, allowing for quick and easy reporting of data for grant-writing.• Revamped SCAN’s website, upgraded all laptops to Windows 10, entered data into a donor database, and completed various other administrative tasks.

Master Of Science - Ms, Analytics

Attended NC State University's Institute for Advanced Analytics, the nation’s first Master of Science in Analytics program, where I was.

Bachelor Of Science - Bs, Mathematics, 3.99

Activities and Societies: Phi Beta Kappa, Beta Theta Pi Fraternity, Lincoln Scholars Program• Lincoln Scholars Program: Awarded a globally.