Ludovic Schmetz

SGG Data Warehouse / BI department • Responsible of the BI team ( 6 persons ) • Project manager for the BI team • BI Architect • Contact with vendors for negociations • Developer within the team on different projects such as : o Reports migrations o Flow development o Architecture and Database design Environment: Windows 7/10 Professional, Windows Server 2012/2013, SQL Server 2012/2016, Visual Studio 2015 Ultimate, SSIS/SSAS/SSRS 2016, Transac SQL, Tableau software 10.* desktop/server core, Power BI , Alteryx, Python

Luxembourg’s Stock exchange • SSRS Migration • Data Warehouse and Tableau • Finance Department • Market Surveillance department • Marketing Department • Index Listing/management department Function: Business Intelligence/Data Warehouse Architect - Developer Tasks: o Migrate a set of +100 reports from Business Objects to SSRS o Build a Data warehouse centralizing the different models of the Luxembourg stock exchange (model and flows) o Define and configure the whole Tableau software architecture o Build the dashboards for the group/board (Stock exchange and Fundsquare) o Coach and train the users to Tableau/SSRS o Be a key person for the technologies and tune the data warehouse o Be close to the key departments and the board of the stock exchange to deliver quality dashboard/reports o Be the key person concerning the reporting for CSSF and ESMA o Manage the whole BI solution from End 2 End Environment: Windows 7/10 Professional, Windows Server 2012/2013, SQL Server 2012/2016, Visual Studio 2015 Ultimate, SSIS/SSAS/SSRS, Transac SQL, Tableau software 10.* desktop/server core

• Tableau software trainer Function: Business Intelligence/Data Warehouse Architect Tasks: o Analyze the Existing architecture and current BI organization o Interview with the key users to define the needs o Specify the guidelines o Evaluate the project portfolio o Business case o Build the roadmap o Build the governance o Select the software/tools

• BI consultant at Banque de Luxembourg Function: Business Intelligence/Data Warehouse Architect Tasks: o Analyze the existing data warehouse and propose optimization of the model and of the ETL process o Prove of concept in order to select the best BI tool

• Analyse and Build of an entire data warehouse solution from End to End ( flow , organisation, methodology and BI services within Docler ) o Analysis of the existing reporting solution
 o Interview of the users to define the new needs and validate the existing reporting in order to build the wanted solution that fits their needs
 o Design and modeling of the new Enterprise Data Warehouse 
 • Development of the ETL following the development paradigms • Responsible of the evaluation, selection, management of licenses and training for the whole group of a global BI tool. Environment: Windows 7 Professional, Windows Server 2012/2008R2, SQL Server 2012, Visual Studio 2012 Ultimate,SSIS/SSAS/SSRS, Embarcadero Data Architect 9.5, XSD, XML, Transac SQL, Embarcadero Portal/CONNECT, Tableau Desktop 8.3/9, Tableau Server 8.3/9, MY SQL.