Digital Transformation Intern
Joeys is a marketing and event-management consultation in New Cairo, and I was its only technical intern. On my interview day I created and verified its Google Business Profile, since it had no verified online presence. After that I built its production Next.js marketing site and an event-registration and QR check-in platform with an authenticated admin dashboard on my own, from requirements to deployment. I also built a B2B lead database, converted the scientific programme of the 10th Alexandria Retina Meeting into a reusable LATEX system, and staffed its check-in desk in person.
The marketing site's case-study section
What I worked on
Product and platform
- A 123-requirement source-of-truth workbook (UR-001 to UR-123) covering registration, check-in, administration, email, validation, privacy, and infrastructure, ahead of any implementation
- A pnpm/Turborepo monorepo with three workspaces: the public site, registration UI, API routes, and admin dashboard; the Prisma schema, migrations, and database client; and the Resend/React Email integration
- The PostgreSQL data model on Supabase, Supabase-authenticated admin dashboard, and idempotent QR generation and check-in flow
- Content Security Policy, Permissions Policy, reCAPTCHA, CSV-formula sanitisation, and the Vercel production deployment
Marketing, research, and growth operations
- The company's Google Business Profile, created and verified after finding it missing on my interview day
- Two evidence-based market research reports: a 40-page global Generation Z consumer-behaviour study and a 46-page Middle East toddler-formula caregiver-behaviour study
- A first-touch UTM and ad-click attribution layer feeding the admin export and owner notification email, alongside Google Ads, GA4, Meta Pixel, and LinkedIn Insight Tag integrations
Client and brand support
- WordPress edits and enhancements to a client website
Completed Work
Unified marketing site and event platform
A single Next.js deployment covering the public marketing site (homepage, five service pages, about, contact, a nine-role careers board, and three case studies) and the event-registration and admin system, sharing one database and deployment rather than running as separate applications.
- Built with
- Next.js 14, React 18, TypeScript, Tailwind CSS, Prisma, PostgreSQL, Supabase
- Contribution
- Designed and built the entire application solo, from requirements through deployment.
- Outcome
- 43 distinct routes served from one deployment, with 29 unit tests and the production build passing at the reviewed revision.
Event registration and QR check-in system
A registration flow (active event, validated form, optional reCAPTCHA, database record, QR image, attendee and owner emails) and a camera-based check-in scanner with an idempotent, conditional database update so a code can't be checked in twice.
- Built with
- Zod, Prisma, QR code generation, Resend, React Email
- Contribution
- Built the schema, the registration and check-in APIs, the scanning interface, and the admin dashboard's filtering, editing, and CSV export.
- Outcome
- 350 registrations (208 courses, 142 conference) and 212 check-ins at the 10th Alexandria Retina Meeting, with zero duplicate-scan corruption.
Market research and B2B lead generation
Two long-form, evidence-first market research reports and a structured B2B lead database covering organisation identity, decision-maker role, evidence freshness, and a scoring and confidence model across Egypt, Dubai, Saudi Arabia, and Europe.
- Built with
- LATEX, Excel, Python
- Contribution
- Authored both reports and built the lead database, country views, and an outreach-automation prototype with a manual send-preview workflow.
- Outcome
- Reusable research and growth assets. The outreach prototype shows the workflow works, but there is no reliable log of campaign results yet.
Technical Stack
Frontend and platform
Next.js, React, TypeScript, Tailwind CSS, Framer Motion
Backend and data
Prisma, PostgreSQL, Supabase, Zod, Node.js
Growth and research
Google Ads, GA4, Meta Pixel, LinkedIn Insight Tag, LATEX, Market research
Working style
End-to-end ownership, Requirements engineering, Technical documentation, Live event operations
Results
- Commits
- 61
- Codebase
- ~9,300 lines of TypeScript/TSX, 29 unit tests across 7 files
- AVRS 2026 registrations
- 350 (208 courses, 142 conference)
- AVRS 2026 check-ins
- 212, zero duplicate-scan corruption
- AVRS 2026 Google Ads campaign
- 150,000+ impressions, 4,000+ conversions
- B2B lead database
- 284 researched organisations, 289 outreach records
- Speaker files received
- 95 files from 50 speakers via AWS Lightsail
- Google Analytics active users and event counts rose more than 300 percent during the conference window compared with the prior period, driven in part by the AVRS Google Ads campaign.
Looking back
- The marketing site, the admin dashboard and the venue QR scanner each needed different priorities in the same codebase: identity and motion for marketing, error recovery for registration, and speed and one-handed use for the scanner. I tested the scanner in person at the AVRS registration desk.