← back to Goodquestion Ai

src/data/projects.ts

195 lines

export interface Project {
  slug: string;
  name: string;
  url: string;
  tagline: string;
  description: string;
  challenge: string;
  solutions: string[];
  techStack: string[];
  screenshot: string;
}

export const projects: Project[] = [
  {
    slug: 'handcrafted-gift-storefront',
    name: 'Handcrafted Gift Storefront',
    url: '',
    tagline: 'A boutique e-commerce store for handcrafted paper art, greeting cards, and seasonal gifts.',
    description: 'A boutique gift brand selling intricate handcrafted paper art and greeting cards. Their e-commerce presence needed to match the tactile, artisanal magic of the product itself.',
    challenge: 'Selling handcrafted 3D paper art online requires conveying depth and dimension that flat product photos can\'t capture. Seasonal demand spikes around gifting holidays were overwhelming inventory management, and the generic theme didn\'t reflect the brand\'s vibrant, artisanal identity.',
    solutions: [
      'Customized the storefront theme to enhance the visual appeal of the designs with immersive product galleries',
      'Optimized site performance for faster browsing and mobile responsiveness across all devices',
      'Integrated apps for smooth inventory management and order processing to handle seasonal surges',
    ],
    techStack: ['Commerce Platform', 'Liquid', 'JavaScript', 'CSS3', 'App Integrations'],
    screenshot: '/images/projects/project-01.png',
  },
  {
    slug: 'custom-framing-storefront',
    name: 'Custom Framing Storefront',
    url: '',
    tagline: 'A home-decor storefront for curated art, mirrors, and custom online photo framing.',
    description: 'A home-decor brand bringing gallery-quality art and custom framing online. The platform needed to handle complex product personalization while keeping the shopping experience effortless.',
    challenge: 'Custom framing requires non-standard product configuration — customers need to select frame styles, mat colors, and dimensions, creating a multi-step checkout flow that most themes can\'t handle. Mobile users were abandoning carts due to poor responsive design on the configuration screens.',
    solutions: [
      'Upgraded and optimized the storefront theme for a seamless shopping experience across all screen sizes',
      'Integrated apps for custom framing and product personalization with intuitive step-by-step flows',
      'Improved site navigation and responsive design for both desktop and mobile users',
    ],
    techStack: ['Commerce Platform', 'Liquid', 'JavaScript', 'Custom Apps', 'Responsive Design'],
    screenshot: '/images/projects/project-02.png',
  },
  {
    slug: 'specialty-catalog-storefront',
    name: 'Specialty Catalog Storefront',
    url: '',
    tagline: 'A trade-facing storefront for a specialty product line with a large, complex catalog.',
    description: 'A specialty commerce operation serving a trade audience. The platform needed to handle a large, complex catalog with deep categorization and high-fidelity imagery.',
    challenge: 'A catalog spanning a large number of SKUs across many material types. Products needed complex categorization, high-resolution image galleries to show texture detail, and a checkout flow that supports the trade-to-retail pipeline.',
    solutions: [
      'Customized the storefront theme to reflect premium branding and multi-line product presentation',
      'Integrated apps for complex product catalogs and high-resolution image galleries',
      'Optimized checkout process and mobile responsiveness for trade and retail customers',
    ],
    techStack: ['Commerce Platform', 'Liquid', 'JavaScript', 'Search', 'Custom Metafields'],
    screenshot: '/images/projects/project-03.png',
  },
  {
    slug: 'hobbyist-gear-storefront',
    name: 'Hobbyist Gear Storefront',
    url: '',
    tagline: 'A deep, technical catalog storefront for a specialist hobbyist community.',
    description: 'A specialist retailer serving a technical hobbyist community. The catalog is deep and technical — customers need to find exact parts that fit their specific builds.',
    challenge: 'Accessories and attachments have complex compatibility requirements — customers need to find specific parts that fit their exact model. Slow site performance was losing mobile shoppers, and the lack of smart filtering made product discovery frustrating in a high-SKU catalog.',
    solutions: [
      'Upgraded the storefront theme for measurably better performance and usability',
      'Integrated product filters, live search, and inventory management apps',
      'Enhanced navigation and mobile responsiveness for faster, friction-free shopping',
    ],
    techStack: ['Commerce Platform', 'Liquid', 'JavaScript', 'Search & Filter', 'Performance Optimization'],
    screenshot: '/images/projects/project-04.png',
  },
  {
    slug: 'apparel-storefront',
    name: 'Apparel Storefront',
    url: '',
    tagline: 'A contemporary apparel storefront for a niche fashion community.',
    description: "A niche apparel brand creating contemporary, stylish clothing for a specific community. The storefront needed to showcase design while clearly communicating the brand's standards.",
    challenge: 'A niche apparel market with specific audience expectations. The brand needed to showcase contemporary, stylish clothing while clearly communicating its standards. The original theme didn\'t highlight fabric quality or fit details — the two things this audience cares most about.',
    solutions: [
      'Customized the storefront theme to highlight quality craftsmanship and modern style',
      'Integrated apps for promotions, newsletter signup, and streamlined order management',
      'Optimized mobile experience and site speed for a smooth shopping journey',
    ],
    techStack: ['Commerce Platform', 'Liquid', 'JavaScript', 'Email Marketing', 'Mobile-First Design'],
    screenshot: '/images/projects/project-05.png',
  },
  {
    slug: 'govarbitrage',
    name: 'GovArbitrage',
    url: 'https://auctions.agentabrams.com',
    tagline: 'Surface underpriced government surplus and seized-asset auctions before the crowd finds them.',
    description: 'GovArbitrage aggregates public government auctions — surplus, seized, and foreclosure listings scattered across dozens of agency sites — into one searchable feed, then flags the lots most likely to be underpriced relative to market. It turns a fragmented, hard-to-monitor corner of the public market into a single opportunity dashboard.',
    challenge: 'Government auction data lives in dozens of inconsistent formats across agency portals, with no unified schema and no way to compare a lot against its real-world resale value. On top of that, the app needed a clean subscription flow with tiered access and a login that Just Works — without a heavyweight identity provider.',
    solutions: [
      'Built a normalized auction ingest pipeline that pulls listings from many sources into one consistent, searchable schema',
      'Added opportunity scoring that flags lots priced below comparable market value so users see the best deals first',
      'Shipped tiered subscription plans with a streamlined basic-auth login and a Stripe-backed checkout',
    ],
    techStack: ['Next.js', 'TypeScript', 'Node.js', 'PostgreSQL', 'Stripe', 'Cloudflare'],
    screenshot: '/images/projects/govarbitrage.png',
  },
  {
    slug: 'national-real-estate-explorer',
    name: 'National Real Estate Explorer',
    url: 'https://nationalrealestate.agentabrams.com',
    tagline: 'A free, nationwide market-data explorer built on open real-estate and parcel datasets.',
    description: 'A national real-estate data explorer that stitches together open government housing datasets — parcels, deeds, market indices, and a broker registry — into one fast, browsable interface. It lets anyone explore markets across the country without a paid data subscription.',
    challenge: 'The parcel table alone runs past five million rows, and county data schemas vary wildly. Naive queries against nested JSON fields caused multi-minute table scans and stalled the whole app; state and county naming conventions had to be reconciled before anything could be joined.',
    solutions: [
      'Engineered concurrent, non-blocking database indexes on a multi-million-row parcel table to kill slow JSON sequential scans',
      'Reconciled inconsistent county and state schemas into a unified, queryable national dataset',
      'Built a broker registry and market-index views that stay fast even under heavy concurrent load',
    ],
    techStack: ['Node.js', 'TypeScript', 'PostgreSQL', 'Open Data APIs', 'Data Pipelines'],
    screenshot: '/images/projects/national-real-estate-explorer.png',
  },
  {
    slug: 'client-growth-portals',
    name: 'Client Growth Portals',
    url: 'https://prestige.agentabrams.com',
    tagline: 'A consulting-portal system that spins up a full growth command center per client from a single intake.',
    description: 'A repeatable consulting engine that turns a short client intake into a complete, per-client growth portal — a private command center with competitor analysis, best-times-to-post data, social and ad signals, a content calendar, costed growth ideas, and even fresh website concepts. What used to be a bespoke engagement becomes a scaffold-and-ship template.',
    challenge: 'Every consulting client needs the same deliverables assembled from scratch — research, positioning, a site concept, a social plan — which is slow and hard to standardize. The system had to generate a genuinely useful, client-branded portal on day one, including honest analytics rather than vanity numbers.',
    solutions: [
      'Built an intake-to-portal scaffolder that generates a branded per-client command center from a single questionnaire',
      'Integrated competitor research, ad-signal detection, content calendars, and costed growth ideas with printable action briefs',
      'Shipped first-party, cookie-free analytics so clients see an honest view-to-conversion rate without a consent banner',
    ],
    techStack: ['Node.js', 'Express', 'PostgreSQL', 'AI Agents', 'Cloudflare'],
    screenshot: '/images/projects/client-growth-portals.png',
  },
  {
    slug: 'ai-wallpaper-storefront',
    name: 'AI Wallpaper Studio',
    url: '',
    tagline: 'An original AI-generated wallpaper collection with a full seamless-tile quality pipeline.',
    description: 'A storefront for original, AI-generated wallpaper designs — each pattern generated in-house, quality-gated for seamless tiling, recolored across colorways, and rendered at print resolution. It pairs a generative design pipeline with a real commerce catalog, so novel patterns can go from prompt to purchasable product.',
    challenge: 'AI image models happily produce beautiful patterns that do not actually tile — a visible seam ruins a wallpaper. Designs also needed automated color and composition checks, full-resolution print masters, and at-scale mural previews that stay crisp, all before anything could ship to customers.',
    solutions: [
      'Built a multi-lens seamless-tile scanner that measures edge and midpoint discontinuity and rejects patterns that would seam on a wall',
      'Automated palette, composition, and defect checks plus a regenerate-until-clean loop so only production-quality designs ship',
      'Generated full-resolution print masters and crisp at-scale mural previews with per-colorway recoloring',
    ],
    techStack: ['Node.js', 'Python', 'Generative AI', 'Computer Vision', 'PostgreSQL', 'Commerce Platform'],
    screenshot: '/images/projects/ai-wallpaper-storefront.png',
  },
  {
    slug: 'professional-directories',
    name: 'Professional Directories',
    url: 'https://barber.agentabrams.com',
    tagline: 'Compliance-first local directories for lawyers, medical practices, animal services, and more.',
    description: 'A family of large-scale local directory platforms — spanning legal, medical, pet-services, and neighborhood verticals — each built on public data, enriched with discovered websites and contact details, and wrapped in a monetization funnel (a site-upgrade SaaS upsell and lead-gen). One directory alone indexes tens of thousands of firms and professionals.',
    challenge: 'Building a directory that is both comprehensive and compliant means reconciling messy public records, crawling and verifying business websites at scale, and respecting suppression and contact rules — while keeping every listing searchable down to the individual professional.',
    solutions: [
      'Assembled directories from public records into searchable databases of tens of thousands of firms and licensed professionals',
      'Ran concurrent website-discovery and automated site-audit crawlers to enrich each listing with real contact data',
      'Wired a compliance gate (suppression list + contact-attempt audit log) that every outbound touch checks first',
    ],
    techStack: ['TypeScript', 'Node.js', 'PostgreSQL', 'Playwright', 'Local LLMs', 'Data Enrichment'],
    screenshot: '/images/projects/professional-directories.png',
  },
  {
    slug: 'ninety-two-ten-guide',
    name: 'The Unofficial 90210 Guide',
    url: 'https://90210.agentabrams.com',
    tagline: 'A full-stack fan guide to a classic TV series — every episode, cast, news, and mini-games.',
    description: 'A complete fan destination for a beloved TV series: 114 episodes with recaps, cast profiles, a rolling news feed, and a handful of playable mini-games, all wrapped in a modern liquid-gradient design. Built as a full-stack Next.js app and shipped end-to-end in a single session.',
    challenge: 'A fan guide only earns repeat visits if the content is deep and the experience feels current. That meant assembling a large episode and cast dataset, a live news feed, and interactive games — then designing something that reads as fresh rather than a dusty archive, and deploying the whole stack cleanly.',
    solutions: [
      'Built a full-stack app covering 100+ episode recaps, cast profiles, and a 700+ item news feed backed by a real database',
      'Added a set of playable mini-games and a modern liquid-gradient visual system for a living, not archival, feel',
      'Deployed the complete stack behind a CDN and verified it cross-browser in one build-to-live pass',
    ],
    techStack: ['Next.js', 'React', 'PostgreSQL', 'Node.js', 'Cloudflare'],
    screenshot: '/images/projects/ninety-two-ten-guide.png',
  },
  {
    slug: 'command-center',
    name: 'Ops Command Center',
    url: 'https://goodquestion.ai',
    tagline: 'A live command center that tracks every build, win, and gated action across a fleet of AI agents.',
    description: 'A custom operations dashboard that gives a single-operator studio air-traffic control over dozens of projects and autonomous agents at once — tracking shipped wins, surfacing gated actions that need human sign-off, and rendering a live view of which agent is working on what. It is the nerve center that makes running many parallel AI workstreams sane.',
    challenge: 'Running dozens of autonomous agents in parallel generates a flood of state: work in flight, actions awaiting approval, jobs that silently stall. Without one canonical surface, approvals get lost in limbo, stale items masquerade as active, and there is no honest picture of what actually shipped.',
    solutions: [
      'Built a same-origin approvals surface that regenerates the gated queue from disk and lets a human approve, reject, or revise in one place',
      'Unified fragmented state stores into a single canonical lifecycle so every item shows a truthful status chip',
      'Added a self-healing sweep that auto-closes orphaned approval limbo and a live view of which agent is working where',
    ],
    techStack: ['Node.js', 'Express', 'JavaScript', 'Real-Time Dashboards', 'AI Agents'],
    screenshot: '/images/projects/command-center.png',
  },
];