I use data bases to: Create predictive analytics Cost reduction through automation Create a competitive advantage Creating a value-added consultancy with in businesses vs. rate shopping Connecting to other data bases, to access to all of your information Projects I’ve created that do the above:Automate 360 Transportation Management System Its own rate engine based on Oct 2000 Czarlite and 98 Czarlite Customer specific rates Invoicing AP Dispatching Customer table Multiple reports BOL and Load confirmation Balance sheet Email functionality Daily numbers check – balance books daily What if table Multiple API calls to vendors to automate processes, including REST, SOAP, FTP SOAP to get rates, track, create shipments from server Pare shipment dates to see if can ship together and save money Its own customer log in Its own sales log in – shows reps their numbers, create shipments, commissions Maintained a US and Canadian zip data base Warehouse Management System for Water production facilityPredictive PO management: PO order quantities, PO order time based on demand as shown from created/placed ordersThis creates on time, complete accurate order fulfillment Track PO Id’s (from purchase to POD) for recall scenarios Live order fulfillment for employees on in house monitors Full inventory management Full quality control functionality Customer management BOL Load confirmation QR Code creation per orderMiddleware for small package – connected to these databases with API calls to and from: TMS Driver Application Use the driver route optimization, push that to the Warehouse to load trucks Warehouse Application Routing parcels with in the warehouse for accurate truck loading Route to delivery truck Route to line haul Multiple Carriers to facilitate: Rates Tracking Shipment creation Shipment transfer from middle mile carrier to final mile carriers Customer FTP connections Rate engine based on postal service zones Webhooks to receive data and respond to calls to the serverMiddleware for LTL/Truckload Connected to these databases with API calls to and from: TMS Pipedrive Power BIRegular occurring refreshing the data for live reports Plecto Predictive customer analytics Webhooks Rater that retrieves 6500 rates per hour via API calls REST API call to create shipmentsCurrent company uses the abilities of the system to consult customers on transportation vs. sell rates and creating another rate shopping site, increasing customer satisfaction and profits for both the company and customer.