Bernat Borràs Cabot

Modern Data Warehouse with SQL Server

Data Engineering Portfolio Project | SQL Server, T-SQL, ETL and Data Modelling

Designed and implemented an end-to-end data warehouse using medallion architecture; Bronze, Silver and Gold layers.

Loaded CRM and ERP source data into the Bronze layer and developed stored procedures to clean, standardize, validate and integrate the data in the Silver layer.

Created analytics-ready views for customers, products and sales in the Gold layer, using dimensional data modelling principles.

Implemented data quality checks and analytical SQL queries to explore sales performance, customer behaviour and product trends.

IMDb Horror Movies Web Scraping Pipeline

Academic Team Project | Python, Selenium, pandas and Web Scraping

Developed a web scraping pipeline to collect structured data on horror movies released between 2015 and 2025 from IMDb.

Automated browser interaction and dynamic content loading using Python and Selenium.

Extracted movie titles, release years, durations, ratings, synopses and source URLs.

Cleaned and structured the collected information into a reusable CSV dataset for further analysis.

Collaborated through Git and GitHub in a two-person university project.

Electrical Engineer Consultant | DEI - External Consultant at COMEXI

R&D Electrical Engineering | Riudellots de la Selva, Girona

Design and update electrical schematics for industrial printing machinery.

Manage electrical components and bills of materials through SAP.

Coordinate technical requirements, materials, and deliveries with suppliers.

Collaborate with mechanical, automation, software, and manufacturing teams.

Support product development and continuous improvement within the R&D department.

Design and integrate electrical assemblies, industrial control components, and pneumatic systems.

Opsis Vision Technologies Sccl | Junior Developer

Parc Tecnològic de Girona

Contribution to the development of robotics and computer vision applications.

Identify and troubleshoot issues related to AI models.

Implementation in C++ of interface standard for industrial cameras

Programming of robotic arm movements defined by eye-to-hand communication

Customer Onboarding and On-site implementation programs

Beca de Transfarència, Innovació I Emprenedoria (BTIE22)

Parc Tecnològic de Girona

Develop AI computer vision application using Xilinx technologies.

Course on transfer, entrepreneurship, and the business world aimed at Transfer Innovation, and Entrepreneurship scholarship holders

AETECH (Aplicacions Elèctroniques SA)

DAC Department

Development of industrial automation applications.

Creation of an HMI for a feed factory and its subsequent connection to the factory server and sensors

Technical documentation elaboration

Master's Degree in Data Science

Universitat Oberta de Catalunya - UOC

Focused on statistical analysis, machine learning, deep learning, data engineering, artificial intelligence and computer vision.

Bachelor's Degree in Automation and Industrial Electronics Engineering

Universitat de Girona – UdG

Focused on industrial automation, electronics, control systems, robotics, electrical engineering and programming.