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 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

Databases:
  • 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
Acronyms:
  • XML
  • SOAP
  • UML
  • ODBC
  • TCP/IP
  • CMS
  • CRM
  • SAAS
  • RESTful
  • JSON
  • regex
WWW:
  • Blogging
  • WordPress
  • e-Commerce
  • e-Learning
  • Google Analytics
  • SEO
  • CSS
iOS:
  • UIKit
  • Core Graphics
  • Core Animation
  • AV Foundation
  • Cocos2D
  • Box2D

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

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
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.

  • 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.