John J Roelant

- Took time off to care for a sick family member.

- Accomplished freelance analytics work for a non-profit.

- Led the development and execution of a new allocation tool while working directly with the CCO, CTO, COO and cross functional teams.

- Actively managed the allocation process resulting in an average fill rate improvement of 48% for all SKUs on the tool (thee SKUs comprise >37% gross revenue)

- Mentored junior analysts, fostering professional development while enhancing overall team performance.

- Managed and improved the company's indirect volume allocation process which handles over 40% of the company's total revenue.

- Identified process improvements and implemented changes resulting in 25% fewer processing errors.

- Assisted in successful system integration of Nestle's $3.4B confections business and Kellogg's $1.3B cookie/fruit snack business.

- Designed and implemented a new forecasting tool utilizing SAP HANA, advanced Excel formulas and VBA which resulted in a 17% increase in demand planning forecast accuracy.

- Developed dashboard visualizations of KPIs in Tableau, allowing leadership to quickly identify business trends and issues.

- Developed a portfolio management program utilizing Excel VBA and RESTful API to automate asset allocation, limiting volatility risk.

- Programmed automatic transaction verification system resulting in reduced escrow times delivering >$15K Bitcoins to customers weekly.

- Designed a Python program and SQL database to optimize the acquisition and pricing of properties using historical Airbnb data, saving approx. 200 hour annually. Concurrently managed daily operations of 6 properties ensuring smooth turnovers; managed over 40 properties resulting in over $100K annual revenue.

- Designed an Excel VBA model which accurately forecasted re-sale ticket prices successfully achieving over a 35% return.