Christian Ranon
Chicago,IL
Summary
One (1) year applied experience in data analysis, cloud-based database management (PostgreSQL, Snowflake), and ELT pipeline development using Python, Docker, and Azure Virtual Machines. Designed and deployed automated workflows for scraping, transforming, and visualizing political speech data, delivering insights through interactive Power BI dashboards. Skilled in leveraging classical and foundation model NLP tools (e.g., ChatGPT, Claude, NRC EmoLex) for psychometric analysis and cost-efficient sentiment scoring. Strong foundation in SQL, data modeling, and reproducible research practices using Git and containerized environments. Committed to translating complex datasets into clear, actionable insights to support decision-making in academic and policy-oriented contexts.
Overview
1
1
year of professional experience
Work History
Data Analyst I
IE University Research Department
01.2025 - Current
- Developed a psychometric system for labeling the emotional content of Spanish Parliamentary speeches over a battery of different methodologies ranging from: classical Dictionary Methods, specifically with the NRC EmoLex (National Research Council of Canada’s Emotional Lexicon Dictionary); and popular Foundation Models such as ChatGPT, Gemini, and Claude.
- Created an end-to-end data pipeline which web scraped political speeches and associated metadata from the Spanish Parliamentary Website, which was combined with existing data sources of Spanish Politicians for an Extract, Load, and Transform (ELT) process for ingestion into a Data Warehouse (hosted with a containerized Docker Image of PostgreSQL), and presenting findings in a Dashboard with Power BI.
- Investigated alternative and economically efficient sources of psychometric speech labeling with Foundation Models through Language Model Arena (LM Arena), which has a Prompt-to-Leaderboard (P2L) service which ranks model performance on individual queries, discovering alternatives to incumbent services which reduced expected Cloud Services expenditures by 733%.
- Technology List: Python, Git, Docker, Flask, PostgreSQL, PowerBI, Selenium, Puppeteer, Azure Virtual Machines (Azure VM).
Research Data Process Consultant
School of Politics, Economics & Global Affairs @ IE University
05.2025 - 06.2025
- Taught fellow researchers best practices for replicability and reproducibility in code by recommending version control software such as Github and ensuring portable software development through basic usage of Docker Containers.
- Gave seminar about Large Language Model basics, and debugged psychometric scoring issues by recommending changes in model temperature (a parameter used in controlling the deterministic quality of outputs) and switching model paradigms from simply using one-shot-encoding to adopting reasoning model architectures.
Education
Bachelor of Science - Business and Data Analytics
IE University, School of Science And Technology
Madrid, Spain07.2025
High School Diploma - undefined
Niles West High School
Skokie, Illinois01.2021
Skills
- Computing Languages and Technologies: Python, SQL, Docker, Tableau, Power BI, Git Red Hat Enterprise Linux (RHEL) NixOS Databricks Snowflake
- Concepts: Relational Databases Entity-Relationship Design Dimensional Design Object-Oriented Design Algorithms and Data Structures Big Data Analytics Version Control Virtualization Containerization
Websites
Languages
Spanish
Professional Working
Timeline
Research Data Process Consultant
School of Politics, Economics & Global Affairs @ IE University
05.2025 - 06.2025
Data Analyst I
IE University Research Department
01.2025 - Current
High School Diploma - undefined
Niles West High School
Bachelor of Science - Business and Data Analytics
IE University, School of Science And Technology
Similar Profiles
Kathleen Ernsberger, MPHKathleen Ernsberger, MPH
Project Management Specialist at Indiana University School of Medicine, Department of Surgery | Surgical Outcomes Quality Improvement Center (SOQIC) Health Services Research DivisionProject Management Specialist at Indiana University School of Medicine, Department of Surgery | Surgical Outcomes Quality Improvement Center (SOQIC) Health Services Research Division
Ramsha MasoodRamsha Masood
Scientific researcher at Laboratory for Translational Research at Department for Internal Med 1. University Medical Center Hamburg EppendorfScientific researcher at Laboratory for Translational Research at Department for Internal Med 1. University Medical Center Hamburg Eppendorf
Vinitha DeepuVinitha Deepu
Postdoctoral Fellow at Department of translational research, Western University of Health SciencesPostdoctoral Fellow at Department of translational research, Western University of Health Sciences
Erika HarrisErika Harris
Home Care Provider at State of IllinoisHome Care Provider at State of Illinois
James WebbJames Webb
Vice President of IT at Hu-Friedy Mfg. Co LLCVice President of IT at Hu-Friedy Mfg. Co LLC