João Vitor de Paiva Marcotti

Currently working full-time as a Data Analyst at FIESC's economic observatory in Brazil, and as a Data Science Freelancer at Whiskystats, based in the Netherlands.

I hold bachelor's degrees in Economics (UniCesumar – Brazil) and Electrical Engineering (Universidade Estadual de Maringá – Brazil), as well as a postgraduation degree in Big Data from Fundação Getúlio Vargas (Brazil).

Driven by continuous learning, I am currently enrolled in a postgraduation program in Computer Vision at Data Science Academy (Brazil).

View My GitHub Profile

Portfolio


Cask Worth - Whisky Casks Pricing Model

A machine learning (supervised learning) model trained on past auction data from multiple auction houses, capable of estimating the value a whisky cask.

Applied tools: Python, R, Scikit-learn and Streamlit.

Applied skills: data analysis, ETL, machine learning and web scraping.

Try it!


DramMatch - Your whisky recommender

A recommendation system that, based on the user’s tasting profile, recommends the most similar bottle based on its tasting notes.

Applied tools: Python, R and Streamlit.

Applied skills: data visualization, ETL, natural language processing, recommendation systems and web scraping.

Try it!


Fuel Prices in Brazil

Dashboard developed to analyze the average prices of six types of fuel across Brazil over time and at different territorial levels, including regions, states, and cities

Applied tools: Plotly, PySpark, Python and Streamlit.

Applied skills: big data, data analysis, data visualization and ETL.

Try it!


Maringá Housing Prices

Dashboard created to support decision-making for real estate purchases in the city of Maringá, Brazil. The project also includes ETL pipelines built from three real estate agency websites.

Applied tools: Power BI and Python.

Applied skills: data analysis, data visualization, ETL and web scraping.


Whisky Casks ETL

ETL process developed to extract, transform and load data from whisky auction houses intended to feed my personal data analysis and machine learning projects related to whisky casks.

Applied tools: Python and R.

Applied skills: ETL and web scraping.

GitHub repository


Financial Utilities API

Composed by 4 routes:

Applied tools: FastAPI and Python.

Applied skills: economics, finance, python development.

Try it!


Academic Publications


Development of a Thermocirculator Applied to the Sous Vide Culinary Technique

Published paper: Development of a Thermocirculator Applied to the Sous Vide Culinary Technique.

Developed in 2019-2023 in collaboration with Erinaldo Nascimento, MSc and Camila Miranda, PhD as part of my electrical engineering BSc final paper and undergraduate research.

Published on: 18/12/2025.

This paper addresses the theory, design, and execution of a thermocirculator, developing its electronic circuits, printed circuit boards (PCBs), plastic structure, and equipment assembling. The developed thermocirculator is based on 3 previous prototypes, with the first one being created in 2019. The ESP32 microcontroller was used as the basis for the electronic circuits. MicroPython was chosen as the programming language, and a web server was developed to connect the user and the equipment via Wi-Fi, allowing monitoring of the equipment from anywhere. An On-Off controller was implemented to keep the water temperature constant. The plastic structure was made of ABS plastic, and manufactured by 3D printing, with lateral dimensions of 7 x 7 cm and 18.5 cm of height, divided into upper portion, medial cover, lower portion, and lower covers. After the equipment was assembled, tests were made to verify its operation, which consisted of preparing foods such as a NY strip steak at 55 ºC, pork ribs at 70 ºC, and eggs at different temperatures. The developed thermocirculator performs its function excellently and can prepare food like a commercial product, fulfilling the objectives established by this paper.


Planning of a Thermocirculators Manufacturer Fictitious Company

Published paper: Planning of a Thermocirculators Manufacturer Fictitious Company.

Developed in 2022-2023 in collaboration with Erinaldo Nascimento, MSc and Camila Miranda, PhD as part of my electrical engineering BSc final paper and undergraduate research.

Published on: 05/03/2025.

This paper proposes the planning of a fictitious company that manufactures thermocirculators, including a business model and a business plan, brand, and conclusions about its viability. Studies indicate that only 37.6% of companies founded in 2014 surviveduntil 2019, and lack of planning is one of the main reasons that lead to the early closure of companies, making it important to make an adequate business planning. Using the Canvas methodology and the manual proposed by Sebrae, the business model and business plan were prepared, respectively. Based on market research, an initial investment of R$23,061.00 and an initial production of 50 thermocirculators with a selling price of R$700.00 per unit were estimated. The SWOT analysis pointed out two threats: competition from consolidated companies and low market demand, in addition to a weakness in product differentiation. Therefore, it is concluded that opening a thermocirculator manufacturing company is unfeasible in this context.


Development of an Electromyography Sensor

Published paper (in portuguese): Development of an electromiography sensor

Developed in 2019-2021 on my own as undergraduate research.

Published on: 28/05/2024.

Electromyography is a highly useful tool for clinical applications involving the human-machine interface. This project proposes the development of a system for capturing bio-potentials applicable to activities and projects related to the Arduino microcontroller and the DIY (Do It Yourself) culture. The circuit design involved the use of operational amplifiers, instrumental amplifiers, active band-pass filters, resistors, and capacitors. The result was a circuit capable of receiving signals from the user’s muscles, cleaning, amplifying and delivering them to the microcontroller. Through its integrated analog-to-digital converter (ADC), it displays the signal values, enabling this sensor’s application in DIY projects. Also, a Printed Circuit Board (PCB) was developed with dimensions of 5 x 3.5 cm and 2 layers, and considered the use of through-hole soldering components. The developed sensor had a final production cost of U$ 16.75, including the PCB manufacturing and delivery, all the electronic components and the electrodes wire.