Freelance Microsoft Power Query : Nos meilleurs consultants identifiés

Aperçu d'expériences de Jean Didier,
freelance MICROSOFT POWER QUERY résidant dans ?

BI ANALYST-DATA CREDIT
avril 2025 - aujourd'hui
SWCS: Société Wallonne du Crédit Social -Walloon Social Credit Society Charleroi Belgique
- Cross-referencing data from different database tables (from SQL SERVER to ORACLE) & Implementing complex filters in Power BI & Implementing complex filters in Power BI & - ptimizing sophisticated DAX formulas & - Implementing a dashboard in Power BI (Deskop-Services) & - Managing Power BI Services & - Extracting queries from Power BI reports for integration into our reporting management interface (SWCS: Société Wallonne du Crédit Social) - Cross-referencing data from different database tables (from SQL SERVER to ORACLE) Writing and optimizing sophisticated DAX formulas - Implementing a dashboard - Extracting queries from Power BI reports for integration into our reporting management interface
Tools : SQL, TSQL,POWER BI · POWER BI SERVICES · Microsoft Power Query · DATAWEHOUSE · SQL · Data Analysis Expressions (DAX) · Programming SAS, SQL SERVER , ORACLE, T SQL, PL/SQL, E Guide SAS.

juillet 2024 - mai 2025
Validation: Python codes for Machine Learning,2024 2025 for Memory,10 models, Python under Power BI for Machine Learning models:
• Comparative analysis of ML and AI models, bank credit scores
• 1. Supervised Learning:
• Classification: Random Forest, Gradient Boosting, Support Vector Machine, DBSCAN, K-nearest neighbors (KNN), Isolation Forest Guide
• Regression: Logistic Regression, Linear Regression, Polynomial Regression
• 2. Unsupervised Learning:Clustering (K-means clustering), Principal Component Analysis (PCA), the k-means algorithm, hierarchical clustering, or autoencoders,Principal Component Analysis, Self-Adaptive Map, Independent Component Analysis
SMOTE for Imbalanced Classification with Python: BorderlineSMOTE & SMOTENC & ADASYN , KMeansSMOTE, SMOTEN, SMOTENC

IT Business Analyst & Developer SAS SNCB -YPTO Bruxelles
septembre 2022 - juillet 2024
Migration from DHW SAS window TO SAP 4HANA

Migration from DHW SAS window TO SAP 4HANA
Data warehousing: (snowflake , star ,Data vault) model

Description Datawarehouse update server PRO-ACC for reports (data) with regard to the needs of the Sales & Marketing department
Data warehousing:snowflake , star ,Data vault

Tasks Weekly meeting with Marketing & Sales Department : functional and technical analysis of business needs (use case) : service sale -Marketing
• Management of the ETL tool, SAP BPA
• Update of the different jobs (Correction of bugs and warnings)
• Data quality: elimination of errors following the bug and data server
• Performance Optimization and Metadata Management
• Data governance: checking the consistency and accuracy of data
• Marketing Service in Belgium & Network Service in Belgium & India
• Modification of Jobs content for Professions
• Data visualization and advanced analytics: creation of dashboards, reports and statistics for errors
• Exceute unit test integration
• Tools: T SQL , SQL SEVER,SAP BPA, SAP HANA,Jira, SAS E. Guide, Linux commands, SAS-SQL, Wncp, Putty, Excel VBA,Power query,Power BI.

IT CREDIT RISK BANK DEVELOPPER – ING Belgium
octobre 2021 - novembre 2021
Migration Datawarehouse Risk data window TO Datawarehouse risk Linux

Description Migration Datawarehouse Risk data window TO Datawarehouse risk Linux
Migration of datawarehouse from Windows server to Linux server
Data warehousing:Data vault

Tasks • Improvement of data quality after migration in Linux server, IPC (Acceptance and Production) :Data Warehouse-Datamart model: DataVault under airlock,
• Checking Daily /Monthly load data from Thaler
• Data migrated from SAS_BA to IPC Linux (Server Acceptance and Production) under sas
• ETL, Data Flow: Creating Jobs from Windows SAS Data Integrator Studio to Linux Server
• Data validations: verification, Compliance of data characters within Linux server, IPC Server
• Program proc compare and calculation of volumetry with sas -Job update with SAS Data Integrator Studio
• Unit Test: Linux commands after each validation and migration, table, variables
• Updating risk reports: MREL: Minimum Requirement for own funds and Eligible Liabilities,CRR: Risk Report ,OMP,RWA: Risk-Weighted Assets,CVA ,CRSR, CRC (daily, monthly) on Linux.
• Type of data: Bank Credit
• TOOLS: THALER, ORACLE, SAS E. GUIDE, SAS SQL, SAS DATA INTEGRATOR STUDIO, WINDOW, LINUX REDH,ORACLE, PL /SQL, SQL DEVELOPER, ORACLE, JIRA

Data Security-Data Project-Business Reporting (SQL SERVER) AG Insurance Bruxelles
juin 2020 - septembre 2021
Tasks • Datawarehouse modeling & datamart modeling : snowflake ,Data vault
• data extraction for marketing team
• data qualities: data anomalies and update-data pack for dawh update with ssis and sas di
• data analysis with ssas-statistical reporting with sas guide e.
• migration-copy data (datawarehouse) to cloud with azure
• Migrate SAS scripts to SQL Server using SSIS.
• Automate simple and complex tables in SQL Server.
• Convert SAS code to SSIS for easier migration and automation
• Design of the technical solution covering the needs (data model, integration flow, data mapping)
• Construction of an integration layer based on Azure : DAX, Azure Cubes, Azure Devops, Azure Analysis services
• PowerBI dashboards connected to Azure Cubes
• Implementation of specific calculations and filtering according to needs.
• TOOLS: ERWIN, SQL SERVER, SAS GUIDE, SAS DI, VISIO, AZURE, POWER BI, SSIS, SSAS,SQL, T SQL

Commission Europa Bruxelles
IT Functional and Accounting Data Analyst
décembre 2018 - juin 2020
: Network Modeling Information Agricultural Accounting Data from all countries to within the European Union.

Tasks • Three Servers (Production, Development, Accepting) with (SAS, Oracle 12c): Configuration Model the Process and the Data Cycle within the information system.
• Study and Analysis of Needs, Specification and Business Requirements
• Management within the project of various Orientations Taken and Monitoring-Evaluation
• Provide statistical data and economic analyzes (macro and micro) of Europa Agriculture
• Data validation: statistical tests (Outliers, Grubbs, Multiple Regression…:Tests Unit,Integration ,Validation…
• Production dashboards and grapraphics : Qqplots,Boxpolts, histogram with density
• Production of different Dashboards(Power Bi-Qlicksense) for the description of the different aspects of the data By country, by region, by specification, by year
• Coaching and implementation after datawarehouse update: Implementation of Power BI and Qlick templates for different dashboards/reporting, to support quarterly and annual reporting
•
SQL

I T DEVELOPPEUR
BNP PARISBAS
août 2016 - juillet 2017
Securities Service Luxembourg & Bruxelles

Mission/Project BNP PARISBAS Securities Service Luxembourg
Tasks Extract data from different source types
Rename Variables-Data cleaning
Data validation is the step of verifying
Reject data that does not follow certain rules before adding to a database
Update, analyze, model BI solutions and query with SQL
Support the expression of business needs-Carry out technical-functional specifications
Update multidimensional data models and implement them in the Data Warehouse
Design dashboards with Power BI : Participate in the analysis of operational solutions
Monitor decision-making tools.
Type of data: Bank Credit
Tools : SAS, PL/SQL,EXCELL,POWER QUERY,POWER BI, SQL , SQL SERVER

OF TECHNICAL & PRODUCT EXPERTISE, GLAXOSMITHKLINE EN BELGIQUE
INDUSTRIEL STATISTICS & GQC CENTER .
janvier 2011 - octobre 2013
Description Develop an analysis utility using SAS software to perform equivalence tests (SAS and SAS code programming for various experimental devices using PROC TTEST and PROC MIXED):
• Plans of experience
• Matched and Independent Data
• Equivalence Test (TOST) and Difference Test
• SAS STAT (PROC TTEST, PROC GLM, PROC MIXED ...)
• Programming SAS (Macro SQL Database)
• Programming VBA.
• Tools / Software: SAS BASE, SAS SQL, SAS MACRO SAS STAT

BIOMETRICS, STATISTICS – DATA MANAGEMENT, BELGIUM.
WALLON GEMBLOUX RESEARCH CENTER.
octobre 2006 - décembre 2013
Description Walloon Research Centre of Gembloux Belgium / Biometry and Statistics, Data Management Section.Research in the field of statistics (European or regional projects) Consultancy for scientific and research projects at the Centre and external customers.

Tasks • Putting my statistical and scientific skills to teams and carriers of active projects in areas of very diverse research studies and development
• Processing of data in Base SAS, writes SQL queries, SQL T base data to SAS
• Advanced and effective programming with SAS Storage and Handling of large data sets
• Optimizing memory and storage space, technology effective programming practice tools on advanced case studies
• Statistical modeling and regression & multivariate statistical analysis
• Planning, statistical analysis and principles of experimentation & Analysis of variance -Multiple graphics statistics
Tools / Software: SAS BASE SAS SQL SAS MACRO, SAS STAT, SAS GRAPHG, R, SAS E GUIDE,Python

BNP PARISBAS Securities Service Bruxelles
aujourd'hui
Mission/Project
Tasks • The purpose of the RECO AUDIT Project was to update and create complete documentation (functional and technical) on the SCORE CARD signals.
-Update the SCORE CARD via the signals.
-Writing SCORE CARD.
• R...