Business Analyst Data Analytics

Chun-Ho(Charlie) Chang

Irvine, CA 949-***-**** ********@***.*** linkedin.com/in/chun-ho-chang github.com/Charlie891107 MSBA student at UCI with robust expertise in data analytics, Excel, and Power BI. Experience includes data cleaning, visualization, and predictive modeling to drive strategic decisions and streamline processes. Proven ability to develop analytical models that uncover market insights and support data-driven recommendations. Passionate about utilizing analytics to explore digital market trends in the media and entertainment sectors. EDUCATION

M.S. in Business Analytics Aug 2025

University of California, Irvine, CA

B.S. in Economics June 2023

TamKang University, New Taipei City, Taiwan

WORK EXPERIENCE

Paciolan, Irvine, California Student Business Analyst Jan 2025 - June 2025

● Cleaned and standardized 1M+ transactional records from ticketing and donation systems to enable cross-platform performance analysis and reporting for digital sales channels

● Applied K-Means and DBSCAN clustering to segment users by engagement and purchase behavior, informing digital campaign strategy and content targeting on online platforms

● Developed a scalable Social Network Analysis model using Python and NetworkX to analyze over 100,000 nodes, identifying key influencers based on centrality metrics and enhancing predictive modeling accuracy by 30% Capital Securities Corp, Sheung Wan, Hong Kong Stock and Future Assistant Jan 2024 - July 2024

● Organized 10,000+ financial records using SQL by implementing a hierarchical grouping strategy that increased data access and processing speed by 6%, ensuring reliable data for financial modeling

● Labeled 3,000+ data entries with metadata tags to improve filtering and categorization efficiency by 12%, streamlining data visualization for reporting

● Applied investment portfolio analysis to evaluate 200+ opportunities, identifying 3 high-potential investments that led to a 5% increase in client portfolio returns through enhanced operational efficiency PROJECT EXPERIENCE

Yelp Recommendation Chatbot Irvine Jan 2025 - Mar 2025

● Analyzed 2M+ Yelp reviews using Python and NLP (tokenization, lemmatization, stopword removal) to improve chatbot response relevance by 8%

● Built a restaurant recommendation chatbot with TF-IDF and cosine similarity, boosting query match accuracy from 70% to 78% using OpenAI Embeddings + FAISS (RAG approach)

● Applied K-Means and contextual embeddings (Alltius) to cluster reviews by city, cuisine, and rating, enhancing filter precision and user satisfaction

Spotify Recommendation System Irvine Oct 2024 - Dec 2024

● Implemented cosine similarity to calculate the alignment between user profiles and album features, and applied K-means clustering to group similar songs for enhanced recommendations

● Designed a content-based filtering system to recommend Taylor Swift albums by leveraging audio features, user preference profiles, and applying mathematics for similarity scoring

● Generated distinct recommendations for test cases and proposed strategies to improve system accuracy and user satisfaction through advanced weighting methods and collaborative filtering integration Determinant Of Flight Satisfaction Project Irvine July 2024 - Sep 2024

● Extracted key determinants of customer satisfaction using MySQL from Kaggle datasets and cleaned data using Python to handle duplicates and missing values, ensuring high-quality data for subsequent analysis

● Applied linear regression to analyze the correlation coefficients of multiple factors, identifying five key drivers of customer satisfaction, provided more targeted and precise service improvements for consumers

● Employed Python libraries (Matplotlib, Pandas) and SPSS(Chart Builder) to generate comparative charts and tables, visually analyzing satisfaction levels across segments SKILLS

Programming Languages: Python (Matplotlib, Pandas, numpy) R SQL Software: SPSS (Regression model) Tableau Microsoft Office (Excel, PowerPoint, Word, Power BI Development) SAP (ERP tasks) Data Storytelling Snowflake

Analytical Skills: Data Analysis Statistical Software Quantitative Reasoning Market Research Problem-Solving CERTIFICATION

● Intermediate SQL & Python Datacamp, July 2024

● Excel: Excel 2019 Expert, Microsoft, March 2023

Contact this candidate