Francis Ballester

Francis Ballester

Office Assistant

Followers of Francis Ballester502 followers
location of Francis BallesterHamburg, Hamburg, Germany

Connect with Francis Ballester to Send Message

Connect

Connect with Francis Ballester to Send Message

Connect
  • Timeline

  • About me

    Materials Planner @ Starkey Hearing Technologies | Data Analyst | Chief Excel Officer by popular vote

  • Education

    • Ohio State University-Newark Campus

      2016 - 2016
      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 of exporting/importing. Selected students participate in a class at the OSU campus over the spring semester, and are then paired with an Ohio small-to-medium sized company over the summer, to assist them with their international trade operations.

    • Freie Universität Berlin

      2016 - 2016
      Study Abroad Cultural Electives, German Language

      Semester abroad at Freie Universität Berlin, in Berlin, Germany. Courses taken were European Economics, International Business Cultures, and Intensive German Language. Non-language courses were taught in English. Completed participation in a week-long excursion to Hamburg and Copenhagen, as well as field trips to various sites in Berlin, such as the Reichstag government building and the German Institute for International and Security Affairs.

    • Wright State University

      2014 - 2018
      International Business International Business

      Activities and Societies: University Chorus, Men's Chorale, Student Honors Association, Dean's Student Advisory Board, Beta Gama Sigma, Ohio State University Export Internship Program

    • Kuehne Logistics University

      2019 - 2021
      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 and sponsored by German logistician Klaus-Michael Kühne, KLU is a young university that specializes in providing an academic and applied logistics and supply chain education to students from around the world. While courses are taught in English, KLU makes intercultural education a standard of their programs.

  • Experience

    • Dean's Office for the College of Education and Human Services

      Dec 2014 - Apr 2016
      Office Assistant
    • Wright State University Tutoring Services

      Jan 2015 - Apr 2016
      Student Tutor
    • Ali Industries, Inc.

      May 2015 - Aug 2015
      Packaging Operator
    • Kent Displays

      May 2016 - Feb 2017
      Marketing and eCommerce Intern

      • 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

    • Wright State Research Institute

      Oct 2017 - Aug 2019

      • 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 • 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

      • Business Analyst

        May 2018 - Aug 2019
      • Administrative Intern

        Oct 2017 - May 2018
    • Kairos Research LLC

      Feb 2019 - Aug 2019
      Business Consultant

      • 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 Show less

    • Beiersdorf

      Aug 2020 - Aug 2021
      Working Student Global Procurement Marketing

      • 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

    • Starkey Hearing

      Jan 2022 - now
      Materials Planner and Data Analyst

      •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. Show less

  • Licenses & Certifications

    • Bloomberg Market Concepts Certificate

      Bloomberg Institute
      Apr 2017
  • Honors & Awards

    • Awarded to Francis Ballester
      Established Student Leader Award Wright State University Mar 2016 "This award will be given to students who have shown exemplary leadership qualities over the last academic year through student organizations, service, scholarship or commitment to the advancement of the mission and goals of Wright State University." - wright.edu