Francesco - Développeur BUSINESS OBJECTS
Ref : 091228R001-
6567 MERBES SAINTE MARIE (Belgique)
-
Consultant, Développeur, Business Analyst (53 ans)
-
Freelance
1)Freelance Senior Analyst and Developer BI at La Poste
June 2009 - Present (7 months)
I'm the Data Services architect, technical analyst and developer for the CDW Project.
CDW is the Corporate Data WareHouse of 'La Poste'.
I take part with the functional analyst and the team in the technical analysis of the business
requirements. I take part to the development of the CDW with Data Services.
* Employee’s Roles & Responsibilities in the project:
o Architect Data Services
o Technical analysis,
o Development of DWH with Data Services of
BusinessObject.
* Tools used :
o Data Services of BusinessObject
o PL/SQL
o PowerDesigner : Data Model
o Toad : Database Management
2)Senior Analyst and Developer BI at European Commission
October 2007 - June 2009 (1 year 9 months)
I was the functional analyst, the technical analyst, the developer and the release coordinator for the
project EDW.
EDW is the DG-Entreprise(European Commission) Data WareHouse (Human Resources, Financial
Accounting, Internal Audits, Legal Commitments)
I taked part with the PM in the analysis and the modelling of the business requirements. Then, I
created the tables and the ETL. To finish, I developed the universes and the reports intended for
the business.
* Employee’s Roles & Responsibilities in the project:
o Functional and technical analysis,
o Business Objects Supervising, Designing and Reporting in
eache environement.
o DataBase modeling and creation.
o Development of DWH with Data Integrator of
BusinessObject.
o Creation of the documentation (Release coordination,
change document,…)
* Tools used :
o Data Integrator of BusinessObject
o PL/SQL
o Reporter, Webi, BCA, Supervisor,...of BusinessObjects
o PowerDesigner : Data Model
o Toad : Database Management+
3)Senior Software Engineer at La Poste
April 2007 - October 2007 (7 months)
BPM (Branch Profitability Model) is an application which is used to calculate the income and the
cost of each Post Office. The application is a Web Interface written in Java and BusinessObjects,
used for the reporting.
NTP is an application for the reporting of activities for all Post Offices.
I was the technical analyst for these existing projects.
My initial task was to resolve Hot Fixing. I was responsible for the evolution of the applications. I
developed in Java (Eclipse) for the interface evolution and I used for the mapping the oracle ETL :
Oracle Warehouse Builder.
Moreover I maintained the universe and the reports (BO 6i).
* Technologies and methodologies used in the
BPM project:
o Sybase Power Designer : Data Modelling
o Oracle Warehouse Builder :ETL tools
o Java : Web Interface
o BusinessObjects 6i : for the reporting
o Oracle and Toad
o Subversion
Specific tool in project NTP :
o SAS : Extract the data and load in the reporting schema
4)Technical Analyst at ING Bank
January 2005 - April 2007 (2 years 4 months)
- Tarification project : the system consisted of two modules:
o A batch used to calculate the commissions on the
accounts, the cards and the interests (replacement of
the existing batch written in COBOL).
o A Web Interface for the branches for marketing purposes.
* Employee’s Roles & Responsibilities in the project:
o Technical Analysis, development
o Database administration.
* Technologies and methodologies in the project:
o Java (WSAD, WeBSphere)
o XML/XSL
o Oracle (Oracle Designer, TOAD)
o MQseries
o CASTOR
o PVCS
o UML2
o Unix Solaris on Sun Sever (Script configuation
5)System Analyst at ING Bank
June 2002 - January 2005 (2 years 8 months)
- BusinessObjects Competence Center : June 2002 - January 2005
Development of the Business Objects Infrastructure for ING
Belgium. Development of the application in all areas of the
BusinessObjects environment.
* Employee’s Roles & Responsibilities in the project:
o General Supervisor within a team of three developers
o Development of application and solution of Business
Intelligence.
I was part of a team of three people which had the role of
developing Business Objects for ING. As General
Supervisor, I configured the various domains, users’
profile, methodology, and the standards for BusinessOject.
The team configured the WebI server in the various
Businesses Units (Holland, Spain, Luxemburg,... )
Moreover I developed in Visual BASIC tools to facilitate
the maintenance of BO :
o tool of versioning in production
o tool for standardization of the universes and the
reports names.
o tool for localization of the universes and the reports.
Application Developer at ING Bank
6)June 2000 - June 2002 (2 years 1 month)
AMI : Application development which enables the branches to report the profitability of their
business. The interface was written in Visual Basic. The exchange between the server and the
client was in XML/XSL files. The servers were written in COBOL and Algol on a Unisys Mainframe.
The User Manual and the settings were also produced by me.
The interface is written in Visual BASIC. The messages generated by the application were in
XML/XSL. These messages were sent towards servers applications written in COBOL, Algol on a
Mainframe A-Series of Unisys.I created the user's manual and I instanced the versioning
in production. Moreover, I was responsible to maintain the following:
o the BBL reporting tool written in ALGOL and COBOL
o An interface customer for the Heads written in NatStar.
o A tool for file conversion written into Visual BASIC.
* Technologies and methodologies:
o COBOL
o ALGOL
o VB
o NATSTAR
o XML/XSL
o Mainframe Unisys A-Series
7)Network Administrator at Belgian Defence
January 1998 - June 2000 (2 years 6 months)
I was responsible for the installation of the ground force network. I installed the routers, modems,
servers, stations, cable and I configured all the material.
I was ensured myself of the maintenance of these networks (security, administration,…) in Belgium,
in Germany and in Kosovo (human operations)
* Tools and materials used :
o Windows NT Server : Operating system
o Cisco : for Routers
o Modem
o IP,TCP/IP, Ethernet: Protocol
o HP servers and HP Workstations.
8)Application Developer at Belgian Defence
January 1996 - January 1998 (2 years 1 month)
I developed reporting application written in Easytrieve and Cobol. I developed these applications on
Mainframe IBM 370.
* Tools and materials used :
o COBOL
o Easytrieve
o MVS/CICS
o IBM 370 Mainframe
Freelance Senior Analyst and Developer BI at 'La Poste'. Owner of TRILOCS SPRL.
Date IT Career started: 1996
-Mr. ******** is the Data Services architect, the technical anlayst and the developer for the project
CDW. CDW is the Coprorate Data Warehouse of 'La Poste'.
-Mr. ******** was the functional analyst, the technical analyst, the developer and the release
coordinator for the project EDW. EDW is the DG-Enterprise (European Commission) Data
Warehouse Project (Human Resources, Financial Accounting, Internal Audits, Legal Commitments)
He taked part with the PM in the analysis and the modelling of the business requirements. Then, he
created the tables and the ETL. To finish, he developed the universes and the reports intended for
the business.
-Mr. ******** as a Technical Analyst and Functional Analyst worked in the Financial Reporting of the
Belgian Post. For this job, the reporting was on Oracle 9i Database and the candidate maintained and
created Data Mart for the reporting. TOAD was used to access the Data Base. Power Designer of
Sybase for the Data modelling and Oracle Warehouse Builder for the mapping.
-Mr. ******** has extensive knowledge of Business objects. In his previous job Mr ******** was
General Supervisor at ING Bank Belgium. He followed all the formations at Business Objects (
Reporter, Designer,BCA, Administrator and Set Analyser).
- Mr. ******** as a Technical Analyst and Programmer worked on a critical Java project for ING Bank
Belgium. He developed the services to access the database and some business process to calculate
the commissions on the accounts, the cards and the interests. He was familiarized with WSAD, Web
Sphere, Castor,...
-Mr. ******** is a disciplined person, eager to permanently broaden his knowledge in the field of work,
a team player, with very good communication skills.
Finally, Mr. ******** is highly creative and interested in new technologies and life experiences. The
candidate continually develops his skills and abilities to enable him adapt to the needs and
requirements of his clients.
Specialties
Business Intelligence : Data Warehouse (OWB, BODI) / Design and Reporting (BusinessObjects/Oracle)
Analyst and development : UML, JAVA, XML/XSL
Analyst and development : COBOL, ALGOL (Unisys and IBM Mainframe)
Methodology : RUP
Education
ETRIS-6TTR (Information Technology School of the Belgian Ground Force) 1994 - 1996