JESTIN JOHNEY

• Processed 400+ B2B/B2C orders/day with 99% accuracy; improved OTIF from 60% to 95% by tightening ATP rules and proactive expediting with 3PLs.
• Coordinate pick–pack–ship with warehouse; allocate stock, prioritize backorders, and expedite shortages with suppliers to protect service for key accounts.
• Track AWBs/manifests and resolve exceptions (NDRs, address/dimension issues, delivery reschedules); provide proactive status updates to customers/sales.
• Reconcile GRNs, Delivery Notes, and physical counts; reduce mismatches and improve inventory accuracy through daily checks with MIS and warehouse.
• Build Excel dashboards for perfect order, backlog aging, and delivery SLAs; cut manual reporting hours and enable weekly S&OP reviews.
• Enhanced productivity through effective resource allocation and schedule management.
• Evaluated performance metrics regularly, identifying areas needing improvement or attention promptly.
• Ensured accuracy in order fulfilment with meticulous attention to detail.
• Managed inventory of lab supplies to prevent stock shortages or over-ordering.

Achievements :

• Processed 300 B2B orders/day with 100% accuracy; lifted OTIF from 95% to 97% by tightening allocation rules and faster exception handling.
• Cut order→dispatch cycle time 45% (5.5Days → 3Day) by automating e‑invoice/e‑way bill and standardizing pick‑pack handoffs; maintained 300 B2B orders/day.
• Reduced backlog aging from 4 days to 2 days through daily shortage calls and prioritized allocations for key accounts.
• Improved inventory accuracy to 100% by reconciling GRNs vs Delivery Notes and fixing scan/SKU mismatches.
• Lowered delivery exceptions/NDRs by 95% via better address validation, packaging standards, and closer 3PL follow‑up.
• Built Excel tracker for perfect order, backlog, and SLA; saved many hours/week of manual reporting.
• Coordinated daily pickups with delivery partner; improved delivery SLA and reduced claims.

Core responsibilities:

• Owned end‑to‑end OTC: Sales Order entry → allocation (ATP) → pick–pack–ship → invoicing → returns/RMA and credit/debit notes.
• Coordinated daily with Warehouse, Logistics, Sales, and Finance to meet ship dates and clear credit/compliance holds.
• Scheduled dispatches and tracked AWBs/manifests; resolved delivery exceptions (NDR/POD issues, reschedules) with 3PLs.
• Managed inbound/outbound stock movements; monitored shortages and triggered supplier follow‑ups
• Maintained price lists/tax details (GST/HSN) and ensured e‑invoice/e‑way bill compliance.
• Communicated proactively with customers on status, changes, and escalations; closed disputes/claims.
• Created SOPs and trained new team members on order exceptions and dispatch workflow.

Tools:

• ERP: Tally ERP | Analytics: Excel (Pivot, XLOOKUP, VLOOKUP Power Query), 3PL/Couriers: [Blue Dart, DHL, others]

• Generated pick lists and shipping labels; coordinated pick–pack–ship with warehouse to meet daily cut‑offs.
• Peak volume: processed during season, maintaining service levels.
• Created invoices and dispatch documents (e‑invoice/e‑way bill if applicable); prepared AWBs/manifests and booked pickups with Blue Dart DHL
• Tracked shipments and handled exceptions (POD follow‑ups); kept sales updated.
• Assisted GRN posting and stock inward/outward logs; performed weekly cycle counts and reconciled variances.
• Processed returns/RMAs and prepared credit/debit notes; quarantined damaged goods and updated inventory records.
• Maintained Excel trackers for daily dispatch, backlog, and returns; reduced manual errors and improved visibility for supervisors.

Tools:

• Tally ERP(only bulk uploading), Excel (Pivot, VLOOKUP), barcode scanners/label printers, Blue Dart DHL portal.

• Supported end‑to‑end order processing: Sales Orders → pick‑pack‑ship.
• Created pick lists and shipping labels and packing lists.
• Handled stock inward/outward scanning and separating as per model.
• Helped cut order→dispatch time by batching pick lists and pre‑printing documents.
• Peak volume: supported by scanning and packing up to 1000 orders/day during season.

Tools:

• Excel(only used for stock barcode scanning), barcode scanners.