Romain Vericel

MDM ORGANIZATION and EMPLOYEE Project:

- Redesign of the SQL modeling for the database used for this repository

- Development of data integration services from different countries via different sources (API, files, etc.)

"OTE" (Order Transport) Project:

- Order entry screen for delivery drivers with different search criteria display based on the connected user

- Identification linked to Active Directory

"EDI - Dematerialized Invoices" Project:

- Retrieval of invoices in PDF and XML format and integration into the THEREFORE DMS

- Integration of processed invoices into the QUALIAC accounting tool

- Querying multiple databases (ORACLE, SQL SERVER, MySQL)

"Multiple Data Exchanges via Multi-Sources and Multi-Targets" Projects:

- Significant file exchange between FTP servers (source and target).

- Processing of large product files (+100MB)

- Multiple applications (WYND Platform, AKENEO PIM, SHOPPING FEED, Office Depot)

"EDI" Project (EDIFACT IFCSUM & IFTSTA):

- Retrieval of incoming (IFCSUM) / outgoing (IFTSTA) messages and integration of orders into the WINTRANS TMS

- Creation of supervision screens to monitor the evolution of EDI messages in the IS

- Retrieval of GPS coordinates from delivery vehicles

- Creation of supervision screens to track one or more vehicles

"BI" (Business Intelligence) Project:

- Processing of a large volume of data from an AS400/DB2 database to SQL SERVER 2016

- Complex transformation and calculation rules

"OTE" (Order Transport) Project:

- Order entry screen for delivery drivers with different search criteria display based on the connected user (responsive mode for tablets)

- Identification linked to Active Directory

Contract type: Permanent contract

EDI Project for a major French transporter:

→ Exchange via Web Services using OAuth 2.0 authentication

→ Support and integration of the client's TMS (WINTRANS) into the business process

→ Order integration and delivery status emission

→ Creation of technical documentation

→ Monitoring of developments related to business processes in connection with EDI

WMS Project for a major French garden center player:

→ Exchange via Web Services using NTLM authentication

→ Support and integration of the client's WMS (SPEED WMS) into the business process

→ Querying Microsoft Dynamics AX as a data source

CLICK&COLLECT Project for a major French garden center player:

→ Support and integration of the client's OMS (WYND) into the business process

→ Querying the MAGELIA platform as a data source

→ Scoping with all project stakeholders (R&D, developers, external providers)

BLUEBOX Project for a major French DIY retailer:

→ Development of a generic system for supervising file and web service processing

→ File processing (CSV/JSON/XML) between different applications (AFINEO/AKENEO/SAP/UNIMAG)

Contract type: Permanent contract

- Project management and complete development of the group's EDI flows (orders, deliveries, and invoices)

- Training, updates, and design of statistical reports using BO XI 3.1

- Travel to Ivory Coast for the implementation of barcode systems on packages