Skip to content
View andmedina's full-sized avatar

Block or report andmedina

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. Markdown is supported. 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
andmedina/README.md

Andres Medina

Data Engineer | Data Scientist

I build end-to-end data systems that transform complex scientific and operational data into reliable datasets, analytical insights, and machine-learning solutions. My background in biological research shapes my interest in bioinformatics, health informatics, medicine, and scientific data systems.

I also enjoy learning unfamiliar domains and translating their processes and business rules into practical data products using Python, SQL, PostgreSQL, ETL development, data modeling, and applied machine learning.

Explore my data projects portfolio →


Featured Projects

Scientific and Healthcare Data

Project What it demonstrates
Aptafind Reproducible computational aptamer research, provenance-aware data pipelines, grouped evaluation, and PyTorch and TensorFlow sequence-generation experiments
Healthcare Clinical Intelligence FHIR and HL7 ingestion, layered PostgreSQL modeling, data quality and reconciliation, Airflow orchestration, OMOP-compatible analytics, and governed machine learning
Healthcare Claims ETL Healthcare data modeling, Python and PostgreSQL ETL, data validation, and analytics-ready transformations
Gene Metadata Pipeline REST API ingestion, scientific-data transformation, validation, and relational storage

Applied End-to-End Data Systems

Project What it demonstrates
Manufacturing Intelligence Platform PostgreSQL data modeling, modular Python ETL, manufacturing KPIs, Tableau reporting, root-cause analysis, and predictive-maintenance modeling
BOM Material Planning ERP-style production demand, BOM explosion, time-phased inventory netting, supplier constraints, and actionable purchasing recommendations
CAD-to-ERP Pipeline Engineering metadata extraction, structured BOM processing, data validation, and CAD-to-ERP integration

Technical Focus

  • Data engineering: ETL pipelines, data validation, relational modeling, data integration, and reproducible analytical datasets
  • Languages and databases: Python, SQL, PostgreSQL, and SQLite
  • Analytics and machine learning: Pandas, NumPy, scikit-learn, Tableau, operational KPIs, and predictive modeling
  • Development workflow: SQLAlchemy, pytest, Git, and Apache Airflow
  • Domain experience: Biological research, bioinformatics, healthcare, manufacturing, and ERP/BOM workflows

Current Interests

I am particularly interested in bioinformatics, health informatics, scientific data systems, medicine, and applied machine learning. I also value cross-domain work that requires learning a complex process and translating it into a reliable, understandable data solution.


Connect

Pinned Loading

  1. aptafind aptafind Public

    Reproducible research software for computational analysis and generative modeling of ssDNA aptamers for small-molecule targets.

    Jupyter Notebook 2

  2. bom-material-planning bom-material-planning Public

    Time-phased BOM material planning and supplier-constrained purchase recommendations

    Python

  3. cad-erp-pipeline cad-erp-pipeline Public

    CAD and PLM engineering data pipeline into validated PostgreSQL ERP models

    Python

  4. gene-metadata-pipeline gene-metadata-pipeline Public

    Bioinformatics ETL pipeline for Ensembl gene metadata using Python, Pandas, and SQLite

    Python

  5. healthcare-clinical-intelligence healthcare-clinical-intelligence Public

    Synthetic FHIR, HL7, claims, quality, analytics, and governed ML platform

    Python

  6. manufacturing-intelligence-platform manufacturing-intelligence-platform Public

    End-to-end manufacturing data platform with PostgreSQL, Tableau, and predictive maintenance

    Python