Senior BI Consultant

Senior BI Consultant

Education

Bachelor's degree in applied computer sciences

Marketing advisor

Certifications

MCTS: SQL Server 2005 Business Intelligence - 2008

MCTS: SQL Server 2005 Implementation and Maintenance - 2007

IBM Certified Solution Developer - WebSphere IIS DataStage Enterprise Edition v7.5 - 2007

Training

• § Prince 2 Project Management Methodology 2009
• § Oracle DataBase 10g Administration 2009
• § Overview of Microsoft SQL Server 2008 Business Intelligence - 2009

• IBM Cognos - 2009
• Implementing Microsoft Office SharePoint Server 2007 -  (MOSS 2007)
• Implementing Microsoft Windows SharePoint Services 3.0
• Intensive training off SSIS
• Multidimensional Modelling  
• DataStage Essentials V8  by IBM Belgium  

• § Overview of Microsoft SQL Server 2005 Business Intelligence
• § Microsoft SQL Server 2005 Analysis Services

Sectors

Bank, Insurance, Automotive, Social Secretariat, Tobacco

IT Skills

      Software                                   

SQL SERVER 2008,MS SQL Server 2005,MS Analysis Services 2005, MS Reporting Services, MS Integration services, MS Excel 2007,ProClarity, DataStage, SharePoint MOSS 2007,Oracle

Environments       Windows XP/NT/2000/2003                                                     

Lagunages            ASP.net, VB.net                                                                       

Data Base              SQL SERVER 2008, SQL Server 2005, Oracle 9i,Oracle 10i       

   Tools & Applications:

• SQL Server Business Intelligence Development Studio
• Microsoft Visual Studio 2005, Microsoft Visual Studio 2008
• Microsoft Visual Studio.NET 2003
• Microsoft Visual SourceSafe
• IBM DataStage designer, Manager, Director and DataStage Administrator

Experience

BI Senior Consultant -                    Imperial Tobacco                                       Dec 2008 - March 2009

• Building OLAP Cube with Analysis Services (SSAS 2005)
• Producing reports from OLAP(Cube) with Reporting Services (SSRS 2005)
• Intensive use of MDX

Tools:

• SQL Server Business Intelligence Development Studio
• SQL Server Reporting Services 2005
• SQL Server Analysis Services 2005

ETL Architect / Project Manager -   ALLIANZ INSURANCE (AGF)               March 2008 - Nov 2008

http://www.allianz.be/

Building data Warehouse for Insurance department

• Developing data naming standards
• Ensuring architectural Best Practices
• Analyzing source systems and creating a mapping to the target database schema
• Defining and implementing the required business transformation rules and logic (ETL development)
• Designing and developing exception handling and data cleansing / standardization procedures
• Optimizing ETL performance
• Assessment and recommendation of ETL tools
• Review conceptual data model, data mappings to ensure adherence to stakeholder and internal team needs
• Defining a suitable architecture for data integration from multiple, disparate data sources (including legacy systems, relational databases, flat files, etc).
• Manage a team of developers
• Coaching of juniors
• Project estimation : man / day

Tools:

• SQL Server Business Intelligence Development Studio
• SQL Server Integration Services 2005
• SQL Server 2005
• CA ERwin® Data Modeler
• SharePoint

BI Microsoft Developer -   SIGI - Luxembourg                 Jan - Feb 2008

http://www.sigi.lu/

• Building OLAP cube with Analysis Services (SSAS 2005)
• Creating Calculation
• Producing reports from MS Analysis Services 2005 with Reporting Services (SSRS 2005
• Publishing Reports in SharePoint

Tools:

• SQL Server Business Intelligence Development Studio
• SQL Server Reporting Services 2005
• SQL Server Analysis Services 2005
• SharePoint 2007

DATASTAGE DEVELOPER -   Moët & CHANDON - EPERNAY FRANCE                  Sep - Dec 2007

http://www.mhis.fr/

• - Processing the data (coming from SAP R/3) in a DataStage server job
• - Creation and modification of Flux
• - Updating jobs and sequences with new business roles
• - Creating a new jobs and sequences
• - Validates, runs and monitor jobs using DataStage Director
• - Deployment
• - Writing script to CREATE table, UPDATE table, ALTER table, ADD columns, DROP or MODIFY columns.

- Writing documentations: describe all change made to jobs and sequences

Tools

• - DataStage 7.5
• - TOAD 7.5 to:

-  build, test, and debug PL/SQL packages, procedures, and functions

-  create and edit database tables, views, indexes, constraints, stored procedures

- File Zilla

Database: ORACLE 9i

Environments: Windows / UNIX

Reporting Services SPECIALIST -   TELINDUS                 May - June 2007

http://www.telindus.com/

• Developing reports for Help Desk service(Clarify database) using SQL Server Reporting Services 2005
• Reports use only Stored Procedure, no code inside reports
• Only Dynamic SQL is used by reports, which allow a SQL statement to be created on-the-fly by a user to satisfy, the particular query requirements for that particular situation.
• Dynamic WHERE Clause, Dynamic FROM Clause, Dynamic SELECT Clause

Tools:

• SQL Server Business Intelligence Development Studio
• SQL Server Reporting Services 2005
• SQL Server 2005, SQL server profiler, SQL Query Analyzer

Internal project based on Microsoft BI solution       April 2007

Building solution to manage consultants' Timesheet

• Building data warehouse
• Extracting data from excel files(Timesheet) and fill data warehouse using SSIS 2005
• Building OLAP cube with Analysis services (SSAS 2005)
• Creating KPI
• Developing Reports from OLAP with Reporting Services (SSRS 2005)

 BI consultant - Aquafin                         Mars 2007

Proof of concept with Microsoft BI technology: to compare with the functionalities of the existing BO platform.

Developing reports using Reporting services 2005

Tools:

• SQL Server 2005
• SQL Server Business Intelligence Development Studio
• Proclarity
• Excel 2007

Major projects as freelance - Previous Business & Decision  

Reporting Services SPECIALIST -   belgian Post Group      SEP - OCT 2006

http://www.post.be/site/en/index.html

• Migration of reports from Excel to reporting services 2005
• Developing reports (Peregrine database) using SQL Server Reporting Services
• Reports use only views and stored procedure, no code inside report
• Developing an application to access reports in ASP.NET 2.0

(TreeView, Multilanguage, Management of Reports favorites (add to favorites & Remove From favorites) ASP.NET 2.0 and VB.NET 2.0 and Web Services

Tools:

• Microsoft Visual Studio.NET 2003
• SQL Server Reporting Services 2005
• SQL Server 2005
• SQL Query Analyzer

Reporting Services SPECIALIST - CAREWORKS Ltd - dublin      JUNE - JULY 2006

http://www.careworks.ie/

• Developing professional reports using SQL Server Reporting Services.
• Authoring reports using the Report Designer. Deploying and publishing reports.

Tools:

• Microsoft Visual Studio.NET 2003
• SQL Server Reporting Services
• SQL Server 2000
• Microsoft Visual SourceSafe

Reporting Services Specialist - PHILIP Morris Benelux             MARCH - Mai   2006

• Developing professional reports using SQL Server Reporting Services.
• Authoring reports using the Report Designer. Deploying and publishing reports.

Tools:

• Microsoft Visual Studio.NET 2003
• SQL Server Reporting Services
• SQL Server 2000
• Microsoft Visual SourceSafe

Quality assurance (QA), TESTING -     Deutsche Bank / IBM    october 2005 - December 2005

• Quality Assurance (QA), Testing, Security (ASP Web application)
• DTS (Data Transformation Services)
• Data Warehouse
• Download from AS400 Files to SQL Sarver tables (BCP, DTS)
• Tables, Views, stored procedures ,Query Sql
• User Defined functions (SQL SERVER )
• Cleanup Database , Shrinking Database
• COM /DCOM (DynaShield Tools By Euricom)

Tools:

• Microsoft Visual SourceSafe 6.0 ,SQL Server 2000, DynaShield

 Analyst    Consultant -          FIAT AUTO BELGIO                            January 2003 - July   2005

• Analyse for reporting system
• Developing budget management web application in asp.net and VB.net that help different departments to manage their budget and forecast.
• Clean code separation using user controls and class libraries for business logic.
• Data extraction and reporting, stored procedures for SQL Server 2000 database
• Migration of an existing Clipper application to Asp.net 1.1.
• Programming in VBA for Microsoft Office 2000 (Excel)

Tools:   Microsoft Visual Studio.NET 2003, Crystal Report, SQL Server 2000, Access

ASP.NET, VB.NET, ASP, Vb script, Java script   - January 2002 - December   2002

• IT Consultancy at Fiat Auto Belgium.
• IT Consultancy at http://www.mondiala.com/

Consultant      EUROPEAN COMMISSION       Dec 2000 - Dec 2001

Working Language: English

• Designed, implemented, deployed and updated the official website for TAIEX (Directorate-General:Enlargement. European Commission) http://taiex.cec.eu.int/ (The website has now been renovated).
• Modification of forms and SQL tables so that they accept the alphabet of Eastern Europe while using the UNICODE
• Animated pre-loader using Flash technology.
• Developing web Site : http://ccvista.taiex.be/ using CCVISTA (The CCVista Database has been created to store translations into the languages of candidate countries of EU measures. The main functions are uploading and downloading translated texts, but it is also possible to download original acts in English

Clipper 5.2 & Visual Basic Developer                                                                                                 1998 -2000

Fiat Auto belgio - Group S(Social Secretariat)   - ZA Verzekeringen(Antwerp)

• Adapting the application to the EURO
• Adapting the application to the year 2000 (Y2K)

Visual Basic, Clipper   Developer          GDS                                                         1988 - 1998    (10 years)

• Technical

Technician in data processing (Hard & Soft)

• Programming

  Different applications in Clipper and Visual Basic

Additional Information

Languages:

• French: excellent.
• English: fluent.
• Arabic: native Language.
• Dutch: basic