Mohamed - Consultant technique SQL SERVER

Expérience professionnelle

European Commission June2013 – 15 November 2013________________________________________

DWH/BI Consultant at the DIGIT

• Designing, coding, and testing
• Perform investigations to improve Univers and Reports.
• Implementing changes on ETL jobs
• Implanting changes to Reports according to the business new requirements.
• Investigate and propose a solution to maintain metadata in order to be used by the report for
an accurate refresh of the reports.


Technical environment: Windows, Oracle 11g, BusinessObject XI3, BODI, Deski, Webi


GDF-SUEZ ELECTRABEL April 2010 – February 2013 ________________________________________
Data Architect in the Generation department
which is responsible for the production and sales of electricity for BE, DE, NL

• Data Modeling
• Define disaster , recovery and Mirroring
• Data extraction and integration from heterogeneous system e.g.: PI (collection, analyze and
hisorisation system Osisoft), MicroScada, XML
• Define Migration
• Define standards and guidelines
• Design and implementation of databases
• Strategies for performance improvement

Technical environment: Windows 2003, SQL Server 2000/2008 R2, SSIS,PI, MicroScada.


GDF-SUEZ ELECTRABEL July 2006 to April 2010
________________________________________
Data Architect the EAI department

• Data Modeling
• Disaster recovery
• Data extraction
• Data Migration
• Define standards and guidelines
• Design and implementation of databases
• Performance improvement
• Integration with Websphere
• BO reporting XI

Technical environment: Oracle 10g, DB2 10, HP-Unix, Websphere, BO XI

RECKITT BENCKISER May 2006 to June 2006
for SOPRA ________________________________________
Senior Consultant on a BI Project

• Migration from SAP to JDE and feed existing Cognos reports
• Inflow analysis
• Detailed mapping analysis
• Data extraction and feeding
• Reports creation

Technical environment: Windows, SQL Server, DTS, JDE, BO


FEDEX May 2005 to Feb 2006
for SOPRA ________________________________________
Senior Consultant on a BI Project for the sales and marketing department

• Inflow architecture design of DWH
• Detailed mapping analysis Informatica Powercenter
• Data extraction and load
• Universe creation
• Reports creation
• Reports performance improvement.

Technical environnement: Oracle 9i, BO 6.5, XI, Informatica

BANKSYS Feb 2005 to April 2005
for SOPRA ________________________________________
Senior Consultant on a BI pre-study

• Case Study
• Universe creation
• Reports creation


N-ALLO April 2004
for SOPRA ________________________________________
Consultant on a BI pre-study

• Case study: KPI’s for a Call Center
• Creation of a mock-up in Business Objects (Application F/Web)
• Create a KPI Dashboard to provide an automated Measurement tool
• Creation of a BusinessObjects universes for reports and for metrics
• Publishing of goals, creation/assignment of roles, membership and strategy with BusinessObjects StrategyBuilder.
• Development of BusinessObject WebIntelligence reports
• Development of Metrics
• Creation Universe


FEDEX July 2004 to Oct 2004
for SOPRA ________________________________________
BI Consultant

• Data Structure consistency checks between the Dev, Acc and Prod environments
• Design of Universes
• Design of reports
• BCA Scheduler, Bursting Reports
• BCA Publisher
• BusinessObjects administration (Supervisor)

Technical environment: Oracle 9i, UNIX, Windows, BO 6.5, Informatica

FEDEX April 2001 to July 2004
for CAP GEMINI ________________________________________
Integration Engineer/ DBA

Within FedEx, I was involved in Sales force Automation implementation.
From the customization of the application to the EMEA rollout and integration with the customer
legacy systems. This application is used by the sales and marketing department. I was also in charge
of the mobile solution implementation. Managing the synchronization process of one 100 off-line users.

• Oracle DBA.
• Performance tuning
• Migration from Sun Solaris to HP.
• Testing procedures.
• Shell scripting, cronjob.
• Programming Clarify VB
• SQL scripting
• Creation of Reports
• Clarify CRM SFA application customization
• Implementation of Interfaces with legacy systems.
• Administration of the client-server environment.
• Set-up and administration of the mobile databases (SQL Server) and the synchronization process.

Technical environment: Oracle 9i, UNIX, Windows, Pl Sql


IMS HEALTH STRATEGIC TECHNOLOGIES July 98 to Sept 2000 ________________________________________
DBA
Providing worldwide support for a customizable Sales Force Automation applications used by pharmaceutical industry.

• Oracle DBA.
• Data migration
• Set up development platforms for the developers.
• Set up testing platforms for the QA: Set up the server, the database, and the application,
by following a predefined testing methodology.
• Implementation of NT servers, Oracle databases, Ardent DataStage and SFA in several European
countries.
• Exchange management.
• Servers management

Technical environment: SQL Server , .Oracle 8.1, 8.5, Windows, Datastage

BELGACOM Sept 95 to July 98 ________________________________________
Support engineer

Customer support in data transmission and monitoring software.


DARELEC 92 to July 95 ________________________________________
Software engineer

• Support for hard and software.
• Design with AutoCAD
• Developing modules in LISP for AutoCAD.

Technical environment: Windows, AutoCAD, Lisp