REFERENCE AVAILBLE UPON REQUEST
Dedicated and result-oriented Analyst with experience in data/business analysis and reporting. Apart from possessing exceptional analytical and problem-solving skills, Yvonne is an organized team player with time management, detail- oriented and presentation skills.
Technical Skills __
Programming Language Advanced SQL, VBA, R, Python
Business Intelligence Tableau, Excel (Dynamic Pivot Table/Chart, VBA Macro)
Databases Microsoft SQL Server, MySQL
Data Analysis Data quality Analysis, Predictive Analysis, Data Integrity
Project Management Business Requirement Documentation, Requirements Gathering Experience & Projects __
Data Analyst - Innovation Services Inc. (Mississauga, ON) Sep 2018 - Current
Data Cleansing Sales Analysis – Tableau Dashboard
Data Management Complex SQL queries
VBA macro report automation Reporting Tool: Advanced Excel, Tableau
Gathered, created and analyzed data to assist in providing solutions and recommendations for clients to identify business opportunities to improve business processes
Improved access to data to ensure that data is properly managed, data security and data integrity
Manipulated and mapped data using Excel, and created dynamic analyzing model using Functions (IF, Offset, Match, look-ups) and VBA Macros to ensure the effectiveness of job delivery
Utilized SQL querying and visualization tools to generate reports
Gained working knowledge of customer and marketing analytics including decision tree analysis, predictive modeling, scoring and strategy building
Worked with management to analyze and interpret data using statistical techniques and knowledge
Prepared documentation of business requirements, policies and procedures surrounding the development and maintenance of data warehouse environment
Actively review data management to identify opportunities to improve data transportation process Environment: ERP (Fishbowl), MySQL, SQL Scripting, Excel, Tableau. Graduate Research Assistant - Dalhousie University (Halifax, NS) Sep 2016 – May 2018
Trend comparison Database: MS Access
Data analysis Access & Excel Reporting Automation
Coordinated with team members to collect required data and built MS Access database using SQL queries to create linked tables and upload forms
Performed data quality analysis, summarized the method to resolve duplication issues in data warehouse
Developed processing tools related to data analysis and visualization
Worked closely with project manager and developer to perform data profiling, gap analysis and test planning
Collaborated with other partners to develop strategies to automate data quality management Research Assistant – St. Francis Xavier University (Antigonish, NS) July 2015 - May 2016
Researched and compared different methods of growing bacteria to study the characteristics of biofilms.
Utilized Raman Spectroscopy to conduct biofilm characteristics Education_ _
MASc. in Environmental Engineering Dalhousie University Sep 2016 – May 2018 BSc. In Chemistry St. Francis Xavier University Sep 2012 – May 2016 Yvonne Li
Toronto, Tel: 902-***-****
Email : ******.**.********@*****.***