Project: Support Information Technology - Database Management System of Exprivia S.p.A.
Client: Banca Intesa San Paolo
Database Expert Consulent with varying working time
Type: Database Solution / Web Application
Integrated development environment: Visual Studio
Programming Languages: Visual Basic, C#
Database: Sql Server 2000-2014
Role: MCSE: Data Platform
Managed Activities:
Administering Microsoft SQL Server (From 2000 to 2014),
Deploy Data Warehouse Solution with Microsoft SQL Server SSRS - SSAS - SSIS
Trainer activity for a Course Telerik (VB.Net and Reports) for Administration Public employees
Via Cristoforo Colombo, 112, 00147 Roma (Italy)
********/
Trainer for Business Course of Microsoft Sql Server 2012.
Business or sector IT
Management 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 operation
Controls, 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 Application
IDEs: Visual Studio 2013
ORMs: MS Framework .NET 4.5
Programming Languages: Visual Basic.Net, C#
Technology: HTML, CSS, ASP.NET, JavaScript, Web Forms
Database: SQL Server 2014
OS: Windows Server 2012
Virtualization Software: Hyper-V
Other: TortoiseSVN, Bootstrap
Role: IT Manager
Activities:
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.
Project: DW3 – Data Warehouse Client of Hewlett-Packard Company
Historicizes 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)
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 dimension
Changes with one tutor in various reports QlikView
Updating Environment Development (DB and SSAS) for compatibility with the production environment
Business or sector IT
Business intelligence Tools: SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, QlikView.
Programming Languages: Visual Basic.Net
Database: SQL Server 2005
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 2010
Programming Languages: C#
ORMs: MS Framework .NET 4.0, Entity Framework 5.0.
Activity:
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.
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 with Performance Monitor using User Defined – Data Collector sets
Sql Server Database Developer Activity:
Research a table partitioning strategy suitable for Sql Server Standard edition
T-Sql Script to Simulate Energy Studio Pro® Data Logger Activity
ETL activity with T-Sql for import Excel files into Sql Server
Write "Designing Queries for Performance" Guideline
Microsoft Windows Developer Activity:
"Automated Testing Environment Update" Application - Console mode and Windows Mode
Create Database Versioning API
Quality control Activity:
Reporting Module Reporting Services Research (SQL Server Reporting Services 2012)
Database Versioning Research
Test Activity per Energy Studio Pro® Web Interface
Test Activity per Energy Studio Pro® Workflow
Business or sector IT