FerrierConsulting

Problem Solved.

Resume: Malcolm Ferrier

Profile
Project Manager
Business Analyst
Internet/Database Developer
Instructor/Speaker

Areas of Specialization:
Industries
Information Technology, Health Care, Internet, Media, Entertainment, Banking/Insurance, Retail, Non-Profit

Technologies
Information Technology Management, Internet Database Development, eCommerce, Document Management, Web-Based Digital Media Delivery

Development Tools
Microsoft Access/SQL Server, ASP.Net, Microsoft Visual Studio, HTML, Visual Basic/VBA, C#, Python, JavaScript, MS Office Suite, Visio, MS Project, Linux/Open source

Skills and Experience:
Project Management
As principal consultant for Ferrier Consulting, project managed, designed, developed, and implemented web/database applications for numerous Lower Mainland public and private organizations.

Project Advisor for multiple BCIT Directed Studies industry projects.

Successfully managed an online nursing guidelines web site development project for a hospital group. Project was completed ahead of schedule and below budget and fully met all functional requirements.  Later expanded this system into a document management system for the entire hospital group.

Coordinated and managed two senior and five junior database analysts for year 2000 remediation of applications for a group of hospitals. Project successfully concluded on time and below budget.

Business Analysis
Identified the business requirements for a new web site for a not-for-profit medical-research institute. Designed a site map, conducted user workshops, and developed an Internet strategy document.

Designed a series of information technology documents for a regional health board responsible for administering health services to a client population of over two million:
•Conducted a preliminary Web site costing investigation
•Developed Web site and electronic information security standards documents

Systems Development and Implementation
Created a centralized strategic data reporting application for the logistics department of a regional health board:
•Developed functions to import data files from three different hospitals’ databases into a common data model and created custom managerial reports using Access 97 and VBA

Developed a recruitment-request application for the HR department of a major metropolitan hospital, to replace a time-intensive paper-based process:
•Created a network-accessible user front-end using Access 97 and Visual Basic for applications

Designed and updated applications for the corporate headquarters of a major Canadian retail drugstore chain:
•Updated a component of the human resources bonus-reporting application using Microsoft Access reporting tools and Visual Basic 6.0
•Developed a server maintenance application using Visual Basic 6.0

Developed an automated interface for a hospital group’s ID card database system using Visual Basic 6.0.

Provided technical analysis for the deployment of compliant software for the workstation rollout for a hospital group’s office systems 2000 project. This phase of the project successfully focused on ensuring year 2000 compliance of the hospital’s software.

Web Development
Created a Web site application to administer and display guidelines for the nursing staff of a hospital group, using Active Server Pages 3.0 and SQL Server 7.0.

Developed a database-driven navigation system for the public Web site of a credit union, using Active Server Pages 3.0 and SQL Server 7.0.

Created an online email response application for a charitable medical-research institute, using Active Server Pages 3.0 and Internet Information Server (IIS) 5.0.

Served as a technical advisor for the development of a preliminary Web site for a regional health board.

Created an internal online meeting and agenda planning application using Access 2000 and Active Server Pages 3.0 for an information technology consulting firm. Developed an email-delivered client survey form using Active Server Pages 3.0 for the same firm.

Developed a component-based eCommerce toolkit using SQL Server and Active Server Pages.

Developed a virtual online record label and management company into a viable eCommerce business:
•Created a comprehensive business proposal outlining a strategic plan for the first three years of operation; conducted extensive market research to determine the demand for online digital music formats, such as MP3
•Designed, developed and maintained a fully functional eCommerce Web site with the capacity for digital music delivery

Business Planning
Member of the development team for an eCommerce information systems plan for a private western Canadian property and casualty insurer:
•Developed a high-level systems strategy and implementation plan for eCommerce and back-end initiatives
•Conducted preliminary policy administration and management application package evaluations

Developed a detailed "virtual office" systems plan for a not-for-profit youth empowerment organization.

Training/Speaking
Currently program head for the Business Information Technology Management (BITMAN) program at BCIT. Teaching Data Modeling/Database Management Systems, Management of Information Systems, Project Management, Business Systems Programming, and Web Application Development.

Provided "Building a Successful e-business" workshop for a Lower Mainland Chamber of Commerce.

Education:
Project Management Professional (PMP), Project Management Institute, 2011.
Master of Business Administration in science and technology, Queen’s University, 1999.
Bachelor of Science in physics, University of Alberta, 1996.

Employment:
Founder and Principal
Ferrier Consulting
Vancouver, BC
March 2002-Present

Program Head/Instructor
British Columbia Institute of Technology (BCIT)
Burnaby, BC
September 2002-Present

Consultant
Sierra Systems
Vancouver, BC
July 1999-February 2002

Accomplishments:
Wrote, directed, and produced the independent sci-fi action movie "STOP"
Wrote a Canadian spy thriller novella ("Troubleshooter")
Dean's List, Queen's University MBA 1999
Scored in the 98th percentile (710) in the GMAT
Recipient of the AHFMR Media Fellowship
Formed and managed a successful professional touring musical group

Contact Ferrier Consulting