Hailin Cai

Develop and enhance production backend services and REST APIs for NBA Stats data products using C#/.NET, Python, SQL, and Databricks. Built Python-based automated testing and validation workflows for 113 API endpoints to improve release confidence during a .NET 10 upgrade. Modernized production workloads from SAP HANA to Databricks with data-consistency validation and resolution of differences between legacy and replacement implementations. Optimized SQL and Databricks logic with ~30% query-performance improvements while preserving correctness, and implemented API validation plus data-access enhancements for reliability and runtime performance.

Architected scalable AWS workflows supporting millions of events during peak operations using Python, Kinesis, Lambda, EventBridge, Step Functions, Redshift, and S3. Built event-driven, multi-step processing flows coordinating distributed services and Python Lambda functions. Designed integrations to consolidate payment, customer, and client-provided feeds into centralized Redshift platforms. Led technical design and code reviews for microservices, data pipelines, and cloud infrastructure to improve scalability, reliability, observability, and maintainability. Developed a Spark- and EKS-based reporting platform delivering hundreds of custom reports and sync feeds. Designed a high-performance PII synchronization system using database triggers, Kinesis Streams, and stored procedures; used production metrics/logs to identify bottlenecks and improve performance by 50%. Used Docker, EKS, and Terraform for deployments and mentored engineers on architecture, debugging, testing, and production

Co-designed high-traffic backend platforms and APIs for the NFL, NBA, NHL, MLS, and UFC, scaling reliably during live events. Built a high-concurrency caching architecture using Redis, Memcached, and Elasticsearch to improve performance by 50% and reduce latency under heavy traffic. Established a real-time sports statistics platform reconciling multiple upstream data sources and delivering reliable live information to downstream applications. Developed production systems in Java and Node.js, integrated OAuth 2.0 and OIDC, and resolved complex distributed-system defects. Led development of customizable content-management and recommendation-system capabilities, improving content targeting and user engagement by 30%.