Osama H. Farhat

The city tracked certificates of insurance for 30,000+ residents in a Visual Basic and Access system nobody had documentation for. I reverse-engineered it, then rebuilt it: ten modules, thirty automated notification flows, full audit trails, cron-driven expiry alerting.

The hard part was not the rewrite. It was expiry state — a certificate flagged non-compliant by a race condition has legal consequences for a resident. I moved expiry from a calculated value to an explicit, locked state transition.

Vue.js · Strapi · PostgreSQL · Node.js · cron · AWS

Roughly 100 staff hours returned per month. Delivered on schedule. Still in production.

Started as one department's tool. Grew into HR, finance and accounting, IT, and academic modules — plus an LLM pipeline that reads and summarises news for an internal monitoring desk.

Tenant scoping is enforced in middleware rather than in queries, so cross-tenant leakage is impossible by design instead of impossible by discipline. RBAC sits on top; tenant-key indexing and connection pooling made the same decision pay for itself on performance.

.NET Core · SQL Server · React · React Native · SignalR

Manual workload down 55%. Reporting cycle from three days to four hours.

Task and calendar management built right-to-left from the first commit, not translated into it — Hijri alongside Gregorian, prayer times in the day view, and a voice-to-form pipeline that takes spoken Lebanese Arabic and fills the fields.

React Native · Expo · Redux · ASP.NET Core · PostgreSQL · SignalR · Whisper

Vector-tile mapping with zone-intersection logic and route optimisation, served from a self-hosted tile pipeline rather than a per-request commercial API.

MapLibre GL JS · PostGIS · Tegola · OSRM · GeoJSON

Trading dashboards rendering thousands of live data points without the interface falling behind the feed.

React · TypeScript · WebSockets

Two to four second load on the heaviest views.