Work, written up properly

Showing 9 of 9 projects

• Data ProductsAnalyticsData ScienceAI

  Equity Gap Calculator

  Independent public project, informed by institutional research practice

  A live, public web application that implements the California Community Colleges Chancellor's Office PPG-1 methodology, helping practitioners identify student groups succeeding at lower rates than their peers. Handles student-level and pre-aggregated data, statistical thresholds, insufficient-data cases, and gap-closing estimates — with both simple and technical result modes.

  Read the case study →

• AutomationBusiness AnalysisAnalytics

  PSLO Automation System

  Institutional research, California community college

  A Python pipeline that collects and structures program learning-outcome information from 300+ program websites and generates 300+ formatted Excel workbooks — replacing roughly two months of manual copy-paste effort and removing the anticipated need for temporary staffing.

  program websites processed

  300+ program websites processed

  Excel workbooks generated

  300+ Excel workbooks generated

  manual effort saved

  ~2 months manual effort saved

  Read the case study →

• AutomationAnalyticsData ScienceIntegration

  Certificate Eligibility Discovery Pipeline

  Retention research, Coastline College

  Scraped hundreds of public program and course pages with Python and R, structured the certificate requirements, joined them against student records with SQL, and applied business-rule matching — identifying hundreds of potentially eligible students and feeding an operational outreach effort.

  Read the case study →

• Data ScienceAnalytics

  Student Success & Retention Modeling

  Retention research, Coastline College

  Built interpretable logistic-regression models to support student success and outreach work. The model reached ROC AUC ≈ 0.719, and held ROC AUC ≈ 0.679 on outreach validation — reported with limitations, not as a magic score.

  ROC AUC

  0.719 ROC AUC (interpretable model)

  ROC AUC

  0.679 ROC AUC (outreach validation)

  Read the case study →

• IntegrationAutomationBusiness Analysis

  DoD Tuition Assistance XML Pipeline

  Institutional data workflow, California community college

  An annual data requirement for military tuition assistance: mapping ~1,600 courses to a required XML schema, transforming and validating the data, and getting the submission right — where errors have compliance consequences for the institution and access consequences for students.

  courses per annual cycle

  ~1,600 courses per annual cycle

  Read the case study →

• AnalyticsBusiness Analysis

  Online Program / ACCJC Analysis

  Institutional research, California community college

  Analyzed two years of course and program data to determine which programs crossed the online-course threshold that triggers institutional review — identifying approximately 70 programs and giving accreditation stakeholders a defensible, documented answer.

  programs identified for review

  ~70 programs identified for review

  Read the case study →

• BIAnalytics

  Zero Cost Textbook Dashboard

  Institutional research, Orange Coast College

  A Power BI dashboard spanning four academic years of zero-cost-textbook course data — a proper data model underneath, and a stakeholder-friendly surface on top for tracking institutional progress on course material affordability.

  Read the case study →

• BIAnalytics

  Time to Completion Dashboard

  Institutional research, Orange Coast College

  A dashboard translating student completion timelines into a form leadership and program stakeholders can interrogate — designed around the questions people actually ask in program review, not around the shape of the source tables.

  Read the case study →

• AnalyticsBusiness AnalysisIntegrationBI

  Customer Success Technology Operations

  Tebra / Kareo — healthcare technology

  At Tebra (and previously Kareo), owned the reporting and operations tooling a CS org runs on: Snowflake SQL for customer-success metrics, Salesforce and Gainsight administration and reporting, Jira Service Desk workflows, and process improvement in a regulated healthcare-data environment.

  Read the case study →