Jhon H. Loaiza

Data Specialist

Altimetrik•  October 2022 - Present

Responsibilities: Ø GoDaddy – Data Engineer ● Migration Airflow Dags and repositories from Github Legacy to Github Enterprise (AWS cloud). ● Monitoring dags in production. Ø Altimetrik – Internal Project ● In charge of developing script process to extract text from Resumes such as PDF, word and RTF files ● Using OpenAI and Scipy frameworks to extract and preprocessing text using Python

Data Analyst Specialist

Scotiabank•  January 2022 - October 2022

Responsibilities: ● Transform business requirements from stakeholders to a technical development, using BSTMs and SQL queries. ● Development of the Data Lineage project for IFRS9 area and mapping specifications of tables and databases used in ECL (Expected Credit Loss) calculation in Collibra. ● In charge of reviewing and improving Hiveql queries to the table system on the area.

Data Scientist

IDICO•  January 2021 - January 2022

Responsibilities: ● Lead of data as a service project for customers of the company. ● Development of strategic dashboards for Sales, Marketing, Logistic and Financial areas using Tableau and Tableau Prep. ● Development of ELT using pyspark and SQL server to integrating and visualizing strategic data by areas in Tableau. ● Development of forecast model for sales area, using LSTM deep Learning models with Tensorflow and deployment of this models using TabPy in Tableau.

Analytical Consultant

Analytics Data•  July 2020 - January 2021

Responsibilities: ● Development of clustering models in Qlik Sense (BI Tool) for a customer of the company.

Head of Audience Intelligence

El Pais SA•  April 2018 - July 2020

Responsibilities: ● Technical leader of the digital subscriptions project to the website elpais.com.co. ● Development of dashboards for Marketing and Sales area, for tracking of audience and subscriptions using PowerBI ● Database integration using SQL server and Postgres DB for PowerBI visualizations. ● Development and calibration of newspaper subscribers using Python and Scikit-learn. ● Development of RFM model for Club Selecta Users (subscriber benefits) using Scikit-learn.

Market Intelligence Analyst

Bancoomeva•  June 2012 - April 2018

● Development of machine learning model for bank’s customers clustering (VIP segment). ● Development of credit and customer behavior tracking dashboards for the marketing area using Qlikview. ● Development of machine learning model to detect best associates to Coomeva organization, using scoring models. ● Development of machine learning model for scoring and churn in bank’s customers ● Extract and create automated reports using IBM Modeler and SQL queries