Robert MacDonald

Automation and AI Systems Architect: production platforms for pay and HR

Profile

I design and build automation and AI systems that are dependable enough to run every day: they check their own results, pick up where they left off after a failure, and keep a record of everything they did. These are not one-off tools. On my own time it has meant more than 90 independent software projects, from AI services to a 3D game engine.

I use AI coding assistants to build quickly, and I design the structure around them so that speed never comes at the cost of quality. Every change is checked automatically, every past mistake has a test that stops it from coming back, and the systems say plainly when they do not know something instead of guessing. And the systems are built to work together rather than stand alone: shared speech and AI services serve several of my applications, one router spreads work across my machines, and an index of everything I have built is open to AI assistants in any project, so each new piece of work starts from what already exists.

I work at the frontier: I evaluate new technology, prove what it can do in a real setting, then set it up and put it into everyday use. AI document processing, secure cloud environments and automation, all new to the department, are now part of its daily operations.

Underneath all of it is many years of deep, hands-on knowledge of computer hardware. It lets me get far more out of the computers and cloud services an organization already pays for, and avoid paying for capacity it does not need. I apply the same thinking to where software runs: across Azure, Cloudflare's global network and servers I run myself, I design systems that cost little to operate, stay reachable, and keep private services private. None of it came from standing still: two years of college, then twenty-five years of continuous learning, with every new technology learned by putting it to work.

Selected results

Experience

Application Developer, HR and Pay AI Program

Feb 2024 – Present
Public Services and Procurement Canada (PSPC), Miramichi, NB

Led the hands-on technical work, in close collaboration with a fellow developer, subject-matter experts and the business, to conceive, engineer and deliver the MVP case-processing tools within the HR branch's AI case-processing project: membership dues, commuting allowance, leave with income averaging and executive performance pay.

  • No transcription, fewer errors: Aligned the tools' outputs with the Pay Centre's bulk-processing team so transactions, case notes and payment control were entered programmatically rather than retyped.
  • End-to-end data pipeline: Set up, with the team, the end-to-end process that kept payroll and case-management data current in an Azure SQL database: Azure Data Factory (ADF) pipelines and Oracle GoldenGate database connectivity, with concurrency and error handling, alongside SQL-based data access and control logic for the MVP prototypes.
    moreAlso designed the DuckDB and SQL schemas the pilot tools ran on, and ran the Protected B Microsoft Azure virtual machines that hosted the pilot.
  • Technical governance: Provided technical governance for a contracted AI document-processing program: reviewed and signed off on the contractor's technical approach and documentation, flagged gaps, and advised management on whether it was meeting its goals.
  • Image extraction: Built prototypes that extract case data from document images with OCR and AI, and collaborated on the data integration moving case-management image data into a departmental data repository.
  • Reusable foundation for production: Delivered the MVP's patterns, logic and business rules as a reusable foundation for the production version, with the requirements, technical documentation, code repositories, training material and knowledge transfer on how the ADF pipelines and databases connect, and coached colleagues in SQL optimization, Python integration and data architecture.

Application Developer, Pay Solutions Branch

Feb 2019 – Feb 2024
Public Services and Procurement Canada (PSPC), Miramichi, NB

Informal technical lead of the four-developer team that conceived, built and ran the Pay Centre's analysis and automation tools from 2016: holding the team together, setting direction and carrying each product from idea to adoption.

  • Pay History Analysis Tool: Drove the pay history analysis tool from idea to adoption: an Excel and VBA analytics tool built on data integration, joining 14 SQL queries of pay data with case details from the case management system into a day-by-day timeline of an employee's pay and career history.
    moreIt shows one cell for every day across each pay period and a bar for every payment, deduction, retroactive adjustment and job change. Every entry, cheque, earning and deduction opens its details on hover or in a popup, with links into the pay and case systems, in English and French; about 2,000 compensation advisors use it every day. Gathered what users and the business needed, built its back-end queries and data sources, cleared other work so its lead developer could focus, trained its users, kept it working through the move from Internet Explorer to Edge, Chrome and Firefox, and built a Citrix edition for departments outside the Pay Centre.
  • Upgrades and web version: Upgraded the original Excel and VBA tool with new SQL queries written to business requirements and published through change requests, brought its latest version, 4.0, through build and rollout, and led the requirements for its web version (TypeScript, HTML and SQL), available alongside it to every Government of Canada department.
    moreWorked with the department's innovation team and a contractor through sprint planning, backlog grooming and data sharing.
  • Client Information Centre (a compensation tool): Co-developed and championed, with its creator, the companion tool for case work: built-in standard operating procedures, automated letters and case notes, and links into the pay systems, used with the analysis tool as one system.
  • Tools other teams still run: Built audit and overpayment-analysis queries and bulk patterns (finding the right employee record, filling one-time payment files in bulk) that overpayment, verification and other teams still run, including for client departments.
  • Queries with the Digital Services Branch: Worked with the Digital Services Branch to develop, maintain and upgrade the queries behind the team's tools, and carried them through business requirements and change requests so they are available to everyone.
5 more from this role
  • AI exploration: Technical advisor to a departmental AI exploration project; wrote the core SQL that captured complex pay business rules and supplied the project's data.
  • First cloud steps: Explored and prototyped on Microsoft Azure for pay processing applications, ahead of the cloud work on an AI case-processing project.
  • Strike leave-without-pay automation: Led the strike leave-without-pay automation, removing pay holds automatically and providing bi-weekly reviews and reports to stakeholders.
  • Compensation advisor tools: Integrated the a revision tool and a letter generator with the pay history analysis tool and case information tool, and supported compensation tools used by more than 2,000 active daily users.
  • Bulk processing: Built utilities for bulk processing of transactions, cases and payments in the payroll and case-management systems, and supported Cognos 10/11 user-acceptance testing and data validation for senior management and directors.

Business Expertise / Data Integrity Analyst

Dec 2015 – Feb 2019
Public Services and Procurement Canada (PSPC), Miramichi, NB

Learned the system to find the leverage -- Mastered the payroll's data, queries, policies and collective agreements well enough to see where automation would pay off most, then built it.

  • Learned the system to find the leverage: Mastered the payroll's data, queries, policies and collective agreements well enough to see where automation would pay off most, then built it.
  • The foundation the automation was built on: Built the SQL extracts, data tagging and quality reviews that the team's later case-closure, pay-history analysis and bulk-processing tools were built on.
  • Bulk payment automation: Delivered a bulk payment automation that cut operational delays and became early proof that RPA could work in traditional pay processing.
  • Data quality and reporting: Ran data quality reviews, recommended data and system improvements, and produced queries, tools and reports for management from payroll and case-management data.
  • Procedures and guides: Wrote and maintained standard operating procedures and system help guides with stakeholders.

Compensation Advisor

Dec 2014 – Dec 2015
Public Services and Procurement Canada (PSPC), Miramichi, NB

Advised employees and managers on pay, benefits and insurance, applying federal and provincial legislation and collective agreements.

  • Compensation advice: Advised employees and managers on a wide range of compensation and insurance benefits.
  • Legislation and agreements: Researched and applied acts, regulations and collective agreements, keeping current with compensation directives and changes.
  • Data integrity: Maintained accurate records across the federal payroll system, the pay system, the case-management system and PeopleSoft.
  • Quality assurance: Completed peer verification to confirm accuracy and adherence to policy.

Distribution Clerk/Client Service Officer,

Aug 2010 – Dec 2014
Service Canada (CSD), Bathurst, NB

Handled protected records, management reporting and employer inquiries for Service Canada programs.

8 more from this role
  • Administrative Expertise: Performed a broad range of administrative and clerical duties, ensuring efficient office operations and the integrity of document management systems.
  • Data Management and Reporting: Took charge of distributing, maintaining, and safeguarding both physical and electronic filing of protected documents, in addition to creating reports and statistics for management, enhancing organizational efficiency.
  • Client Support and Legislative Application: Delivered exceptional client service by answering and assisting employers with technical inquiries about Service Canada programs, applying government legislation, acts, and regulations daily to ensure compliance and informed client interactions.
  • Perform various administrative, and clerical duties
  • Distribute, maintain, and keep physical and electronic filing of protected documents
  • Create Reports/Statistics for management/senior management
  • Answer and assist employers with technical inquiries regarding Service Canada programs
  • Apply Government legislation, acts, and regulation on a daily basis

Technician

Jan - Sept 2009
PC Medic, Amherst NS

Supervised daily activities of PC Medic Store

3 more from this role
  • Supervised daily activities of PC Medic Store
  • Tracked inventory and sales history
  • Performed maintenance and repair on computers and networks

Payroll Administrator

2009 – 2010
Reg Plumbing and Heating, Moncton NB

Perform scheduling and supervision of staff

2 more from this role
  • Perform scheduling and supervision of staff
  • Payroll, collections, accounting, and various other duties

Material Purchasing Officer / Technical Support

Feb - Aug 2008
Benjamin Heating, Springhill NS

Performed all aspects of material purchasing for the production of furnaces and boilers

2 more from this role
  • Performed all aspects of material purchasing for the production of furnaces and boilers
  • Used soft skills to find best prices and quantity breaks for the company

Administrative Assistant

2008 – 2009
Correctional Services of Canada, Springhill NS

Coordinated and distributed daily mail throughout institution

4 more from this role
  • Coordinated and distributed daily mail throughout institution
  • Administered testing and interviews for positions within the institution
  • Completed inventory system update
  • Supervised in the distribution of inmate canteen

Technical Support

2007 – 2008
Rogers Cable, Moncton NB

Provided technical support for customers with internet, wireless data and cable issues

2 more from this role
  • Provided technical support for customers with internet, wireless data and cable issues
  • Met and exceeded quality and call handle times on a regular basis

Customer Service Representative

2003 – 2005
Telus Mobility, Barrie ON

Assisted clients with a multitude of cell phone billing, sales, and hardware requests

2 more from this role
  • Assisted clients with a multitude of cell phone billing, sales, and hardware requests
  • Used an array of applications to perform troubleshooting, billing, and sales analysis

Data Pod Technician / Operations Support Specialist

2002-2003 and 2006-2007
TeleTech Canada, Orillia, ON and Amherst NS

Assisted business clients with troubleshooting their wireless internet services

4 more from this role
  • Assisted business clients with troubleshooting their wireless internet services
  • Worked in a fast-paced call centre environment helping individuals and businesses with their digital communication needs
  • Coordinated with management and supervisors to ensure our clients' service levels were met
  • Used numerous applications to forecast call volume, create/maintain schedules, and produce detailed reports for the corporate management

Selected projects

Independent architecture and engineering

Writing

Skills

Competencies

Education and continuous learning