Andrew Muschamp McKay

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

Profile

Experienced international MBA graduate and CFA® Candidate with coding experience in: C, C++, Objective-C, ColdFusion, Java, JavaScript, PHP, Python, and VBA. Professional Scrum Master™ and project manager capable of analyzing data, developing financial projections, building consensus, and executing business plans. Objective: an opportunity to leverage my IT background and complete the CFA charter, having successfully passed the CFA Level III exam.

Information Technology

Databases:
  • Oracle
  • FrontBase
  • MySQL
  • FileMaker Pro
  • SQL Server
Data Analysis:
  • Python
  • NumPy
  • pandas
  • matplotlib
  • statsmodels
  • SciPy
  • seaborn
  • Tableau
Microsoft Excel:
  • Pivot Tables
  • Forecasting
  • Regression Analysis
  • VBA
  • Goal Seek
  • Solver
Acronyms:
  • XML
  • SOAP
  • UML
  • ODBC
  • TCP/IP
  • CMS
  • CRM
  • SAAS
  • RESTful
  • JSON
  • regex
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
  • PSM I
  • Waterfall
  • Critical Path Optimization
  • FranklinCovey
WWW:
  • Blogging
  • WordPress
  • e-Commerce
  • e-Learning
  • SEO
  • CSS
  • HTML
iOS:
  • UIKit
  • Core Graphics
  • Core Animation
  • AV Foundation
  • Cocos2D
  • Box2D
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

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.
  • Created custom PowerPoint training decks and served on the Content Taskforce.
  • Organized events and served on the Teacher Recruitment & Training committee.
  • 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.

  • Product Owner 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é, SOLE food 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 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.