(09/2014 – today)  [BI/DWH analyst &developer in Techedge s.p.a.]

Attended in projects of Analysis and Development Oracle DWH, in particular:

–       DWHDeveloperfor FCA Bank (February 2017 – today): definition of Data Model of ODS and Data Marts for contracts reporting. Development of ETL flows of Staging Area with SAP Data Services.

(Jun-Jul 2016)  Attended in projects of Essbase flow analysis, in particular:

–       BI Analyst for FCA group: analysis of the process for developing an Essbase application for calculation of True Up and adjustment of consolidated data for Operational Transfer Price.

(Sep 2016 – Jan 2017)  Attended in projects of Analysis and Development of OBIEE 11g Dashboards, in particular:

–       Consultant for LoroPiana Textile: development of metadata repository and several dashboard for reporting of Invoices and Orders Portfolio.

(Jan 2016 – today) –       Consultant for Zegna: development of several dashboards and reports for salesand ticket traking.

(Apr 2016) –       Consultant for FCA group:Modeling of schema and tables for Mapping Output reporting of SAP and HFM consolidating data.

(Jul-Dec 2015) 

–       Consultant for Pirelli: implementation and development of the model for reporting of HR analysis.

Development of several dashboards andreports for Headcount, Labour Costs and Turnoveranalysis.

(Jul 2015) –       Consultant for Safilo: analysis and development of two dashboards for tracking sales by dimensions, interfaced on an Oracle DB Source.

(May – Jul 2015) –       Consultant for FCA group: implementation and development of the OBIEE model and dashboard reports for monitoring invoices by accounts, interfacing OBIEE on an integrated HFM cube and FDMEE data source.

(Jan- May 2015) –       Consultant for Pirelli: implementation and development of the OBIEE modelfor reporting of Management Plan Consumer and Industrial.Development and modify of several dashboard report for sellout and stock analysis.

(Sep- Oct 2014) –       Consultant for CNH(FCA group):implementation and development of dashboards reports for financial analysis and provisioninginterfaced on Hyperion Essbase Source.

(Oct-Dec 2014) (Oct 2014 – today) –       Consultant for Safilo: analysis and development of several dashboards for tracking sales by dimensions. Application Management Service of dashboards and users security].

(Nov 2013 –June 2014) [Teacher of Mathematics and Science in middle school “I.C. L. Da Vinci” in CesanoBoscone (Italy).]

(Apr 2011 –Oct 2013) [Analyst and developer in MediamenteConsulting s.r.l. in projects of Data Warehouse and Business Intelligence]

(Sep 2011 – Feb 2012) 

Attended in several projects of implementation, analysis and development of systems integration with ODI (Oracle Data Integrator) 10g and 11g as well as PL / SQL procedures, in particular:

–       Consultant for hospital project: Implementation, development and monitoring of loading flows with ODI 11g tool with external file surces (as .csv and .xlsformat) for monitoring of the time of the surgical steps.

(Feb 2012)  –       Consultant for Safilo: Development of loading flows with PL/SQL procedures for data integration on DWH.

(March 2012) –       Consultant for Geox: Implementation and monitoring of loading flows for data integration between ERP ( AS400 ) and E – commerce site with Oracle Data Integrator 10g .

(Jan– May 2012)  –       Consultant for Moby/Toremar: Implementation, development and monitoring of loading flows for the integration of information systems of Moby and Toremarcompanies and the variousticket offices;use of loading flows with Oracle Data Integrator 11g and PL/SQL procedures, of medium- high complexity; management of racing vessels.

–       development and management of loading flows for the integration of information systems between Moby company and its various ticket offices, from data sources of various kind (.xls and .txt files, Oracle DB, etc. ) using loading flows of Oracle Data Integrator 11g and PL/SQL procedures, of medium-high complexity;

–       Creation of a data mart for reporting in OBIEE, aimed at the management of logistical and administrative data;

–       Creation and development of severalAPEX web application for administrative monitoring of the budget. 

(Feb – Oct 2013) 

Attended in several projects of implementation,analysis and development of OBIEE 11g Dashboards, in particular:

–       Consultant for Pia Fondazione Panico: implementation and development of a prototype of a dashboard for monitoring hospital data

(Apr 2011 – Aug 2011)        Consultantfor Strategy2: development of a dashboard with KPI and other tools for Financial and economic analysis.

(Jun 2011 Aug 2011)-       Consultant for hospital project: analysis, implementation and developmentof OBIEE repository for monitoring surgical step timeof medium-high complexity, as well as relative dashboards, integrated with KPI.

(Sep 2011 – Feb 2012) –       Consultant for Puma: development and modify of report for monitoring of invoices and sales.

(Mar 2012 – Aug 2012)-       Consultant for Intesa Sanpaolo: implementation and development of the OBIEE repository and development of relative reportsand KPI for monitoring Commercial and International Banking.

(Jul 2012 – Dec 2012)  –       Consultant for Menarini Industrie Farmaceutiche Riunite S.r.l. 

(May – October 2013):Migration and revisiting business intelligence applications interfaced either on Oracle DB and on OLAP data source systems, as well as from xls and .csv files. even with the use of utilities such as Smart View OBIEE and Oracle BI Mobile.

EDUCATION AND TRAINING

(01/2015) Certificated Oracle Business Intelligence Foundation 11gImplementation Specialist

(2011- 2013)Attended at several Oracle Workshops regarding new developments of di Oracle BI, Exadataand Exalytics.

(06/2010 – 03/2011) [Specialization course on “WEB CONTENT MANAGER”, with Java/J2EE, LIFERAY, ALFRESCO technologies and stage in QBR-Team]

(2007-2010) [Italian degree similar to a Master's Degree in Mathematics at University of Salento magna cum laude and thesis in differential geometry titled “Problems on reconstruction of tournaments”]

(09/2009 – 11/2009) [Teacher assistant at High School “Q.Ennio” in Gallipoli (Italy)]

(2002-2007) [Italian degree similar to a bachelor's degree in Mathematics and thesis titled: “NUMERICS METHODS FOR NON-LINEAR LEAST SQUARES METHOD”]

(1999-2002) [High school leaving qualification in scientific studies at Naval School  “Francesco Morosini” in Venice]

 (11/2010 – 12/2010) [Stagist for QBR-Team in Milan (Italy),engaged for the development of a Java Web Application on Liferay platform.]

(12/2009 – 07/2010) [Collaboration with the teacher association “LiceoDocet” providing tutoring and after-school classes in the afternoon.]

[Provision of Mathematics private lessons at Medium and High School students, as well as University students.]

SKILLS

MOTHER TONGUE [Italian]

OTHER LANGUAGE  [English]

COMPUTER  SKILLS AND COMPETENCES

O.S.Windows and Linux.

Data Warehousing tools:

–       Oracle DB (11g, 12c);

–       DB access tools: SQLPlus, Toad, SqlDeveloperand Data Modeler;

–       Essbase access tool: Smart View

–       ETL tools: Oracle Data Integrator (release 10g, 11g);

–       BI tools: Oracle Business Intelligence EE 10g, 11g e 12c.

–       Good knowledge of SQL e PL/SQL.

–       Good knowledge of APEX web application.

Basic knowledge of other languages (Java, C, C++, Mathematica, Matlab).

Microsoft Office packages

Basic knowledge of Liferayand Alfresco platforms.