Menu

Pierre LATI

Neuilly-sur-Seine

En résumé

Cofondateur de Squadrill - Solution de reporting pour Experts-Comptables et Directeurs Financiers à temps partagé
www.squadrill.com

Consultant Freelance Business Intelligence
Principales expertises:
SAP BI
BI Open source suites

Anglais courant.

Mes compétences :
Accounting
Business
Cognos
Controlling
Crystal reports
data integration
ETL
ETL Talend
Intégration
Jasper
Jasper Reports
Kettle
Microsoft Business Intelligence
Open Source
Palo
Pentaho
Pentaho Data Integration
SAP
Sap bw
Talend
Crystal Report

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

Annuaire des membres :