YUZE YANG
NA · Frontier Airlines
Irvine, CAWork Experience
Data Analyst Intern
Frontier Airlines2021 – 2021
● Finished the automation of canceled flight tracker feature using python for PRM team within a week ● Designed and drafted relational database system for future migration from MS to Azure that approved by PRM and IT team ● Helped treasury team with data mining and extraction on historical booking with 100% accuracy using MS SQL ● Transformed raw datasets into neat regional comparison table for better data visualization which improves workflow
Data Analyst IT Support
Skyline Digital2018 – 2020
● Performed rigorous analyses on complex customer datasets, providing strategic insights for target marketing and campaigns ● Managed real-time leads to maximize the traffic for direct marketing and measured campaign success by analyzing KPI metrics ● Implemented drop shipping strategy to reduce cost and increase shipping speed by 40%, processing half million records monthly ● Set up and configured local server, network, 15 PCs, phones and warehouse machines with 100% functionality in a week ● Optimized server and LAN in 2 offices with 50% faster internal data transfer speed while maintaining an error free database
Full Stack and Business Analyst
Track Weapons2018 – 2018
● Conduct ad-hoc analysis, and make recommendation to the management to improve performance ● Developed data pipelines and visualization dashboards for enhanced real-time planning, forecasting, and data-driven execution ● Automated manual process of inventory tracking and workflow management to improve operational efficiency ● Constructed back-end database and enhanced data warehouse using MySQL to increase employee productivity ● Polished and redesigned front-end web and UI using WIX, HTML, PHP, CSS, increasing web traffic by 5%
Tech Consultant Global NGO Program
Labdoo2017 – 2017
● Led a team of 5 technicians to solve technical IT problems and fine-tune education programs for schools ● Diagnosed & repaired 30+ computer hardware and recovered 20+ operating systems within two months ● Trained volunteers to conduct system diagnosis and designed technical manuals for hardware preparation
PROJECT & INTERESTS ● Vehicle Advisor Project: Working on a project called CarGenius which allows users to find ideal car models within seconds. There is no similar app or software like this so far. ● VR Game: Designed a dart game from scratch with a delicate user interface; learned how to utilize VR in business and how VR can shape the future business model.
Education
masters
University of Southern California2023
BSc
Indiana University2018