John Dain Jr Email and Phone Number

Using Alwin, AS400 and Windows Express to ensure non-standard orders that cause system errors get processed correctly by manipulation of dataUse salesforce to contact correct Customer Service Reps on any customers’ orders that need clarification for processing.Use of AutoCad to align window grids and draw out Window Shapes and Grids

Performing Database Entry in AS400 to fulfill capacity for Five Main PlantsUses SQL Server Report Services to extract Plant Product Line Data to fulfill capacitiesUses Pivot Tables in Excel to derive plant capacity data to assist with fulfillmentDetermines Root Causes and Patterns for back-ordered products and serial numbers for Akron Plant by use of Window's Program AlwinUses Outlook to communicate with Customer Service and other departments for various needs and rush requests

Performed Database Entry in various programs for customer service siding, including AS400, BAP, Salesforce, AIMS, and VMSInvestigates issues with siding orders and credits, Responsible for customer experience, issue resolution and customer satisfactionUtilize Outlook and Microsoft systems to assist with various internal communications and communications with customers.

Executive Account Handler for Echo Global Logistics and Blue Grace LogisticsPerformed database entry using industry specific logistical tracking systems McLeod and CoyoteUtilized Excel for coordinating / tracking shipments in conjunction with McLeod and CoyoteHandled sales and billing inquiries for major 3rd party logistics firms through email and phone calls averaging 60-100 per dayCommon day-to-day issues included incorrect pricing / invoices, insufficient fund issues, lost checks, lost invoices, update on status, update on shipment status / location, etc.Utilized Adobe for troubleshooting and editing invoices as well as transferring PDFs to .jpeg images as needed

Assisted customers with packing of groceries and carrying outStocked shelves, retrieved carts, cleaned and organized work areas and operated cash registersManaged and operated computer systems for balancing media such as checks and bank statementsFound solutions to cashier mistakes and general computer and accounting errorsAssisted 100 to 150 customers a day and sixty-thousand dollars plus in business