Freelance Microsoft Power Query : Recevez rapidement les CV que vous avez choisi

Exemple d'expériences de Jean Didier,
freelance MICROSOFT POWER QUERY habitant ?

• BI ANALYST

  -DATA CREDIT
  Jan 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.

• Jan 2024 - Jan 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
  Jan 2022 - Jan 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
  Jan 2021 - Jan 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
  Jan 2020 - Jan 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

• IT Functional and Accounting Data Analyst

  Commission Europa Bruxelles
  Jan 2018 - Jan 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
  Jan 2016 - Jan 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 .
  Jan 2011 - Jan 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.
  Jan 2006 - Jan 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...