Freelancer profile translated to English.

Description

Freelance full-stack developer specializing in PHP and Symfony, with direct and ongoing client relationships since 2011. I take full responsibility for projects: requirements gathering, development, deployment, maintenance, and evolution in production.

My primary area is back-end: custom back-office development, data integration, data modeling, and migrations. I configure and deploy on LAMP/LAPP environments (Apache, MySQL/MariaDB/PostgreSQL, PHP) on Linux (Ubuntu); I have also worked with Nginx (LEMP). I have also deployed on a self-managed PaaS platform (Upsun, formerly Platform.sh). I use Docker in the development environment.

As a differentiating specialty, I have extensive experience in automatic product catalog generation (data → EasyCatalog/InDesign and PIM) and, more recently, in data integration and business intelligence (ETL with Talend, reports in Power BI).

As a representative example: I have been solely developing the online catalog and product management for ROVASI, an architectural lighting manufacturer, for over a decade, with a direct and sustained relationship.

I am looking for collaborations where I can provide technical solvency and long-term reliability, both in new projects and in the evolution and maintenance of existing Symfony applications.

Languages

Catalan
Native or bilingual
English
Conversational
Spanish
Native or bilingual

Workplace preferences

Can work on-site

Barcelona (up to 50km)

ROVASI — fabricante de iluminación arquitectural (Barcelona)
Full-Stack Developer (Freelance)
January 2015 - Today (11 years and 7 months)
Barcelona, Spain
Main client, with sole development responsibility since 2016, in collaboration with the Integrum agency. Online catalog and product management system, with a unified database as the source for the web and (historically) the printed catalog. Design and implementation of the product data model and migration from MySQL to PostgreSQL; complete development of the product management back-office and internationalization in 5 languages; server migrations and PHP/Symfony version upgrades; automation of the printed catalog using an extraction query for EasyCatalog/InDesign. Continuous maintenance and evolution for over a decade, with a direct and sustained relationship.
PHP Symfony PostgreSQL Doctrine twig
Faro Barcelona — fabricante de iluminación (Barcelona) · vía proveedor
Developer — Data Integration and BI
January 2024 - January 2026 (2 years)
Barcelona, Spain
Data integration and business reporting: database fed from various client sources (Kriter ERP, Google Analytics) to support Power BI reports. Work by areas, in coordination with the vendor and the client's technical team. Definition of tables and views oriented towards reporting exploitation; development of integration jobs (ETL) in Talend; integration of Google Analytics data through Python scripts against the Google API; adaptation and creation of reports in Power BI.
Skills to tag: SQL · Talend (ETL) · Power BI · Python · Google Analytics API · Data Integration · Business Intelligence · View Modeling
Talend PowerBI SQL Python ETL
Caepia — plataforma B2B (SaaS) de gestión de compras para restauración
Full-Stack Developer (Freelance)
January 2018 - January 2019 (1 year)
Barcelona, Spain
Purchasing management application with multi-restaurant support and client-specific data separation. Supplier catalog modules, orders, production orders, and goods receipt. Implementation of the product data model (design by a third party) on MySQL; complete development of the administration back-office; implementation of the application structure, controllers, and services in Symfony; Twig template controllers and structure for the frontend (layout and design by The Onliners agency; the REST API developed by an external team).
PHP Symfony MySQL Doctrine twig