Would you like to go to https://onsiter.com/us/ instead?
Might be available
(Updated 2020-05-15)IT Manager & SQL Server Database Expert
Mascalucia, Province of Catania, Italy
Beginner Italian, English
- ORMs, OS,
- Database, IDEs, Business Intelligence Tools
Skills (77)
LIFE CYCLE
Data Analysis
XML
MCSE
STATISTICS
PUBLIC RELATIONS
HELP DESK
SQL SERVER 2008
MANAGERIAL
POLICY MANAGEMENT
OPTIMIZATION
SQL SERVER 2005
SQL
OFFICE 2010
MS ADO
LOGGING
Visual Basic
WORKFLOW MANAGEMENT
AUTOMATED TESTING
CUSTOMER RELATIONSHIP MANAGEMENT
Microsoft SQL Server
ESTIMATING
EXPLORATION
Xamarin
Microsoft Access
MySQL
ADO
INTERNET EXPLORER
CRM
MENTORING
SHIPPING
TELECOMMUNICATIONS
CONTRACTS
DATABASE MODELING
ADO.NET
MICROSOFT OFFICE 2010
GSE
PUBLISHING
CCNA
DATA ENTRY
SQL SERVER 2012
ACCOUNTING
Business Intelligence
COLLECTION
MICROSOFT INTERNET EXPLORER
DB2
DATABASE ADMINISTRATOR
Oracle
PRODUCTION ENVIRONMENT
SQL Server
DATABASE MANAGEMENT
CREDIT
SQL SERVER 2000
MICROSOFT SQL SERVER 2012
WRITING TECHNICAL
BANKING SYSTEMS
ADJUSTMENTS
RELATIONSHIP MANAGEMENT
USER INTERFACE
STORED PROCEDURES
INTEGRATION
ACROBAT
MS SQL Server
BI
WORKFLOW
MICROSOFT OFFICE
TECHNICAL SUPPORT
Telecom
Excel
CONTROL SYSTEMS
LOGISTICS
MARKETING ANALYSIS
SQL SERVER 2008 R2
SOFTWARE DESIGN
ARCHITECTURE
DATABASE
Professional Experience
2020-05 - Present
Database: sql server 2019 - Azure
Role: Database/Software Archietect
Business or sector Information and communication
2020-05 - 2020-05
http://www.baxenergy.com/
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. Technology:
Windows Presentation Foundation
Database: SQL Server 2008 r2 - SQL Server 2012
Other: Team Foundation Server, LinQ
Role: Analyst Developer - Database Administrator 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. 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
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
2020-05 - 2020-05
http://www.ao-garibaldi.catania.it/
Project: Gestione strutture ricettive
Integrated development environment: Microsoft Office - Windows
Role: Software developer / data entry
Activities: Help desk hardware / software. Programming Office Applications: Access (Tables, Forms, Modules VBA, Reports) Data entry with a management software for hospitality.
Business or sector Human health and social work activities
2020-05 - 2020-05
Client: Business Agenda
Type: Java application
Client: Business application.
Integrated development environment: Eclipse
Role: Software developer Languages: Java
Database: MySql 5 Activities: Creating a Business Agenda using the main software design patterns for object-oriented programming Sun
Business or sector Information and communication
2020-05 - 2020-05
Project: Sistema integrato Valutario Antiriciclaggio SIVA It 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 Functions
Type: Web Application - 4-Tier Architecture
Client: 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 Framework Database: Sql Server 2005
Role: Developer Software
Activities: Created Aspx Pages with framework Eidos. ETL operation and migration data to Sql
2020-05 - 2020-05
Project: Portale Sifip The 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
2020-05 - 2020-05
http://www.proximainformatica.com/
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 architecture Client: 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 2005
Role: Analyst Developer - Database Administrator
Activities: Installing and configuring SQL Server Database Designing 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.
Business or sector Information and communication
2020-05 - 2020-05
http://www.adecco.it/
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) Client: Eurizon Capital -
Banca Intesa San Paolo IDEs: Visual studio 2005 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
Other: Team Foundation Server
Role: 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 dimension Changes with one tutor in various reports QlikView Updating
Environment Development (DB and SSAS) for compatibility with the production environment
Business or sector Information and communication
2020-05 - 2020-05
http://www.sesanv.com/
Trainer for Business Course of Microsoft Sql Server 2012.
Business or sector Information and communication
2020-05 - 2020-05
Via Pomarico, 58, 00178 Roma (Italy)
http://www.esis-italia.com/
Trainer activity for a Course Telerik (VB.Net and Reports) for Administration Public employees
Business or sector Information and communication
2020-05 - 2020-05
http://www.dacomat.com/
Project: Sigma Giovani of Unisys Italia Spa. Client: Ministry of Labour and Social Policy 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
Business or sector Information and communication
2020-05 - 2020-05
http://www.dacomat.com/
2020-05 - 2020-05
Shopping Malls in Rome and Catania with the company: Target Italia S.r.l. - Viale Umbria, 11/A -
20135 Milano in Centri Commerciali RM e CT.
Occasional work as a Webmaster for the websites: www.teafalco.com, www.davide986.altervista.org/
Configuring Wi-Fi router for video surveillance.
2002-01 - 2019-01
2002-01 - 2019-01
ORMs: MS Framework .NET 3.5
Technology: ASP.NET , HTML, CSS, JavaScript, Web Forms
Database: Sql Server 2008
Role: Developer Software
Activities: Created Aspx Pages with framework Eidos. Used Telerik - Ajax controls. Used LinQ
Technology. Functionality Importing monthly data from Excel File - XML db on SQL Server. Imported
data from excel to Sql server with SSIS. Created Views.
Project: Prototipo GSE Formazione office 2010 Users upgrading of skills in the use of the products of
Microsoft Office 2010. In particular, the activities involve a potential target of about 950 users (shared between GSE, GME, AU and RSE) taking into account the different contexts from the point of view of the role of business covered, prior knowledge and logistics.
Type: Web App - Sharepoint 2007
Client: Gestore dei Servizi Energetici - GSE S.p.A.
IDEs: Visual studio 2010
Languages: C# Technology: HTML, CSS, JavaScript, Web Forms, Asp. Net ORMs: MS
Framework .NET 4.0 Other: SharePoint 2007, Team Foundation Server
Role: Analyst Developer - Database Administrator Database: SQL Server Activities: Created aspx
pages and SharePoint Document libraries Created Custom Master Pages and layout Created
Content Query Web Part Management Database (sizing, partitioning, etc.)
Project: Anas OpenPageIIS.Service Technology infrastructure management services for Unix / Aix,
Windows 2003 Server, Oracle, and SAP Tcp-Ip Anas.
Type: Windows Service
Client: Anas S.p.A.
Integrated development environment: Visual studio 2008 - C# Asp.Net 3.5.
Role: Developer Software
Activities: Creating a Windows Service for the WebRequest, through reading URLs from xml file,
logging into a file individual the cases of success or failure in order to start the first build faster,
therefore, the user navigation.
Business or sector Information and communication
2002-01 - 2019-01
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: L488 The solution EIDOS L488 manages the life cycle of all requests for facilitating access to credit, banks submitted to the dealer by the companies qualifying for access to credit under the law
L488/92. The solution has been developed with a modular architecture according to the continuous
changes of the law itself. One section is devoted entirely to the investigation stage, guiding the user to
the definition of the outcome (positive or negative) for access to credit. A second section is devoted to
the control SAL submitted by companies including calculations of the contributions to be paid and
phase Grant making. This section interacts with the banking systems of the Customer for the accounting and preparation of recovery plans.
Type: Windows Application Client: Artigiancassa S.p.A.
IDEs: Visual studio 2008
Languages: C#
ORMs: MS Framework .NET 3.5
Database: Sql Server 2005
Role: Developer Software
Activities: Used library FileHelpers to Write Master-Details records to files.
Project: Italferr Access Gestione Tratte-Contratti Provision of specialist assistance: -Update-functional
system integration with Business Objects and SAP R / 3 and BI Database and other business;
-Update, control and monitoring of the infrastructure of Web systems; -tuning, optimization and integration of enterprise database; -Analysis of business processes, the design of the application flows
and alignment to existing systems; -Updating the standards of usability and user interface of Web
systems; -Updating map data and GIS business;
Type: File Microsoft Access 2007
Client: Italferr - Gruppo Ferrovie dello Stato
Commercial office suite: Microsoft Office Access 2007
Languages: Visual Basic for Application
Role: Analyst Developer - Database Administrator
Activities: Designed a Database Strategy and Created Database, Tables, Relations, Indexes, Views.
Created Forms and Sub-Forms Created reports (text and graphic)
Business or sector Information and communication
2000-01 - 2014-01
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
Business or sector Information and communication
2012-01 - 2012-01
Test Activity per Energy Studio Pro® Workflow
Business or sector Information and communication
2007-01 - 2007-01
the use of sections which: Blog, Wiki and News.
Type: Web Application - Two-tier architecture Client: Consip S.p.A.
IDEs: Visual studio 2008 ORMs: Asp.Net 3.5 Other: Microsoft SharePoint Server 2007, Team
Foundation Server Database: SQL Server 2005
Role: Analyst Developer - Database Administrator Activities: 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: Italferr - ROI Giustificativi Development of the Application "ROI Justifications" for compiling the weekly timesheet for the employees Italferr.
Type: Web Application - Three-tier architecture
Client: Italferr - Gruppo Ferrovie dello Stato: Italferr - Gruppo Ferrovie dello Stato
IDEs: Visual studio 2010 Languages: C# ORMs: .NET 4.0 Business intelligence Tools: SSIS.
Database: SQL Server 2008
Role: Analyst Developer - Database Administrator
Activities: Created a Windows Service in C# for History change tracking of data check in/ check out
employees with start at night. Used SSIS to Migrate Oracle database to SQL Server 2008 Database
check in/ check out employees.
Project: CCVT Management Current Accounts The solution manages the accounts resulting from
the issuance of passports in the Italian offices abroad. Includes a step of recording the accounts, with any adjustments communicated later, and a step of transferring money from current accounts opened with Italian foreign offices. The system is integrated with other accounting applications and provides
the ability to automatically create all the necessary paperwork to the operators.
Type: Web Application - Three-tier architecture
Academic Background
2020-05 - 2020-05