MP LogoMatt Pickett

Technical Skills

A comprehensive overview of my technical expertise and capabilities

Next.js

Building high-performance React apps with the App Router, server components, SSR/SSG, and API routes (v14–15+).

React

Crafting dynamic, component-driven UIs with hooks, context, and advanced state management patterns.

TypeScript

Enforcing type safety across front- and back-end codebases for more maintainable, self-documenting code.

Node.js & Deno

Creating scalable server-side applications and serverless functions using Express (Node.js) and Deno 2.

API Design & Integration

Designing RESTful/GraphQL endpoints and integrating third-party services (Google Maps, Stripe, QuickBooks, Twilio, etc.).

Databases & Caching

Modeling & optimizing schemas in MySQL and PostgreSQL; implementing fast data access with Redis.

Cloud Platforms

Deploying and operating services on Google Cloud (Cloud Run, Functions, Pub/Sub, Cloud Build, Cloud SQL) and AWS.

Real-Time Systems

Powering live features with Twilio Voice/SMS and PubNub for seamless messaging and VoIP workflows.

Data Fetching & State Management

Leveraging TanStack Query (React Query) and SWR for efficient client-side caching and background refetches.

UI/UX & Styling

Styling responsive interfaces with Tailwind CSS, shadcn/ui components, and adding polish via Framer Motion animations.

CI/CD & DevOps

Automating builds and deployments with Docker, Google Cloud Build, GitHub Actions, and containerized Cloud Run services.

Authentication & Security

Implementing JWT/session flows with jose and bcrypt, plus best practices for data encryption and SOC-2 readiness.

Data Visualization

Rendering interactive charts and dashboards using Chart.js and Recharts for clear, actionable insights.

Geospatial Mapping

Visualizing service areas and lead distributions with React Simple Maps and geospatial queries in PostgreSQL.

AI & Machine Learning

Building and tuning Vertex AI Agents, prompt engineering, and integrating ML-powered features into apps.

PHP

Building scalable, secure, and maintainable web applications using the Laravel framework.