HAOBIN LIU

Data Analyst at Chuwa America Corporation
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Durham, North Carolina, United States, US
Languages
  • Mandarin Native or bilingual proficiency
  • Cantonese Native or bilingual proficiency
  • English Professional working proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Introduction to Python
    DataCamp
    Sep, 2023
    - Nov, 2024
  • Manipulating Time Series Data with xts and zoo in R
    DataCamp
    Mar, 2023
    - Nov, 2024
  • Data Manipulation with data.table in R
    DataCamp
    Jan, 2023
    - Nov, 2024
  • Joining Data with data.table in R
    DataCamp
    Jan, 2023
    - Nov, 2024
  • Delivery Tips for Speaking in Public
    LinkedIn
    Jul, 2022
    - Nov, 2024
  • Intermediate R
    DataCamp
    Jun, 2022
    - Nov, 2024
  • Introduction to R
    DataCamp
    Jun, 2022
    - Nov, 2024
  • Investment Banking Market Mapping & Landscape Analysis Remote Internship
    Paragon One
    Sep, 2021
    - Nov, 2024

Experience

  • Chuwa America Corporation
    • United States
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Data Analyst
      • Jan 2022 - Present

      • Gather, prepare, and analyze large-scaled datasets in CSV, Excel, and MySQL table format. • Utilized SQL to clean, transform, join, and merge data to meet the business requirement, and process text data for sentiment analysis related to their service. • Defined, executed, and interpreted simple to intricate SQL queriers such as join, window functions, and subqueries, tailored to churn rate analysis and other specific business needs of AT&T. • Conducted data visualization using Tableau, working closely with AT&T marketing and product teams. • Visualized patterns in customer behavior using Tableau, emphasizing potential churn indicators. • Analyzed geographical data related to churn trends and visualized how different segments, interacted with AT&T's services and their correlation to churn. • Leveraged Python's Pandas library to delve into AT&T customer preferences and order data, utilizing aggregate functions. • Applied Python(pandasql) techniques to identify high-risk churn segments, enabling AT&T to roll out targeted retention campaigns. • Led SQL training sessions for junior analysts in the consulting team and provided support in post-training sessions. Show less

  • Nfluence Partners
    • United States
    • Investment Banking
    • 1 - 100 Employee
    • Investment Banking Extern
      • Jul 2021 - Sep 2021

      • Led construction of market maps across sectors, include sub-sectors and product categories, via Excel and PowerPoint, highlighting area of growth and potential risk to facilitate executive decision making. • Analyzed company metrics and available financial data from WRDS database with R for potential investors to help them evaluate investment opportunity, such as size, growth rate, revenue. • Identified 30 M&A candidate firms for further relationship building and due diligence. • Led construction of market maps across sectors, include sub-sectors and product categories, via Excel and PowerPoint, highlighting area of growth and potential risk to facilitate executive decision making. • Analyzed company metrics and available financial data from WRDS database with R for potential investors to help them evaluate investment opportunity, such as size, growth rate, revenue. • Identified 30 M&A candidate firms for further relationship building and due diligence.

  • Zhong Xun Investment Management
    • Shenzhen, Guangdong, China
    • Data Analyst Intern
      • Jun 2020 - Sep 2020

      • Performed financial analysis via R and SQL, evaluating online educational training and conference service providers. • Developed quantitative models using R to analyze risk exposure, including LGD (Loss Given Default), EAD (Exposure at Default), and PD (Probability of Default), assessing counterparty risk on portfolio and improving Value at Risk by 5%. • Provided data-driven recommendations to senior analysts for portfolio optimization and risk management. • Performed financial analysis via R and SQL, evaluating online educational training and conference service providers. • Developed quantitative models using R to analyze risk exposure, including LGD (Loss Given Default), EAD (Exposure at Default), and PD (Probability of Default), assessing counterparty risk on portfolio and improving Value at Risk by 5%. • Provided data-driven recommendations to senior analysts for portfolio optimization and risk management.

  • Ke Yuan Office Equipment Operating Company
    • Dongguan, Guangdong, China
    • Business Analyst Intern
      • Jul 2019 - Sep 2019

      • Analyze and optimized inventory turnover using R and SQL, reducing carrying costs by 20% and increasing cash flow by 15%. • Developed predictive models using quantitative techniques on WRDS database, improving accuracy of sales forecasting by 25% and reducing stockouts by 30%. • Conducted comprehensive financial analysis using WRDS data, identifying cost-saving opportunities that decreased operating expenses by 10%. • Analyze and optimized inventory turnover using R and SQL, reducing carrying costs by 20% and increasing cash flow by 15%. • Developed predictive models using quantitative techniques on WRDS database, improving accuracy of sales forecasting by 25% and reducing stockouts by 30%. • Conducted comprehensive financial analysis using WRDS data, identifying cost-saving opportunities that decreased operating expenses by 10%.

Education

  • Duke University - The Fuqua School of Business
    Master of Quantitative Management, Business Analytics Finance Track
    2022 - 2023
  • UC IRvine
    Bachelor of Arts, Business Economics
    2018 - 2021

Community

You need to have a working account to view this content. Click here to join now