Missions SAP ERP : Une multitude d'offres mises en ligne chaque semaine

Résumé d'expériences de Kossigan,
freelance SAP ERP résidant dans la Savoie (73)

• SAP BI Consultant duration : 2,5 months

  STATIM Conseil, Paris France
  Jan 2015 - Jan 2015

  Ver. SAP BW 7.x, BI4, HANA
  Training and Demo platform
  SAP ECC6/SAP Netweaver 7.3
  SAP BI4 IDT, WEBI, Design studio, Cristals report using BICS connection, Analysis
  SAP HANA studio : Create Tables, views, BW Datasource with DXC connections
  Data Model: create attribute views, analytic views, calculation views,
  Importing a BW InfoProvider into SAP HANA as analytical model,
  hana optimized infocube , composite and transient infoprovider
  Design studio : Create applications using Bex queries on SAP BW/Hana system

• SAP BI Consultant duration : 34 months

  MANITOWOC, Lyon France
  Jan 2012 - Jan 2015

  Project ONE: Implementation of SAP ECC and BW7x, BI.4
  SAP ERP: PP, MM, SD, QM, FI, CO, COPA.
  Rollouts of the solution to several Manitowoc regions (Europe, APAC, America, China…)

  Ver. NetWeaver BW 7.0, 7.3 BI4, ECC6.0

• SAP BIW Consultant duration: 10 months Ver. NetWeaver 7.0 BI, ECC5

  SCHNEIDER Electric (Rueil-M. France )
  Jan 2011 - Jan 2012

  BRIDGE Project: OTD - On time delivery indicators
  The goal of these indicators is to measure ability of Schneider Plants and Distribution centers to deliver on time their customers.
  
  SAP ERP Functional areas : Purchases, Sales, Deliveries, Shipments.
  
  Participate in functional and technical analysis in SAP and BI for the implementation of the targeted functionality.
  Participate in deliverables for OTD - On time delivery indicators
  Analysis, modelling and BW development: infobjets, Datasources, DSO, cubes and multicubes, BEX and WEB queries and process chain.
  Preparation of go-live plan for new BW dataflow
  ETL:
  LO cockpit extractors used : 2LIS_02*, 2LIS_11*, 2LIS_12*,2LIS_08*.
  Datasources enhancement, Append structure, and user-exit
  Built customised datasources based on database tables or views (master data, Standard and customised Master-data extractors
  Reorganisation of the setup tables, Init /delta loading

• Blue-Infinity, Switzerland, Geneva
  Jan 2010 - Jan 2010

  Project ERP & BI for Customs of an African government:
  Preparation phase
  
  Modules procurement, Finance et RH.
  Identification of main business processes
  Deliverables and project documentations
  Methodology for Business intelligence tools evaluation.

• SAP ERP, SAP BI, BO and COGNOS

  blue-infinity
  Jan 2010 - Jan 2010

  Installation Platforme de Demo
  • Intégration SAP ECC6/SAP Netweaver 7.0 and Business Objects XI 3.1
  • Intégration SAP ECC6/SAP Netweaver 7.0 and Cognos 8
  • Crystal reports, WEBI, Xcelsius, Cognos report studio.

• Consultant SAP BW

  Philip Morris International (PMI) Lausanne Suisse
  Jan 2007 - Jan 2010

  BW OPS (System BW global ): Projet PPTT - 8 mois
  Ver. NetWeaver 7.0 BI, R/3 4.6, ECC5, ECC6
  Projet PPTT: Product Project Tracking Tool (produits finis et semi-finis)
  
  SAP ERP : Achats, production, niveau et mouvements de stock, BOM et MRP.
  Oracle GIPS : Projets de gestion de cycle de vie des produits (projet produits)
  • Améliorer la gestion de l’obsolescence des produits
  • Optimiser les projets produits afin de gérer efficacement la fin du cycle vie d’un produit
  Participer aux analyses fonctionnelles et techniques des besoins, Gestion des livrables
  Modélisation et développement BW : infobjets, Datasources, DSO, infocubes, process chain…
  ETL:
  • LO cockpit: Activation des extracteurs logistics SAP (2LIS_03*, 2LIS_O2*, 2LIS_04_P_MATNR), Extensions de datasources standards, Append structure, et user-exit
  • Création de datasources spécifiques à partir de tables SAP
  • Datasources à partir de vues de bases de données Oracle ( DB Connect )
  • Restructuration des tables Setup, vidage, et rechargement init et delta des flux
  • Connection (DB connect) entre SAP BI7 et system Oracle (GIPS)

• BW Technical Lead and development: FI, CO, COPA, QM.

  aujourd'hui

  Functional requirements analysis, define BW technical specifications
  Provide technical guidelines for the data modelling and development
  Develop Datasources, DSO, cubes, BEX and WEB queries and process chain
  Manage and follow up the offshore BW development team members.
  Coordinate the development activities of the offshore team.

• SAP BW/BI Business Analyst: FI, CO, COPA, QM.

  aujourd'hui

  Collect functional requirements from end/key users, Finance and Quality team.
  Organize workshop and gap fit analysis, requirements analysis.
  Define BW functional specifications. Provide technical guidelines for the data modelling.
  Gap fit analysis for new countries deployment and for enhancements.
  Provide testing data, data load, organize unit testing and UAT.
  Write user guide for delivered reports, organize training, knowledge transfer and support to end-users.
  Rebuild with Design Studio and WEBI some existing WAD reports for Finance and Quality management teams.Datasources enhancement, Append structure, and user-exit
  Built customised datasources based on database tables or views (master data, Standard and customised Master-data extractors
  Reorganisation of the setup tables, Init /delta loading
  Talend Datasource based on external source system ( Oracle DB, Web database…)

  ETL: LO cockpit extractors used : 2LIS_02*, 2LIS_03*, 2LIS_04*, 2LIS_05*, 2LIS_06*, 2LIS_08*.2LIS_11*, 2LIS_12*, 2LIS_13*, 0FI_GL*, 0FI_AP*, 0FI_AR*, 0CO_* , COPA generated DataSource…

• BW OPS (System BW global )Projet FGCT - 9 mois
  aujourd'hui

  Ver. NetWeaver 7.0 BI, R/3 4.6, ECC5, ECC6
  Projet FGCT: Finished Goods Component Tracking and Tracing Project
  
  SAP ERP : Achats, production , niveau et mouvements de stock
  Régions déployées : Amérique latine, Asie pacifique, Europe de l’est, Europe de l’ouest.
  • Déploiement pour 4 systèmes SAP ERP de la solution SAP BW de suivi et de traçabilité des anomalies lors de la production de cigarettes (produits finis ou composants défectueux)
  • Identifier produits ou composants défectueux, identifier le lot, les fournisseurs, les clients…
  
  Participer aux analyses fonctionnelles et techniques des besoins, gestions des livrables
  Modélisation et développement BW : infobjets, Datasources, DSO, cubes, queries, process chain…
  Jump target de queries BW vers des reports dans SAP ERP ( tcode BMBC, me23n, ME2L)
  ETL:
  • LO cockpit: Activation des extracteurs logistics (2LIS_03*)
  • Création et extensions de datasources SAP pour BW, Append structure, et user-exit, CTBW
  • Gérer les connection RFC entre SAP BI7 et 4 SAP ERP systems

• Projet SAP P1 BW

  Stabilisation du SAP P1 BW Western Europe - 16 mois
  aujourd'hui

  Ver. BW 3.5, R/3 ECC5
  Analyse, modélisation et Modification de flux BW : finance, controlling, achat, production, stock
  ETL:
  • Activation et extensions d’extracteurs logistics (2LIS_03*, 2LIS_O2*, 2LIS_04* 2LIS_05*)
  • FICO Datasources: 0FI_GL*, 0FI_AP*, 0FI_AR*, OCO_PC_ACT*, 0CO_OM_CCA*
  • Datasources à partir de tables et vues SAP, Datasources Classification avec tcode CTBW.
  • Restructuration des tables Setup, vidage, et rechargement init et delta des flux