Zichen Fan
Data analyst
Technical Skills: Python, SQL, R, Tableau, Power BI, MATLAB, TensorFlow, Neural Networks, PySpark
Education
-
M.S., Data Analystics Engineering Northeastern University (December 2023) -
B.S., Economics Washington State University (July 2021)
Work Experience
Business Analyst @ Dialysis-X (Feb 2024 – present)
- Sourced and performed statistical analysis on industry data using MS Excel. Developed comprehensive Tableau dashboards based on the analysis that uncovered trends and breakthrough insights in the dialysis industry.
- Performed quantitative value analysis with Python to determine how the startup’s product would benefit its customers. This report is central to an ongoing campaign getting letters of commitment from target customers.
Data Analyst @ The Roux Institute at Northeastern University (July 2022 – Dec 2022)
Facilitated data analysis, visualization, and data pipeline solutions for startup companies.
- Gathered and cleaned text data, and conducted a Python-based Text Mining project on a 1,000+ page PDF, extracting CPT codes and descriptions, resulting in a 30% reduction in medical practices’ workload.
- Designed and implemented ETL solutions for a civic engagement platform, performing SQL queries to establish data collection, storage, and processing infrastructure for rapid retrieval of user data, increasing users by 50% in two months.
Product Data Analyst @ Hubei BECK Pharmaceutical Co., (July 2013 – Dec 2018)
Oversee and analyze the inventory data for the pharmacy supply chain, manage cost, and crossfunctional work with the IT team to optimize the CRM system
- Conducted in-depth inventory data analysis and implemented a budget system, achieving a 6% cost reduction within three months.
- Performed SQL queries to establish data collection, storage, and processing infrastructure, analyzed historical sales and purchasing data, and proposed a data-driven marketing strategy, resulting in an 8% sales increase in three months.