Robert Bannon Email and Phone Number

SQL and VBA programming for report writing and other tactical solutions.

• Business lead in the development of a regulatory web-based reporting application• Responsible for daily reporting of Basel regulatory requirements for securitizations• Utilizing SQL and Excel VBA to create various automated regulatory reports• Creating Ad-hoc reports as requested• Subject matter expert for SSFA (Simplified Supervisory Formula Approach)/SFA (Supervisory Formula Approach) for Basel regulations• Debugging SQL stored procedures and data discrepancies

• Responsible for all branch operational metrics relating to customer service, warehousing, purchasing, inventory control and management, and SOX compliance across 20 branches• Key participant in the hiring of new Branch Operations Supervisors• Daily support for branch operations (Branch Operations Supervisor, Customer Service, and Warehouse personnel) including initial training and implementing new procedures • Liaison between branch operations and corporate personnel• Team Leader for fit-gap analysis for new ERP implementation, creating flow charts for all existing procedures and identifying all gaps and fits within the current ERP system• Team member participating in new ERP implementation• Responsibilities included in the Inventory Analyst Role

• Responsible for 12,000 inventory SKUs in 20 branches and 7 consignment locations• Reviewing of all inventory usage and order controls to support proper stocking levels while reducing risk of excess and obsolete inventory• Supervising and auditing physical inventories for 20 branches • Performing safety inspections, discussion and correction of warehouse facilities• Developing standard operating procedures and/or training modules for: Shipping, receiving, order picking, cycle counting, warehouse organization, etc.• Training employees on best practices concerning warehousing; shipping and receiving; order controls and stocking levels; and purchasing• Co-creator in the formation of an in-house nonconformance and quality issue website and corresponding procedures • Responsible for approving, documenting and auditing SOX compliance for inventory transactions, including customer returns and inventory adjustments• Increased inventory accuracy from 54% to 94% by utilizing the above-mentioned procedures and training• Team Lead in switching the third largest warehouse to a warehouse management system• Communicating and working with Accounts Payable and Accounts Receivables on any issues concerning inventory• Creating various reports for operational metrics; inventory accuracy, excess and obsolete, warehouse efficiency, etc. and ad hoc reports as needed

Ran all aspects of lab for creating eye glasses, from ordering material to inspecting the final product

• Developed and ran cycle counting system • Researched inventory discrepancies for root cause and recommended procedural changes• Supervised physical inventories• Created purchase orders for suppliers • Notified and resolved receiving discrepancies with all suppliers• Implemented and trained employees on receiving procedures• Teamed with Accounts Payable and Accounts Receivables on any issues concerning inventory• Customer service for inside sales • Reduced yearly inventory loss by 50% in the first year

• Increased scrap accuracy by 90% by implementing new scrap reporting procedure• Supervised shipping department (four direct reports)• Developed and ran cycle counting system • Supervised quarterly physical inventories• Developed back-flushing procedure for production reporting• Ran the MRP system and scheduled releases for raw material • Set up routing and bill of material for new items• Followed up with suppliers on any scheduling or receiving issues• Performed all aspects of shipping and receiving, and customer service back-up• Responsible for QS9000 documentation and adherence for shipping and receiving• Sent ASNs (advance shipping notice) for outgoing shipments