Sr. Business Intelligence Architect

Dates 01 October 2010 ? Today
Occupation or position held Sr. Business Intelligence Architect
Name and address of employer LC-Service S.r.l
Via A.Volta, 94, 20033 Desio (MB) (Italy)
Type of business or sector Information and communication

Dates 01/04/2011 ? Today
Occupation or position held Sr. Bussiness Intelligence Architect
Main activities and responsibilities 1. Back End Activities:
a. Analysis to create an enterprise data warehouse: Dimensional Model.

b. Using Erwin for Data Model (Create tables).

c. Create procedures for loading the tables from first level to last level of enterprise data warehouse.


2. Frond End Activities:
a. With Designer 4.0 of SAP Business Objects 4.0 I create universes following the functional and technical specifications.

b. With Web Intelligence (Webi & Rich Client) of SAP Business Objects 4.0, I create various reports for various departments. The complexity of the report depends on the user\'s requests.

c. I use SAP Dashboards Xcelsius 4.0 to create enterprise dashboards.

3. SAP Business Objects 4.0 administrations activities:
a. Safety of park report company: \"Who can do/see what\" (Security Access)

b. Profiling users and users groups: Creating and assigning rights access.

4. knowledge transfer to users: Taining for users, teach users basic knowledge of webi to create reports.

5. Technologies used:
a. Oracle

b. SAP Business Objects Tools: Designer - Desktop Intelligence - Intelligence Web - Web Intelligence Rich Client - SAP Dashboards Xcelsius 4.0.

c. Programming Languages: SQL - PL/Sql
Name and address of client A2A S.p.A.
Corso di Porta Vittoria, 4, 20122 Milano (Italy)
Type of business or sector Electricity, gas, steam and air conditioning supply

Dates 01 October 2010 - 31 March 2011
Occupation or position held Sr. Business Intelligence Architect
Main activities and responsibilities 1. Back End Activities:
a. Analysis to create an enterprise data warehouse: Dimensional Model.

b. With SQL Server Integration Service (SSIS): I Create package for loading various tables at the first level (L0) of the upload process of enterprise data warehouse.

c. With SQL Server Management Studio: I Create procedures for loading the tables to the next level of enterprise data warehouse.


2. Frond End Activities:
a. With Designer XIR3.1 of SAP Business Objects I create universes following the functional and technical specifications.

b. With Web Intelligence (Webi & Rich Client), I create various reports for various departments. The complexity of the report depends on the end user requests.

c. I use SAP Dashboards Xcelsius 2008 to create enterprise dashboards.

3. SAP Business Objects XIR3.1 administration activities:
a. Safety of park report compagny: \"Who can do/see what.\"

b. Profiling user and user groups: Creating and assigning security access level.

4. knowledge transfer to users: Taining for users.

5. Technologies used:
a. MS SQL Server 2008: SQL Server Business Intelligence Development Studio - SQL Server Integration Services - SQL Server Management Studio.

b. Business Objects Tools: Designer - Desktop Intelligence - Intelligence Web - Web Intelligence Rich Client - SAP Dashboards Xcelsius 2008.

c. Programming Languages: SQL - Transact-SQL
Name and address of employer Bayer Italy
Viale Certosa, 130, 20156 Milano (Italy)
Type of business or sector Pharmaceutical

Dates 01 March 2010 - 30 September 2010
Occupation or position held Sr. Business Intelligence Architect
Name and address of employer EXACON S.r.l
Via G. Murat, 60, 20159 Milano (Italia) (Italy)
Type of business or sector Information Technology and communication

Dates 01 March 2010 - 30 September 2010
Occupation or position held Sr. Business Intelligence Architect
Main activities and responsibilities 1. Front-end activities: Creation of the universe according to functional specifications, which will be used to create reports targeted to different departments for analysis.

2. Transformation of MicroStrategy analysis environment to Business Objects universe.
• Analysis of user needs
• Design and creation of universes
• Distribution of universes
• Maintaining universes
• Creating reports

3. Administration Activities in the Business Objects XIR3.1: Installation -Configuration - Update - Security Park Business Intelligence - Profiling the users &groups.

4. Activities of migration from Business Objects 6.5 version to Business Objects XIR3.1 version

5. Training for the use of web intelligence software – desktop intelligence software & Designer intelligence for advanced users.

6. Technologies used:
a. Tools Business Objects (Designer - Desktop Intelligence - Web Intelligence -Web Intelligence Rich Client - Crystal Reports - Business View Manager - Voyager -Central Management Control - Xcelsius - Live Office)
b. Languages: PL / Sql - Sql
c. Data base: Oracle
Name and address of client Fastweb
Viale Fulvio Testi, 280, 20126 Milano (Italy)
Type of business or sector Information and communication

Dates 01 September 2009 - 28 February 2010
Occupation or position held Sr. Business Intelligence Architect
Main activities and responsibilities 1. Front end activities:
a. Analysis of user needs
b. Design and creation of universes
c. Distribution of universes
d. Maintaining universes
e. Creating reports for the departments: Finance - Research - Human Resources -Information Technology

2. Back-end activities:
a. Creating and editing scripts, PL / Sql - Sql for feeding and maintenance of thedatabase.
b. Changing the corporate data warehouse.

3. Training the use of Business Objects software to users.

4. Technology Used:
a. XIR3.1 Tools Business Objects (Designer - Desktop Intelligence - WebIntelligence - Crystal Reports - Business View Manager - Office Live)
b. Languages: PL / Sql - Sql
c. Data base: Oracle
d. ETL: Oracle Warehouse Builder
Name and address of client GlaxoSmithKline
Via A. Fleming, 4, 37135 Verona (Italy)
Type of business or sector Pharmaceutical

Dates 01 March 2009 - 31 July 2009
Occupation or position held Functional Analyst
Main activities and responsibilities Scan for implementation, maintenance and documentation of the management, distribution and detection of gas consumption throughout the Italy country.
Name and address of client ENEL Energia
Viale Italia, 26, 20099 Milano (Italy)
Type of business or sector Electricity, gas, steam and air conditioning supply

Dates 21 February 2007 - 28 February 2009
Occupation or position held Business Intelligence Architect
Name and address of employer Kyros.net BI
Viale Virgilio, 54, 41100 Modena (Italy)
Type of business or sector Information Technology and communication

Dates 21 February 2007 - 28 February 2009
Occupation or position held Business Intelligence Architect
Main activities and responsibilities 1. Front end activities:
a. Analysis of user needs
b. Design and creation of universes
c. Distribution of universes
d. Maintaining universes
e. Creating reports for the departments: Finance - Research - Human Resources -Information Technology

2. Back-end activities:
a. Creating and editing scripts, PL / Sql - Sql for feeding and maintenance of thedatabase.
b. Changing the corporate data warehouse.

3. Training the use of Business Objects software to users.

4. Technology Used:
a. XIR3.1 Tools Business Objects (Designer - Desktop Intelligence - WebIntelligence - Crystal Reports - Business View Manager - Office Live)
b. Languages: PL / Sql - Sql
c. Data base: MS Sql Server
d. ETL: Sql Server Integration Service
Name and address of client Ernst & Young
Via Wittgens, 6, 20123 Milano (Italy)
Type of business or sector Revision of budget and business consulting, financial, fiscal and legal

Dates 21 February 2007 - 28 February 2009
Occupation or position held Business Intelligence Architect
Main activities and responsibilities 1. Front end activities:
a. Analysis of user needs
b. Design and creation of universes
c. Distribution of universes
d. Maintaining universes
e. Creating reports for the departments: Finance - Research - Human Resources -Information Technology

2. Back-end activities:
a. Creating and editing scripts, PL / Sql - Sql for feeding and maintenance of thedatabase.
b. Changing the corporate data warehouse.

3. Training the use of Business Objects software to users.

4. Technology Used:
a. XIR3.1 Tools Business Objects (Designer - Desktop Intelligence - WebIntelligence - Crystal Reports - Business View Manager - Office Live)
b. Languages: PL / Sql - Sql
c. Data base: Oracle
d. ETL: Oracle Warehouse Builder
Name and address of client Loro Piana
Via Per Valduggia, 22, 13011 Borgosesia (VC) (Italy)
Type of business or sector Fashion House

Dates 01 January 2006 - 31 December 2006
Occupation or position held Computer systems designer and analyst
Main activities and responsibilities 1. Maintenance and updating of the information system of the European University Institute.

2. Analysis for the implementation of new systems, project management for building from scratch the web structure of the Institute. In this international context is very important to the knowledge of foreign languages (English and French) to be reliable interface with the Brussels office and effectively mediating between local needs and the need for central entity.

3. Technologies used:
a. Data Base: Oracle
b. Languages: SQL, PL / SQL, Java, JavaScript, DHTML
Name and address of employer European University Institute
Via Dei Rocchettini, 9, 50014 San Domenico di Fiesole (FI) (Italy)
Type of business or sector Education

Dates 01 January 2001 - 31 December 2005
Occupation or position held Computer systems analyst
Main activities and responsibilities 1. Maintenance of corporate web systems (corporate web site, web sites used by Marketing to promote the various products in the medical profession, intranet site for Human Resources Management
of personnel data). Particular attention was placed in this context to the security systems of the high sensitivity of data processed

2. Connected to Data Base Management Systems (update data, cleaning data base, preparation of reports to users and generating statistics)

3. Management of projects relating to the creation of solutions for the needs expressed by business users (in particular (Marketing and Human Resources). The result of such projects has materialized:
- creation of new web site for product promotion and scientific information to doctors
- implementation of a new internet system for the collection of HP and its system
Question for the identification of potential candidates

4. Specialists in the writing of system documentation and user manuals
Name and address of employer Eli Lilly S.p.A.
Via Gramsci, 325, 50019 Sesto Fiorentino (FI) (Italy)
Type of business or sector Pharmaceutical