Data Project

Charles Cheng

* ** ****** **, ******* 647-***-**** *************@*****.***

Skills Summary

• Superior skills in advanced Excel such as data validation, conditional formatting, PivotTable, VLOOKUP, array formula, highly-visualized charts design, string operation.

• Solid skills in Excel VBA; automating, Coding (do while, if loop, worksheet function etc.), Record Macro, Debug codes, create dynamic charts.

• Excellent knowledge with SQL queries and MySQL database; importing/ exporting databases, creating tables and distinct datatypes, multi- inserting/ updating/ deleting data, referencing and ordering tables by timestamp, filtering table by case statement/ Aggregate Functions etc.

• Proficient in Tableau; connecting data, mapping data geographically, creating interactive dashboards.

• Fluent coding skills in SAS, Python, academic knowledge of R.

• Fast learner, enthusiastic in work and always looking for professional improvement. Excellent communicator with strong abilities in oral and written communications. Great efficient problem- solver with strong capabilities of self-learning, self-discipline, multitasking and time management. Excellent team- player, friendly and easy- going with teammates, can perform tasks well both individually or in a team.

Projects & Experience

MySQL project of Instagram Database clone Dec. 2018

• Simulate Instagram database by creating several tables including user table, photo table, comments table, likes table, follows table and Tags table, associate those tables by defined primary and foreign keys.

• Inserting thousands of data into the Instagram database and analyze the data to draw specific conclusions. (active/ inactive user, most used hashtags, bot user who liked every post, day of the week that most user register on etc.)

Excel VBA project Oct. 2018

• Creating a VBA procedure (application) to enable users choose and import multiple text files by one click. Creating excel functions to enhance reusability.

• Writing VBA codes (combination of While/do, If, Loop, Worksheet Function, and Record Macro) to organize data (auto calculate, add headers, formatting) and generate to the final reports. Significantly improved the efficiency of generating reports.

• Creating dynamic charts / user forms with scroll bar and instruction buttons.

SQL database Computer Science Project Sep. 2018

• Accessed Database and manipulated database by sending queries such as Select, Join, where, and updates DBMS as requests.

• Developed an ER model in SQL based on the Association’s requirements; defined primary key and foreign key for each entity. Create tables for each entity and imported data from University’s database.

Desupline Asset Management Co., Ltd. Intern Junior Analyst May 2015 – August 2015

• Prepare presentation PowerPoint documents and Excel spreadsheet reports to clients on financial products.

• Calculate and processes monthly commission payout and produce analytical reports to manager to help in project planning and budget making (Excel).

• Analyze the organized clients' information in terms of investments objectives and risk appetite and create reports by Excel to support decision making.

• Find out, record and analyze data/ information through Excel and create statistical report for executive. Prepare contract and other needed paperwork to clients.

Funde Sino Life Intern Insurance Analyst December 2012 – February 2013

• Record and analysis potential customers, type in the data through Excel.

• Pull out the data and call potential customers, introduce the products and record comments about their attitudes.

• Record and analyze the total sales of different products through Excel, helping executive making improvements of products and change monthly objectives.

Education and online courses

University of Toronto 2014-2018

Bachelor's Degree Major in Statistics; Environmental studies

Udemy Online Courses September 2018 to December 2018

• The Ultimate MySQL Bootcamp

• Microsoft Excel- advanced Excel

• Complete Python Bootcamp

• Learn SAS and Become a Data Ninja

Contact this candidate