← Back to portfolio

Enterprise production · Critical Mass

Content Sync Validator

An automated content-validation tool that compares staging vs. production content and surfaces discrepancies before release — replacing an error-prone manual process and restoring team confidence.

Executive summary

An enterprise team hit recurring production errors after content approval in an AEM multi-environment setup — content authored in staging frequently mismatched production, costing 25–30 hours per release and eroding launch confidence. I initiated and led an automated validation tool that compares staging vs. production content, surfaces discrepancies with their content paths, and was adopted into the formal QA workflow across three teams — reducing human errors by up to 80%.

My role

Initiated and led the project end to end: problem discovery, stakeholder research, solution design, implementation, and iteration with users. A shipped production tool integrated into the team's formal QA process — not a prototype.

Constraints

  • AEM multi-environment setup with no programmatic validation between staging and production
  • Manual, multi-step release workflow spanning Content, Release Management, and QA
  • High mean-time-to-detection — errors surfaced days after introduction
  • QA performed bi-weekly manual regression across 31 pages
  • Each error triggered a cascade of tickets, reviews, and re-deployments

The broken workflow

The process I inherited:

  • Content authors update content while manually documenting fragment paths in Jira
  • Release managers collect paths from multiple tickets for production publishing
  • QA performs word-by-word comparison to catch discrepancies
  • Missing paths trigger a multi-step resolution process with additional QA cycles

Architecture

Staging content  ┐
                 ├→ Deep comparison engine (page variation data)
Production content┘
        ↓
Visual diff table (staging vs. production discrepancies)
        ↓
Content-path extraction (for release management)
        ↓
Real-time validation + error reporting

The core is a deep comparison engine over AEM page-variation data, producing a visual diff table and extracting the exact content paths release managers need — eliminating manual field extraction from fragment paths.

Key technical decisions

Context: The biggest constraint was no automated way to compare staging vs. production.

Decision: An MVP focused on immediate visibility into content differences plus content paths for quick resolution — built in roughly 2 hours using GitHub Copilot.

Tradeoff: Deliberately minimal v1 to validate value fast, in exchange for features that arrived in later iterations.

Context: Authors and release managers still manually extracted fields from fragment paths.

Decision: v2 added a unique content-path extraction button, removing manual field extraction.

Tradeoff: More surface area, in exchange for eliminating a tedious, error-prone step.

Context: A new disclaimer-matrix validation need emerged, risking a from-scratch build.

Decision: v3 reused the existing comparison engine for Excel-upload disclaimer validation, reusing logic for efficiency.

Tradeoff: Slight coupling, in exchange for fast delivery and dramatically increased QA adoption.

Iteration with users

Through observation and partnership with users, the tool grew across three versions:

  • v1 (MVP): deep comparison, visual diff, content-path extraction, real-time validation
  • v2: path-extraction button for authors/release managers; in-tool diff highlighting for QA
  • v3: disclaimer-matrix validation via Excel upload, reusing the comparison engine

Reliability & quality

  • Real-time validation replacing days-lag detection
  • In-tool diff highlighting — no external comparison tools or context-switching
  • Error and unsupported-field reporting with content paths for fast resolution
  • Reused, proven comparison logic as the stable core across new features

Results

Measured before → after impact:

Production quality
3–5 errors per releaseZero errors
Up to 80% fewer errors
QA efficiency
30 hours overhead< 1 hour
96% faster
Disclaimer validation
2 hours manual15 minutes automated
87% faster
Error detection
2–3 days lagReal-time
Instant feedback

Qualitatively: restored team confidence, formal QA-process integration, a cultural shift from reactive firefighting to proactive validation, and cross-team adoption beyond the initial user group.

Leadership & recognition

🎤

Invited speaker

Presented the problem-solving methodology and tool-development process to

~200 members of the technology discipline

Invited to share insights and inspire similar innovation initiatives across the organization.

Methodologies applied

Design Thinking
Empathize, Define, Ideate, Prototype, Test
The Mom Test
Unbiased user research techniques
Systems Thinking
Understanding causal loops and feedback
Jobs-to-be-Done
Functional, emotional, social needs
RICE Scoring
Reach, Impact, Confidence, Effort
Root Cause Analysis
5 Whys to identify core problems
SCAMPER
Creative problem-solving for ideation
MVP Approach
Earliest Usable Lovable Product

Retrospective

  • Partnership drives adoption: working alongside users during implementation inspired formal integration.
  • Observation reveals hidden needs: watching actual usage uncovered impactful improvements.
  • Reusability accelerates development: leveraging existing code for new features maximized efficiency.
  • Small tools, big impact: a ~2-hour MVP solved a problem costing 25–30 hours per release.

Proof

QA Engineer

Confidence has increased for sure, now I can trust that what I did is all correct. Speed has increased at least by 70-80%. The Disclaimer comparison tool increased speed 60% — from 1-2 hours to 15-30 minutes. That's a huge difference. 80% reduction of errors in low volume releases.

Project Manager

Significant increase in productivity during QA phase. The tool has put us in a more favorable position when handing over value to the client. Testing phase is now more agile and reliable, allowing us to deliver earlier. Reduced bug tickets, less human error, less back and forth between teams.

Content Author

Increased confidence in logging paths — we now verify paths before logging them. The Diff Tool saves us 25 minutes on path verification. Enhanced release success — we can track missing paths in less than 5 minutes versus 30 minutes previously.

Tech Lead / Release Manager

Operation time saving especially for QAs. Delivered content quality improvement — teams can spot problems easily. Workflow simplification makes conversations easier. Future potential to integrate other disciplines' workflows.

Client Stakeholder

Increased speed to market and ability to respond to emergent business needs. Reduced liability on legal compliance. Increased throughput for more return on investment — we can work faster and get more done in the same amount of time with the same amount of people.

Plus: invited presentation to ~200 technology-discipline members, and adoption into the formal QA workflow across three teams.

Want to talk?

I'm open to senior product-engineering and technical-lead roles.

Get in touch