Data Analyst
Toronto, Ontario, Canada
Business Collaboration and Data Preprocessing (MySQL, Python)• Collaborated with clients’ internal teams to develop data-driven strategies that aligned with their business goals and addressed problems.• Refined clients’ needs through interviews, meetings, and document reviews, translated requests, and cleaned data using SQL and Python.Data Manipulation and Statistical Analysis (Excel, MySQL, Python)• Conducted segmentation analysis with RFM (Recency, Frequency, Monetary) on client’s customer purchase data, identifying key segments for targeted marketing campaigns and working closely with the client to implement strategies that increased sales by 5% in 2 weeks.• Performed metrics analysis with a linear regression model in Python and A/B testing with client, boosting product application rate by 3%.• Analyzed customer behavior data across channels and offered branding strategy insights, increasing campaign enrollment rate by 5%.Data Automation and Visualization (Power BI, Excel)• Created and managed a real-time performance tracking dashboard on Power BI, serving 100+ users and enabling effective monitoring and optimization of marketing campaign performance across different channels, including revenue, profit, ROI, etc.• Automated data generation by integrating systems with ETL processes and using SQL queries and scripts to create reports for monthly and ad hoc business needs, reducing processing time by 75%.