Rifki Rosada | Personal Product

Spectre Insight

Personal product. Upload a spreadsheet, get a generated management brief using LLM parsing.

Solo Founder & Engineer Ongoing — early access live Public product build
  • Problem

    Operators and managers regularly receive raw spreadsheet exports (sales, ops, inventory, performance) that take hours to manually parse into something a leadership team can act on.

  • My scope

    Built the upload and parse pipeline on Next.js with Prisma over SQLite for fast solo iteration.

  • Result

    Live at spectre.asia. Built end-to-end as a solo project.

Problem

Operators and managers regularly receive raw spreadsheet exports (sales, ops, inventory, performance) that take hours to manually parse into something a leadership team can act on.

Constraints

  • Output briefs must remain accurate and avoid LLM hallucination on numerical data
  • Upload flow must handle messy real-world spreadsheets (mixed schemas, inconsistent headers, partial data)
  • Hosting and inference cost has to stay viable at low usage volume during early access

System workflow

  • Built the upload and parse pipeline on Next.js with Prisma over SQLite for fast solo iteration.
  • Designed the LLM prompting layer to ground briefs in actual data instead of free-form summarization.
  • Deployed end-to-end on a VPS with predictable cost and no per-call infrastructure overhead beyond the LLM API.
  • Shipped early access at spectre.asia for direct user feedback before opening it more widely.

Result

  • Live at spectre.asia, available for early access.
  • Validated the upload-to-brief flow end-to-end with real spreadsheets.
  • Set up the base for future work on multi-tenant access, billing, and custom brief templates.

Tech stack

  • Next.js
  • Prisma
  • SQLite
  • OpenAI
  • VPS Deployment

Related delivery proof across internal tools, automation, Android + AI, and supporting product systems.

Client Systems

Client delivery

Enterprise CRM - Sales Pipeline & Performance System

Lead Full-Stack Engineer6-week delivery sprint

Cut the weekly pipeline review cycle from ~2 days of spreadsheet reconciliation to ~15 minutes — single source of truth across sales, ops, and management.

  • Laravel
  • Next.js
  • PostgreSQL
Read the case study

Automation Systems

Client delivery

Inbound Order & Lead Ops Automation

Automation Engineer2-week delivery sprint

Eliminated an estimated 60–80 hours/month of manual data entry across multi-branch operations. Booking + reporting now flow automatically into a single source of truth.

  • n8n
  • Google Apps Script
  • Google Sheets
Read the case study

Platform Delivery

Client delivery

Multi-Surface Platform Monorepo

Monorepo Platform Engineer4-week delivery sprint

Reduced release friction and dependency drift across the platform.

  • npm workspaces
  • Next.js
  • NestJS
Read the case study

Have a similar workflow?

Share what your team needs to improve. I can help define the first useful milestone.