Work

Practical solutions for complex operations

Our work sits where operations, safety and data meet: forms that used to be paper, reports that used to be manual, and programs that need someone to carry them through delivery.

Selected work

Recent engagements

State emergency management · Data integration & Analytics

Integrated data and reporting for emergency management

Challenge
Information on emergency operations, damage assessment, grants and finances sat in separate applications and data sources. Leadership needed consistent reporting across them, and the agency’s existing business applications needed ongoing support as requirements changed.
Approach
Enterprise data architecture and integration on Power Platform and Dataverse, connecting operational systems to shared reporting:
  • Application support: ongoing support for existing Power Platform applications for financial management and for emergency rostering and credentialing.
  • Operational reporting: Power BI reporting for emergency operations, including search and rescue and hazardous materials.
  • Damage assessment and recovery: integration design and reporting architecture that bring damage assessments, recovery data and declaration tracking together.
  • Administrative analytics: clearer visibility into grants, finances, project portfolios, workload and capacity.
Result
Reusable data structures and consistent reporting definitions across operations and administration, clearer visibility for leadership into performance, workload and priorities, and business applications that keep pace with the agency’s needs.
  • Power Apps
  • Dataverse
  • Power Pages
  • Power Automate
  • Power BI
  • SharePoint

Professional services firm · Data & Analytics

Financial and workforce reporting leadership can trust

Challenge
Reporting on revenue, work in progress, billing, collections, staff productivity and business development had grown complex, with inconsistent calculations and reports that were hard to navigate.
Approach
Modernized the firm’s Power BI data model and business rules, not just the dashboards, so every report draws on one consistent set of calculations:
  • Financial analytics: revenue, invoicing, billing realization and work in progress.
  • Workforce productivity: validated measures for billable hours, capacity, utilization and budgets.
  • Business development: attribution for client origination and shared credit, with prior-year comparisons.
  • Data management: cleaner semantic models and DAX, data reconciliation, controlled access and simpler navigation.
Result
More consistent measures of financial and workforce performance, clearer business development credit, and easy comparison against prior periods and targets.
  • Power BI
  • DAX
  • Semantic models

City medical examiner · Data integration

Automated daily situation reporting during COVID-19

Challenge
During the COVID-19 response, the daily situation report was compiled by hand from several disconnected SQL systems and Excel reports, taking up two staff members every day.
Approach
An on-premises data gateway connected the separate SQL systems and Excel reporting to Power BI as one consistent picture, feeding response-planning reports and an automated daily situation report.
Result
The daily situation report runs automatically, freeing two staff members for other response work.
  • Power BI
  • On-premises data gateway
  • SQL
  • Excel

City emergency management · Apps & Analytics

Procurement and preparedness tools on Power Platform

Challenge
Several teams needed better tools for core work, from contract procurement on a basic SharePoint list to preparedness exercises tracked in Excel.
Approach
Three focused projects on the agency’s existing Microsoft 365 platform:
  • Procurement contract management: restructured the contract data in SharePoint, then added a canvas app with built-in business rules and routing, Power Automate flows and improved Power BI reporting.
  • USAR grant tracking: a Power BI dashboard for tracking urban search and rescue grants.
  • Exercise tracking: moved exercise data out of Excel into a structured SharePoint list with notifications and a Power BI dashboard.
Result
More efficient workflows, clearer status and next steps for each area, and coordinated briefings that kept leadership informed.
  • Power Apps
  • Power Automate
  • SharePoint
  • Power BI

City emergency management · Protected health data

COVID-19 vaccination and testing tracking

Challenge
During the COVID-19 response, the agency needed an internal way to track staff vaccination and testing, using records that held PII and HIPAA-covered health data.
Approach
A canvas Power App on SharePoint with Power Automate flows and Power BI reporting. Restricted permissions and intake that let staff add records but only ever see their own kept the health data protected.
Result
Leadership had a clear, current view of vaccination and testing status, while each person’s health records stayed visible only to them and authorized staff.
  • Power Apps
  • Power Automate
  • SharePoint
  • Power BI

Experience

Public-sector operations experience

Our team has supported state and city agencies responsible for transportation, emergencies and continuity of government. That experience shapes how we design: around real procedures, controls and the people on shift.

Sectors

  • Transportation
  • Emergency management
  • Safety & security
  • Continuity of operations
  • Health & human services

Start a conversation

Have a process that still runs on paper or spreadsheets?

A free 30-minute call to talk through your process, the tools you already have and where a solution would make the biggest difference.

Intro call30 minutes · free · Microsoft Teams
Book

Prefer email?