Information Technology and Services - Consultant and Contractor

Description

SKILLS

Oracle, Oracle PL/SQL Development, Query Optimization, SQL Tuning, HP Openview, Management Accounting, IT Asset Management, IT Hardware Models, Data Quality, Pension Systems, Italian State structure, Public Sector, Amortization Schedules, Linux, Virtualization, MySQL, MySQL replication, Apache, Microsoft SQL Server, Software Development, Disaster Recovery, Business Objects, JavaScript, HTML, CSS, Joomla, WordPress, PHP, Business Intelligence, SQL, Database, PL/SQL, Sviluppo di software, Server Microsoft SQL, book self publishing, DPA Data Protection Advisor, HP DDMI, C, Delphi, VBScript, VBA, Microsoft Access, Microsoft Excel, QlikSense, Irion EDM, Axway XRDJ, IBI WebFocus

Main Skills

Other Skills

Solaris

Debian

AutoCad

databases

Microsoft Access

UML

Microsoft SQL

Unix

database engine

Data Centers

Solaris operating system

firewalls

CSS

Database

Query Optimization

C

HP Openview

VBA

bash

VBasic

backup procedures

Javascript

Software Development

QlikSense

Information Systems

Data Layer

MS SQL Server

PHP

servers

ETL

database applications

Windows

MySQL

Disaster Recovery

SAP R/3

user documentation

SQL injection

SQL Server

C#

Access

metadata management

Excel

awk

VMware

Virtualization

Oracle

APIs

Apache

network appliances

data analysis

Informix

Windows NT

software applications

desktop virtualization

PL/SQL

routing

Microsoft Office

VB Script

data mining

data warehousing

SQL

Linux

Microsoft Excel

ksh

test automation

Cognos

Crystal Reports

debugging

Unix shell scripts

Agile methodologies

proxies

programming

MS Windows

nmap

SAP BO

JScript

data warehouse

SQL Tuning

MS Access

Microsoft Visual Studio

accounting system

Microsoft SQL Server

Borland Delphi

Oracle PL/SQL

Ubuntu

Wordpress

Application Management

continuous integration

ETL process

NetApp

EMC Legato Networker

Relational Model

pair programming

VBScript

OnCommand

MySql databases

Joomla

Software maintenance

Oracle SQL

Delphi

stored procedures

Business Objects

HTML

Work & Experience

01.12.2015 — Now

Dexia Crediop Bank

* Project Manager for the Data Quality. * Reorganization of full documentation of the input sources or the data warehouse regarding the financial activities (Loans, Bonds, Securities, Repos, Derivatives, Collaterals, Options, Deposits). * Market analysis of metadata management tools (Irion Edm, Oracle Enterprise Metadata Management, SAP BO Information Steward). * Analysis and development of a solution based on Irion Edm for the Data Quality project. * Application Management in debugging and new developments using IBI WebFocus, migrating from Axway XRDJ Accounting Integration Suite.

01.10.2010 — 30.04.2014

Centro Mariapoli Internazionale

* Analysis of the business requirements and design of the Relational Model and of the Data Layer. * Planning and implementation of front end and back end MySql databases with data replication. * Supervision of the work of the C# programmers.

01.12.2004 — 31.10.2015

INPS

* Optimization of queries and reports (pension payments database: 2.5 million records monthly for the past 10 years; public employees contributions database: 3.5 million record monthly for the past 7 years). * Design of the data warehouse (Relational Model and the Data Layer). * Production of ETL software applications that automate import and check loading of external data into the data warehouse. * Production of reports (functional analysis of the business requirements, design and optimization of queries for the Business Objects universes) on pension expense growth, on collected contributions to the pension plans, on welfare programs, on loans and mortgages delivered to public employees.

01.01.2004 — 30.11.2004

ICCRS (International Catholic Charismatic Renewal Services)

* Developed interactive database (MS Access) of management of conventions and congresses for this non profit organization. The program offers complete delegate registration, arrivals check-in and check-out, logistical management of groups, translation services, shuttles to hotels, accommodations organization, billing, and payment registration.

01.02.2002 — 31.12.2002

Ministry of the Treasury, Italian Govt.

Analyst Consultant

* Regular meetings with representatives of the Treasury Ministry for system review. * Analysis of the maintenance and enhancement requests for the payroll system. * Produced documentation of the software requirements specifications. * Supervised the work of the programmers and provided final testing and certification of software.

01.03.2001 — 30.06.2015

Telecom Italia IT

* Assist in the organization and management of the Technological Assets' database, tracking more than 170,000 computers, storage, and network appliances in the company internet data centers' inventory. * Produce and maintain PL/SQL scripts and queries on the Oracle database for the cost accounting department. * Manage or participate in several integration projects, all well completed, with the databases of the company's other applications: with the db of maintenance contracts, with the db of Archibus system of Data Centers' AutoCad maps, with the VMware systems of farms of virtualizers, with the db of EMC Legato Networker backup definitions, with the db of EMC Data Protection Advisor backup logs, with the db of HP DDMI automatic discovery of servers' configurations, with the db of NetApp OnCommand Insight storage monitoring tools, with the db of Control Room management tools, with the db of the software licenses, and with the db of the colocation customers' physical and virtual assets. * Create optimized Oracle SQL views and PL/SQL packages for feeding the ETL process to the Oracle Warehouse OWB. * Produce conversion scripts and provided data summary reports to management during the migration phase to the HP Peregrine-based asset management system. * Produce software programs for data entry and on-site data quality verification. * Produce catalogue of the models of the assets, structuring them by macro categories and organizing the research of the specification data on the websites of the manufacturers and maintenance service companies. * Provide 2nd level assistance to end users. * Supervise a team of five full-time employees, in Rome and Milan, for registering and maintaining technical and accounting information.

01.04.2000 — 31.03.2001

See America Travel, Inc.

* Software maintenance of custom CRM system for the travel agency.

01.05.1994 — 31.05.1998

CEIA Spa (Costruzioni Elettroniche Industriali Automatismi)

* Installed and administered the mixed Unix - Windows NT LAN in this manufacturing company in the field of security systems. Administrator for the Unix/Informix database for the accounting system. Implemented the change to the SAP R/3 based on NT/Oracle with analysis of the ERP and warehouse management functionalities. * Responsible for installation and administration of PCs in the offices and production departments, and of the Sun workstations with Solaris operating system, and of the Silicon Graphics workstations in the labs. * Organizational analysis of electro-mechanical production businesses. Provided technical review and reporting evaluations of IT market. * Participated in data warehousing and data mining projects using SQL Server as database engine and Microsoft Office (Excel, Access) for business report generation, developing ad hoc VBA functions.

ZEITLICHE UND RÄUMLICHE

SONSTIGE ANGABEN

ZEITLICHE UND RÄUMLICHE VERFÜGBARKEIT Fulltime or partime SONSTIGE ANGABEN I am a Computer and Information Systems Consultant with extensive professional experience as a Programmer Analyst, Business Intelligence Analyst and Database Specialist. As a Programmer Analyst, I worked through all phases of the cycle of software development. In my career I wrote various software in the domains of IT Asset Management, Accounting, Warehouse systems, Cost Accounting, Italian public sector Pension system, Italian State structure, Loan and Mortgage plans, Payroll, ERP and CRM for a wide range of businesses including banking, government service, telecommunication, electro-mechanical production, tourism, and non profit services. Keywords: C, Borland Delphi, Javascript, Microsoft Visual Studio VBasic and C#, SQL, PL/SQL, Microsoft ADO APIs, VBA, VBScript, JScript, HTML, CSS. I'm expert in analysis of software requirements and design specifications for business operations. I do data and process modelling with UML and use case requirements engineering. I have long experience with Database Modeling, in attribute collection and in normalization. I have experience in continuous integration, test automation, quality control, and assurance. I do both architectural design, using the entity-relationships model, and physical layer design. I worked on extensive systems' integration projects and I have experience using Test-driven and Agile methodologies (pair programming). I have long experience in production of technical and user documentation. I worked with MS Windows, Solaris, Unix and various Linux platforms. I'm expert in Unix shell scripts languages (ksh, bash) and with tools such as vi and awk, and I have full familiarity with Internet/intranet architecture, IP family protocols, routing, proxies, and firewalls. I have experience in security issues (SQL injection, usage of MBSA and nmap), in setup of backup procedures, in server and desktop virtualization, and in moving from Windows to Linux (Debian and Ubuntu). As a Business Intelligence Analyst and Database Specialist (Oracle and MySQL), I have long experience in data analysis and crunching, from just cleaning Excel files (identifying duplicates, combining and/or splitting data to follow company standards, spot-checking work for accuracy, removing unwanted characters and formats), up to designing and implementing data warehouses for building historical trends and finding correlations. I have full knowledge about design and development of databases, and long experience in database applications. I'm expert in optimization and tuning of queries in large scale databases and in advanced Oracle PL/SQL packages programming as stored procedures and triggers. I have experience with high-volume bulk data processing in PL/SQL: for INPS, the largest social security and welfare institute in Italy, I was able to reduce the running time of the monthly ETL process for the Public Sector Pension payments from a few days down to few hours. I have also experience with MS Access, Crystal Reports, Business Objects XI, MS SQL Server, QlikSense, Irion EDM, Axway XRDJ, IBI WebFocus.