Fethi - Administrateur système SAP BUSINESS EXPLORER
Ref : 200226E001-
4031 LIEGE (Belgique)
-
Administrateur système, DBA, Business Analyst (57 ans)
-
Totalement mobile
-
Freelance
Expérience professionnelle
SEP 2020 – PRESENT
STAGE BIG DATA CONSULTANT & BI, TECHNOFUTUR TIC
ETL: Extraction, transformation and loading of data with SQL Server SSIS
Design and management of OLAP cubes with SQL server SSAS,
Data analysis and Reporting with PowerBI, QlikView and QlikSense and Serveur SSRS,
Big Data, Hadoop, Map Reduce, Mongo DB, Machine Learning and Data Mining.
JAN 2020 – JUL 2020
BI SYSTEM ENGINEER CONSULTANT, ING BANK ( MICROPLE ) - BRUXELLES
- Technical analysis and architecture of the target platform
- Architecture and user support in the development of applications of decision support.
- Workload estimation, specifications, planning
- Project Management & Change Management
- Coordination of IT and business teams
- Installation, configuration, maintenance and monitoring SAP Business Intelligence
- Implementation Content management plan, security model, levels security, Active Directory
Single Sign On Integration
- User security and access rights
- Synchronization Load Data and the Scheduler Reports
- Recruitment and selection and Training of new colleges
- Analyses of structural needs and dysfunctions and their problem-solving
- Developing, implementation, maintaining and distributing Universes.
JAN 2017 – DEC 2019
BI SYSTEM ENGINEER CONSULTANT, ING BANK (MPOWER PLUS) - BRUXELLES
- Technical analysis and architecture of the target platform
- Architecture and user support in the development of applications of decision support.
- Workload estimation, specifications, planning
- Project Management & Change Management
- Coordination of IT and business teams
- Installation, configuration, maintenance and monitoring SAP Business Intelligence,
Information Steward
- Implementation Content management plan, security model, levels security, Active Directory
Single Sign On Integration
- Installation of SAP Business Intelligence 4.2, Objective : Migration 2000 reports, 100
Publications, 240 univers, 4500 users :
- User security and access rights
- Synchronization Load Data and the Scheduler Reports
- Migration of existing reports
- Testing, Training of IT & business team
- Recruitment and selection and Training of new colleges
- Analyses of structural needs and dysfunctions and their problem-solving
- Setting deadlines, follow-up, deontology and achievement of objectives
- Developing, implementation, maintaining and distributing Universes
- Creation Desktop Intelligence and Web Intelligence report on Business Objects
SEP 2016 – DEC 2016
BI SYSTEM ENGINEER CONSULTANT, BPOST (PROCARUS) - BRUXELLES
- Installation, configuration and maintenance, platforms optimization in terms of
performances and stability SAP Business Intelligence and SAP Data Services 4.2.
- Management of BI4, DS servers and BI applications on Windows and on Linux OS.
- Security Level Management Business Intelligence.
JAN 2006 – DEC 2015
SENIOR BUSINESS INTELLIGENCE, BPOST - BRUXELLES
- Installation, configuration, maintenance and monitoring SAP Business Intelligence, SAP
Data Services, Information Steward, Lifecycle Management and SAS.
- Implementation Content management plan, security model, levels security, Active
Directory Single Sign On Integration
- Installation of SAP Business Intelligence 4.1
- Objective : Migration 2000 reports, 100 Publications, 240 univers, 1800 users :
- Technical analysis and architecture
- Installation of the software and Administration Console
- Installation of the products 360°
- User security and access rights
- Developing, implementation, maintaining and distributing Universes
- Creation Desktop Intelligence and Web Intelligence report on Business Objects
- Create data model according to user's request.
- Architecture and user support in the development of applications of decision support.
- Database Administrator Oracle.
- Migration of BO 6.5 to BO XI v3.1
- Feasibility study
- Analysis of the existing environment : source data, reports, dashboards
- New business requirements
- Architecture of the target platform
- Workload estimation, specifications, planning
- Project Management & Change Management
- Security and Administration
- Installation of BO XI 3.1 server and clients, LiveOffice 12.1
- Automated deployment package
- Migration of existing reports
- Testing, Training of IT & business team
- Recruitment and selection and Training of new colleges
- Analyses of structural needs and dysfunctions and their problem-solving
- Setting deadlines, follow-up, deontology and achievement of objectives
JAN 2006 – DEC 2009
JUNIOR DATABASE ADMINISTRATOR ORACLE, BPOST - BRUXELLES
- Responsibilities include designing, implementing, and maintaining the database system;
establishing policies and procedures pertaining to the management, security, maintenance,
and use of the database management system.
- Responsible to develop and maintain the databases of the organization
- Build up the database architecture and models
- Design the schemes, permissions and tables for database as appropriate for its use
- Install, configure and upgrade the server to suit the database needs
- Design automated systems to mine information and make reports
- Provide inputs for developing newer versions of databases customized to peculiar need
- Include objects in database like tables, views, functions, triggers, etc.
DEC 1998 – DEC 2005
MAINFRAME PROGRAMMER, BPOST - BRUXELLES
I was part of the Infrastructure BI team. I was responsible for the installation of applications
in Acceptance and Production environments. The applications were functional BS200
applications where the technology was COBOL. I also managed and maintained Job Control
Language (JCL). Apart from the installation, maintenance of the applications, resolution of
problems, incident management, analysis of issues, performance tuning and giving support to
the development team when needed, the role also involved documentation of the process,
best practices, etc. Working in an operational environment meant that I had to be flexible
and stress resistant with continuous improvement in mind.
MAJOR EXPERIENCES
Last mission : Implementation SAP Business Intelligence 4.2 and Upgrade DBaaS
PROJECT UPGRADE CMS SYSTEM DATABASE TO DBAAS
Dates 2020
Sector / CustomerING Belgium – Micropole
Function SAP Business Intelligence Consultant
Activities
Migration of BI4.1 to BI4.2 SP8
Feasibility study
Analysis of the existing environment
Workload estimation, specifications, planning
Implementation
Upgrade CMS System Database from Oracle 11 to DBaaS
Environment BI 4.2, Oracle 11g, DBaaS,Windows Server
PROJECT Installation and Migration 4.2 SP8
Dates 2020
Sector / CustomerING Belgium – Micropole
Function SAP Business Intelligence Consultant
Activities
Migration of BI4.1 to BI4.2 SP8
Feasibility study
Analysis of the existing environment
Workload estimation, specifications, planning
Implementation
Project Management & Change Management
Coordination of IT and business teams
Installation BI4.2
Migration of existing reports, universes and groups
Configuration service BI
BI Level 3 Support
Environment BI 4.2, Oracle 11g, Windows Server
PROJECT Installation and Migration 4.2 SP6
Dates 2017
Sector / CustomerING Belgium,- MPower Plus
Function SAP Business Intelligence Consultant
Activities
Migration of BI4.2 to BI4.2 SP6
Feasibility study
Analysis of the existing environment
Workload estimation, specifications, planning
Implementation
Project Management & Change Management
Coordination of IT and business teams
Installation BI4.2
Migration of existing reports, universes and groups
Configuration service BI
BI Level 3 Support
Environment BI 4.2, Oracle 11g, Windows Server
PROJECT Installation SAP Data Services 4.2
Dates 2015
Sector / CustomerBPost
Function Senior SAP Business Intelligence Consultant
Activities
Migration of BODS 3.2 to BODS 4.2
Feasibility study
- Analysis of the existing environment
- Architecture of the target platform
- Workload estimation, specifications, planning
Implementation
- Project Management & Change Management
- Coordination of IT and business teams
- Installation of BODS 4.2 server and clients
- Migration of existing Data Flow and Data Store
- Configuration Job Servers
Environment BODS, Oracle 11g, Windows Server, Linux, UC4
PROJECT Virtualizing SAP BusinessObjects 3.1
Dates 2014
Sector BPost
Function Senior SAP Business Intelligence Consultant
Activities
Installation and Virtualizing SAP BusinessObjects 3.1 SP6
Objective : Virtualizing SAP BusinessObjects
Proposition of the new platform architecture
Installation of the software and Administration Console
User security and access rights
Data integration from Oracle database
Development of user Universes and reports
Environment BOE, CMC, CMS, InfoView, MS Active Directory, Oracle 10g, Windows Server
PROJECT SAP Business Intelligence 4.1 PILOT PLATFORM
Period 2014
Sector / Customer BPost
Function Senior SAP Business Intelligence Consultant
Activities
Installation SAP Business Intelligence 4.1
Objective : Migration 2000 reports, 100 Publications, 240 univers, 1800 users :
Technical analysis and architecture
Installation of the software and Administration Console
Installation of the products 360°
User security and access rights
Synchronization Load Data and the Scheduler Reports
Environment BI, CMC, CMS, Explorer, MS Active Directory, Oracle 11g, Windows Server
PROJECT Virtualizing SAP Data Services 3.2
Dates 2013
Sector BPost
Function Senior SAP Business Intelligence Consultant
Activities
Installation and Virtualizing SAP Data Services 3.2
Objective : Virtualizing BODS
Proposition of the new platform architecture
Installation of the software and Administration Console
Data integration from Oracle database
Configuration Job Servers
Implementation Scheduler UC4
Environment BODS, Oracle 10g, Windows Server, Linux, UC4
PROJET ENTERPRISE PERFORMANCE MANAGEMENT (EPM) PEOPLESOFT
Period 2012
Client / Sector BPost
Function Senior SAP Business Intelligence Consultant
Context Datawarehouse
Activities
Analysis of business data
Load and transformation of data into new datawarehouse
Scripting in SQL, PL/SQL
Development under Oracle Application Designer
Maintenance of user Univers : Budget, Cost Accounting, HR
Maintenance of user reports
Test plan
Environment Data Services 3.2, BO, Oracle Designer, PL/SQL, PeopleSoft EPM, Toad
PROJET FINANCIAL DATAWAREHOUSE IMPLEMENTATION
Period 2011
Client / Sector BPost
Function Senior SAP Business Intelligence Consultant
Context Datadarehouse
Rôle
Load of operational data
Automation of processes
Training of IT support team
Migration of 1200 business reports
Test plan
User acceptance & training
Activities Windows, Business Objects Entreprise v6.5, Webi, BODI 3.1, SQL Server 2000, SQL
PROJECT Installation SAP Data Services 3.2
Dates 2010
Sector BPost
Activities
Migration of BODS 3.1 to BODS 3.2
Feasibility study
- Analysis of the existing environment
- New business requirements
- Architecture of the target platform
- Workload estimation, specifications, planning
Implementation
- Project Management & Change Management
- Coordination of IT and business teams
- Installation of BODS 3.2 server and clients
- Automated deployment package
- Migration of existing Data Flow Data Store
- Configuration Job Servers
Environment BODS, Oracle 10g, Windows Server, Linux, UC4
PROJET BUSINESS OBJECTS MIGRATION
Périod 2009
Client BPost
Rôle Analyst, BI System Engineer
Activities
Migration of BO 6.5 to BO XI v3.1
Feasibility study
Analysis of the existing environment : source data, reports, dashboards
New business requirements
Architecture of the target platform
Workload estimation, specifications, planning
Implementation
Project Management & Change Management
Coordination of IT and business teams
Security and Administration
Installation of BO XI 3.1 server and clients, LiveOffice 12.1
Automated deployment package
Migration of existing reports
- Testing, Training of IT & business team
Environment BO 6.5, BO XI 3.1, LiveOffice 12.1, Oracle 10, Oracle SQL Developer
PROJECT BUSINESS OBJECTS – PILOT PLATFORM
Period 2008
Client / Sector BPost
Context Management Reporting
Rôle BI System Engineer
Activities
Presentation to target users of reporting tool functionalities
Interviews of key managers, workshops
Definition of the perimeter of the pilot platform
Creation of key reports
Presentation to top management
Environment BO XI 3.1 Edge, Designer, Infoview, WebI, BO Explorer, Xcelsius, LiveOffice, CMC
EDUCATION
JUN 1995
BACHELOR'S DEGREE, INFORMATION TECHNOLOGY, HAUTE ECOLE DE LA
PROVINCE DE LIEGE 'RENNEQUIN SUALEM'
JUN 1988
BACCALAUREAT MATHEMATIQUE ET TECHNIQUE, LYCEE TECHNIQUE DE
SOUSSE 2 MARS 1934 - TUNISIE
TRAINING
2020 : Training BI & Big Data Consultant - Technofutur TIC, Gosselies
2016
Training cisco certified network associate - ccna
English training course
2014
SAP Business Objects Business Intelligence Platform: Administration and Security; SAP; Belgium; SAP; Belgium
2012
Linux System Administrator; EGILIA; France
2010
Business Objects Security and Portals , SAP NetWeaver BW BO integration; SAP; Belgium
2009
Sap Data Services, Data Quality and Data Profiling, Xcelsius for Administrators; SAP Belgium
Oracle 9i DBA Fundamentals, Oracle; Belgium
EDUCATIONAL HISTORY
1995/1997 : Master in Computer Science; ULG
1992/1195 : Graduate Information Technology; ISET Liège
1989/1992 : Master Physical Chemistry; University Science Monastir
1983/1989 : Baccalaureate Mathematics and Technology; Lycée Technique Sousse Tunisia
Technical Skills
Tool Competence Rating (1=basic, 5=excellent)
SAP Business Objects 3.1, Business Intelligence 4.1 4
SAP Data Services 4.1 4
Business Intelligence Architecture 4
Metadata Management , Information Steward 4
Lifecycle Management 4
Dashboard ; Xcelsius 4
Oracle administration, PL/SQL, ETL and Data Model 3
SAS Reporting 3
Unix, Linux 3
Windows Server 3
SAP BusinessObjects Design Studio 3
Active Directory, Single Sign On 3
Tortoise Subversion Versioning Tool, WinScp FTP Tool 3
MiddleWare Tools: Tomcat/Java 3
LANGUAGE SKILLS
French, Arabic Mother tongue
English Fluent.
Dutch Basic knowledge