Remo Ponzo

PERSONAL DETAILS

Name: Remo PONZO
Place and Date of birth: Naples, 12.04.1979
Nationality: Italian
E-mail: ponzo.remo@tiscali.it
Linkedin URL: it.linkedin.com/pub/remo-ponzo/5/950/68
Today’s position: Full time Notice ~ 3 months

QUALIFICATION

Operating System: Windows XP Pro SP3, Unix
Languages: Sql, Pl/Sql, Cobol
RDBMS: Oracle 8i,9i,10g – Access 2003, DB2, Sql Server 2000 V.8, Sql Server 2005 V.9, Teradata V.12

Business Intelligence Tools: Harry V.6.4, Business Object 6.5, MS Reporting Services 2005
Olap: MS Analysis Service 2005
Data Modelling: CA Erwin
ETL: Oracle Warehouse Builder 9.2, 10/R3, Data Stage, Oracle Data Integrator
Others: Pvcs, Putty, CA Harvest, Avaloq Ice, Avaloq Client, Avaloq Banking system script, Tivoli Client, MS Visual SourceSafe

EDUCATION

School: I.T.I.S. “A.Pacinotti” in Scafati (SA)
Titolo: Diploma in Electronics and telecommunication (42/60)
University: Student in Economy and Commerce

Date (from – until): September 2010 / October 2010

Company: B-Source
Role: Consultant for Mac Solutions
Tasks: Course for platform below:

  • Avaloq Banking System Script
  • Avaloq Ice
  • Avaloq Client

Date (from – until): June 2005 / July 2005
Name and tasks: SAP training course – NetWeaver form oriented – specifically Exchange Infrastructure Integration Technology.

Date (from – until): August 2002/ September 2002
Name and tasks: Course on platform Business Objects making use of modules below:

  • InfoView
  • Supervisor
  • Designer
  • Business Objects

I implemented an internal application using the suite Business Objects on database SQL Server 2000, integrated with excel template, for production and analysis of data administrative reports.

Date (from – until): December 2001 / February 2002
Name and tasks: Introduction and planning of Data warehouse Course for Siemens Informatics in Rome.

Date (from – until): February 2001 / July 2001
Name and tasks: Stage about modules below :

  • EDP Introduction
  • Structured programming technique
  • Introduction at data base and relational theory
  • SQL
  • Windows NT
  • UNIX
  • COBOL
  • DB2

Date (from – until): November 2009 / Today
Company: Mac Solutions
Role: Analyst for B-Source / BSI (Banca Svizzera italiana)

Main duties: Analyst for maintenance and development of Staging Area in B-Source SA.
In particular, analysis, development, maintenance about Avaloq Data Extractions and ETL jobs / processes with Oracle Odi platform, in order to load data from Avaloq Banking system to Oracle DB instance for “Sas reading” phase. I’ve managed all software release phases regarding Avaloq Extractions implementation, creating new “Jar” files in order to implement Oracle DB instance and ODI sceneries (xml file) for ETL processes.

Everything using the following products:

  • MS Visual SoruceSafe
  • Avaloq Scripts
  • Avaloq Ice
  • CA Harvest
  • Oracle Data Integrator
  • Unix
  • Oracle RDBMS

Date (from – until): January 2009 / October 2009
Company: C.S.W. s.r.l – Informatica
Role: Analyst for ElsagDatamat / Poste Italiane
Main duties: Analyst for maintenance and development of Data Warehouse in Poste Italiane.
In particular, analysis of user requirements, development, maintenance of OLAP cubes on Teradata platform / MS Analysis Service 2005 and reports with MS Reporting Services 2005 regarding KPI of Poste Italiane and consequential user testing.
The elaborated software is equipes of following documentation :

  • Technical Specificatons
  • Installation manual
  • User manual
  • Testing Plan

Everything using the following tools :

  • MS Visual SoruceSafe
  • CA Erwin v.7
  • Teradata v.12
  • MS Analysis Service 2005 SP3
  • MS Reporting Services 2005 SP3

Date (from – until): September 2008 / January 2009
Company: C.S.W. s.r.l – Informatics
Role: Analyst for ElsagDatamat / Oracle Italia / Telecom Italia
Main duties: Analyst for maintenance and development of Data Warehouse DWHC / DMC in Telecom Italia .
The activity concern, in co-operation with Factory Telecom in Bari, the delivery, with consequential acquirement of Know-how on DWHC, between Oracle Italia and ElsagDatamat.
In particular, I was involved in user requirements analysis, in the setup, the maintenance and development on Oracle Warehouse Builder 9.2 platform, of admission flows coming from different sources fueling systems, with consequential realization and implementation of “Mapping” for the acquisition of them.
The generated software shell, ddl, sql, ctl, mdl , pls, xls, doc are then installed on Hp-UX platform.
Using PVCS software for versioning Software.

Everything using the following tools:

  • Oracle Warehouse Builder Client 9.2
  • Oracle Warehouse Flow Monitor 2.6.3
  • Hp-UX
  • PVCS 4.8
  • Toad 9.0
  • Business Object 6.5

Date (from – until): October 2007 / June 2008
Company: C.S.W. s.r.l – Informatics
Role: Analyst for Aubay Research / Hpdcs
Main duties: Analyst for re-engineering of Data Warehouse activity, attendant at activities of SLA (Services Level Agreement) and KPI (Key Performance Indicators) for final guest Hp-dcs.
The activity covered the requirement user analysis,the Oracle Warehouse Builder10g platform installation on networks as Windows Server 2003 and Hp-UX. Also the optimization of admission flows with consequential actualization of “Mapping”. These assumed, from different sources fueling systems as Remedy, Avaya and others, information to be reported on their relatives ambient (backdrops) of Data Warehouse (Staging, Ods, DataMart).

Everything using the following tools:

  • Oracle Warehouse Builder Client 10.2.0.3
  • Oracle Warehouse Flow Monitor 2.6.4.
  • Hp-UX
  • Toad
  • Business Object 6.5

Date (from – until): December 2006 / June 2007
Company: Scientia Consulting s.r.l. – Informatics
Role: Analyst for Eustema / HP Italia /SKY Italia
Main duties: Analyst in HP Italia (Hewlett-Packard Italia) for the activity of development and maintenance of “Mapping” and “WorkFlow” relatives at data mining (ETL jobs) coming from Siebel system. These for population and implementation of Staging – ODS – DDS instance and relatives Enterprice Data Warehouse Datamarts. All for SLA (Services Level Agreement) and KPI (Key Performance Indicators) activities of final Guest Sky Italia.

Everything using the following tools:

  • Oracle Warehouse Builder Client 9i
  • Oracle Warehouse Flow Monitor 9i
  • Toad
  • Business Object 6.0

This activity involved me also in “Business Intelligence Project Implementation” project, that means update of Geografic KPI for development and maintenance of “Prospect DM” (Geo-Marketing) reports.

Everything using the following tools :

  • Oracle Warehouse Builder Client 9i
  • Oracle Warehouse Flow Monitor 9i
  • Toad
  • Business Object 6.0

Date (from – until): October 2006 / December 2006
Company: Quality for Technology S.p.A. – Informatics
Role: Analyst / Programmer
Main duties: International credit management project, through the reports development, cubes and WEB applications, using Harry software BI Suite.

Date (from – until): January 2006 / October 2006
Company: Bas S.r.l – Informatics
Role: Analyst for OpenSystem / Gruppo Generali Servizi
Main duties: Analyst – Programmer to implement technological infrastructures for SAIL (Data Warehouse Sinistri -VITA) project, developing related “Mapping”, these to migrate and reworking data, coming from Legacy (DB2) systems, to Staging Area, ODS and DDS and to the second level of del Data Warehouse SAIL. This activity was also oriented to making objects and entiies (Fact Table e Dimension Table, indexes,etc…) on new and old Datamart.

Everything using the following tools:

  1. Oracle Warehouse Builder Client 10g
  2. Oracle Warehouse Builder Designer 10g
  3. Toad

In the same time I had the role of Analyst – Programmer for Data modelling of Data Warehouse (Sinistri-RCA) activity, using the following tools:

  • CA – Erwin

Documenting also the data models (file.ER1) on a Staging – ODS – DDS instances and of first level (Datamart) of Data Warehouse Sinistri-RCA.
The activity was oriented to make also “DDL”(Script SQL) to afford at DBA Oracle for physical creation of objects (Table, view, index, pk, fk…) on Oracle instances.

Objects already exsistent on Legacy (DB2) systems to migrate or create on Oracle 10g platform.

Date (from – until): October 2004 / June 2005
Company: Quality for Technology S.p.A.
Role: Analyst for Gepin / Poste Italiane
Main duties: Analyst /Programmer / Tutor for Enterprise Data Warehouse and 6 DataMart theme realization, to make Informative Corporate Area of Poste Italiane for KPI (Key Performance Indicators) activity.

The project was integrated by LDAP system of Poste Italiane, using authentication mechanisms given from LDAP, and implementing the authorization processes and profiling through the Harry Software repository. This supplementation made Poste’s users able to access to the reporting through administration of synchronization processes with LDAP technology, to insert – modify – cancel Guest profiles.

Everything has been conduct through the Harry Software platform; its modules:

  • HarryPilot V 6.4
  • HarryBuilder V 6.4
  • HarryNetServer V 6.4
  • HarryCube V 6.4
  • HarryManager V 6.4

Professional services development of 700 reports articulated as below:

  • 200 Report Standard
  • 250 Report Olap Base
  • 250 Report Olap Avanzati

Professional services development of 600 fllows to be downloaded, through ETL tools, in Base Informativa, in Enterprice Data Warehouse and in 6 DataMart.

Receivers of EDW : Poste’s offices all over Italy.

Operation System : Windows Server 2003, Windows XP, Windows XP Pro, Windows 2000 Pro
RDBMS : SQL Server 2000 Vers. 8
Extraction-Trasformation-Loading Tool : DataStage

Date (from – until): May 2004 / October 2004
Company: Quality for Technology S.p.A. – Informatics
Role: Analyst / Programmer (Pre – Sales)
Main duties: Search / Development /Sales of Business Intelligence Harry Software product.

Date (from – until): April 2004 / May 2004
Company: Quality for Technology S.p.A. – Informatics
Role: Tutor at ANCI (Associazione Nazionale Comuni Italiani)
Main duties: I taught in training courses for ECDL European computer licence, on the following modules :

  • Windows 98
  • Windows 2000
  • Internet
  • Word 97/2000
  • Excel 97/2000
  • Access 97/2000
  • Power Point 97/2000
  • Outlook Express

Date (from – until): February 2003 / March 2004
Company: Quality for Technology S.p.A. – Informatics
Role: Analyst for HP Italia / H3G Italia
Main duties: Consultant / Tutor for realization and administration of Enterprice Data Warehouse on SLA (Services Level Agreement) and KPI (Key Performance Indicators) activities.

The project was oriented to integrate an user authentication system, through LDAP system, in order to insert – modify – cancel access reports profiles. This profiles was defined and managed through the creation of a specific repositories.

All on Business Objects platform; its modules:

  1. Business Objects
  2. Designer
  3. Supervisor
  4. InfoView

Professional services development of 550 reports articulated as below:

  • 200 Report Standard per l’attività di SLA
  • 350 Report Standard per l’attività di KPI

Professional services development of 450 fllows to be downloaded, through ETL tools, in Enterprice Data Warehouse.

Receivers of EDW : H3G Business Units in Rome

Operation System : Unix
RDBMS : Oracle 8i
Extraction-Trasformation-Loading Tool : DataStage

Date (from – until): March 2002 / July 2002
Company: Quality for Technology S.p.A. – Informatics
Role: Tutor for Corpo Forestale dello Stato
Main duties: Teaching for ECDL.

I taught in training courses for the products below:

  • Windows 98
  • Windows 2000
  • Internet
  • Word 97/2000
  • Excel 97/2000
  • Access 97/2000
  • Power Point 97/2000
  • Outlook Express

Date (from – until): December 2001 / February 2002
Company: Quality for Technology S.p.A. – Informatics
Role: Programmer for Recall S.r.l.
Main duties: Analysis and implementation of relational Data Base (Microsoft Access) with Excel files, useful to manage, through the WEB, data from the final user.

Date (from – until): July 2001 / Novembre 2001
Company: Quality for Technology S.p.A. – Informatics
Role: Programmer for Wind Spa
Main duties: Realization of DSS proptotype, using Harry Software suite on database SQL Server 2000, for analysis and production of reports regarding invoicing.

LANGUAGES

Mother language: Italian
Other Languages: English

  • Reading: Intermediate
  • Writing: Intermediate
  • Speaking: Intermediate

Summary and Key Skills: I am confident and excellent communicator, reliable, resourceful and problem-solving oriented.
Other relevant information: I am available to move all over Italy/Switzerland or abroad for a fixed period

Driving Licence: Licences A and B

Remo PONZO