YUZE YANG

YUZE YANG

NA · Frontier Airlines

Irvine, CA

Work Experience

Data Analyst Intern

Frontier Airlines

2021 – 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 Digital

2018 – 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 Weapons

2018 – 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

Labdoo

2017 – 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 California

2023

BSc

Indiana University

2018

Skills

DatabaseGamingUser InterfaceProtocols and StandardsBig DataInternetData MiningInformation TechnologyProgrammingMachine Learning