David Serna Gutiérrez

David Serna Gutiérrez  new_releases

About

Detail

Engineer | Data Scientist | GIS Specialist | Python | SQL | NoSQL | PowerBI | Machine & Deep Learning | Data Base Administration
Colombia
Contact David regarding: 
Flexible work
Starting at USD100/hour
id_card
Internships
Starting at USD2.5k/month
groups
Networking

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • Procalidad SAS
    Consultant public Remote experience
    Procalidad SAS
    Sep 2021 - May 2023 (1 year 9 months)
    - Work on typical data scientist workflows using Python and Power BI: data ingestion, exploration, mining, cleaning, visualization, dashboard creation, and machine learning modeling.
    - Experience in searching and consuming APIs to enrich data.
    - Developing search models using regular expressions.
    - Support in creating a BI search service using various Azure services such as virtual machines, AZ Functions, Data Lakes, and AZ Search Service, among others.
    - Develop interactive dashboards in Power BI.
    - 80-hour Seedbed Tutor on Analytics, Business Intelligence, Relational Databases, Python, Databricks, and Power BI.
  • Automatic Mind
    Immersion Trainee
    Automatic Mind
    Jul 2021 - Sep 2021 (3 months)
    - I solved 31 challenges and was ready for the interviews. However I was looking for more jobs and Procalidad found me and there I am.
    - I solved problems about geometry, mathematics, statistics, cyber security and string tricks.
    - The challenges were solved using Groovy, Hy, Mercury and Reason ML.
    - I was a trainee which his mission consist of solving programming challenges of the codeabbey web page (https://www.codeabbey.com/).
    - The tricky part was that I couldn't use ordinary programming languages (like Python, Java, C, etc.) nor for loops (just recursion or Tail Call Optimization).
    - After the problem was solved
  • Forestry Consulting Group
    Forest Engineering
    Forestry Consulting Group
    Aug 2020 - Sep 2020 (2 months)
    - Plot establishment to measure biomass in forest plantations.
    - Field work at the campaments.
    - Gathering and processing geographics information.
  • Universidad Nacional de Colombia
    Contractor
    Universidad Nacional de Colombia
    Sep 2019 - Nov 2019 (3 months)
    - Generation of basic cartography with ArcGIS and QGIS and technical reports.
    - Biophysical characterization of three properties for purchase by EPM, in the framework of the forced investment of 1% of the cost of the Porce III Hydroelectric Project in the Municipality of Amalfi, Antioquia.
  • Contractor
    Assistant Researcher in doctoral thesis
    Contractor
    Aug 2019 - Current (7 years 3 months)
    - Collection and preparation of the wood core samples.
    - Scanning and digitization of the wood cores.
    - Chronological time series exploration using dplR and tidyverse packages in R also with ImageJ (open source software based on Java).
    - Assistant research in the project: "Long-term effects of climate change on tree growth and water use efficiency along an elevational gradient in northern Andes of Colombia"
    - Dendrochronological measurements using an open source software (ImageJ) in digitized images for three species in three forest plots in northeastern Antioquia - Colombia.
    - Graphical and statistical exploration using tidyverse in R and dplR to make dendrochronological measurements and statistics.
  • Jardín Botánico Medellin
    Apprentice
    Jardín Botánico Medellin
    Jan 2019 - Jul 2019 (7 months)
    - A phenological calendar was developed for each specie using tidyverse library, specially the ggplot2 package and dplyr in R.
    - Every tree which were selected for the monitoring was geo positioned and target with a dendrometric band.
    - A map was delivered using GIS open software QGIS and SAS Planet.
    - The dendrometric results were analyzed R and helped to improve the management of tree pruning.
    - Monitoring tree iconic species of the facilities installing dendrometric bands and establishing a monthly audit.
    - Germination test on endangerous palm specie.
    - Literature searching to compare the theory behavior of trees versus real.
    - Support at field work in the natural reserve of the botanical garden.
  • Universidad Nacional de Colombia
    Auxiliar student
    Universidad Nacional de Colombia
    Sep 2017 - Oct 2017 (2 months)
    - Production of thematic cartography through QGIS and subsequent socialization with the community, for their empowerment and governance of the territory.
    - Biophysical characterization of the productive estates of the community Km. 6 in the municipality of Leticia using GIS tools.
    - Cartographic surveys and delimitation of boundaries with the help of satellite images and field work.
Education verified_user 7% verified
  • Coursera
    Data Engineering Professional Certificate public Remote experience
    Coursera
    Aug 2022 - Sep 2022 (2 months)
  • Coursera
    NoSQL, Big Data, and Spark Foundations
    Coursera
    Aug 2022 - Sep 2022 (2 months)
  • Coursera
    IBM Data Warehouse Engineer
    Coursera
    Aug 2022 - Sep 2022 (2 months)
  • DataCamp
    Data Analyst in Power BI
    DataCamp
    Jul 2022 - Aug 2022 (2 months)
  • Micrososft
    Microsoft Certified: Azure Data Scientist Associate
    Micrososft
    Apr 2022
  • Correlation One
    Data Science For All (Cohort 6)
    Correlation One
    Mar 2022 - Jul 2022 (5 months)
  • Micrososft
    Microsoft Certified: Azure AI Fundamentals
    Micrososft
    Feb 2022
  • Micrososft
    Microsoft Certified: Azure Fundamentals
    Micrososft
    Jan 2022
  • Universidad Sergio Arboleda
    Misión TIC 2022 | Web development
    Universidad Sergio Arboleda
    Sep 2021 - Dec 2021 (4 months)
  • DataCamp
    Data Scientist Professional public Remote experience
    DataCamp
    Jun 2021 - Nov 2021 (6 months)
  • DataCamp
    Python Programmer Career Track
    DataCamp
    Jun 2021 - Dec 2021 (7 months)
  • Universidad Nacional de Colombia
    GIS Specialist public Remote experience
    Universidad Nacional de Colombia
    Oct 2020 - Dec 2021 (1 year 3 months)
  • Acámica
    Data Science Career public Remote experience
    Acámica
    Jul 2020 - Apr 2021 (10 months)
    - First project was about Machine learning fundamentals.
    - Second project was about advanced machine learning models and tools.
    - Third project could be about NLP, Machine Learning or Time Series, I made a time series analysis.
    - In the final project I developed a time series analysis with dengue fever data from Medellín, made a Web Scrapping to obtain hidroclimatic data and adjust a neural network to predict the cases of dengue from precipitation and temperature.
  • HarvardX
    CS50's Introduction to Computer Science public Remote experience
    HarvardX
    May 2020 - Apr 2021 (1 year)
    - There were 10 weeks were I learn about C, Arrays, Algorithms, Memory, Data Structures, Python, HTML, CSS, JavaScript and Flask.
    - The Final Project was a web page developed in Flask were I create a shop market of sport pants, the description is in the repository.
  • DataCamp
    Data Scientist with R Track public Remote experience
    DataCamp
    Apr 2020 - Nov 2020 (8 months)
  • Universidad Nacional de Colombia
    Forest Engineer verified_user Verified experience
    Universidad Nacional de Colombia
    Jan 2012 - Aug 2019 (7 years 8 months)