Online Technology Consulting activities on the technologies that I have already proven mastery:T-SQL, SQL SERVER, SSIS, SSRS, SSAS, PL / SQL, Azure SQL, PL / SQL, Asp.Net, c #, Microsoft Outlook, Windows Server, HTML, VBA, Microsoft Excel, Microsoft, Access, MySQL, XML, C #, IT Security, Design database, Object-oriented analysis and design (OOAD), PHP, JavaScript, CSS, PowerPoint, Bash shell, Arduino IDE, Arduino motor shield driver, Power BI, Active Directory, PowerShell, Python, Azure, Data Studio, Google Analitys, Google AdSense, Google Tag, Docker, MongoDB , Oracle DB, PySpark• Technologies under study: Notebook Jupiter, Kubernetes, Ruby language, ElasticSearch, Cassandra, Amazon Web Services, Microsoft Dynamics 365, Azure DevOps Services, XAMARIN, Bluetooth protocol• Development of Studio Software Solutions to expand and apply my knowledge on the new technologists used in the didactic courses / personal lessons• Search for new customers• Work on updating Professional Website (HTML5 - PHP - MYSQL)• With Front-End compatible for Desktop and Mobile Browser (Safari - Google Crome)• Development of Software Solutions for Future Publication on Apple Store, Starting from a Conceptual Idea of mine and self-financed - Of a confidential nature as indeed not yet published and incompleteVISIT MY WEBSITE: WWW.DAVIDE986.ALTERVISTA.ORGAnd read more about me and the Regulated Profession of Informatics Industrial EngineerMost important occasional tax substitute clients:• Client: Eiss S.r.l. Legal Representative Christian Cerutti• Client: lemsys srl Legal Representative Arch. Luca Moscardi• Client: Dv Media Net Legal Representative Politi Alfio

Project: Support Information Technology - Database Management System of Exprivia S.p.A.Client: Banca Intesa San PaoloDatabase Expert Consulent with varying working time Type: Database Solution / Web ApplicationIntegrated development environment: Visual Studio Programming Languages: Visual Basic, C#Database: Sql Server 2000-2014Role: MCSE: Data Platform with Business Intelligence skillsManaged Activities: Administering Microsoft SQL Server (From 2000 to 2014),Deploy Data Warehouse Solution with Microsoft SQL Server SSRS - SSAS - SSIS

Project: Sigma Giovani of Unisys Italia Spa.Client: Ministry of Labour and Social PolicyManagement information system for Monitoring Audit activity.The SIGMA Giovani is the local system of DGPAPL and is responsible for the management of:vital statistics, structure, equipment and Operative Program (O.P.)Monitoring and surveillance of O.P.Financial transactions O.P.Accounting records of each operationControls, performed by both parties of the system of management and control systems (the first level controls, Certifying Authority, Audit Authority), or by external parties (e.g. Commission, IGRUE, Court of Auditors, etc.).Irregularities detected by all subjects with the power of control over the operations and the data related to the monitoring of corrective actions taken.Type: Database Solution / Web ApplicationIDEs: Visual Studio 2013ORMs: MS Framework .NET 4.5Programming Languages: Visual Basic.Net, C#Technology: HTML, CSS, ASP.NET, JavaScript, Web FormsDatabase: SQL Server 2014OS: Windows Server 2012Virtualization Software: Hyper-VOther: TortoiseSVN, BootstrapRole: Senior DBA (MCSE DATA PLATFORM) with Asp.Net skillsActivities: Person in charge of Database Project Sigma Giovani.Database Analyst.Database Designer.Support activities for the development team.Maintenance and optimization of databases. Sizing disks, the installation and configuration SQL instances.Installing and configuring Reporting Services. Activity monitoring server and production machines.Migrating from SQL Server 2005 to SQL Server 2014. Management and administration of users / permissions. Interfacing with Oracle Database.

Trainer activity for a Course Telerik (VB.Net and Reports) for Administration Public employees

Project: DW3 – Data Warehouse Client of Hewlett-Packard CompanyHistoricizes transactional data residing on accounting systems dedicated to the management of certain products established or delegated at Eurizon Capital.The set of the analysed data is constituted by:-The Heritage, Collection, subscriptions / redemptions, transfers / withdrawals;- Activations and revocations of contracts of G. Collective.Type: Data Warehouse 4 level (Staging - History - Primary - DataMart)Client: Eurizon Capital - Banca Intesa San PaoloIDEs: Visual studio 2005 Business intelligence Tools: SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, QlikView.Programming Languages: Visual Basic.NetDatabase: SQL Server 2005Other: Team Foundation ServerRole: Business Intelligence Microsoft Consultant Activity:Edit SSIS packages for the acquisition of new columns in csv files.Edit tables, views, stored procedures for loading new data.Adding new hierarchies on the product dimensionChanges with one tutor in various reports QlikViewUpdating Environment Development (DB and SSAS) for compatibility with the production environment

Project: Administration Data Warehouse and Graphic Reports of the application Energy Studio Pro ® Properties ® GmbH BaxEnergy for different Customers: EDF Group, Enel Green Power, Imwind, etc...Type: Database Solution / Web Application Client: Bax Energy Italia S.r.l.IDEs: Visual studio 2010Programming Languages: C#ORMs: MS Framework .NET 4.0, Entity Framework 5.0.Technology: Windows Presentation Foundation Database: SQL Server 2008 r2 - SQL Server 2012Other: Team Foundation Server, LinQRole: Analyst Developer – Database AdministratorActivity:Sql Server Database Administrator Activity:Migration Database.ETL con SSIS per import in Sql Server.Troubleshoot and optimize queries, Gathering Performance Information and Work with data Write "Sql Server Performance Analysis" Guideline.Technical Support Activity (Sql user permissions, SNAPSHOT, Recursion in T-SQL, use sp_MSForEachTable, Log Shipping, how configure full text, SQL Datetime Conversion into String by Formats, CONTEXT_INFO, BULK INSERT, BACKUP DATABASE, Adding External References to SQL CLR Projects, Partitioned Views, BULK INSERT, MERGE, SQL Server Service Broker) .Estimating Database Size and Analyse CPU and Ram requirements during Data Generator withPerformance Monitor using User Defined – Data Collector setsSql Server Database Developer Activity:Research a table partitioning strategy suitable for Sql Server Standard editionT-Sql Script to Simulate Energy Studio Pro® Data Logger ActivityETL activity with T-Sql for import Excel files into Sql Server Write "Designing Queries for Performance" GuidelineMicrosoft Windows Developer Activity:"Automated Testing Environment Update" Application - Console mode and Windows ModeCreate Database Versioning API Quality control Activity:Reporting Module Reporting Services Research (SQL Server Reporting Services 2012)Database Versioning ResearchTest Activity per Energy Studio Pro® Web InterfaceTest Activity per Energy Studio Pro® Workflow

Project: W.A.S.P (Web Agenda sistema per il Provisioning).The application W.A.S.P. is a management software for the workflow of the activities of Telecom / PAth.Net employees.Type: Web Application - Two-tier architectureClient: PAth.Net - Gruppo Telecom Italia S.p.A.ORMs: Visual studio 2008 Programming Languages: Visual Basic.Net, C#ORMs: MS Framework .NET 3.5, Asp.Net Database: SQL Server 2005Role: Analyst Developer – Database AdministratorActivities:Installing and configuring SQL Server DatabaseDesigning a Database (Entity relationship diagram).Designing and Implementing Programming Objects and Indexes.Data analysis and verification database referential integrity. Build new application functionality Using VB.NET and C# in the same solution (Workflow management, Planning Activities) using ADO.net and improved maintainability of some existing functions.Used Telerik - Ajax controls.Interfacing with remote application WeTech through Web Services to database data synchronization. Solution developed in Windows Service. Install and configuration of Visual Studio 2008 Team Foundation Server.Writing user manual and mentoring activities for handover of the project at another employee.

Project: Portale SifipThe application SIFIP is a portal that allows Ministerial Inspectors to share information relevant to their work. The use of the various features of Microsoft SharePoint Server 2007, will improve the management of documents and will increase the dialogue and the exchange of information, through the customization of tabs verification, categorization of documents, and through the use of sections which: Blog, Wiki and News.Type: Web Application - Two-tier architectureClient: Consip S.p.A. IDEs: Visual studio 2008ORMs: Asp.Net 3.5 Other: Microsoft SharePoint Server 2007, Team Foundation ServerDatabase: SQL Server 2005Role: Analyst Developer – Database AdministratorActivities:Created Web Parts with Database Sql Server 2005 access for forms asp.net to insert/update/delete/views/ search data and send newsletter emails.Programmatically create pages and document library from WebPart.Creating Web-Part for Managing newsletter and Sending e-mail.Used Telerik- Ajax controls.Designing a Database Strategy and Designing Database Tables.Designing and Implementing Programming Objects and used SSIS Packages to Import Data.

Project: Sistema integrato Valutario Antiriciclaggio SIVAIt is an integrated web application for manage the "Direzione V" of the department of The Department of the Treasury Italian. In the past there were two distinct areas, but now the two areas are being unified:Sigiweb for handling administrative offenses provided for by the legislation against money laundering,GIV for handling administrative offenses provided for by currency regulations,SIVA The system has the following characteristics:- One-Extranet- Single database-The common functions implemented once-The functions peculiar to specialized according to the regulations:-Management of seizures for values of the people and cancelled seizures (only scope for currency area)-"Management and security" for offenses (different according to the area functional)-Management offerings (different according to the area functional)-Management disputes (for only anti-laundering area functional)-Document Management-Managing user levels, simplifying-Administrative FunctionsType: Web Application - 4-Tier ArchitectureClient: Consip S.p.A. IDEs: Visual studio 2010 Languages: C# Technology: HTML, CSS, JavaScript, Web Forms, ASP.NET, Windows Communication Foundation ORMs: MS Framework .NET 4.0, Entity FrameworkDatabase: Sql Server 2005Role: Developer SoftwareActivities:Created Aspx Pages with framework Eidos.ETL operation and migration data to Sql Server.Created UML diagrams (Sequence Diagram, Use case diagram).Corrected the x-html web pages for usability and accessibility using the Stanca law using W3C® Markup Validation Service.Created Views.Used LINQ and Entity Framework.Created Reports with Crystal Reports.

Project: Business AgendaType: Java applicationClient: Business application.Integrated development environment: EclipseRole: Software developerLanguages: JavaDatabase: MySql 5 Activities:Creating a Business Agenda using the main software design patterns for object-oriented programming Sun