Ben Bjorklund

Worked on the Supply Chain Business Intelligence Team. - Led automation of an 80-page monthly logistics binder into an interactive dashboard using IBM Cognos. - Enhanced decision making by increasing KPI visibility and reducing data lag by 30+ days. - Decreased manual effort and repeatable tasks reducing time spent by 10 hours per month. - Contributed to a data module by implementing complex queries and joins while ensuring validity. - Developed an early stage Python-based linear regression model predicting the delivery time of truck stops. - Created a SQL query to join and filter multiple tables extracting 60,000 relevant data points.

- Utilized Macros in Excel to normalize 10,000 rows of financial data resulting in increased functionality. - Created PivotTables for recurring data requests reducing lookup time by an estimated 30%. - Created 8 sustainable Excel spreadsheets involving advanced formulas and calculations replacing outdated logic and reducing manual efforts.

- Oversaw and led 15 Summer Staff interns through daily tasks and month long projects. - Assisted in extensive planning for a summer camp involving over 1500 children and 100 high school students. - Created a reusable budget in Excel using simple formulas and conditional formatting for camp expenses.

Worked as a teaching assistant for the Advanced Statistical Methods course taught by John Smith. - Facilitated problem-solving for 25 students, guiding them through statistical modeling problems (Monte Carlo, ANOVA, Regression, etc) in Excel and R increasing available lecture time by 20%. - Assisted in project creation and partook in conversations to improve the scope of class material.

Developed High School and College age workers in leadership, appropriate interactions with children, and conflict resolution. Participated in daily leadership meetings in an effort to improve day-to-day camp functions. Trusted with sensitive information and situations.

In progresss