![beBee background](https://contents.bebee.com/public/img/bg-user-ex-5.jpg)
![Alex MacKenzie](https://contents.bebee.com/users/id/3jLil665fcc07aaff2/_avatar-hZGUK-400.png)
About Alex MacKenzie:
Hi, I'm Alex 👋 I'm a data analyst at heart who loves to ask questions and understand outcomes, outputs, & processes at a deeper level.Â
Leveraging my statistical background, I've become adept at utilizing industry-leading reporting and visualization tools like Python, R, Power BI, and Tableau. I have analytics experience interning at RBC and also had the opportunity to conduct quantitative research during my time in university. I'm currently working as a financial data analyst at ZEISS Vision Care, implementing technical solutions to derive actionable insights which fuel business growth.
I'm always looking to grow both professionally and as an individual and would love to connect with you!
Experience
FINANCIAL DATA ANALYST – ZEISS Vision Care – North York, ON                 November 2022 - Current
- Developed an interactive sales map across Canada using Python GeoPandas & Folium libraries highlighting over- & underperforming area codes to direct monthly managerial reviews with sales reps resulting in 15% higher gross sales
- Created an automated Power BI dashboard of customer orders using modelling & DAX calculations to track both recent & 13-week unit growth showing key brand & customer trends, prompting a 20% volume surge through strategy alignment
- Produced Excel reports using Pivot & Power Query to improve customer service & support promotional campaigns
- Managed 5K customer accounts and led software migration through data-mapping in ERPs to maintain business function
Â
QUANTITATIVE GENETICS RESEARCHER – University of Toronto – Sztepanacz Lab        September 2021 – June 2022
- Used RStudio & Bash to create pedigrees & model genetic variation in simulated animal populations allowing the comparison of observed trait values with genetic underpinnings using multivariate matrix comparison
- Found similarity of phenotypic & genetic variation using PCA & subspace testing and plotted results with R ggplot2 package
- Designed an award-winning poster and presented novel findings at the OE3C 2022 conference at Queen’s University
Â
BUSINESS SYSTEMS ANALYST INTERN – Royal Bank of Canada – Toronto, ON              May 2020 –August 2020
- Integrated Excel & ServiceNow to present software application health metrics to upper management allowing retrieval of key fiscal diagnostic trends among different business lines & operational areas, facilitating the presentation of Q4 data
- Developed teamwide business analytics dashboard in ServiceNow resulting in a total support case time reduction of 4%
- Ran SQL queries to assess data needs and streamlined data pipelines between wealth management apps using Excel & JIRA
Â
FOURTH DEGREE MASTER INSTRUCTOR – Kickstart Taekwondo – Etobicoke, ON         October 2016 – March 2020
- Led classes with >20 students of all ages instilling discipline & confidence and promoting teamwork
- Directed martial arts training with pattern recognition & tailored strategies to master mobility & techniques
Education
HONOURS BACHELOR OF SCIENCE – University of Toronto                        September 2018 – April 2022
Statistics Major, Mathematics & Biology Double Minor
Relevant Coursework: Probability & Statistics II, Experimental Design, Applied Statistics, Data Analysis II
CFA Level 1 Candidate, CFA Institute
Professionals in the same Technology / Internet sector as Alex MacKenzie
Other users who are called Alex
Jobs near Toronto, Ontario
-
Maintenance Associate
1 week ago
The Boulevard Club Toronto, ON, CanadaDo you love hospitality? Love to meet and interact with fun and diverse people? Love to work in a friendly environment? If so, come be a part of our Boulevard Club family. · The Boulevard Club was announced as the Great Place To Work in Hospitality and Retail Industry in Cana ...
-
Tail End Operator/lead Hand
1 week ago
Direct apply
Fermar Paving Limited Toronto, CanadaWe are now hiring and are looking to expand our team with experienced and hard-working individuals. We currently have an opening for a Tail End Operator/Lead Hand for the 2023 season. Start date is dependant on contract, weather and regional requirements. · About Us: · We have be ...
-
Summer Camp Leader/Counsellor
6 days ago
Code Ninjas East Gwillimbury, Canada Part timeWho are we? Code Ninjas is the nation's fastest-growing kids coding franchise. In our center, kids ages 7-14 learn to code in a fun, non-intimidating way – by playing and building video games they love. Kids have a blast and can't wait to come back. Parents are thrilled as their ...