CV/Mission d'Expert Business Objects Data Services freelance

Exemple de missions de Jean-Pierre,
Expert Business Objects Data Services habitant ?

• Project Manager

  Diebold Nixdorf
  Jan 2021 - aujourd'hui

  SUMMARY :
  PMO (Implementation of Quicbase product) to do the follow up of different projects accross the teams
  
  REALISATIONS :
  Implementation (design, configuration ,...) of tools such as Quickbase (lowcode application based on relationnal database) and/or Fastfield (currently the different teams are using excell shits or acccess, etc.

• Business Data Analyst

  Match & SMatch
  Jan 2020 - Jan 2021

  Study of the architecture in order to implement a new data lake (+datamarts) and definition of the various processes (ETL/ELT), reports and dashboards
  
  REALISATIONS :
  - the contract is stopped, no budget allocated for the next phase

  TECHNICAL ENVIRONMENT: Sqlserver (SSIS,SSRS) , Postgressql, Oracle , Qlickview , Power BI, T-SQL, Power designer, Scripting, ETL,Microsoft office, Visual studio 2019 (.NET VB & C#, Framework 4.5 et 4.6), DevOps, Agile, Kimball and Data vault …

• Reengineering Confédération Construction
  Jan 2019 - Jan 2020

  SUMMARY : Reorganization of the IT processes in place and development of
  a documentation of the existing ones.
  Definition of the evolutions to be implemented in order to ensure a better vision
  and a more efficient production.
  
  REALISATIONS :
  - Dba Sybase (874 tables, not standardized, definitions of "business functionality" of triggers implemented on the tables)
  - PowerBuilder Developer
  - System documentation
  - Application documentation
  - Processing documentation on request (+-500 procedures sql)
  - Documentation of the procedures to be followed at the server level (Shutdown, restart of servers)
  - Setting up a WIKI
  - Implementation of a warning system (Detect as soon as possible the absence of files)
  - Implementation of a system for processing operational files as soon as they arrive
  - Assistance in the migration of existing data to a CRM (Efficy)
  - Set up export/import processes inside and outside Sybase
  - Management of required authorizations at the application level + attempt at automation
  - Etc...

  TECHNICAL ENVIRONMENT: Sqlserver , Sybase, Oracle , Powerbuilder 2017 , Visual Expert , Power designer, Scripting, ETL…

• BI Expert

  BUYWAY
  Jan 2018 - Jan 2018

  SUMMARY : Handling internal procedures and setting up new procedures (ETL automation)
  
  REALISATIONS :
  Rethink the processes in place to have an exact view of the treatments required for the business
  
  Improvements in inter-team communication
  
  Process developments (via Talend, VBA, ...)
  
  Analysis and upgrading of realized processes and governance for future development
  
  Consolidation of business needs and improvement of the development approach
  Getting started and optimizing the procedures for controlling financial movements of atypical nature
  Guarantee, that all movements are off 'laundering' or fraud

  TECHNICAL ENVIRONMENT: Sqlserver , Oracle, BO XI 4,1 , Scripting, Talend (ETL) …

• Expert ETL process

  RBC
  Jan 2017 - Jan 2017

  SUMMARY : Support for the dataLake project by managing the data extraction process to make it more efficient
  
  REALISATIONS :
  ⦁ Development of Crystal report
  ⦁ Development of a tool (powershell) to “Split” excel sheet to multiple excel sheet base on parameters defined by the end-user

  TECHNICAL ENVIRONMENT: Sqlserver 2008, Oracle, SYBASE, Crystal Report , Powershell , SAP BODS, Vbscript, …

• Data Exchange Manager

  SABCA
  Jan 2016 - Jan 2017

  SUMMARY : Automate and ensure the archiving and complete traceability of data exchange
  In order to automate and ensure the archiving and complete traceability of the following data exchanges, a tool should be developed.
  • Sending data to external companies.
  • Receiving data from external companies.
  
  REALISATIONS :
  ⦁ Conception, design and development of a software for exchanging technical documents (CAO) with high security with the customers.
  ⦁ Ensure the traceability off all trade entry and exit.
  ⦁ Creation of the database and the application software in an user friendly approach
  
  The feasibility study and the specifications were handed over to the management.
  Development not yet decided.

  TECHNICAL ENVIRONMENT: Mysql, Sqlserver 2008, Oracle, Windev, WebDev, Visual Studio 2015, Vbscript, …

• Powershell Developper

  IS4F
  Jan 2016 - Jan 2016

  SUMMARY : Conception and development of scripts for automatic installation of Sqlserver
  
  REALISATIONS :
  Conception and development of scripts for automatic installation of Sqlserver (Engine, SSIS,SSAS, SSRS) on Vm Machine for Belgium and Luxemburg

  TECHNICAL ENVIRONMENT: Windows Server 2008 R2, Sqlserver 2008/2012 and 2014

• Expert-conversion LUMINUS
  Jan 2016 - aujourd'hui

  SUMMARY :
  Feasibility study of a conversion of an access application to Access and Sqlserver 2012
  REALISATIONS :
  Feasibility study of a conversion of an access application to Access and Sqlserver 2012

  TECHNICAL ENVIRONMENT: Access, Sqlserver 2012