Resume

Sign in

Data Analyst

Location:
Mississauga, ON, Canada
Posted:
May 17, 2020

Contact this candidate

Resume:

TUAN MINH DUONG

647-***-**** adc9vv@r.postjobfree.com 3501 Glen Erin Drive, Unit 107, Mississauga, L5L 2E9

SUMMARY OF QUALIFICATIONS

Highly detail-oriented Financial Data Analyst with 2 years of proven experience in data analyzing, data mining, data manipulating and financial modeling by using Microsoft Excel to provide business insights, identify trends and develop forecasts.

Professional Skills Include:

Financial Modeling

Budgeting & Forecasting

Financial Stmt & Ratio Analysis

Advanced Data Mining

Financial Data Visualization

Regression Analysis

Financial Accounting

Investment Analysis

Risk Management

Technical Skills Include:

Excel, MySQL, Python (Pandas, NumPy, Scikit-learn), SAP ERP, STATA, Tableau, PowerPoint, Word

EDUCATION

Bachelor of Commerce – Specialist in Finance and Economics 2017 – 2020

University of Toronto GPA: 3.92/4.0 – Ranked among top 5% of students

Achieved a grade of 95% in equity research project by utilizing Excel to conduct complex financial statements and ratio analysis in combination with valuation methods, including DCF models, precedent transactions, and comparable company analysis, to evaluate investment opportunities.

Advanced Diploma – Business Administration – Marketing 2013 – 2016

Sheridan College GPA: 3.97/4.0 – High Honor

WORK EXPERIENCE

Data Analyst - Internship January 2020 – May 2020

SustainMobility – Mississauga, Ontario, Canada

Executed quality assurance of the development of the new data analytics system project by leveraging Excel functions, such as VLookup, Index, Match, If statement, Countifs, and PivotTable, etc., to analyze business processes, validate the accuracy of data outputs, and troubleshoot data issues.

Developed test scenarios and QA scripts to execute testing on the new data analytics system for 4 weeks to verify the desired results and system functionalities.

Utilized database modeling techniques to visualize ER diagram and relational schema of over 5 entities to validate and maintain data integrity across multiple data sources.

Extracted relevant information from different sources to build comprehensive summary reports and presentations to deliver performance insights to C-suite stakeholders.

Prepared, updated, and maintained management reporting of key performance indicators with keen attention to detail to import data to the new system and enhance the data integration processes.

Research Analyst - with Professor Nicholas Zammit June 2019 – March 2020

University of Toronto – Toronto, Ontario, Canada

Collected, interpreted, and reported Canadian imports and exports data from 1913 to 1917 for many countries to continue building an economic efficiency loss measurement project on panel data.

Applied exploratory data analysis, statistical variance analysis and regression analysis on STATA (statistical software) to design and build statistical analysis models for testing and forecasting purposes.

Used Data Envelopment Analysis technique on STATA to analyze manufacturing data to estimate optimal enhancements for Canadian production while meeting tight deadlines.

Business Analyst - Internship January 2015 – May 2015

Kuehne & Nagel Corporation - Mississauga, Ontario, Canada

Constructed portfolios of prospective accounts by collecting, integrating, and analyzing accurately information of more than 600 companies per day to strengthen the quality of the ERP system (SAP).

Developed data analyzing skills with strong utilization of various features in Excel, such as Pivot Tables, VLookup, and Macros, etc. to prepare ad hoc analysis and performance reports to assist management and sales team in evaluating projects in a fast-paced environment.

Maintained the availability, reliability, and integrity of the sales database in the ERP system by continuously correcting discrepancies and updating information to enhance decision-making process.

EXTRA CURRICULAR ACTIVITIES

Teaching Assistant – for Professor Bailey Lee September 2018 – April 2020

University of Toronto - Toronto, Ontario, Canada

Delivered tutorials and lectures to more than 100 students by utilizing excellent written and verbal communication skills in the academic and interactive manner.

Held weekly office hours to resolve student's concerns with demonstrated interpersonal skills.

LICENSES & CERTIFICATIONS

Certificate of SQL for Data Science from the University of California

Certificate of Python for Data Science and AI from IBM

Certificate of Data Visualization and Communication with Tableau from the University of Duke



Contact this candidate