Shane McCormick

Senior Analyst Financial Planning & Analytics at Alberta Teachers' Retirement Fund
  • Claim this Profile
Contact Information
Location
Edmonton, Alberta, Canada, CA
Languages
  • English Native or bilingual proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • CBDA (Certified Business Data Analyst
    IIBA
  • CCBA (Certification of Capability in Business Analysis)
    IIBA
  • FMVA (Financial Modelling and Valuation Analyst)
    Corporate Finance Institute® (CFI)

Experience

    • Canada
    • Financial Services
    • 1 - 100 Employee
    • Senior Analyst Financial Planning & Analytics
      • Mar 2022 - Present

    • Financial Analyst, Planning and Reporting
      • Sep 2020 - Mar 2022

      Corporate strategy, planning, finance, and reporting experience with a wide-range of responsibilities including:- Finance: corporate budgeting and reporting, budget forecasting and financial planning, ad-hoc financial analysis for corporate and project planning, regulatory filings, annual report and financial statement development support, and other general corporate accounting support. - Data analysis: Corporate Scorecard development and administration including identification of performance metrics, and performance monitoring and reporting; and compilation of operational and investment performance data for participation in industry benchmarking services and analysis of benchmarking results.- Corporate planning and strategy: business plan development and corporate performance management, financial modelling, and market research and analysis.

    • Real Estate
    • 1 - 100 Employee
    • Founder, Cambire Capital
      • Nov 2019 - Aug 2020

      - Developed a fully automated public equity valuation algorithm that leverages fundamental and technical stock data to calculate the intrinsic value of equities in collaboration with a partner. The output include investment summary reports and equity valuations and ratings (buy, sell, hold). - The intent was to use the algorithm to build an investment fund; however, after numerous iterations (back tested to the early 2000’s), the conclusion was that scalability issues made it more suitable as a personal investment strategy. - Note: Continue to actively invest personal assets in individual equities and index funds using Cambire-developed tools plus additional proprietary tools and methods created subsequent to putting Cambire into indefinite suspension. Activities include investment research, market and finance research, development of analytics hypothesis, and the application of statistical modelling techniques.

    • Data Analytics Consultant
      • Jan 2019 - Aug 2020

      - Engaged by MNP, Edmonton Economic Development Corp. (EEDC), and Treelink (local arboriculture company) to support business analysis, database development, data analytics and data validation projects. - MNP engagement: completed an analytical review of Alberta’s 2011-2019 wildfire seasons to support a more wholesome review of Alberta’s wildfire management practices and performance, including cost analysis, KPI review, wildfire season intensity, behaviour and trends. - EEDC engagement: completed an analysis of qualitative survey data from Edmonton’s summer 2018 events and developed surveys report for key stakeholders to support future planning of Edmonton’s summer festivals. - Treelink engagement: developed a process for collecting (database development, data collection) and reviewing (data analytics) project operations data to support a review of project quoting accuracy and to guide future project quoting decisions.

    • Human Resources Services
    • Analyst, Consulting Services
      • Apr 2019 - Mar 2020

      - Management consulting services support and execution, including client engagement, data analysis, research, business planning, feasibility assessments, business process mapping, business analysis, presentations development and client delivery. - Quickly became a go-to person for analytics projects on the consulting team, including hosting an internal knowledge transfer session of different capabilities for financial modelling in excel.- Ceased full time work with MNP to pursue starting Cambire Capital (see ‘Professional Projects’ on the next page).

    • Canada
    • Civic and Social Organizations
    • 1 - 100 Employee
    • Research Associate Intern
      • May 2018 - Jan 2019

      - 8-month internship with Edmonton Economic Development Corporation’s (EEDC) research team.- Responsibilities included: international market research, business analysis, business process mapping, client meetings, report writing and data analysis. - Continued to be engaged by EEDC as a sub-contractor following departure. - 8-month internship with Edmonton Economic Development Corporation’s (EEDC) research team.- Responsibilities included: international market research, business analysis, business process mapping, client meetings, report writing and data analysis. - Continued to be engaged by EEDC as a sub-contractor following departure.

    • United Kingdom
    • Non-profit Organizations
    • 1 - 100 Employee
    • Policy Analyst Intern (Jodhpur, India)
      • Jan 2018 - Feb 2018

      - Moved to Jodhpur, India after graduation from B.COMM program to volunteer for 1-month with a social-initiatives focused law firm. - Supported legal research for two major initiatives, 1) the development of a federal bill that would lead to more persecutions of those participating in witch trials, and 2) support education of music intellectual property rights for under-privileged villages. - Travelled throughout India for two-months following the volunteer work. - Moved to Jodhpur, India after graduation from B.COMM program to volunteer for 1-month with a social-initiatives focused law firm. - Supported legal research for two major initiatives, 1) the development of a federal bill that would lead to more persecutions of those participating in witch trials, and 2) support education of music intellectual property rights for under-privileged villages. - Travelled throughout India for two-months following the volunteer work.

    • Canada
    • Banking
    • 700 & Above Employee
    • Corporate Settlements Intern
      • May 2017 - Sep 2017

      Responsible for supporting ATB’s forex trading desk, which included: journal entry development, currency trade confirmation with counterparties and ensuring timely transfer / receipt of funds. Responsible for supporting ATB’s forex trading desk, which included: journal entry development, currency trade confirmation with counterparties and ensuring timely transfer / receipt of funds.

Education

  • Sprott School of Business at Carleton University
    Master of Business Administration - MBA, Financial Management
    2022 - 2023
  • New York University
    Certificate, Advanced SQL Queries
    -
  • UC San Diego
    Certificate, Python for Data Science
    -
  • MacEwan University
    Bachelor of Commerce (BCom), International Business
    2013 - 2017
  • Hogeschool van Arnhem en Nijmegen
    Bachelor of Commerce (B.Com.), International Business
    2015 - 2015

Community

You need to have a working account to view this content. Click here to join now