Profilo
Esperto prodotto SQL Server sia come Amministratore, Svilupparore, che come BI ( SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analisys Server)
Ho 10 certificazioni Microsoft a partire dalla versione 2008 (MCSE: Data Management and Analytics,MCSA: SQL Server 2012/2014)
ho 8 anni di esperienza in vari settori: Pubblica amministrazione, Settore energetico e settore finanziario.
ho anche capacita di programmazione c# asp.net per Web Application.
. Database Design
Optimized Entity Relation Diagram ERD
Extended ER Diagram EERD
Schema Design
UML Class diagrams
Conceptual, Logical, and Physical Designs
Data Flow Diagram
Dependency Diagrams
. Development in SQL Database
CURD Operations
Table Constraints
Best SQL Queries (DDL & DML)
Complex queries, Subqueries or Correlated Queries
Joins, Groups, Set Operations
Normalization(1NF, 2NF, 3NF, BCNF)
. PLSQL Advance
Stored Procedures
Triggers
Functions
Views
New User Profiles
User Authorization
Indexes and Clusters
. Data WareHousing
SSIS Packages
ETL Packages
Data Collection
Data Transformation
Software That I use:
Microsoft Visio
DeZign by Datanamic
Draw.io
Visual Paradigm
Visual Studio for ETLs
Vertabelo
