Andrew Muschamp McKay

Room 0801 No. 78 Zhejiang South Road
Shanghai, 200021, China
Phone: 13127958663
Email:
Web: http://www.muschamp.ca
 

Profile

Experienced international MBA graduate and CFA® Candidate with professional coding experience in: C, C++, Objective-C, ColdFusion, Java, JavaScript, PHP, and VBA. Project manager capable of analyzing data, developing financial projections, building consensus, and executing business plans. Proficient communicator with a proven ability to deliver high-quality customer service across borders, departments, and teams. Objective: an opportunity to leverage my IT background and complete the CFA charter, having successfully passed the Level 1 and Level 2 CFA exams.

Information Technology

Databases:
  • Oracle
  • FrontBase
  • MySQL
  • FileMaker Pro
  • SQL Server
Microsoft Excel:
  • Pivot Tables
  • Forecasting
  • Regression Analysis
  • VBA
  • Goal Seek
  • Solver
Acronyms:
  • XML
  • SOAP
  • UML
  • ODBC
  • TCP/IP
  • CMS
  • CRM
  • SAAS
  • RESTful
  • JSON
APIs:
  • Amazon
  • Last.FM
  • Open Graph
  • Twitter
  • iTunes Store
  • Flickr
  • YouTube
  • MediaWiki
Design Methodologies:
  • eXtreme Programming
  • Refactoring
  • Design By Contract
  • MVC
  • Design Patterns
Project Management:
  • Agile
  • Scrum
  • Waterfall
  • Iterative
  • Critical Path Optimization
  • FranklinCovey
WWW:
  • Blogging
  • WordPress
  • e-Commerce
  • e-Learning
  • SEO
  • CSS
  • HTML
iOS:
  • UIKit
  • Core Graphics
  • Core Animation
  • AV Foundation
  • Cocos2D
  • Box2D
  • Kobold2D
Google Analytics:
  • Custom variables
  • events
  • segments
  • filters
  • profiles
  • reports
  • dashboards

Education

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

English Trainer

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

Reporting to a Team Leader, taught private and online group lessons using Adobe Connect.

  • Helped beta test the new online teaching platform.
  • Served on the Teacher Recruitment & Training committee and the Content Taskforce.
  • Created numerous custom lessons as well as in center training materials.
  • Student Evaluation Scores in both group and private lessons averaged over 4.9/5.0.

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.

  • Managed website updates during a 6 month period in which online sales increased 171%.
  • Recognized by coworkers for providing outstanding customer service.
  • Improved Google Analytics e-commerce sales funnel reporting and campaign tracking. Created custom scripts, events, segments, filters, reports and dashboards.
  • Analyzed online booking data with MS Excel segmented by region, vertical and website.
  • Increased social media integration using Facebook API, Pinterest, and jQuery.

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é, SOLEfood Urban Farm, and coworking@BOB. Duties included writing business plans and grant applications, pro forma accounting, sales projections, and market & industry research.
  • Increased cluster program participation by over 66%.
  • Project manager for redevelopment of BOB's website and the social purchasing portal. Responsible for budget, timeline, scope, vendor contracts, content, and re-launch.
  • Leveraged social media to achieve front page coverage of cluster projects in the Vancouver Sun and Metro as well as numerous other mentions in print, radio, and TV.
  • Contributed to event planning, organization, and promotion of: Sustainability 2.0 and the 2009 Gaining Ground Resilient Cities conferences.

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

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.