Ing. Gabriele Patrizi

Support to define the strategy about data, IT and data remediation. Design and definition of the new data architecture of the banking group, projects and suppliers management, definition of the standard of data quality, reporting and data accessibility risk assessment, data lineage monitoring and golden sources finding, business process reengineering and documentation. Data analysis and data quality controls via SQL and Python, reporting and business intelligence via Power BI.

Lecturer for "Big Data Analytics Professionals" Executive Master dispensed by MAndS at Sapienza University of Rome, on the following topics: Business Intelligence, Data Warehousing, Architectures, Data Analysis and Data Visualization.

Architecture design and creation of the new DWH, projects management and documentation, requirements analysis, definition of the standard of data quality, business intelligence. Development, data analysis and management via Microsoft SQL Server (using SQL and stored procedure), data analysis with SQL and Python (forecasting, linear regression and predictive modelling using Naïve Bayes and Nearest Neighbors) and reporting via Power BI. Furthermore, management of one supplier and of two resources activities.

Design and creation of the new Data Warehouse and business data architecture, business intelligence analysis and development, requirements analysis and development of automated reporting for internal and external customers via Sap BO Infoview, data analysis and management via Microsoft SQL Server Management 2012 (using SQL and stored procedure in T-SQL), data analysis and discovery via QlikView and Power BI. Complete management of an external customer about the reporting and data sharing.

Innovation and automation, data architecture, Data Warehouse analysis, Business Intelligence development and analysis. Forecasting algorithms, data management, analysis and quality via Microsoft SQL Server Management 2012 (using SQL and stored procedure in T-SQL), ETL development and management via SSIS, cubes creation via SSAS and reporting via SSRS. Creation and management of the Business Intelligence front-end via QlikView, reporting and analysis, macros in Visual Basic.

IT to business support. Data Warehouse analysis, development and improvement, data architecture analysis and management, KPIs definition and implementation, Business Intelligence Engineering and ETL via Microsoft SQL Server Management 2012 (creation of stored procedures using T-SQL), data management, analysis and quality, reporting via mails and files (csv and txt). Gather requirements from internal customers using Agile methodology, preparation of architectural and technical documentation.

IT Business Analysis focused on innovation and automation. DWH analysis, development and improvement, Data Marts creation, db admin and BI, ETL and T-SQL for stored procedures via Microsoft SQL Server 2008, integration via SSIS, reporting via SSRS; data management, analysis and quality (using SQL). Business process analysis and reengineering, functional and test specifications using also Agile methodology, gather requirements from external and internal customers, project management via Redmine tool.

Project for MIUR: development of management and resource control system via SAS tools. Used technologies (ETL, BI and DWH): Data Integration Studio, SAS language and SAS Macro language, Management Console, Information Map Studio, Human Capital Management, Financial Management, Strategy Management, BI Dashboard, Information Delivery Portal, SAS Add-In for Microsoft Office, Excel, Sql, MySql.

Data management and development of demo and prototypes. Manufacturing projects on management and analysis of balance sheet; telco project on analysis about satisfaction of customer via social network, among more competitors. Used instruments: SAS tools, SAS language and macro language (using SAS 9.2), SQL.

Obtained on May of 2010 with a score of 106/110. Thesis’s title: “Representation of Critical Infrastructures via Coloured Fuzzy Petri Nets”, about the European project MICIE on Critical Infrastructures, building the Java simulator FCPN-SIM to validate the mathematic model.

Obtained on May of 2007 with a score of 93/110. Thesis’s title: “Re-routing techniques for the problem of urban traffic”.