Penglin Chen
Burnaby,BC
Summary
Dynamic and detail-oriented Data Analyst with a strong mathematical foundation from the University of British Columbia. Skilled in data analysis, SQL, and Excel, with a proven ability to drive business decisions and optimize processes. Adept at creating actionable insights through advanced visualization tools like Power BI and Tableau. Demonstrates excellent problem-solving abilities and thrives in fast-paced, data-driven environments.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst
Amber Financial
01.2022 - Current
- Integrated data using SQL to improve efficiency and reduce costs; utilized advanced Excel formulas and pivot tables to enhance advertisement budget allocation
- Developed 12 detailed trend analyses in Power BI, driving a 15% market share increase and generating $3.5 million in additional revenue
- Led a transformative marketing initiative, reducing traditional print ad spend by 80% and significantly increasing investments in digital channels
Data Analyst Intern
Aeon Insurance
03.2021 - 06.2022
- Processed and analyzed historical insurance cancellation data using Python, enabling management to allocate $5 million in response to emerging market risks
- Built regression models with Sklearn to predict insurance cancellations, achieving an accuracy rate above 85%
- Delivered actionable insights to the management team, mitigating risks associated with negative market events
- Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
Education
Bachelor of Science - Mathematics
University of British Columbia
Vancouver, BC04-2021
Skills
Technical Skills
Data Analysis Tools: Python, SQL, R, Sklearn
Visualization Tools: Power BI, Tableau
Software Proficiency: Microsoft Office Suite (Excel, Word, PowerPoint), PowerShell
Machine Learning: Regression Analysis, Data Modeling, Forecasting
Cloud Platforms: Azure, Google Cloud
- Data analysis
Languages
Certification
- Microsoft Certified: Data Analyst Associate
- Google Data Analytics Professional Certificate
Software
Timeline
Data Analyst
Amber Financial
01.2022 - Current
Data Analyst Intern
Aeon Insurance
03.2021 - 06.2022
- Microsoft Certified: Data Analyst Associate
- Google Data Analytics Professional Certificate
Bachelor of Science - Mathematics
University of British Columbia
Similar Profiles
Ruo Yu LiangRuo Yu Liang
Compliance Coordinator at Amber Financial Services Corp.Compliance Coordinator at Amber Financial Services Corp.
Troy ZhaoTroy Zhao
Mortgage Manager at Amber Financial Services Corp.Mortgage Manager at Amber Financial Services Corp.
Patricia SeedatPatricia Seedat
Finance Clerk at Amber Financial TechnologiesFinance Clerk at Amber Financial Technologies