SKILLS

Technical: SQL (CTE, Window function, Recursive Queries), Python, AWS, GCP, Power Query, Snowflake, Alteryx, DBT
Visualization Tools; Amazon Quicksight, Tableau, Power BI, Google Looker Studio
Certifications: SQL Advanced Hackerrank, Certified Scrum Product Owner, DataCamp Certified Data Analyst

PROFESSIONAL EXPERIENCE

Incoming Business Intelligence Engineer Intern

Design & automate ETL pipelines from different source systems using Python, SQL, Alteryx, and Snowflake
Data visualization & analytics via Power BI, Power App, and Snowflake for decision-making and control
Data migration using Alteryx and SnowSQL to support move to a cloud-based warehouse and Azure landing zone

Business Intelligence Engineer Intern

Designed an automated ETL pipeline using Python, Salesforce, and Power Query, reducing workload by 90%
Built a pricing deep learning web app with Streamlit, achieving 95% accuracy on TechSmith's pricing data and enabling a 2% price increase for Snagit & Camtasia while reducing customer churn
Collaborated with 3 senior Data Engineers to optimize index and 100 queries in SQL Server, reduce runtime by 70%
Collaborated with 5 BI analysts using Microsoft Data Studio, SQL, and Power BI to craft a PO quotes dashboard, fostering data-informed insights and strategic decision-making for stakeholders, including the Chief of Revenue

Business Intelligence & Analytics Intern

Provided actionable insights for Corning Inc.’s stakeholders, reducing waste by 13% through Lean Six Sigma
Analyzed datasets to identify 92 components from 26 suppliers across Europe-Asia, built five Power BI dashboards documenting supplier characteristics and warehouse locations for enhanced decision-making
Identified driver metrics and predicted inventory demand, facilitating Corning Inc.'s transition from air to sea freight and proposing warehouse locations to reduce logistic costs by $230M over the next 10 years

Data Analyst Intern

Analyzed stocks and proposed trading strategies to the C-Suite, resulting in a 9.3% portfolio increase
Utilized SQL Server and Power BI to construct two Sales Dashboards, boosting sales revenue by 12%
Developed & optimized SQL queries with index, hint, and SARGABLE queries, reduced runtime by 53%

Data Analyst Intern

Constructed a multivariate linear regression model for volumes across 40 banks, yielding $15B revenue
Collaborated with data engineers to devise a data model and data pipelines for the company’s data warehouse

British Airway end-to-end Analytics Project

Led a team of nine to discover 10 insights and 3 recommendations for BA to enhance customer experience
Engineered Python scripts to extract and clean 4000 reviews spanning ten years using Beautiful Soup and Requests
Collaborated with two data engineers to construct an automated ETL pipeline using Python, Crawler & Glue, orchestrating a daily triggered system with CloudWatch & Lambda functions for automatic data integration into S3
Performed EDA with Python, created a Star Schema, and developed 2 Streamlit apps and 3 Power BI dashboards
Cooperated with Data Scientists in feature engineering and identifying key customer experience factors
Utilized NLP to classify London Staff Problems into 3 categories, achieving a 95% accuracy score on testing data

Uber BI engineering project

Integrated Uber data into BigQuery via Python ETL pipeline with GCP Storage, Mage compute engine, and Mage.ai
Developed a STAR data model and interactive Looker dashboard in BigQuery for recommendations and insights

Founder - The Coconut Academy Nonprofit Start-Up

Led teams of Ivy-League students, designers, and engineers to develop an online college advising company, assisted 20 Vietnamese students to pursue education in the United States while generating $10000 in revenue