Celtic Logo




Bruce MacPherson

Software designer and developer with a demonstrated ability to understand business requirements and translate them into quality systems. Bruce is a team player, a problem solver, and a proven leader with outstanding communication and interpersonal skills. His primary strengths are in building client server applications using OpenText's TeamDeveloper (Centura/SQL Windows) as well as web based applications in ASP.NET

Bathust, New Brunswick, CANADA

macpherson@celtic.ca

1-613-720-0821

linkedin.com/in/macphersonbruce


Summary

Bruce has more than thirty-five years experience in software development. He has expertise as a business analyst, systems analyst, project manager, team leader and developer.

He has extensive experience building client-server applications and web-based N-tier architecture.

Bruce has strong leadership and mentoring skills acquired both through technology projects and volunteer work.

Bruce has a Secret (Level II) Security Clearance with the federal government of Canada.


Experience

Senior Software Designer/Developer - Celtic Information Consultants Limited (Owner)
1990 - Current

Bruce is an independent consultant who has been designing and building systems on a variety of platforms for many of Canada's federal government departments.

He has extensive experience with OpenText's TeamDeveloper (Centura/SQLWindows) client server development tools, connecting with Oracle, SQLServer and SQLBase backend databases. Using this technology he has designed and built large enterprise systems and small scale custom solutions for clients such as:

  • Innovation, Science and Economic Development Canada (2016-present)
  • Transport Canada (2006-2011)
  • Canadian Food Inspection Agency (1996-2005)
  • Fisheries and Oceans Canada (1992-1996)
  • Transportation Safety Board (1991-1992)

Bruce has also designed and developed web based applications in ASP.NET/JavaScript/VB Script/Crystal Reports for clients such as:

  • Library of Parliament (2004-2014)
  • Natural Sciences and Engineering Research Council of Canada (2013)
  • Aboriginal Affairs and Northern Development Canada (2011-2013)
  • Transport Canada (2005-2006)
  • Privy Council Office (2005)
  • The Senate of Canada (2001-2004)
  • Parks Canada Agency (2001-2002)


Skills and Experience

  • System Analysis and Design - working with clients, architects and analysts in documenting business and functional requirements, and prototyping solutions
  • Gap Analysis - identifying and documenting current state, desired future state and associated gaps and challenges
  • Significant experience with the infrastructure and applications used in creating client-server and N-teir applications on hardware ranging from mainframe computers to laptops and tablets
  • Extensive experience coding and managing applications built using TeamDeveloper (Centura/SQLWindows) client server tools
  • Strong skills in designing and maintaining database management systems using Oracle, SQL Server, SQLBase and others, including working with stored procedures, functions, triggers, and referential integrity
  • Analyzing existing software applications and tools to determine the current functionality, using a reverse engineering approach to document requirements for replacement systems


Board Member and Chair (volunteer) - Manotick Community Church
2015 - 2023

Founding member of the church and member of the board for eight years (seven as chair) until moving out of the province.

Demonstrated leadership ability through overseeing the hiring process for a new pastor, organizing and arranging volunteer and ministry teams, as well as managing events.






Education

Bachelor of Computer Science
1982 - 1986

Acadia LogoAcadia University - Wolfville, Nova Scotia


Technology

  • TeamDeveloper / Centura / SQL Windows
  • Oracle
  • SQL Server
  • SQLBase
  • ODBC
  • PL/SQL
  • T-SQL

  • TOAD
  • SQLPlus
  • Erwin
  • Crystal Reports

  • Microsoft Word
  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual Studio
  • Microsoft Visual SourceSafe

  • ASP.NET
  • Javascript
  • VBScript
  • CSS
  • HTML
  • XML


Awards

GTEC Honouree for the "Aboriginal and Treaty Rights Information System"
2012

Aboriginal Affairs and Northern Development Canada


GTEC Gold Medal for the "Human Resources Services Request System"
2009

Transport Canada


GTEC Bronze Medal for the "Automated Import System"
1997

Canadian Food Inspection Agency


Passions

  • Faith
  • Family
  • Snowmobiling
  • Old Ford Trucks