Dec 2015 – Jul 2018   Parvis SA, Milan       Database Technical Leader (Dec 2015 – Jul 2018)

Main duties:  Data Analysis, data modelling, database administration and development, PLSQL and TSQL on Oracle 11g R2/12c R2 and SQL Server 2008/2012. Migration from 11g to 12c. Integration between Oracle and SQL server using SSIS and integration between databases and all other components of the platform.

Jun 2015 – Oct 2015    Sensei ltd, Milan       Technical coordinator (Jun 2015– Oct 2015)

Main duties:   Analysis, design, database administration and development, PLSQL and TSQL, of a data warehouse migrated from SQL Server to Oracle 11g. Design of new features, loading flows, ETL, and integration with other satellite systems used for reporting.    

 Feb 2005 – Jan 2014   NTT DATA Corporation, Milan

                                      Project Manager – ENI SA (Mar 2013 – Jan 2014)

Main duties:    Team leader of Control Room group; updating and running of DWH concerning weekly and monthly Reports about Control room activities.

                                      Technical coordinator – Pirelli SA (Jun 2011 – Dec 2012)

Main duties:   data analysis, data modelling and design of a data warehouse and of the ETL flows from scratch using Oracle 11g, OBIEE 11g and ODI 11g. Analysis and design of migration of an old BI platform from SQL Server 2000 to Oracle 11g.

                                      Technical coordinator – ENI SA Milan Sep 2009 – May 2011

Main duties:    Coordinating the group of application maintenance and support of two Data Warehouse of employees including data analysis, data modelling for ETL flows and Reporting using Oracle 9i, 11g, Datastage 7.6 and BO 6.1.

                                      Analyst and designer- Deutsche Bank SA Milan (May 2009 – Sep 2009)

 Main duties:   Database architect of a database for the agents of the bank’s branches using Oracle 10g.

                                      Developer – Vodafone SA Milan (Jun 2008 – May 2009)

Main duties:    Maintenance, development PLSQL and support for the migration of some data warehouse from Oracle 9i to Oracle 10g.

                                      Analyst and developer – Enel SA Milan (Apr 2008 – Jun 2008)

Main duties:    Analysis and development of loading flows, ETL, using Datastage 7.5.

                                      Technical Leader – Telecom Italia SA (May 2006 – Apr 2008)

Main duties:   Database architect of a new platform for Workforce Management and integration with external systems. Migration from old databases, MySQL and SQL Server, to Oracle 10g, data modelling for ETL flows between the new platform and the old ones.

                                      Analyst and designer – RCS Group Milan (Jan 2006 – Apr 2006)

Main duties:   Migration a Data warehouse from SQL Server 2000 to Oracle 10g, and Tuning of DWH after migration.

                                      Analyst and developer – Telecom Italia, Venice (Feb 2005 – Jan 2006)         

Main duties:  Maintenance and support on very large database 32Tb data.

Jun 2002 – Jan 2005    SESA SA, Milan

                                      Analyst and developer – FS state railways, Rome (Sep 2004 – Jan 2005)

Main duties:  Implementation of an Asset management software and interfacing with other platforms to load data.

                                       Analyst – Vodafone SA, Milan and Turin (Jan 2004 – Sep 2004)

Main duties:  Charging analysis of new services like UMTS, MMS, Presence, Push To Talk.

                                       Database Administrator – Wind SA, Milan (Feb 2003 – Jan 2004)

Main duties:  Maintenance and support. Migration of Telecom Inventory Management from Cramer 3 to Cramer 4.

                                      Database administrator Oracle – Sirti Sistemi SA Milan (May 2002 – Feb 2003)

Main duties:   Maintenance and support of Oracle databases

Jun 2001 – Apr 2002   HSO Business System Ltd, Milan

Main duties:   Analysis and development of new feature of Baan, ERP, and database Oracle 9i

Oct 1999 – Apr 2001   D&T Ltd

Main duties:   Database administrator on Oracle and Informix databases

1.  Competenze Professionali            

1.1.     Sistemi Operativi

WINDOWS 2000, XP, seven

Sun Solaris

LINUX (Red Hat, SUSE, Fedora)

1.2.     Linguaggi

                                      SQL, SQL*Plus, PL/SQL  

                                      4GL 

                                      SHELL UNIX

4.3.      Strumenti e Tecnologie

ORACLE 8i, 9i, 10g, 11g

MS SQL SERVER 2000/2005

INFORMIX

ACCESS

4.4.      Application Server

ORACLE APPLICATION SERVER 9i

4.5.      Applicativi e Ambienti di Sviluppo

DATASTAGE

ORACLE OBIEE 11g

BUSINESS OBJECTS

DWH REDBRICK

ORACLE DEVELOPER

ORACLE DESIGNER

4.6.      ERP

BAAN, SAP

4.7.      Asset management

USU VALUEMATION

4.8.      Lingue Straniere

Inglese:                        Advanced 

Francese :                     Beginner 

      Studi

–   Laurea in “Ingegneria dei Materiali” conseguita nel 1994

–   Corso di Gestione di Database Oracle frequentato nel 1999 -2000

–   Corso di Gestione di Database Informix frequentato nel 2000 presso Informix Italia

–   Corso sui prodotti DWH Redbrick Informix nel 2000 presso Informix Italia

–   Corso di Amministrazione di Sistema SUN Solaris frequentato nel 2001 presso SUN Italia

–   Corso ERP Baan nel 2001

–   Corso di Asset Management ValueMation frequentato nel 2004 presso USU Spa Germania

–   Certificazione OCA Oracle 9i nel 2005 presso Oracle Italia

–   Corso Project Management nel 2008 presso Emit Feltrinelli Milano

–   Corso SAP FI nel 2008-2009 presso CFP Vigorelli Milano

–   Corso Project Management nel 2010 presso MIP Politecnico di Milano

–   Corso ITIL Foundation V3 nel 2011 presso GKI Roma

–   Corso OBI nel 2011 presso Oracle Italia

–   Corso Oracle Performance Tuning nel 2012 Milano

–   Corso QLIKVIEW nel 2013 Milano

–   Certificazione OCA 11g 2015 presso Oracle/Pearson Vue Italia

–   IELTS British Council nel 2017