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, DNUs, and MAUs.• 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% success rate and witnessing a 10X increase within the initial four-month period.• 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 type, age group, and device. This enabled thorough monitoring and analysis for actionable insights.

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. This innovation empowers advertisers to track performance data on an hourly basis, adapt bids and budgets, and enhance operational efficiency.• 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 continuously enhancing and crafting website components with Angular, HTML, and TypeScript. Additionally, contributed to the creation of an Enterprise dashboard through Power BI.

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 analysis and prospective pilot studies.• 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 motion data to effectively addressed the research inquiries and implement pilot studies.• 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 Python and SQL for data extraction and transformation, in conjunction with analytical tools like Tableau to support stakeholders' data analysis needs.• 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. in the Los Angeles region.

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 to 350,000 rows.• 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 retention ratios for business development and market expansion.• 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 location data and contributing to integrated market success.• 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 product features.

Canonsburg, Pennsylvania, Us

Mumbai, Maharashtra, In

Guangzhou, Gng, Cn

Neuilly Sur Seine, Ile De France, Fr