At Grupo Lorenzo, I design and maintain a layered data architecture across ODS, Data Warehouse, and Power BI semantic models. I build ETL pipelines with SSIS and Python to bring ERP and SQL Server data into the ODS.
I migrated Power BI sources from Excel and Python to SQL Server views and stored procedures, centralizing business logic. I also developed an OAuth2 integration with third-party REST APIs to replace an RPA process affected by authentication changes.
At Grupo Lorenzo, I develop Power BI dashboards for aftersales and inventory, bringing counter and workshop sales from several units into one model. I’ve also adapted inventory dashboards to a new stock classification methodology.
Previously at Sauda SRL (Blowmax and Super A), I developed data integrations and dashboards, scraped competitor prices, and created clustering models to segment products and customers. Earlier, as a Cost and Pricing Analyst, I analyzed costs, margins, and profitability to support pricing strategies.
