ChiaChun Lee

ChiaChun Lee

Sr. Data Analyst
United States of America

About Me

Sr. Data Analyst with experience in time-series analysis, forecasting, data visualization, and statistical modeling. Skilled in R, Python, SQL, Tableau, QuickSight, and machine learning techniques, with experience applyi…

Experience

Sr. Data Analyst

Energy Ogre
Aug 2023 - Present · 3 years 2 months

• Leveraged time-series analysis techniques in R, including ARIMA and Holt-Winters models, to forecast member growth and revenue. Achieved a 96% accuracy to aid financial planning for a budget exceeding $20 million.
• Automated data extraction using MSSQL and developed electricity usage forecasting models using regression methods in Python, significantly improving prediction accuracy by 28% compared to conventional methods.
• Created a Tableau dashboard to provide real-time status tracking of 200K+ members, enhancing operational visibility and facilitating informed decision-making.
• Crafted interactive QuickSight visualizations to segment members based on residency, membership duration, and contract expiry. Identified 4K+ members at high cancellation risk to enable proactive retention strategies.

Sr. Data Analyst

Energy Ogre, Houston, Texas
Aug 2023 - Nov 2023 · 3 months

<p>Leveraged time-series analysis techniques in R, including ARIMA and Holt-Winters models, to forecast member growth and revenue.<br>
Achieved a 96% accuracy to aid financial planning for a budget exceeding $20 million.<br>
Automated data extraction using MSSQL and developed electricity usage forecasting models using regression methods in Python, significantly improving prediction accuracy by 28% compared to conventional methods.<br>
Created a Tableau dashboard to provide real-time status tracking of 200K+ members, enhancing operational visibility and facilitating informed decision-making.<br>
Crafted interactive QuickSight visualizations to segment members based on residency, membership duration, and contract expiry.<br>
Identified 4K+ members at high cancellation risk to enable proactive retention strategies.</p>

Data Analyst

Energy Ogre, Houston, Texas
Jul 2022 - Jul 2023 · 1 year

<p>Conducted a multi-variate analysis on 5-year electricity usage data for 1.5M households, examining location, property specifics, and consumption patterns with Python/MSSQL, contributing to an 18% growth in customer acquisition.<br>
Analyzed over 15K+ cancellation surveys using Python/MSSQL to identify distinct churn drivers between new and established members.<br>
Developed tailored retention strategies, leading to an 8% increase in retention rate.<br>
Implemented various metrics including RMSE, MAE, and MAPE to assess the performance and robustness of electricity usage prediction models, ensuring high forecast accuracy and reliability for over 45K+ members.</p>

Product Compliance Analyst Intern

Micron Technology, Inc., Taichung, Taiwan
Jul 2021 - Aug 2021 · 1 month

<p>Streamlined data collection and analysis of 1300+ supplier surveys using SQLite, achieving over 90% completion rate.<br>
Saved 10 hours weekly in data processing time.<br>
Created data visualization dashboards to monitor business metrics of 2K+ suppliers using Tableau, enabling rapid monitoring and analysis of regulatory risks.<br>
Developed a random forest model in R for regulatory risk assessment, identifying key survey questions for risk mitigation based on feature importance.</p>

Skills

Code Writing Data Analysis and Reporting Data Analytics dplyr tidyverse lubridate ggplot2 Python pandas scikit-learn matplotlib SQL Tableau QuickSight Hypothesis testing Regression Time series analysis Classification Clustering Tree-based models AWS Certified Cloud Practitioner ARIMA Holt-Winters MSSQL SQLite Random forest K-means
Report this Profile?