Administrative Assistant Power Bi

LISA CLUTTER

720-***-**** adyruj@r.postjobfree.com

Experience:

Lumen Technologies Littleton, CO Freight Analyst II 07/2019 -present Key responsibilities: SME for Transportation. LTL, TL and small parcel shipments. Audit: pricing analyst, fall-out analysis with 3rd party freight payment provider, CAST roll off containers billing analysis for regional US locations in the Lumen network. Main liaison to project managers and engineers resolving issues with TMS job related LTL and TL shipments. Monitored accuracy of OTR transit, on time delivery and correct site addresses through address matrix accuracy. Processed LS&D claims with our 3PL for LTL and TL shipments. Managed cost avoidance logs to quantify freight, claims, and LTL savings metrics and reported to Director level. Oracle, SAP Fiori, Power BI, Office 365, Teams Z Casino/Bullwhackers Black Hawk, CO Internal Auditor 06/2016 07/2019 Key responsibilities: Hotel and F&B daily audits and reconciliations. Weekly Excel reporting of Micros data for F&B usage to forecast trends with management. Analyzed pricing discrepancies from daily audits to F&B management. Entered revenue for all venues into Excel J/E reports and verified accuracy for end of month close. RMX Global Logistics Evergreen, CO Logistics Coordinator/Freight Broker/Freight Auditor 09/2013 - 06/2016 Key responsibilities: Tracking freight, real-time customer updates and problem resolution. Scheduled both pick-up and delivery appointments. Developed new business leads, RFQ and RFP for refer LTL and TL carriers. Spot market bids loads via LEAN logistics. Processed, verified accuracy and scanned carrier paperwork for AP billing.

Monarch Casino - Black Hawk, CO - Purchasing Assistant 07/2011 - 09/2013 Key responsibilities: Analyzed RFQ and RFP casino, facilities, and F&B. Processed open requisitions into POs and monitored until delivery. Managed warehouse inventory par levels and quarterly usage reports. Overseen monthly cycle counts in the warehouse. Key liaison working closely with the finance department obtaining credits for pricing overcharges, variances, and vendor statement discrepancies. Negotiated RFP and RFQ rates for LTL shipments with carriers. AS400 EXCEL OUTLOOK

Wildcat Minerals - Golden, CO Logistics Specialist 06/2008- 06/2011 Key responsibilities: Developed and maintained the freight rate database of Railroad Tariffs and monthly fuel surcharges for railcar shipments. Reviewed freight and demurrage bills for accuracy, disputing accordingly. Handled L,S&D with a success rate of 98% of claimed losses. Monitored, tracked and updated TMS on all shipments using BNSF and UP pipeline inventory reports.

AAA Operations - Dumont, CO - Administrative Assistant Key responsibilities: Answered multi-line phones Accounts Receivable transactions using QuickBooks. Completed bank deposits for two water municipalities. Responsible for verifying timesheets for payroll. Responsible for inbound and outbound billing statements and payments. In-house lab water testing: Monthly reporting to the State of Colorado DOH’s Water Quality Division.

Pacer Global Logistics (now RXO)- Dublin, OH - Intermodal Team Leader 01/1995 - 06/2006 Key responsibilities: Led a team of eight employees. Established benchmarks for cost efficient processes. Negotiated demurrage and storage reimbursements. Company’s SME specializes in forecasting transportation trends and reporting daily to internal and external customers regarding the trucking and intermodal market . Excellent working relationship with all North American, Canadian and Mexico main and interline railroads resolving transportation delays. Education and Skills:

Duquesne University Pittsburgh, PA - Associate's Degree - Computer Science/Business

Proficient with the following software: Microsoft Office products, Teams, QuickBooks, Power BI, Access, AS400, McLeod, Lean Logistics, SAP, Fiori, Oracle TMS, and Stratton Warren. ISO 9001 and Hazardous Material awareness certified.