Professional Profile

More than 18 years of local and international experience as IT consultant in different multinationals with around 9+ years in Technical Consulting in Data Warehousing/Business Intelligence space, working for company leaders such as Allianz-AGF, Belgian Post Group, Philip Morris Benelux, Deutsche Bank, Fiat Auto Belgio, The European Commission, Telindus, Imperial Tobacco, Careworks in Dublin, SIGI in Luxembourg, Moët & Chandon in France and IBM/ABN AMRO in Netherlands.
Based on this experience, I’m confident; I can fulfil all the requirements for professional projects. I am a quick learner, with strong analytical and interpersonal skills; I am energetic, self-motivated and hard working 

Languages:
  • English: fluent
  • French: native
Certifications:
  • Certificate of Attendance: Cloudera Data Analyst Training: Using Pig, Hive, MapReduce, And Impala with Hadoop - Amsterdam 2015
  • Certificate of Attendance: ETL ARCHITECTURE IN DEPTH - Kimball University by Ralph Kimball - 10-13 June 2013 – Amsterdam
  • MCTS: SQL Server 2005 Business Intelligence
  • MCTS: SQL Server 2005 Implementation and Maintenance
  • IBM Certified Solution Developer - WebSphere IIS DataStage Enterprise Edition

Skills

ETL Tools:
  • Microsoft SSIS
  • DataStage
Reporting Tools:
  • SSRS
  • Crystal Report
OLAP Tools:
  • Microsoft Analysis Services
Programming Languages:
  • SQL
  • T-SQL
  • MDX
  • ADX
Methodology:
  • Agile development methodology
Database Tools:
  • Microsoft SQL Server 2000/2005/2008/2012/2014
  • Oracle
Data Modeling Tools:
  • CA/ERWIN
  • Power Designer
Big data Tools:
  • Hadoop
  • Hive
  • Pig
  • Impala
Packages:
  • Microsoft SQL Server Data Tools
  • SQL Server Business Intelligence Development Studio
  • Microsoft Visual Studio 2005
  • Microsoft Visual Studio 2008
  • Microsoft Visual Studio 2012
  • IBM DataStage & Quality Stage 8.1
Data modelling:
  • Star-Schema Modeling
  • Snowflake Schema Modeling
  • Fact
  • Dimension tables
Version Control Systems:
  • SVN
  • TFS

 

Training

Big Data


  • Cloudera Data Analyst Using Pig, Hive, And Impala With Hadoop 9-12 Feb 2015 Amsterdam

BI / DATAWAREHOUSE


  • Implementing a Data Warehouse with Microsoft SQL Server 2012
  • ETL Architecture in Depth: Kimball University by Ralph Kimball - 10-13 June 2013 – Amsterdam
  • SQL Server 2008/R2 Database Administration
  • IBM DataStage & Quality Stage 8.1
  • Oracle Database 10g Administration
  • Microsoft SQL Server 2008 Business Intelligence
  • Multidimensional Modelling
  • Prince 2 Project Management Methodology

SAP Master Class at SAP Academy/University (3 weeks) 2012


  • TBI10 – BW – Query Design and Analysis
  • TBI20 – BW – Data Warehousing Fundamentals &Web Application Designer
  • TBI30 – SAP Business Intelligence Solutions with SAP Business Warehouse BO

Work Experience

JAN 2015 – MARCH 2015

SQL Developer / Big Data Analyst

Belgium




  • Data migration from SQL SERVER 2008 R2 to SQL SERVER 2012 of Databases, ETL Package.
  • Creating Tabular cube
  • Big Data products such as Hadoop, Pig, Hive end Impala, Linux using Hadoop virtual machine Cloudera
SQL Server 2012 - Hadoop - Hive - Pig - Impala

July 2014 - Dec 2014

BI Business Analyst

Le havre - France




SPB operates as a broker and is European leader in affinity insurances and services for more than 100 major brands, with implantations in 12 countries

  • Data Migration from SAS to SQL Server 2008 R2
  • Reports Migration from SAS to SSRS 2008
  • Frequent communication with business regarding in business needs gathering
  • I developed professional reports
SQL 2008R2 - SSIS - SSRS

Dec 2013 – May 2014

Lead ETL Developer / Data Architect

Belgium




As Senior BI Consultant, I worked in a leadership role to set a BI environment in a highly secure environment. I built a data warehouse diagram, I used Kimball methodology. I developed ETL package, to load data into Data warehouse. The data warehouse contains 12 fact tables.

  • Data Migration ( Cleaning and migrating data from SQL SERVER 2000 to SQL Server 2008 R2 using SSIS 2008 )
  • BI Architect
SQL 2008R2 - TFS - DWH Modeling - SSIS - Kimball Best Practice

Aug 2013 – Nov 2013

AP Crystal Reports Migration / SQL SSRS

Belgium




  • Replace SAP Crystal Reports with Microsoft Reporting Services(SSRS 2012) in relation to a new ERP (iScala) migration
  • The client has Crystal Enterprise Reports - moving this to Microsoft Reporting Services as they are upgrading to a newer version of Iscala.
  • Advise how to migrate to Microsoft Reporting, then convert reports with them Advise best practice

As I worked through the conversions, I uncovered limitations between the Crystal Reports and SSRS environments. I worked creatively to solve these issues and present a solution to meet the critical requirements of the client.

SQL SERVER 2012 - SQL Server data tools - Reporting services 2012 - SAP Crystal report

Apr 2013 - June 2013

SQL Developer

Belgium




I migrated data from SQL SERVER 2008 to SQL SERVER 2012 of Databases, ETL Package and Reports. Preparing the certification: Implementing a Data Warehouse with Microsoft SQL Server 2012

SQL SERVER 2012 - SSIS - SSAS - SSRS

May 2011 – Mar 2013

BI Developer / Data Migration Specialist

Belgium




A. Migration
  • Cleaning and migrating data from Oracle, SQL SERVER 2000, mySQL and Excel to SQL Server 2008 R2 using SSIS 2008
  • I had to develop a thorough understanding of the system that was to be turned off. The first step was to model the legacy system in its entirety.
  • Before it was moved, the data must be read, understood and translated, while obsolete elements need to be discarded.
  • I developed a migration strategy and approach; I defined the scope, schedule, technical requirements and a detailed execution plan.
  • I developed migration routines; validated business requirements for historical data, data analysis, mapping and referential integrity and certification scripts.
  • I completed end-to-end migration while coordinating with business users in completing data validation, verifying and evaluating the control mechanism and metrics.
  • I executed full-scale migration into the production environment.
  • The client has Crystal Enterprise Reports - moving this to Microsoft Reporting Services as they are upgrading to a newer version of Iscala.
B. BI Project
  • I worked with the business to gather business requirements, created data models based on these requirements and designed BI functionality to meet these needs
  • I designed and implemented DW and BI architecture
  • I designed data models and databases to implement these models
  • I integrated data from other applications
  • I developed OLAP Cube.
  • I produced reports from OLAP (Cube) with Reporting Services (SSRS 2008) with intensive use of MDX
SQL SERVER 2008 R2 - SSIS - SSAS - SSRS - Power Designer - Microsoft SharePoint 2010 - Agile project management techniques - TFS Source Control

Jan 2011 – Apr 2011

BI Consultant

Luxembourg




  • I built a Data Warehouse using SSIS
  • I built OLAP Cube with Analysis Services (SSAS 2005)
SQL 2008R2 - SSIS

Dec 2009 – Dec 2010

DataStage / Data Migration Consultant

Amsterdam ( Netherlands )




  • I migrated customer account data (retail) from Fortis Bank to ABN AMRO Bank. In terms of migration volumes, 1.7 million customers have their account and related products migrated.
  • I designed, implemented, tested, and deployed parallel DataStage solutions.
  • I demonstrated knowledge of parallel concepts (data collection, data skew, data partitioning, buffers, sorting, aggregation, data collecting.
DataStage, svn, Toad and Oracle database

Apr 2009 – Nov 2009

SQL Developer

Belgium




I migrated data from SQL SERVER 2005 to SQL SERVER 2008 of Databases, ETL Package and Reports.

SQL 2008R2 - SSIS – SSRS

Dec 2008 – Mar 2009

Senior BI Consultant

Belgium




With numerous sales regions in approximately 130 countries throughout Europe, Imperial Tobacco needed a comprehensive business intelligence solution that could provide more effective business planning and forecasting abilities.

  • I worked in reporting services, we created several reports to better present the company information for the top management to track actual results against targeted levels.
  • I completed functional analysis including Business Requirements gathering, formalising reports based on the outcomes of interactions with the Clients.
  • I built OLAP Cube with Analysis Services (SSAS 2005)
  • I produced reports from OLAP(Cube) with Reporting Services (SSRS 2005)
  • I extensively used MDX
SQL SERVER 2005 - SSAS - SSRS

May 2008 – Nov 2008

ETL Architect / Project Manager

Belgium




Building data Warehouse for Insurance department.

  • I managed a development team
  • I participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing.
  • I collaborated with analysts, technical leads, business partners and developers
  • I organized a series of interviews with the people that run the business and have knowledge of all activities and processes
  • I analyzed source systems and created a mapping to the target database schema
  • I defined and implemented the required business transformation rules and logic (ETL development)
  • I reviewed the conceptual data model and data mappings to ensure adherence to stakeholder and internal team need
  • I defined a suitable architecture for data integration from multiple, disparate data sources (including legacy systems, relational databases, flat files, etc).
SQL SERVER 2005 - SSIS - CA ERwin® Data Modeler - SharePoint

Jan 2008 - Mar 2008

Senior BI Consultant

Luxembourg




  • I implemented business intelligence dashboards using MOSS 2007 Report Center & Excel Services producing different summary results based on user view & role membership.
  • I built OLAP cube with Analysis Services (SSAS 2005)
  • I produced reports from MS Analysis Services 2005 with Reporting
  • Services and I published reports in SharePoint
SQL SERVER 2005 - SSAS - SSRS

Jul 2007 - Dec 2007

DATASTAGE Consultant

France




  • I processed the data (coming from SAP R/3) in DataStage
  • Server jobs
  • I created and managed the modification of Sequences
  • I updated jobs and sequences with new business roles
  • I validated, ran and monitored jobs using DataStage Director
  • Deployment
  • I wrote scripts to CREATE table, UPDATE table, ALTER table, ADD columns, DROP or MODIFY columns.
DataStage - SAP - OracleS

May 2007 - June 2007

BI Consultant

Belgium




  • I developed reports for Help Desk service (Clarify database) using SQL Server Reporting Services 2005
SQL 2005 – SSRS

SEP 2006 - OCT 2006

BI Consultant

Belgium




  • I migrated reports from Excel to Reporting Services 2005
  • I developed reports (Peregrine database) using SQL Server Reporting Services
  • The Reports use only views and stored procedures with no code inside the reports
Reporting Services 2005 - SQL Server 2005

JUN 2006 – JUL 2006

BI Consultant

Dublin ( Ireland )




  • I developed professional reports using SQL Server Reporting Services.
  • I authored reports using the Report Designer.
  • I deployed and published these reports.
SQL 2005 – SSRS

MAR 2006- May 2006

BI Consultant

Belgium




  • I developed professional reports using SQL Server Reporting Services.
  • I authored reports using the Report Designer.
  • I deployed and published these reports.
SQL 2005 – SSRS

Oct 2005 – Dec 2005

Quality assurance (QA), TESTING

Belgium




  • I managed Quality Assurance (QA), Testing, Security (ASP Web application),
  • I used DTS (Data Transformation Services) and Data Warehouse, downloading AS400 Files to SQL Server tables (BCP, DTS) including Tables, Views, stored procedures ,UDF, Cleanup Database , Shrinking Database
SQL Server 2000, DTS

Jan 2002 – July 2005

Functional Analyst

Belgium




  • I analysed to assist the reporting system
  • I organized a series of interviews with the people that run the business and have knowledge of all activities and processes
  • I undertook Business requirements analysis while gathering business requirements to understand what the customer required.

Dec 2000 – DEC 2001

Consultant

Belgium




  • I designed, implemented, deployed and updated the official website for TAIEX (Directorate-General: Enlargement. European Commission)
  • I developed the EC web site using CCVISTA (The CCVista Database was created to store translations off all the languages of candidate countries of the EU measures)
ASP, Flash , Html, JavaScript and SQL Server 2000

Recommendations

"I found Abdou to be the a very experienced professional, he is enthusiastic and is a self starter. Throughout the project he delivered his work to a high standard in a timely fashion. On a personal level, he is curteous and friendly and has shown himself to be an excellent technical reference for BI, Data Warehousing and related ETL topics. I would be delighted to work with Abdou again and would not hesitate to recommend him for any suitable roles in the future."

David Murphy, (Abn Amro/IBM - 2010)

Abdou is always eager to learn and likes technical challenges. He is a good team mate you can count on.

Thuong do, (Abn Amro/IBM - 2010)

Abdou is always motivated to find solutions his work area....He is always willing to help others. He's a real team worker. It was a real pleasure to work with him.

Saloua Kaissi, (Bpost - 2008)

Abdou is a pleasant person to work with. He has good skills at IBM DataStage en related technics (SQL).

Mark Ansink, (IBM Global Business Services - 2010)

I worked with Abdou on a Reporting Services project at the Belgian Post Group, it was a great pleasure for me to work with Abdou on this project, because Abdou has a lot of experience and always the will to learn to new stuff. In the future, if there is a possiblity, I will do a lot more projects with hem, because he is a really good guy.

Pascal Carpels, (Bpost - 2008)

Abdous has a wonderful exprience in MS products..he is insightful and responsive to come with god solutions...he would bring value to any organisation he joins.

Chilukuri Srinivas, (Bpost - 2008)

I had the chance to work with Abdou on several BI projects and must say that Abdou is a very professional, communicative and social person, with advanced skills in BI and reporting. If I was given the occasion again, no doubt I would work together with him again!

Peter Mesotten, (Bpost - 2008)