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.
• 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.

Master'S Degree, Business Analytics

Bachelor'S Degree, Management Information Systems, General

Activities and Societies: