Skip to content
View Sublian's full-sized avatar
:octocat:
:octocat:

Block or report Sublian

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.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
sublian/README.md

Python Django FastAPI PostgreSQL Celery Redis

Hello! 👋 I'm Luis Gonzalez

Software Engineer · Python Backend Specialist · Lifelong Learner

I'm a Backend Python Engineer with 2+ years working on production systems, specializing in API design, process automation, and high-performance backend services using Django, FastAPI, Flask, and Odoo. My work is focused on building scalable, maintainable architectures that are easy to evolve and operate in real-world environments.

I enjoy tackling complex performance bottlenecks, designing clear and robust abstractions, and writing clean, well-tested code that teams can rely on over time. I care about code quality, observability, and modern DevOps practices to ensure systems are not only functional, but reliable in production.


🧠 Active Learning & Skill Development

I believe in learning by doing and following a structured approach to growth. I run an ongoing Upskilling Project to deepen my expertise in core backend and DevOps skills.

🎯 T1-Upskilling-2025: Structured Learning Project

I use a GitHub Project Board to plan, track, and document my learning journey. Each skill or concept is broken down into actionable issues, linked directly to the code I write in dedicated practice repositories.

  • Purpose: Systematically advance in backend architecture, advanced testing, and modern DevOps.
  • Methodology: Theory → Practice → Code Repository → Documentation.
  • Current Focus Areas: Advanced Pytest patterns, microservices design, and AWS fundamentals.
  • 👉 View my Upskilling Project Board & Progress

This public board reflects my commitment to deliberate practice, continuous improvement, and transparent skill-building.


🛠️ Tech Stack

Backend & Frameworks: Python, Django, Django REST Framework, FastAPI, Flask, Celery

Databases & Caching: PostgreSQL, MySQL, MongoDB, Redis · Query optimization, indexing strategies

Testing & Quality: Pytest, unit/integration testing, mocking, TDD, coverage analysis

DevOps & Tooling: Docker, Docker Compose, Git, GitHub Actions (CI/CD pipelines), Linux

Architecture & Patterns: REST APIs, JWT auth, background tasks, service layer patterns, microservice-oriented design (in progress)

Specialties

  • Performance Optimization: Systematic profiling with cProfile + SnakeViz, hot‑path analysis, and targeted refactors to reduce execution time in critical paths.

  • Database Performance: Query tuning in PostgreSQL using EXPLAIN ANALYZE, indexing strategies, and rewrite of heavy joins/aggregations for significant latency reduction.

  • Architecture: Pragmatic use of design patterns (Factory, Strategy, service layers) and modular backend design.

  • Testing & QA: Pytest-centered workflows, high-value test suites, Swagger/OpenAPI-driven contracts.

  • Automation: Scripting, scheduled jobs, reporting and monitoring tasks.


🚀 Featured Projects

Here are some key public projects that represent how I design, test, and ship backend systems.

🔐 Professional Django API Template · 100% test coverage

(Django • Docker • JWT • PostgreSQL • Pytest)

Production-ready, reusable template for secure backend APIs. Includes JWT authentication with refresh token rotation, a role-based permission system (admin/staff/client), rate limiting, and a fully containerized setup with Docker.

Testing: Reached 100% test coverage with 60+ tests, including integration coverage for API endpoints, authentication flows, and permissions, following professional QA practices.

Highlights:

  • Factory Boy–based test data, advanced mocking, and end-to-end API tests
  • Designed as a modern foundation for SaaS, mobile backends, or microservices
  • CI/CD-friendly structure with automated test workflows

⚙️ Django 🐳 Docker 🔒 JWT 🐘 PostgreSQL 🧪 Pytest 📊 100% Coverage

View Repository


🧠 Background Task Processor with Django & Celery

(Django • Celery • Redis • PostgreSQL • Pandas)

Backend service for asynchronous file processing (CSV/Excel) using Celery and Redis. Handles long-running tasks, decouples user requests from heavy processing, and exposes a dashboard for tracking upload status and historical runs.

Highlight: Demonstrates production-style async patterns: task queues, retries, monitoring, and user feedback for background work.

⚙️ Django 🧵 Celery 🔴 Redis 📊 Pandas

View Repository


📧 Daily English Phrases Mailing System

(Flask • MySQL • JWT • Bootstrap • Cron)

Full-stack web application for automated daily email delivery. Implements multi-role accounts (free/premium), email confirmation, a personalized admin dashboard, and a mailing workflow with retries and scheduling.

Highlight: Showcases user management, scheduled jobs, transactional email flows, and a responsive UI deployed to production.

⚡ Flask 🍃 MySQL ✉️ SMTP 🎨 Bootstrap

View Repository · Live Demo ↗


🧪 Pytest Learning Lab

(Pytest • Fixtures • Mocking • Parametrization • uv)

Hands-on repository documenting my deep dive into advanced testing patterns in Python. Covers reusable fixtures, parametrized tests, and robust mocking of external APIs and services, all running on a modern uv-based test environment.

Highlight: Serves as a living knowledge base for professional-grade testing practices, focused on readability, intent-revealing test names, and fast feedback loops.

✅ Pytest 🎭 Mocking 🧩 Fixtures & Parametrize 🛠️ uv

View Repository


📈 Achievements & Metrics

  • Testing Excellence: Achieved 100% test coverage on my Django API Template (60+ tests, including integration suites for endpoints, auth flows, and permissions), reflecting strong, automated QA practices.
  • Legacy System Optimization (Odoo): Delivered a 45x performance improvement on a critical module, reducing processing time from 20+ hours to under 3 hours through profiling, query refactors, and better indexing.
  • Database Performance: Improved complex query response times by 300% on tables with 10,000+ records using EXPLAIN ANALYZE, strategic indexing, and query simplification.
  • Quality Discipline: Aim to keep 90%+ test coverage on main repositories and rely on CI/CD pipelines for continuous, automated quality checks.

🌱 Currently & Next Steps

  • Working on: Optimizing and progressively migrating a legacy Odoo v13 system into Django REST Framework services, with a focus on performance, maintainability, and clean API boundaries.
  • Learning: Deepening my understanding of microservices architecture and growing my AWS cloud skills (deployment, networking, and managed services for backend workloads).
  • Collaboration: Interested in contributing to Python open-source projects, developer tooling, and technical documentation initiatives like python-docs-es.
  • Open to: Remote-friendly backend roles, collaboration on Python infrastructure/testing projects, and mentorship opportunities (both giving and receiving).

📊 Other Projects

Project Description Tech Stack
🏥 Hospital Records System Backend for medical data management with FastAPI and Docker, handling ~1k new records per day with secure access and structured data workflows. FastAPI Docker PostgreSQL JWT Jinja2
💸 Automated Payroll System Redesign and automation of complex payroll calculations (allowances, deductions, taxes), significantly improving processing efficiency and reducing manual errors. Django Pandas NumPy PostgreSQL Jinja2

📫 Let's Connect

  • Email: subliandev@gmail.com
  • GitHub: @Sublian
  • LinkedIn: @Luis_Gonzalez
  • Languages: English (B2 - EFSet Certified), Spanish (Native).
  • Community: Active contributor as a translator for the official Python documentation in Spanish.

Thanks for visiting my profile! Always open to discussing technology, optimization challenges, and new opportunities.


Pinned Loading

  1. Daily_English_Phrases Daily_English_Phrases Public

    Sistema de Envío de Frases Diarias . Un sistema web completo para el envío automatizado de frases diarias por correo electrónico, con gestión de usuarios y panel de administración.

    Python 1

  2. pytest-learning-lab pytest-learning-lab Public

    Learning lab de Pytest centrado en tests profesionales: parametrización, fixtures avanzadas, mocking de HTTP/correo y preparación para CI/CD en backends Python.

    Python 1

  3. django-docker-postgres_basic django-docker-postgres_basic Public

    Proyecto inicial sobre django con postgresql usando docker para levantar el proyecto completo, se usa DRF con un modulo de usuario. Ver readme.md para más informacion

    Python 2

  4. django_celery django_celery Public

    Django con tareas en segundo plano. Orientado a Facturación electrónica en Peru. Inspirado en Odoo

    Python 1

  5. django_background_task django_background_task Public

    Asynchronous background task system for Django using Celery and Redis, focused on offloading long-running jobs (emails, reports, file processing) from HTTP requests and monitoring them with product…

    HTML 1