Ryan Sun Email & Phone Number

California, United States

Los Angeles, California, US

Los Angeles, California, US

Global Security - Security Control VerificationGlobal Security - Data Protection

Los Angeles, California, US

• Data platform
• Big data ETL & tuning – Built highly efficient Apache Spark ETL jobs that handled data of daily incremental size of more than 800TB uncompressed; optimized under-performing tasks & reducing runtime from 3 hours+ to.
• System design – Architected & executed (full-stack) a self-service machine learning tool using FaaS (Function as a Service), ClickHouse, Kafka, Flink, and in-house visualization tools, among others, enabling.
• Stakeholder management – Interfaced with stakeholders to understand data need and partnered to develop metrics for livestreaming business; earned trust and improved team’s NPS from 20% to 60%.

China, China, CN

Data platform

Purchase, New York, US

• Data modeling – Architected and led the development of a Snowflake data warehouse, using data vault & dimensional modelling techniques and DBT; delivered product significantly more flexible (reduced new feature.
• Data pipelines – Built both schedule-triggered and event-driven batch data pipelines using Airflow, SSIS, and PowerShell with average uptime > 99% (SLA being 75%); established alerting mechanisms achieving incident.
• Streaming – Implemented a streaming analytics solution to understand legacy SQL Server usage, using extended events, C# (.NET Core), Kafka, and Flink, in order to make data-driven design optimizations for the above.
• Grow the team – Mentored new developers and authored department’s first-ever “labs” for hands-on practice, introducing “self-service” onboarding and reducing “time to readiness” from 1 week to 2 days; Presented.
• Project leadership – Identified opportunity to automate mentorship matching offered by ERGs and led a group of 18 developers to build the first-ever matchmaking platform company-wide; project is work in progress which.

Milwaukee, Wisconsin, US

**Recipient of Impact Award (2 students within the whole school)** - Utilized Spark on Databricks platform, ran FP-Growth algorithm to mine association rules and analyze halo products- Authored an object-oriented Python package of reusable building blocks, in order that the company can build upon this project in the future. The package was built with.

St. Louis, MO, US

Teaching assistant for CSE247 Data Structure and Algorithms

St. Louis, MO, US

Teaching Assistant for SQL and Database Management

St Louis, Missouri, US

• Worked closely with business partners and trained an XGBoost model for backorder prediction; addressed data leakage issue with special cross validation technique; presented actionable result to C-suite executive and.
• Working closely with IT, architected and provisioned the company’s first dedicated lab environment for data science, consisting of cloud-based database and auto-scaled compute resources, among others, achieving time.
• Launched a comprehensive documentation SharePoint site for efficient and scalable knowledge transfer; site was the first of its kind organization-wide and received near 500 views; this was beyond responsibilities.

San Jose, CA, US

• Executed data analysis with Python, SQL - Teradata, Hive, and Spark for shipping from Japan to the US and optimized delivery estimate accordingly; the project had impact over 4 million transactions every year and.
• Reviewed defect (bad buyer experience) performance of Greater China sellers with Tableau and SQL; ran regression analysis for forecast and proposed policy recommendations for regional lead’s consideration
• Automated routine processes (Business Intelligence reporting) on Linux, saving the team at least 5 hours per week
• Authored New Intern Guide that addresses pinch points for office newbies, which was later adopted by various teams; drafted detailed tech tutorial and received more than 10 stars on Company GitHub
• Earned reputation of the "go-to" person in office for SQL query optimization and debugging

Shanghai, SHA, CN

• Implemented company’s first automatic fraud prevention system by modeling past transactions; frauds detected were three times more than previous experience-based manual processing
• Introduced procedures that significantly increased ETL system efficiency by utilizing big memory advantage; shortened delivery time of data requests by at least 50% and made possible data analysis of TBs of weblog

Master Of Science - Ms, Business Analytics

Bachelor'S Degree, Actuarial Science

Exchange Student, Accounting

Visiting Student

Visiting Student