Jean-Pierre - Data Analyst .NET

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 the implementation of product such as Business Objects – Coda Financials for all the child company of the group.
⦁ Management of all the databases (Sql Server , Mysql and Access)
⦁ Designer and supervisor for the reporting inside the group
⦁ Definition of the group policy (security aspect) for all the child company in the group
⦁ Development of a concept to consolidate automatically informations from the child company (DB) in a DataWharehouse (OLAP Cubes) for financial analysis
⦁ Automation of the alarm procedures and control system of message through GSM and emails to the various persons in charge (.NET)
⦁ Implementation of an asset management tool for analysis of the software installed on the servers and the workstations
⦁ Study and implementation of tools of inventory of the material and programs installed on the servers and the stations customers
⦁ Responsible of network architecture network and security: definition of the standards “Groups Policy” for the installation of the routers and Firewalls
⦁ Implementation of a tool of “alignment” of the events on the various servers of the “group” (.NET)


TECHNICAL ENVIRONMENT:
VB.NET, OPManager - GLPI - Business Objects BOXI et v5.1.4 – Broadcast Agent – WebIntelligence CODA-Financial (V9 and V10e) – Windows 2000/2003 (Server and Workstation), SQL Server 7.0/2000/2005, Windows XP and Office XP, Visual Studio 6.0 (.Net), TCP/IP, Oracle 9i…), Linux, Citrix, Tm1 8.3.1 (Applix Software))


04/2001 – 02/2002 Developer
FORTIS BANK

SUMMARY : Adapt and test the Batch and TP programs


REALISATIONS :
Marketing & Term Accounts, this department is responsible for the computer management of short-term investments.
Our role was to adapt and test the Batch and TP programs on the basis of analyses to ensure that they are multi-currency, that they accept deposits made from both “CGER” and “Générale de Banque” agencies, and that deposits made from the Financial Market (FM) are integrated, these having previously been managed by other, exclusively FM programs


TECHNICAL ENVIRONMENT:
IBM OS/390, COBOL COB2, PL1, EASYTRIEVE PLUS 6.1, TSO, IMS/DLI, DB2, ISPF, MVS/ESA, ELIPS, CA - ENDEVOR, FILEAID/MVS, JCL, SDF II, ABENDAID XLS, BTSI, Microsoft Office



04/1998 – 03/2001 Team Leader / Manager , Developer
AXA/Royale Belge

SUMMARY :
This department is responsible for the computer management of standard insurance (IARD, Life, …).
Analyse the business of the different services inside the company, to know and understand the reusable objets (process and data) . Afterwards , I specified the global architecture that the company must follow to develop the different “Workflows” for different services. We deeply analysed the process and flow of the documents from it’s start to this end point of life in the “business”. Also, all the interfaces used in the different services must have a standard layout to reduce the time of programming and the time to explain how the application works and can be manipulate by the end-users

REALISATIONS :

⦁ Development of interfaces to manage all the image-document stored in a WORKFLOW architecture.

The WORKFLOW technology is streamlining the flow and management of both image-based and computer-generated information to reduce process cycle times, enhance quality, and improve accountability.
In addition, imaging solutions are eliminating paper and making it easier people to store and retrieve documents, cutting processing time dramatically and virtually eliminating bottlenecks.

⦁ Define and organize the standard in programming and structure aspect for the future WORKFLOW in the different services in the company

⦁ Development of an interface to ensure the communication between the host and the pc environment for a CALL CENTER application



TECHNICAL ENVIRONMENT:
Mainframe environment: IMS DB/DC, Micro Focus Cobol , Cics , DB2/DLI/VSAM, Easytrieve, Endevor, FileAid, AbendAid , APPC, Mqseries, MVS, RACF

PC environment: NT, Visual Studio Microsoft ( VB6.0 + C ), Oracle, Access ,SQL SERVER ,
EastMan Software , OpenImage 3.2, WinRunner, OO, UML , Appc, Mqseries, MSMQ


03/1997 – 03/1998 Team Leader / Manager , Developer
EDS

SUMMARY :
Development of a tool to analyze the source code in multiple languages

REALISATIONS :
Development of a tool to analyze the source code in multiple languages for the problem of Y2000 and Euro
conversion.
Define a global software architecture and methodology to solve all the problem independently of the language used

TECHNICAL ENVIRONMENT:
OS2/NT, Micro Focus Cobol, DB2, Easytrieve


10/1994 – 02/1997
Team Leader / Manager , Developer
TOYOTA

SUMMARY : Multiple activities on BI aspects


REALISATIONS :
TOYOTA BELGIQUE
PDO, manage all the organization of the parking when the vehicles arrived in Belgium (Antwerp)
TOYOTA MOTOR EUROPE
• PARTS
• WARRANTY
• TEN (Toyota European Network)
• ISLOG : tool to control and manage the resources on informatics projects



TECHNICAL ENVIRONMENT:
Cics, Cobol 2, DB2/DLI/VSAM, Xpeditor, FileAid, AbendAid, Endevor, Easytrieve , CA-EASYTEST, VisualGen (GUI), MVS/DOS, TSO/ISPF, RACF, MQSERIES, etc

PC environment: Os2 / NT, VisualGen(GUI), DB2, Access


05/1994 – 09/1994 Developer SWIFT

SUMMARY : Billing

REALISATIONS :
⦁ Upgrading the billing application for new feature


TECHNICAL ENVIRONMENT:
Mainframe environment: MVS, Cobol 2, DB2/DLI/VSAM, etc

PC environment: Matchintosh )

10/1993 – 04/1994 Team Leader / Manager , Developer
SAIT

SUMMARY : Tool security application

REALISATIONS :
⦁ Privileges (profile of user): creation of a tool to control and manage the privileges of the users for the different application and programs in a multinational company (Conceptual, functional aspect) .

⦁ Manage the maritime traffic



TECHNICAL ENVIRONMENT:

Mainframe environment: MVS, Cobol 2, DB2/DATACOM/VSAM, etc



02/1990 – 09/1993 Team Leader / Manager , Developer
CSC EUROPE

SUMMARY : Tool security application

REALISATIONS :
⦁ Report generator, creation of a tool to generate easily complex reports for the Authority .

⦁ Managing the removing of license to drive ( for professional drivers)

⦁ Managing the medical authorization to drive ( for professional drivers)

⦁ Synchronization of the data from national register and the data of the drivers (private and professional)

⦁ Analyze the data needed to create a centralized file for all the applications of the Ministry

⦁ Analyze all the system for the control of the drivers



TECHNICAL ENVIRONMENT:

Mainframe environment: MVS/XA, DOS/VSE, CICS, Cobol 2, DB2/VSAM, Xpeditor, Fileaid, AbendAid, Easytrieve,TELON,GRETA(phonetic),RACF etc

PC environment: OS2/Win31, Excelerator, EasyCase, Informix, Progress, Microsoft Office, etc




04/1988 - 01/1990 Team Leader / Manager , Developer
COBAC/CODAREC


SUMMARY : Centralization of data

REALISATIONS :
⦁ Managing of insurance files, centralization of all the insurance information inside an electronic solution
⦁ Creation of a system to be able to refresh automatically and manually all the information needed for the business
⦁ Report generator


TECHNICAL ENVIRONMENT:

Mainframe environment: MVS/XA, DOS/VSE, CICS, Cobol 2, DB2/DLI/VSAM, Easytrieve, RACF



04/1984 - 03/1988 Team Leader / Manager , Developer
Belgian Shell


SUMMARY : Centralization of data

REALISATIONS :
⦁ Fixed Assets register
⦁ Conversion Dos/MVS
⦁ Accounting (general ledger, purchase order, accounts payable, …)



TECHNICAL ENVIRONMENT:

Mainframe environment: MVS/XA, DOS/VSE, CICS, Cobol 2, DB2/DLI/VSAM/IDMS, Easytrieve, RACF etc