Education

Master's Degree in Computational Statistics and Data Analysis @University of Porto
September 2022 - July 2024

During this two-year program, I had the opportunity to delve deeper into topics such as :

• simple and multiple linear regression; logistic regression
• time series analysis
• stochastic processes and Markov chains
• supervised and unsupervised learning methods

using both R and Python. In the second year, I completed a six-month curricular internship at the Portuguese start-up FORCERA, where I developed a Python program to detect anomalies in Portuguese public contracts.

You can check the course page here.

Bachelor's Degree in Physics @University of Porto
Sept.2017 - Jan.2022

During this degree, I have develop a solid foundation in various subjects ranging from real analysis, linear algebra, and both classical and modern physics to programming and experimental laboratory work. In many of these courses, Python was extensively used, particularly alongside libraries such as Pandas, NumPy, Matplotlib, SciPy, and Plotly.

You can check the course page here.

Professional Experience

Data Analyst @Creative Toys Portugal

December 2024 - July 2025

As part of the Financial Department, my key responsabilites included the development of complex SQL queries and consequent data tranformation using Python in order to:

• Develop quarterly profitability analyses for products and customers. This process, traditionally performed in Excel, was converted into Python scripts, significantly improving efficiency and reliability, and resulting in a 240-fold increase in speed—from 8 hours to 2 minutes.
• Develop interactive dashboards in Power BI to monitor financial performance KPIs, analyze sales performance, and support the preparation of budgets and financial reports.
• Work with the sales and logistics teams to forecast revenue and optimize order fulfillment.

Tools Used: Python w/ Numpy, Pandas and Psycopg2, Microsoft SQL Server, Microsoft Excel, PowerBI, Cegid Primavera ERP, CRM Salesforce

Data Analyst Curricular Intership @FORCERA

October 2023 - April 2024

During this internship, I developed and implemented an automated system for applying red flags defined by the Open Contracting Partnership, in accordance with the legislation of the Portuguese Public Contracts Code, with the purpose of identifying potential irregularities in public procurement contracts. Based on the Open Contracting Partnership guidelines, nine binary red flags were selected and adapted to the Portuguese context. For each of these red flags, a PostgreSQL query was created to detect and flag contracts. The database, updated daily with new contracts published on Portal Base - the official government platform for public procurement -, served as the system’s data source. A Python script, built using the psycopg2 library, connected to the database and executed the queries through dedicated functions. The resulting contracts triggered by at least one red flag were then copied into a new database table for further analysis.

This entire process was automated by containerizing the Python scripts using Docker and deploying them on Amazon Web Services, ensuring daily monitoring of new contract entries into the PostgreSQL database. From the research conducted, it was concluded that the system was effective in identifying and flagging public contracts that did not fully comply with the criteria defined by the Public Contracts Code, thereby serving as a valuable tool for the management and supervision of public procurement.

This project was developed as part of my master's dissertation, which is available for consultation here.

Tools Used: Python w/ Numpy, Matplotlib, Pandas, Psycopg2, PostgreSQL, GitHub, Docker, AWS Lambda Function, AWS ECR