javier-guerra

Javier Guerra

v2026.06Latest release · Jun 2026

Full stack web developer · AI and automation

I build web applications end to end with Next.js, TypeScript and Node.js, with special care for the interface. I connect them to data and automations with Python, SQL and n8n to turn complex problems into simple, practical products. Bucaramanga, Colombia.

results.diffsiigo

manual accounting process: 1 full day of work

automated machine run: 20 seconds

automations scattered across tools

single portal for accountants: Next.js + Supabase

13 projects · Spanish native · English proficient (C1)

Release history

v2026.06

Jun 2026 — Present

Siigo

Automation Analyst

Colombia

  • AddedBuilt automations for Siigo Colombia's accounting team with n8n and Power Automate, based on each requirement and access permissions.
  • ResearchedLed multiple requirements-gathering sessions with accountants to map manual processes for later automation.
  • In progressDeveloping a web portal (Next.js, Supabase, Vercel) that brings all these automations together in one place, so accountants can easily access and use them.
  • ImprovedReduced a process that took a full day of manual work to 20 seconds of machine execution.

n8n · Power Automate · Next.js · Supabase · Vercel

v2025.11

Nov 2025 — Jun 2026

AnniQ

AI and Automation Engineer

Intelligent Customer Success Suite · Remote, USA

  • AddedDesigned and implemented automated data ingestion pipelines using n8n, integrating multiple sources and loading structured data into PostgreSQL for both operational and analytical use cases.
  • ImprovedOptimized critical data pipelines, improving processing times and computational efficiency.
  • AddedContributed to data engineering efforts, including data modeling and the design of a data warehouse for social media metrics analysis.

n8n · PostgreSQL · Data modeling

2023–2024

repos created · May 2023 — Sep 2024

Web development

Selected projects

Shipped sites and apps, each with a live link.

  • Pokepedia

    v2023.05 · repo created · May 2023

    Pokémon encyclopedia built with SvelteKit, with data fetched from PokéAPI.

    SvelteKit · Tailwind CSS · TypeScript

  • Gestión Documental Web

    v2024.09 · repo created · Sep 2024

    Informational website for the Document Management technology program.

    Astro · React

  • Techno Fix

    v2024.05 · repo created · May 2024

    Static website for a device repair company.

    Astro · Tailwind CSS · React

  • Luna Llena

    no public date

    Static website for a client.

    Astro · Tailwind CSS

See all 13 projects
v2022.06

Jun 2022 — Dec 2022

NTT DATA

Data/BI Analyst — Terpel GNV Billing Project

Remote, Colombia

  • MigratedSupported the migration from on-premise infrastructure to Google Cloud Platform (GCP) for a national billing platform, improving system reliability and enabling cloud-based process automation.
  • ImprovedWorked with relational databases in billing environments, performing SQL validations, reconciliations, and data quality checks to ensure data integrity.
  • ImprovedMonitored and optimized real-time data operations, documenting critical workflows to reduce errors, improve traceability, and meet operational SLAs.

SQL · GCP · Data quality

v2020.02

Feb 2020 — Nov 2022

UPC

Initial commit

Undergraduate in Systems Engineering

Universidad Popular del Cesar · Valledupar, Colombia · GPA 4.1/5

Dependencies

Languages
Python, JavaScript, TypeScript, SQL, Bash, MQL (MongoDB)
Frameworks / runtimes
Node.js, Next.js, FastAPI, Astro, n8n, Power Automate
Databases
PostgreSQL, MySQL, Oracle, MongoDB
Cloud / DevOps
Azure, Google Cloud Platform, Docker, Firebase, Supabase, Vercel, Git
Data / analytics
Power BI, Tableau, Databricks, ETL/ELT, Excel / Google Sheets
Spoken languages
Spanish (Native), English (Proficient (C1))

What's the next release?

I'm open to full-time roles and freelance projects. If you have an opening, an idea, or a process that eats your hours, tell me what you need.

guerraturizojavier@gmail.comLinkedInGitHub