Richard Kinnaird Email and Phone Number

• Requirements gathering, business process analysis and solution architecting.• Creating custom integration solutions from SRS to Unit4 ERP and Unit4 SM using C# .NET Core Web API's, Visual Studio, Entity Framework, Azure, DevOps and Pipelines.• Unit4 SM integration using VB.NET Windows Forms desktop apps• SSRS custom reports development.• SQL, Oracle linked servers, Unit4 API's, Unit4 on-premises ROR data exchanges.

• Acting IS Manager on an as needed basis.• Supervise training of new IS support staff.• Manage ongoing enhancement of in-house Warehouse Management System, creating custom solutions to improve the customer experience and increase productivity.• Manage and coordinate all on-boarding of new clients, creation of custom data exchanges our WMS system. Working closely with the client to ensure a smooth transition to live.• Designed custom integration between UPS World Ship and our WMS to sync order status.• Monitor daily Integration flow monitoring, troubleshooting and fixing issues as they arise. • Manage SQL Server DBA, maintenance plans, index optimization, stored procedures, and scheduled jobs.• Web server management, IIS Administration, FTP site creation.

• Created VFP 9 code to transform SQL view data, used for Demand Summary reporting and forecasting.• Updated OLAP cubes as required by the new data structure.

• Created custom MS Access solutions for Purchasing allowing real time comparison of an Engineering Material List (ML) and Procurement spreadsheets and Accounting to automate the import of employee time from Labour Tracker into MRP for payroll.• Enhanced existing Crystal reports and T-SQL stored procedures as required.• Designed custom reports for Open PO’s and Sales Cost Analysis.• Automation of Production Scheduling spreadsheet using MS Access and VBA.

• Responsible for new development and maintenance of IGA MarketPlace POS.• MS Access/SQL database maintenance, development. • Created QA testing procedures, scripts and scenarios.• Deployment of the EMV (chip and pin) version of the POS application to all stores throughout the chain.

• Ongoing maintenance and development of reporting needs.• Custom T-SQL scripting/reporting, including SSRS.• Deployment of VB6 application upgrades.• Western Canada support for “dot broker”• Responsible for MS Access database maintenance, reporting and application enhancements.

• Implemented enhancements to allow the mass emailing of pricing notifications.• Ensured code updates where in compliance with new government levy regulations.

• Responsible for the maintenance of all existing reports, creation of new reports including requirements gathering, unit testing, user acceptance and training.

• Project lead responsible for impact analysis of VB6 to VB .NET migration.• Upgraded code to work within the .NET framework and maintain functionality.• Responsible for unit testing of all changes, documentation of implementation and deployment to the client’s environment.

• Responsible for setup and implementation of version control using VSS.• Wrote POS cash register using VB6 to handle, internet connectivity, FTP activation, file upload/download, connection to Oracle data sources, UI design and configuration.• Developed and implemented procedures for receipt printer compatibility and Barcode Scanner interface.

• Managed all custom applications including, staffing, maintenance, development and research.• Created custom Crystal Reports for in-house reservations application and Interactive Intelligence ACD phone system.• Software architect for all custom application for data collection of new destinations, this data was then used by the intranet as a value added sales tool for the agents.• Created custom e-forms using SQL 2000 and Form Flow.• SQL server 7/2000 installation, administration, creation of maintenance plans, stored procedures.• NT 4.0/Windows 2000 server system administration.• Help Desk support including, workstation setup and maintenance, hardware troubleshooting, email and ACD phone client setup.

• Managed three technical support employees.• Responsible for IT budgeting and project costing.• Successful execution of companywide technology upgrade under or within budget.• Hardware selection was conducted to maximize scalability and computing power for department’s needs.• Responsible for implementation of new network architecture• Installation and setup of MS Windows Server, SQL Server 6.5, Exchange Server 5.5, Seagate Backup Exec.• SQL Server 6.5 system administration, stored procedures, triggers, backup/restore and maintenance.• Migration from Novell 4.11 to MS NT 4.0.• Migration from third party E-mail POP service to MS Exchange Server 5.5.• Maintenance and development of custom CMA membership system using both FoxPro 2.5/2.6 DOS/WIN• Administration and programming of StarTalk voicemail and handsets.• Visual Basic 6.0/VBScript development and maintenance.• Installation and configuration of remote access using PCAnywhere 9.0 to facilitate remote administration and support for the network and iMIS.• Design of PowerPoint/VBA presentations for Directors, training and Society functions.• Installation and configuration of Great Plains for NT account payable and account receivable.• Installation and configuration of Fax Server using WinFax Pro 9.0.• Project Lead responsible for installation, integration and configuration of iMIS membership system including, data migration, custom SQL script development, MS Access/VBA and Crystal reporting. • Selection, negotiation and deployment of T1 fiber optic Internet access.• Hardware troubleshooting and repair.• Software support for all systems, including training.