About
James Mackenzie - an IT consultant with over 30 years experience. I have worked with many types of technologies, organizations, projects and people. I am a practical logician with resourceful and flexible problem-solving abilities. I excel at connecting abstract concepts to useful solutions. I am a focused communicator with a relaxed and personable style that adapts effectively to any audience.
DATA ANALYSIS
I possess a keen ability to envision data structure and I am skilled at creating relational data models. I am able to develop new databases and efficiently analyze and improve existing databases. I have a broad background in data migration and I am experienced in analyzing, transforming, linking and summarizing data regardless of format or size. I have advanced expertise in CMDB data collection and warehousing.
BUSINESS SYSTEMS ANALYSIS
I am successful when implementing and managing high-performance and large-scale IT projects. I can conduct a comprehensive analysis of an IT infrastructure to achieve maximum reliability and performance with low overhead. I am experienced in producing clear technical, training and business documentation and am adept at project planning. I assist in cost cutting by identifying and implementing standardization and efficiency measures.
APPLICATION AND REPORTING DEVELOPMENT
I code simple and efficient browser-based interfaces for data management; writing practical, modular code and designing simple and intuitive interfaces. I create precise reports and dashboards and develops automated processes to export and import data into multiple formats for display and distribution.
I possess a keen ability to envision data structure and I am skilled at creating relational data models. I am able to develop new databases and efficiently analyze and improve existing databases. I have a broad background in data migration and I am experienced in analyzing, transforming, linking and summarizing data regardless of format or size. I have advanced expertise in CMDB data collection and warehousing.
BUSINESS SYSTEMS ANALYSIS
I am successful when implementing and managing high-performance and large-scale IT projects. I can conduct a comprehensive analysis of an IT infrastructure to achieve maximum reliability and performance with low overhead. I am experienced in producing clear technical, training and business documentation and am adept at project planning. I assist in cost cutting by identifying and implementing standardization and efficiency measures.
APPLICATION AND REPORTING DEVELOPMENT
I code simple and efficient browser-based interfaces for data management; writing practical, modular code and designing simple and intuitive interfaces. I create precise reports and dashboards and develops automated processes to export and import data into multiple formats for display and distribution.
As indicated, I have worked with many organizations and people. Below are the most prominant engagements of my career.
You can get the details from my Linkedin Profile.
Lobsters R Us Seafood, Little Harbor, NS
Business Systems Analyst/Developer, June 2012 – Present (14 years)
Designed and supporting a complete web-based production system to replace a spreadsheet and paper-based process. The system manages inventory averaging 3 million pounds of lobster and 3 million pounds of crab per season.
Shared Services Canada (SSC), Ottawa, ON
Enterprise Architect, July 2020 – Sept 2025 (5 years)
Provided Enterprise-level Business and Financial System analysis as well as Data Migration and Project Management services to CMDB teams affecting deployed IT equipment across Shared Service Canada.
Health Canada (HC), Ottawa, ON
Business Systems Analyst/Developer, January 2008 – November 2010 (2.5 years)
Designed and implemented a comprehensive reporting system supporting HP OpenView suite of products. The total investment of the project exceeded $5 million and affected a user base of 15,000 employees nationwide.
Public Works & Government Services Canada (PWGSC), Ottawa, ON
Business Systems Analyst/Developer, July 1997 – December 2007 (10 years)
Co-launched and supported the first thin-client System at PWGSC. Designed, implemented, and supported a web-based timesheet and contract reporting system that supported 200 contractors and billed $250 million over a 7 year period.Managed the sales and customer support for a company of thirty employees with total yearly sales of over $5 million and 250 customers in twenty-five countries.
You can get the details from my Linkedin Profile.
Lobsters R Us Seafood, Little Harbor, NS
Business Systems Analyst/Developer, June 2012 – Present (14 years)
Designed and supporting a complete web-based production system to replace a spreadsheet and paper-based process. The system manages inventory averaging 3 million pounds of lobster and 3 million pounds of crab per season.
Shared Services Canada (SSC), Ottawa, ON
Enterprise Architect, July 2020 – Sept 2025 (5 years)
Provided Enterprise-level Business and Financial System analysis as well as Data Migration and Project Management services to CMDB teams affecting deployed IT equipment across Shared Service Canada.
Health Canada (HC), Ottawa, ON
Business Systems Analyst/Developer, January 2008 – November 2010 (2.5 years)
Designed and implemented a comprehensive reporting system supporting HP OpenView suite of products. The total investment of the project exceeded $5 million and affected a user base of 15,000 employees nationwide.
Public Works & Government Services Canada (PWGSC), Ottawa, ON
Business Systems Analyst/Developer, July 1997 – December 2007 (10 years)
Co-launched and supported the first thin-client System at PWGSC. Designed, implemented, and supported a web-based timesheet and contract reporting system that supported 200 contractors and billed $250 million over a 7 year period.Managed the sales and customer support for a company of thirty employees with total yearly sales of over $5 million and 250 customers in twenty-five countries.
Although this website highlights my individual experience, I also have professional relationships with individuals and organizations with similar levels of expertise and acumen. If there is a need to engage additional resources to assist in your project, I will indicate that this is the case and introduce additional resource(s) as necessary.
I also have several contacts in large-scale personnel firms that specialize in providing professional services. I can assist in obtaining short and/or long term resources for your needs if they're completely outside of the scope of what I'm able to provide.
I also have several contacts in large-scale personnel firms that specialize in providing professional services. I can assist in obtaining short and/or long term resources for your needs if they're completely outside of the scope of what I'm able to provide.
2026-04-17 09:45:18 ATL