CV PCB : Trouvez le meilleur profil freelance

Résumé des missions de Salima,
freelance PCB résidant dans le Val-de-Marne (94)

• EIFFAGE
  Jan 2018 - aujourd'hui

  Eiffage is a group with diversified skills in many areas: construction, real estate, infrastructure, energy, roads, concessions. It is the third group of French constructions and concessions, behind Vinci and Bouygues, and the fifth largest European group. Eiffage has decided to make available to all business areas a reporting tool for making corporate documents available and creating ad hoc documents to speed up arbitration and control. The REFONTE OPERIS project and Eiffage BI RH concerns the 6 business lines up to the group consolidation.
  
  Mission
  Attached to the DSI and the program director, my mission was to carry out the following as a Task Force:
  
  Analyze data sources to establish an optimum Data Model.
  Analyze power management and reporting rules.
  Creating a BODS feed job for arbitration.
  Optimize the technical layer under SAP HANA.
  Optimize the semantic layer to allow the creation of ad hoc documents by trades.
  Enrich the provision of information by creating 240 new indicators.
  Migrate the 140 existing reports on the new environment.
  Accompany the MOA in the implementation of best practices.
  Accompany the consultants in charge of the unit tests.
  
  Achievements
  Reduction of the number of calculations views (60 calculations view by 3 calculations views)
  Creation of a BO universe to simultaneously meet the needs of corporate reporting as well as ad hoc reporting.
  Creation of 360 indicators.
  Migration of 140 reports.
  Accompanying to unit tests.
  Production start.

  Application and technical environments BODS BI4 ,SAP HANA, Sql Developer, BO Univers IDT, BO WEBI BI4

• AIRBUS
  Jan 2017 - Jan 2018

  Airbus is an international pioneer in the aerospace industry. It’s a leader in designing, manufacturing and delivering aerospace products, services and solutions to customers on a global scale. AIRBUS has decided to migrate 4 legacies systems under SAP ECC 4.6 to 1 ECC on Supply Chain scope by wave.
  “Wave 2” migration project (based on Wave 1 experience) is focus on A350 aircraft program impacting all countries (FR / GE / UK / SP).
  
  Mission
  Attached to different team leader, as part of ARP Project, my mission was to carry out the following as a Task Force:
  Migrate data from SAP ERP ECC 4.5 to ECC 6 by identifying a Core International Model.
  Qualify and correct Extract, Transform and Load data rules.
  Serve as expert in ETL and migration to development team On shore and Off shore (Accenture Manilla).
  Provide knowledge transfer to local team (15 peoples).
  Design, develop architecture and build data load process.
  Build level 3 technical developments.
  Assist and support test consultant
  
  Achievements
  Migration of all Purchases Orders (average costing time for each job - 5 minutes)
  Creation of Kpi Dashboard to improve data cleansing (average costing time for each job - 3 minutes)
  Automatic load of master and transactional data on the target environment.

  Application and technical environments SAP ECC 4.5, SAP ECC 6, SAP GUI, SAP HANA, LSMW, BODS XI, Sql Developer

• E.Leclerc G.A.L.E.C
  Jan 2016 - Jan 2017

  E.Leclerc is a distribution cooperative network, one of the leaders in the French agri-food sector with some €50 billion in revenues. The E.Leclerc stores are supplied by a central procurement generalist organized by 16 geographical areas. E.Leclerc network has decided to optimize and migrate its decision-making tools, redesign business processes and set up a centralized repository that is shared with all the entities in the organization.
  
  Mission
  Attached to the DSI and the program director, as part of the BODS BOXI project, my mission involved migration decision-making and planning tools and was organized around 3 axes :
  
  1st axis:
  Assist and recommend as expert business intelligence solutions.
  Coordinate and control the various internal stakeholders for the client (several departments) and service providers (several providers).
  Monitor the progress of projects and alerts.
  Prepare and lead project meetings and steering committees.
  Coordinate with the leaders of each tools impacted by migration.
  Coordinate between project managers and team leader of each decision tool.
  Serve as technical adviser level 3.
  Development of complex solutions.
  2nd axis:
  Design and run functional test processes.
  Perform non-regression tests.
  Monitor and manage incidents up to completion.
  Prepare follow-up committees.
  
  3rd axis:
  Initiate and conduct site anonymization of analytical databases and restitution.
  
  Achievements
  Reduction in the reporting perimeter of BO XI R3 to BI 4 reports (from 467 reports to 128 reports).
  Reduced load stream processing times (eg 8 to 10 minutes).
  Reduced backup processing times (eg. : 1 daily backup to 2 weekly backups).
  Respect of planning and costs.
  Optimization of communication and manage collaboration between the various technical and business departments.
  Template for deliverables.
  Knowledge transfer in favour of 2 junior project managers.
  Participation in Informatica workshops for managing master data.
  Boost competence of the business teams on the main rules of a repository.
  Validation by the business teams of the data characterisation (masters, consecutives, parameters).
  Validation of repositories’ modeling (5 million products, 10 000 suppliers, 500 stores).
  Validation of MCD suppliers, products and stores.

  Application and technical environments BO XI R3 - BI 4, Sql Developer, DB2, flat files, xml, SQL, MYSQL.

• A.G.I. ALLIANZ GLOBAL INVESTOR
  Jan 2014 - Jan 2015

  Allianz Global Investors is an asset manager for private and institutional clients worldwide.
  It manages assets valued at almost 500 billion euros. The announced shutdown of SAP support on R3 version, has imposed the migration of its decision-making environment as well as its planning tool to ensure sustainability and quality trade-offs.
  
  Mission
  Attached to the DSI in collaboration with Business Unit Reporting within the PEER ONE migration project, my mission was to ensure that schedule and budget were met, while promoting exchanges between technical teams and European businesses through the following actions :
  Referencing, qualification, cost estimation, project planning (documents, universes, ETL / other flows, treatment planning).
  Level 3 technical development, assistance and support of junior developers
  Management, monitoring, technical and functional assistance for 6 junior consultants.
  recommendation and formalization of necessary adaptations and modifications (documents, universes, flows, RDBMS)
  Preparation and presentation of progress reports to the project committees.
  
  Achievements
  Reduction of the migration perimeter of BO XI R3 documents to BI 4 (from 1164 reports to 280 reports).
  Reduced update times for BO documents (eg. : From 4 hours to 3 minutes).
  Optimization of 10 universes and 6 RDBMS.
  Scheduling of 280 documents migrated to the new version of Infoburst.
  Implementation of the new user repository BO (CMC)
  Documentation update.
  Knowledge transfer in favour of junior consultants

  Application and technical environments BO XI R3 - BI 4, Sql Developer, INFOBURST, ORACLE, flat files.

• SCOR
  Jan 2013 - Jan 2013

  Ranked as the 3rd largest global reinsurance group in the world, SCOR is organized into two business branches, SCOR Global P & C (Property & Casualty reinsurance) and SCOR Global Life (life reinsurance), and an asset management business, SCOR Global Investments.
  Due to constantly increasing processing time, it was necessary to consolidate the BI tools.
  
  Mission
  Attached to the IT department, as part of the DWH project DIMENSION, my mission was to provide the following :
  Setting up of an inventory of the tools used.
  Rationalization of 6 RDBMS, 10 universes and ETL.
  Optimization of backup procedures and incident management.
  Realization of the scoping phase, budget, and project planning
  Organization and monitoring of unit test activities until the production phase.
  
  Achievements
  Creation of 2 DWH (management portfolios, reinsurance) and 30 documents.
  Reduction of business support costs (eg. : elimination of Excel file redundant with Business Object application, training).
  Replacing the monthly data load (initial duration : 5 days) with daily data load (duration : 20 minutes)
  Replacing the monthly backup procedures (initial duration : 24 hours) by a daily backup (duration : 1 hour)
  Development of a targeted backtrack procedure.
  Internal training for new environments.
  Respect of planning and budget.
  Leadership of unit tests up to production

  Application and technical environments SAP, BODS XI, TOAD, BO XI 4, Sql Developer, ORACLE, flat files.  

• SYNAPSES
  Jan 2013 - Jan 2014

  Founded in 1982, Synapses' mission is to train, advise and assist companies in the implementation of their management and office automation systems, as well as to support them in the evolution of their systems.
  
  Mission
  Attached to the CEO, my mission was to provide training on the different Business Object modules to end customers and intervene as an expert on various ERP.
  
  Achievements
  Creation of a training support on end customer’s production environment.
  Qualification leader.
  Training of junior consultants.
  Level 3 technical development and functional support.

• HEINEKEN - FRANCE BOISSONS
  Jan 2010 - Jan 2012

  HEINEKEN France, a French subsidiary of the Dutch group, has a turnover of € 1.6 billion, making it one of the top 100 companies in France. The HEINEKEN group is developing two strategic activities: Brewery, through its subsidiary HEINEKEN Entreprise, and Beverage Distributor, through its subsidiary France Boissons. The announced shutdown of SAP support on ECC version 4.5, has imposed the migration of its transactional and master data environment.
  
  Mission
  Attached to the DSI France, pilot site in the ******** project, my mission was to ca...