Freelance Microsoft Power Query : Recevez gratuitement les meilleurs CV

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

• 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:
  &#x2022 Comparative analysis of ML and AI models, bank credit scores
  &#x2022 1. Supervised Learning:
  &#x2022 Classification: Random Forest, Gradient Boosting, Support Vector Machine, DBSCAN, K-nearest neighbors (KNN), Isolation Forest Guide
  &#x2022 Regression: Logistic Regression, Linear Regression, Polynomial Regression
  &#x2022 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
  &#x2022 Management of the ETL tool, SAP BPA
  &#x2022 Update of the different jobs (Correction of bugs and warnings)
  &#x2022 Data quality: elimination of errors following the bug and data server
  &#x2022 Performance Optimization and Metadata Management
  &#x2022 Data governance: checking the consistency and accuracy of data
  &#x2022 Marketing Service in Belgium & Network Service in Belgium & India
  &#x2022 Modification of Jobs content for Professions
  &#x2022 Data visualization and advanced analytics: creation of dashboards, reports and statistics for errors
  &#x2022 Exceute unit test integration
  &#x2022 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 &#x2013 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 &#x2022 Improvement of data quality after migration in Linux server, IPC (Acceptance and Production) :Data Warehouse-Datamart model: DataVault under airlock,
  &#x2022 Checking Daily /Monthly load data from Thaler
  &#x2022 Data migrated from SAS_BA to IPC Linux (Server Acceptance and Production) under sas
  &#x2022 ETL, Data Flow: Creating Jobs from Windows SAS Data Integrator Studio to Linux Server
  &#x2022 Data validations: verification, Compliance of data characters within Linux server, IPC Server
  &#x2022 Program proc compare and calculation of volumetry with sas -Job update with SAS Data Integrator Studio
  &#x2022 Unit Test: Linux commands after each validation and migration, table, variables
  &#x2022 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.
  &#x2022 Type of data: Bank Credit
  &#x2022 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 &#x2022 Datawarehouse modeling & datamart modeling : snowflake ,Data vault
  &#x2022 data extraction for marketing team
  &#x2022 data qualities: data anomalies and update-data pack for dawh update with ssis and sas di
  &#x2022 data analysis with ssas-statistical reporting with sas guide e.
  &#x2022 migration-copy data (datawarehouse) to cloud with azure
  &#x2022 Migrate SAS scripts to SQL Server using SSIS.
  &#x2022 Automate simple and complex tables in SQL Server.
  &#x2022 Convert SAS code to SSIS for easier migration and automation
  &#x2022 Design of the technical solution covering the needs (data model, integration flow, data mapping)
  &#x2022 Construction of an integration layer based on Azure : DAX, Azure Cubes, Azure Devops, Azure Analysis services
  &#x2022 PowerBI dashboards connected to Azure Cubes
  &#x2022 Implementation of specific calculations and filtering according to needs.

  &#x2022 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 &#x2022 Three Servers (Production, Development, Accepting) with (SAS, Oracle 12c): Configuration Model the Process and the Data Cycle within the information system.
  &#x2022 Study and Analysis of Needs, Specification and Business Requirements
  &#x2022 Management within the project of various Orientations Taken and Monitoring-Evaluation
  &#x2022 Provide statistical data and economic analyzes (macro and micro) of Europa Agriculture
  &#x2022 Data validation: statistical tests (Outliers, Grubbs, Multiple Regression&#x2026:Tests Unit,Integration ,Validation&#x2026
  &#x2022 Production dashboards and grapraphics : Qqplots,Boxpolts, histogram with density
  &#x2022 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
  &#x2022 Coaching and implementation after datawarehouse update: Implementation of Power BI and Qlick templates for different dashboards/reporting, to support quarterly and annual reporting
  &#x2022
  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):
  &#x2022 Plans of experience
  &#x2022 Matched and Independent Data
  &#x2022 Equivalence Test (TOST) and Difference Test
  &#x2022 SAS STAT (PROC TTEST, PROC GLM, PROC MIXED ...)
  &#x2022 Programming SAS (Macro SQL Database)
  &#x2022 Programming VBA.
  &#x2022 Tools / Software: SAS BASE, SAS SQL, SAS MACRO SAS STAT

• BIOMETRICS, STATISTICS &#x2013 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 &#x2022 Putting my statistical and scientific skills to teams and carriers of active projects in areas of very diverse research studies and development
  &#x2022 Processing of data in Base SAS, writes SQL queries, SQL T base data to SAS
  &#x2022 Advanced and effective programming with SAS Storage and Handling of large data sets
  &#x2022 Optimizing memory and storage space, technology effective programming practice tools on advanced case studies
  &#x2022 Statistical modeling and regression & multivariate statistical analysis
  &#x2022 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 &#x2022 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.
  &#x2022 R...