Keyu Chen
Yorba Linda
Summary
Insight-driven Business Analyst skilled in Python, R, SQL, and Tableau. Experienced in transforming data into clear business insights to support strategy, market research, and process optimization. Strong communicator with a passion for data-backed decision-making.
Overview
5
5
years of professional experience
Work History
Marketing Coordinator
LEDCONN Corporation
08.2025 - Current
- Answered general marketing department inquiries by email, phone, and mail.
- Developed visually engaging marketing materials by Adobe Illustrator and Photoshop to support product launches and promotions.
- Composed daily posts for social media and helped build corporate presence on Twitter, Facebook, and Instagram through Loomly, ActiveCampaign.
Business Analyst
ACEE International Education
09.2024 - 07.2025
- Analyzed global admission events, tracking conversion rates, student interest, and applications using SQL and Tableau, providing insights to support regional recruitment performance and data-driven decision-making.
- Developed a Python script to automate student data entry, saving 10+ hours per week, reducing errors, and improving data accuracy, allowing the admissions team to prioritize key tasks.
- Conducted spreadsheet and CRM analytics to evaluate acceptance rates, regional performance, and student engagement, creating automated reports in Tableau to visualize trends and inform recruitment strategies.
Market Research Analyst Intern
Small Business Development Center
01.2023 - 05.2024
- Extracted and analyzed industry trends, target customer data, and competitor insights for small business owners from various sources, including IBIS, Bizminer, Jungle Scout, and Esri.
- Utilized SQL and Excel for data analysis to derive insights on sales revenue and market share.
- Designed and visualized market research reports in Adobe to create accessible insights for consultants. Maintained close communication with consultants to understand their needs, ensuring reports supported strategic planning and effective client discussions.
- Evaluated the company's performance in attracting new business owners to our services by analyzing key marketing metrics, including ROI, impressions, and event and conference conversion rates— visualized findings using Tableau to support data-driven marketing strategies.
Product Analyst Intern
MCT Technology
06.2020 - 08.2021
- Helped improve the student development tracking app by assisting with UI design and organizing the analytics features, making reports easier for teachers to use.
- Collected feedback from teachers and worked with the team to make app improvements, using Excel to help identify areas that needed attention.
- Updated and maintained student and parent data across schools, ensuring everything was organized and accurate using CRM tools to support the app's functionality.
Education
Master of Science - Information System - Business Analytics
California State University, Fullerton
Fullerton, CA06-2024
Bachelor of Science - Computer Information System
California State Polytechnic University, Pomona
Pomona, CA12-2021
Skills
- Python and R Programming
- SQL
- Tableau and Power BI
- Excel
- Statistical Modeling
- Forecasting
Languages
Chinese (Mandarin)
Native or Bilingual
Timeline
Marketing Coordinator
LEDCONN Corporation
08.2025 - Current
Business Analyst
ACEE International Education
09.2024 - 07.2025
Market Research Analyst Intern
Small Business Development Center
01.2023 - 05.2024
Product Analyst Intern
MCT Technology
06.2020 - 08.2021
Master of Science - Information System - Business Analytics
California State University, Fullerton
Bachelor of Science - Computer Information System
California State Polytechnic University, Pomona
Similar Profiles
Rebecca BolnerRebecca Bolner
Coordinating Center Associate at United United BioSource Corporation CorporationCoordinating Center Associate at United United BioSource Corporation Corporation
Sandhya YSandhya Y
System Supervisor at Karnataka State Road Transport Corporation(KSRTC) & Bengaluru Metropolitan Transport CorporationSystem Supervisor at Karnataka State Road Transport Corporation(KSRTC) & Bengaluru Metropolitan Transport Corporation
MARK ANTHONY T. MANALOMARK ANTHONY T. MANALO
Chief Cook at Bright Maritime Corporation (Principal: Evalend Shipping Corporation)Chief Cook at Bright Maritime Corporation (Principal: Evalend Shipping Corporation)
Larissa SantosLarissa Santos
Payroll Administrator at Elevated ResourcesPayroll Administrator at Elevated Resources
Eva LittleEva Little
Swim Instructor at Elite Aquatics Sports TeamSwim Instructor at Elite Aquatics Sports Team