Ludovic Schmetz

Enterprise Data Platform Architecture

• Architected and implemented AWS-based data platform (S3 datalake+redshift) , achieving 99%+ uptime while migrating from legacy Exasol infrastructure.
• Engineered declarative DAG framework in Python with YAML-based configuration enabling self-service pipeline creation across multi-source systems (Postgres, SAP ECC, MS SQL, REST APIs, FTP,...), auto-deploying to Airflow and reducing development time from weeks to hours
• Led 6-month data warehouse migration deploying 180+ Python/Airflow/dbt pipelines across medallion architecture (Bronze/Silver/Gold layers) with zero business disruption, processing 200+ GB daily with dbt-based quality testing and transformation logic.
• Developed enterprise data products including SAP EEP CDC replication (111 tables, SCD Type 2), CREOS meter readings ODS (39M records/day), weather data integration, asset forecasting models, operational event, etc...
• Designed and implemented federated data architecture enabling 4 business units with autonomous Redshift instances interconnected via datashare, supporting domain-specific analytics while maintaining centralized governance and cross-domain data access.
• Established enterprise data governance framework integrating OpenMetadata for automated lineage tracking, dbt schema tests for data quality, and standardized data contracts across all source systems and data products

• Developed architecture artifacts for standards, patterns and architectural roadmaps.
• Analyzed technology industry, competitors and market trends to determine potential impact on enterprise.
• Translated business and technical requirements into architectural blueprint to achieve business objectives.
• Tested functional compliance of company products.
• Created proofs of concept for innovative new solutions.
• Designed and developed analytical data structures.
• Designed and implemented scalable applications for data extraction and analysis.
• Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.
• Migrated numerous legacy systems to newer technologies, reducing costs and enhancing efficiency of computing tasks.
• Designed data models for complex analysis needs.
• Collaborates with ING at group level for ING LU on many
  projects (Workday, SAP BO, CSSF reporting, python for
  data scientists, Oracle migration...)

• Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
• Handled massive quantities of business intelligence data.
• Designed customized data collection models for specific visualization tasks.
• Developed intelligence-sharing dashboards, providing company-wide access to collected data.
• Responded to specific BI requests from personnel, creating data packets with requested information in easily understandable formats.
• Collected data from wide-ranging sources.
• Created data analysis tools to allow teams to query acquired information for unique details.
• Optimized system and platform performance capabilities in most efficient, practical way possible.
• Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse.
• Developed applications and designed processes for transformation and data management from company-wide databases.
• Documented data warehouse architecture to guarantee capacity met current and forecasted needs.

• Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
• Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
• Developed intelligence-sharing dashboards, providing company-wide access to collected data.
• Designed customized data collection models for specific visualization tasks.
• Responded to specific BI request, creating data packets with requested information in easily understandable formats.

• Put in place the data management for the company, teaching to the key people the paradigm of data management and BI.
• Development Data Dictionaries
• Data Governance and policies
• Governance and development of Data Models
• Planned and implemented security measures to safeguard vital business data.
• Collected, reviewed and analyzed data from diverse departments for business needs.
• Built and deployed plans, reports, validation procedures and entry processes for data management needs.

• Business intelligence Expert ( short term mission ) Projects: Mission CSSF Luxembourg / BI department, Developer within the team on different projects such as :.
• Reports migrations.
• Flow development.
• Architecture and Database design.
• Dashboard development
• EMIR Datamart
• Responded to specific BI requests, creating data packets with requested information in easily understandable formats.
• Designed customized data collection models for specific visualization tasks.
• Conducted interviews with key business users to collect information on business processes and user requirements.

• SGG Data Warehouse / BI department.
• Responsible of the BI team ( 6 persons ).
• Project manager for the BI team.
• Synthesized current business intelligence data to produce reports and polished presentations highlighting findings and recommending changes.
• Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
• Orchestrated smooth and effective flow of data to support users.
• Developed KPIs metrics derived from raw company data to track improvements in organizational efficiency.

• Migrate a set of +100 reports from Business Objects to SSRS
• Build a Data warehouse centralizing the different models of the Luxembourg stock exchange (model and flows)
• Define and configure the whole Tableau software architecture
• Build the dashboards for the group/board (Stock exchange and Fundsquare)
• Coach and train the users to Tableau/SSRS
• Be a key person for the technologies and tune the data warehouse
• Be close to the key departments and the board of the stock exchange to deliver quality dashboard/reports
• Be the key person concerning the reporting for CSSF and ESMA
• Manage the whole BI solution from End 2 End
• Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
• Reviewed files, records and other documents to obtain business information and key data informing responses to development requests.

• BI Roadmap for FOYER Insurances.
• Tableau software trainer Function: Business Intelligence/Data Warehouse Architect Tasks:.
• Analyze the Existing architecture and current BI organization.
• Interview with the key users to define the needs.
• Specify the guidelines.
• Evaluate the project portfolio.
• Business case.
• Build the roadmap.
• Build the governance.
• Select the software/tools
• Analyze the existing data warehouse and propose optimization of the model and of the ETL process
• Prove of concept in order to select the best BI tool

• IMS (Information Management System ) Function: Business Intelligence/Data Warehouse Architect Tasks:.
• Analyze and Build an entire of the data warehouse solution from End to End (flow , organization, methodology and BI services within Docler ).
• Analysis of the existing reporting solution.
• Interview of the users to define the new needs and validate the existing reporting to build the wanted solution that fits their needs.
• 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.

• Global BI Tool Selection (MicroStrategy).
• CAPEX Tracking KPI.
• HFM integration into Central Data Warehouse.
• Centralization of the support for the whole CDW Team Function: Business Intelligence/Data Warehouse Architect (1 years and 4 months) Tasks:.
• Provide End-to-End BI solutions for 14 operations countries (8 in Africa, 6 in LATAM) and 4 HQ countries ( London, Dubai, Miami, Luxembourg ).
• Responsible of the evaluation, selection, management of licenses and training for the whole group of a global BI tool in order to harmonize and centralize the knowledge, the information and the connectivity between the countries.
• Responsible of the evaluation, selection and implementation of a modeling tool for the entire group.
• Integration of financial systems into the Central Data Warehouse (EBS, HFM, Sun Systems).
• Help the Millicom service desk to centralize and organize the support for the whole Central Data Warehouse Team.
• Centralization of the local data warehouses into the Central Data Warehouse

• Business intelligence specialist Project: Implementation of Lombard Online Reporting Data warehouse (LORD and BIIM) Function: Business Intelligence Specialist (7 years) Tasks:.
• Review and refactoring of the data warehouse (flow , organization, methodology and BI services within Lombard).
• Analysis of the existing reporting solution.
• 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.
• Design and modeling of the new Enterprise Data Warehouse.
• Development of the ETL following the development paradigms.
• Development of the Business objects environment (Universes, reports).
• Review and validation of the specifications together with the business analysts.
• Participate / Review the design of the solutions.
• Play a role of a technical ETL specialist.
• Put in place new development and release management processes within the team based on JIRA.
• Implementation of a new source versioning system (SVN).
• Liaise with IT operations team to organize delivery and technical/business support.
• Responsible of the quality of the delivery, respect of scope/deadlines and coverage of the unit/system tests.
• Participate to the scope definition of the releases, and the overall planning.
• Creation of system/technical specifications and functional documentation.
• Development of 700 dataflows for the LORD and ODS projects.
• POC on SAP Data services in order to use JMS.
• Implementation of Real Time JOBS using JMS with SAP Data Services.
• Migration of BO Data Integrator XI R2 to SAP Data Services.
• Testing and support to product/system/UAT tests.
• Data integrator job optimization: parametrization of memory processes, optimization of slow dataflows.
• Data quality process review and repository cleaning.
• Modelisation and implementation from scratch of an ODS in order to load LORD in real time.
• Responsible of full testing phases for LORD and creation of the testing documents (in English).
• Responsible of all data models for LOMBARD IT department.
• (creation, update, consolidation, play the role of architect).
• Business Domains: Life Insurance, Policy and Fund management.
• Securities (setup/pricing/dealing), accounting.

• Design & development of an ESB following the SOA paradigm.
• Play a role of ESB technical architect and definition of the common data model used in the services.
• Integration of applications: CODA: Accounting, Sungard GP3: Fund management, Swift Alliance : SWIFT interface, CLASS: policy administration and implementation of data flows from source applications to ODS/Data Warehouse.
• Development of 50 jobs with exception management, monitoring tool, guaranteed delivery, development & testing framework, and continuous synchronization checks using KPI
• 
  

• Developed object-oriented software
• Built, tested and deployed scalable, highly available and modular software products.
• Generated reports, updated spreadsheets and presented results.
• Developed and managed dashboards using Business Objects.

• Project: Universal screen splitter Tasks:.
• Analyzed and developed the Super Split application allowing the display PAL, NTSC, SECAM and NTSCJ of 64 video sources in real time.
• Integration of the application within a dedicated web server allowing to manage the application on distant servers.
• Coding for the management of the anti-aliasing, wall papers, optical effects (fades...) Environment: Windows NT 4 Server, Windows 95/98, Microsoft Visual C++ 6.0, Microsoft Internet explorer 4.03, TCP/IP (SOCKETS), Web server developed in C.