Andrew Muschamp McKay

123 Some Street
Calgary, Postal Code, Canada
Phone: 403-###-####


Analytical and technologically savvy international MBA graduate with coding experience in: C, C++, Objective-C, ColdFusion, Java, JavaScript, PHP, Python, T-SQL, and VBA. Professional Scrum Master™ and project manager capable of analyzing data, developing financial projections, building consensus, and executing business plans.

Information Technology

  • Oracle
  • FrontBase
  • MySQL
  • FileMaker Pro
  • SQL Server
Data Analysis:
  • Python
  • NumPy
  • pandas
  • matplotlib
  • SciPy
  • seaborn
  • Tableau
  • Power BI
Microsoft Excel:
  • Pivot Tables
  • Forecasting
  • Regression Analysis
  • VBA
  • Goal Seek
  • Solver
  • XML
  • SOAP
  • UML
  • ODBC
  • TCP/IP
  • CMS
  • CRM
  • SAAS
  • RESTful
  • JSON
  • regex
  • Blogging
  • WordPress
  • e-Commerce
  • e-Learning
  • Google Analytics
  • SEO
  • CSS
  • UIKit
  • Core Graphics
  • Core Animation
  • AV Foundation
  • Cocos2D
  • Box2D


CFA® Charterholder

CFA Institute, Charlottesville, Virgina

Master of Business Administration, Entrepreneurship

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

Bachelor of Computer Science (Co-op)

University of Victoria, Victoria, BC

Work Experience

Senior Business Intelligence Analyst

Mawer Investment Management Ltd., Calgary, Alberta
2021 -

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.

  • Product Owner during a 6-month period in which online sales increased 171%.

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.

  • Helped plan and launch the following social enterprises: W2 Café, SOLE food Urban Farm, and coworking@BOB. Duties included writing business plans and grant applications, pro forma accounting, sales projections, and market & industry research.

Investment & Communications Officer

Commercial Section of the Korean Consulate, Vancouver, BC

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

Reporting to the VP of Sales and Marketing, conducted market research into and analysis of the following industries: Forestry, Construction, and Mobile Computing.

  • Developed marketing plan, product positioning and branding strategy for a mobile app.

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.

  • Integrated into an internationally dispersed development team that worked onsite both in Canada and in Germany while developing a custom CMS for an e-commerce portal.