Initiating EDC Insurance Records Migration · Phase 1 · Easy Dental Care · Nassau, Bahamas
Project Charter Summary
Insurance Records
Digitisation & Migration
Dental practice · 2021 · Hybrid methodology (Waterfall + iterative validation)
Scope
Phase 1: Insurance & billing records only. Patient health records deferred to Phase 2.
Timeline
roughly 3 months in-person, alongside front-desk duties
Project Lead & Authority
Front Desk & Records Coordinator · Budget authority: Practice Owner · Scope agreed verbally
Constraints
Vendor-locked EHR (Henry Schein); no new software or hardware; Bahamian data privacy compliance required
Trigger
Hurricane Dorian (2019) closed a secondary office. Hidden post-storm plumbing damage in an adjacent unit surfaced ~2 years later. The files were safe, but the near-miss made the risk undeniable. Project proposed proactively before any data was lost.
Success Criteria
Records in Google Workspace; insurers accept digital; staff pass usability test independently
Tools
Google Workspace · Henry Schein EHR · Todoist · Notion
From the project lead

This started as a near-miss, not a directive.

After Dorian in 2019 we lost one office entirely. What stayed hidden was damage to the neighbouring unit's plumbing. The inspector never flagged it because the vulnerability wasn't on our side of the building. When it surfaced the following summer, the physical files were safe. But the shock was real.

I suggested the transition while that feeling was still fresh. First because the government's digitisation schemes had just opened up, and also because five cabinets of records dating back to 2008 are one bad day away from being gone.

The charter was informal. I'm applying the structured framing now, after completing my Google PM cert. But the thinking was there at the time.

— G. Camacho-Reid
All figures and names in [brackets] are illustrative placeholders. Real data is confidential.
WCAG AAData PrivacyPlain LanguagePM Case Study · 1 of 9
Initiating Stakeholder Analysis & RACI
Stakeholder Map
Practice Owner
Budget authority & final approval · [Name redacted]
AccountableInformed
Records Coordinator (me)
System designer, digitiser, trainer
ResponsibleConsulted
Office Colleague
Implementation support; ongoing scanning
ResponsibleConsulted
Dental Providers (~6 providers)
Form validation only; clinical time priority
Consulted
Insurance Companies
Accept digital submissions; set compliance format
ConsultedInformed
EHR Vendor (Henry Schein)
Server infrastructure; no modifications possible
Informed
Key tensions
Providers vs. Admin: Providers felt answering questions about form completion was outside their clinical duties. Low engagement, hard to schedule — became the main execution blocker.
Time vs. Scope: One coordinator, three months in-person, alongside front-desk duties. Scope had to stay tight or nothing would get done well.
What I was actually navigating

The providers were the hardest stakeholder to manage. Their time was clinical. Patients in chairs, instruments, schedules. Asking them to review how they'd been filling out forms felt like an administrative inconvenience with nothing to do with their actual work.

Direct correction requests didn't land. So I changed the approach. Instead of asking them to fix mistakes, I asked them to help me design a blank template showing what a correctly completed form looked like. One-time ask, and then my colleague and I could handle the corrections ourselves using the template as a guide.

It was a small reframe. But it got us what we needed without making anyone feel like they were being audited.

— G
All figures in brackets are placeholders.
WCAG AAData PrivacyPlain LanguageStakeholders · 2 of 9
Planning Work Breakdown Structure
WBS · Phase 1
1.0 EDC Insurance Records Migration
1.1 Initiation & Scoping
1.1.1 Audit physical filing cabinets (5–10 filing cabinets)
1.1.2 Define Phase 1 scope — insurance records first
1.1.3 Confirm stakeholder roles with owner
1.1.4 Document Phase 2 requirements (health records)
1.2 System Design
1.2.1 Design Google Drive folder hierarchy
1.2.2 Define naming conventions (patient ID standard)
1.2.3 Set file metadata & access control standards
1.2.4 Confirm Bahamian data privacy compliance
1.3 Digitisation & Migration
1.3.1 Scan insurance records ([~APPROX. VOLUME])
1.3.2 Validate completeness & accuracy per record
1.3.3 Flag incomplete / outdated forms
1.3.4 Apply blank-template validation for corrections
1.4 Compliance & Acceptance
1.4.1 Verify digital acceptance format per insurer
1.4.2 Handle fax-only insurer exception (→ CR-001)
1.4.3 Test upload & retrieval in EHR
1.5 Training & Handoff
1.5.1 Train office staff on Drive structure
1.5.2 Write SOPs for ongoing maintenance
1.5.3 Usability test with office manager & EA
1.5.4 Phase 2 brief written & handed to owner
1.6 Out of Scope / Deferred
Patient health records → Phase 2
Server infrastructure changes
Access DB integration (attempted; abandoned)
Effort estimate
In-person capacity: [Approx. X hrs/week × ~12 weeks]
Shared alongside front-desk duties · Project allocation: [Approx. XX% of working time]
How I actually planned this

I didn't use a formal WBS at the time. My actual tools were Todoist for task assignment and Notion for logging what happened and when.

What I did have was a clear instinct about sequencing: insurance records first, health records later. Insurance records were the highest-risk item for the practice. Delayed or incomplete digitisation could mean unpaid claims. That made them the obvious first priority.

The WBS here is a retrospective mapping of what I actually did onto a formal framework. The thinking was there. The documentation wasn't. That's one of the honest lessons I took from this project.

— G
Volumes and durations in brackets are illustrative placeholders.
WCAG AAData PrivacyPlain LanguageWBS · 3 of 9
Planning Risk Register
Risk Register · Phase 1
ID Risk Like. Impact Mitigation / Response Status
R-001 Time constraint — roughly 3 months in-person only, alongside existing duties High High Prioritise insurance records; formally defer Phase 2 to a separate brief ✓ Managed
R-002 Provider resistance — clinical time seen as higher priority than admin validation Medium Medium Reframed from correction requests to blank-template validation; delegated follow-up to office staff ✓ Resolved
R-003 Post-departure change management failure — new manager may revert to paper Medium High SOPs written; staff trained; usability test passed. No formal internal champion designated. ⚠ Materialised
R-004 Insurance company rejects digital submission format Low High Pre-check acceptance format per insurer; maintain fax line as fallback (→ CR-001) ✓ Managed
R-005 Data loss or misfiling during scanning and transfer Low V.High Retain physical originals until digital version is validated; double-check filing protocol ✓ No incident
R-006 MS Access integration fails due to vendor-locked server backend Medium Low Attempt; abandon if incompatible. Acceptable given it was outside Phase 1 core scope. ✗ Abandoned
The one that kept me up

R-003 is the one I wish I'd taken more seriously.

I knew I was leaving. I even have a note from that time about needing someone to own this after I left. But flagging a risk is not the same as managing it.

I wrote SOPs. I trained my colleague. The office manager passed the usability test. But I didn't get a formal commitment to designate an internal champion, and I didn't build enough pressure into the system to make the digital workflow obviously easier than paper.

A few months after I left, COVID was also complicating everything, and a less tech-comfortable manager went back to paper. I still get asked about it. The practice is partly family, so I stay in the loop.

— G
R-003 materialised post-project; included for transparency. All figures are placeholders.
WCAG AAData PrivacyPlain LanguageRisk Register · 4 of 9
Principles Accessibility & Compliance Framework · Built into Planning, not bolted on
Accessibility & Compliance Considerations
Patient Data & Privacy
Bahamian Data Protection Act compliance maintained throughout
HIPAA-equivalent handling for US insurer data (Cigna, BCBS, UHC)
EHR access locked behind role-based passwords (Henry Schein native controls)
Physical originals retained in full until each digital record was independently validated
No patient health data migrated in Phase 1 — descoped to reduce exposure risk
Document & Information Access
Folder hierarchy capped at 3 levels — reduces cognitive load for clinical staff
Naming conventions use patient identifier, not clinician shorthand or abbreviation
Blank-template forms tested for plain language clarity by front desk staff before rollout
File labels designed to be meaningful to staff with varying digital literacy
Drive structure walkthrough delivered in both visual and written SOP formats
Communication & Inclusion
No assumption of formal meeting availability — clinical schedules are non-negotiable
Async-first channels (Google Sheet, email, Todoist) accommodate varied work patterns
Fax-only insurer exception maintained — patient care continuity takes priority over workflow purity
Training delivered 1:1 rather than group session — accommodates different learning paces
Feedback loops built informally — staff could flag confusion without formal escalation
Why this belongs in Planning

Healthcare PM sits between administrative efficiency and patient dignity, and the two pull against each other constantly. Every system I design gets run against one question: who needs to use this under pressure, with minimal time, and possibly with a patient sitting right in front of them?

When I built the folder naming conventions, I was thinking about the locum clinician who'd never seen our system before. When I kept the fax line, I was thinking about the patient whose insurer would otherwise miss a payment. Accessibility isn't a compliance checkbox. It's what makes systems work for everyone, including the people who weren't in the room when you designed it.

— G
All figures in brackets are illustrative placeholders. Compliance details reflect general practice — not legally binding.
WCAG AAData PrivacyPlain LanguageAccessibility · 5 of 9
Executing Communications Plan
Comms Plan
Stakeholder Information need Channel Frequency Owner
Practice Owner Progress vs. scope; any budget or change issues; Phase 2 readiness Shared Google Sheet + in-person Weekly summary; ad hoc on issues Gabriel
Office Colleague Daily task priorities; filing standards; quality checks Todoist + end-of-day 1:1 Daily Gabriel
Dental Providers Template validation requests only; minimal impact on clinical time In-person (brief) + blank template As needed; batched Gabriel
Insurance Companies Format acceptance; any submission requirement changes Phone + email + fax (one insurer) As needed Gabriel
Incoming Manager Gap — identified post-project System overview; SOPs; where things are and why Written SOP + walkthrough One-time handoff Gabriel
Channel rationale
No formal meetings: The practice ran on patients, not stand-ups. Every channel was chosen to fit around the clinical rhythm rather than interrupt it.
Async-first: A shared Google Sheet the owner could check anytime was more useful than a weekly verbal update that required both of us to be free simultaneously.
Communication in practice

There were no formal meetings on this project. The practice didn't work that way. The pace was set by patient appointments, not project schedules.

Most of my communication happened in the margins: quick asks between patients, end-of-day check-ins with my colleague, phone calls with insurers at lunch. The shared Google Sheet meant the owner could check progress without needing to ask me directly.

This worked fine for execution, but it created a gap at handoff. The incoming manager row in that table was added in retrospect. I had planned a walkthrough. I just didn't build enough redundancy to make the system work without me being there to explain it.

— G
All figures in brackets are placeholders.
WCAG AAData PrivacyPlain LanguageComms Plan · 6 of 9
Executing Change Request Log
Change Request Log
CR-ID Description Raised by Impact Resolution Status
CR-001 Family Guardian requires fax-only submission — digital format not accepted under any condition Gabriel
(compliance check)
Medium Fax line maintained as exception. Fax workflow documented as separate SOP entry. Insurer flagged for Phase 2 renegotiation. ✓ Resolved
CR-002 Provider validation method changed: direct correction requests replaced with blank-template approach Gabriel
(process change)
Low Providers create one reference template each. Office staff handle all corrections independently using template as guide. Scope unchanged. ✓ Resolved
CR-003 Patient health data migration formally de-scoped from Phase 1; moved to Phase 2 Gabriel & Owner
(scope review)
High Agreed as correct prioritisation. Phase 2 requirements documented and handed to owner for future resourcing. ✓ Deferred
CR-004 MS Access integration attempted for records cross-reference; abandoned due to server constraints Gabriel
(technical)
Low Vendor-locked backend incompatible. Dropped without Phase 1 scope impact. Noted for future consideration if infrastructure changes. ✗ Abandoned
The fax one

CR-001 caught me off guard. By 2021 I'd assumed every insurer was digital. Most were. But Family Guardian is a major local Nassau carrier and their submission process was simply fax-only, full stop. The size of the practice had nothing to do with it. EDC is the largest single dental practice in the Bahamas and that still wasn't the conversation.

So we built around it. The fax line stayed, the workflow was documented as an SOP exception, my colleague knew the process, and I flagged it for Phase 2 renegotiation. That's a policy conversation that needs a longer runway than a digitisation sprint.

What I took from it: compliance checks belong at the start of planning, not mid-execution.

— G
All names and figures in brackets are placeholders.
WCAG AAData PrivacyPlain LanguageChange Requests · 7 of 9
Monitoring Progress & KPI Dashboard · [Week X of Y]
Progress Snapshot
Insurance Records Digitised
[XXXX]
of [YYYY] total identified
Progress bar is a placeholder — actual % redacted
Forms Flagged for Correction
[XX]
outstanding at Phase 1 close
Tracked via shared Google Sheet; reviewed weekly with colleague
Insurer Acceptance Confirmed
[X of Y]
major carriers accepting digital
1 fax-only exception — documented & managed via CR-001
Usability Check
✓ Passed
Office manager & EA located records independently
Primary success criterion — intentionally qualitative
Phase 2 Brief
✓ Written
Patient health records scope handed to owner
Resourcing decision not within Phase 1 scope
Weekly Throughput
[~XX]
records processed per week (est.)
Tracked informally via Notion log; not formally reported
Note on metrics: All figures above are illustrative placeholders. Real project tracking was primarily qualitative. The dashboard structure here shows how I would now approach monitoring a comparable project — not exactly what was formally tracked at the time.
How I actually measured progress

My primary KPI was qualitative, and I stand by it. I'd sit with the office manager or the EA and ask them to find a specific patient file. If they could do it without asking me, we were on track.

For quantitative tracking I used a Google Sheet. A running count of what was done versus what remained, reviewed weekly with my colleague. My Notion journal was the informal "what happened today" log.

I'd build something more structured now. The dashboard on the left is the framework I'd use on a comparable project. The placeholders are an honest acknowledgment that real figures are confidential. Structure matters more than the numbers anyway.

— G
All figures are explicit placeholders. Real metrics are confidential and were tracked informally.
WCAG AAData PrivacyPlain LanguageKPIs · 8 of 9
Closing Retrospective & Lessons Learned
Retrospective · Phase 1
What went well
Phase 1 scope delivered within the roughly 3 months timeline
Google Drive structure intuitive enough that staff passed usability check independently
Blank-template workaround reduced provider friction significantly
[X of Y] major insurers confirmed digital acceptance
Phase 2 brief completed and handed off as a clean separate document
No data loss incidents during scanning or transfer
What didn't work
Post-departure change management failed — paper files reinstated within months by new manager
MS Access integration attempted and abandoned; server constraints should have been scoped earlier
No formally assigned internal champion to own the system after departure
Comms plan too light at handoff — SOP alone wasn't sufficient
Progress tracking too informal; no structured log over time
What I'd do differently
Formal change management plan from week one — not just SOPs, but structured adoption support
Named internal champion with explicit training & ownership before leaving
Full compliance audit at start of planning, not mid-execution
Written project charter signed by owner from the start
Structured KPI tracking from day one, even if qualitative metrics stay primary
Phase 2 brief handed to a named next-owner — not just filed with the practice owner
Closing honestly

The project succeeded. Phase 1 was delivered, the system worked, and the office could find things. But the change didn't stick, and that's the gap I think about most.

There's a difference between delivering a project and making a change last. On-time and within scope isn't enough if the system reverts when you leave. Lasting change needs an owner, a plan, and enough friction removed that the new way is genuinely easier than the old way.

I didn't have the vocabulary for that at the time. I do now. And that's probably the most useful thing I took from completing my Google PM cert: being able to name exactly what happened and understand where it broke.

— G. Camacho-Reid
All figures are placeholders. This retrospective reflects my honest assessment — including what failed.
WCAG AAData PrivacyPlain LanguageRetrospective · 9 of 9