menu-icon menu-icon Great Britain flag

Juan Ignacio Zapata


Fullstack Developer | Python Developer


I am a developer with a passion for programming, driven by curiosity and continuous learning. I enjoy creating elegant and efficient solutions to complex problems.


CV icon Github icon Linkedin icon

Python 3

Python 3

Javascript

Javascript

HTML

HTML

CSS

CSS

SQL

SQL

MySQL

MySQL

NodeJS

NodeJS

React

React



Experience


SDS - Smart Drawing Services

Auckland, NZ

Electrical Designer and Draftsman | Software development

January 2021 - Present


I joined a New Zealand engineering company where I worked as an electrical drawing designer, developing in-house design standards and programming work. I developed Python scripts to automate tasks. I worked on the development of a web application for GPS tracking with IOT devices, involving both backend and frontend design. Constantly improving and working to bring the best quality and reliability to customers.

Because of my interest in the subject, I was given small tasks to automate data entry processes. I used the Openpyxl and Python libraries to speed up the loading of data into the company’s standard spreadsheets.

2 years ago I was asked to develop a web application that could track various devices and sensors using IOT technology. I was in charge of the project:

  • check-icon Investigate and implement LoRAWAN connections from sensors to gateways. Finding the best options and considering which sensor is best suited to the task.

  • check-icon Establish the connection between the gateways and the server running the application.

  • check-icon I developed the RestAPI server using Python and FastAPI. I designed the various endpoints for the MySQL database, the IOT sensors and the front-end.

  • check-icon I had to manage the deployment of the application on the server hosted by Hostinger, using a VPS running Ubuntu Server.

Freelance work

Remote

Electrical Drafter

August 2019 - January 2021


I have worked for a number of New Zealand companies on high/medium/low power electrical design for water treatment plants. Working remotely in coordination with various teams and using Autocad electrical design software to meet IEC design standards.



Projects


We are working on this...



Studies


UTN Buenos Aires - Centro de e-Learning UTN BA

Remote

Diploma in Databases

Nov 2023 - Feb 2024

Relevant knowledge

Understanding relational databases

Internal Database Structure

SQL

MySQL

Oracle Database

UTN Buenos Aires - Centro de e-Learning UTN BA

Remote

Diploma in Python

Jul 2023 - Feb 2024

Relevant knowledge

Advanced Python skills

Classes

Object-oriented programming

GUI usage and design

Design patterns

UNLP - Facultad de Ciencias Astronomicas y Geofisicas La Plata

La Plata, BA

Bachelor of Science in Astronomy

2016 - In progress

Relevant knowledge

Advanced Physics

Advanced Mathematics

Mathematical Logic

Statistics

Algebra

Linear Algebra

Multivariable Calculus

EEST n.º 6 Siderurgia Argentina

San Nicolás de los Arroyos, BA

Electronic Technician

2009 - 2015

Relevant knowledge

Low/medium voltage installations

PLC

PIC

mikroC software

Circuit Board Design

Telecommunications



Certificates download



Certificado Codo a Codo 4.0 Desarrollo Web (JS/NodeJs)UTN e-Learning - Diplomatura Base de datosUTN e-Learning - Diplomatura PythonMongoDB - Introduction to MongoDBMongoDB - Using MongoDB with PythonMastermind - Aprende a programar con Python
download


About-me bandera-argentina mate


JZ - Portfolio

My name is Juan Ignacio, I am an electronic technician and I have 5 years of experience in software development and programming, and 2 years doing fullstack and data analysis work.

I graduated in 2015 from a technical college where I learned several skills in logic, mathematics and problem solving. I specialised in the design of electronic circuits and industrial control installations:

  • check-icon I acquired knowledge of medium and low voltage electrical installations.

  • check-icon I designed and implemented circuits with integrated circuits such as the LM741, LM555, logic gates and others.

  • check-icon I worked with PID closed-loop control circuits.

  • check-icon I programmed PIC microcontrollers in C language and used them in control and automation circuits.

  • check-icon I implemented solutions by designing and programming the Schneider PLC logic and connecting the equipment, motors and sensors.

When I finished high school, I turned my academic path towards the sciences and began studying for a degree in astronomy.

I spent several years there, where I was able to consolidate my knowledge of advanced mathematics, multivariable calculus, algebra and linear algebra, advanced physics, among others. It also boosted my critical thinking and further developed my problem-solving skills.

In 2019 I started working remotely for New Zealand in electrical design and engineering, designing wiring diagrams with AutoCAD Electrical. At the same time, and because the career I was in was oriented towards the use of software, I took up the study of software development on my own and accompanied it with courses. I became interested in the Python language in particular. And from there I started adding other languages (JavaScript, HTML, CSS, PHP, SQL) and frameworks (React, NodeJS, Express, Astro, Flask, FastAPI, Selenium, BeautifulSoup, MySQL, among others).

In 2021, thanks to my good performance, I joined a New Zealand design and engineering company.

Since then, I have been developing in the professional environment of the sector and, in addition, expanding my knowledge of programming and development.