Juan Diego Martínez Castro
Data Analyst/Scientist at Stayforlong- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
-
Portuguese Full professional proficiency
-
Spanish Native or bilingual proficiency
Topline Score
Bio
Mia Tošić
Juan Diego is a very committed co-worker. Always eager to help and share his knowledge which he possesses across many different industries. He is very proactive in his day-to-day which makes one feel always included and supported. I would be happy to work with him any day as I feel he would bring the best out of my skills.
Martin Blanchard Melelli
Juan DIego or Juandi after you meet him. Is an admirable person, always going the extra mile, persistence and most important he is a great professional, constantly learning and perfectioning his skills. He speaks his mind in a very respectful way, that's something very valuable nowadays. He knows what he need to do to suceed and he is going to do everything on his hands to make it happen. Give me Juandi everyday!
Mia Tošić
Juan Diego is a very committed co-worker. Always eager to help and share his knowledge which he possesses across many different industries. He is very proactive in his day-to-day which makes one feel always included and supported. I would be happy to work with him any day as I feel he would bring the best out of my skills.
Martin Blanchard Melelli
Juan DIego or Juandi after you meet him. Is an admirable person, always going the extra mile, persistence and most important he is a great professional, constantly learning and perfectioning his skills. He speaks his mind in a very respectful way, that's something very valuable nowadays. He knows what he need to do to suceed and he is going to do everything on his hands to make it happen. Give me Juandi everyday!
Mia Tošić
Juan Diego is a very committed co-worker. Always eager to help and share his knowledge which he possesses across many different industries. He is very proactive in his day-to-day which makes one feel always included and supported. I would be happy to work with him any day as I feel he would bring the best out of my skills.
Martin Blanchard Melelli
Juan DIego or Juandi after you meet him. Is an admirable person, always going the extra mile, persistence and most important he is a great professional, constantly learning and perfectioning his skills. He speaks his mind in a very respectful way, that's something very valuable nowadays. He knows what he need to do to suceed and he is going to do everything on his hands to make it happen. Give me Juandi everyday!
Mia Tošić
Juan Diego is a very committed co-worker. Always eager to help and share his knowledge which he possesses across many different industries. He is very proactive in his day-to-day which makes one feel always included and supported. I would be happy to work with him any day as I feel he would bring the best out of my skills.
Martin Blanchard Melelli
Juan DIego or Juandi after you meet him. Is an admirable person, always going the extra mile, persistence and most important he is a great professional, constantly learning and perfectioning his skills. He speaks his mind in a very respectful way, that's something very valuable nowadays. He knows what he need to do to suceed and he is going to do everything on his hands to make it happen. Give me Juandi everyday!
Credentials
-
CELPE-BRAS
Ministério da EducaçãoFeb, 2017- Nov, 2024 -
Certificate of proficiency in English
University of CambridgeFeb, 2010- Nov, 2024
Experience
-
Stayforlong
-
Spain
-
Software Development
-
1 - 100 Employee
-
Data Analyst/Scientist
-
Aug 2022 - Present
Defined +100 new data models utilizing SQL, dbt and Looker in order to answer questions, gain insights and simplify/speed up self-service analytics in the company, according to business questions, needs and results of data exploration. Performed various data transformations using SQL, dbt and Looker to more efficiently store and access the data. This maximized performance and speed of the Redshift Data Warehouse and Looker. Carried out numerous data analysis projects regarding the behavior of visitors on our web (ex: what % of times a visitor ends up buying a different hotel than the one initially seen? is conversion higher when the user clicks on the map?) that boosted sales & conversion based on the results up to 6%. (actionable results: we should show this hotel instead of this other one because of X). Interacted with multiple stakeholders in the definition of business requirements for new data models/new visualizations/dashboards and also presented the results of deep-dive analysis, along with recommendations. Involved in the measuring and monitoring of A/B test results of the product with the aim to optimize our webpage: session duration, conversion and sales. Orchestrated and scheduled new tasks on Airflow in order to automate the hourly/daily/weekly updating of various tables in our database, defined DAGS, Sensors and order of operations using Python, saving many hours of manual work and ensuring data consistency. Show less
-
-
-
International Paper
-
United States
-
Paper and Forest Product Manufacturing
-
700 & Above Employee
-
Data Analyst - Production
-
Dec 2020 - Oct 2021
Conducting data analysis with tools such as SQL, Excel, SAP, Python, decided on the production of 36.000 monthly tons of cardboard for customers all over EMEA and Africa. Reached 90% of monthly product availability. Optimized production to minimize the waste via the creation of a new process to guide decision-making and set priorities, attained through Python. Accomplished waste of less than 1% monthly. Defined and automated the CS request process to make it much more efficient and orderly, saving dozens of hours a month with the help of Excel. Show less
-
-
-
Dufry Group
-
Switzerland
-
Retail
-
700 & Above Employee
-
Data Analyst - Supply
-
Sep 2018 - Aug 2020
Utilizing SQL, Excel, SAP, Python, Tableau, analyzed data from different sources to make decisions on inventory , stock levels and availability of 1000s of products in 21 warehouses and 120 stores across the US & Canada, attaining Out-of-Stock levels of less than 5% and 86% availability in A & B products. Uncovered valuable insights through data analysis, simulations and visualizations that generated 1000s of dollars in savings and increased sales, and an improved analytics pipeline thanks to Python and Excel. Commanded the SAP F&R module (Forecast & Replenishment) implementation project for the area, driving forecast from 200% of monthly sales to 110%. Show less
-
-
-
Sodimac Uruguay.
-
Uruguay
-
Retail
-
1 - 100 Employee
-
Product & Category Manager
-
Jul 2017 - Aug 2018
Performed thorough data analysis on the products sales history using Excel and Data Visualization in order to make product decisions: which products, at what price, in which store, at what time, in which area of the store. Attained a 20% growth in sales vs last year for 1 of my categories. Crafted and effectivized promotions, special offers and price variations for numerous products, many of them resulting in a +50% hike in sales. Carried out web analytics and some A/B testing for products on the e-commerce page, specifically with prices and photos: achieved growth of 20% in sales for some products because of applied changes. Show less
-
-
-
Arnaldo Castro
-
Uruguay
-
Information Technology & Services
-
200 - 300 Employee
-
Data Analyst - Business Intelligence Analyst
-
Aug 2014 - Jun 2017
Successfully analyzed data of over 6 industries, 20 companies with Excel, SQL and Tableau. Wrote hundreds of queries in SQL to access data from different tables and databases, implemented Tableau via the building of 100s of relevant metrics, KPIs, visualizations & dozens of dashboards. Directed the in-house Business Intelligence project, aiming to make deeper, faster analyses and base the company's decision-making in available data. Built +100 visualizations, + 20 interactive dashboards that saved hundreds of hours of manual work a month and resulted in a 22% increase in productivity. Show less
-
-
-
R & S Investimentos Ltda
-
Financial Services
-
1 - 100 Employee
-
Financial Assistant
-
Jan 2013 - Mar 2013
3-month internship at the stock broker company RS Investimentos, in the city of Sao Paulo, Brasil. Assisted in the asssessment of purchases or sales of different stocks, carried out national and international macroeconomic analysis, sought out relevant information for financial, stocks & bonds decision-making and kept an eye on the Brazilian stock market. 3-month internship at the stock broker company RS Investimentos, in the city of Sao Paulo, Brasil. Assisted in the asssessment of purchases or sales of different stocks, carried out national and international macroeconomic analysis, sought out relevant information for financial, stocks & bonds decision-making and kept an eye on the Brazilian stock market.
-
-
Education
-
2021 - 2021
IE Business School
Data Science Bootcamp, Data Science -
2019 - 2020
Universidad ORT Uruguay
Postgrado en Dirección de Marketing, Marketing & Business -
2017 - 2017
Universidad ORT Uruguay
Programa Ejecutivo en Abastecimiento y Logística, Logistics, Materials, and Supply Chain Management -
2011 - 2015
Universidad de Montevideo
Economics
Community
