-
TALAN
- Solutions Manager Business Intelligence
Paris
2016 - maintenant
Presales and Consultant Management for Microstrategy Solution.
-
Airbus
- Senior BI Consultant
Blagnac
2012 - 2016
Airbus is a division of Airbus Group SE that manufactures civil aircraft. It is based in Toulouse Suburb with production and manufacturing facilities mainly in France, Germany, Spain and the United Kingdom.
Main Tasks :
Global Architect on Tactical Planning Reporting projects
Conception - Analysis - Architecture - Development - Coaching
Harmonized User friendly landscape Design
Writing the Norms & Methods - Optimizing Process.
Training Session for End users and Proof of Concept Realization in BI4.
Aeronautics Domain:
Industrial process
Configuration management
Manufacturing planning
Quality
Challenges :
Convert time-consuming, unharmonized and unindustrialized solutions to evolutive and maintainable results.
Client Benefits :
Harmonized and new friendly user interface landscape
Automation process in line with their requirements
Technical background :
SAP BW 7.3, SQL SERVER 2012, SAP BI 4.1
-
BNP Paribas Fortis
- Senior BI Consultant
PARIS
2010 - 2012
BNP PARIBAS FORTIS, the no. 1 bank in Belgium, offers the market a comprehensive package of financial services for private and professional clients, wealthy individuals, corporate clients, public entities and financial institutions. Today, it is organized around 4 core activities: Retail & Private Banking, Corporate & Public Banking, Corporate & Investment Banking and Investment Solutions. BNP Paribas Fortis supports its clients abroad with a unique pan-European network reinforcing the Group's worldwide positions.
Operational Maintenance:
-Execute DW maintennace Jobs - fast track, Credit Margins
-Corrective Maintenance - Handle Incidents and Defects coming from BNPP-Fortis
-Preventive maintenance - Optimize application processes and code
Adaptive&Evolutive Maintenant
-Keep the datawarehouse in line with evolving technology and software product releases.
-Implement the functionalities in order to make the platform evolve in line with changing business needs.
Operational Service and Quality Management
-Timeline and planning follow up
-Risks and issues management
My main activities are:
Oracle DBA :
Document and Implement DB-changes, DB Maintenance tuning.
Platform Administrator :
PowerCenter Administration Tasks, platform support, Tool Vendor Support
ETL Framework :
Manage the ETL Application Framework, standards and guidelines. Review Designs.
Release Management :
Coordinate releases, maintain release documentation, deploy PowerCenter and Unix-scripts.
Role : Technical team Coordinator / Tech Lead.
Tools : Unix Script, Informatica v8, Oracle 10g
-
Fedex
- Senior BI Consultant
GENNEVILLIERS
2009 - 2010
Primary Tasks and responsibilities :
1. Familiarize with the existing XML parsing environment
2. Translate the functional design document and database model into the needed tables
3. Develop the needed ETL workflows to fill the tables with data
4. Cooperate with other ETL developers to ensure transparency and smooth integration in the existing ETL workflows
-
Johnson Controls
- Senior BI Consultant
Colombes
2009 - 2009
22/6/2009 - 20/9/2009 Johnson & Johnson
Name: Clinical Trials Management System
Role: Analyst Programmer, Technical Analyst
Description: Central Business Support Services, a Division of Global Clinical Operations, part of J&J is responsible for support of the IT systems used within GCO.
One of the main systems supported is the Clinical Trials Management System, a system that allows you track the progress and activities of a clinical trial.
CTMS currently has its own cognos reporting environment setup, based on a datamart that was developped in house (CACTUS). A set of predefined reports is already available in this reporting tool (AGORA).
They were planning to extend this datamart with a set of new tables from another GCO supported system, Trial Master Source.
Primary Tasks and responsibilities
-Familiarize with the existing reporting environment
-Translate the functional design document and database model into the needed tables
-Develop the needed ETL workflows to fill the tables with data
-Cooperate with other ETL developers to ensure transparency and smooth integration in the existing ETL workflows
Toward the end of the project a set of cognos reports have been developed based on the added tables to cover the standard reporting needs for the Trial Master Source project.
Technical background : ETL analysis and development in Informatica Power Center 8.5.1
· Data modeling, PL/SQL, Performance Tuning
· Cognos experience 8(ReportNet and framework manager ; Analysis Studio , Metrics Studio)
Technical background: Informatica PowerCenter 8
-
Belgacom
- Senior BI Consultant
Bruxelles
2008 - 2009
1/7/2008 - 23/06/2008 BELGACOM Belgacom Group
Name: Migration Biling Manager
Role: Analyst, DataWarehouse Architect, Technical Analyst
Description: Billing Manager's Overview
Companies use numerous telecom products and services and therefore receive a large number of
bills from Belgacom each month. Centralizing these bills and analyzing the telecoms budget require
each company to carry out an enormous amount of followup and generates high costs.
Belgacom Billing Manager (BMG) is an Internet application which, on the basis of predefined criteria,
provides belgacom customers with a reliable and secure solution for:
o creating reports,
o analyzing reports,
o downloading reports.
All data is extracted from Belgacom's official billing system.
Customers have access to their billing data records of the last 13 months.
The current solution regarding the reporting is based on Business Object Webi 6.5.2. The DBMS is ORACLE 9i.
Mission Objectives
Belgacom intends to migrate its current Billing Manager application in 2008 to a completely new system, based on the architecture and the technology delivered by MicroStrategy.
The objectives of Belgacom for this migration project are the following:
1. Stop using technology that will no longer be supported within Belgacom mid 2008
2. Provide its customers a more simple and more user-friendly application for reporting and analysis on billing data
3. Provide new functional and technical capabilities that will increase the usability of the application for Belgacom?s customers
4. Provide a more reliable, stable and better performing system with very little down-time
5. Migrate all standard and all personal reports
6. And in the longer term: differentiate itself from the competition by offering its customer new , innovative services through this new Billing Manager system.
In this contexte, my work will be to analyze the existing reports in Business Object, create the new report on Microstrategy and try to optimize as much as possible.
Technical background: MicroStrategy Desktop, MicroStrategy, Microstrategy Advanced Reporting, MicroStrategy Architect, MicroStrategy Web, Business Objects
-
Groupe Danone
- Consultant BI
PARIS
2006 - 2008
21/8/2006 - 31/1/2008 Unilog Logica Danone
Name: Pyramide : Junior Third Party Maintenance Project Leader
Role: Analyst Programmer, Functional Analyst, IT Support
Description: Danone is the number one food products company in France, world leader in dairy products
Pyramide : Danone Corporate TPM
Danone Corporate have a Business Intelligence Third Party Maintance to control the cost of operational maintenance, the development of new services for users and have a visibility on the performance level.
The Users were from the Financial Sector and the Commercial Sector.
Objectives and Responsabilites :
-Corrective and Evolving maintenance with Essbase
-Expertise upon Request for assistance for Microstrategy
-Analysis and modeling with PowerAMC
-Development of data extraction mappings with Informatica from several sources ( SAP, flat files, Operational DB, Analysis of the dependencies and construction of the workflows)
-Develop ETL workflows to fill the tables
Domains and intervention levels
-Design and Implementation
-Testing
-Documentation
Technical background: Business Analysis, DB2, Essbase, Informatica Power Center, MicroStrategy, Power AMC, Microsoft SQL Server 2005 Business Intelligence, Oracle 9.i, Oracle PL/SQL
