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.