Dylan Rose Email & Phone Number

– Developed mobile Power Apps portal that improved manager/employee communication and interdepartmental cohesion.– Improved labor efficiency by automating sales process, commission calculations, and manager approvals with Power Automate. – Maintained Access financial/accounting database - repaired outdated SQL Queries, forms, and reports.– Built automated job labor reports and ETL pipeline with Python / REST API to query QuickBooks time for reporting in PowerBI.– Managed company SharePoint, Power Apps, Power Automate flows, Microsoft Admin Center, and Microsoft Exchange server.– Maintained Data Integrity of CRM and Microsoft SQL database.

Salt Lake City, Utah, United States

– Managed daily workflow for team by running sales reports and allocating jobs to warehouse staff.– Issued updates and corrections to POs with MICA business system.– Tracked & investigated inventory discrepancies with ISQL reports.

Salt Lake City, Utah, United States

– Managed client data with Microsoft Dynamics 365 CRM software.– Automated routine processes with Excel macros and VBA.– Developed goals and KPIs during formation of a new team.– Standardized and documented operational processes in training & procedures manual.– Developed system for tracking quarterly revenue and expenses utilizing excel macros.