CV/Mission d'Expert Business Objects Data Services freelance

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

EXPERIENCE

07/2021 – ……..
Project Manager
Diebold Nixdorf

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.

12/2020 – 04/2021
Business Data Analyst
Match & SMatch

SUMMARY : 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 …

01/2019 – 02/2020 Reengineering Confédération Construction

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…

02/2018 – 12/2018 BI Expert BUYWAY

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) …

09/2017 – 11/2017 Expert ETL process RBC

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, …

11/2016 – 03/2017 Data Exchange Manager SABCA

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, …

06/2016 – 10/2016 Powershell Developper IS4F

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

05/2016 Expert-conversion LUMINUS

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

09/2011 – 01/2016
Bi and Unica campaign Developer BELFIUS

SUMMARY : Multiple activities on BI aspects

REALISATIONS :
⦁ Create and maintain UNICA flows
⦁ Create and develop of ETL procedures to optimize the work of loading and unloading data
⦁ Create a data monitoring tool to analyze all the data’s used in the different campaign
⦁ Use tools of Self-Service BI (Power BI) from Microsoft
⦁ Automate ETL processes
⦁ Control as well as enrich processes and data warehousing
⦁ Optimize various Queries, performance tuning
⦁ Create programs for end users
⦁ Create and execute various test
⦁ SAS conversion process to PL/SQL
⦁ Create packages and procedures ORACLE to perform specific treatments for the marketing department
⦁ Optimize and create documentation
⦁ Communicate and share information with stakeholders and key users
⦁ Work in a team as well as autonomously
⦁ SSIS: Process of enrichment of the dwh.
SSRS: Automation of reports of enrichment

TECHNICAL ENVIRONMENT:
UNICA, Pl-SQL, ORACLE, Office , Toad, Eclipse, Sqlserver 2012, SSIS, SSRS , SSAS, ETL, Data warehouse, SQL, tables and views, VBA, .NET

02/2010 – 08/2011
BO XI Consultant and Administrator BNP

SUMMARY : Multiple activities on BI aspects

REALISATIONS :
⦁ Administration and migration of data warehousing tool from Business Object (BO) 6.5.3/4 to BO XI 3.1 SP2
⦁ Ensure and define the migration of the “repository” from SQL server 2000 to SQL server 2005
⦁ Development of an “in house” tool to manage and control the global platform.
⦁ Study and implementation of promote tool (Import-Export Wizard and Life Cycle Management [LCM]) for the different environment in place (Based on the security concept of BNPP Fortis)
⦁ Create universe and reports to give an analytical view of the system (SAP BOXI)
⦁ Generation of KPI for the manager
⦁ Design and implementation of concept of delegation to the different services or person
⦁ Development and production of an analysis process using BOXI for different services
⦁ Collecting and formatting data in SYBASE IQ, SQL Server and Oracle database
⦁ Configuration of Single-Sign-On (SSO) (WebSphere, SAP, AD, LDAP)
⦁ Standardization of the install procedures for a complete “restaging” of the different servers.
⦁ Conceptual and technical documentation
⦁ DRP policy
⦁ Clustering on BO servers and Web servers
⦁ Data integration modelling (ETL)
⦁ SSIS: Integration of the process of updating the tables and set up of the architecture of consolidation of data from internal and external services.
⦁ SSRS: Automation of reports of logging on the use of resources.

TECHNICAL ENVIRONMENT:
BO 6.5.x , BO XI R3.1, Business Objects Data Integrator, SQL Server, Oracle, Sysbase IQ, ETL, SSIS, SSRS, SSAS

05/2009 – 02/2010 BOXI administrator DTS

SUMMARY : Multiple activities on BI aspects

REALISATIONS :
⦁ Development and production of an analysis process using BOXI
for different services.

Collecting and formatting data in an Oracle database.
Creation of the universe as well as ad hoc reports Webi.

⦁ Study and development of a consolidation of events (log windows
and BO), to facilitate the management problems encountered by
users and support teams.

⦁ Synchronize documents / universes in different environments (TST,
GTU, UAT, PRD) due to problems of data consistencies in the
various CMS.

⦁ Establishment of parameters required to enable reporting of various
planning reports (package) or other.

⦁ SSIS: Integration of the process of updating the tables and enrichment of financial data.
⦁ SSRS: Control of the rich data and impact on performance. Report of "events on the serveur(incidents, services)."

TECHNICAL ENVIRONMENT:
BO XI , Business Objects Data Integrator, SQL Server, ETL, SSIS, SSAS, Content Management Systems (CMS)

03/2002 –09/2008 Network administrator and security manager , Dba, Developer SOFICOM (Eiffage)

SUMMARY : Multiple activities on BI aspects

REALISATIONS :
⦁ Responsible of network architecture network and security: definition of the standards “Groups Policy” for the installation of the routers and Firewalls.
⦁ Implementation of an asset management tool for analysis of the software installed on the servers and the workstations.
⦁ Implementation of a tool of “alignment” of the events on the various servers of the “group”
⦁ Optimization of the resources servers, in order to increase quality and available treatments within the framework of a centralized architecture.
⦁ Responsible for ...