Data Analyst Management

Maggie Dong

Work Experience

Tech Skills

Education

JLL Data Analyst Co-op North York April 2018 - Sep 2018

• Managed MS SQL database, Excel spreadsheets and CRM system, enriched client address and contact data and ensured data integrity, quality and reliability

• Prepared documents/reports in forms of paper and PowerBI for sharing with potential clients and brokerage teams

• Collected data from various data sources to perform QA and imported to database accurately

• Participated and provided analytical support on market research projects, evaluated data outputs for market trends and draw insights

• Responded to clients’ requests, designed and built an Excel template to document & track client’s requests and actions

• Created and maintained functional documentations related to current business process and procedures

• Prepared financial analysis reports using SAS and SQL on bank’s performance, portfolio and market risk profiles

• Cooperated with IT team to develop programs to clean database and produce financial reports automatically

• Breakdown the bank wide business plan and financial budget by branches and departments

• Collected and processed finance transaction data to database, provided analytical support and insight to senior management team

York, UK 2011-2014

Mathematics and Statistics University of York B.Sc.

• SQL

• SAS

• SPSS

• Excel/VBA

• Access

• Power BI

• Python

• Photoshop

• R

647-***-****

• Proficient in various tools including SQL, Access, Excel, Word, SAS, SPSS and Power BI

• Experience in data management, analytics and

visualization/reporting

• Exceptional interpersonal & communication skills **************@*****.***

7 Paperbark Ave, Maple, ON

Other Skills

• Time Management

• Database Management

• Financial Reporting

• Financial Modelling

• Report Writing

• Data Visualization

• Good Interpersonal Skill

• Data Collection

• Statistical Analysis

• Regression

• Exceptional Presentation Skill

• Exceptional Organization Skill

Qualifications

Toronto 2017-2018

IT Business Analysis Graduate Certificate Hanson College Toronto 2016-2017

Marketing Management Humber College Graduate Certificate China Construction Bank Financial Data Analyst Shenyang, China Nov 2014 – Nov 2015

Certificate

Udemy

Microsoft Power BI - A Complete Introduction

Languages

• English

• Mandarin

Interests

• Yoga

• Pilates

• Reading

Contact this candidate