Zherong Ye

Zherong Ye

Junior Data Analyst
Canada

نبذة عني

Highly motivated recent graduate with a strong interest in data analytics. Seeking a Junior Data Analyst position to apply passion for solving real-world problems using analytical skills. I am looking forward to providin…

الخبرة

Excel Programming Trainee

Savvy Pro Education
Jan 2024

Quickly acquired Excel skills through hands-on experience and utilized skills in projects showcasing adaptability.
Knowledge in formula creation, pivot table utilization, and skilled in data visualization through charts/graphs.
Able to efficiently organize, manipulate, and analyze data to derive meaningful insights.
Familiar with features such as conditional formatting, data validation, VLOOKUP, Power Query and VBA.

Fraud Analytics in Retail Banking

Project
Jan 2024

Analyzed a sizable dataset of transactions to identify patterns and trends of fraudulent activities.
Conducted data analysis and integrated multiple datasets using SQLite.
Identified and resolved errors within the dataset to ensure correct table joining and accurate analysis.
Backtested and evaluated rule performance using Error Analysis, tuning features to improve detection performance.

Marketing Campaign Analysis

Project
Dec 2023

Analyzed data from a contact-center of a Portuguese bank to optimize its targeted marketing campaigns.
Conducted data cleaning and validation in Python, enhanced data completeness through missing value imputations using the Scikit-Learn package.
Developed and compared predictive models (Random Forests, Simple Forest, Logistic Regression), informing decision-making in marketing strategies.
Improved accuracy of a prediction model by implementing multiple missing value imputation strategies.

Sales Operation and Dashboard

Project
Nov 2023

Analyzed global store retail transaction data to identify sales trend, profit growth opportunities, area of strategic initiatives using visualizations.
Visualized data using advanced graphs.
Performed correlation analysis using Scatter plots, and regression model visualizations, delivering informational insights.
Analyzed 4 years of online retailer operational data to identify the opportunities using quadrant analysis.
Created dashboards, using graphs, tables and Tableau’s enhanced interactivity features.

المهارات

إكسل حساب بايثون (لغة برمجة) قاعدة بيانات SQL الإحصاء اختبار A/B إكسل VBA خوارزميات تعلم الآلة تابلو Time Management Attention to Details Critical Thinking Effective Communication Problem Solving Analytical Skills SQL NumPy Matplotlib Pandas NLP Scikit Learn Pyecharts SQLite VBA Power Query VLOOKUP Conditional Formatting Data Validation Pivot Tables Data Visualization Data Cleaning Data Analysis Missing Value Imputation Random Forest Logistic Regression Correlation Analysis Regression Analysis Quadrant Analysis Dashboard Creation
الإبلاغ عن هذا الملف الشخصي؟