Full-Stack Software Engineer · Einstein11Plus
Prototype
Simulated event flow — the production engine wired Shopify webhooks to internal MySQL enrollment with variant → entity ID mapping, cutting manual ops ~80%.
Highlights
- Event-Driven Automation: Designed and implemented a server-side, webhook-driven booking and automation engine integrating Shopify events with internal MySQL systems to automate student enrollment across 4+ product workflows, successfully reducing manual operations by ~80%.
- State Management: Built scalable backend services using explicit state management, status flagging, and complex ID-mapping logic (external Shopify variants → internal database entities) to ensure 100% data accuracy across 20+ concurrent schedules.
- Frontend Performance: Developed integration-aware frontend components utilizing JavaScript MutationObservers to capture structured transactional metadata in real-time, reducing response times by ~30x (from 6s down to <200ms).
- Production Debugging: Refactored backend reporting pipelines and conducted deep-level production debugging across PHP, SQL joins, and session handling layers, eliminating duplicate data entry and improving reporting accuracy to ~100% reliability.
Technologies
- Shopify
- MySQL
- JavaScript
- PHP
- SQL