Case Study: AMARIS
Automated Org Chart Builder
High-Level Impact
Reduced manual org-chart creation time from 2 months to under 7 days and improved data-update cadence to near real time.
Project Metadata
- CategoryCloud Architecture / Automation
- ClientAMARIS
Core Components
React UI Front-end
Google Cloud Storage (Raw Images)
Cloud Run Service 'DocProc'
Custom Document AI Processor
BigQuery Dataset 'org_charts'
Cloud Run Service 'EnrichProc'
Lusha API Integration
Looker Studio Live Dashboard
Business Objectives
Accelerate go-to-market for org-chart deliverables
Ensure data freshness with continuous updates
Enrich basic hierarchies with complete contact metadata
Achieve 95%+ data extraction accuracy
Automate end-to-end processing within a 7-day sprint
Securely manage sensitive personal data
Solution Design
"Enable AMARIS consultant managers to ingest static team-structure images for third-party clients, enrich personnel records, and maintain a live, exportable organization chart. This addressed the critical gap where only static pictures of client team structures were available, lacking automated capture of roles, contact details, and bios."
1. User uploads org-chart image via UI to GCS. 2. 'DocProc' fetches image and calls Custom Document AI to extract raw hierarchy. 3. raw data is written to BigQuery. 4. 'EnrichProc' retrieves new rows and queries Lusha API for enrichment. 5. Looker Studio renders the live, hierarchical chart.