Allison Chen Email & Phone Number

Taiwan

台灣 臺北市

【 Data Analysis 】• Conducted data cleaning, transformation, and visualization using Power BI, Python, and SQL• Integrated over 10 data workflows with Power BI, built more than 10 semantic models, and created over 30 daily updated visual reports• Specialized in building Power BI semantic models and proficient in DAX【 ETL and Data Pipeline 】• Optimized the ETL pipeline for the company website, saving 35% of daily update time• Developed Cloud Function APIs using Flask to replace the original data workflow, increasing data integration efficiency by 50%, while linking data to BugQuery and CDP platforms for member tagging, facilitating data integration and eliminating manual tasks• Created automated workflows with Python, reducing the time required for daily manual tasks from at least 60 minutes to just 1 minute• Established Azure data pipelines• Maintained and updated over 150 data workflows daily using Power BI, Python, BigQuery, and Azure• Optimized the performance of Power BI semantic models, saving 15% of daily update time【 AI and Machine Learning 】• Developed machine learning models to segment 1.9 million members and predict their future contributions, optimizing marketing strategies based on the analysis results【 Project Management 】• Collaborated with the Industrial Technology Research Institute (ITRI) to develop new measurement systems for the company• Introduced and maintained the CDP customer data platform for the company, integrating over 5 million data records from online and offline sources• Transformed and optimized retail operations, identifying valuable data from raw data, which led to a 28% increase in sales for key products