Supply Chain Analyst / Purchasing Agent
Dfw Airport, Texas, Us
1. Analyzing over ten million dollars worth of moving inventory with extensive data mining, SQL, and Excel modeling2. Developing an Excel database to show inventory worth based on product life cycle analysis and projected usage and establishing internal controls to keep inventory levels at targets3. Maintaining an Excel cost analysis database for engine part repair costs made with General Ledger records and developing statistical tools to show projected costs taking into account cost types (direct labor, direct material, overhead, and outside vendor), cost variance, and cost saving measures4. Creating, monitoring, and closing jobs for engine parts due to be sold to customers on a deadline in addition posting all associated General Ledger transactions5. Creating, tracking, and closing purchase orders while doing process improvements6. Extensive experience researching General Ledger records to help Accounting Department reconcile Accounts Receivable and Inventory cost issues