Smain BOUKHARI

En résumé

Entreprises

• Société Générale - Senior BI Consultant and responsible business object restitution team

  PARIS 2014 - maintenant

• Nissan Europe - Senior Consultant BI

  2014 - 2014 The purpose of the project is to provide a unique and integrated New Customer Database to support the Loyalty Program while maintaining RBUs flexibility and autonomy in terms of local CRM activities.
  Within this global project, the data management stream has to feed the data in the entire system.
  
  Writing and updating of general functional specification
  Evolutionary maintenance of developments(informatica, Data Quality)
  Treatment Analysis and Writing impact studies.
  Redaction and Updating SFD and SFG.
  
  
  Environment: Informatica Power Center 9.1,Data Quality , Oracle 11g, scripting UNIX, PL/SQL, Hp Quality Center.CRM neolane

• SCOR SE - Business Objects expert

  Paris 2013 - 2013 Responsible to
  
  Ensured the support BOXI R3 level 1 and level 2
  Monitoring of incidents on SPIRA tool (200 users worldwide)
  Participation in DESKI Reports Migration Project in Webi
  Development and updating of reports
  Realization of workshops in collaboration with users.
  
  Environoment:, BusisnessObjects XI3.1, Spira , sap business objects reporting tools.

• APP Ministry of Justice - Consultant BI

  Levallois-Perret 2012 - 2013 APPI is an abbreviation for Application of Sentences, Probation and APPI Inserting the Data Center collects data from different areas of APPI. The infocenter APPI must meet two major areas or trades, DSJ and DAP
  
  • DSJ The Court Services Division of the Department of Justice
  • DAP is the directorate of prison administration
  
  Function Consultant BI
  Responsible to
  
  Evolutionary maintenance of developments.
  Treatment Analysis and Writing impact studies.
  Redaction and Updating SFD and SFG.
  Updating and development of reports and universe from detailed specifications.
  
  
  
  
  
  

• EDF Energy - Consultant BI

  Paris 2011 - 2012 Project TMA (Third-Party Application Maintenance) data integration from different application that feed production systems (Sprint Payroll, GA Sprint, Sprint Training) to provide reporting services, analysis and mass publication.
  
  Responsible to
  
  
  Realization the new ETL flows.
  Optimization of treatment and at INFORMATICA Database.
  Evolutionary maintenance of developments.
  Treatment Analysis and Writing impact studies.
  Redaction and Updating SFD and SFG.
  Implementation of the migration tests on Quality Center.
  Environment: Informatica Power Center 9.1, Oracle 11g, shell UNIX, PL/SQL, Hp Quality Center.
  

• L'Oréal - Consultant BI

  PARIS 2011 - 2011 Project Under the project IDG (Integrated Data Group), the objective of anticipating flow crisis is to integrate and restore data on raw material requirements (MP) in anticipation of new product launches. The ultimate goal is to provide end users, the cell Purchase, information on the cumulative amounts of MP based on dates available (MAD) of new products.
  Responsible to
  Analysis of existing BI architecture for the integration of new flows.
  Realization the new ETL flows.
  Automated processing developed.
  Establishment of production monitoring automatically.
  Preparation and organization of the implementation and testing recipes.
  Development reports and universe from detailed specifications.
  Design, production and writing of SFD and GFS.
  Environment: BusinessObjects Data Integrator 11.7, BusinessObjects XI 3.1, SQL Server 2005, Sybase Power AMC.
  

• Atos Origin International - Consultant BI

  Bezons 2008 - 2011 Project Key Indicators Warehouse Infrastructure (KIWI): Establishment of an intelligence information system that provides access to information from different business areas (fleet management, event management, activity tracking.).
  
  • Sub-project GSP: (Global services portal) Data Integration in the GSP Datawarhouse. Csv files contain the activity logs of the web portal GSP.
  
  • Sub-project CLOUD : Data Integration in the Cloud Datawarhouse. CSV files contain all information about the CPUs, Memory, and Server.
  
  • Sub-project Mainframe: Integration of mainframe data into the data warehouse, the goal is to migrate the existing reporting from Germany in the common tool.
  
  • Sub-project Time Tracking: Data integration 'Time Tracking' in the data warehouse, the objective is to correlate the time assigned by Client, Project / Sub Project, Tasks with the number of tickets resolved and / or closed.
  
  • Sub-Project gestion des catalogues : integration of data management in catalogs KIWI.
  
  • Sub-project Ticketing : Integration of data in the data warehouse Ticketing, the objective is to consolidate the data into a single reporting (events, telephony, fleet management, activity tracking, ...
  
  Function Consultant BI
  Resposible to Realization of power mappings (ODS, data warehouse, Datamart).
  Modeling and Design of functional specifications in English.
  Preparation of data sets, performing tests, fault management.
  Workflow management and Monitors.
  Production implementation developments (export, import, parameter file, script).
  Realization of English documentation (detailed specification, record production, delivery).
  Evolutionary maintenance of developments.
  Optimization of treatment and at INFORMATICA Database.
  Daily monitoring of treatment in production and management of incidents.
  Team meetings in English.
  Coaching India on the tool KIWI.
  Environment: Power Center Informatica V8.1, Oracle 10G, SQL Server 2005, Mysql, TOAD, BusinessObjects XI R2, Scripts VB.
  
  

Formations

• Université Paris XIII Nord

  Villetaneuse 2006 - 2008 Exploration Informatique des Données et Décisionnel Data Mining
  
  Institut Galilée

Réseau

• Franck TROPHARDY

• Hinde BENCHANAA

• Liengie NAL

• Redouane EZZAHRY

• Roudolf Yves NDUMBE

• Sebastien LEBLIC

• Social TECHNET

• Yacine BANNOURI