• Created, managed, automated, and analyzed multiple Excel spreadsheets for leadership including revenue by customer, budget vs actual by department, board packages, end of month summaries, and more• Reimagined and implemented an improved process for reporting, utilizing a combination of complex SQL queries, Power Pivot & Dax, and advanced Excel formulas that reduced completion time from 1 week to 30 minutes, automating everything outside of manual adjustments made by the accounting… Show more • Created, managed, automated, and analyzed multiple Excel spreadsheets for leadership including revenue by customer, budget vs actual by department, board packages, end of month summaries, and more• Reimagined and implemented an improved process for reporting, utilizing a combination of complex SQL queries, Power Pivot & Dax, and advanced Excel formulas that reduced completion time from 1 week to 30 minutes, automating everything outside of manual adjustments made by the accounting team• Chosen by the CFO to train the accounting team in Excel including: advanced formulas, pivot tables, shortcuts, and dynamic reporting methods• Coordinated a change in financial statement reporting which eliminated extra steps and increased accuracy between reports• Worked closely with the IT department to clean data and ensure accuracy across finance, accounting, and operations reports Show less

• Utilized advanced skills within Excel and SQL on a daily basis to create dynamic financial models• Created, updated, and analyzed multiple reports for leadership such as: international franchise sales, pre v post performance of remodels and marketing tests, KPIs for each business segment, and more• Trusted with analyzing current company performance and creating high level summaries for the CEO to share with our Board members later that day• Performed same day ad-hoc… Show more • Utilized advanced skills within Excel and SQL on a daily basis to create dynamic financial models• Created, updated, and analyzed multiple reports for leadership such as: international franchise sales, pre v post performance of remodels and marketing tests, KPIs for each business segment, and more• Trusted with analyzing current company performance and creating high level summaries for the CEO to share with our Board members later that day• Performed same day ad-hoc analysis and presented findings to management in a concise manner• Worked closely with the Peter Piper finance team to understand their data, and individually wrote SQL queries that were then used to create a data cube for the company Show less

-Monitored financial statements and key performance indicators daily in order to identify strengths and weaknesses in pricing, promotions, and employee performance -Created and executed a promotion through delivery services by analyzing margins and breakeven points on popular items leading to an additional $2,000 in revenue per week during the time of promotion-Learned the day to day of successful business management and measuring performance through spreadsheet analysis

-Led the coordination of clients and business of walking dogs on a daily basis to ensure timely and positive experience which led to an overall 5-star rating across 12 clients-Promoted to new hire training after first 6 weeks as a result of client feedback and positive ratings-Responsibilities included: house sitting, dog walking, new hire training

-Given ability to assist customers in 1 on 1 interactions to match their needs with the right product-Assisted in designing new processes for inventory management which led to elimination of minor non-value-added steps in process-Responsibilities included: register management, inventory and new shipment management, cleaning of facilities

-Organized and managed inventory on a daily basis-Weekly meetings with owner strategizing methods of increasing traffic and customer satisfaction-Responsibilities included: inventory management, social media promotion, and marketing strategy