Pierre LATI

En résumé

Entreprises

• Chanel - Functional Consultant

  Neuilly-sur-Seine 2012 - maintenant Time Period:
  October 2012 - Project ending in July 2013
  
  Client Name:
  Chanel
  
  Project Nature:
  Analysis and Implementation of new Corporate Financial Reporting Requirements
  3 divisions involved in consolidation reporting..
  • Total of 10 people involved in site
  • Functional Analysis, project steering and coordination.
  • International environment.
  
  Business requirements
  • Requirement gathering and analysis
  • Assistance to functional specification
  • Technical specification
  
  Team management / Project steering
  • Workload assessment.
  • Planning elaboration.
  • Weekly status meetings and involvment in steering comittees
  
  Testing / Project ownership assistance
  • Elaboration of unit and integration test scenarios.
  • Unit and integration testing of developments.
  • Roll-out of the solution by wave/entities.
  • Assistance to Training and change management
  
  Technical environment :
  BI suite: 7.0
  ERP : SAP R/3 FI-CO

• Valeo - BW Finance Lead

  Paris 2011 - 2012 Implementation and roll out of BW Finance flows and reports (Financial consolidation reporting of Valeo sites to headquarters).
  30 valeo sites involved in consolidation reporting..
  • Total of 10 people involved in site, 30 people from Off Shore (India)
  • Project ownership, management, project steering and coordination.
  • International environment.
  
  Business requirements
  • Requirement gathering and analysis
  • Assistance to functional specification
  • Technical specification
  
  Team management / Project steering
  • Workload assessment.
  • Planning elaboration.
  • Weekly status meetings and involvment in steering comittees
  • Management of off-shore Consultants (India) for developments.
  
  Conception
  • Conception of the BW architecture, reports and associated rights.
  • Follow up and monitoring of developments made by Off-Shore team (India).
  
  Testing / Project ownership assistance
  • Elaboration of unit and integration test scenarios.
  • Unit and integration testing of developments.
  • Roll-out of the solution by wave/entities.
  • Assistance to Training and change management
  
  Technical environment :
  BI suite: SAP BW 3.5, 7.0
  ERP : SAP R/3 FI (GL, AP/AR), CO (CO-OM, EC-PCA), New Ledger

• BNP Paribas Real Estate - Business Intelligence Consultant

  ISSY LES MOULINEAUX 2009 - 2010 eReport project : Implementation of a BI system (ETL, Cube and Reporting modules) to be used by Property Management Functions.
  
  Business requirements
  • Scope definition.
  • Gathering of reporting requirements.
  • Workload assessment
  • Project planning.
  
  
  Conception and realization
  • Source data analysis
  • Data capture and transformation design
  • Conception and modeling of a BI datawarehouse and associated reporting levels.
  • Conception and realization of associated ETL processes.
  • Writing of technical and functional specifications.
  
  
  Reporting
  • Development of static reports for mass diffusion.
  • Developement of OLAP cubes for dynamic reporting.
  • Development of interface flows for external IT applications.
  
  
  Testing / Project ownership assistance
  • Roll-out of the solution by waves/entities.
  • Writing of unit test and integration test scenarios.
  • Unit and integration testing
  • User testing assistance.
  • User training and change management.
  
  
  Technical environment :
  Database : Oracle 9i, SQL Server 2000, transact SQL
  ETL : Talend Open Studio
  Multidimensional analysis : Jedox Palo
  Reporting : JasperReports, iReport, BIRT

• BearingPoint (Paris La Défense) - Consultant

  2005 - 2009 Internal assignments :
  September 2007 – March 2009
  Development of Open Source Business Intelligence systems for internal purposes.
  Technical environment :
  • ETL: Pentado Data Integration, Talend
  • MutiDimensional Analysis: Pentaho Analysis, Palo
  • Reporting: JasperReports, Pentaho Reporting
  • BI platform: Spago BI, Pentaho BI Platform
  
  External assignments :
  
  June 2007-March 2009 Johnson & Johnson
  Business type : Healthcare
  Business line: Accounting / Controlling.
  European roll-out of an SAP BW/SEM- based accounting and controlling tool, used by US affiliates.
  Roll-out includes centralizing controlling and accounting functions in a Shared Service Center in Prague (Czech republic).
  Tasks:
  Requirement analysis.
  Functional and detailed design.
  Acceptance Test preparation and works.
  Technical environment :
  • Business intelligence suite: SAP (BW, SEM)
  • ERP: SAP R/3 (FI CO)
  
  
  Jan 2007-May 2007 CNH
  Business type : Automotive
  Business line: Finance.
  Support and assistance to the maintenance and evolution of a Financial solution (retail and wholsesale finance operations)
  Technical environment :
  • Financial software: Fimasys Profinance
  • Database: Oracle
  
  
  October 2006 Finance Ministry
  Business type : Public Services
  Business line: Finance
  Participation in the elaboration of a commercial proposal, in response to client requirements for a new BW-based Business Intelligence system.
  
  
  July 2006-September 2006 FNAC
  Business type : Retail
  Business line: Accounting.
  Implementation of a Business Intelligence architecture and reports for the internal Business Lines.
  Tasks:
  Implementation.
  Acceptance Test preparation and works.
  Technical environment :
  • Business intelligence suite: SAP/BW
  
  
  September 2005-July 2006 Low-cost Leader Retail Company
  Business type : Retail
  Business line : Supply Chain, Sales, Accounting.
  Implementation of a Business Intelligence architecture and reports for the internal Business Lines.
  Tasks:
  Functional and detailed design.
  Implementation.
  Acceptance Test preparation and works.
  End-User Training and going live support.
  Technical environment :
  • Business intelligence suite: SAP/BW

• British Telecom France - Consultant

  2003 - 2005 January 2005-06 May 2005 Crédit Agricole S.A.
  Business type : Banking
  Business line : Human Resources
  Desing and implementation of Human Resources Datawarehouses, consecutively to the Crédit Agricole-Crédit Lyonnais merger.
  Tasks:
  Requirement analysis.
  Functional and detailed design.
  Acceptance Test preparation and works.
  Technical environment :
  • OS : Unix.
  • Database : Oracle, Toad.
  • ETL : Oracle SQL Loader.
  • Programming : PL/SQL, Shell.
  
  
  December 2004-Janvier 2005 Ubisoft (Montreuil)
  Business type : Retail
  Business line : Executive Management
  Development of a Balance Scorecard, for the purpose of driving performance around 4 majors themes : Sales, HR, Projects Finance.
  Tasks:
  Functional and detailed design.
  Technical implementation.
  Acceptance Test preparation and works.
  Technical environment:
  • Database : Microsoft SQL Server.
  • OLAP : Microsoft Analysis Services.
  • Balance Scorecard : Microsoft Business Scorecard Accelerator.
  • Reporting : Microsoft Reporting Services.
  • Portal : Microsoft Windows Sharepoint Services.
  
  
  November-December 2004 Servair (Roissy)
  Business Line: catering.
  Business Intelligence IT systems migration.
  Technical environment:
  • Reporting : Business Objects V4-V5-V6.
  
  
  September 2004 Lesaffre (performed at BT Headquarters, La Défense)
  Business type : Retail
  Business line : Executive Management
  Development of a Balance Scorecard prototype within a Commercial Proposal context, with the purpose of piloting sales.
  Tasks:
  Requirement analysis.
  Prototype development.
  Technical environment :
  • Database : Microsoft SQL Server.
  • Reporting : Microsoft Reporting Services, Business Objects V6.
  
  
  August 2004 - September 2004 ExxonMobil (Rueil-Malmaison).
  Business type : Energy
  Business line : Support
  Developement of reports for Helpline performance assessment.
  Tasks:
  Functional and detailed design.
  Technical implementation.
  Acceptance Test preparation and works.
  Technical environment :
  • Database: Oracle.
  • Reporting: Crystal Reports, Crystal Designer (restitution).
  
  
  July 2004 Ubisoft (Montreuil)
  Business type : Retail
  Business line : Executive Management
  Participation in the elaboration of a commercial proposal, in response to a client’s need for a Sales Balance Scorecard.
  Technical environment :
  • Database: Microsoft SQL Server.
  • Reporting : Microsoft Reporting Services.
  • Balance Scorecard : Microsoft Business Scorecard Accelerator.
  • Portal : Windows Sharepoint Services.
  
  
  June 2004 Servair (Roissy)
  Business type: catering.
  Business Intellignce IT migration.
  Tasks:
  Requirement analysis.
  Audit of existing Business Intelligence IT infrastructure.
  Functional and detailed design.
  Technical environment :
  • Database: Oracle, Toad.
  • Reporting: Crystal Reports.
  • Programming: Microsoft Visual Basic.
  
  
  February 2004 - June 2004 ADP/GSI (Vésinet Le Pecq)
  Developement of reports for Helpline performance assessment of various client internal activities (Helpline assessment, Sales Performance assessment for the different agencies and regions, client rentability…)
  Tasks:
  Functional and detailed design.
  Technical implementation.
  Acceptance Test preparation and works.
  Technical environment :
  • Serveur: Citrix.
  • SGBD: Oracle, Toad.
  • Restitution: Crystal Reports.
  • Programmation: Microsoft Visual Basic.
  
  
  January 2004 Commissariat à l’Energie Atomique (Saclay)
  Business type : Energy.
  Business Intellignce IT migration.
  
  
  September 2003 - December 2003
  Interlal assignment for British Telecom
  Development of a Balance Scorecard for the BT France Executive management, for the pupose of measuring internal performance (Business Line performance, staffing…).
  Tasks:
  Requirement Analysis.
  Functional and detailed design.
  Technical implementation.
  Acceptance Test preparation and works.
  Technical environment :
  • Server: Apache, WebI.
  • Databse: Oracle, Toad.
  • Reporting: Business Objects.
  • Dashboard: Application Foundation.

Formations

Pas de formation renseignée

Réseau

• Alexandre GHILARDI

• Aurelie LEGEAY

  It-Akademy (Villeurbanne)

• Cedric MARY

• Cedric PORTE

• David SAVADOGO

• Glotz DIDIER

• Laure PEUREUX

• Liz CRANE

• Rayal DJERBOUA

• Sandrine FERREIRA