ES — Leer en español
Santiago Machuca Páez

Santiago Machuca Páez

Backend Developer

Python · FastAPI · Java · Spring Boot · Data & ETL

Get in touch

About me

Software Developer working since 2022 with Python (FastAPI) and Java (Spring Boot). I build efficient, scalable and maintainable solutions, and I take part in the whole cycle: from gathering requirements to deploying and running them in production.

I work close to the data: I clean, transform and analyze it with Pandas, NumPy and Scikit-learn, design ETL processes and data processing systems, and build AI-powered solutions. I model and optimize enterprise databases, mainly PostgreSQL and Oracle.

I stand out for analytical thinking and for delivering practical solutions, combining knowledge of the telecommunications industry with current technologies. I’m currently expanding my experience into cloud architectures, with continuous learning to build ever more resilient systems.

Experience
4 years 2 months
Main stack
Python · FastAPI · Java · Spring Boot · SQL
Location
Asunción, Paraguay · Remote
Languages
Spanish (native) · English (C1 — EF SET)

Experience

  1. Backend DeveloperAvatar Informática

    — Present(2 years 6 months)

    Remote · Argentina

    • Development and maintenance of backend services with Java and Spring Boot in a layered architecture (Controller, Service, Repository), with persistence through Spring Data JPA, and complementary services in Python with FastAPI.
    • Design and implementation of RESTful APIs for integration between systems and communication between services.
    • SQL query optimization and database modeling on Oracle and PostgreSQL, with stored procedures and functions that support business-critical processes.
    • Implementation of a support module for the Level 2 (N2) team that reduced incident resolution times through internal tools and better error traceability.
    • Development of ETL processes for bulk data ingestion, transformation and loading, ensuring integrity, consistency and availability.
    • Deployment and operation of services on OpenShift (pods, configurations, resources) and Linux server administration: processes, environments and production monitoring.
    • Large-scale geographic data management with Python, QGIS and PostGIS.
    • Functional and technical testing, and data quality validation, contributing to the stability of streaming platforms.
    • Java
    • Spring Boot
    • Spring Data JPA
    • Python
    • FastAPI
    • Pandas
    • GeoPandas
    • Oracle
    • PostgreSQL
    • Docker
    • OpenShift
    • Linux
    • GitLab
    • Looker Studio
    • Power BI
    • QGIS

  2. Backend Developer / Functional AnalystConsultores Informáticos

    — (1 year 9 months)

    Paraguay

    • Backend development of internal applications: REST APIs and business logic.
    • Development and deployment of serverless functions with Node.js on AWS Lambda.
    • Design and modeling of relational databases (PostgreSQL, SQL Server) and data access with Sequelize.
    • User, role and access management with Keycloak.
    • Gathering and analysis of functional requirements with users and stakeholders.
    • JavaScript
    • Node.js
    • Sequelize
    • AWS Lambda
    • Keycloak
    • PostgreSQL
    • SQL Server
    • Docker
    • GitLab
    • GitHub

Projects

Websites

Professional projects (anonymized)

Personal projects

Skills

  • Languages

    • Java
    • Python
    • JavaScript
    • TypeScript
    • SQL
    • Go

  • Backend

    • Spring Boot
    • Spring Data JPA
    • FastAPI
    • Flask
    • Node.js
    • Express
    • Sequelize
    • SQLAlchemy
    • REST APIs

  • Frontend

    • React
    • Next.js
    • Astro
    • Tailwind CSS

  • Data

    • ETL
    • Pandas
    • NumPy
    • GeoPandas
    • Matplotlib
    • PyQGIS
    • PostGIS
    • QGIS

  • Databases

    • Oracle
    • PostgreSQL
    • SQLite
    • Supabase
    • SQL Server
    • Stored procedures

  • Cloud & DevOps

    • Docker
    • OpenShift
    • AWS (Lambda)
    • GCP
    • Linux
    • GitLab
    • GitHub
    • Keycloak

  • Visualization

    • Looker Studio
    • Power BI

Education

  • Information Systems Analysis (in progress)

    Universidad Católica Nuestra Señora de la Asunción

    — Present · Program class representative

  • Computer Applications Programmer

    Universidad Católica Nuestra Señora de la Asunción

    —

  • Advanced English 1

    Centro Cultural Paraguayo Americano (CCPA)

    —

Languages

Spanish
Native
English
C1 (EF SET Advanced)

Certifications