Information
YouTeam is now part of Toptal. You now have access to a complete range of world-class talent and services.
Close
YouTeam Logo

Summary

Expertise

Project Highlights

Agency

JL

English:

Upper Intermediate

Jhon L.

vetted by Youteam

Vetted by YouTeam

Colombia

UTC -05:00

America/Bogota

English:

Upper Intermediate

5 years in the role, he has experience with Azure Data factory and Databricks, Ssis and Ssrs. He has a certification with Aws.

Data Scientist/Engineer with more than 5 year of experience having hands-on solving problems with data help and giving them value. He has the experience preparing data in various Azure services/tool like Azure Data Factory, Azure Data Lake Storage, Azure SQL, Azure Data Bricks, Azure Synapse Analytics, Mapping Data Flows, etc. Experienced in SQL development, Notebook’s development, ETL/ELT process designing, Database Designing and Modeling, Dimension Modelling, Data-warehousing.). He has knowledge building and implementing machine/deep learning models and visual solutions using data that generate benefits for companies in multiple sectors (Banking and Finance, Healthcare, Retail, Tourism).

Want to hire this engineer?

Check if Jhon is available

Expertise

Years of commercial development experience

5 years of experience

Core technologies

Python 5 years
SQL 5 years
pandas 5 years
Azure 3 years
AWS 1 year
PostgreSQL 3 years

Other technologies

ETL
SSIS
Tableau
SSRS
Power BI

Project Highlights

icon
Data engineer

Option

Sep `22 - Present

2 years

Option

Remote project creating automate report

Responsibilities & achievements

Build Pipelines in Azure Data Factory to ingest on premise DBs, use Databricks to transform data and put it in delta tables and let use it for visualization team. Create Automate Report in PDF that alert about the tables status.

Azure
Python
SQL
pandas
icon
Sr Data Scientist

Nubiral Project

Apr `22 - Present

3 years

Nubiral

remote Data projects for different clients.

Responsibilities & achievements

Working in different data projects on multi cloud like AWS, GCP and Azure Developing OCR tools to extract text from pdf files using computer vision Implementing MBA solutions to improve the sales in retail sector Implementing Deep Learning like a forecast tool to develop forecast product.

AWS
Azure
Python
SQL
Google Cloud Platform
pandas
icon
Sr Data Scientist

Kastech project

Jul `21 - Apr `22

9 months

Kastech SSG

Retail projects – Markets in USA

Responsibilities & achievements

Implement machine learning models in retail sector that allow correct decisionmaking (marketing strategies, product promotion, among others) (Market Basket Analysis). Implement visual analytics (Power BI) solutions that allow identifying improvement opportunities obtained through machine learning models (bestselling, least-selling products) for an important chain of mini-markets in the USA. Develop ETL/ELT for the creation of a data lake for a publishing company that receives different sources of financial information from different sources, transforms them to unify them and then for them to be exploited by Power BI development teams. Develop solutions to migrate data from on premise data warehouse to Azure Synapse analytics using data pipelines and python scripts. Setup framework to migrate data between DEV/TEST/PROD environments.

Azure
ETL
Python
SQL
Machine learning Engineer
pandas
Power BI
icon
Data Scientist

Bank Project

Jan `20 - Nov `20

10 months

Banco de Occidente

Identify potential bank clients to offer foreign trade products

Responsibilities & achievements

built a model that allows us to know the impact that the crisis generated by COVID 19 has had on the bank's business clients. Identify the characteristics of prospect bank customers that are profitable. Built a model that allows the companies to predict if a client will be on overdue or not, and the different overdue stages (1,2,3 months).

Python
SQL
pandas
icon
Data Scientist

Cotelco Project

Feb `17 - Oct `20

4 years

Cotelco Valle del Cauca

Collect Data. Project to tourism sectors

Responsibilities & achievements

Designed and planned the sampling strategic to collect data in tourism sector, into collect that he had the responsibility to coordinate the collector data team and the data analytics team. He designed and deployed business intelligence solution using Tableau and develop machine learning models techniques using web scraping data collected via Twitter. – He planned all the collection and analysis and information activities for the SITUR Valle del Cauca . - I designed the information collection methodology that allows characterizing tourism in the Valley (Receptive, Internal and Offer Tourism -Tourism and employment). - He coordinated the field work team, made up of 7 interviewers. - He designed the databases of the SITUR Valle del Cauca. - He designed the data collection methodology for the pilot characterization of sports tourism in the city of Cali. He designed the analytics or business intelligence module for the www.siturvalle.com platform. through Tableau. Implement models and other statistical analysis techniques such as social network analysis or sentiment analysis to know the opinion of tourists about the department of Valle del Cauca and their probability of return to it.

Python
SQL
Tableau
pandas

Agency

Web and Mobile Development agency #1967

50-100

GMT-3

Montevideo/Uruguay

Core Expertise

AngularJS
AWS
Azure
Cloud Engineer
Data Scientists
ETL
Java
JavaScript
Kotlin
Kubernetes
Linux
MongoDB
MySQL
.NET
Node.js
Oracle
PHP
Python
React.js
React Native
Salesforce
SAP
SharePoint
SQL Server
TypeScript
Visual Studio
Windows
Xamarin
Android
Jenkins
Scrum
Swift
Angular 2x
Android Testing API
Docker
Linux Systems Administration
MariaDB
JetBrains
Kanban
Redux
iOS SDK
Scrum Master
Visual Studio Code
Angular UI Bootstrap
Angular Material
Flutter
Angular CLI
Google Cloud Platform
.NET Core
Xamarin.Forms
Xamarin Native
Mongo Compass
Data Analyst
SAP HANA
SwiftUI
SAP BTP
SAP S4/HANA

Industries

Logistics & Transportation, E-Commerce & Retail, Banking & Finance, Construction & Real estate, Healthcare & Medicine, Automotive, Branding, design, web development, ERP

Want to hire this engineer?

Check if Jhon is available