Freelancer profile translated to English.
Back to original languageAbout Moslem
I am a Senior BI & Data Engineer with 15 years of experience in data architecture, ETL/ELT integration, and data governance, in regulated sectors (Swiss public sector, insurance, industry).
My expertise includes:
• Design and industrialization of ETL/ELT pipelines (Talend DI & ESB, SSIS, ODI, Stambia)
• Business intelligence modeling (Kimball methodology — star, snowflake, Datamarts)
• Advanced SQL on Oracle and SQL Server (query optimization, stored procedures, batch processing)
• Master Data Management and data repositories (MDM)
• Data visualization (Power BI, Tableau, SSRS)
• Data governance: quality, standards, documentation
Project references:
• State of Fribourg (2 years 10 months): 2 cantonal MDM repositories, 50 Talend ESB routes, 20 REST APIs, SQL optimization -99% logical reads
• AG2R La Mondiale (2 years): Group Data Lake on Cloudera/Spark, 6+ integrated Business Units, 30+ ODI/Stambia workflows
• ALMERYS Santé (2 years): Talend ESB flows, health file parsing (NOEMIE, B2) — several million lines/month
French
Native or bilingual
English
Fluent
Arabic
Native or bilingual
German
Basic
Can work on-site
Paris (up to 50km), Lyon (up to 50km), Strasbourg (up to 50km)
Experience
- DigilinksSenior BI ConsultantSOFTWARE PUBLISHINGJanuary 2025 - Today (1 year and 7 months)Paris, France
- Refactoring of existing flows to improve performance, reliability, and maintainability.
- Development of complex SQL treatments (Oracle / SQL Server).
- Implementation of data consistency and quality checks.
- Technical documentation of flows and adherence to industrialization standards.
- Operational support for Data teams in 100% delivery activities.
- TEAM PARTNERS/BLUESOFTData & Integration ExpertPUBLIC SECTORMarch 2022 - December 2024 (2 years and 9 months)Fribourg, Switzerland
- Design and development of 2 cantonal MDM repositories (individuals + companies/establishments) serving as a single source of truth for the Fribourg administration.
- Development of 50 Talend ESB routes and 50 Talend DI Jobs for populating and synchronizing repositories.
- Development of 20 REST APIs for exposing Elasticsearch indexes, reducing response times to less than 2 seconds.
- Critical SQL optimization: 99% reduction in logical reads (5 million → 4 logical reads) on the bottleneck query.
- Critical stored procedure optimization: 3 sec → <300 ms (−90%) via targeted indexing.
- Industrialization of deployments via Jenkins CI/CD on TAC.
- DATA ANALYTICASenior Data ConsultantHEALTH AND WELLNESSSeptember 2018 - September 2021 (3 years)Toulouse, FranceClient AG2R La Mondiale:
- Architecture and deployment of the group Data Lake on Cloudera/Spark: centralization of flows from 6+ Business Units.
- Development of 30+ ingestion workflows (ODI + Stambia) covering life insurance, retirement, and provident funds.
- SQL optimization on Oracle: refactoring of critical queries and procedures.
- Definition of Data development standards adopted by 15 developers.
- Writing technical specifications and estimations in Agile/Scrum mode.
Other Clients:- Sopra Steria/Airbus (migration of aeronautical data to PLM ARAS, Talend DI 7.1)
- Owliance (migration Talend v5.4 → v7.1)
- Liebherr (migration SSIS 2008R2 → 2016)
Recommendations
Be the first to recommend Moslem
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master II in Information Systems and Decision SupportUniversité Lille I2012
Certifications
- PL-300 Microsoft Power BI Data AnalystMicrosoft2025
- DP-700: Microsoft Fabric Data Engineer AssociateMicrosoft2025