Excel,Python,SQL,Tableau,R,Jira

PROFILE

Undergraduate degree in Mathematics; Strengths in statistical, business and data analysis; Statistical modeling using SQL, R and Python. Technical Skills include:

Database Programming: Python; SQL; R; Mat-lab

Project Management Tool: Jira Software

Visualization Software: Excel, Tableau

EDUCATION

British Columbia Institute of Technology 2019-Present

- Applied Data Analytics and Applied Database Administration certification

Simon Fraser University 2012-2017

- Bachelor of Science in Applied Mathematics

EXPERIENCE

Math/Physics/Stats Tutor, JL Educational Institute Mar 2019 – Present

Managed 1-year term AP Calculus/Physics/Statistics preparation and implemented lesson plans

Managed students’ progress, performance reports and their problems with their parents

Trade Finance Associate, KEB Hana Bank Canada Jan 2018 – April 2018

Specialized Import Export DP/DA/Negotiation/Collection

Managed bank administration, executed daily, weekly and monthly reports

Created Table using Excel to calculate interest rates, bill of lading products, quantities and amounts

ACADEMIC PROJECT

Data Analysis Project (MS-SQL)

- Experience using data to design (ERD diagram for operating procedure) and answer business questions, via writing queries in SQL against multiple large data set; detected potential issues, and made recommendation and guidance such as defining the goal, and what we are interested in for project.

Date Analysis Project (Tableau with Excel)

- Experience in gathering datasets, data cleaning, transformation using Excel PowerQuery, and creating dashboards using Tableau. Storytelling by finding relationships in topics such as Global GDP, Mortality Rate, and CO2 Emission Rate all together how they are correlated each other.

HIV Spread Prediction (MatLab/Excel)

- Analyzed and estimated on HIV spread in particular country, gathered data, found appropriate equations, applied and interact with various constraints to predict future events. (spreading or dying?)

Linear Programming (Excel/Report)

- Maximized daily intake of nutrients, minimized costs in subway (restaurant company) using Excel solver (simplex linear programming) created system of equations by looking at all combination of sandwiches with at least 20 items of ingredients; applied best-fit constraints and presented the result.

Contact this candidate