-
AXA Investment Managers (AXA IM)
- SENIOR BUSINESS INTELLIGENCE CONSULTANT
Puteaux
2010 - maintenant
I was involved during 7 years in the operation, implementation, administrator and supporting of SAP (BI , HANA) . Being an effective colleague possessing good communication and technical skills, adaptive to new changing technologies.
* Responsible of the BI platform.
* I ensure that best practices are followed during projects design and build.
* Implementation of SAP HANA for the proof of concept.
* Exprerienced SAP Landscape transformation (SLT),
* Interface with developers and modelers for performance and data access requirements
* Responsible for technical architecture for BI.
* Technical referent for the developer users.
* Formulated the requirements and configurations best practice.
* Involved in designing and implementation of BI4 Architecture (Single Sign-On, Cluster,…)
* Capable of working independently with a minimum supervision as well as in a team.
* Moving Transports from development to Production system and tracking the changes.
* Implementation of the migration of Business Objects XI 3.1 to BI4.2
* Managing CMC administration and performance.
* Implementation and managing of security configuration on different environments.
* Performing upgrades of the servers to new release levels and clustering.
* Scheduling and publishing Webi reports via CMC to business users
* Involved in regression, performance and integration testing.
* Audit and KPIs existing Business Objects repository.
* Development of jobs control-M to monitor the platform.
* Researched new software and tools, proactively recommend improvements.
-
BPCE Infogérance & Technologies
- BUSINESS INTELLIGENCE CONSULTANT / ORACLE DBA
2007 - 2010
I’m involved in all Business Objects migration phases (6.5.4 to BOXI3) and database consolidation from financial software for banking (Summit, Reuters, Arpson, ...).
In addition, I’m responsible for the technical part of the project .
Define architecture environment (Clustered server).
Audit existing Buisness Objects repository.
* Define and document the technical steps for the migration.
* Loading the data warehouse from financial software (database consolidation).
* CMC administration and performance.
* Implementation of security configuration
* Creation of BO Universe (Resolving loops using contexts and aliases to remove the cyclic dependencies).
* Design desktop intelligence and web intelligence reports.
* Scheduling and publishing desktop intelligence reports via Infoview to business users
* Involved in regression, performance and integration testing.
* Template Xcelsius.
* Creation of stored procedures and snapshots (PL/SQL).
* Optimization of scripts SQL (Partitions tables).
* Managing the database's storage structures.
* Managing schema objects, such as tables, indexes, and views
* Knowledge transfer and training to the internal team and client.
Technologies and Environment : Windows server 2003, Unix (Sun Solaris 9i), Oracle 10GR2 , Business Objects XI3/R2, 6.5.4, Xcelsius, Shell, Perl
-
Datavance
- BUSINESS INTELLIGENCE CONSULTANT & ORACLE DBA
PARIS LA DEFENSE CEDEX
2007 - 2007
CLIENT : ADP – HR SERVICES (SALARY SOFTWARE COMPANY)
Project : Migration of the environment Business Objects version 5 to BOXIR2
* Migration data on oracle 9i to oracle 10GR2 ;
* Migration BO universes and reports version 5 to BOXIR2. ;
* Creation of BO Universe.
* Design and publishing BO reports. ;
* Creation of stored procedures and triggers (PL/SQL) ;
* Optimization of scripts SQL ;
* Rights administration Business Objects (CMC)
Technologies and Environment : Linux (OpenSUSE 9), Oracle 10GR2 , Business Objects XI R2(CMC, Desktop Intelligence, Designer, Web Intelligence)
-
Datavance
- ORACLE DBA & BUSINESS INTELLIGENCE CONSULTANT
PARIS LA DEFENSE CEDEX
2006 - 2007
Client Nokia
I was involved in the building of a new WAP SFR platform allowing to make available the information coming from statistic SFR system.
* Installation of Oracle (standalone and RAC) and Database Administrator.
* Performing upgrades of the database to new release levels
* Upgraded 9.2.0 database to 10.2.0.2 ;
* Creating and managing tablespaces, making database backups when necessary.
* Design Data Warehouse, creation of stored procedure for Data Aggregation.
* Installation of Business Objects and Administration Console.
* Creation of BO Universe.
* Design and publish BO reports. ;
* Rights administration and users management (SuperVisor).
* Interventions in others projects (Orange mobile network operator) as DBA Oracle (Maintenance and Optimization of the database and scripts SQL).
* Writing of the documentation (data validation reports (Oracle and BO)).
Technologies and Environment : Unix (Sun Solaris 9i), Oracle 10GR2 (DBA, PL/SQL), Business Objects 6.5.3(Designer, Supervisor, WEBI)
-
ACIAL
- SOFTWARE ENGINEER
Paris
2004 - 2005
Client : DEPARTMENT OF HEALTH
- MAINH (IS-IH2007 PROJECT)
I was involved in the conception and development of an intranet application allowing the financial operations of the project ``Plan Hospital 2007''.
I was responsible for the data Warehouse.
* Writing of data Warehouse requirements.
* Modeling Data Warehouse. ;
* Design of BO universes (management aid grant given to the public service of health (Designer). ;
* Creation of BO reports (Reporter and WEBI). ;
* Publication of several BO reports (Broadcast Agent). ;
* Rights administration and users management (Supervisor and WEBI). ;
* Upgraded Business Objects 6.1 (a, b) to 6.5.3. ;
* Formation given to the users.
Technologies and Environment : Business Objects 6.5.1(Designer, Reporters, Supervisor, BroadCast Agent, WEBI), SQLServer 2000 (Transact SQL), .NET(Visual Studio net, ASP net, C#)
-
ACIAL
- Software Engineer
Paris
2003 - 2004
Client : BNF (Bibliothèque Nationale de France)
Department : « Catalogue Collectif de France (CCFr)»
Project: Applicative maintenance of information system.
Mainly, in charge of database and Business Objects applications
* Maintenance and optimization of database and scripts SQL. ;
* Analysis and evolution of universes.
* Design of BO reports.
* Development macro VB in BO reports.
Technologies and Environment: Unix (Aix 4.3), Informix 7.22, Business Objects 4, Java, Netscape Enterprise Server, C, Visual Basic, html, Compiled JavaScript.
-
ACIAL
- Software Engineer
Paris
2002 - 2003
Client : DEZINEO
Conception and realization of web site and intranet
Development and configuration of administration service.
Modeling and implementation of database.
Technologies and Environment: Java (jsp, servlets), Application server: Tomcat, Oracle8i.
-
ACIAL
- Technical manager in charge of many applications
Paris
2001 - 2002
ACIAL (INFORMATION SYSTEMS AND CONSULTANCY COMPANY)
Client : Cart'Com (Project eRacer)
- Development of an intranet network for a company business management.
Technologies and Environment: Java (jsp, servlets), Application server: Tomcat, Database : PostgresSQL.
Client : Affimext (Project Affinet)
- Setting up new reservation application of advertising space for billstickers network.
VBA automation from the creation of the Access base, then shipment by FTP
Technologies and Environment : Visual Basic application, Access + extension ASP
Client : " Union de médecins Libéraux de l'Ile de France "
- Implementation of a new web site version (www.urml-idf.org
) and administration service.
Technologies and Environment : ASP, VBScript, Oracle (PL/SQL)
Client :Town hall of Franconville (France)
- Implementation of a new web site version (www.ville-franconville.fr) and administration service.
Technologies and Environment : ASP, VBScript, Access
-
Team netSolutions
- Software Engineer
2001 - 2001
DIGITAL SHARE (Medical intranet)
Intranet development allowing interchange of medical reports.
Administration of the oracle database.
Technologies and Environment : Java (Servlets, jsp), Oracle 8i (PL/SQL)
