Juan Antonio Fernández Cruz

Juan Fernández Cruz Data Engineering student C. 45 # 451 Residencial del Norte. 97219 Merida, Yucatán. México. ([email protected] www.linkedin.com/in/juan-antonio-fernandez-cruz SKILLS ● ● ● ● Proficiency with Python for Data engineering. Certification of English language proficiency at C1 level (Itep). Experience of data manipulation, cleansing and visualization using Python (pandas, matplotlib, seaborn). Relational database management experience with mysql, and data science/analysis tools such as Dataiku. EXPERIENCE SmartIA, Mérida, Yucatán. México- Internship JANUARY 2023 - APRIL 2023 Pothole image recognition and geolocation system. The goal was to detect potholes in real time using cameras placed in vehicles that would map the city and provide information about the areas that needed maintenance. My role was to select the software and algorithm for object recognition training using tools such as opencv and train it specifically to detect potholes in roads, as well as cleaning and visualizing the data processed by the software to generate models and density maps in the city. Asesoría Comercial Hermin, Mérida, Yucatán. México- Internship JANUARY 2024 - APRIL 2024 OLTP and OLAP database implementation and ETL process development. Database centralization for an application automation project. During my participation in this project, I was in charge of designing and implementing the OLTP and OLAP databases for the migration of information from datasheets to a centralized database using MySQL. My role included the extraction and cleansing of data from Google Sheets, the creation of pipelines for recurring data cleansing, as well as the loading and storage of the cleansed information into the centralized MySQL database. In addition, I worked on the development of ETL processes for data delivery to other projects. EDUCATION Universidad Politécnica de Yucatán, Mérida, Yucatán. Mexico- Data Engineering AUGUST 2021 - PRESENT Optimization, data filtering, organization and the development of products capable of deriving valuable information from data sets that can later be utilized in decision-making, at a scientific and technological level, in the areas of Digital Economy, Advanced Population Analysis, Data Science and the Internet of Things. ACHIEVEMENTS ● 2nd place in the 2022 Yucatan I6 GCP bootcamp in Mérida, Yucatan, for the best project proposal to improve Merida's traffic flow with GCP tools, integrating cameras to the traffic lights to analyze the density and possible route of vehicles to optimize the flow during peak hours.