//assets.cakeresume.com/assets/contentarea/contentarea-2d64eca8dae2a1ffb31e0fb1df887bbad072c7c19734d7d30fa14884bbcc299a.css

IBT TOEFL - 84

I'm a data analyst who thrives on turning complex data into clear insights and smart strategies. With hands-on experience in boosting efficiency, creating snappy dashboards, and segmenting customers for targeted marketing, I'm all about making data work hard and smart.

Ready to dive in and make waves as your next data whiz.

National Central University

- Utilized SWOT Analysis to assess the project and develop the trip-arranging application, a combination of existing applications, such as Yelp, Uber, and Airbnb. Helped customers organize and adjust their trips to create a favorable experience

Temple University

Data Analyst

莊嘉穎 Zhuang Jia-Ying

Amnesty International Taiwan Section

Data Analyst Specialist

- Improved data ETL pipeline and Data Warehouse with four key stakeholders using Python, SQLite, and Excel, achieving a 90% increase in efficiency

- Develop 5 reporting dashboards using Power BI to monitor operational performance and reduce report creation time from 4 hours to 20 minutes per report

- Analyzed data from 90000 donors (22000 monthly active donors) and used output to guide marketing and donor engagement strategies

台灣台北市

- Organized the venue and meticulously processed orders, packaging over 100 bottles of wine for customer purchases

- Serviced over 40 customers with engaging hospitality, achieving a 2% conversion rate through effective communication and product knowledge

Buono 享味生活

Wine Sales

- Conducted comprehensive analysis of 15 million customer shopping records, utilizing RFM and LTV models for customer segmentation. Developed tailored marketing strategies for different customer groups, enhancing targeted marketing efforts

- Developed predictive models using Python, achieving an approximate 20% accuracy rate in predicting customer purchases

- Designed and analyzed online user surveys for the Carrefour e-commerce platform, focusing on website experience, advertising marketing, and recommendation systems. Proposed 3 distinct solutions to optimize the online user journey and enhance customer engagement

台灣

家樂福_家福股份有限公司

Business Competition - Data Analyst

- Managed the warehouse of firefighter Tools and Equipment to maintain the safety and availability of over 50 types of equipment

- Led a team of 10 assistants and collaborated with 3 instructors to streamline the equipment management process for over 100 students daily, enhancing efficiency by 30%

- Analyzed, collected, and documented over 5 types of class information to build the database for instructors to efficiently make plans for the course, which improved efficiency by 90%

台灣南投縣

Alternative Military Service - National Fire Agency, Ministry of the interior

Firefighter Assistant

Data Analyst Intern
October 2020 - November 2021 / Taiwan, New Taipei City

- Collaborated with 5 colleges from the operation and marketing team to figure out the needs of indicators and make the plan for the ETL pipeline of digital Ads data and the data dashboard building

- Received, cleaned, and prepped data (10K records per month) from Ads platforms API using Python, and SQL Server to help the marketing and operation team have automated real-time supervision 

- Built extensible and maintainable data dashboard for supervising digital Ads KPIs and manual reporting led to reducing 90% of the processing time
 

莊嘉穎 Zhuang Jia-Ying’s posts