Skip to content
View ceugenia's full-sized avatar

Block or report ceugenia

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
ceugenia/README.md

👋 Hi, I'm Constanza Eugenia Perez!

Data Analytics Professional | Data Engineering | SnowPro Core Certified | SQL | Python | Snowflake

I'm a data professional with a background in data analytics, computational biology, bioinformatics, and clinical data. I specialize in working with complex datasets, developing reproducible analytical workflows, and turning raw data into useful insights.

My current focus is data analytics and growing toward data engineering, with particular interest in SQL, Python, Snowflake, data warehousing, ETL/ELT, data quality, and cloud-based data workflows.

My scientific and clinical background has given me experience working with large datasets, troubleshooting technical problems, validating data, documenting workflows, and communicating data-driven findings to both technical and non-technical audiences.

🏆 SnowPro Core Certified


🎯 What I'm Focused On

  • 📊 Data Analytics & Exploratory Data Analysis
  • 🐍 Python Data Processing & Automation
  • 🗄️ SQL & Data Modeling
  • ❄️ Snowflake & Cloud Data Warehousing
  • 🔄 ETL / ELT & Data Pipelines
  • 🔍 Data Quality & Validation
  • 📈 Data Visualization & Dashboards
  • 🧬 Bioinformatics & Computational Biology
  • 🧪 Clinical & Healthcare Data
  • ☁️ Building toward Data Engineering

Career Path

Data Analytics → Analytics Engineering → Data Engineering

I'm seeking opportunities where I can combine my analytical background with growing expertise in modern data engineering technologies.


🛠️ Tech Stack

Data Engineering & Analytics

Python · SQL · Snowflake · Pandas · NumPy · R

  • Data ingestion
  • ETL / ELT
  • Data transformation
  • Data cleaning
  • Data validation
  • Data quality
  • Data modeling
  • Exploratory Data Analysis
  • Statistical analysis
  • Data warehousing
  • Analytical workflows

Databases & Cloud

Snowflake · SQLite · SQL

  • Relational databases
  • Cloud data warehousing
  • SQL analytics
  • Database management
  • Data loading
  • Analytical data structures

Visualization & Applications

Streamlit · Shiny · Plotly · Dash · ggplot2

  • Interactive dashboards
  • Exploratory visualization
  • Data storytelling
  • Analytical applications

Programming & Development

Python · R · SQL · Bash · Git · GitHub · Linux

Machine Learning

scikit-learn · XGBoost

  • Logistic Regression
  • Random Forest
  • Decision Trees
  • XGBoost
  • Feature engineering
  • Model evaluation
  • PCA
  • UMAP
  • Clustering

Bioinformatics & Computational Biology

Seurat · Scanpy · CIARA · Monocle3 · scVelo · Slingshot · Destiny

  • Single-cell RNA-seq
  • Bulk RNA-seq
  • Spatial transcriptomics
  • Transcriptomic analysis
  • Cell clustering
  • Cell-type identification
  • Rare-cell detection
  • Developmental trajectory analysis

Clinical Data

  • Electronic Data Capture (EDC)
  • Clinical research data
  • Data validation
  • Data quality control
  • Source data verification
  • HIPAA-compliant data handling
  • iMedidata
  • IBM Clinical Development
  • InForm
  • ProSoft Clinical
  • Veeva Vault

📁 Featured Projects

🥤 Melanie's Smoothies

End-to-End Data Engineering & Analytics Platform

A practical data engineering and analytics project built around a smoothie shop business use case.

The project demonstrates how data can move from external sources and APIs through Python processing, SQL, relational storage, Snowflake, and an interactive Streamlit application.

🔄 Data Workflow

External Data / REST APIs
          ↓
   Python Ingestion
          ↓
Data Cleaning & Transformation
          ↓
       SQLite
          ↓
    SQL Analytics
          ↓
      Snowflake
          ↓
 Streamlit Application
          ↓
   Business Insights

🛠️ Technologies

Python · SQL · REST APIs · SQLite · Snowflake · Streamlit · Pandas · Git

What This Project Demonstrates

  • API integration
  • Data ingestion
  • Data cleaning and transformation
  • Relational database workflows
  • SQL analytics
  • Cloud data warehousing
  • Snowflake
  • Interactive data applications
  • End-to-end data workflow design
  • Git/GitHub project organization

🔗 Repository: https://github.com/ceugenia/melanies_smoothies


🧬 immune-chord

Single-Cell RNA-seq Data Analytics Pipeline

A computational biology analytics workflow focused on identifying and exploring rare cell populations in single-cell RNA sequencing data.

What I Worked On

  • Processed single-cell RNA-seq datasets
  • Performed quality control and preprocessing
  • Applied normalization and dimensionality reduction
  • Used PCA and UMAP for exploratory analysis
  • Applied clustering and population-level analysis
  • Created data visualizations for biological interpretation
  • Organized reproducible analytical workflows

Technologies

R · Seurat · Python · Pandas · UMAP · EDA · Conda


🖼️ PTBP1 ImageJ Analysis Suite

Microscopy Data Analytics & Image Processing

A data analysis workflow for quantifying protein localization from microscopy datasets.

What I Worked On

  • Processed and analyzed 26,000+ cell images
  • Automated portions of the image analysis workflow
  • Used Python for data processing and analysis
  • Applied OpenCV and scikit-image for image-based feature extraction
  • Performed statistical analysis
  • Created visualizations and analytical reports
  • Presented research findings at the CSUF Research Symposium

Outcome

26,040 cells analyzed

Technologies

Python · ImageJ/Fiji · OpenCV · scikit-image · Dash · Statistical Analysis


🔬 CIARA-MGCrestLab-SC 🔒

Rare-Cell Detection & Transcriptomic Data Analytics

Comparative analysis of rare-cell detection methods using human gastrula single-cell RNA-seq datasets.

What I Worked On

  • Performed exploratory data analysis
  • Preprocessed and normalized single-cell datasets
  • Applied dimensionality reduction and clustering
  • Compared rare-cell detection approaches
  • Performed statistical analysis
  • Analyzed developmental trajectory and pseudotime data
  • Developed visualizations for algorithm comparison
  • Used R and Python for reproducible analysis

Outcome

CIARA achieved 0.92 recall at low read depth and identified rare hemogenic endothelial progenitor populations.

Technologies

R · Python · Seurat · CIARA · Monocle3 · Statistical Analysis · Data Visualization


📊 MGCrestLab ShinyApp 🔒

Interactive Single-Cell Data Analytics Dashboard

An interactive R Shiny application designed to make transcriptomic datasets easier to explore and analyze.

Features

  • Interactive exploration of Seurat clusters
  • Gene-expression visualization
  • Heatmaps
  • Scatter plots
  • Bar charts
  • Data filtering
  • Exploratory analysis
  • Research-oriented data visualization

Outcome

Improved accessibility and efficiency of exploratory data analysis for research collaborators.

Technologies

R · Shiny · Seurat · ggplot2 · Plotly


💼 Professional Experience

Computational Biology / Research Data Analysis

MGCrest Lab — University of California, Riverside

November 2023 – September 2025

Worked with large-scale single-cell and bulk transcriptomic datasets focused on neural crest development.

Highlights

  • Worked with 5+ TB of single-cell and bulk RNA-seq data
  • Developed reproducible analytical workflows using Python and R
  • Performed data ingestion, cleaning, quality control, transformation, and exploratory analysis
  • Applied normalization, PCA, UMAP, clustering, and marker analysis
  • Used CIARA, Monocle3, Seurat, Scanpy, scVelo, and Slingshot
  • Developed interactive R Shiny applications for data exploration
  • Investigated rare-cell populations and developmental trajectories
  • Documented analytical workflows and maintained reproducibility
  • Troubleshot computational and data-processing problems

Data Specialist

CenExel ACT — Anaheim Clinical Trials

June 2022 – August 2023

Worked with clinical research data across multiple Electronic Data Capture systems.

Highlights

  • Processed and validated 5,000+ clinical records
  • Maintained 99.8% data accuracy
  • Worked across multiple EDC platforms
  • Performed data quality checks and discrepancy resolution
  • Supported quality assurance and user acceptance testing
  • Identified data inconsistencies and workflow issues
  • Collaborated with clinical research teams
  • Created and delivered training on data-entry procedures
  • Worked within HIPAA, FDA, GCP, and clinical research requirements

EDC Platforms

iMedidata · IBM Clinical Development · InForm · ProSoft Clinical · Veeva Vault


🧪 Research & Computational Data Experience

My research background provides a strong foundation for working with complex and high-dimensional datasets.

I've worked across:

Biological Data
      ↓
Data Cleaning
      ↓
Quality Control
      ↓
Transformation
      ↓
Exploratory Analysis
      ↓
Statistical Analysis
      ↓
Visualization
      ↓
Data-Driven Findings

This experience translates directly into data analytics and data engineering because the underlying challenges are similar:

  • Large datasets
  • Data quality
  • Reproducibility
  • Automation
  • Validation
  • Data transformation
  • Troubleshooting
  • Documentation
  • Communicating results

❄️ Snowflake

I'm particularly interested in Snowflake and cloud data engineering.

My focus includes:

  • Cloud data warehousing
  • SQL
  • Data loading
  • Data transformation
  • Data modeling
  • ETL / ELT
  • Analytical datasets
  • Data quality
  • Scalable analytics

Certification

🏆 SnowPro Core Certified

I'm continuing to expand my Snowflake skills through hands-on projects and data engineering coursework.


🐍 Python

Python is one of my primary tools for data analysis and data engineering.

I use Python for:

  • Data ingestion
  • REST API integration
  • Data cleaning
  • Data transformation
  • Exploratory analysis
  • Automation
  • Statistical analysis
  • Machine learning
  • Visualization
  • Data applications

Libraries

Pandas · NumPy · scikit-learn · Plotly · Streamlit · OpenCV · scikit-image


🗄️ SQL

SQL is a core part of my transition toward data engineering.

I use SQL for:

  • Data exploration
  • Filtering and aggregation
  • Joins
  • Data transformation
  • Analytical queries
  • Data validation
  • Business metrics
  • Relational data workflows
  • Data warehouse analysis

I'm continuing to deepen my knowledge of SQL and data modeling through hands-on projects.


📊 Data Analytics

My analytics workflow typically follows:

Question
   ↓
Data Collection
   ↓
Data Cleaning
   ↓
Data Validation
   ↓
Exploratory Analysis
   ↓
Transformation
   ↓
Visualization
   ↓
Insights

I focus on making analytical workflows reproducible, understandable, and useful for decision-making.


📚 Education

University of California, Riverside

B.S. Microbiology University Honors Program Graduated June 2025

Relevant coursework:

  • Genetics
  • Molecular Biology
  • Immunology
  • Virology
  • Applied Linear Algebra

Miami Dade College

A.A. Computer Engineering

  • Highest Honors
  • Dean's List, 2017–2019

Fullerton College

Biotechnology Laboratory Assistant Skills Certificate


🏆 Certifications & Training

Certifications

🏆 SnowPro Core Certification — Snowflake

Additional Training

  • Hands-On Essentials: Data Engineering Workshop — Snowflake
  • Hands-On Essentials: Data Warehousing Workshop — Snowflake
  • NASA GeneLab GL4U Intro OnDemand
  • Biotechnology Laboratory Assistant Skills Certificate

Continuing Education

Currently expanding skills in:

  • Cloud data engineering
  • SQL
  • Data warehousing
  • ETL / ELT
  • BigQuery
  • Databricks
  • Modern data pipelines

🎯 Career Direction

I'm currently focused on Data Analytics while strategically building toward Data Engineering and Analytics Engineering.

Current Target Roles

  • Data Analyst
  • Data Analytics Analyst
  • Healthcare Data Analyst
  • Clinical Data Analyst
  • Bioinformatics Data Analyst
  • Analytics Engineer
  • Junior Data Engineer
  • Data Engineer

Areas of Interest

  • Healthcare
  • Clinical research
  • Pharmaceuticals
  • Life sciences
  • Biotechnology
  • Scientific data
  • Cloud data platforms
  • Business analytics
  • Data engineering

I enjoy roles where I can combine technical data skills with domain knowledge to solve real-world problems.


📈 What I'm Building Next

My current development path is focused on moving from analytical workflows toward production-oriented data systems.

Data Analytics
      ↓
Advanced SQL
      ↓
Data Modeling
      ↓
ETL / ELT
      ↓
Cloud Warehousing
      ↓
Data Pipelines
      ↓
Data Engineering

I'm especially interested in developing stronger skills in:

  • Advanced SQL
  • Snowflake
  • AWS
  • Data pipelines
  • ETL / ELT
  • Data modeling
  • Cloud architecture
  • Data quality engineering
  • Workflow automation
  • CI/CD
  • Production data systems

🌎 Languages

  • 🇺🇸 English
  • 🇪🇸 Spanish

📫 Connect With Me

GitHub

🔗 https://github.com/ceugenia

LinkedIn

🔗 https://linkedin.com/in/constanza-eugenia


⭐ Featured Repository

If you're interested in seeing how I apply my growing data engineering skills to a practical business scenario:

🥤 Melanie's Smoothies https://github.com/ceugenia/melanies_smoothies


💡 My Data Philosophy

Good data work should be reproducible, reliable, understandable, and useful.

Whether I'm analyzing genomic data, clinical research records, or business datasets, I approach problems by combining data quality, analytical thinking, programming, and clear communication.

I'm building toward a career where I can use that foundation to design better data workflows and eventually build scalable data systems.


⭐ Thanks for visiting my GitHub!

Pinned Loading

  1. immune-chord immune-chord Public

    An end-to-end R pipeline utilizing the BigSur algorithm for robust detection and analysis of rare cell populations in single-cell RNA sequencing data.

    R 4

  2. ptbp1-imagej-analysis ptbp1-imagej-analysis Public

    Automated ImageJ/Fiji and Python pipeline for quantifying PTBP1 and RRM2 domain subcellular localization from fluorescence microscopy images in heterokaryon assays.

    Jupyter Notebook 4

  3. melanies_smoothies melanies_smoothies Public

    This will be the web version of the smoothie order form

    Python