← Back to Portfolio
Portfolio / AI Work / 02 · Flagship
Case Study 02 · Flagship

Operational Stabilization & AI-Enabled Recovery in a Post-Disruption Territory

Following the conclusion of a federal consulting engagement impacted by DOGE-related cost reduction initiatives, I was brought into a global equipment manufacturing organization to stabilize a high-risk territory devastated by hurricane damage. Over a defined five-month scope, I retained 27 of 30 at-risk client accounts, reduced ticket resolution time by 67%, cut field survey time by 77%, and introduced AI-assisted workflows across a team with no prior exposure to digital productivity tools.

Engagement Details
OrganizationGlobal Equipment Manufacturer
RoleSenior Account Manager · Crisis Recovery Engagement
DurationSep. 2025 · Early 2026 (5-month scope)
ContextPost-hurricane territory recovery · 30 at-risk client accounts
AI StackClaude · ChatGPT · Microsoft Copilot · AI route planning
IndustryEquipment Manufacturing & Field Services
ApproachConsulting frameworks + AI-enabled productivity in a non-tech field environment
67%
Reduction in average ticket resolution time (9 days to 3 days)
77%
Field survey time reduction · 120 min to 27 min
96%
SLA compliance rate achieved after workflow systems deployed
5-Pillar Case Study
1
Pillar One
Diagnostic Framing · The Engagement Context & Operational Bottlenecks

This engagement was not a standard account management role. Following the conclusion of a federal consulting contract impacted by government cost-reduction initiatives under the Department of Government Efficiency (DOGE), I transitioned into a global equipment manufacturing organization to support a high-risk territory experiencing severe operational disruption after hurricane-related damage impacted service continuity, client responsiveness, and field execution.

The five-month engagement had a defined stabilization mandate: reduce service backlog, improve execution efficiency, protect client retention, and introduce operational structure to a team that had been operating reactively since the disruption. Approximately 30 client accounts were identified as at risk due to ongoing service failures and operational instability. Although the industry differed significantly from my prior background in consulting, technology, and analytics-driven environments, I applied transferable consulting frameworks, operational problem-solving methodologies, and AI-enabled productivity strategies to accelerate impact within a compressed recovery timeline.

Engagement Mandate

Stabilize field operations, reduce open service backlog, protect at-risk client accounts, and introduce scalable AI-assisted workflows to a team with no prior exposure to digital productivity tools · all within a five-month engagement scope.

Three core operational bottlenecks were identified in the first two weeks of the engagement:

Problem One
The 2-Hour Paper-Based Diagnostic Survey

Every client visit meant showing up with a clipboard, writing notes by hand, and mentally juggling 40+ inspection checkpoints across cab interiors, door systems, machine rooms, and controllers. Account managers were deciding on the fly what to look at next. A thorough survey took 2 hours, quality varied by rep, and the paper notes had to be manually converted into a report afterward. The process had no structure, no consistency, and no way to scale.

Problem Two
The Single-Person Proposal Bottleneck

The branch manager wrote excellent proposals. His tone and client framing were what closed deals. No one else on the team could replicate it. Every account manager proposal required repeated revision cycles, and the manager's time was the bottleneck.

Problem Three · The Invisible Ticket Backlog

ServiceNow was the platform. Email was the process. When a ticket was created, the only notification account managers and managers received was a system-generated email that quickly got buried in inboxes. There was no centralized view of what was open, what was overdue, or who owned what. Tickets sat for days without follow-up not because people didn't care, but because nothing made them visible.

I built a ServiceNow ticket tracker in Excel with dropdown menus for team, category, priority, and status · pulling the same data that lived in the platform into a format the team could actually use in a meeting. Then I designed a structured weekly cadence to run alongside it: a Monday morning 10-minute triage to review all open tickets, a Wednesday check-in to track progress and follow up with IT support, and a Friday close-out meeting to confirm resolved tickets and flag anything still open. Three touchpoints, 10 minutes each, zero additional headcount.

67%
Reduction in average ticket resolution time
9d → 3d
Average open ticket lifespan before and after
30 min
Total weekly meeting time to run the full cadence
96%
SLA compliance rate achieved after system deployed
Weekly Ticket Cadence · Designed by Joaquin Wilson
Monday · 10 min
Full triage of all open tickets. Assign priority and owner. Set resolution target for the week.
Wednesday · 10 min
Mid-week progress check. Follow up with IT support on any blocked tickets. Escalate if needed.
Friday · 10 min
Close-out review. Confirm resolved tickets. Final IT follow-up. Flag anything rolling into next week.
Tangible Proof · The Ticket Tracker & Executive Dashboard

Below is the ServiceNow Open Tickets tracker built in Excel · category dropdowns, priority levels, SLA status, resolution times, and real-time age tracking across all open tickets. Alongside it, an IT Operations Executive Summary dashboard showing SLA compliance, open ticket counts, and team-level breakdown · built so any manager could see the full picture in under 30 seconds.

ServiceNow Open Tickets Tracker.xlsx
ServiceNow Ticket Tracker built by Joaquin Wilson
IT Operations Executive Summary Dashboard.xlsx
IT Operations Executive Dashboard built by Joaquin Wilson
ServiceNow ticket tracker and IT Operations Executive Dashboard · built in Excel to give account managers and leadership real-time visibility into open tickets, SLA compliance, and resolution performance.
How I Built the Fix

Since I came from a consulting background, not the elevator industry, I started where any good analyst starts: research. I used AI to run deep market research on the most common upgrade opportunities and lead signals in commercial elevator maintenance, including obsolete door edge types, aging controllers, overheating machine rooms, and cab interior wear patterns. That research became the backbone of the form.

I combined that research with my consulting skills and Generative AI to design a structured digital survey in Excel. Every inspection category became a dropdown menu with standardized condition ratings. The form guided account managers through each section in a fixed sequence, eliminated the "what do I look at next" hesitation, and auto-flagged upgrade priorities by category. Paper and pen were gone. The mental load of running the survey dropped to near zero.

120 min
Average survey time before the digital form
27 min
Average survey time after adoption across 5 account managers
40+ pts
Inspection checkpoints standardized with dropdown logic
Tangible Proof · The Actual Tool

Below is a screenshot of the Executive Survey Form (v2) built in Excel. Each section · Cab Interior, Door System, Machine Room · uses dropdown menus with condition-specific options. Account managers move through the form in sequence, select from standardized choices, and the form flags upgrade opportunities automatically.

SurveyForm_Executive_v2.xlsx
Executive Survey Form - Excel diagnostic tool built by Joaquin Wilson
Executive Survey Form v2 · built in Excel using dropdown logic, AI-assisted market research, and consulting methodology. Deployed across a 5-person field team.
Measurable Goal

Cut diagnostic survey time to under 30 minutes with no loss in quality, and make the branch manager's proposal style transferable to every account manager without requiring his direct involvement in every revision.

2
Pillar Two
Prompt Iteration Logs · Building Both Systems

System One: The Diagnostic Form

Version 1 · Manual Checklist
  • Free-text entries for each component
  • No standardized condition ratings
  • No automatic upgrade flagging
  • Average completion: 90 minutes
Version 3 · Production Form
  • Dropdown menus for all component conditions
  • Standardized ratings: Good / Monitor / Upgrade Required
  • Auto-flagged upgrade priorities by category
  • Average completion: 27 minutes

System Two: The Proposal Prompt Library

Version 1 · Generic Prompt
"Write a proposal for an equipment upgrade at a commercial office building. The client needs a new door operator and controller replacement."
Version 4 · Few-Shot Production Prompt
"You are writing a client proposal for a field equipment services company. Study the tone, structure, and persuasion style of the following 4 successful proposals by the branch manager: [examples]. Write a new proposal for [client/building type] addressing [upgrade needs]. Match his direct, client-focused tone exactly. Lead with the client's operational risk, not product features."
What the Few-Shot Approach Solved

Generic prompts produced generic proposals. The few-shot approach gave Claude a concrete style target. After version 3, proposals matched the manager's tone closely enough that he stopped requesting revisions. The writing style became a team asset, not a single person's skill.

3
Pillar Three
Guardrails & Governance
Standing Rules · Diagnostic Form

1. The form flags upgrade priorities but never makes the final recommendation. The account manager reviews every flag before it appears client-facing.

2. Machine room and controller assessments require physical inspection confirmation. The form cannot override on-site judgment for safety-adjacent components.

3. The output is an internal working document. It feeds the proposal but is never shared directly with the client.

Standing Rules · Proposal Prompt Library

1. Every AI-generated proposal is reviewed by the account manager before submission.

2. Pricing, contract terms, and technical specifications are always entered manually. The AI handles tone and structure only.

3. If the client has prior relationship history, that context is added manually before the prompt runs.

4
Pillar Four
Systematic Evaluation
Test ScenarioExpected BehaviorActual ResultStatus
Diagnostic form on building with 3 flagged componentsFlags all 3, no missed itemsAll 3 flagged correctly, priority order accuratePASS
Form used by colleague unfamiliar with original checklistCompleted without guidanceCompleted in 31 min, 1 clarification on machine room sectionPASS
Proposal prompt on new client type not in examplesMaintain tone, adjust contextTone held, but opening led with product specs · caught in review, constraint addedFLAGGED → FIXED
Proposal prompt on client with prior service historyNeutral draft, manager adds context manuallyCorrectly produced neutral draft; context added manuallyPASS
Route planning with AI on 5-visit dayOptimized by traffic and geographyReduced estimated drive time by 34 minutesPASS
Human Judgment Boundary

The proposal prompt test revealed one failure mode: without an explicit instruction to lead with client risk, Claude defaulted to product feature language · exactly what the manager's style avoided. One constraint added to the system prompt fixed it. That catch happened in testing, not in front of a client.

5
Pillar Five
Visual Proof & Business Impact
77%
Reduction in diagnostic survey time per visit
93min
Time saved per site visit across all 5 account managers
0
Proposal revisions required after prompt library v4
4
Peers trained and adopted with no mandate
34min
Avg. drive time saved per day via AI route planning
Self-init.
Both systems designed and deployed without assignment
Scale Hypothesis

At 5 account managers saving 93 minutes per site visit and an average of 3 visits per day, the diagnostic form alone frees roughly 23 hours of field time per week. Applied to a regional team of 20 account managers, that represents over 90 hours of recovered selling time per week · without adding headcount.