Available · Pereira, CO

GerwinLambrañoTorres

Software Backend Engineer · Python & FastAPI · REST APIs · Event-driven architecture · Cloud & Data · GCP & Azure · AI-first development

I design backend services and data systems in Python and take them safely to production with FastAPI, Docker and CI/CD, on-premise or in the cloud.

Download CV
Gerwin Lambraño Torres
Latest projectNationwide WhatsApp channel for Colombia's National Planning DepartmentView project

+1.1M

citizen interactions tracked in 2025 by a system I built for Pereira City Hall

View projects

About

Backend engineer, from the data model to production

Backend engineer focused on turning messy manual processes into systems that run reliably in production.

I work mostly in Python, from the data model to the deployment: REST APIs, integrations with third-party platforms, data pipelines and the infrastructure that keeps them running on GCP, Azure or on-premise Linux servers.

I also teach Python for data analysis at Universidad Tecnológica de Pereira, and I'm training my English toward C1.

years building backend
3+
systems in production
5
hours teaching Python
123
  1. 2024 – presentSoftware EngineeroiDATA
  2. 2025 – presentPython InstructorUniversidad Tecnológica de Pereira
  3. 2022 – 2023Junior Backend DeveloperDelphi Analytics
  4. 2020 – 2025Systems and Computer EngineeringUniversidad Tecnológica de Pereira

Experience

Where I've worked

Software Engineer @ oiDATA

May 2024 – PresentFull-time · HybridPereira, ColombiaVerify company

I design, build and deploy software and data systems in Python for public entities and private companies, from the data model to production.

  • Delivered projects from the first meeting to production for Colombia's National Planning Department, Pereira City Hall and an insurance and tax agency in the United States.
  • Support and continuous improvement for the systems I deliver.
  • Co-built an ETL pipeline that cut each purchase order of a spare-parts importer from about 28 hours of spreadsheet work to about 5.
  • Python
  • FastAPI
  • REST APIs
  • PostgreSQL
  • MySQL
  • pandas
  • Docker
  • Linux
  • Azure
  • GCP
  • CI/CD

Projects

Work I'm proud of

  • Personal project

    reorder

    An API that estimates weekly demand per product from its sales history, with the rule and inputs behind each estimate.

    • Rebuilds in the open the demand-estimation engine I first built for a client, with synthetic data.
    • Domain logic kept apart from the framework, tests against a real PostgreSQL database and documented decisions.
    • Python
    • FastAPI
    • PostgreSQL
    • SQLAlchemy
    • Alembic
    • pytest
    • Docker
    • Cloud Run
  • Professional case

    Public policy tracking system for Pereira City Hall

    A data-capture app and a public statistics dashboard that replaced the Excel process of the Secretaría de Planeación.

    • In 2025: 58 officials from 19 city departments, 14 policies and 1.1 million citizen interactions.
    • Validation at the point of capture and an automated check that keeps the dashboard and its reports consistent across 106 scenarios.
    • Runs on the city's on-premise Linux servers with Docker, Traefik and continuous deployment.
    • Python
    • MySQL
    • Streamlit
    • pandas
    • Docker
    • Traefik
    • Linux
  • Professional case

    Purchase-order automation for a spare-parts importer

    An ETL pipeline over the exports of an ERP with no API, from raw sales data to the order for each supplier.

    • Data cleaning, demand estimation, stock vs. in-transit reconciliation and best-price selection across suppliers.
    • Each purchase order went from about 28 hours of spreadsheet work to about 5.
    • Python
    • pandas
    • ETL
    • Streamlit
    • Docker
  • Volunteer

    Damage reporting after the August 2026 earthquake

    A free reporting system, built in three days, for the command posts of Guática and La Virginia (Risaralda).

    • Field reports with photos and GPS location, standardized at the point of capture and prioritized automatically.
    • More than 100 records of affected people and damages.
    • Each municipality sees a map with only its own cases and can export its data at any time.
    • Railway
    • Google Cloud Storage
    • Leaflet

Skills

The stack I work with

  1. APIs

    • REST
    • FastAPI
    • Webhooks
    • GraphQL
  2. Services

    • Python
    • Event-driven design
    • LLM integrations
  3. Messaging

    • Message queues
    • Azure Service Bus
    • Background workers
  4. Data

    • PostgreSQL
    • MySQL
    • SQL
    • pandas
    • ETL
  5. Quality

    • pytest
    • Integration tests
    • Code review
  6. Infrastructure

    • Docker
    • Linux
    • Traefik
    • CI/CD
    • GitHub Actions
    • IaC
    • GCP
    • Azure
  7. Other

    • Git
    • Streamlit
    • Quarto
    • Make
    • Monday.com

Ordered like the layers of a backend service, from the API down to the infrastructure.

Contact

Let's work together

I'm looking for new challenges as aSoftware Engineer | Backend Python Developer

If you need someone to design APIs, connect services and take data systems all the way to production, let's talk!

Email is the quickest way to reach me.