Johan's Avatar

Full-Stack Developer Building Solutions with Real Impact

Detailed UIs โ€ข Scalable Systems โ€ข Smart Automation

Full-stack developer specializing in ETL and automation. React, Python, SQL, SAP. I build tools that genuinely improve how teams work.

2+
Years Coding
2
Featured Projects
โˆž
Problems Solved

What I Do

Frontend Craft

Interfaces that feel right

  • โ†’ React, Next.js, Astro
  • โ†’ Responsive design that works
  • โ†’ Performance optimization
  • โ†’ Pixel-perfect implementations

Backend Engineering

Architecture that scales

  • โ†’ Python, Node.js APIs
  • โ†’ SQL Server, PostgreSQL, MongoDB
  • โ†’ RESTful services design
  • โ†’ Database optimization

Data & Automation

Processes that run themselves

  • โ†’ ETL processes from SAP
  • โ†’ Python automation scripts
  • โ†’ Data pipelines & workflows
  • โ†’ Batch processing & scheduling
Coming Soon

AI & ML

Intelligent systems

  • โ†’ LLM integration
  • โ†’ Prompt engineering
  • โ†’ AI-powered features
  • โ†’ Machine learning basics

Featured Projects

From idea to working code - these projects best showcase how I solve real problems

ETL Data Pipeline
Production-Ready @ Sucroal

SAP ETL Automation Pipeline

Problem

Manual SAP data extraction took hours and was error-prone. Critical data arrived late for business decisions.

Solution

Built automated pipeline to extract, transform, and load SAP data to SQL Server. Designed to process 30,000+ daily records with zero manual intervention. Delivered production-ready code with comprehensive documentation.

Impact

Designed to eliminate 4+ hours of daily manual work. System processes data in 12 minutes vs. 4 hours manually. Real-time data availability for business intelligence.

Tech Stack

Python SAP GUI SQL Server Windows COM Pandas
Proprietary Code - Details Available in Interviews
In Development

Bakery Management System

Problem

Family bakery managing inventory, recipes, costs, and orders across disconnected Excel spreadsheets.

Solution

Integrated system that automatically calculates costs from recipes, manages inventory with alerts, and generates real-time financial reports. Everything in one place.

Impact

70% reduction in administrative time. Accurate profitability calculation per product.

Tech Stack

React Next.js Tailwind localStorage
Private Repository
Bakery Management Platform

More projects coming soon as I continue building and shipping.

Experience

My journey in software development

Software Developer

Work
Sucroal May 2025 - November 2025 ยท 7 months Palmira, Valle del Cauca - Colombia

Developed automated ETL processes from SAP to SQL Server. Database query optimization and data pipeline development.

Key Achievements:

  • Built ETL system designed to reduce 10+ hours to 1 hour of extraction time monthly
  • Implemented automatic data validation
  • Delivered production-ready code with comprehensive documentation
Python SQL Server SAP pandas

Full Stack Developer

Freelance
Freelance / Personal Projects 2022 - Present Remote

Web and mobile application development. Business process automation.

Key Achievements:

  • Fast Training - Mobile app for sports training management (Flutter, Firebase)
  • Bakery management system for family business (React, Node.js, SQL)
  • Python automation scripts for data processing
React Node.js Flutter Firebase PostgreSQL

Software Development Technology Program

Education
SENA 2023 - 2025 Popayรกn, Cauca - Colombia

Analysis and Software Development. Comprehensive technical training in full-stack development.

Key Achievements:

  • Web development certification
  • Practical projects in React and Python
  • Competed in programming challenges and technical competitions
React Python SQL MongoDB Next.js Javascript Flutter

Web Development Certification

Education
Universidad de Caldas 2022 ยท 800 hours Remote

Intensive program focused on web application development as part of Colombia's MinTIC digital transformation initiative.

Key Achievements:

  • Web development fundamentals and architecture
  • Full-stack development practices
  • Modern web technologies
HTML CSS JavaScript PHP MySQL

Skills & Tools

Technologies I use daily and feel comfortable with

Frontend

React + Next.js
โ—โ—โ—โ—โ—
Astro
โ—โ—โ—โ—โ—‹
Tailwind CSS
โ—โ—โ—โ—โ—
TypeScript
โ—โ—โ—โ—โ—‹
Flutter
โ—โ—โ—โ—‹โ—‹

Backend

Python
โ—โ—โ—โ—โ—
Node.js
โ—โ—โ—โ—โ—‹
REST APIs
โ—โ—โ—โ—โ—

Databases

SQL Server
โ—โ—โ—โ—โ—
PostgreSQL
โ—โ—โ—โ—โ—‹
MongoDB
โ—โ—โ—โ—‹โ—‹
Git โ—โ—โ—โ—โ—
Linux โ—โ—โ—โ—โ—‹
Docker โ—โ—โ—โ—‹โ—‹
Pandas โ—โ—โ—โ—โ—‹

Data & Automation

ETL Processes
โ—โ—โ—โ—โ—
SAP Integration
โ—โ—โ—โ—โ—‹
Python Scripts
โ—โ—โ—โ—โ—
Data Analysis
โ—โ—โ—โ—โ—‹

๐ŸŒฑ Currently learning: Machine Learning - AI Integration

About Me

I came to programming unexpectedlyโ€”a couple of YouTube videos at the end of high school sparked the right kind of curiosity. From working in a family bakery to writing full-stack code.

I started fascinated by frontend: watching designs come to life, every detail in its place. But I quickly understood I needed to master backend to build things that actually work. Automation came with my first jobโ€”not my original plan, but it showed me the value of optimizing processes and giving people their time back.

Today I build everything from carefully crafted interfaces to systems that scale. What drives me is creating tools with real impact, not just writing code for the sake of it. Full-stack to me means understanding how to connect all the pieces to solve complete problems.

Outside of code: chess, drawing, documentaries, music. Programming is just another way to create.

"Programming is just another way to create. The difference is your creations can improve how thousands of people work."

Let's Talk

Have a project in mind? Looking for a developer? Just want to chat about code?