Projects

Wave Rollout Tracking Dashboard

Power BI dashboard built in 2 weeks to track complex 5-wave workforce rollout across 4 months. Transformed slow Excel lookup process into interactive single-click information hub. First Power BI project for the team, self-taught M code and DAX during development. Enabled instant employee assignments, email routing automation, and vacation coverage visibility.

Power BIM CodeDAXPower QueryExcelAccess DatabaseSharePoint

View Project

Workers Compensation Analytics Dashboard

Excel dashboard with Power Pivot and DAX built for Business Continuity stakeholders to analyze workers compensation claims across multiple lines of business. Identified risk patterns, cost drivers, and prevention opportunities through statistical analysis and multi-dimensional data modeling. Delivered actionable recommendations for safety improvements and cost reduction.

Excel Power PivotDAXPivot TablesGETPIVOTDATAData Modeling

View Project

Automated Report Distribution System

Six parallel Power Automate flows eliminating manual report copy workflows for macro-heavy workforce reports. Automated SharePoint monitoring, OneDrive file transfers, and Teams notifications reduced daily file operations from tedious multi-step process to instant delivery. Personal productivity solution demonstrating advanced workflow automation capabilities.

Power AutomateSharePointOneDriveMicrosoft TeamsFlow Bot

View Project

Automated Weekly Schedule Generator

Office Scripts and Power Automate solution eliminating 90-minute weekly schedule creation process. TypeScript automation handles bi-weekly template rotation, date calculations, and visual formatting through Sunday morning scheduled execution. First TypeScript project demonstrating self-directed learning and programming language transfer from VBA.

Office ScriptsTypeScriptPower AutomateExcel

View Project

Claims Platform Analytics Dashboard

Power BI dashboard with integrated Power Automate data preservation addressing critical historical data loss problem. Revealed previously invisible documentation quality gaps through innovative coaching opportunities analysis. Combined live and archived data sources for first-time historical trend visibility across claims platform performance metrics and team coaching needs.

Power BIPower AutomateM CodeDAXPower QuerySharePointExcelField Parameters

View Project

Permanent Timecard Lookup Tool

Power BI dashboard redesign transforming temporary wave tracker into permanent operational reference tool. Eliminated obsolete features while amplifying high-value lookup capabilities with innovative employee information panel, intelligent email automation to use employee's preferred name, and non-app user detection system. PowerShell automation enables scheduled refresh of specific Excel workbooks eliminating manual maintenance.

Power BIDAXM CodePower QueryPowerShellSharePointTask SchedulerAzure Maps

View Project

SharePoint Report Archive Automation

Power Automate scheduled automation transforming complex 4-level SharePoint folder structure into streamlined 2-level system with automatic archival. Team-wide infrastructure redesign eliminated manual folder creation, end-of-month navigation chaos, and tedious multi-click workflows. Coordinated cross-functional technical change management with VBA stakeholders to ensure backward compatibility and smooth rollout.

Power AutomateSharePointVBA

View Project

Shared Inbox Email Routing Automation

Power Automate workflow suite eliminating manual email triage and forwarding burden during email duty shifts. Ten parallel flows automatically detect, route, and file incoming emails to team distribution lists based on sender, subject keywords, and email type patterns. Reduced email duty workload by automating most common routing workflows, enabling focus on complex unusual emails requiring human judgment.

Power AutomateOutlookDistribution ListsShared Mailbox

View Project

Hot Topic Info Board Automation

Power Automate and Power Apps integration eliminating critical single point of failure bottleneck for team information board. Automated complete workflow from supervisor email receipt to Power App form population with email copy attachment and content extraction. First Power Apps project demonstrating cross-platform integration capabilities and eliminating coverage gaps during team member absence.

Power AutomatePower AppsOutlookEmail Automation

View Project

Dynamic Daily Task Management

Power Automate workflow suite solving Microsoft Planner recurring task limitation through day-specific task generation. Five daily automations create only relevant tasks per weekday, eliminating visual clutter from perpetual date-shifted recurring items. First Power Automate project demonstrating self-directed learning and personal productivity optimization through automation. Improved daily task visibility and true completion tracking.

Power AutomateMicrosoft PlannerOutlook

View Project

Monthly Schedule Verification Automation

Power Automate scheduled workflow establishing proactive data quality maintenance for workforce schedule accuracy. Monthly automated reminders to leadership ensured schedule workbook remained current, preventing downstream timecard discrepancies and unnecessary corrections. Preventative approach shifted from reactive problem-solving to proactive data integrity management.

Power AutomateOutlookEmail Automation

View Project

Emergency Employee Safety Check Automation

Two-flow Power Automate architecture eliminating manual emergency response email workflows during crisis events. Teams chat trigger enables instant employee safety check deployment through single keyword command. Parallel 24-hour delayed supervisor escalation flow automatically follows up with non-responders. Cross-team collaboration project built with Business Continuity analyst, replacing manual crisis communication entirely.

Power AutomateMicrosoft TeamsExcelSharePointEmail Automation

View Project

Claims Analytics Ecosystem

Multi-platform analytics solution combining Power BI dashboard with 70+ DAX measures, custom Power App for data entry, and automated workflows eliminating hours of monthly manual processing. Three-phase evolution from basic dashboard to complete ecosystem with training quality tracking, automated archival, and seamless cross-platform integration. First Power App and most complex Power BI project demonstrating advanced data modeling, UX design, and self-directed learning across multiple Microsoft Power Platform tools.

Power BIPower AppsPower AutomateDAXM CodePower QuerySharePointExcelTypeScriptOffice Scripts

View Project

Personal Email Management System

Power Automate rule-based email filing system with 30+ conditional workflows reducing inbox volume by 90 percent. Automated categorization handles supervisor alerts with Teams notifications, auto-archival of low-value emails, and smart filing for reference materials. Built after returning from PTO to over 1500 unread emails, transforming Thursday morning email triage from hours to minutes through intelligent pattern recognition and folder routing.

Power AutomateOutlookMicrosoft TeamsEmail Automation

View Project