Jérome LAROSE

En résumé

Entreprises

• ALLIANZ REAL ESTATE GMBH - Data Alchemist

  2012 - maintenant

• ALLIANZ - Data Alchemist

  Puteaux 2012 - maintenant Déploiement de l'ERM STIL selon la méthodologie Time Is Life :
  Audit de l'architecture décisionnelle existante
  Analyse des impacts technico-fonctionnels
  Validation de la roadmap DWH
  Définition de la méthodologie de gestion de projet
  Coordination des équipes externes et internes
  Automatisation de la génération des interfaces SAP avec Talend
  Conception , développement et chargement des DWH FRANCE et GMBH avec SQL SERVER 2012 , SSIS
  Création de cubes OLAP avec SQL SERVER 2012 , SSAS
  Création de DashBoard pour les investisseurs France et GmbH avec SQL SERVER 2012 , SSRS
  Planification des tâches
  Présentation pour le Codir

• INGESUP - Formateur bases de données décisionnelles

  2012 - maintenant Formateur en conception et optimisation de bases de données décisionelles:
  UML , SQL , PL/SQL, ORACLE , SQL SERVER, MySQL

• INGESUP - Trainer

  2012 - 2012 Business Intelligence Trainer
  
  * Trainer in design and modeling databases for engineers 1st and 2nd year
  UML, SQL, PL / SQL, ORACLE, SQL SERVER, MySQL
  
  * Trainer in DataWareHouse design and optimization for the CAPGEMINI engineers:
  TUNING, SPFILE, CONFIGURATION, ETL, SNOW FLAKE, STAR, MDX, ROLAP, MOLAP, HOLAP,
  SLICE & DICE, ROLL UP & DOWN DRILL, CRM, ERP, REPORTS...

• AMP VISUAL TV - Chef de projet

  2012 - 2012 Analyse des processus de planification interne.
  Analyse du modèle de données 4D.
  Etude des fonctionnalités cibles à implémenter par des interviews avec les utilisateurs.
  Restitution des écarts et des impacts au management.
  Recommandation de la technologie à mettre en oeuvre.
  Découpage technico-fonctionnel par groupe d'utilisateurs.
  Réalisation de 40 tableaux de bord de contrôles opérationnels
  Pilotage migration 4D vers la version 12

• MUTUALITE FRANCAISE - AUDITEUR BASE DE DONNEES

  Paris 2012 - 2012 Analyse des accès applicatifs impactant les Input/Output sur le serveur de base de données.
  
  Analyse des accès applicatifs impactant les performances au niveau mémoire.
  
  Amélioration des performances de 30%
  

• ESCEM - IT Project Director

  Tours Cedex 3 2011 - 2012 Information System Project
  
  Actions:
  * Identification of initial requirements.
  * Creation of mapping and data model. ;
  * Implementation of a specific project management method to define deliverables and
  establish a road map for the project team.
  * Weekly meeting management to identify risks, get the feedback of the directors, and modify
  the different project team tasks to respect the delivery planning.
  * Management of the development team to realize interfaces in ASP. Net / C #.
  * Creation of dashboards in Reporting Services 2008 to visualize key figures. ;
  * Creation of training tool.
  * Change management organization.

• TIME IS LIFE - Profit Center MANAGER & R&D DIRECTOR

  PARIS 2011 - maintenant * Coordination, conception and development of the STIL R&D project.
  * Customer portfolio development.

• Time Is Life - Créateur de Richesse et d'Apprentissage

  PARIS 2011 - maintenant Développement de systèmes d'information sur mesure incluant : GED , CRM et BI
  
  Conduite de projet
  
  Optimisation et refonte de systèmes existants

• UNICEF - IT Project Director

  Paris 2009 - 2011 ERP PROJECT:
  
  Goal: Optimization, ergonomic adaptation and migration of the ERP QUALIAC.
  
  Actions
  * Definition of the planning and identification of the project milestones in MS PROJECT.
  * Identification of operational ergonomic needs and establishment of the gap analysis to define
  the appropriate road map.
  * Re-writing of SQL procedure to provide the best information view.
  * Coordination of the QUALIAC team to prepare migration and the rollout the final solution.
  
  UNIWEB PROJECT :
  
  Goal:
  Automation of transaction flows between the online shop, the fulfillment platform and the logistician
  in order to develop fundraising actions on the internet.
  
  Actions
  * Definition of the planning and identification of the project milestones in MS PROJECT.
  * Support and orientation to the web project team to include their development in the whole
  project.
  * Following of the KPI and CSOP meeting organization. ;
  * Industrialization of the overall scripts and fundraising data flows with Talend. ;
  * Tests method definition. ;
  * Knowledge Management process definition to optimize the scalability in case of emergency.
  
  
  BRP LOGISTIC INTERNATIONAL PROJECT:
  
  Goal:
  Rationalize the supply chain in a European perspective between France, Netherlands, and Geneva.
  
  Actions:
  * Definition of the planning and identification of the project milestones in MS PROJECT.
  * Functional translation of operational and strategic business need to technical requirement.
  * Coordination between the following IT teams: RHENUS in the Netherlands, ARVATO in Lens
  and UN in Geneva.
  * Monitoring and report on progress of the project to the stakeholders.
  * Modelling flow exchanges by sales channel. ;
  * Coordination of the development of interface generation for sales and stock.
  * Analysis of issues and risks, management of project changes and problem resolution to
  respect project objectives
  * Setting up supervision tools for flows and backup procedures.
  * Setting up of automated KPI analysis tools.
  
  UNIREF PROJECT
  
  Goal:
  
  Centralized all external datas in a dedicated DataWareHouse in order to increase fundraising
  efficiency and follow strategic KPIs easily.
  
  Actions:
  * Modelling of the DWH Finance and Marketing ;
  * Coordination of external team to create automated SSIS 2008 jobs for the feed. ;
  * Development of DWH consolidation rules via SQL Server 2005 and 2008 ;
  * Creation of financial and marketing reports via VISUAL STUDIO 2008 ;
  * Implementation of a security policy for the 150 users ;
  * Implementation of publication by subscription. ;
  * Setting up of operational processes.

• UNICEF - CHEF DE PROJET MOE

  Paris 2009 - 2011 PROJET RIA :
  - Optimisation, adaptation ergonomique, puis migration de l’ERP QUALIAC vers sa version RIA.
  PROJET UNIWEB :
  - Automatisation des flux transactionnels entre la boutique Web, la plate- forme de fullfillment et le logisticien.
  PROJET INTERNATIONAL BRP LOGISTIC:
  - Coordination entre les équipes informatiques RHENUS aux Pays-Bas, ARVATO
  à Lens et ONU à Genève.
  - Modélisation des échanges de flux par canal de vente.
  - Pilotage des développements de génération des interfaces de ventes et de
  stocks.
  - Mise en place des outils de supervisions des flux et des procédures de
  rattrapage.
  PROJET UNIREF
  - Modélisation des DWH finance et marketing
  - Pilotage d’équipe pour la création des jobs automatiques SSIS 2008 pour l’alimentation.
  - Développement des règles de consolidation des DWH via SQL SERVER 2005 et 2008.
  - Création des reportings finances et marketing via VISUAL STUDIO 2008
  - Mise en œuvre de la politique de sécurité.
  - Mise en œuvre de la publication par abonnement.
  - Définition des procédures opérationnelles d’exploitation.

• ALLIANCE HEALTHCARE - Application Manager

  Gennevilliers 2008 - 2009 * Modelling of the DWH structure and DataMarts products and logistics routes. ;
  * Creation of the XML feed flows for DWH via ETL TALEND. ;
  * Updating the DWH consolidation requests. ;
  * Coordination of the London and Milan development teams for final tests.

• ICDC - IT Project Manager

  Arcueil 2007 - 2008 SIRC PROJECT:
  Goal:
  Creation of Credit Risk Management tools to apply to the Basel II principals.
  
  Actions:
  * Modelling of calculation tables and implementation of the new DWH risk engine
  with Fermat.
  * Analysis of the impacts linked to the developments requested by the client.
  * Automation of loads and flux logging. ;
  * Definition of dependencies between the packages ;
  * Test planning on the various environments ;
  * Development of Data Windows within the Fermat software package. ;
  * Management of user profiles through browsers. ;
  * Optimization of the performance of SQL processes. ;
  * Maintenance, organization of validations and production start-up
  * Participation in the upgrade of the FERMAT 5.1 software package to FERMAT 5.3.

• ING DIRECT - Application Manager

  Paris 2007 - 2007 Development of a data analysis tool.
  
  * Target table modelling and monitoring of referential integrity with existing tables.
  * Preparation of a report specifying the selected technical solution.
  * Development of data extractors in T-SQL.
  * Carrying out unit tests. ;
  * Preparation of the production report, including the various stored procedures used and their
  operation method.
  * Integration of the application in the production environment. ;
  * Validation with users.

• CAISSE DES DEPOTS - Chef de projet décisionnel Oracle

  PARIS 2007 - 2008 PROJET SIRC : risque de contrepartie et Bâle II
  - Modélisation des tables de calcul et implémentation du nouveau moteur de risque DWH Fermat.
  - Analyse des impacts liés aux évolutions demandées par le client.
  - Evaluation des charges.
  - Définition des dépendances entre les packages
  - Planification de tests sur les différents environnements
  - Réalisation de Data Windows au sein du progiciel Fermat.
  - Administration des profils utilisateurs à travers les browsers.
  - Optimisation des performances des traitements SQL.
  - Maintenances, organisation des recettes et mises en production
  - Participation à l'upgrade du progiciel FERMAT 5.1 vers FERMAT 5.3.

• FININFO - Application Manager

  2006 - 2007 Development of decision making tools for market activities.
  * Development of a DWH OPCVM batch feeder via SYBASE accesses and procedures stored
  in T-SQL.
  * Modification of a stock market price history algorithm to include warrant type
  instruments from ABN AMRO in C language
  * Development of decision making verification rules with multi-base stored procedures to
  detect intra-day abnormalities and current day abnormalities compared with the
  previous day.
  * Participation in the functional qualification with MOA.
  * Creation of non-regression unit tests and completion of the software integration phase.

• STOCK EXCHANGE - Application Manager

  2005 - 2006 PACKAGE EDITOR (PROJECT VIA CAPGEMINI CONSULTING)
  Implementation of version 8 of the REGISTRAR proprietary software
  
  * Development of SQL batch requests to retrieve relevant information from the database.
  * Development of triggers and T-SQL scripts for performance optimization.
  * Updates of the HELP DESK Database (initiating client contact, follow-up of the correction
  process, validation of incident tickets) in ACCESS.
  * Integration of evolutions into the PVCS project management tool
  * Preparation of computerized links based on the GIE general specifications
  * Completion of unit tests and modular tests with scenario definitions
  * Participation in the validation phase of version 8 of the software.

• DHL - Stagiaire

  Roissy en France 2002 - 2003

Formations

• Talend

  Suresnes 2011 - 2011 TOS CERTIFICATION

• EDU

  Paris 2009 - 2009 MICROSOFT Certification

• SCIFORMA

  Paris 2008 - 2008 PROJECT MANAGEMENT AND ITIL V2 PRINCIPLES
  
  Training in project management, ITIL methods, SCRUM, PSNEXT at SCIFORMA. ;

• First Finance School

  Paris 2007 - 2007 Credit Risk Management & Basel II

• Université Paris Est Val De Marne Créteil (UPEC)

  Creteil 1999 - 2004 MIAGE

• Lycée Léon Blum

  Creteil 1996 - 1999 scientifique