Skip to content
View McAelanRemigio's full-sized avatar

Block or report McAelanRemigio

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
McAelanRemigio/README.md

McAelan Remigio

Business Analytics & Strategy | Decision Systems | Data Science

I build analytical systems that transform complex data into actionable insights, scalable workflows, and better organizational decisions.

Statistics & Data Science student at San Diego State University (May 2027) with 2+ years of experience across workforce analytics, public health surveillance, scientific research, and AI-enabled reporting.

My work sits at the intersection of data engineering, business strategy, and operational decision-making.

LinkedIn Portfolio Email


About Me

I am interested in building systems that make organizations more effective, informed, and scalable.

My experience spans:

  • Strategy & Operations: Workforce analytics, resource allocation, KPI development, and operational reporting.
  • Data Engineering: ETL pipelines, data modeling, validation, and reproducible analytical workflows.
  • Applied AI: LLM-powered analytics, prompt orchestration, and automated business intelligence.
  • Statistical Research: Regression modeling, time-series analysis, and program evaluation.
  • Organizational Leadership: Building communities, developing partnerships, and creating sustainable systems.

I particularly enjoy working on problems where technical execution and organizational decision-making intersect.


Featured Projects

Twenty AI CRM Copilot

Independent Developer · AI-Powered Business Intelligence · 2026–Present

An AI-powered CRM analytics platform that transforms operational customer data into structured, actionable business intelligence using locally hosted language models.

  • Developed an LLM-powered analytics workflow connecting Twenty CRM, PostgreSQL, and locally hosted models through Ollama.
  • Designed prompt orchestration and structured output schemas for automated KPI interpretation, meeting summarization, and executive reporting.
  • Built reproducible Python pipelines that transform CRM records into contextual insights and write AI-generated summaries back into the CRM.
  • Exploring agent-based distribution and commercial applications for AI-assisted CRM intelligence.

Technology: Python · PostgreSQL · Ollama · Twenty CRM · LLMs

Repository: Twenty AI CRM Copilot


Rubin Variable Star Classification

NSF–DOE Vera C. Rubin Observatory · 2025

Engineered analytical workflows for astronomical time-series data and variable star classification.

  • Processed 3.5 TB of astronomical data using Python and SQL.
  • Established 94% classification accuracy.
  • Supervised three undergraduate researchers and presented findings to research stakeholders.

Resources:

Stack: Python · SQL · Statistical Modeling · Time-Series Analysis


Workforce Analytics & Strategy

SDSU Career Services · 2025–2026

Developed analytical infrastructure supporting a $2M California State University workforce initiative.

  • Reconstructed and standardized 761K+ records across 100+ datasets.
  • Built reporting pipelines supporting workforce analysis and resource allocation.
  • Delivered analytical insights informing institutional and regional workforce strategy.

Stack: Python · SQL · Tableau · Power BI · Data Modeling


Professional Experience

Organization Role Focus
SDSU Global Education Office Data Assistant Institutional analytics & data governance
Independent Development Developer GenAI analytics & reporting platform
SDSU Career Services Operations & Resources Associate Workforce analytics & strategy
NSF–DOE Vera C. Rubin Observatory Undergraduate Researcher Scientific data engineering
Centers for Disease Control (CDC) ORISE Data Science Fellow Public health analytics
SDSU Research Foundation Data Science Research Assistant Statistical modeling & program evaluation

Selected Research & Operational Impact

  • $1.27M NSF Program: Developed multivariate regression models evaluating student success outcomes across 10K+ records.
  • CDC Surveillance: Standardized international SARS-CoV-2 datasets, improving reporting consistency to approximately 99%.
  • Institutional Analytics: Supporting reporting infrastructure and data governance across seven enterprise systems at SDSU Global Education.

Leadership & Recognition

Founder & President — SDSU Data Science Initiative

Founded and developed SDSU's first campus-wide data science organization.

  • Grew the organization to 160+ members.
  • Supported 20+ students in securing internships and professional opportunities.
  • Established university and industry partnerships.
  • Built mentorship programs and sustainable organizational infrastructure.

Selected Honors

  • 2026 SDSU Homecoming Royal — Leadership & Service (1 of 2)
  • 2026 Prebys Student Leaders Endowed Scholar
  • 2026 Mortar Board — Selected as 1 of 45
  • 2025 Daniel B. Nowak Outstanding Student Service Award — Sole Recipient

Technical Toolkit

Languages & Querying

Data & Analytics

Infrastructure & Development

Core Competencies

Statistical Modeling · Regression Analysis · Hypothesis Testing · Time-Series Analysis · Feature Engineering · ETL Pipelines · Data Validation · Data Governance · KPI Development · Program Evaluation


Current Focus

  • Building AI-enabled analytics and reporting infrastructure.
  • Exploring the intersection of LLMs and operational decision systems.
  • Developing scalable data pipelines and reproducible analytical workflows.
  • Applying statistical methods to organizational and business problems.

Let's Connect

Interested in collaborating on projects involving data analytics, applied AI, business intelligence, and decision systems.

Building analytical systems that create measurable impact.

Pinned Loading

  1. Twenty_AI_CRM_Copilot Twenty_AI_CRM_Copilot Public

    AI-powered CRM copilot that generates strategic company insights inside Twenty CRM using FastAPI, Odysseus, and a local LLM.

    Python 1

  2. BCG_GenAI_Financial_Chatbot BCG_GenAI_Financial_Chatbot Public

    A Python-based financial chatbot prototype that transforms SEC 10-K data into conversational insights through data retrieval, financial analysis, and rule-based AI workflows.

    Jupyter Notebook 1

  3. CS_SO_Analytics CS_SO_Analytics Public

    This project demonstrates how job posting data can be structured, analyzed, and modeled to support workforce development decision-making for a statewide manufacturing pipeline initiative.

    Python 2

  4. VeraRubin VeraRubin Public

    Machine Learning based variable star classification with Rubin Observatory Data Preview 1 with outputs including ranked candidate variable stars, diagnostic plots, and reproducible analysis notebooks.

    Jupyter Notebook 1