Back to Timeline

Experience

Allyvia

Founding Software Engineer

Allyvia

Jul 2025 – Apr 2026

Overview

Cloud-native enterprise workflow, financial management, and CRM platform on Google Cloud, built with React 19, TypeScript, Material UI, Python, Django REST Framework, BigQuery, Pub/Sub, and Cloud Storage. Featuring incremental QuickBooks Online sync into BigQuery, event-driven ingestion, CRM pipeline management, employee shift tracking, multi-module reports and analytics, and a GenAI prototype assistant.

Responsibilities

Led the end-to-end full-stack development of the SaaS platform on GCP. Designed the frontend state management (Redux Toolkit, React Query) and scalable Django REST API endpoints. Built the BigQuery data pipelines for QuickBooks sync and analytics, the Pub/Sub and Cloud Storage event-driven ingestion layer, AI-enabled REST APIs for the GenAI prototype assistant, third-party OAuth integrations, and dynamic role-based access control (RBAC).

Challenges

  • Keeping QuickBooks Online accounting data consistent in the platform while staying within API rate limits and avoiding request timeouts.
  • Serving multi-module business intelligence metrics (utilization rates, conversion funnels, cash flows) fast, without heavy queries on every page load.
  • Securing sensitive customer credentials and managing automated token refresh cycles for QuickBooks and Google OAuth flows.
  • Ingesting uploaded documents and webhook events reliably without blocking the main HTTP request thread.
  • Designing a reliable, stateful clock-in/out console (Kiosk) to manage employee time tracking and shift durations securely.
  • Handling fuzzy search across large inventory, contact, and transaction tables efficiently.

Solutions

  • Built incremental-load pipelines that pull only QuickBooks changes since the last recorded sync, transform them in Python, and land them in BigQuery.
  • Pre-aggregated reporting metrics in BigQuery and cached results so the Finance, Inventory, CRM, Employee, and Overview pages load from ready aggregates.
  • Stored access and refresh tokens with symmetric database-level encryption, alongside automated background refresh checks.
  • Published upload and webhook events to Pub/Sub with files in Cloud Storage, processed asynchronously by background workers that also feed the GenAI prototype assistant.
  • Implemented a PIN-authorized Kiosk dashboard with session locking to manage employee shifts and clock-in/out time logs.
  • Used PostgreSQL TrigramSimilarity for fast fuzzy matching on names, SKUs, and descriptions.

Impact

  • Kept API response latency under 200ms, including every reports page, by serving analytics from BigQuery aggregates.
  • Synchronized 10 critical accounting entities (Invoices, Bills, Inventory Items, Payments, etc.) between Allyvia and QuickBooks Online, ensuring ledger consistency.
  • Moved document and webhook ingestion onto event-driven Pub/Sub workers, keeping the web tier responsive.
  • Shipped AI-enabled REST APIs powering an early GenAI prototype assistant.
  • Encrypted third-party OAuth tokens across all company profiles, preventing credential leakage.
  • Delivered RBAC route guarding, dynamic menu filtering, and UI action permissions based on subscription tiers and user roles.
  • Provisioned a secure physical kiosk station for zero-friction clock-in/out and automated shift durations.
  • Enabled full client pipeline management (leads, deals, and notes) linked to company documents and financial invoices.