Image
Julian Oliveros Forero

Web Developer, Data Science, Consultant

Hire Me Download CV
About

Greetings! I am Julián Oliveros Forero, a passionate individual from Colombia. I hold a degree in Computer and Systems Engineering from at Universidad de Los Andes. I am eager to utilize my skills and dedication to contribute towards the mission of a company. With a positive attitude, I possess a strong drive and enthusiasm for acquiring new skills and knowledge. I am constantly seeking opportunities to expand my expertise and apply newfound wisdom in practical ways. Embracing a lifelong learning mindset, I am committed to personal growth and staying abreast of emerging trends.

Basic Information
Age:
Email:

julianestevanof@hotmail.com

Phone:

Phone:(+57) 300 355 33 91

Address:

Bogota, Colombia

Language:

Spanish (Native)

English (IELTS Band Score 6)

French (Elementary proficiency)



Software

  • Databases

    • PostgreSQL
    • Oracle
    • MySQL
    • MongoDB
    • Neo4j
    • Firebase DB

  • Diagramming tools

    • Lucid Chart
    • Genmymodel
    • Diagrams.net
    • Draw.io

  • Visualization tools

    • Power BI
    • Tableau
    • Matplotlib
    • Dash
    • Grafana
    • Metabase

  • SaaS

    • AWS
    • Microsoft Azure
    • Google cloud
    • Microsoft Excel
    • Microsoft Power Point

  • Project Collaboration Software

    • Github
    • GitLab
    • Trello
    • MeisterTask
    • Microsoft To Do

  • Data Science

    • Orange
    • Knime
    • Numpy, Pandas and Scikit Learn
    • Streamlit
    • Apache Airflow
    • Apache Sapark

  • Software

    • FastAPI
    • Nest js
    • Nest js
    • Spring-boot
    • React JS
    • React native
    • Backend Design Patterns
    • Restfull APIS
Soft-Skills

Organized, Time management, Compromised, and Teamwork.

Portfolio

Application / FastAPI / PostgresSQL / Tensorflow / Keras / Apache Airflow / LSTM models / Streamlit / Restfull API

Qries

  Artificial Intelligence Techniques Applied to Cryptocurrency Market Prediction Thesis

Created a web Aplication that uses LSTM models to predict the prices of crypto currencies. Also Implmented and ETL using Airflow to extract the information of the cryptocurrecny prices and other complementary Assets.

Apache Spark / Mongo / Docker / NLP / PySpark / Cluster Kubernetes/

Qries

  Big Data Projects Masters Class Unaindes

I successfully completed projects as part of the Big Data class, focusing on utilizing cutting-edge technologies such as Spark to process massive datasets. Specifically, I gained hands-on experience in handling and analyzing data from sources containing a staggering 300 GB of information.

Natural Language Processing / Python / nltk / Streamlit / pandas / plotly

Qries

 NLP: WhatsApp sentiment Analysis

Develop a Natural language processing project that analyzes the sentiment of the messages in a WhatsApp conversation

Data Visualization / Dash / Python / Plotly / HTML /

Qries

  Analysis US Elections 1976-2020

Built a website that displays an interactive dashborad that show relevant information about the US Elections for the presidency and the senate during the period 1976-2020

Data Science / Python / Airflow / Streamlit / Grafana / FastAPI / PostgreSQL

Qries

 Mobile Price Prediction App

Develop a complete data science in production pipeline that predicts the price range of a cellphone. Used Streamlit to create a visual interactive interface, Airflow was used to make automated predictions to the model. Used fast Api to build endpoints, all the predictions where stored in postgres data base and used grafana to show stadistics abput the model.

Machine Learning / Python / Pandas / Numpy / Scikit Learn / Joblib

Qries

  House prediction model

Created a machine learning model composed of the modules of preproess, train and inference to make predictions of the price of a house.

Mobile App / Kotlin / Firebase / PostgreSQL

Qries

  Android App: Movie roulette

Design a mobile application which gives recomendations of movies to watch for an user in the format of tinder.

Work Experience

Sep 2024 - Present

Plenti
Back End Engineer
  • Launched the Plenti Card, achieving seamless integration with partner Pomelo in just 3 days, setting a record- breaking timeline for the fintech industry
  • Designed and implemented comprehensive testing strategies to ensure the robustness and reliability of the Plenti Card system.
  • Developed microservices to improve the scalability, modularity, and maintainability of back-end systems.
  • Refactored the system architecture to adopt a hexagonal architecture approach, improving flexibility, maintainability, and adherence to domain-driven design principles.

    • Jun 2024 - Sep 2024

    Treinta
    Semi-Senior Data Engineer
  • Led the migration of the data infrastructure from Google BigQuery to Amazon Redshift, reducing billing by 50%

    • Jul 2023 - Jun 2024

    Treinta
    Data Engineer
  • Deployed and optimized scalable ETL pipelines for efficient data processing.
  • Created robust data marts to enhance reporting efficiency and accuracy

    • Jan 2023 - Jul 2023

    Treinta
    Business Intelligence Analyst
  • Restructured the data pipeline to improve the synchronization time between Google BigQuery and Braze by 60%, optimizing the delivery of push and phone notifications to users.
  • Revamped the data pipeline to enhance synchronization time by an impressive 40% between Google BigQuery and Braze, optimizing the delivery of push and phone notifications to users.
  • Deployed an ETL to retrieve Google reviews from Buckets and an API to display potential users in the app and send alerts on Slack when bad reviews are made to improve the Google Play score.
  • Integrated ChatGPT API to create custom marketing communications to sell products to B2B clients.
  • Implemented clustering algorithms to establish control and test groups for seamless feature deployment.
  • Utilized extensive SQL to extract actionable insights, generate comprehensive reports, and perform various data-related tasks.

    • Aug 2022 - Jan 2023

    Treinta
    Business Intelligence Intern
  • Designed and created user-friendly Power BI and Metabase dashboards to meet specific organizational needs and requirements.
  • Utilized SQL and Python to develop DAGs (Directed Acyclic Graphs) using Airflow for efficient ETL (Extract, Transform, Load) processes into the Data Lake.
  • Created a Semantic layer for one of the monetized products of the company.
  • Executed Slack alerts pipeline that shows information from the company Data Lake to improve company operations.
  • Created retool tools to be able to connect and query companies' databases and APIs to update information.
  • Developed datamarts to facilitate efficient data storage, organization, and retrieval for improved analytical capabilities and reporting functionalities.

    • Aug 2022 - Jun 2023

    Universidad de Los Andes

    Software Research Assistant for Professors' Portfolio Project

    The Professors' Portfolio is a project that aims to centralize all information related to a professor in one place. This will allow professors to search for information from different sources on the same site. The information to be consulted includes basic information, information related to courses, academic production, and institutional development.

  • Designed Entity-Relationship Diagrams (ERDs) for the professors' portfolio architecture.
  • Developed and supported the back end of the professors' portfolio project at the University of Los Andes. Initially, Typescript and Nest js framework were used. However, due to university constraints and integrations, the code was later moved to Java and Spring-Boot framework.
  • Conducted thorough software unit testing to ensure functionality and reliability.
  • Implemented the MVC software design pattern.
  • Integrated the software architecture, enabling seamless utilization of Uniandes Academia Oracle databases.
  • Created views and databases in Oracle databases to match with the backend models.

    • Jan 2021 - Feb 2023

    Microsoft Learn Student Ambassador
    Student Ambassador Beta
  • Coordinated a virtual Cloud Boot-camp about Azure which least for 2 days, had more than 20 sessions and workshops, and attended around 200 people.
  • Organized a virtual event to teach 20 kids about programming using scratch.
  • Generated a python script that creates certificates of attendance at events and sends them by mail to their respective participant to 150 assistance’s.

    • April 2021 - Aug 2022

    Finance & Investment Club Uniandes
    Member of Capital Markets
  • Planned a trading tournament for the members of the club which last 3 months.
  • Built a algorithmic trading bot using the language MQL5 that predicts opportunities on the stock market.

    • Jun 2021

    Summer Innovation Bootcamp
    Consultant
  • Attended to Summer camp in which, for 4 weeks, I was able to reinforce my knowledge by building solutions that generate value for Colombian companies that have been affected by the COVID-19 pandemic.
  • Design a plan to implement the B2C distribution channel in the company.

    • Jun 2021 - Aug 2021

    Universidad de Los Andes
    Class Monitor and Teacher Assistant
  • Class: ISIS 1404 TI in the organizations
  • Assessed students doubts related to the class concepts.
  • Evaluated and qualifying workshops, home works and presentations.

    • Apr 2013 - Feb 2014

    Universidad de Los Andes
    Class Monitor and Teacher Assistant
  • Class: ISIS 2403 Business Architecture.
  • Assessed students doubts related to the class concepts.
  • Evaluated and qualifying workshops, home works and presentations.
    • Education

    Jan 2024 - Dec 2025

    Master’s Degree

    Master’s in Software Engineering

    Universidad de Los Andes

  • GPA: 4.65/5

    • Jan 2022 - Aug 2022

    Academic exchange on a Master's Degree

    Image
    Academic exchange on the core and specialization semester of the master’s degree in Data Science & Analytics.

    EPITA: E ́cole pour l'informatique et les techniques avancées

  • GPA: 17/20
  • Relevant Coursework: Foundations of statistical analysis machine learning, Data exploration preparation, Data science in production, Data visualization, Predictive analytics data mining, Cloud infrastructure for big data, Deep learning for natural language processing, and French classes.

    • June 2018 - August 2023

    Bachelor's Degree

    Bachelor’s degree, Systems and Computing Engineering

    Universidad de Los Andes

  • GPA: 4/5
  • Academic option in entrepreneurship
  • Relevant Coursework: Technology infrastructure fundamentals, Algorithm design and analysis, Transactional systems, Software architecture and design, Enterprise architecture, Business intelligence, Communications infras- tructure, and Construction of mobile applications.
    • Achievements
    Contact Me
    Feel free to contact me

    Address

    Bogota, Colombia

    Phone

    Phone:(+57) 300 355 33 91

    Email

    julianestevanof@hotmail.com