Description

Pascal is a Business/Functional Analyst, an Expert in Business Intelligence who has completed many projects in the design and loading of data warehouses in the financial domain. Over the years, he has successfully performed the implementation of reporting layers for a variety of risk and performance uses, including the integration of data feeds and numerous software platforms into data warehouse environments. Beyond his functional and technical profile, he is a proactive person with a "can do" spirit, driven by results. With his good communication skills, he will quickly fit in any team.

SSAS, SSRS, SSIS, Power BI, T-SQL, Visual Studio, Data Modeling, Dashboarding, Data Quality, Data Analysis, Data Warehousing, ETL, AGILE, Functional Analysis, Data Analysis, DAX

Langues

Français
Bilingue ou natif
Anglais
Bilingue ou natif
Néerlandais
Capacité professionnelle limitée

Préférences en matière de lieu de travail

Accepte de travailler sur site

Bruxelles (jusqu’à 50 km)

Business & Decision
Business Specialist / BI Developer
août 2020 - Aujourd'hui (5 ans et 10 mois)
Brussels, Belgium
Finalyse
Senior Consultant - Business Intelligence
septembre 2010 - août 2020 (9 ans et 11 mois)
Client: BNP Paribas Fortis Project: Deep Drill Title: Team Leader Main tasks/Main responsibilities: o Business Analyst: Understanding the Business needs in order to translate them into technical concepts. o Extraction Transformation and Load (ETL) of Business data to DeepDrill database using Microsoft Integration Services (SSIS) o Creation of a dimensional cube using Analysis Services (SSAS) o Reporting Package for Business users, using Microsoft Reporting Services (SSRS) Technical environment: Microsoft SQL Server 2008 / Performance Point Services and Excel (connected to SSAS Cube) Business environment: Deep Drill is the Management Information System ('MIS') dedicated to the Retail and Private Banking business done in Capital Markets securities (FI and GECD). Focusing on securities flows and stocks, Deep Drill gathers, sorts, analyzes, evaluates and distributes needed, timely, and accurate information to decision makers. Used skills:ETL, Programming, Reporting
Finalyse
Senior Consultant - Business Intelligence
juin 2009 - septembre 2010 (1 an et 3 mois)
Amsterdam, Netherlands
Client: Fortis Bank Nederland Project: Separation Project (VaRworks / Reg Cap) Main tasks/Main responsibilities: o Business Analyst: Understanding the Business needs in order to translate them into technical concepts. o Extraction of Fortis NL data into the Fortis BE database using Business Objects 6.5 o Extraction Transformation and Load (ETL) of previously extracted data to Fortis NL database using Microsoft Integration Services (SSIS) o Reporting Package for Business users, using Microsoft Reporting Services (SSRS) Technical environment:Business Objects 6.5 & Microsoft SQL Server 2005 Business environment: Products handled by Varworks and RegCap application: IRS, CRS, FXOPT, CAP&FLOOR, DEPOT, SPOT, SWAP. The understanding of these products is necessary to translate Business needs into technical concepts.