Jason Chavez

Led the design of an AI-enabled customer-support integration connecting a Zendesk ticketing database to a Shopify order history API, reducing manual lookup time by ~35%. Built a retrieval-augmented support assistant using Python and embeddings to surface relevant order and policy data during live chat interactions. Audited a disconnected CRM, spreadsheet, and marketing-tool stack to create a phased integration roadmap prioritized by data access constraints and business risk. Automated marketing funnel reporting by syncing Klaviyo campaign data with HubSpot CRM records via an AWS Lambda ETL job. Diagnosed and fixed recurring webhook failures between Shopify and a fulfillment system by implementing retry logic that reduced dropped order events by ~40%. Reviewed junior contractors’ integration designs and established shared conventions for authentication and error handling. Implemented data validation checks to prevent duplicate contacts during CRM synchronization, and analyzed support

Developed a Python integration layer linking WooCommerce storefront orders to Salesforce CRM, eliminating manual order entry for the support team. Built REST API connectors between a customer database and a marketing automation platform to trigger email sequences based on purchase behavior. Migrated customer-support data from spreadsheets into a structured PostgreSQL schema for reliable querying and reporting. Implemented webhook listeners for real-time inventory updates between an e-commerce platform and a third-party warehouse management system. Resolved Zendesk-to-dashboard data syncing issues by identifying a timezone mismatch in timestamps. Automated weekly sales and funnel performance reporting, cutting manual spreadsheet compilation time from several hours to ~20 minutes. Integrated a chatbot prototype with a FAQ knowledge base for first-tier inquiries and collaborated with marketing on data requirements for a HubSpot lead-scoring workflow.

Built and maintained Python REST API endpoints for internal order-tracking tools used by customer service. Wrote unit and integration tests for a data-import pipeline pulling customer records from CSV into MySQL. Supported production debugging of API timeout errors affecting a third-party payment integration during peak traffic. Helped automate recurring data cleanup tasks that previously required manual spreadsheet corrections. Implemented basic authentication and role-based access controls for an internal admin dashboard handling customer data. Assisted migration of legacy customer-support records into a centralized database, improving retrieval consistency and reducing lookup errors by ~25%.