DOOR (ex Latch) — Enterprise Integrations & Production Automation
Context: DOOR operates a smart-access platform that connects software, hardware, property systems, and external integration partners.
Contribution: I define and test API/SDK requirements, inspect authentication, payloads, webhooks, and field mappings, and work directly with partners and internal Product and Engineering teams through implementation and ongoing issue resolution.
- Supported 10+ external partners and the onboarding of 200+ properties.
- Resolved approximately 700 duplicate accounts affecting 350 users in one hour by combining Snowflake analysis with a Python script and internal APIs.
- Built a Python/API mapping workflow used across 300+ properties, replacing a manual process that took 15–30 minutes per property.
- Built reusable Snowflake reporting for integration status, data quality, and recurring issue investigation.