Jamie Wu Email & Phone Number

San Francisco, California, United States

• Developed and maintained scalable big data pipelines using PySpark/Python and AWS services (S3, Athena, EMR/EC2, Glue, SQS/SNS, etc.), processing millions of rows of health data efficiently and accurately• Built structured and unstructured data models via RDS (Redshift, Aurora), NoSQL DB, and Elastic Search; Refined schema and performed query tuning for fast and efficient access by data applications• Designed and implemented scalable and maintainable data pipelines; Optimized and improved performance by conducting Spark, cluster, and database tuning• Automated and monitored jobs through Airflow, reducing manual workload by 30% weekly and ensuring timely data delivery• Proficient in writing SQL across several dialects to operate in relational databases (MySQL, PostgreSQL, SQL Server) for data governance and database management

Scottsdale, Arizona, United States

*** Previously National Education Partners ***• Designed and constructed large scale enterprise data solutions by leveraging AWS technologies and infrastructure• Hands-on development experience on migrating data from on-premise data warehouses to AWS cloud platform• Designed data flows to load data from different sources and formats into S3 data lake; Built ETL pipelines and implemented data engineering within Glue using Python to ensure data quality and integrity before moving data into Redshift enterprise data warehouse• Deployed and maintained primary data pipelines and cloud architectures to ensure clean and accessible data are available for downstream analytics tools

Scottsdale, Arizona

• Utilized SQL, custom scripts, and stored procedures to gather and assess data from databases, operational data stores, and external systems to assist university leadership in decision making• Developed and built SSRS reports, designed ad-hoc reports, gathered requirements, analyzed data to support clients’ operation reports based on their business requirements• Utilized data visualization tools to designed and built dashboards with interactive views, trends, and drill-downs that provide clear visualizations of various university-specific KPIs and the performance in real time; Sprinted in sourcing, processing, managing data, and distributing business-driven and actionable visual reports

Master'S Degree, Business Analytics

Bachelor'S Degree, Management Information Systems, General

Activities and Societies: