KA YU (CARRIE) YU
Brooklyn
Summary
Business intelligence professional with comprehensive experience in data analysis and reporting. Proven ability to drive business improvements through data-driven recommendations. Reliable team player with focus on collaboration and adaptability to changing needs. Skilled in SQL, data visualization, and problem-solving.
Overview
6
6
years of professional experience
Work History
Business Intelligence Engineer II
Amazon Web Services, Inc.
New York, NY
08.2021 - Current
- Architect foundational data models using SQL and Redshift, transforming millions of raw logs into high-integrity datasets for a centralized data lake.
- Automate end-to-end ETL workflows using Airflow (YAML) and internal frameworks; leverage Glue and S3 to manage metadata and ensure data discoverability.
- Design automated QuickSight dashboards for Revenue Forecasting and Forecast Accuracy (QC); automate variance and percentage-difference analysis to drive regional sales targets.
- Maintain a monitoring suite to track pipeline health and execution metrics, ensuring high reliability and SLA compliance for global business reporting.
- Refactor complex Python transformation logic into optimized SQL, significantly reducing compute overhead and improving pipeline latency.
- Partner with Economists and Applied Scientists to translate research needs into technical specs; build foundational datasets for behavioral modeling and predictive analytics.
Business Intelligence Engineer Intern
Amazon Web Services, Inc.
New York, NY
06.2020 - 08.2020
- Processed large-scale datasets using AWS EMR and Apache Kylin to build OLAP cubes, significantly reducing query latency and enabling faster data exploration for business analysts.
- Authored AWS CloudFormation templates to automate the provisioning of data environments, ensuring consistent, repeatable infrastructure deployment and reducing manual setup time.
Help desk Technician
Metropolitan College, Boston University
Boston, MA
01.2020 - 05.2021
- Managed hardware and software systems for campus-wide technology resources, resolving high-volume technical escalations via a ticketing system to ensure maximum system uptime.
- Troubleshot complex network and application issues, maintaining a high resolution rate and providing technical support to a diverse user base of students and faculty.
Education
Master of Science - Applied Data Analytics
Metropolitan College, Boston University
Boston, MA05.2021
Bachelor of Technology - Computer Systems - Concentration in Database
New York City College of Technology, CUNY
Brooklyn, NY06.2019
Skills
- SQL
- QuickSight
- Airflow
- Python
- YAML
- S3
- Redshift
- Glue
- AWS EMR
- ETL frameworks
- Apache Kylin
- Salesforce
Timeline
Business Intelligence Engineer II
Amazon Web Services, Inc.
08.2021 - Current
Business Intelligence Engineer Intern
Amazon Web Services, Inc.
06.2020 - 08.2020
Help desk Technician
Metropolitan College, Boston University
01.2020 - 05.2021
Master of Science - Applied Data Analytics
Metropolitan College, Boston University
Bachelor of Technology - Computer Systems - Concentration in Database
New York City College of Technology, CUNY