Andrew Muschamp McKay

123 Some Street
Calgary, Postal Code, Canada
Phone: 403-###-####
Email:
Web: http://www.muschamp.ca
 

Profile

Analytical and technologically savvy international MBA graduate, CFA® Charterholder and Professional Scrum Master™. Proficiency in analyzing data, developing financial projections, building consensus, and executing business plans. Started as a full stack developer in the previous millennium, currently focused on attribution and portfolio performance calculations.

Information Technology

Languages:
  • C
  • C++
  • Objective-C
  • ColdFusion
  • Java
  • JavaScript
  • KQL
  • PHP
  • T-SQL
  • VBA
Databases:
  • Oracle
  • FrontBase
  • MySQL
  • FileMaker Pro
  • SQL Server
  • Azure Data Explorer
Data Analysis:
  • Python
  • NumPy
  • pandas
  • matplotlib
  • SciPy
  • seaborn
  • Tableau
  • Power BI
Acronyms:
  • XML
  • SOAP
  • UML
  • ODBC
  • TCP/IP
  • CMS
  • CRM
  • SAAS
  • RESTful
  • JSON
  • regex
WWW:
  • Blogging
  • WordPress
  • e-Commerce
  • e-Learning
  • SEO
  • CSS

Education

CFA® Charterholder

CFA Institute, Charlottesville, Virgina
2022
 

Master of Business Administration, Entrepreneurship

Sauder School of Business, University of British Columbia, Vancouver, BC
2006
 

Bachelor of Computer Science (Co-op)

University of Victoria, Victoria, BC
2000
 

Work Experience

Performance Analyst

Mawer Investment Management Ltd., Calgary, Alberta
2023 -
 

Reporting to the Manager of Investment Applications, as part of a distributed team was responsible for ensuring the accuracy and timeliness of fund performance, client portfolio performance and associated attribution and risk metrics.

  • Calculations done in SimCorp Dimensions, SQL Server, Excel and Power BI.

Senior Business Intelligence Analyst

Mawer Investment Management Ltd., Calgary, Alberta
2021 - 2023
 

Reporting to the Manager of Enterprise Reporting and Data Analytics, as a Scrum team member used: SQL Server, Oracle, Excel, Power BI, DAX, and Python to create models and reports which calculated portfolio performance, portfolio holding characteristics, AUM, attribution, and portfolio performance contribution for clients, staff and external consultants.

  • Wrote code, specifications, documentation and UAT test sets for SimCorp Dimensions (SCD) multi-asset, front-to-back investment management platform implementation.

Reporting Analyst

Mawer Investment Management Ltd., Calgary, Alberta
2019 - 2021
 

Reporting to the Manager of Enterprise Reporting and Data Analytics, analyzed existing business processes, data sources, and coordinated report automation initiative. The project integrated data from Advent Portfolio Exchange, FactSet, Charles River IMS, and other sources into self serve Power BI dashboards and reports generated using SSRS.

  • Inventoried and analyzed over 400 reports issued to internal and external clients.
  • Wrote technical requirements documentation and user acceptance criteria.

Online English Trainer

EF English First Language Training (EF), Shanghai, China
2015 - 2019
 

Reporting to a Team Leader, taught private and online group lessons using Adobe Connect and EF's custom web based teaching platform.

  • Beta tested, trained staff and provided end-user support on the teaching platform.

Senior Technical Analyst

Carlson Wagonlit Travel (CWT), Vancouver, BC
2013 - 2014
 

Reporting to the Manager of Leisure Technology, responsible for upgrading and improving existing systems and researching the migration path for custom ColdFusion based extranet. Managed updates, bug reports and change requests for e-commerce websites using Agile/Scrum methodologies. Coding and mentoring provided in ColdFusion, JavaScript, HTML, CSS, and SQL.

Industry Initiatives Coordinator

Building Opportunities with Business (BOB), Vancouver, BC
2008 - 2010
 

Reporting to the CEO, responsible for management and strategic planning of industry cluster programs and projects at BOB. Provided business development services to inner-city connected businesses and entrepreneurs.

Investment & Communications Officer

Commercial Section of the Korean Consulate, Vancouver, BC
2007
 

Reporting to the Director General and Chief Trade Commissioner of KOTRA Vancouver, researched companies, potential partners, legal requirements, industries, and markets in Korea and Canada. In order to increase foreign direct investment and trade I organized: promotional events, seminars, trade show pavilions, and business matchmaking opportunities.

Business Analyst (MBA Intern)

Noratek Solutions, Prince George, BC
2005
 

Reporting to the VP of Sales and Marketing, conducted market research into and analysis of the following industries: forestry, construction, and mobile computing.

Foreign Teaching Staff

AEON English School, Toyohashi, Japan
2003 - 2004
 

Reporting to the Head Teacher and Branch Manager, taught English as a second language to students ranging in age from high school student to retiree.

Software Developer

Global Village Consulting, Vancouver, BC
2000 - 2003
 

Reporting to a Senior Developer, developed a variety of internet and intranet applications using Apple's WebObjects. Participated in all phases of the software development lifecycle. Programming was done in both Java and Objective-C using Apple's Foundation Framework.