Arun Aggarwal

Experience

• 

  Ranbaxy Laboratories Limited

  Apr 1989 - Mar 2015

  Senior Executive Commercial and Exports (Global Logistic Operation)

   Creation of sales order-Inquiry: Quotation, Free sample, Letter of credit(Loc), Invoice Instruction/Allocation(INI), Pre-Shipment document(PSI)/Billing document, Airway Bill/Bill of Lading instructions(BLI), Airway Bill/Bill of Lading(BOL),Post Shipment Documents(PSG),License wise DEEC Declaration, Freight Report, Pending Documents Report, On-line tracking of order from order to billing stage, On-line availability of stock etc.Domain Expertise 25 years of Association with Sun Pharma (erstwhile Ranbaxy Labs Ltd, Mohali as Sr.Executive Commercial and Export Operations (from 1989 to 2015).  Experienced in handling entire gamut of Export related Supply Chain and Documentation activities for Pharma, API products, including streamlining processes to reduce delivery time and implementing systems/ SOPs to standardise processes.  Resourceful in coordinating Logistics and Warehouse and Stores Operations including Planning, Order process, Establishment of Letters of credits and Amendments (L/C), negotiation with service providers like CHA's and Shipping and Air Cargo as well as liaising with internal and external customers.  Proficient in managing contract manufacturing activities for APIs. An effective communicator with excellent team leadership skills, strong analytical, problem solving & organisational abilities. Show less

• 

  SUN PHARMA Erstwhile Ranbaxy Laboratories Limited

  Apr 2015 - Sept 2015

  SME SAP GTS-SD Module Functional Consultant

  SAP FUNCTIONAL PROFICIENCY SD Module : Sales & Distribution :Creation of (COM Cycle)Export Sales documents Inquiry, Quotation, Sales Order, Free of Charge (FOC) Sales Order, Returns Order, Creation of delivery and ship it to customer, Invoice the delivery, Post payment to customers account, Debit/Credit Notes. Master data : Creation of Customer master, Global Vendor/Supplier,Product Master, Currency Master, Bank Master Data, Port Master Data, Country Master, Pack Master Data, various reports –like Freight report(Country/Region wise), daily pending documents report etc. Account Receivable: Treasury Cash control, Cash forecast, Delivery date, payment terms, Cash Management Position, Payment settlement by due date. Credit Management: Credit data for each customer, Assigning Credit Limit, Credit control, Credit Limit Exceeded order blocked for delivery, Risk Rating & Automatic blocking of customer in all sales organizations in case of cheque default, Managing credit and Revised Credit Norms. Complaint Processing: Receipt of complaint from customer, Investigation of complaint and letter to the customs/RBI for Permission to Recall the goods, Letter to customer to for Return of stocks after receipt of permission from RBI, Receipt of goods and custom clearance of the same, creation of Return Sales order delivery and posting to the stocks to Return storage location.GTS (Export Module) : Selection of Sales Organization, Distribution Channel, Division, Shipping Points, Sales Plant, Storage Location. Customer Export order Cycle: Receipt of Sales Order, Creation of Sales Order, Raising STO, Request to Plant for Goods, Process Delivery, Goods receipt at W/H, Release of D/o, Documents to CHA, Picking and Delivery to CHA, Custom Clearance, Handover to Shipping Line for Shipment of goods, Negotiation of documents and Receipt of Payment. Show less

• 

  ICI Healthcare, Gurgaon

  Oct 2018 - now

  Senior Manager Logistics Operations-Consultant