LinkRail Analytics, Inc
Founder
- Built a URL shortening and visitor analytics platform with PHP, MariaDB, and Redis, featuring real-time visitor tracking, async event processing via AWS SQS, and team-based access control. Focused on security and privacy with cookie-less tracking.
- Designed an asynchronous analytics pipeline using AWS SQS workers to ingest tracking events, persist raw logs, and aggregate into summary tables for low-latency dashboard reads.
- Integrated an LLM-powered analytics pipeline that generates natural-language insights from visit and visitor data, using a scheduled background queue architecture with Redis-backed job processing, persistent JSON storage, and a tiered cache/DB read-through strategy for instant dashboard loads.
- Integrated CI/CD with GitHub Actions and AWS CodeBuild, S3 for object storage, and SES for transactional email with deliverability tracking via webhooks.
- Containerized the full development environment with Docker Compose (PHP-FPM, nginx, MariaDB, Redis, asset building, local AWS emulation for testing) and automated migrations with Phinx.