Shuchang Liu
Marietta,GA
Summary
Results-driven data analyst with experience at Oriental Harbor Investment Management, where I automated data workflows and delivered actionable insights through Tableau. Proficient in SQL and Python, I excel in machine learning analytics and visualization, enhancing decision-making processes and supporting strategic initiatives. Strong analytical skills combined with effective communication.
Overview
1
1
year of professional experience
Work History
Business Analytics Intern
Oriental Harbor Investment Management Co., Ltd.
05.2025 - 08.2025
· Built performance dashboards consolidating monthly data from 10+ renewable energy companies, standardizing portfolio-level reporting.
· Automated trend tracking and data pipeline workflows using Python and SQL, improving data refresh speed and reporting consistency.
· Delivered visual performance insights to stakeholders through Tableau, enhancing data transparency and enabling faster investment decisions.
· Analyzed multi-sector financial data to identify key trends and variances, supporting risk assessment and strategic planning.
Data Analyst Intern
Citic Prudential Life Insurance Co.
05.2024 - 07.2024
· Developed a churn prediction model using SQL and Python on 50K+ policyholder records, supporting customer retention strategy.
· Designed and analyzed A/B testing for incentive programs; evaluated lift in renewal rates and optimized targeting strategy.
Education
Master of Science - Predictive Analytics & Risk Managemeny
University of Illinois Urbana-Champaign, Champaign
Illinois 12-2025
Bachelor of Science - Economics in Insurance
Shandong University of Finance And Economics
Jinan, China 07-2023
Skills
- Programming & Tools: SQL, Python, R, Excel, Tableau, PowerPoint
- Machine learning analytics: A/B Testing, Logistic Regression, Random Forest, XGBoost, KNN, Window Functions, ETL, Time Series Analysis
- Data analysis and visualization
Timeline
Business Analytics Intern
Oriental Harbor Investment Management Co., Ltd.
05.2025 - 08.2025
Data Analyst Intern
Citic Prudential Life Insurance Co.
05.2024 - 07.2024
Master of Science - Predictive Analytics & Risk Managemeny
University of Illinois Urbana-Champaign, Champaign
Bachelor of Science - Economics in Insurance
Shandong University of Finance And Economics