Aaron Johnson Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

• Facilitated communication and cooperation with 15 different lines of business to answer over 180 questions regarding TD and its subsidiaries ESG initiatives• Utilized MS Excel and VBA to create an automated and dynamic checklist of over 4 complex equations, increasing the efficiency of the task and diminishing human error

Toronto, Ontario, Canada

• Automated complex data in spreadsheets over 18 time periods and 25 line items using nested IF statements and matrix calculations, improving data management efficiency• Efficiently compiled the financial information of 45 private companies by meticulously analyzing over 2,000 pages in 100+ PDF documents which enabled easier tracking of investee performance• Designed an engaging and informative onboarding PowerPoint deck for new hires across TDS, clearly delineating roles and responsibilities for both the new hire and people manager

Toronto, Ontario, Canada

• Adapted quickly to fast-paced and dynamic game situations, providing reliable timekeeping support to contribute to the overall success of each match• Demonstrated attention to detail through accurately tracking in-game statistics and playing audio to enhance both player and spectator experience• Collaborated closely with referees and arena staff to ensure seamless coordination before, during, and after games

Toronto, Ontario, Canada

• Skillfully managed and projected expenses exceeding $10MM for over 8 LOBs, playing a vital role in shaping the upcoming fiscal year's budget allocation• Conducted comprehensive sensitivity analysis on 3 LOBs, meticulously identifying primary cost influencers and dissecting variance origins• Revamped operational efficiency by implementing intricate Excel automation across 8 tasks, harnessing the power of advanced functions like if(), sumifs(), and xlookup()• Directed and facilitated weekly executive gatherings, facilitating collaborative decision-making for expenses greenlighted up to $7.5MM

Toronto, Ontario, Canada

• Conducted rigorous statistical analysis on KPIs to identify the distinguishing traits of the top 5% sales advisors, facilitating data-driven insights for enhanced team performance• Streamlined a meticulous Excel task through the implementation of complex equations and macros, resulting in an impressive 93.8% reduction in task completion time• Devised a comprehensive technical interview tailored for a Senior Analyst role, effectively assessing Excel proficiency which helped determine the top 2 candidates from a pool of 6 applicants• Orchestrated and guided the Social and Connections committee to curate and execute events catering to a cohort of around 750 interns, fostering engagement and camaraderie within the intern community

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Prince Albert, Saskatchewan, Canada

Prince Albert, Saskatchewan, Canada

Prince Albert, Saskatchewan, Canada

Prince Albert, Saskatchewan, Canada

Bachelor Of Commerce - Bcom, Finance And Economics Specialist, Environmental Economics Minor

Activities and Societies: 1x represents one semester 2x Sigma Chi Fraternity - Recruitment Chair 6x Sigma Chi Fraternity - Executive.

Bachelor Of Commerce - Bcom, Finance And Economics

Activities and Societies: Exchange Program partnered with University of Toronto