English:
Upper Intermediate
Colombia
UTC -05:00
America/Bogota
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 availableExpertise
Years of commercial development experience
5 years of experience
Core technologies
Other technologies
Project Highlights
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.
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.
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.
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).
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.
Agency
50-100
GMT-3
Montevideo/Uruguay
Core Expertise
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