Education
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.
Master's Degree in Computational Statistics and Data Analysis @University of Porto
Sept.2022 - Jul.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, computational statistics, and both 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.
Professional Experience
Data Analyst Curricular Intership @FORCERA
Oct.2023 - Apr.2024
During this internship, I developed and implemented an automated system for applying red flags—indicators 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
Data Analyst @Creative Toys Portugal
Dec.2024 - Jul.2025
Creative Toys is a Portuguese company that commercializes toys and games, with trading card games as one of its main products. As part of the Financial Department, my key responsabilites included:
- Transforming quarterly profitability analyses of products and clientes - traditionally performed in Excel - into fully automated Python scripts, significantly improving efficiency, reliability and speed.
- Creating automated reporting pipelines by extracting data through SQL queries from a large database and applying subsequent transformations in Python.
- Developing interactive PowerBI dashboards to monitor financial KPIs, analyse sales performance, and support the preparation of budgets and financial reports.
- Collaborating with sales and logistic teams to forecast revenue and optimize order supply.
Tools Used: Python w/ Numpy, Pandas and Psycopg2, Microsoft SQL Server, Microsoft Excel, PowerBI, Cegid Primavera ERP, CRM Salesforce