Eric Franks

Grand Rapids, MI *****

616-***-****; ad1ja6@r.postjobfree.com

Summary

Supply Chain Professional with over a decade of experience across multiple industries. Process driven, analytical with an inclination toward efficiency and continuous improvement. Experienced with data analytics on multiple platforms for results-based optimization.

Skills

• Data Visualization - Power BI, Qlik Sense • Multi-Mode Management

• International Logistics • Invoice Management

• Excel - Advanced Formulas, Power Query • Project Management

• KPI Reporting • Carrier / Shipper EDI

• Power Automate • Six Sigma

BI Dashboards Portfolio: https://www.novypro.com/profile_projects/eric

Licenses & certifications

Programming for Everybody (Getting Started with Python)

Foundations: Data, Data, Everywhere

Education

Bachelor of Science in Business Administration

Logistics Management & Marketing

December 2008, Central Michigan University

Experience

2020 Sept – Current Logistics Analyst, e2open – Holland, MI

• Onboarded new clients & carriers to the e2open system and network

• Trained and developed the knowledge and skills of e2open employees

• Reviewed rate proposals from carriers and worked with clients to recommend solutions

• Responsible for generating & distributing operational and financial reports

• Tested and assisted in the implementation of new functionality in the BluJay / e2open TMS with Jira

• Utilized Business Intelligence software e.g Power BI, WebFocus, Tableau & Qlik Sense to analyze network data

2019 March – 2020 September Logistics Analyst II, Meijer – Grand Rapids, MI

• Developed and maintained multiple logistics-related spreadsheets, reports and dashboards through Excel, Power BI and various internal platforms

• Tracked and was responsible for long-term company goals including, reducing spot market utilization & order tracking throughout the entire supply chain

• Developed KPI metrics related to carrier scorecards

• Worked directly with freight forwarders and consolidators to facilitate international freight

2016 October – 2019 March Logistics Coordinator, BluJay Solutions – Holland, MI

•Responsible for coordinating the supply chain for a national food brand and tier one automotive supplier •Analyzed & presented transportation-related data for inbound and outbound freight

•Tracked and presented data related to KPIs, overspend and cost avoidance directly to client

•Restructured routes to maximize cost savings

•Developed Excel VBA Macros to automat varies tasks including track & trace efforts, spreadsheet development and email notifications

2013 January – 2016 October Logistics Manager, Grupo Logico – Lexington, KY

•On-site at Client Logistics Manager responsible for coordinating the supply chain for a tier-one automotive supplier

•Provided cost studies for new locations / suppliers, managed route optimization, recorded periodic freight expenditures, financial reporting for customer

•Responsible for waste mitigation through continuous improvement initiatives

•Directly managed implementation of project moving a significant portion of our supply base from Europe to China to facilitate a new programs

Activities / Other

•SCMA, Supply Chain Management Association, Central Michigan University

•Volunteer at the HQ Center of Grand Rapids for disadvantaged youth

•Volunteer at Grand Rapids Bethany Christian academy teaching both children and adult’s English skills related to job placement, Tutored ESL students

•Excellent listening and problem-solving skills, conscientious and multitask oriented

Contact this candidate