About Achour
French
Native or bilingual
English
Fluent
Experience
- DPD-FranceSMTP - 365LOGISTICS AND SUPPLY CHAINJune 2023 - October 2025 (2 years and 4 months)Marne La Vallée, FranceMission:Implementation of a BI system for managing shared files on a SharePoint space.Context:The company faced several issues related to the automated distribution of files via Talend.To address these challenges, a new distribution system based on SharePoint and controlled by Talend jobs was designed as part of the SMTP project.To overcome these limitations and modernize the entire file distribution chain, DPD-FRANCE launched the SMTP Project. This name refers to the replacement of the tSendMail component with a sending solution directly based on the SMTP protocol integrated with Azure AD.Key Achievements:
- Study, analysis, and comparison of different solutions proposed for file sharing (FTP Server, OneDrive, SharePoint Space, etc.),
- Creation and configuration of an API on Azure AD,
- Creation of SharePoint sites for file sharing (CSV/Excel),
- Execution and validation of HTTP requests via the MS Graph API and Postman,
- Development of SQL queries and Shell scripts for creating data tables on a local database,
- Design and development of an automated and secure BI system, composed of Talend workflows,
- Performance of unit tests and validation of Talend flows,
- System maintenance, log management, and anomaly tracking,
- Support for the integration team for the production deployment of Talend jobs,
- Writing technical documentation,
- Parcel traceability and tracking,
- Maintenance, optimization, and reliability of various existing critical flows.
- NORSAR TECHNOLOGIESDWH Optimization and ArchivingBANKING AND INSURANCEApril 2021 - March 2023 (1 year and 11 months)Paris, FranceMission:My mission was to implement a BI solution for the detection and archiving of personal historical data.Context:Allianz-Assurance's operational database was facing performance issues. It contained several years of personal data, leading to overload and impacting processing performance.The objective was to keep only 13 months of data in the active database and automatically archive the rest in a Google storage solution, an environment subject to LPD/GDPR compliance requirements.Key Achievements:
- Analysis of the existing system and definition of management rules for identifying data older than 13 months,
- Active participation in Agile ceremonies (daily meeting, planning, review, retrospective),
- Design and development of Talend jobs for DWH population,
- Development of advanced SQL queries and stored procedures in PL/SQL,
- Development of Shell scripts to automate and orchestrate certain processes and ancillary tasks,
- Performance of unit tests and complete validation of Talend flows before production deployment,
- Archiving of DWH historical data to Google Cloud Storage,
- Management of personal and confidential data in a context subject to LPD/GDPR requirements, taking into account protection and confidentiality rules,
- Implementation of rigorous monitoring: log management, anomaly handling, continuous optimization of ETL flow performance, and reduction of the active database volume.
- DATAYard ManagementLOGISTICS AND SUPPLY CHAINJanuary 2019 - March 2021 (2 years and 2 months)Cachan, FranceMission:My mission was to implement a BI solution for centralized logistics flow management and near real-time monitoring of sorting center activities.Context:Amidst an increase in customer complaints and growing delivery time constraints, the client launched a project to modernize its logistics information system.The objective was to centralize and ensure the reliability of data from the sorting center's operational systems within a Data Warehouse, in order to improve flow traceability, anticipate congestion, and optimize logistics operations.In this context, my work primarily focused on the design, population, and reliability of the Data Warehouse.Key Achievements:
- Analysis of the existing system and understanding of logistics data flows,
- Participation in various "Agile" ceremonies,
- Design and creation of Data Warehouse tables (Carriers, Vehicles, Docks, Package Labels, Sections, Routes, etc.),
- Development of Talend Jobs for DWH population,
- Development of SQL queries and stored procedures in PL/SQL,
- Development of Shell scripts,
- Performance of unit tests,
- Management and exploitation of execution logs, monitoring and correction of production anomalies,
- Implementation of the data processing chain, from design to stabilization of the production feed chain,
- Control, traceability, and monitoring of logistics flows.
Recommendations
Be the first to recommend Achour
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
- Training in Business IntelligenceAFPA Roubaix.2018Formation en informatique décisionnelle
- Java JEE Developer TrainingAFPA Roubaix.2018Formation développeur Java JEE
Certifications
- Java JEEAFPA2018