Jerson E.

Airtable, Make & Pipedream Expert | API Integrations | Full-Stack Apps

I build business applications, internal platforms, dashboards, automations, and API integrations that help teams reduce manual work, improve visibility, and make better business decisions. My core background is in Airtable, Make, Pipedream, and API integrations. I use these tools to automate workflows, connect systems, structure data, and build reporting solutions. I also build custom full-stack applications using Next.js, React, Supabase, PostgreSQL, Vercel, Git/GitHub, Claude Code, and ChatGPT Codex. What I enjoy most is taking a messy business process, understanding how it actually works, and turning it into a reliable system that people can use every day. 🏅 RECENT WORK & RESULTS • Built executive and departmental dashboards that provide real-time visibility into financial, project, resource, and operational performance. • Directly credited by leadership for helping contribute to the company’s most profitable month in over a year by providing better financial visibility and decision-support dashboards. • Led the migration from a legacy ERP system into a custom-built internal platform. • Consolidated multiple Airtable and manual workflows into a centralized business application. • Built and maintained REST API integrations between ERP data, Airtable, Make, Pipedream, CRM platforms, and other business systems. • Built custom internal applications and client-facing portals with authentication, role-based access, dashboards, workflows, and integrations. • Built Airtable reporting systems that transform raw API data into reliable metrics and dashboards. • Created automated document workflows, notifications, approval processes, data synchronization, and scheduled reporting. • Expanded from low-code/no-code automation into custom full-stack web applications using AI-assisted development. ⚙️ WHAT I CAN HELP YOU WITH • Airtable database design and optimization • Airtable automations and custom scripts • Make scenarios and advanced API integrations • Pipedream workflows and custom code steps • REST APIs, webhooks, OAuth2, JSON, and data transformation • Custom dashboards and management reporting • Full-stack internal tools and business applications • Client and employee portals • Next.js and React applications • Supabase databases, authentication, and role-based permissions • Legacy system and data migration • CRM integrations and workflow automation • HubSpot integrations, workflows, and reporting • Process automation and system consolidation • AI-assisted application development • Troubleshooting, testing, and ongoing maintenance 📊 BUSINESS SYSTEMS & CRM EXPERIENCE Airtable · HubSpot · Deltek Vantagepoint · Salesforce · Pipedrive · LACRM · JobNimbus · Softr · Jotform · WordPress · Google Workspace · Dialpad · Google Voice I’m comfortable working with both existing systems and custom applications. I can help determine whether a process is better solved through Airtable and automation or whether it has reached the point where a custom application is the better long-term solution. 🧠 HOW I WORK My approach is business-first rather than tool-first. I start by understanding the current workflow, users, data, pain points, and desired outcome. From there, I translate the requirement into a practical technical solution. Typical workflow: Discover → Plan → Build → Test → Demo → Feedback → Release → Improve I work closely with stakeholders and can take a request that starts as a business problem rather than a detailed technical specification. I also prioritize: • Data accuracy and validation • Production safety • Clear documentation • Maintainable workflows and applications • Proper testing before deployment • Fast feedback and iteration • Clear communication around blockers, risks, and priorities 👤 PRODUCT & PROJECT BACKGROUND My background also includes Product Ownership and Scrum. As a Product Owner, I worked with stakeholders to define product goals, prioritize backlogs, write user stories and acceptance criteria, and plan releases. As a Scrum Master, I facilitated planning, reviews, and retrospectives, removed blockers, tracked progress, and supported continuous improvement. This helps me bridge the gap between business stakeholders and technical implementation—not just build what is requested, but understand why it is needed and how it should support the business. 🧰 CORE STACK Airtable · Make · Pipedream · REST APIs · Webhooks · OAuth2 · JSON · HubSpot 💻 FULL-STACK & PLATFORM Next.js · React · Supabase · PostgreSQL · Vercel · Git/GitHub · Claude Code · ChatGPT Codex If you need someone who can work across Airtable and automation today while also helping you move toward custom business applications when needed, that is where I can provide the most value.