Implementation of a new EDW: over 2TB of compressed data collected in 3 years serve more than 200 Webi reports useful to main central departments (Marketing dept., Credit dept., Product dept., etc.) and around 1000 branches, automatizing previously hands made reporting.Made key data available on daily base from monthly base.Defined standards of development for ETL, Database, Master Data Management and DataQuality.Design of the scheduling model (ETL Jobs, database maintenance utilities and backups) of thecurrent 24x7 online reporting system.Planning and organization of UAT.Design and development of mission critical tasks like user data profiling and Credit Management reports and dashboards.Strong effort in DB2 database maintenance, tuning of report queries and ETL improvements.Technologies: IBM Infosphere Balanced Warehouse 9.5, IBM Datastage 8.1, Erwin DataModeler, Business Objects XI 3.1, Linux Suse Server 10, Oracle 10g, shell scripting, Java.

Migration of ETL critical loading processes of EBCDIC files (from z/OS environment)from Microsoft SSIS to IBM Datastage to improve performances. Made data loads efficient fromDatastage ETL on Aix server toward Sql Server 2005 by reading source files directly on z/OS viaNFS, moving the transformed data via FTP to the database server and bulk loading.Part of the Italian-German team that studied how to migrate toward the German Zeb ControlCost Management System. 3+ months of international meetings. Realization of gap analysisand definition of business requirements that lead to a partnership between Cedacri and ZebControl.Technologies: IBM Datastage 8.0, Unix Aix, Sql Server 2005, T-SQL, Oracle 10g, Pentaho DI.

Improvement of existing algorithms (statistics built with BTEQ Scripts and DatastageETLs) of customer segmentation, evaluation of financial promoters and product distribution.Analysis and design of a new algorithm of measurement of the existing Remote Bankingstructure detailed for each channel: Phone Banking, Home Banking, Mobile Banking, etc. forMarketing dept..Analysis and design of a new algorithm of asset segmentation based on duration, liquidity, risk,etc. for Financial Auditing dept..Design and development of a web application to handle the BTEQ Sql Scripts MetadataRepository and automate deployments.Technologies: Ascential Datastage 7.5, Teradata 12, BTEQ Scripting, Multiload and TPump,Erwin Data Modeler, Asp, Javascript.

Maintenance of an Oracle data warehouse and related ETL loading procedures. Analysis and design of a datamart and Business Objects reports to monitor free market of energy.Technologies: Ascential Datastage 7.5, Oracle 9i, Business Objects

Maintenance and improvement of a Visual Basic 6 application based on Oracle 9i database.Technologies: Visual Basic 6, Oracle 9i

Management and improvement of a web platform of energy production programming.Successful integration of the current web platform with TIBCO. Development of an Access database with forms able to simulate remote XMLHTTP calls for tests.Technologies: ASP 3.0, Javascript, Oracle 9i, PL/SQL, XML, XMLHTTP, Access, VBA

Creation of an Access database to store data regarding listed companies in Italy with the support of CONSOB.Creation of forms to edit, import and export data. Realization of reports to show the financial, structural and economic situation of the companies and its relations.Technologies: MS Access, MS Excel, ASP 3.0, Javascript.

Editing and format of lesson texts and documents.Students and tutors technical support.Technologies: Microsoft Word, Internet

Shoot Boxe and free fight trainer.Ju Jitsu instructor for childs 4+ years.Ju Jitsu instructor for adults 15+ years.The courses of Ju Jitsu are intended of "Octopus Ju Jitus", a modern concept of Ju Jitsu from Akiyama Gym Livorno.