David Johnstone Email & Phone Number

St. Thomas, On

- Tech Stack: C# .Net Core, Core web API, Angular, TypeScript, Bootstrap, Git, GitHub, Swagger, Dapper, SQL Server, Microsoft Power Automate, MQTT, Redis Cache, Worker Service, Microsoft Report Builder, Visual Studio, VS Code, Node, NPM.- Modernized critical “Part Manager” Windows application from VB.Net to C#. Added core features for tracking and reporting engineering changes of automotive parts. Improved process flow and document management to simplify, automate, and streamline engineering changes.- Created a new “Incident and Injury” full-stack web application for managing and reporting workplace injuries, property damage, and environmental contamination. Included automated email system and integration with Power Automate (MS Teams messaging) for information distribution and approval processes. Added visual documentation of injuries by allowing drawing on a body diagram.- Created a new “Plant Pass” full-stack web application to replace a costly 3rd party application for registering and managing on-site visitors and contractors for multiple plant locations. Managed on-site scheduling, security code generation and distribution, sign-in/out process, badge printing, and contractor insurances and safety documentation.- Updated a number of systems including security access to the “Employee Teams” web application which manages employee data, feedback, and disciplinary information. Updated distribution lists for “Document Manager” which informs teams when critical documents are revised. Created a “Weld Parameters” web application allowing efficient access to data required for shop-floor machine configurations. Created a new “FIFO” web application allowing forklift drivers the ability to verify latest inventory use via a mobile device.

London, Ontario, Canada

- Created an online Customer Rewards Framework restful web API with C# and SQL.- Designed and developed video game systems with C# and Unity specializing in AI heuristic decision making, path-finding, inventory and leader-board integration.- Designed and created custom websites for independent businesses.- Technical skills include C#, Unity, Visual Studio Code, JavaScript (ES6+), Node.js, Express, TypeScript.

London, Ontario, Canada

- Tech Stack: C#, .Net Framework, ASP.Net, JavaScript, CSS, HTML, SQL (SSIS, SSAS, SSRS), IIS, Com+ Enterprise Serviced Components, Windows Services, MSMQ, Visual Studio, VSS, SVN.- Developed core back-end systems including the Integrated Intelligence (i2TM) platform, security, administration, scheduling, events and notifications, and reporting.- Developed enterprise-wide, mission-critical, distributed back-end systems for the Integrated Intelligence Platform TM comprising security, administration, scheduling, events and notifications, data collection, and reporting.- Developed customer-facing applications including GPS Mapping, Equipment Maintenance, Rental, Remote Control, Real-time Data Collection, Restful APIs driving mobile, website, and custom client applications.- Modernized UI elements including dashboard, navigation, content layout, and custom themes.- Adept at building scalable fault-tolerant software architectures with a focus on performance, specializing in SQL performance tuning.- Trained and developed new employee competence in all facets of technologies including system architecture, design patterns, applications, communication systems, database design, best-practices and standards.- Strong contributor toward continuing innovation movement in an agile environment.

London, On

- Designed and implemented the web-based version of WinAir TM – an aircraft maintenance, scheduling, and inventory control system using Java, Apache, and SQL.

London, On

- Designed and implemented the web-based version of inPulse TM – a distributed digital content system using Java, WebSphere, DB2 and Linux.