Siyu Wang Email & Phone Number

Santa Monica, California, US

• Designed and orchestrated the development and implementation of ETL pipelines utilizing Airflow, Python, SQL, and GCP, Spark, DBT, with a focus on monitoring and evaluating key growth metrics including DAUs, DRUs.
• Collaborate with data scientists and software engineers to conduct AB testing and introduce novel features, exemplified by the successful implementation of Google 1TL login on Snapchat, achieving a remarkable 94%.
• Developed comprehensive Looker and Mercury dashboards to conduct detailed analysis of login and registration funnels, including retention, conversion, and dropout rates, across various dimensions such as country, OS.

San Francisco, California, US

Spark, Pyspark, Python and SQL

Seattle, WA, US

• Identified and defined crucial advertising metrics for 177,000 advertisers across 14 marketplaces.
• Conducted comprehensive data validation, successfully identifying and resolving a global data issue impacting 900 million users and 700,000 brands.
• Designed and implemented ETL pipelines, leveraging internal tools and AWS services (Redshift, AWS Glue, S3, Datanet, Cradle) & architected a real-time monitoring solution for a significant marketing stream service..
• Produced a suite of executive-level reports using Amazon QuickSight, contributing to informed decision-making by VP-level stakeholders.

US

• Cooperated with 20 cross-functional teams to build microservices for Optum virtual care website. This involved collecting data from diverse sources, including Kafka, processing and transferring it into Snowflake, and.

US

• Collaborated with research teams to provide data and analytical support for a wide variety of healthcare research projects and experimental initiatives. Designed databases and crafted queries for both retrospective.
• Extensively worked on diverse health care data sources including Medicare, Commercial and Medicaid claims, EMR (Electronic medical record), and digital devices such as CGM(continuous blood glucose monitor) and Fitbit.
• Designed and implemented ETL pipelines to seamlessly integrate large datasets (~12 Billion records) from multiple data sources and database platforms such as Google Big Query, AWS and Microsoft SQL Server & Utilized.
• Utilized Python, SQL, and JavaScript to generate dynamic code for Quality Assurance (QA) and data validation, resulted in a significant enhancement of usability and efficiency, with up to a 70% improvement.

Torrance, CA, US

• Designed and deployed customized Microsoft Dynamics 365 Enterprise resource systems, serving the needs of local small-to-medium-sized enterprises and renowned global corporations, including MOC Products Company, Inc..

Fullerton, California, US

• Conducted data cleansing, transformation, and integration from diverse platforms (WeChat, Mixpanel, AWS) and data sources (China Unicom). Established a MySQL Database capable of handling datasets ranging from 200,000.
• Designed and implemented a Key Performance Indicator (KPI) dashboard to present daily data reports for internal usage. Performed data analytics, including Funnel Analysis and Cohort Analysis, to gain insights into.
• Created interactive data visualizations using PHP, JavaScript, SQL, and Google API to generate Heat Maps, Polygon Maps, and Marker Clustering Maps, providing a deeper understanding of consumer journeys related to.
• Extracted data from the MySQL database and applied Python for complex data analytics, resulting in powerful insights and the identification of significant business opportunities. These insights were used to enhance.

Canonsburg, Pennsylvania, US

Mumbai, Maharashtra, IN

Guangzhou, GNG, CN

Neuilly Sur Seine, Ile De France, FR