Intro
Hey there! I’m Hugo Seguin, your friendly neighborhood Associate Cloud and Data Science Engineer at Realm of Caring 🏙️. With a Master’s degree in Social Psychology 🧠, I’m all about merging the worlds of data science and human behavior.
My main focus? Building fast processing pipelines ⚡, analyzing data at lightning speeds 💻, and of course, playing video games 🎮. I love combining my coding skills with my background in psychology to create powerful, data-driven insights.
I’m passionate about using data science methods to enhance psychological research, especially when it comes to improving the strength, validity, and reliability of data 📊. I’m all in for using big data to bring faster insights to the world of psychology! 🚀
It’s the kind of work that keeps me up at night (in a good way, of course! 😴). If you're looking for a Data Engineer or Data Scientist, I’m your guy! 💼 Or if you're just as passionate about psychology and big data methods as I am, let’s nerd out together! Hit me up on LinkedIn! 📩
Oh, and if you want to vibe with me while I crunch data, check out what I am currently listening to:
Playlist Last Updated: December 2024
Connect on LinkedIn
Work
Check out my R Code repository on GitHub for examples of R programming projects, including visualizations and analyses from my Master's thesis. Below is a sample visualization.
Explore my Python Projects repository on GitHub for examples of Python-based analytics and visualizations. Below is an example from my work.
Resume
Skills:
- Coding Languages: Python, SQL, SAS, R, Java, JavaScript, Node.js, C++
- Database Technologies: MySQL, PostgreSQL, MongoDB, Graph DB, Cloud Data
- Big Data Technologies: Hadoop, Docker, Pyspark, Airflow, Mage.AI, CLI/Bash, Kubernetes
- Version Control: Git, GitHub
- Architecture as Code: Terraform, Ansible
- Design: Draw.IO, Flowchart
- Business Visualization Tools: Tableau, PowerBI, SAS Visual Analytics (Redshift)
- Cloud Platforms: AWS, Tableau Cloud
- Data Quality: Great Expectations, AWS Glue
- Database Management: pgAdmin4, DBeaver
- Statistics: 8 years of quantitative and qualitative analysis
- Machine Learning: Supervised/Unsupervised Learning, NLP (Scikit-learn, Keras, TensorFlow)
- Software: Postman, MS Office/PowerPoint, Google Workspace, Gravity Forms
Work Experience:
Realm of Caring (ROC)/ Data Manager
Location: Chicago, IL | Duration: October 2023 - Present
- Led design and development of data architecture for NIH-funded projects.
- Cleaned and prepared a decade-old dataset for analysis and ensured integrity.
- Developed ETL processes for live datasets and migrated to AWS, ensuring PHI/HIPAA compliance.
- Implemented AWS architecture for a data pipeline with PostgreSQL storage for querying and analysis.
- Utilized qualitative data analysis techniques for studies and publications.
- Designed and deployed data pipelines using Mage.AI and Docker, integrating biological datasets.
- Managed security protocols and legal compliance using AWS IAM, VPC, and data encryption.
Des Moines Area Community College (DMACC)/ Data Analyst
Location: Ames, IA | Duration: May 2023 - October 2023
- Conducted focused data analysis and reporting on institutional data for external entities.
- Utilized SAS and SQL for reporting key performance indicators to IPEDS, MIS, and NCCBP.
- Automated post-graduation outcomes reports using SAS and analyzed qualitative data with Python.
- Consulted on research projects, providing swift data analysis and survey creation support.
Projects:
ROC Projects:
- AWS NIH Project: Led migration of complex dataset from REDCap, developed ETL pipeline, and ensured HIPAA compliance.
- Article API Dashboard: Developed automated pipeline using GraphQL and Mage.AI to visualize article metrics on Tableau dashboards.
- Registry Version 1/2 Data Cleaning Project: Cleaned and migrated Registry data, automated dashboards on AWS, reducing costs by 20%.
DMACC Projects:
- Data Governance Policy Project: Contributed to data governance team and policy, created data dictionary to eliminate silos.
Education:
- Iowa State University - Masters of Science, Social Psychology (GPA: 3.80), Ames, IA, USA
- Bishops University - Bachelor of Arts, Honors Applied Psychology (GPA: 3.9), Sherbrooke, QC, Canada