delcy

Automated Order Management Workflow (Make.com, JotForm, Airtable, Gmail): Built an end-to-end order processing system linking ingestion (JotForm) to the database (Airtable) and communication (Gmail). Implemented inventory control logic to compare order quantities against available stock, automatically triggering 'Low Stock' alerts to admins. Configured conditional email routing to send personalized welcome, confirmation, and status updates based on customer opt-in settings. Enhanced data integrity by building logic to search, compare, and update existing customer records rather than creating duplicates. Developed advanced scenarios for Payment Reminders and a Loyalty Program to track and reward repeat customers. Idea Prioritization Pipeline (Zapier, Gmail, Airtable): Developed a conditional routing system using Zapier Paths to parse incoming email subjects and content. Mapped data to specific Airtable tables based on keywords, effectively sorting inputs into appropriate departmental queues. Implemented spreadsheet formulas to automatically flag and archive outdated entries ('Cold Storage') to maintain database hygiene. Reporting & Dashboards: Designed Airtable Interfaces to provide admins with real-time status updates. Automated the generation and delivery of daily revenue reports via email. Personal Productivity Systems: Created a Notion dashboard utilizing relational databases and validation formulas for goal tracking. Built multi-step Zaps with delay filters to automate timed reminders and task notifications.

Managed the Director's complex calendar, coordinating 10+ internal and external meetings weekly across different time zones. Drafted and refined external correspondence, donor reports, and operational memos, ensuring clear and professional communication. Maintained and organized digital client/donor records and training materials using Google Drive and Notion, enhancing accessibility by 20%. Provided end-to-end administrative support for monthly online workshops and training programs for over 50 participants. Served as the primary liaison for partners and volunteers, handling inquiries and managing follow-ups to streamline collaborative projects. Conducted light research on grant opportunities and industry trends, assisting the operations team with strategic planning.