lijo john

Key Responsibilities:
(Beauty Division - Perfumes and Cosmetics)
• Provided dedicated customer service support to high-profile suppliers such as Estee Lauder, Orveon, and Loreal.
• Prepared and presented weekly Stock on Hand (SOH) reports by brand for the commercial team using Oracle Power BI.
• Generated and analysed weekly sales performance and inventory metrics reports for the commercial team.
• Assisted in setting up promotions and new product launches, coordinating with the commercial team.
• Managed master data, including new product codification, ensured with country of origin, HS codes and currency, updates for products, locations, and suppliers, and communicated assortment updates.
• Created and managed monthly replenishment purchase orders for sellable and non-sellable items, transfers, and returns in Oracle RMS.
• Created Sales Orders from retailers and e-commerce region-wise (UAE, BAH, QAT, KWT, KSA) in Oracle EBS once fill rates for healthy SOH are checked.
• Coordinated with suppliers on order requests, verified supplier invoices and packing lists, and followed up on finance approvals for purchase orders. And ensuring receipt of original stamped documents required for shipment clearance.
• Ensured all products were registered and obtained necessary certificates before shipments by coordinating with regulatory agents and governmental organisations.
• Collaborated with the shipping and warehouse teams to ensure timely clearance of import/export shipments of dangerous and non dangerous goods, addressed discrepancies, and processed claims for shortages, damages, and expired items.
• Process non sellable items like testers/GWP/PLV via Oracle RMS as per commercial needs region wise, and convert sellable items to testers upon special approval.
• Handled financial processes, including verifying 3PL invoices, coordinating payments with the accounts team, and ensuring all logistics records were up-to date for audit compliance.

Key Responsibilities:
(Beauty Division - Perfumes & Cosmetics/ Fashion - RTW, Shoes, Bags, Accessories)
• Managed all purchase orders within the CORE system, ensuring precise system transfers for various movements, including warehouse-to-store, intra-store, inter country, return-to-vendor, and temporary stock loans.
• Monitored and updated the system on back orders, maintaining an up-to-date order log and ensuring timely follow-up with suppliers.
• Addressed brand demands promptly, facilitating efficient merchandise movement and resolving related issues.
• Initiated re-orders as needed to maintain optimal stock levels and coverage.
• Registered and managed sales orders, ensuring all customer shipping requirements were met and necessary documentation was issued.
• Generated invoices upon completion of sales orders and prepared credit notes and other required documents.
• Coordinated between warehouse, office, and sales staff to ensure accurate processing of sales orders and seamless interdepartmental communication.
• Maintained and updated prices in the system, including markdowns and promotions, escalating any issues as needed.
• Ensured timely updates of SKU lists for promotions, marketing events, and discount periods in the system.
• Uploaded replenishment requests promptly, ensuring accurate stock requests during peak periods and maximising sales opportunities.

Chalhoub Group is a leading luxury brand retail company in the Middle East representing a portfolio of 300+ brands, a presence in 14 countries and managing of over 600 retail outlets.
Key Responsibilities:
(Fashion Division - RTW, Shoes, Bags, Accessories)
• Managed seasonal budget data, obtaining information from Finance Control and updating budget-monitoring files to ensure accurate financial tracking.
• Compared manual orders with final orders, resolving discrepancies in collaboration with suppliers, commercial teams, and finance control.
• Created and uploaded item codes and purchase orders, ensuring the accuracy of codes, quantities, prices, and total values.
• Facilitated advance payments by securing necessary approvals and ensuring timely financial transactions.
• Verified supplier invoices against back orders, ensuring receipt of original stamped documents required for shipment clearance.
• Coordinated shipments with freight forwarders and warehouse, overseeing delivery and conducting physical checks.
• Managed after-sales service by communicating with suppliers regarding damaged, short, or excess goods and confirming credit or debit notes.
• Maintained supplier retail prices (SRP) based on coefficients provided by brand managers and suppliers, ensuring accurate pricing.
• Handled document management for ERP entries, including supplier invoices, packing lists, country of origin documents, HS codes, and shipment-related invoices.
• Coordinated goods receipt and pricing with accounts, ensuring timely GRN posting and printing retail price tags as per agreed timelines.
• Region wise Insurance application for monthly received shipments
• For commercial visibility updated delivery monitoring files, track delivery windows, and alert commercial in case of deviations
• Coordinate with retail and brand teams to get return authorization, arrange returns, and follow up on repairs or credit notes.
• Track and receive spare parts from suppliers for boutique repairs.
• Managed advertising materials, boutique staff uniforms, and promotional props according to brand and retail manager allocations.
OTHER WORK EXPERIENCES

 Created, forwarded, updated weekly and monthly magazine distribution sheets for local & GCC distributors as per subscription database (CRM-SAP) & circulation dept.
 Printing press coordination on magazine deliveries to warehouse & distributors with box counts including event copies
 Coordinated with freight forwarders for weekly GCC & International shipments
 Tracked AWBs on status of local, GCC & international deliveries
 Delivery updation with marketing dept. on event copies
 Warehouse coordination on bulk deliveries such as event copies & other hand deliveries on request, stock management, delivery of merchandising materials etc.
 Liaised with accounts for payments of distributors & freight invoices
 Participated in group sponsored events (GITEX) & arranged copies for different stalls

Apparel Group is a global fashion and lifestyle company that caters to thousands of eager shoppers through more than 1450+ stores covering four continents.

Achievements:
Attended London International Book Fair 2005 held at Olympia, London represented the company for buying

Key Responsibilities:
•Publisher catalogue maintenance, IPO and LPO issuance via Navision system (ERP) based on branch and customer requirement, and bestsellers-publisher file updation
•Handled the correspondence with international publishers on orders and other queries such as enquiries and negotiation of prices & discounts, availability, title clearance, embargo, billing, shortage and damage issues
•Coordinated with the UK & US publisher representatives for order status and liaised with the publishers to receive confirmation of shipments
•Liased with freight forwarders on shipment clearance and maintained paper works related to clearance, and sorted import documents
•Prepared the ministry clearance sheets for Ministry of Information, Dubai, UAE and maintained the banned list file
•Provided details for customer enquiries through email, fax and phone, and placed special orders via online and arranged delivery via courier
•Assisted with advertisers / visual merchandisers for layout designs and other creativities for promotion and events
•Conducted frequent market visits
•Monitored stock levels of each titles publisher/branch wise to make sure purchases placed on time to avoid product shortage
•Updated supplier prices / RSP based on notification requests with approval
•Maintained reports on sale through analysis & merging, top 10 reports for various categories, daily/weekly/monthly/annual purchase & sales reports, best selling/worst selling/seasonal wise reports, shipments report, publisher turnover, budgeting reports etc. using Navision system
•Supported group inventory process and ERP implementation
•Warehouse coordination on stock distribution, arranged returns for unsold and requisition of publisher credit notes
•Formulated the overseas files for the system and forwarding the daily shop in & out transactions
•Maintained overseas invoices entries in the system & making the purchase of respective overseas branches
•Performed accounts coordination for payments, checking freight invoices along with keeping a log of import & export and supplier/publisher invoices due for payment