Senior Microsoft BI Consultant

• Aug 2021 - Present

Senior Microsoft BI analyst

• Jun 2020 - Jul 2021

Reporting Projects Creation of PowerBI reports for Rental, Selling and Financial branches. o Requirements analysis, Azure SQL database development, Google Analytics querying, file import using Azure Data Factory, PowerBI reporting, documentation Maintenance and optimisation of Azure SQL Server o Optimisation of queries, indexes, automatization of index rebuilding, naming convention Maintenance of legacy systems based on Pentaho, SQL Server 2014, SSIS packages,… o Tools: Azure SQL Server, Azure Data Factory, PowerBI, Pentaho, Confluence, Jira Show less

Senior Microsoft BI Consultant

• Mar 2020 - Jun 2020

Corporate Data Warehouse Creation of a new corporate data warehouse to replace the existing one. o Requirements analysis, bases, ETL, packages o Tools: SQL Server 2019, SSIS, Redgate Toolbelt, TFS, SourceTree, Confluence, Jira Corporate Data Warehouse Creation of a new corporate data warehouse to replace the existing one. o Requirements analysis, bases, ETL, packages o Tools: SQL Server 2019, SSIS, Redgate Toolbelt, TFS, SourceTree, Confluence, Jira

Data Analyst - DBA

• Jan 2018 - Feb 2020

Database optimizations, replications, database migration. o Optimization of stored procedures and triggers, analysis of query plans, creation and modification of indexes o Controls and modifications of database replications o Migration from Sybase database to SQL Server database o Upgrade of SQL Server database version (2005 to 2008R2/2012) o Monitoring operations and performance monitoring o Modelling of bases, analysis, installation o Data scripting for deployments Database development. o Modification and creation of stored procedures o Creation of automatisms and configuration o Writing of documentation o Tools: SQL Server 2008/2012/2014/2016, Sybase Central, SQL Advantage, OGG, Flyway, SourceTree, Confluence, Jira Show less

ODI Analyst - Senior BI Specialist

• Aug 2016 - Jan 2018

In order to provide services to various financial entities, ODI is used to import, transform, and export data. o Maintenance of existing ODI applications o Development of new ODI project for specific clients (On Going Charges, Citi...) o Development of PRIIPS ODI project o Global monitoring project o Backup automating of ODI projects o Defining business requirements for new solutions o Collecting and analysing quantitative data from various data source o Design Architecture and Data Model o Ensure coordination of the project between ODI team and Business users o Writing of documentation o Tools: ODI 12, Oracle 11, PL/SQL, Confluence, Jira Show less

Senior Microsoft BI Consultant

• Jan 2014 - Aug 2016

- Projects migration to SQL Server 2014 Migration of existing systems to SQL2014. o Requirements analysis, bases, ETL, packages and cubes migration o SSRS report migration - Corporate Data Warehouse In order to ensure cross reporting between corporate applications, a DWH has been implemented. o Define business requirements for the new solution o Collect and analyzing quantitative data from various data source o Organize mapping between Master data o Design Architecture and Data Model under the supervising of a senior architect o Ensure coordination of the project between ETL team and Business users - Global Services Project Automation, consolidation, reassignment and treatment of IT costs, collected by using formal input files. The result is easily usable in any tool of standard reporting and ad hoc analysis tool. o Requirements analysis, modeling bases, ETL creation, packages creation o SSRS reports creation, deployed in Sharepoint o InfoPath input forms creation, deployed in Sharepoint - FxRate Project Automating the collection of rates, automatic conversion in different projects. o Requirements analysis, modeling bases, ETL creation, packages creation, cubes modification - MDXParser Project Automating the creation of MDX formulas depending of various parameters. o Requirements analysis, ETL creation, packages creation, script creation - GTB Cube Project Modification of the existing cube, adding exchange rates, creating automatic partitions, metric/imperial automatic conversion, ... o Requirements analysis, modeling bases, ETL creation, packages creation, cubes modifications o Sharepoint dashboard creation using SSRS - CPM Team Maintenance and development of existing systems, migration to SQL2012. o Requirements analysis, bases, ETL, packages and cubes maintenance o SSRS report maintenance o Writing of documentation o Tools: SQL Server 2005/2008/2012/2014, SSAS, SSIS, SSRS, InfoPath, PowerBI, MDX Show less

Senior Microsoft BI Consultant

• Oct 2012 - Dec 2013

- Projects migration to SQL Server 2014 Migration of existing systems to SQL2014. o Requirements analysis, bases, ETL, packages and cubes migration o SSRS report migration - Corporate Data Warehouse In order to ensure cross reporting between corporate applications, a DWH has been implemented. o Define business requirements for the new solution o Collect and analyzing quantitative data from various data source o Organize mapping between Master data o Design Architecture and Data Model under the supervising of a senior architect o Ensure coordination of the project between ETL team and Business users - Global Services Project Automation, consolidation, reassignment and treatment of IT costs, collected by using formal input files. The result is easily usable in any tool of standard reporting and ad hoc analysis tool. o Requirements analysis, modeling bases, ETL creation, packages creation o SSRS reports creation, deployed in Sharepoint o InfoPath input forms creation, deployed in Sharepoint - FxRate Project Automating the collection of rates, automatic conversion in different projects. o Requirements analysis, modeling bases, ETL creation, packages creation, cubes modification - MDXParser Project Automating the creation of MDX formulas depending of various parameters. o Requirements analysis, ETL creation, packages creation, script creation - GTB Cube Project Modification of the existing cube, adding exchange rates, creating automatic partitions, metric/imperial automatic conversion, ... o Requirements analysis, modeling bases, ETL creation, packages creation, cubes modifications o Sharepoint dashboard creation using SSRS - CPM Team Maintenance and development of existing systems, migration to SQL2012. o Requirements analysis, bases, ETL, packages and cubes maintenance o SSRS report maintenance o Writing of documentation o Tools: SQL Server 2005/2008/2012/2014, SSAS, SSIS, SSRS, InfoPath, PowerBI, MDX Show less

Senior Microsoft BI Consultant

• Feb 2012 - Oct 2012

- Development of Microsoft BI in Luxemburg o Pre sales client meetings o Sales support (documentation, presentations, …) o Microsoft event presentation o Adding documentation on Sogeti group repository o Sogeti countries meetings - Schroder Investment Management Luxembourg o Creation of OLAP Cubes Requirements analysis, modeling bases, creation of ETL, creating packages, creation of cubes o Creating financial reports o Writing of documentation - Alter Domus o Creating financial reports o Writing of documentation o Tools: SQL Server 2008, SSAS, SSIS, SSRS, MDX Show less

Senior software engineer (DBA/BI)

• 2009 - 2012

- DBA SQL o Monitoring and Server Management database Monitoring operations and performance monitoring, operations of backup / restore o Modelling of bases, analysis, installation - BI o Creation of OLAP Cubes Requirements analysis, modeling bases, creation of ETL, creating packages, creation of cubes o Creating Reports - SQL Development o Creation of calculation engine management retrocommissions Needs analysis, creation of SP, testing, optimization (query plan, automated testing) o Writing of documentation o Tools: SQL Server 2005/2008, Toad, SSIS, SSRS, MDX Show less

Consultant

• 2008 - 2009

- Vitis Life o Analysis of the existing solution (VB module and forms, SQL Server) to plan a migration to a .NET 3.5 development, based on an nTiers architecture (SOA) (09/09/08 – 09/12/08) o Migration of the existing solution (VB module and forms, SQL Server) to a .NET 3.5 development, based on an nTiers architecture (SOA) (01/05/09 – 10/09) o C# (2008), Framework 3.5, WCF, Linq for SQL, Spring .Net, SQL Server 2000/2005 - La Bâloise assurances o Internal Computer department documentation (12/10/08 – 12/16/08) - NAMSA LG (Logistic) o Analysis of costs estimate for the CJTF/NRF Automation project (10/30/08 – 12/04/08) Estimation and analysis of global costs for the implementation and maintenance of the CJTF/NRF Automation project, including all sub-parts of the Project: SAP, NDSS, CJTF Capability Configurator. - Microsoft Trainer o 2793A - Implementing and Maintaining MS SQL Server 2005 Reporting Serv. (09/03/08 - 09/05/08) o 2791A - Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services (08/06/08 - 08/08/08) - La Luxembourgeoise o Analysis for a future migration of MS Office (08/14/08 – 08/22/08) Show less

Developer SQL/Oracle

• 2007 - 2008

- Audit, analysis and project monitoring, deployment and definition of parameters of applications - Analysis and programming. Software sold to stores for sales force management. Setup creation - Analysis and programming of internal tools - Writing of materials and specifications, users training - Incl. 4 months working for Tequia for this client o Tools: Visual Basic 6, SQL Server 2000, Oracle 9, Crystal Reports 10, Installshield 11 - Audit, analysis and project monitoring, deployment and definition of parameters of applications - Analysis and programming. Software sold to stores for sales force management. Setup creation - Analysis and programming of internal tools - Writing of materials and specifications, users training - Incl. 4 months working for Tequia for this client o Tools: Visual Basic 6, SQL Server 2000, Oracle 9, Crystal Reports 10, Installshield 11

DBA/BI

• 2003 - 2007

- Development of the system Mikado for valuation of property risks (lead, white ants, …) - Development of the system Gestaff for management of business (industrial risks) - OLAP development with Office Web Component - SQL Server DBA - Various development and service (projects, ocx, dll, …) o Tools: Visual Basic 6, SQL 7/2000/2005, Office Web Components, OLAP, MS Office, VBA, VB CE, PowerAMC 8 - Development of the system Mikado for valuation of property risks (lead, white ants, …) - Development of the system Gestaff for management of business (industrial risks) - OLAP development with Office Web Component - SQL Server DBA - Various development and service (projects, ocx, dll, …) o Tools: Visual Basic 6, SQL 7/2000/2005, Office Web Components, OLAP, MS Office, VBA, VB CE, PowerAMC 8

IT Project Manager

• 1998 - 2003

Managing credit risk project team o Tools: Visual Basic 5/6, SQL 6.5/7/2000, Office Web Components, OLAP, MS Office, VBA Managing credit risk project team o Tools: Visual Basic 5/6, SQL 6.5/7/2000, Office Web Components, OLAP, MS Office, VBA