# Johan Gómez

Johan Gómez is a remote worker on Himalayas, Software Semi Senior - Python - IA at Hitss Colombia, based in Colombia.

Source: https://himalayas.app/@johangmez

```text
Backend and data engineer at Hitss Colombia, who cut mobile data processing time and cost by 70%.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Colombia |
| Authorized to work in | Colombia |
| Salary expectations | 30k+ USD |
| Job categories | Backend Engineer, Data Engineer, Database Administrator, Machine Learning Engineer |
| Skills | Backend Development, Data Engineering, ETL, Machine Learning, AI, Python, SQL, Pl SQL, Databricks, Airflow, PySpark, AWS, Google Cloud Platform, BigQuery, PostgreSQL |
| Portfolio | https://drive.google.com/file/d/16nqjWrPCuJDROUxw0K75faptp9H0cXkP/view |

## About

```text
At Hitss Colombia, I optimized Python and Airflow processing for mobile server and antenna queries, reducing processing time and cost by 70%. I also integrated AWS functions with Salesforce and other sources to synchronize point-of-sale information for Italcol.

I used GCP and Databricks ETL pipelines to transform and distribute data, and applied evolutionary models to construction projects. The models improved roof and slab distribution efficiency by 90% and reduced material waste by 100%.

Earlier, at Periferia IT Group, I optimized stored procedures and ETL processes, and restored production databases using RMAN, reducing recovery time by 60%. At Skit Consulting S.A.S, I led the DS4A project, applying machine learning to predict project durability in the financial sector with 87.5% prediction accuracy.
```

## Experience

### Software Semi Senior - Python - IA (current)

Hitss Colombia. Sep 2023 - Present

```text
Reduced processing time and cost by 70% in queries to servers and mobile antennas using Python with the MAT framework (Airflow). Integrated AWS functions with Salesforce and other sources for real-time data synchronization, and optimized distribution of roofs and plates using evolutionary models, achieving a 90% improvement in distribution efficiency and 100% reduction in material waste.
```

Skills: Python, Java, .NET, PySpark, Databricks, BigQuery, PostgreSQL, AWS, Postman, MAT, Airflow, GCP, C#

### PL SQL Developer and Database Administrador (DBA)

Periferia IT Group. May 2022 - Aug 2023

```text
Structured and managed the bank's asset database, optimizing organization and access. Developed optimized stored procedures, designed and optimized ETL processes, restored production databases using RMAN, reducing recovery times by 60% and ensuring service availability above 90%.
```

Skills: Pl-SQL, SQL-Server, ETL, Oracle-RMAN

### Cobol and SQL Developer

SERDAN S.A. Jul 2021 - Feb 2022

```text
Designed and structured the bank's asset database, optimizing organization and access. Developed and maintained COBOL programs, ensuring stability and efficiency in critical legacy systems, and executed unit tests to reduce errors before production implementation.
```

Skills: COBOL, SQL-Server, JavaScript

### PLSQL Developer, Analítica e AI

Skit Consulting S.A.S. Nov 2019 - Jul 2021

```text
Designed and structured databases, developed and optimized stored procedures, executed and documented unit tests, managed key reports, and led the DS4A project applying machine learning techniques to predict project durability in the financial sector, achieving 87.5% prediction accuracy.
```

Skills: Python, Java, Pl-SQL, MongoDB, WEKA

## Education

### Universidad de los Andes

Curso, SCRUM

```text
Completed a course on Scrum.
```

### Universidad Sergio Arboleda

Curso, Inteligencia artificial aplicada a los negocios

```text
Completed a course on applied artificial intelligence for business.
```

### Google

Professional Data Engineer, Data Engineering

```text
Earned the Professional Data Engineer certification, including badges in serverless data processing, smart analytics, and modernizing data lakes and warehouses.
```

### Universidad de los Andes

Curso, Backend con Python

```text
Completed a course on backend development with Python.
```

### Monelit

Curso, Ciencia de datos

```text
Completed a course on data science.
```

### Oracle

Oracle Cloud Infrastructure 2024 Generative AI Professional, Generative AI

```text
Earned the Oracle Cloud Infrastructure 2024 Generative AI Professional certification.
```

### Udemy

Curso, DevOps, Docker, Kubernetes, Kanban

```text
Completed courses on DevOps, Docker, Azure, Kubernetes, Docker on AWS, and Kanban.
```

### Cadiff BNP Paribas

Curso, Python

```text
Completed an intensive Python course covering basic and intermediate levels.
```

### Universidad El Bosque

Profesional en Ingeniería de Sistemas, Ingeniería de Sistemas

```text
Completed a degree in Systems Engineering, gaining a strong foundation in software development and data management.
```

### DataCamp

Curso, Data Science

```text
Completed a data science learning track using Python.
```

### Oracle

Curso, Bases de datos Oracle

```text
Completed a web course on designing and building databases in Oracle.
```

### Iquall Networks

Iquall Netops Automation Professional, NetOps Automation

```text
Earned the Iquall Netops Automation Professional (INAP) certification.
```

## Tech stack

- Postman
- Google Cloud Platform
- Kubernetes
- NumPy
- Pandas
- PySpark
- MySQL
- PostgreSQL
- MongoDB
- .NET
- Databricks
- Azure DevOps
- Jira
- JavaScript
- Python
- Java
- C#
- Visual Studio Code
- Git
- Docker
- Airflow
- SQL
- XGBoost
- Matplotlib
- AWS
- REST APIs

To contact Johan, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Nicolás Poch Llorente](https://himalayas.app/@nicolspochllorente): Senior software engineer , Telesign
- [Francisco Karriere](https://himalayas.app/@karrierefran): Data Consultant, Freelance
- [Carlos Ramirez](https://himalayas.app/@carlosramirez3): Logistic Coordinator, Lean Solutions Group
- [Camila García](https://himalayas.app/@camilagarca): Data Consultant, Comgraficas SAS
- [Juan Sebastián Parrado Gutiérrez](https://himalayas.app/@juansebastinparradog): Staff Programmer / Data Engineer, Inetum
- [Juan Osorio](https://himalayas.app/@juanosorio1): Data Engineer, Krones AG
- [Juan Manuel Diaz Torres](https://himalayas.app/@juanmanueldiaztorres): Apoyo en Tecnología, Procuraduría General de la Nación
- [Carlos Mario Hoyos Rios](https://himalayas.app/@carlosmariohoyosrios): BI Developer (Data Engineering), Banco de Occidente
- [Nicolas Imbachi](https://himalayas.app/@nicolasimbachi): Software Developer, Data & Analytics Platform, Mercado Libre
- [Jose Manuel Medina Cano](https://himalayas.app/@josemanuelmedinacano): Data Engineer, Amwell.com
