Data Analyst at Ivey Business School, Western University (2022-03 – Present)
- Managed, extracted, transformed, analysed, visualised, and presented student and program data for Ivey Business School, responding to ad-hoc data inquiries.
- Liaised with diverse internal and external stakeholders, including program department heads, IT staff, and external publications like the Financial Times, to ascertain data requirements, investigate discrepancies across various sources (e.g., Salesforce, internal file management systems, databases, websites), and report findings that accurately addressed specific queries.
- Leveraged tools such as Salesforce and Power BI to summarise, model, and visualise data automatically tracked by internal systems, thereby identifying trends and potential insights.
Associate Consultant at Gallagher Benefits Services (2020-09 – 2021-12)
- Completed a leadership development program within Gallagher's Benefits and HR consulting division, undertaking rotations in compensation, retirement, and benefits consulting practices.
- Participated in and documented client calls with HR directors, CFOs, CHROs, and pension committees, recording key details to understand client needs and concerns, present strategic recommendations on company compensation structures, retirement plans, and investment menus, and deliver educational content on compensation and retirement topics.
- Spearheaded a Target-Date Fund manager research project during the retirement rotation, coordinating RFQs and research calls with asset-management representatives, and critically examining fund management philosophies and processes to analyse and compare all Canadian TDF products, culminating in client recommendations.
Data Analyst at International Institute for Business Analysis (2020-05 – 2020-08)
- Executed SQL queries to extract pertinent information from Salesforce reports, subsequently analysing the data in Excel and Microsoft BI to generate business intelligence and marketing insights.
- Collaborated with database engineers/administrators, the CFO, and the IT director to comprehend how business operations influenced database structure and design, offering recommendations for enhancements.
- Utilised historical sales data to delineate profiles of current and past customers, informing the organisation about identified attrition points within the sales pipeline and potential lost sales opportunities.
- Quantified the impact of COVID-19 on company revenue by comparing product sales from March 2020 to June 2020 against previous seasons' sales, accounting for projected sales growth.
Data & Business Analyst at Esiance Inc. (2019-05 – 2019-08)
- Developed a monthly report utilising Google Analytics data for gift card suppliers (e.g., Lowe's, The Bay), illustrating the impact of their merchant promotions on sales and customer reach.
- Formulated a new Google Ads strategy for a novel product offering by analysing consumer data, achieving a 30% reduction in promotional spending while enhancing effectiveness through more targeted promotions and gamification.
- Engineered a new user interface and implemented automated rules and messages for Esiance's fraud processing system, improving operational efficiency by decreasing the employee time required for transaction screening.
