Multi-Tenant Platform + iOS App. Built End-to-End for USA Client in 5 Months.
A USA-based client was drowning in Excel. Commissions calculated wrong, financial data exposed to everyone, no way to track team performance, and sales reps losing data in areas with poor connectivity. I built the full solution from scratch: a multi-tenant SaaS platform with role-based access, real-time financial tracking, offline sales reporting, CSV import/export, and a companion iOS app published on the Apple App Store. Delivered in 5 months, solo, and running in production without issues.
Solo Product Engineer, full ownership from architecture to App Store submission
5 months covering platform, iOS app, security hardening, and ongoing maintenance
USA-based business (confidential, link pending client approval)
Live in production with iOS app active on the App Store
This wasn't just an Excel replacement. The client had a growing sales operation with multiple companies, managers, and field reps with zero infrastructure to support it. Every problem was costing them money.
Built three distinct user roles with completely different views and permissions. Admins manage companies, users, and financial settings. Managers see their team's performance, individual rep stats, and company-level reports. Sales reps only see their own data and can log sales from anywhere. No role can access what it shouldn't. This is enforced at the database level with PostgreSQL Row Level Security.
Field sales reps often work in areas with poor or no internet. I built offline-first functionality into the iOS app so reps can log sales without a connection. The moment they're back online, the app automatically syncs all pending records to the server. No data lost, no manual re-entry. This was a game-changer for the client's field team.
Managers now have real visibility. Individual rep performance, team totals, company-wide financial summaries, and period comparisons all in real time. Reports can be exported as CSV for accounting and compliance. The client went from zero visibility to full operational intelligence.
Admins and accounting teams can bulk import historical data and export any report as a CSV file. This eliminated hours of manual data entry during migration and gives the finance team the flexibility to work with data in their own tools when needed.
The original Excel setup had critical exposure risks. Financial data was shared over email with no access control. I fixed this by enforcing RLS at every database query, securing the account claiming flow, patching data leakage points found during security audits, and ensuring each company's data is completely invisible to other tenants.
The initial database design had performance bottlenecks under real load. I redesigned the query architecture, added proper indexing, optimized the financial calculation tables, and introduced database views for reporting queries. Response times dropped significantly and the system now handles concurrent users without degradation.
┌─────────────────────────────────────────────────────────────┐
│ Frontend Layer │
│ ┌─────────────────┐ ┌─────────────────┐ ┌─────────────────┐ │
│ │ Admin Panel │ │ Accounting UI │ │ Sales Portal │ │
│ │ (React/Next) │ │ (React/Next) │ │ (React/Next) │ │
│ └─────────────────┘ └─────────────────┘ └─────────────────┘ │
└─────────────────────────────────────────────────────────────┘
│
┌─────────────────┐
│ Supabase │
│ Edge API │
└─────────────────┘
│
┌──────────────────────┼──────────────────────┐
│ │ │
┌─────────────────┐ ┌─────────────────┐ ┌─────────────────┐
│ PostgreSQL │ │ Row Level │ │ Real-time │
│ Database │ │ Security │ │ Subscriptions │
│ (Multi-tenant)│ │ (RLS) │ │ (Live Updates)│
└─────────────────┘ └─────────────────┘ └─────────────────┘
The system implements a sophisticated multi-tenant database design with proper data isolation:
Admin, Manager, and Sales Rep roles with scoped permissions enforced at the database level
Sales reps log sales without internet. App syncs all records automatically when back online
Individual rep stats, manager team views, and company-wide financial summaries in real time
Bulk data operations for admins and accounting teams, no manual entry required
Multiple companies on one platform with complete data isolation between each tenant
Commission, holdback, and payout engines with zero manual intervention
Critical vulnerabilities patched, RLS policies tightened, account claiming secured
Redesigned query structure, added indexing, and optimized reporting views for speed
Every financial transaction logged with full audit trail, exportable for compliance
React Native and Expo app submitted, reviewed, and approved by Apple
Users verify identity and claim pre-created accounts during onboarding
Live updates across all dashboards with instant calculation results
Every spreadsheet workflow moved to the platform. No more manual formulas, version conflicts, or emailed files
Offline sales reporting means reps in low-connectivity areas never lose a sale record again
Team performance, individual rep stats, and company financials visible in one dashboard
Critical data leakage risks eliminated. Each role sees only what it's authorized to see
Monthly reconciliation that took hours now runs automatically in real time
Automated commission and payout engines replaced error-prone manual spreadsheet math
CSV import and export cut migration time and give the finance team flexibility with their data
Database architecture overhaul reduced load times significantly under real concurrent usage
"Appreciate you, keep doing good work." — USA-based SaaS Founder
I specialize in replacing complex Excel workflows with production-ready web applications. Let's discuss how I can build or enhance your business-critical software.