Chuan Mao

Designed and operated large-scale product data platforms supporting messaging, engagement, experimentation, analytics, and AI initiatives. Built scalable batch and streaming data pipelines using Python, PySpark, Spark SQL, SQL, and distributed processing frameworks.

Architected enterprise marketing analytics platforms using GCP, Snowflake, dbt, Cloud Storage, Cloud Composer, and Terraform. Designed cloud-native data ingestion solutions integrating advertising APIs including Meta, Google, Amazon, LinkedIn, Microsoft, and TikTok.

Built revenue management and forecasting data platforms using AWS cloud services including S3, EC2, and RDS. Developed Python, SQL, and PL/SQL pipelines supporting pricing optimization, forecasting, inventory analytics, and business reporting.

Developed data transformation processes using Oracle, Python, SQL, PL/SQL, and scheduled batch workflows. Built forecasting, pricing, and inventory optimization datasets from multiple operational sources.

Analyzed business requirements and translated operational needs into scalable data models and reporting solutions. Created ER diagrams, SQL analysis workflows, data validation processes, and database documentation.

Master of Science in Information Systems and Technology Management from The George Washington University.

Bachelor's degree in Management Information Systems from Renmin University of China.

AWS Certified Cloud Practitioner certification from Amazon Web Services.

CIO University Certificate from The George Washington University.