Randy Gamage
The ROViewer app is a cloud-based IOT front end that allows customers to track their ROVs (Remote Operated Vehicles) around the globe. It provides realtime telemetry via an instrumentation dashboard, as well as a file manager to allow downloading detail records and data logs. It also integrates with the Microsoft TSI (Time Series Insights) environment to allow unlimited flexibility in viewing the charted data that is collected. I designed and built this web front end and contributed to the work on edge devices and data collection code. I also implemented all of the Azure API endpoints that move data from the Edge, through Azure and archiving of the data in blob storage.
PartRover is an enterprise tool I developed at Schilling Robotics that allows any employee to find all related information about the company's parts, in the quickest and easiest way possible. Given a part number, users can find suppliers, manufacturers, order history, change history, bills of materials, where used, assembly drawings, phptos, failure history, related company work instructions and procedures, etc.
Pick and Ship app is an ERP-driven part planning, picking, and shipping app I developed for Schilling Robotics. It is fully integrated with their ERP system, and allows factory floor workers to Plan, Pick, Box, and Ship parts out to customers. It handles all aspects of international shipping, including HTS codes, EECN codes, export licenses, government filing (AES/EEI filing) for US export, etc. It creates commercial invoices, packing slips, and part labels automatically. It manages custom box sizes and weights, freight forward scenarios (with automatted SED form creation) and splitting of shipments to any grouping of parts as needed. In the first year of implementation it allowed Schilling to hit a new record revenue for spare parts shipped for the year, and greatly reduced the manpower needed to ship parts every day.
The PCO app is designed for managing change orders ("ECOs" in more common terms), which are driven by the Engineering / Product Development group, but change affects all departments, and the PCO app provides visibility, traceability, and accountability for these changes. All aspects of design changes are documented in the app, which integrates with the ERP system, as well as SharePoint document libraries, SolidWorks native CAD objects, and network shared folders. All this data is pulled together to provide a seamless workflow for the users. ISO-9000 and DNV auditors love this tool, because it makes their job so easy to review the change management process.
The MTP (My Tennis Partner) app is a website designed for organizing social tennis. It is designed as a normal website but with mobile-first design that looks good and works well on mobile phones. It is written in .NET Blazor Server Side app with a SQL Server back end. The app is actively used by several groups of tennis players in various indoor and outdoor leagues, in the Sacramento area. I originally wrote it in ReactJS, but then re-wrote it in .NET Blazor. I posted the React version in a public repository as open source.
