Omschrijving

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

Talen

Frans
Tweetalig / moedertaal
Engels
Tweetalig / moedertaal
Nederlands
Beperkte professionele capaciteit

Voorkeuren voor werkplek

Kan op locatie werken

Bruxelles (tot 50km)

Business & Decision
Business Specialist / BI Developer
augustus 2020 - Vandaag (5 jaren en 10 maanden)
Brussels, Belgium
Finalyse
Senior Consultant - Business Intelligence
september 2010 - augustus 2020 (9 jaren en 11 maanden)
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
juni 2009 - september 2010 (1 jaar en 3 maanden)
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.