Supply Chain Analyst - Data Visualization & SAP Expert

Michael Hodges, MBA

Email: ************@*****.*** Cell# 678-***-**** Atlanta, GA

Supply Chain professional with expertise in multiple logistic functions including dash boarding, data warehousing, routing shipments, data gathering and reporting, analysis, freight payment, forecasting, project management, rate negotiations, and inventory management. Strong analytical skills and ability to present data with data visualization software. Expert in Microsoft Excel, Microsoft Power BI, SAS, Access, Word, PowerPoint, Visio, Transact-SQL, Java, and Tableau. Subject matter expert in SAP (EWM/WMS), TMS, and OTM. Possess strong communication skills with the ability to provide solid operational analysis and planning.

Areas of Expertise:

Project Management

Data Visualization

Warehouse Management

Operations Management

Supply Chain

Contract Negotiation

Data Analytics

Process Improvements

Lean and Six Sigma

Professional Experience

Mercedes Benz USA, Atlanta, GA (Contract Assignment) December 2022 – Present

Supply Chain Analyst

Responsible for material changes, updates, and PDC changes in Paragon.

POC from various teams in the organization for material changes and tracking processes.

Responsible to fulfill MB customer requests to efficiently serve the end customers (MB dealers) orders/demands.

Maintain relevant KPI’s for parts master and Transportation management visibility and application for business decisions and process improvement.

Campbells Soup, Camden, NJ (Contract Assignment) December 2021 – July 2022

Transportation Analyst

Develop KPI and other reports to communicate metrics for best practices and implementation using advanced Excel tools such as Pivot tables, V-lookups, Macro, etc.

Effectively manage DSD locations for optimal routing.

Perform supply chain analysis and support for new product introductions, P&L changes, cost to serve analysis, logistics channels, co-packer opportunities and special supply chain projects for business teams. Created analyses, monitor performance and present the results to the supply chain management and local teams.

Utilized SAP, TMS, and dashboard software to acquire and present data for reporting.

Generates weekly reporting on cost and operating metrics using advanced Excel tools.

SOUTHEAST CONNECTIONS, Conyers, GA December 2020 – September 2021

Procurement Analyst

Utilized Power BI to publish and manage KPI’s, daily reports, and other ad hoc projects.

Worked with sales and local operations to communicate new orders and forecast goals.

Ensured the integrity of and validated the data supplied by the operations team, ERP system and other databases used to report metrics and performance.

Identified opportunities for process improvement (people, process, and technology) to increase efficiency within the Supply Chain organization.

Lead and supported in the automation of data collection, reporting and dashboards to reduce cost.

AUTOPLUS, Kennesaw, GA November 2018 – February 2020

Supply Chain Business Analyst

Utilized Power BI to perform and manage KPI reporting (Actual performance compared to business plan)

Serve as point of contact for reporting issues with operations, data and existing KPI’s

Created SQL queries to research, analyze and troubleshoot data and create business reports

Primary decision-maker for real time problem resolution

Identify opportunities for process improvement to increase efficiency within supply chain organization

Participate in ongoing training and analysis focused on driving consistency of data across the supply chain for ongoing KPI and ad hoc research

Basic knowledge of data design principles

PURCHASING POWER, Atlanta, GA April 2015 - November 2018

Data Analyst

Experience performing data analysis through working with stakeholders on requirements and business processes

Managed and executed cross functional projects (Such as the deployment of reverse logistics strategy)

Utilized Tableau to create and distribute daily, weekly and monthly dashboards (KPI’s) to relevant business units

Created and maintained strong working relationships with vendors, carriers, and internal peers

Created and executed SQL queries and statements for financial reporting and analysis.

Communicated and negotiated with vendors to consistently provide a high level of service and products to customers

Key Accomplishments:

Developed yearly savings tracker to monitor key metrics for management

Met and exceeded saving goal by 10%

Created dashboards in Tableau - highlighting rate of return, cost of goods sold and top returned SKUs (In support of the reverse logistic project)

LOCKHEED MARTIN AERONAUTICS, Atlanta, GA April 2010 - April 2015

Logistics Data Analyst

Provided data analysis for rate, budget and variance analysis

Created complex data analysis reports using advanced Excel skills (formulas, charts, pivot tables)

Trained End Users on the functionality of SAP and Oracle applications

Provided warehouse support and direction to the traffic team on brokerage/routing of daily outbound, inbound and international shipments

Engaged with internal and external business teams and stakeholders to identify opportunities to improve performance and service

Key Accomplishments:

Implemented SAP system and Oracle Transportation Management System

Recognized by management for developing complex data analysis and reporting solutions that were used to conduct research on transportation methods, rates and routes

Education & Training

Master of Business Administration in Operations Management

AMERICAN INTERCONTINENTAL UNIVERSITY Dunwoody, GA

Bachelors of Business Administration in Logistics and Intermodal Transportation

GEORGIA SOUTHERN UNIVERSITY Statesboro, GA

Contact this candidate