Sign in

Data Assistant

Toronto, Ontario, Canada
April 26, 2019

Contact this candidate



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 :

Contact this candidate