Javier Guerra

I've built production-style Python automation systems, REST API integrations, and local ELT pipelines, with a focus on testing, failure handling, and maintainable workflows.

My GitHub Data Pipeline extracts repository data through the GitHub API, loads it into SQLite, transforms it with reusable SQL, and verifies results through automated pytest tests. I configured Meltano streams and built an orchestrator with subprocess execution, exit-code handling, stage isolation, incremental extraction concepts, and environment-based credentials.

As a freelance digital consultant, I build and maintain websites and practical digital solutions for small-business clients. I also develop reusable automation tools and projects using Python, React, Streamlit, and Pygame while documenting lessons from debugging, validation, and testable design.