Throughout my career at Temple University, I have been fortunate enough to work at a large auto manufacturing company and a start-up consumer goods firm. The companies I have interned and worked for include Subaru Motors of America and GoPuff Inc. While working these jobs, I have gained an exponential amount of experience establishing clear cut communication skills, adept time management from balancing several projects at a time, and lastly enhancing my technical skills at Subaru Motors of America. I have developed extensive Microsoft Excel skills due to working with the software every day at work, including the use of index(match)) formulas, nested if statements for error trapping, and utilizing basic macros. I would monitor vehicle sales for Subaru of America, and create daily reports that were distributed to the executives.

The executives would utilize the data I have compiled and presented to them to make business decisions with our “mother” company, Fuji Heavy Industries. My communication skills have also improved while in the workplace. I am constantly engaged with the Vice President of Sales, along with my reporting manager. Professionalism is a must while speaking with my reporting managers and the clear cut information is dire to the success of Subaru. No day is the same, and there are always projects to be completed and data to be interpreted for the Executives of the company. The company relies on the data I retrieve to make vital business decisions. Prioritizing work and managing my time have become my strongest skill through my work experience at Subaru. I have to balance several projects per week while carrying out my daily tasks. I have a passion for the automotive industry and would love to continue my career path in this specific industry whether it be data analysis, sales, or in management.

Some of the reports that I was responsible for include the District Sales Manager Bonus Program, Retailer Rewards 2.0 and Retailer Rewards 3.0, and creating numerous pivot table reports that summarize large amounts of data. The District Sales Manager Bonus Program summarizes careline sales data, mechanical penetration, STARLINK upgrade data, and Owner Loyalty Program scores for the respective DSM. It also covers the Zone Directors respective and similar information. The Retailer Rewards 2.0 and Retailer Rewards 3.0 covers chargeback amounts for 631 retailers in the nation based on committed penetration versus actual penetration. This is all based on mechanical contracts sold, vehicles sold, and the “penetration” rate which is Contracts/Vehicles sold. This tool was made for Keith Cook and is heavily used and distributed to the Field. It is used to leverage retailer contracts being sold and how the DSM (District Sales Manager) can manipulate their respective AOR retailers to prevent a chargeback from happening. This is also used to track “bonus” chargebacks as well. When a retailer is above the committed penetration, they are eligible to receive a positive chargeback for doing well based on mechanical penetration. The multiple amounts of pivot tables created leverage real-time sales data in order to track sales by the retailer. They also cover historical sales in order to complete trending analysis and future vehicle drafting.