Tracked orders placed to 200-plus vendors daily. Updated items discontinued or out of stock on PO. Updating status to customer. Oversaw daily uploading of tracking from FedEx and UPS to upload into Oracle (Art.com order system). Ran daily reports to track open PO's without tracking and then emailed vendors to request tracking. Wrote and developed variety of Excel shortcuts to consolidate data from multiple report into one form with pivot tables.• Created reports in FedEx and UPS for incoming shipments resulting in saving two hours a day. • Streamlined drop ship order tracking process to save time.• Partnered with vendors to deliver time sensitive items that resulted in faster delivery to customers.• Delivered customer service support to internal clients by timely follow up on customer issues.• Improved operational KPIs of in-stock by 10%.• Reduced obsolete inventory by 5% YOY by managing clearance items.• Increased customer on time delivery by one day by monitoring vendor shipment times.