L’Oreal DUBAI: March 2011

I went to L’Oreal Middle East (LOME) Office in Dubai to work on the standard B1 processes setup and the L’Oreal Core Model adaptation and setup for the Pakistani subsidiary of L’Oreal (LOPAK).

I worked on this project together with LOPAK key users (sales manager, purchase manager, financial responsible, controller and stock responsible) and they were supported by LOME B1 project manager for L’Oreal process issues  and IT manager for infrastructure and B1 administration issues because LOME represents the hub of L’Oreal Middle East and Africa B1 projects. The first implementation in this zone has been done for Dubai subsidiary by VISEO in 2009.

I organized different workshops with the key users in which we had setup the B1 standard processes (Administration, financials and logistics: sales, purchasing and stock management).

Then we worked on the Core model setup. The implemented addons in this project were:

-          Extrafields: to manage products (items) hierarchy, customers hierarchy, add a tab on Purchase Order window and add a window to B1 main menu to manage L’Oreal Core Model setup

-          Price Hierarchical Management (PHM): to manage item prices following item hierarchy definition, marketing campaigns

-          Pricing: apply pricing strategies defined by PHM addon on Sales Order line level then on the Document Total level

-          Split Pick Lists: Split pick list following the comparison result between  the customer truck volume or weight defined by Extrafields addon on Customer level and the Sales Order volume or weight defined by Extrafields addon on item level

-          Substitution addon: Two kinds of items substitution (needs to deactivate B1 standard substitution):

o   Automatic: on sales order level

o   On shortage: while picking the Sales Order

The implemented interfaces were:

-          Sales order import: Import files provided by LOPAK customers and transform them to Sales Orders in B1

-          Purchase Order export: export B1 Purchase Order as a Sales Order file to send it to LOME or to the factory then they can import them as Sales Orders on their B1

-          Stock Interface: compares the stock level between Logistic Partner and B1 inventory

In parallel with setup workshops we did training workshops with the key users by area. This made the setup easier and efficient.

Picture of me taken with Burj Khalifa
the highest skyscraper of the world 

This project phase coincided with the cricket world cup. The final game was played by India and Pakistan. Pakistani lost and the project team was very sad because cricket is the most popular sport in Pakistan.