Qiyang Liu

Experience

1. Senior Data Analyst

   Integrity

   Sep 2024 — Present · Dallas, TX, US

   Effectively facilitated data communication by translating requirements from departments, executives, and stakeholders into actionable data objectives. Participated in decision-making meetings to align data timelines with business goals. Extracted, cleaned, ingested, and stored data using SQL, Alteryx, Snowflake, and SQL Server. Ensured high data quality and maintained the integrity of the Snowflake database. Troubleshot ODBC connection issues and resolved ingestion errors. Leveraged cleaned data to develop Power BI dashboards tailored to departmental and stakeholder objectives or provided refined datasets for internal use. Automated workflows for raw data processing, Snowflake database management, and Power BI dashboards to enable real-time updates. Applied machine learning models for business insights: used k-Means Clustering and DBSCAN for customer segmentation and anomaly detection, SVM for customer classification and risk prediction, and Linear Regression for profit forecasting. Deployed models on Azure Cloud. Mentored Junior Data Analysts and conducted data integrity checks to identify and resolve anomalies.

Education

• Hohai University

  Bachelor's degree, International Economics and Trade

• Fudan University

  Master of Business Administration - MBA

• The University of Texas at Dallas

  Master of Science - MS, Business Analytics