You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Achour KacherAK

Achour Kacher

Talend Developer | SQL/PLSQL | Logistics/Supply Chain

€450/day
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Achour

With over 6 years of experience in Business Intelligence, I have acquired technical and functional expertise on various BI projects and business sectors.

What I offer:

- My skills and expertise: Strong command of SQL, PL/SQL, Java languages, Talend, Informix, PostgreSQL, MySQL, Oracle tools, and platforms like Azure AD, SharePoint, etc.

- My know-how: My main interventions include the design, population, and optimization of BI solutions, development, integration, deployment, and migration of data flows (from Talend 7.3 to Talend 8.0) while ensuring data quality and ETL flow reliability.

- My attitude: If you are looking for a motivated, autonomous, and experienced BI developer or consultant capable of transforming your data into concrete decisions, do not hesitate to contact me to discuss your project and needs. I would be delighted to assist you in implementing high-performing BI solutions tailored to your organization.
  • French

    Native or bilingual

  • English

    Fluent

Remote only
Primarily works remotely

Experience

  • DPD-France
    SMTP - 365
    LOGISTICS AND SUPPLY CHAIN
    June 2023 - October 2025 (2 years and 4 months)
    Marne La Vallée, France
    Mission:
    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.
    Talend Azure AD Postman MS Graph SharePoint Administration
  • NORSAR TECHNOLOGIES
    DWH Optimization and Archiving
    BANKING AND INSURANCE
    April 2021 - March 2023 (1 year and 11 months)
    Paris, France
    Mission:
    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.
    Talend PostgreSQL SQL OpenProject Git
  • DATA
    Yard Management
    LOGISTICS AND SUPPLY CHAIN
    January 2019 - March 2021 (2 years and 2 months)
    Cachan, France
    Mission:
    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.
    Oracle 11g SQL Developer Shell Talend Open Studio SQL

Recommendations

Be the first to recommend Achour

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Training in Business Intelligence
    AFPA Roubaix.
    2018
    Formation en informatique décisionnelle
  • Java JEE Developer Training
    AFPA Roubaix.
    2018
    Formation développeur Java JEE

Certifications

  • Java JEE
    AFPA
    2018
    SQL Developer Java Web Application Development Oracle PL/SQL Visual Studio Code Shell HTML/CSS Eclipse IDE Apache Tomcat SQL

Skill set

Categories