ALBERTO SANTINON

– Migration of a competitive benchmarking solution from Azure Data Factory to Databricks following a medallion structure using pySpark, Delta Tables, Structured Streaming and Workflows. – Migration of warehouse data transformation processes written on Stored Procedures from SQL Server to Microsoft Fabric using pySpark and sparkSQL. – Developed a pricing engine solution in Azure SQL Server utilizing stored procedures, triggers, cursors, and dynamic SQL to process transactions. – Developed and administered Azure Data Factory pipelines for data ingestion and export.

– Contributed to the redesign of the data warehouse to facilitate the transition to a new data supplier utilizing SQL Server and Azure DevOps. – Contributed on dbt documentation creating Confluence page describing dbt's main features, syntax and materialisations including table, view, incremental and ephemeral. – Collaborated on SQL stored procedures to guarantee data quality and consistency within the data warehouse while resolving any identified bugs. – Developed unit tests to assist the QA team in the staging environment utilizing Azure DevOps. – Collaborated with the team to oversee the development environment for the deployment and testing of cloud artifacts. – Developed and maintained Snowflake views.

– Developed a bespoke, automated data pipeline utilizing Python and SQL to extract and process data from Excel spreadsheets into Redshift. – Utilized transformation tools such as dbt to manipulate and process data and deliver usable datasets in accordance with the Data Science team's requirements on Snowflake or Redshift. – Created an interactive dashboard for employee statistics, including projects, managers, annual leave, and sick leave, utilizing Apache Superset.

– Developed new ETL processes and refined existing ones utilizing SAP BW in accordance with customer requirements. – Data was loaded into SAP HANA Cloud and subsequently enriched and transformed utilizing calculation views and stored procedures in accordance with business rules. – Developed data sources and data models prepared for visualization in SAP Analytics Cloud.

– Developed a proof of concept (POC) utilizing Snowflake and Tableau to investigate key performance indicators (KPIs) pertinent to insurance policies and brokers. – Contributed to the development of a cloud data warehouse on Snowflake based on Kimball architecture, which involved designing ERDs and building dimensions and fact tables utilizing Snowflake and dbt for data cleaning, transformation and loading. – Maintained and modified existing ETL pipelines utilizing Matillion and Snowflake. – Developed a data ingestion pipeline from AWS S3 to Snowflake utilizing automations through Snowpipe.

– Developed 40 job order reports for a shipbuilding company to identify process bottlenecks utilizing SAP BO and SAP HANA. – Processed support tickets to address data consistency issues, improve existing SAP BO reports, or rectify dashboard bugs. – I have engaged in various small projects for multiple clients, supporting the project manager in data modeling tasks and resolving data visualization challenges utilizing SAP BO, SQL Server, and Oracle.