Xiaodan Zhang
London,ON
Summary
Positive problem-solver with knack for uncovering insights through data-driven analysis. Well-versed in statistical methodologies and proficient in tools such as SQL and Python, with solid understanding of data visualization techniques. Capable of leveraging analytical skills to drive impactful business decisions.
Overview
1
1
year of professional experience
Work History
Data Analyst
CSO Education Technology Group
05.2024 - 08.2024
- Big Data Analysis: Conducted analysis on over 100 million records using SQL scripts and Python libraries (Pandas, NumPy, SciPy, and Scikit-learn), identifying key trends, patterns, and anomalies
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Dashboard Development: Designed and developed a risk dashboard in Tableau to monitor key performance indicators (KPIs), delivering actionable insights and data-driven recommendations to stakeholders
- Improvement Planning: Developed and documented comprehensive improvement measures and management plans by synthesizing field investigations and multimedia content from the marketing department
- User Data Insights: Conducted user data analysis by extracting insights from online reviews and Q&A, which led to a 25% increase in customer satisfaction following the implementation of the recommendations
- Process Automation: Enhanced operational efficiency by 70% by automating daily reporting processes using VBA and SQL, significantly reducing manual effort and error rates
- Team Collaboration: Collaborated with cross-functional teams, including marketing and product development, ensuring alignment with business objectives and the integration of user insights into project development
Campus Marketing Coordinator
EasyTransfer
02.2023 - 09.2023
- Campaign Coordination: Collaborated with the Business Marketing Group and Business Department to execute campus marketing campaigns, increasing service adoption among university students and boosting user engagement
- Market Research and Analysis: Performed market research and analyzed data using Excel and SQL to identify key customer segments, optimizing targeted marketing efforts and improving campaign efficiency by 20%
- Business Analysis: Conducted business analysis to evaluate marketing performance, identifying gaps in customer engagement and providing recommendations to enhance the overall campaign strategy
- Strategy Development: Developed marketing strategies based on the analysis of user feedback and market trends, providing actionable insights that influenced future marketing initiatives
- Project Management: Assisted in the management of marketing projects by coordinating with cross-functional teams, managing timelines, and ensuring projects aligned with business objectives and deadlines
Education
Bachelor of Science - Applied Math, History
University of Western Ontario
London, ON06-2026
Skills
- Data Analysis
- SQL
- Python
- Pandas
- NumPy
- Excel Functions
- Python Programming
- Data Visualization and Presentations
- SciPy
- Scikit-learn
- Dashboard Development
- Tableau
- Process Automation
- VBA
- Business Analysis
- Market Analysis
Volunteer Experience
VP Education, Nail'd it Club, Western University, 2024
- Leadership and Team Management: Led a team of club members, coordinating educational initiatives and ensuring alignment with the club's goals and objectives, resulting in a 15% increase in member engagement and participation.
- Fundraising Strategy and Execution: Planned and managed fundraising initiatives to support team activities, organized events, and coordinated outreach efforts to secure sponsorships and donations.
- Membership Management: Oversaw the recruitment, engagement, and retention of team members, maintaining a strong, motivated team by organizing team-building activities and managing member communication.
- Event Planning: Planned fundraising events, ensuring smooth operations, financial oversight, and active participation from team members and supporters.
Volunteer at Convocation 2024, Western University, June 2024
- Maintained clean, neat, and operational facilities to serve program needs.
- Assisted with special events and programs.
- Completed daily domestic tasks in shelters and group homes to assist people in need.
Volunteer at Science Olympic 2024, Western University, May 2024
- Assisted with special events and programs.
- Maintained clean, neat, and operational facilities to serve program needs.
- Coordinated and managed volunteer activities for activities.
- Created educational materials to convey important information to service recipients.
Languages
English
Full Professional
Chinese (Mandarin)
Native or Bilingual
Japanese
Limited Working
Timeline
Data Analyst
CSO Education Technology Group
05.2024 - 08.2024
Campus Marketing Coordinator
EasyTransfer
02.2023 - 09.2023
Bachelor of Science - Applied Math, History
University of Western Ontario
Similar Profiles
Asaad AlomairyAsaad Alomairy
Project Coordinator/Program Admin. at Parker Hannifin, Aerospace Group, CSOProject Coordinator/Program Admin. at Parker Hannifin, Aerospace Group, CSO
Haiqi LiuHaiqi Liu
TOEFL Teacher Assistant at New Oriental Education & Technology GroupTOEFL Teacher Assistant at New Oriental Education & Technology Group
Langtian SongLangtian Song
Tutorial Assistant at New Oriental Education & Technology Group Inc.Tutorial Assistant at New Oriental Education & Technology Group Inc.