TECHNICAL SKILLS:

Excel Skills: - advanced formula creation and auditing, nesting formulas, VLOOKUP, cell styles, text to columns, concatenating, advanced sorting and filtering, conditional formatting, advanced chart making, pivot table and pivot chart creation, VBA and Macro creation

Access Skills: - using design view to define fields, data types and properties, primary key fields, advanced filtering, indexing, creating table relationships, using Wizards to create queries, forms and reports, query creation using multiple tables, using SQL to expand query options, create table queries, append queries, upde queries, crosstab queries, using AND/OR criteria, calculated fields, grouping, working with null, creating forms and subforms, form design, creating reports, report design, working with external data, importing and exporting, integrate Access with other office products like Excel and SharePoint, VBA and Macro creationat

PowerPoint Skills: - using design views, changing layouts, background designs, using outlines, adding slide transitions and animations, using drawing tools, adding sound and video, automating slideshows to run automatically, integrating Excel charts and reports, linking objects, inserting hyperlinks

Miscellaneous Skills: Microsoft Visio, Microsoft Project, Outlook, Outlook Express, Lotus Notes, SharePoint Training, Visual Basic training, SQL Training, database management

WORK EXPERIENCE:

Confidential, Novi, MI

Senior Logistics Specialist

• Facilitate customer communication for Lineage Logistics Southwest region team OS&D issues and follow up with Lineage Carriers and OSD department for claim liability protection.
• Lead Account representative for high maintenance Lineage Customers.
• Track and trace all past due shipments for Southwest, Midwest, Northeast and Texas Region carriers.
• Design and create an automated email database to send customized update lists to Lineage Logistics carriers for past due updates.
• Create and generate ad hoc reports from Lean Logistics TMS to feed into carrier email databases daily.
• Generate aging load reports and follow up for Lineage Logistics carriers for immediate past due updates.
• Act as an ad hoc customer account representative for high pressure transportation failure recovery track and trace.
• Monitor Lineage Logistics email group distribution for outstanding issues and respond immediately.
• Create Profit/Loss database to generate individualized Southwest Region Profit/Loss reports to be distributed amongst load planners for carrier rate corrections.

Business Analyst

• Provide analytical and technical support on confidential Ford Motor Company sales and marketing technology update.
• Act as a liaison between functional departments to ensure scope cohesion
• Ensure process documentation for internal departmental meetings
• Prepare ad hoc reports and standardize presentation data formats for clarity
• Work with purchased service groups to ensure necessary resources are available to facilitate completion of statements of work
• Plan and design a manpower and resource Access database to ensure up - to-date data recording, provide ad hoc query functionality and accurate departmental reporting features.

Business Analyst

• Use database management skills to design and implement a Manpower and Materials database for the Powertrain Controls Engineering Division (PTC).
• Create Manpower Model Charts to display full time equivalent (FTE) employees by PTC department that are related to approved vehicle program changes.
• Create Direct Materials Reports to display prototype vehicle parts and tooling costs, as well as purchased service and supplier development costs by PTC department that are related to approved vehicle program changes.
• Create ad hoc reports as requested to display required dynamic data from the Manpower and Materials database.
• Consolidate departmental responses to major vehicle platform studies into a single response for submission to the program review board.
• Responsible for creating a Direct/Indirect/Non Production Material and Manpower reconciliation process with procurement requests to allocate planned versus actual spend and maintain the current reconciliation budget
• Responsible for designing departmental training for the reconciliation process.

Supply Chain Manager

• Act as a liaison between operations, engineering, service providers, suppliers and customer plant/warehouse locations to meet or exceed established service agreements.
• Track, analyze and communicate key performance metrics.
• Drives best practices with operations managers and customer service operations.
• Ensure service providers understand and accept customer guidelines and requirements for all logistics operations.
• The main point of contact for all tactical customer related actions, issues, etc.
• Initiate and follow through on projects to implement savings initiatives, network optimization opportunities, launch initiatives, and expansion opportunities.

Logistics Analyst

• Design and implement routing solutions based on current North America production plans.
• Optimize route design to reduce transportation spend.
• Be able to resolve situations quickly, communicate status of problem, and work with the appropriate subject matter expert until it is fixed.
• Participate in process improvement teams and cost saving initiatives.
• Lead analyst on Navistar rack return special project.
• Provide analytical and IT expertise to launch a new technology solution that provided BOL, Customs and track/trace solutions regarding rack shipments for Navistar Container Management.
• This special assignment required a high degree of flexibility and travel to provide on-site support at customer facilities and plants; therefore, a strong understanding of plant operations and network logistics was required.
• Required a high level of customer interface via face to face meetings, conference calls and email with Regional Logistics Managers, Plant Managers and Corporate VPs.
• Provide Month over Month cost savings reviews with customer for eventual $7.8 Million annualized savings fiscal year 2010.
• Generate and report weekly rack project service metrics for customer conference calls.

Logistics Coordinator/Customer Service Specialist

• Manage dedicated inbound transportation for Navistar assembly plants.
• Perform needs assessment for Navistar suppliers requesting ad hoc routing and broker load for optimal service and cost.
• Maintain working knowledge of weekly supplier EDI 830 requirements
• Act as a liaison between Navistar suppliers, carriers and plant MFU contacts.
• Provided back up MFU support both on-site at assembly plants and remotely via on call support.