TUAN MINH DUONG
647-***-**** firstname.lastname@example.org 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:
Budgeting & Forecasting
Financial Stmt & Ratio Analysis
Advanced Data Mining
Financial Data Visualization
Technical Skills Include:
Excel, MySQL, Python (Pandas, NumPy, Scikit-learn), SAP ERP, STATA, Tableau, PowerPoint, Word
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
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