Power Apps
Scheduling Application
With Intelsius I created a scheduling application that tracks, audits, and notifies relevant departments on order progress through the entire order lifecycle. The application draws in orders automatically, calculates the estimated production time, and prepares them for assignment. To complete the real-time order lifecycle, I also created a client side application that would allow for real time tracking on the warehouse floor, creating immediate communication between managers and floor workers.
Rental Tracking
This application handles up to 1000 rent-able assets and their refurbishments upon return. The assets are set to be returned within a set period of time, if not returned the application notifies the appropriate team of the overdue rental. Once returned, the application allows for a warehouse worker to mark damages on the asset and create notes. The data is on a robust and traceable data-verse table set. This application was integrated into the scheduling application, so when a rental was returned, it automatically creates a new item to be scheduled on the production line to be refurbished.
Power Automate
Three stage API request
I created a Power Automate Flow that talks with our website and the FedEx API. The flow takes data from an excel order template for a three leg shipment order. It reads the template and then creates the order on our website. Using the FedEx API, it generates the shipping labels and sends them out.
Office Script
Excel Template Reading
I am a big fan of automating where it makes sense. Excel is a very powerful tool that allows for data manipulation and entry. Utilizing Office Scripting, I have automated the data entry of multiple templates into a database. Then I automated updates to weekly and daily reports into single button presses.