Jugurtha Melahi

E-COMMERCE PROJECT - AUTOMOTIVE PARTS SALES WEBSITE (FULL REMOTE), ALGERIA

Objective: Short-term assignment aimed at supporting the project team in all Data aspects, from database modeling to setting up key indicators for customer and commercial monitoring.

• Design and structuring of the product database: relational modeling with PostgreSQL, creation of tables, views, and indexes for multi-category management (OEM, vehicles, parts families…)

• Implementation of the backend data architecture with Flask, ensuring consistency, scalability, and compatibility with future API modules, search, etc.)

• Development of advanced scraping scripts for extracting product information from specialized sources (7zap, Partsouq)

• Cleaning and structuring of collected data for integration into the product database

• Design of a Power BI dashboard presenting key KPIs (popular products, conversions, projected ROI)

• Ongoing implementation of email campaign tracking (clickers, openers, bounce rate)

• Facilitating workshops to identify client functional needs

Objective: Within the Corporate Risk Department, in collaboration with the Data Protection Officer (DPO), I provided my technical expertise to design and implement solutions meeting business requirements for compliance and data management. My role was to ensure the operational translation of functional needs within a demanding regulatory framework (GDPR).

• Creation of a Python application to automate data comparison between two internal registers.

• Automation of extraction, transformation, and comparison steps using Python libraries, while generating detailed reports on detected inconsistencies.

• Integration of pre-trained models (e.g., BERT) for anomaly detection and data quality assessment

• Advanced data preprocessing with NLTK and spaCy (cleaning, tokenization, semantic analysis).

• Creation of automated data pipelines (SQL, Excel, SharePoint) with unit test management and validation on real datasets

• Design of dynamic Power BI dashboards for monitoring risk and data protection KPIs

• Implementation of GDPR controls and management of personal data breach registers.

• Conducting risk analyses to identify, assess, and prevent risks related to personal data.

• Participation in raising employee awareness on Data Privacy and GDPR issues