Francis Ballester Email & Phone Number

Hamburg, Hh, De

Hamburg, Germany

•Created template and process for reviewing weekly MRP order lists, ensuring accurate inventory orders and exposing errors in MRP item settings and forecasts. Reduced company backlog average age from months to just 2-3 days.•Created data model of company’s supply and demand data to automate reporting. Used Power Query to automatically format and import data exports from ERP, MRP, and other sources. Modelled data relationships and developed measures and KPIs using Power Pivot.•Conduct monthly forecast reviews by calculating MAPE, summarizing forecast statistics and reviewing with sales and operations leadership.•Automated Goods Receipt process using custom Excel template and barcode scanner. Allows multi-user scanning of thousands of items and compares expected quantities to actual quantities. Reduced inaccuracies and errors by 95%.•Monitor daily stock levels and availability of thousands of active SKUs to proactively recognize and prevent stock-outs.•Track supplier order status and communicate persistently with suppliers in USA and Europe regarding order delays, order escalation, and supply issues.•Assist with material management activities such as product launches, item creation and management in ERP/MRP systems, booking of material transactions, and Goods Receipt.

Hamburg, Germany

• Created monthly KPI reports using Power BI and procurement spend data• Enhanced team digitalization through Sharepoint sites design, administration, and training• Performed ad-hoc analysis of category metrics such as supplier payment terms• Upheld compliance by diligently following supplier contract retention policies

Fairborn, Ohio, Usa

• Setup and managed company’s Quickbooks Online accounting system and processes; maintained all company vendor/customer account data and expense and journal entries• Developed Excel report to automate company labor data analysis and reporting• Designed custom Excel templates to standardized key company procedures, such as travel expense reporting and consultant invoicing• Assisted the COO in developing organizational spending and rate budgets• Prepared pricing proposals and proofread technical proposals for company research bids

Dayton, Ohio Area

• Designed and maintained Excel templates to streamline multi-million-dollar budgeting and pricing activities. Trained coworkers on template usage• Assisted with bid and proposal activities, contributing to pricing analysis and development• Supported CFO in preparation of budgets and overhead expense rate calculations• Other administrative tasks: maintenance of company fixed asset records; monthly close; supervised the movement and installation of new furniture

Dayton, Ohio Area

• Tagged, tracked, and recorded over 1400 company furniture assets• Trained and supervised two interns in asset tagging and other administrative functions• Documented company processes and created process charts using Microsoft Visio• Proficient use of Office software to manage data and create documents and charts

Kent, Ohio

• Managed company’s Amazon pages for American and Europe• Maintained inventory levels by processing shipments from company warehouses to Amazon fulfillment centers• Created new company products on Amazon sites to support product launches• Provided same- and next-day customer service for Amazon sites

Fairborn, Ohio

Fairborn, Ohio

Fairborn, Ohio

Master'S Degree, Global Logistics & Supply Chain Management

Kühne Logistics University is a dedicated logistics university located in the active German port city of Hamburg. Established in 2010.

International Business, International Business

Activities and Societies: University Chorus, Men's Chorale, Student Honors Association, Dean's Student Advisory Board, Beta Gama Sigma.

Study Abroad, Cultural Electives, German Language

Semester abroad at Freie Universität Berlin, in Berlin, Germany. Courses taken were European Economics, International Business Cultures.

Export Internship Program, International Trade

Program sponsored by the OSU Fisher College of Business and the Ohio Development Services Agency to train college students in the process.