Visitor #:

How I made my Cloud Resume Project Link (December 2022)

Victor Hsiao

Data Analyst with a background in business analytics and programming

[ linkedin ] . [ github ] . [ victorhsiao98@mail.com] . [(323)-599-7029]

SKILLS

Data Analysis, Database Management, Machine Learning, Data Visualization, something something

Programming: Python, SQL, Command Line, java

Python Packages: Jupyter, Pandas, Numpy, Matplotlib, Scikit-learn

Tools: Microsoft Excel, Jupyter Notebook, Domo, Tableau, AWS Cloud Services

EXPERIENCE

Business Data Analyst | Hammitt Inc, Los Angeles, CA (Jun 2022 - Present)

• Developed weekly reporting for managers and cross-functional groups to help form the design of products and roadmap discussions.
• Built and maintained several critical ETLs used to generate data tables used across the organization
• Performed data deep dives into areas of business and drew data insights to drive business decisions.
• Owned various company KPIs, providing detailed reporting and dashboarding to monitor and investigate anomalies.
• Independently worked on ambiguous data problems, from high-level analysis, design, and code implementations.

Service Desk Specialist | Parking and Transportation in LMU, Los Angeles, CA (Sep 2019 - Mar 2020)

• Utilized computing software within parking and transportation department to streamline customer data
• Handled a high volume of inbound calls of users with PC / Server / Printer / Network problems
• Identified customer concerns or issues and resolved them, or escalated to the next level of support when necessary
• Maintained support documentation, policies, processes, and methods of support delivery

EDUCATION

Loyola Marymount University | Los Angeles, CA (Expected May 2023)

Bachelor of Science, Information Systems & Business Analytics

• Courses: Database Management Systems (ISBA 3710), Developing Business Applications using SQL (ISBA 4715), Machine Learning (CMSI 5350), Introduction to Big Data (ISBA 4755), Network & Cloud Computing (ISBA 4798)

EXTRACURRICULARS

• Animal Action Fund-raiser Executive | High School Soccer Captain | LMU Cryptocurrency Club | LMU ISBA/AIMS Society | LMU Hantao Club | LMU Kasa Club | Model United Nations Admin

PROJECTS

Los Angeles County’s Coffee Market Research| Personal Project Project Link (May 2022)

• Scraped relevant data of all coffee shops within Los Angeles County, using Yelps API and loading into AWS database.
• Cleaned, transformed and analyzed the resulting dataset using Python and SQL to generate key insights.

Tahoe Fuzzy Factory Business Analytics| Personal Project Project Link (April 2022)

• Conducted A/B split test to optimize conversion funnel, focusing on user conversion and web traffic.
• Identified bottlenecks in the conversion funnel, presenting findings and actionable remediations.S