Experience

  • BI Developer

    at CESI

    March 2019 - June 2019

    Bruxelles-Capitale

    Activities: • Designing ETL solution using SQL Server Integration Services. • Create new SQL Server objects such as tables, views, indexes, functions, schemas. • Managing, investigating and solving incidents. • Maintain and correct existing stored procedures, views, functions when needed. • Maintain the existing DWH database and the multidimensional cube. • Publish, schedule ETL solutions using SSDT and SQL Agent jobs. • Monitor daily ETL executions. • Used tools: SSMS 2017, SQL Server 2014, SQL Server Data Tool 2017

  • BI Developer

    at Touring club royal de Belgique

    April 2016 - June 2018

    Bruxelles-Capitale

    Activities: • Designing ETL (E-LT) solution using Oracle data integrator 12c. • Analyze and designing semantic layer using BO Universe design tool. • Designing reports using SAP WEBI 4.2 from universe (BO –Universe Design Tool). • Implementing Stored Procedures using PL/SQL • Monitor ETL executions by checking the logs and notification emails in prod envinronment. • Writing complex SQL Queries for reports from ODS layer (Oracle 12 database). • Migration of sunopsis towards Oracle Data Integrator 12c. • Using Power Designer tool for database modeling. Other: Jira; subversion

  • BIdeveloper

    at ACV-CSC

    September 2013 - February 2016

    Bruxelles-Capitale

    Activities: • Developing database solutions. • Multidimensional modeling (Star schema: Determining Dimensions and Facts) • Implementing Stored Procedures using T-SQL • Writing complex SQL Queries. • Designing and implementing an ETL solutions using SSIS. • Writing documentation using EA. • Writing reports using SSRS. • Designing Tabular Cube using SSAS. • Team foundation server as Versioning tool

  • Analyst Developer Consultant

    at Scotler

    September 2011 - October 2012

    Bruxelles-Capitale

    Activities: • Developing Planning Application 5YP. • Multidimensional modeling (Star schema: determining Dimensions and Facts) • Physical modeling with Ms visio 2010 • Implementing Stored Procedures using T-SQL • Writing complex SQL Queries. • Designing and implementing an ETL solution using SSIS (loading 5YP datamart from contributor db) • Creating macro to automate ETL process, data publishing and application versioning. • Implementing Cognos Framework manager • Migrating BO XI catalog (universe) to Framework manager. • Designing reports with Cognos Report Studio • Used tools Ms visio, BIDS 2005, Cognos BI 8.4, Framework Manager, SQL Server and Windows Server 2003

Education

  • MCSA SQL 2016 70-767 Implementing a Data Warehouse

    at RealDolmen

    2018 - 2018 (1 year)

  • Oracle Data Integrator 12c

    at Oracle academy

    2016 - 2016 (1 year) Bruxelles-Capitale

  • BSc Computer Science

    at ICET

    1999 - 2002 (3 years) Walloon Region

Hives