Eric - Analyste Business et Fonctionnel - Data
Ref : 130109C001-
24000 PERIGUEUX
-
Data Analyst, Business Analyst, Chef de projet (53 ans)
-
Totalement mobile
-
Mandataire social de sa structure Freelance (SARL, SAS, EURL, etc)
Expérience professionnelle
30 years’ experience in IT.
Possible roles :
Business Analyst –business cases analysis and translation, testing and validation, quality checks
Functional Analyst – operational and B.I. data models analysis and creation, processes and flows description
Product Owner – team management, knowledge and decisions, prioritization and communication
Eric ******** - Main missions since 2011
Data analysis, data
outflows
ING – with Blue Soft (FR)
Paris, FRANCE
From 03/2023
Business / functional analysis
Regulations analysis
Requirements
Coordination
Data profiling
Testing
Agile
Data governance
ING, Retail and Wholesale Banking.
Part of the Data Management Tribe, as Business Analyst :
responsible for functional data knowledge and End-to-End data
processing for populating local data repositories and cross-border
Data Lake. Link between Data Lake data / Data Lake sourcing data
and Business Data Consumers (KYC, regulatory reporting, …).
Creating functional specifications, towards Dev Engineers / Dev Ops,
describing outflows upon target business requirements about
transactions, party and accounts data, …
International context, all meetings and documentations in english
Oracle SQL Developer
IBM Infosphere
IBM BDW
Sharepoint / Confluence
Data migration, coordination
MLOZ – with Kalytech (BE)
Brussels, BELGIUM
03/2022 to 01/2023
Business / functional analysis
Requirements
Data profiling
Testing
For MLOZ – Social Security, implementing a data migration program,
from an external system to in-house databases :
• Roles
o Business Analyst
o Coordinator of the internal analysts team (+/- 25 people)
o Coordinator of exchanges with sourcing system people
• Activities
o Understanding in-house systems and data models
o Understanding sourcing systems
o Organizing workshops and documentation
o Involving data experts and coordinating them about requirements production
o Reviewing produced analyses
o Ensuring progress visibility
iSeries (IBM DB2)
DBeaver
Sharepoint / Confluence
Teams
Jira
SQL
Data analysis, data
outflows
IQVIA – with Visser & Van Baars
Brussels, BELGIUM
01/2019 to 09/2021
Business Intelligence context
Business / functional analysis
Business workshops
Requirements
Coordination
Team management
Data profiling
Data modelling
Testing
Agile
Data governance
For IQVIA, international company in Healthcare data, staffed by UCB, international Global Biopharma company, Belgium Worldwide HQ and main production site :
• Roles of Business Analyst, Scrum Master, Technical data model designer
• Projects about creating data models and reporting on Supply Chain, Drugs production, Commercial (Sales, CRM), Documentation management, Project management data
o gathering requirements from users all over the world,
o leading projects in terms of planning (development, deliveries,
resources) / project review / coordination between
stakeholders,
o leading and supporting developers team in different
technologies with regards to data provisioning, from data
warehousing to data consumption through data virtualization
o data analysis, designing data models, designing data flows
o testing and showing
o documentation
International context, all meetings and documentations in english
Denodo
Azure DevOps
Teams
Aginity (IBM Netezza)
DBeaver
Sharepoint
(SAP ECC / SAP BW)
(Qlik Sense)
(Veeva Vault)
(Planisware)
(SAS DI)
Data analysis, data
outflows
ING – with Vivid Resourcing
Brussels, BELGIUM
07/2018 to 12/2018
Business / functional analysis
Regulations analysis
Requirements
Coordination
Data profiling
Testing
Agile
Data governance
ING, “Best Bank in the World” 2017 awarded.
Part of the Data Management Tribe, as “Customer Journey Expert” :
responsible for functional data knowledge and End-to-End data
processing, in context of UNITE project, cross-border Data Lake
creation. Link between Data Lake data / Data Lake sourcing data and
Business Data Consumers.
Creating functional specifications, towards Dev Engineers / Dev Ops,
describing outflows upon target business requirements about credit
card transactions, consumer loans, party and arrangements data,
account balances, securities and investments, FCRM (Financial
Crime Risk Management) regulatory reporting…
International context, all meetings and documentations in english
Aginity (IBM Netezza)
DBeaver
IBM Infosphere
IBM BDW
ServiceNOW
Sharepoint / Confluence
XFB / CFT
(IBM Tivoli)
MiFID regulatory
reporting, analysis
BNP PARIBAS FORTIS – with People & Technology
Brussels, BELGIUM
01/2017 to 06/2018
Business / functional analysis
Regulations analysis
Business workshops
Requirements
Coordination
Data profiling
Testing
Agile
Data architecture
Data modelling
Data governance
BNP Paribas Fortis, main Belgian bank, part of BNP Paribas group,
European and World major banking company.
In BI department, datamarts creation and regulatory reporting on
bank clients’ investments (transactions and assets), on a daily and
yearly basis with regards to European MiFID (Markets in Financial
Instruments Directive).
Daily reporting to FSMA (Belgian regulatory institution) by creating a
XML file with all previous day transactions on financial instruments :
data sourcing, data storage and tracking, file creation process, errors
handling, feedbacks and corrections handling, traceability.
Yearly reporting to FSMA (“MiFID Cartography”) about providing
figures on transactions and assets on investment products (bonds,
funds, corporate actions, commodities, deposits, …), securities
custody,… aggregating data from many systems of the bank, through
all banking entities (Retail, Private, Corporate banking, …) : business
definitions understanding and validation across bank departments
(marketing, sales, finance, compliance, …), data sourcing, data
quality, datamarts specifications, output queries.
Member of the bank data governance project, defining data
elements and their dependencies.
Meetings and documentations in english
SQL DEVELOPER
SAP POWER DESIGNER
MS VISIO
HP QUALITY CENTER (ALM)
XML
(CONTROL M)
Data Architect, analysis
and development
ATRADIUS – with Artemys
Paris, FRANCE
04/2015 to 01/2017
Analysis
Requirements
Agile
Programming
Data migration
Data modelling
Atradius is world’s number 2 in credit insurance and bonding for
companies.
The project is the implementation of a new software for all Atradius’
units in Europe. I was dealing with French data and documents
migration : source data analysis, functional workshops, documents
production (Editique) and storage (DMS) processes / business
workflows, gaps analysis, source/target mapping, scripts encoding,
…
As data architect, supporting Business Analysts in their
requirements specifications and challenging the editor in its solution
design (functional and data model)
International context, all meetings and documentations in english
PL/SQL
NATSTAR (Natsystem)
ENTERPRISE ARCHITECT
WEBOND (editor RGI)
REDMINE
TOAD
BIZAGI
Project management,
analysis and development
PRIMONIAL PARTENAIRES, (PRIMONIAL group)
Paris, FRANCE
02/2013 to 01/2017
Specifications
Programming
Support
Project management
Team management
Primonial Partenaires is a main French company offering services to
insurance and patrimonial management independent agencies.
Analysis and development of a financial assets and insurance
contracts management under 4D environnement.
Application maintenance with ATALOGIC team
4D
Analysis and development GIFI – with Consultime
Villeneuve sur Lot, FRANCE
09/2014 to 02/2015
Analysis
Specifications
Programming
ETL
ERP migration, needs analysis, purchase, supply and documentation
processes, business workflows, interfaces specifications.
Générix
Streamserve
PL/SQL
Datastage
MS Visio
Analysis and development CULTURA – with Eurogiciel
Bordeaux, FRANCE
04/2014 to 08/2014
Analysis
Specifications
Programming
ETL
ERP consulting, business workflows, skills transfer and
accompaniment in the evolution of the internal solutions
Générix
Streamserve
PL/SQL
VBA
MS Access
SSIS
MS VISIO
Analysis and development Proconsultant Informatique
Metz, FRANCE
05/2013 to 04/2014
Programming
Support
4D upgrade towards v13 for commercialised home made
applications, new 4D objects implementation, try-outs and tests, old
code conversion, interfaces, application architecture design.
4D
Windev
Analysis and development Bossi Industries, Sobeval (VanDrie group)
Dordogne, FRANCE
04/2013 to 09/2015
ETL
Business Intelligence
Programming
Modelling
Datawarehouse, ETL, reports and datasheets development and
maintenance under MyReport.
Windev
MyReport
SQL Server
Project management,
analysis and development
LCA environmental lab
La Rochelle, FRANCE
11/2011 to 11/2012
Project management
Programming
Skills transfer
Release StreamServe SP5 Persuasion projects for the edition of the
environmental analyses reports, skills transfer and accompaniment
in the evolution of the internal solutions of activity and traceability
management in the reports production processes.
LIMS (editor Altik)
Windev
Oracle
MySQL
SQL
PL/SQL
StreamServe
Eric ******** – Employee experience
ICT manager LCA environmental lab
La Rochelle, FRANCE
03/2009 to 06/2011
2 years +
Project management
Team management
Projects development
Coordination
IT team coordination
Software development
LIMS integration and interfaces
Reporting solution implementation
LIMS (editor Altik)
Windev
4D
Oracle
MySQL
SQL
PL/SQL
StreamServe
VBA
ERP project leader ABF (AZNETWORK group)
Alençon, FRANCE
09/2007 to 02/2009
1,5 year
ERP integration
Functional analysis
Multilingual
Editique
Project management
Integrating ERP Générix (supply chain) to clients’ Information System
oSésame group, Thouars (France)
oEd, Vitry sur Seine (France)
oProxis group, Brussels (Belgium)
oClub group, Brussels (Belgium)
Générix
StreamServe
Oracle
SQL
PL/SQL
VBA
MS Access
Project leader JVS-ADIX (JVS group)
Alençon – Metz, FRANCE
05/2004 to 08/2007
3 years +
Strategy
Coordination
Analysis
Development
Responsible for the analysis, the conception and the maintenance of softwares
Leading of the teams working around these projects, mainly the water
management system (customers, meters, localisations, indexes, invoices,
payments, letters, reporting, …) previously taken over from BIA
4D
Windev
Oracle
SQL
PL/SQL
VBA
Operational leader AZNETWORK
Alençon, FRANCE
11/2002 to 04/2004
1,5 year
ERP integration
Functional analysis
Multilingual
Integrating ERP Générix (supply chain) to clients’ Information System
oGeneral Electric Healthcare, Buc (France, but international context)
oGueydon group (« King Jouet » brand), Voiron (France)
oCDG Participations (Paris / Geneva / Monaco airports shops), Paris (France)
o Belgian Sky Shops (Brussels national airport shops), Brussels (Belgium)
Générix
StreamServe
SQL
PL/SQL
VBA
MS Access
Software developer BIA
Alençon, FRANCE
02/2000 to 10/2002
2,5 years +
Analysis
Development
Improvement
Team working
Leading the software developers team. The applications were data
management oriented mainly for public services
4D
VBA
MS Access
Several activities MC Video (Paris), TF1 (Paris), Freelance (Alençon), Alençon town
hall (Alençon), FRANCE
09/1994 à 01/2000
Management
Reactivity
Training
Development
Company manager, video operator, IT freelance, Internet support VB
MS Access
HTML
Software developer KORTMAN INTRADAL, SARA LEE/DE group
Veenendaal, THE NETHERLANDS
02/1991 to 05/1994
3 years +
Helpdesk
Requirements
Programming
Experience abroad
Computers’ maintenance (software installation and hardware first level
troubleshooting resolution), production and commercial sales / deliveries
planning solutions development.
Dbase
Clipper
MS-DOS
Lotus
Eric ******** – Skills experience
Skill Details Experience
Functional Requirements specifications, Workflow design (BPM), business and technical,
training, support and manuals writing, large functional experience : bank,
retail, industry, environment, supply chain, transportation, quality, traceability,
public services, doc management, insurance, credit insurance, bonding,
pharma, …
Multilingual, french english dutch
10+
Data BI datawarehouses and datamarts building, sourcing and architecture,
business processes and data modelling, reports and datasheets
Data profiling
Data migration
10+
SQL et BDD Oracle, MySQL, MicroSoft SQL Server, Sybase, MicroSoft Access, Firebird,
Hyperfile, 4D, Dbase, IBM Netezza, IBM BDW
Queries : TOAD, SQL Developper, Aginity, DBeaver, PGAdmin
1 to 10+
PL/SQL Under Oracle 9, 10, 11, 12, Stored procedures, Functions , Packages, Triggers,
Optimisation
10+
4D From 5.5 to v15 versions, Versions upgrading, Plugins, Databases
management, File management, Client/Server applications, Windows and
MacOS development, Web Server, 4D Silver Partner
10+
Windev From 9 to 20 versions, External databases access (MySQL, Oracle, …), FTP and
emails functions, Ease of use, Reports tool, Mobility, OO programming
5+
Editique Streamserve (OpenText CCM) v4 and SP5 Persuasion versions, PageOUT,
XMLOut, StoryTeller, Overlays, Documents designing, Scripts, Main
applications connexion (ERP, CRM, internal, …), production feedback
management, sending
5+
ETL Denodo, MyReport, Datastage, data flows transformation, multiple databases
connexions (Oracle, MySQL, SQL Server, Firebird, …)
1 to 5+
Tools and
softwares
Enterprise Architect, MS Visio, Bizagi, Mantis, Redmine, ServiceNOW, SAP
Power Designer, Sparx, Eclipse, SVN, Windows and Mac OS, MS Office et
OpenOffice suites
MS Sharepoint, Azure DevOps, Teams, Confluence
VB and VBA, C, PHP, Script Shell Unix, HTML, CSS, Java
Générix ERP, Altik LIMS
Schedulers : Control M, IBM Tivoli
various
IT business processes and data analyst
Projects
Analysis and requirements, business
processes modelling
Data governance, data knowledge
Data migration, ETL
Reports and datasheets
ERP, CRM, LIMS integration
Planning, Waterfall / Agile (SCRUM)
Team management, Coordination
Databases
Oracle, MySQL, Sybase, 4D,
MicroSoft SQL Server, IBM Netezza,
IBM BDW, MicroSoft Access,
Firebird, Hyperfile, Dbase
Data manipulation
Data profiling
BI sourcing, data stores modelling
Denodo Data Virtualization
TOAD, SQL Developer, Aginity, DBeaver, PGAdmin
PL/SQL under Oracle 9, 10, 11, 12 (Stored procedures, Functions, Packages, Triggers, Optimisation)
4D
From 5.5 to v15 versions
Versions upgrading
Plugins
Databases management
File management
Client/Server applications
Windows and MacOS development
Web Server
4D Silver Partner
Windev
From 9 to 19 versions
External databases access (MySQL, Oracle, …)
FTP and emails functions
Ease of use
Reports tool
Mobility
OO programming
Editique
Streamserve (OpenText CCM)
v4 and SP5 Persuasion
PageOUT, XMLOut, StoryTeller, …
Overlays
Documents designing
Scripts
Main applications connexion (ERP, CRM, internal, …)
Production feedback
Sending
Functional
Requirements specifications, business and technical
User stories / Use cases / UML
Business workflows / processes / cases Training
Support and manuals writing
Large functional experience : bank, retail, trade import/export, industry, laboratories, environment, supply chain, quality, traceability, public services, doc management, credit insurance, bonding, pharma…
Multilingual, French English Dutch
Other skills
Languages :
SQL, OO programming, VB and VBA, C, PHP, Script Shell Unix, HTML, CSS, Java
Applications : Generix ERP, Altik LIMS
Tools and other softwares : Enterprise Architect (Sparx), SAP Power Designer, MS Visio, Bizagi, Mantis, Redmine, ServiceNOW, Control M, IBM Tivoli, Eclipse, SVN, Windows and Mac OS, MS Office and OpenOffice suites, MS Azure, MS Teams
SCHOOLING
1991 Application development diploma, Obtained in the Netherlands, Amersfoort / Utrecht, validated by the french Ministery of Education.
1989 Baccalauréat E serie (maths – technical), Lycée Alain
– Alençon - FRANCE
SKILLS
Spoken foreign languages : french, english, dutch.
Known foreign languages : spanish, german, Italian (learnt but no current practice).
B driving licence.
Leisure : fencing, photography.