Sukhmeet
Singh Hora, EIT

A secure, full-stack enterprise dashboard suite for Indus Automation — three integrated real-time apps covering production job tracking, design drafting workflows, and resource capacity planning. Protected by Microsoft Entra ID (Azure AD) with MSAL authentication; accessible only to company domain users.

Offline-first Power Apps canvas app deployed for field technicians at Indus Automation — captures multi-task workplace hazard assessments with dynamic risk scoring, PPE validation, and hazard classification. On submission, triggers a Power Automate flow that auto-generates a signed formatted PDF and routes it to the Safety Representative with zero manual intervention.

Production-deployed 6-step Power Apps wizard that replaces a paper-based service record process at Indus Automation. Captures multi-day work performed, auto-calculates Regular/Overtime/Double Time by day-of-week CBA rules, itemizes materials costs, and routes records through an identity-verified multi-approver workflow — culminating in auto-generated PDFs distributed to management and customer, with permanent SharePoint archival.

Production Power Apps canvas app for company-wide weekly timesheet entry covering regular, overtime, holiday, sick, and vacation hours — with overtime banking (FIFO, 27hr cap), mileage tracking, and copy-prior-week UX. Feeds a parent/child Power Automate flow architecture that generates per-employee Excel files and a master QuickBooks-aligned import sheet, automatically split across two companies (Indus + Break Engineering), with CPA notification on full submission.

Engineered a secure remote-access architecture for industrial sites using Exor MicroEdge edge gateways and Corvina Cloud as the VPN broker — enabling encrypted connectivity to field PLCs, HMIs, and SCADA from desktop and mobile without public internet exposure. Configured CIDR-based endpoint access control, per-protocol application profiles (RDP, VNC, SSH, HTTPS), and validated TAP-tunnel Layer-2 routing. Also evaluated Siemens SCALANCE S615 with SINEMA Remote Connect as an alternative stack.

Python proof-of-concept that queries live Siemens WinCC SCADA data directly via pyodbc → SQL Server → WinCC OLE DB Linked Server, bypassing manual HMI exports. Dynamically builds UNION ALL queries across user-selected PLC tags, retrieves timestamped analog and alarm history, and exports structured compliance reports to Excel — validating the full WinCC OLE DB reporting pipeline.

Custom cross-platform smartphone app (iOS & Android) for real-time remote monitoring and control of Siemens S7-1200/1500 PLCs at pump/lift stations. AWS IoT Core + MQTT, RBAC authentication, real-time dashboard, and push/email/SMS alerts.

University of Manitoba Capstone (team of 6). Sensor-driven system enabling boaters to conduct real-time bathymetric surveys — sonar + GPS data streamed to a Flutter app with Google Maps visualization, safe-route navigation, and ML-driven hazard detection.

MERN-stack career platform (team of 6) connecting job seekers and employers. Features AI-driven job recommendations, live employer quizzes, real-time messaging, interview scheduling, and forums. Load tested to 250 concurrent users with JMeter.

Python automation engine that reads structured cutsheet filenames, auto-builds a multi-page Table of Contents with clickable internal hyperlinks and PDF bookmarks, then merges everything into a single deliverable PDF. Distributed as a standalone .exe via PyInstaller. Paired with a VBA macro that searches network drives to locate cutsheets by part number and manufacturer.

Embedded assistive technology for deaf curlers. A handheld controller wirelessly signals sweeping commands to an LED ring on the broom — providing visual cues via ESP-NOW (peer-to-peer Wi-Fi, no router) between two ESP32 modules.

Clean, responsive e-commerce storefront for tech products with dynamic product catalogue, shopping cart, checkout flow, user account management, and product recommendations. Deployed on GitHub Pages.

Fully normalized relational database for managing music catalogues — albums, artists, songs, playlists, and user data. Features a Python CLI for complete CRUD operations and complex SQL queries. COMP 3380 Database course project.

A suite of enterprise automation tools deployed across Indus Automation and New Flyer — spanning VBA macros for PLC I/O data integration into AutoCAD Electrical, dynamic capacity planning and budget forecasting workbooks connected live to SharePoint, automated BoM management systems, and Office Scripts pipelines. Collectively replaced multiple manual paper and Excel-based processes, achieving an 8× efficiency improvement in design workflows.