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

Languages

French
Native or bilingual
English
Native or bilingual
Dutch
Conversational

Workplace preferences

Can work on-site

Bruxelles (up to 50km)

Business & Decision
Business Specialist / BI Developer
August 2020 - Today (5 years and 10 months)
Brussels, Belgium
Finalyse
Senior Consultant - Business Intelligence
September 2010 - August 2020 (9 years and 11 months)
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
June 2009 - September 2010 (1 year and 3 months)
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.