Mes compétences :
Business Intelligence
Oracle Data Integrator
Qlikview
Oracle
Datawarehouse
Entreprises
Sodexo
- Responsable Infrastructure BI
Issy-les-Moulineaux 2014 - maintenant
Direct Energie
- Ingénieur Etudes et Développement Business Intelligence
Paris2010 - 2014Développement d’applications décisionnelles sur de nombreux domaines fonctionnels :
- Finance (Encaissements par échéances, Balance Agée, Prélèvements bancaires, Rejets)
- Facturation (Analyses des Runs de Facturation, Analyses des billshocks)
- Gestion des Contrats (Programmes Anti-churn, Analyses de données clients)
- Recouvrement (Relances clientes)
- Approvisionnements en énergies (électricité et gaz)
- CRM
Résumé de l'activité :
• Recueil des besoins des clients internes
• Spécifications fonctionnelles et techniques
• Modélisation de Datawarehouses et Cubes sur bases Oracle
• Extraction des données via l’ELT Oracle Data Integrator (principales sources : SAP-ISU, SAP-CRM, FI-CA, FI-GL, Applications internes, flux XML, extractions CSV)
• Restitution avec Qlikview de tableaux de bords
Oracle Corporation
- Business Intelligence Junior Consultant
Colombes2008 - 2008I joined the Business Intelligence Consulting Team of Oracle France for a six months end-school internship.
Gained valuable experience in developing a new branch of an integrated Business Intelligence suite, dealing with four Oracle softwares : from our data source, the ERP ‘JD Edwards’ to the final activity reports.
Tasks Undertaken
• Define interesting performance indicators in the Procurement and Sales domain
• Analyse the source of our data (the ERP JD Edwards)
• Design the Data warehouse to be filled
• Develop ETL mechanisms to extract data from our data source
• Create professional reports
• Produce documents in English
Training Undertaken
• ORACLE DBA (Database 10g)
• ORACLE DATA INTEGRATOR (ETL)
• ORACLE BUSINESS INTELLIGENCE (Reports builder)
• Self-training on JD EDWARDS (ERP)
Bouygues Telecom
- Activity Reports Developer
Meudon2006 - 2008I joined the Service Delivery Manager’s team in the IT Support and Operations Department of third largest mobile phone company in France (10 million of customers).
I was in charge of the statistics data management of up to 100 mobile phone services reporting to managers and head of departments within the company. For example, this included statistics of SMS/MMS service availability, mobile web page visited and answering machine use.
Tasks Undertaken
• Development and upgrade of statistics reports on a web platform
• Provide new sources of data with a home-made ETL, dealing with IT support servers
• Maintain of all the extraction systems
• Supervise and commission work to IT contractual workers
Thalès Raytheon Systems
- System Engineer and Software Tester
Courbevoie2006 - 2006I joined the System Engineering Team during the final stages of testing for components for a software suite embedded in armoured military trucks, dealing with radars data interactions and radio telecommunications.
Tasks Undertaken
• Gained basic knowledge of military deployment
• Build military scenarios in laboratory, such as: artillery deployment mapping with airplane attacks)
• Validate virtual scenarios in military trucks
• Report technical bugs or software problems to the IT support team
RTE - Réseau de transport d'électricité
- Software developer and Database Manager
Puteaux2005 - 2005During my DUT's internship, I joined the IT team for a French electricity company.
I worked on many Microsoft Access databases with Visual Basic forms.
Tasks Undertaken
• Upgrade of the electricity lines database for the Paris electricity network
• Build staff database including necessary forms