Sep 2014 – Today

Application Manager and Technical Team Coordinator

DOLCE & GABBANA S.p.A., Legnano (MI)

▪  Team performance monitorabout .Net developermembers and functional software support (PLM, Retail POS system, Order entry)

▪  Team goalssetting

▪  Tasks and deadlinesdelegation

▪  Day-to-dayoperationoversee

▪  Team building activitiesorganization

Mainprojects:

▪  Enterprise Data Warehouseadministration

▪  PLM software management

▪  Production Planning suite administration

▪  Order entry suite administration

▪  Dynamic AX and CRM integration with ERP

▪  Pricing System administration

▪  Corporate DAM Integration

▪  Data Integration betweenthird partyapplications and Enterprise Data Warehouse: API management, custom console application

▪  PowerAppsdevelopment

Usedtools:

▪  Microsoft Azure: LogicApps, Data Factory, Data Gateway

▪  Microsoft Office 365:PowerApps, Flow, Forms, Teams, Planner, SharePoint

▪  Microsoft DevOps

▪  Swagger

▪  SoapUI

▪  Sql Server Integration Services

▪  Microsoft Visual Studio

▪  Microsoft Sql Server Integration Services

▪  Microsoft Reporting Services

May 2012 – Today

Microsoft Sql Server Administrator

DOLCE & GABBANA S.p.A., Legnano (MI)

▪  SQL Server databasesmanagement through multiple productlifecycleenvironments, from development to mission-critical production systems

▪  Database servers and processesmaintenance and configuration, includingmonitoring of systemhealth and performance, to ensure high levels of performance, availability and security (CPU, RAM, HD and TempDbbottlenecksdetection)

▪  Independentlyanalyze, solve, and correctissues in real time, providingproblemresolution end-to-end

▪  Assist developers with complexquerytuning and schema refinement

▪  Provide 24×7 supportfor critical production systems

▪  Excellentknowledge and implementation of: stored procedure, functons, trigger, jobs, CLR elements, partitionedtables, log shipping, columnstoreindexes, changetracking, change data capture, dynamicmanagemetviews, maintenanceplans

▪  Hardware sizing

Mainprojects:

▪  Enterprise Data Warehouse

▪  POS database migration to Sql Server

▪  Administration and maintenance (entirelifecycle) aboutallinstances in Italy, New York, Hong Kong, Tokyo

Usedtools:

▪  Microsoft Sql Server Management Studio

▪  Microsoft Sql Server Tuning Advisor

▪  Microsoft Sql Server Profiler

▪  Microsoft Windows Performance Monitor

▪  Red Gate Suite (tools for Sql Server, .Net, Oracle)

May 2012 – Today

Corporate Data Warehouses Administrator

DOLCE & GABBANA S.p.A., Legnano (MI)

▪  Responsible for the development and sustainment of the Corporate SQL Server Data Warehouses

▪  Data warehouse and data mart schema data model creation

▪  ETL development, data aggregation and transformation

▪  Resultsvalidationwith business representatives

▪  Implemented business intelligence solutionssupport (Business Objects, Microsoft Power BI)

Mainprojects:

▪  3 layer Retail relationalCorporate Data Warehousecreation

▪  Microsoft AX data integration

▪  ERP (DB2), POS (Sql Server) and othersouces (Oracle, Access, Google Analytics, Xml, Web Service) dataintegration

Usedtools:

▪  Microsoft Visual Studio 2017

▪  Microsoft Sql Server Integration Services

▪  Microsoft Reporting Services

Apr 2006 – Today

Senior Analyst, ETL and .Net Developer

DOLCE & GABBANA S.p.A., Legnano (MI)

▪  ETL dataflow design

▪  Windows applicationdevelopment

▪  Web site and webservicedevelopment

▪  Batch automationtasksdevelopment

Mainprojects:

▪  Dynamics CRM data integration

▪  Dynamics AX and CRM data integration

▪  CRM custom Windows applicationdevelopment for customer merge, preferredstore and sales assistantdefinition in the Retail environment

▪  EDI integration of Corporate POS with localfinancesystemsthough custom web services

▪  PLM utilitiesdevelopment

▪  Production Planning system startup

▪  Custom data migrationobjectsdevelopment

▪  Google Analytics stats and Data Warehouseintegration

▪  Externalwarehouses data integration

Usedtools:

▪  Microsoft Visual Studio 2015 (VB.NET, C#, Linq)

▪  Sql Server Business Intelligence Development Studio

▪  Sql Server Data Tools

▪  DevExpress Components

▪  QuestToad for Oracle

Apr 2003 – Apr 2006

.Net Developer

BIANCHI MARE’ S.p.A., Caronno Pertusella (VA)

▪  Web development

▪  Hardware and network administration

Mainprojects:

▪  Enterprise site and embeddedEcommercemodule

▪  Customer care web intranet

Usedtools:

▪  Microsoft Visual Studio

▪  Microsoft Sql Server

Oct 2002 – Apr2003

IT Teacher

Clerici Insitute, Parabiago (MI)

▪  Web development

▪  Microsoft Access

Feb 2000–Apr2003

Web Developer

CALCOL INFORMATICA srl, Legnano (MI)

▪  Web development

Mainprojects:

▪  Web site Regione Lombardia

▪  Web portal Real Estate agencies

Usedtools:

▪  Microsoft Visual Studio

▪  Microsoft Sql Server

TRAINING COURSES

May 2019

Workshop – Dynamics 365 Administration &Troubleshooting

Microsoft

Feb 2019

Sep 2018

Workshop – Dynamics 365 Performance & Data Automation Framework

Microsoft

English Course

Wall Street English Busto Arsizio

Jun 2016

Official Microsoft MSPE level 400

Sql Server 2014 Performance Tuning and Optimization

▪  SQL Server execution model, waits and queues

▪  Core I/O concepts, Storage Area Networks and performance testing

▪  Architecturalconcepts and best practicesrelated to data files for userdatabases and TempDB

▪  Architecturalconcepts and best practicesrelated to Concurrency, Transactions, IsolationLevels and Locking

▪  Architecturalconcepts of the Optimizer and how to identify and fixqueryplanissues

▪  Architecturalconcepts, troubleshootingscenarios and best practicesrelated to Plan Cache

▪  Understandtechniques to identify and diagnosebottlenecks to improveoverall performance

Jul 2014

Official Microsoft Sql Server Integration Services

Deal with loading of differentkinds of data into SQL Server

▪  Creating an Integration Services Project

▪  Executing a package from SQL Server Data Tools

▪  Changingcommand-line applicationargumentsusingExpressions

▪  Change Data Capture(CDC) database objects

▪  Preparing data for CDC and performingIncrementalloading

PERSONAL SKILLS

Foreignlanguages

English B2

French A2

Communicationskills

▪  Empathiclistener and persuasive speaker

▪  Godpresentation and negotiationskills

Organizational and management skills

▪  Leadership (currentlyresponsible for a team of 6people)

▪  Workingindependently and collaboratively

▪  Excellentorganisationalabilities

Operating Systems

▪  Windows Server 2008 R2, 2012 R2, 2016 R2

▪  Windows 7, 8, 10

Databases

▪  Microsoft Sql Server 2005, 2008, 2012, 2014, 2016, 2017

▪  Oracle 10, 11, 12

▪  DB2 400

▪  Microsoft Access

▪  File Maker

▪  Google Analytics

Software

▪  Microsoft Visual Studio 2010, 2012, 2015, 2017(C#, VB.NET, Linq)

▪  Sql Server Business Intelligence Development Studio

▪  Sql Server Data Tools

▪  DevExpress Components

▪  QuestToad for Oracle

▪  Microsoft Dynamics 365

▪  Stealth (DB2 400)

▪  Microsoft DevOps

▪  Microsoft Life Cycle Service

▪  Microsoft Sql Server Integration Services

▪  Microsoft Sql Server Reporting Services

▪  Microsoft Sql Server Analysis Services

▪  Microsoft Sql Server Management Studio

▪  Microsoft Sql Server Tuning Advisor

▪  Microsoft Sql Server Profiler

▪  Microsoft Windows Performance Monitor

▪  Swagger

▪  SoapUI

▪  Red Gate Suite (tools for Sql Server, .Net, Oracle)

▪  Scribe

▪  DBeaver

▪  Microsoft Office Suite

▪  Microsoft System Center Configuration Manager

▪  SimpanaCommvault (backup