- Pipeline processing ~400 PDFs spanning 25 years of Spanish university entrance exams (Chemistry, Mathematics II and Applied Math): statement extraction, automatic cropping to images and storage in SQLite.
- Automatic topic classification with an LLM (Claude Haiku), guided by taxonomies and topic-specific instructions.
- Multipage Streamlit web app with filters, checkbox selection (st.data_editor), state management and deployment on a self-managed VPS; in real use as a teaching tool.
Daniel Ramírez Ruiz
Data Analyst & Python Developer · Streamlit · SQL · R · Applied AI
Professional profile
Chemical Engineer turned data analyst and Python developer. I design and deploy end-to-end applications: data extraction and cleaning, SQL databases, LLM integration via API, web interfaces with Streamlit and deployment on Linux servers. Author of a hands-on data analysis book with R and freelance Python and Data Analytics trainer for CodeSpace Academy. I combine technical rigor, the ability to explain complex topics simply, and intensive use of AI tools in my development workflow.
Technical skills
- Languages
- PythonRAdvanced SQL
- Data & analysis
- pandasNumPytidyversedplyrtidyrggplot2lubridatestringrdbplyrAdvanced Excel
- Databases
- MySQLPostgreSQLSQLiteWindow functionsCTEsComplex joinsData modeling
- Apps & web
- Streamlit (multipage, session_state, st.data_editor)Flask + Jinja2HTML/CSS
- Applied AI
- Anthropic API (Claude)Classification pipelinesPrompt engineeringAI in the development cycle
- Visualization / BI
- Power BITableauggplot2
- Machine Learning
- scikit-learn (intermediate)
- Systems & tooling
- Linux (Debian, Arch)VPS administrationGit/GitHubuvR MarkdownQuarto
Key projects
- Stock management application for chemical products with an orders/cart module, built for day-to-day laboratory use.
- Evolution of an earlier CRUD prototype in Flask + SQLite (routes, Jinja2 forms, GET/POST, error handling).
A hands-on data analysis course in R from scratch (in Spanish).
- 15-chapter manual with progressive exercises on the real nycflights13 dataset (336,000 flights): transformation, joins, pivoting, dates and visualization.
- Automated Markdown-to-PDF typesetting with cover page and table of contents.
- Expansion in progress: connecting to MySQL databases with dbplyr, with business problems solved in both SQL and R.
Other projects
- PDF editor in Streamlit for viewing and manipulating documents.
- Web scraping of an online bookstore catalog with BeautifulSoup and Selenium.
- Interactive financial dashboard in Power BI.
- Synthetic dataset of lung cancer incidence with Python.
- Data cleaning with SQL, pandas and R.
Professional experience
CodeSpace Academy · freelance
- Delivered the course from scratch to intermediate level: data types and structures, control flow, functions, file handling and object-oriented programming.
- Designed hands-on exercises with custom datasets and quick-reference guides (best practices, PEP 8, type hints).
CodeSpace Academy · freelance
- Hands-on data analysis course with Excel, SQL and Power BI: queries, data modeling and dashboard building.
Academia Osorio
- Preparing students for the Spanish University Entrance Exams (Selectividad).
- Developing in-house tools (Python, Streamlit, AI) to automate the creation of teaching materials.
Self-employed
- University entrance exam preparation and support in Chemistry, Physics, Mathematics, Biology, English and German. Cambridge exam preparation (B1, B2, IELTS) in 2016–2017.
- Laboratory Assistant · AYG Materials Quality Control Laboratory (2007–2009): chemistry and steel testing laboratories, technical reports with Excel.
- Sales Promoter for Acer and AMD · Carrefour Rosaleda shopping center (2010–2011).
- Science Teacher · Academia Centros DIF (2011).
Education
- Data Science Bootcamp · CodeSpace Academy2024
- Machine Learning · Codebasics2024
- Python Data Science Mastery · DS4B2024
- Chemical Engineering · University of Málaga2014
Additional: Firefox OS App Development (HTML5, 40 h, 2013) · Network and Computer Systems Security (Academia Unitec, 2011).
Languages
- Spanish · Native
- English — C1/C2 · Certificate in Advanced English (C1); preparing for the Certificate of Proficiency (C2). Fluent technical documentation and professional communication.
- German — B2 · telc Deutsch B2 (2017)