top of page

SKILLS

I believe wisdom is an art of skillful learning, and I have a deep desire for knowledge. 

I am able to quickly gain experience among a broad set of skills and therefore support various roles. 

business

Business​

​

What I can do for you

In-depth market research

Develop business plan​

Analyze financial reports

Facilitate planning, controlling, decision making

Deliver excellent presentations

Formulate negotiation plans

​

​

Knowledge Structure

​

My knowledge structure is as follows. This structure is provided by CIMA (Chartered Institute of Management Accountants). I learned this for 4 years and capable of applying those knowledge in real cases. [see my CIMA certificates]

​

CIMA.png
词吗.JPG
project management

Project Management

​

What I can do for you

Project Planning

Budget Prediction

Risk Management

Project Management​

Assess and recover troubled project

Create Gantt Chart, Network Diagram, WBS, Resource Spreadsheet

Agile Project Management, Traditional Project Management

​

Details

Project Management Life Cycle
​

  1. Understand different project management life cycle models (PMLC)

    • Traditional project management(TPM)​

    • Agile project management(APM)

    • Extreme project management(xPM)

    • Emertxe project management(MPx)

  2. Capable of identifying and applying appropriate lifecycle model for a given project

Certificate

I completed the certificate program in University of Chicago with GPA 4.0 and got the Project Management Certificate. 

[see my PM certificates]

​

graham-school-logo.png
Project Basics​
​
Understand what project means and phases of project management lifecycle, capable of using Microsoft Project and performing the following tasks.​​
​

  1. Identify critical activities

  2. Create project plan

  3. Manage stakeholders

  4. Breakdown and estimate project tasks

  5. Estimate budget

  6. Manage risk and compute risk cost (event risk, variability risk, ambiguity, emergemt risk)

  7. Apply earned value management

  8. Manage project resources

    • scope: WBS, scope statement​

    • time: network diagram(critical path), gantt chart

    • cost: bottom-up estimates, cumulative cost curve

    • resources: RACI chart, resrouce spreadsheet​

  9. Create Gantt Chart, Network Diagram, WBS, Resource Spreadsheet by Microsoft Project

Business Analytics

​

What I can do for you

Data Visualization by Tableau

Optimization (max/min) problems

Queueing problems

Network problems

Monte Carlo simulation and forecasting

 

Details

Monte Carlo simulation &
forecasting
​

Understand various probability distributions and capable of ​using Monte Carlo simulation to model the probability of different outcomes that cannot easily be predicted due to the intervention of random variables by @Risk, R or Python.

Optimization

​

Capable of building optimization models and generate optimal solutions by python, Gurobi and Solver. 

​

Problems that I can solve:

  1. Perfrom stock portfolio selection to maximize returns within certain risk

  2. Assign people to groups with balanced skills or backgrounds

  3. Optimize distribution plan (plants - distribution centers - stores - customers) through supply chain

  4. Solve problems in a network:

    • Find shortest path in a network

    • Connects all the nodes in a network with lowest cost (minimum spinning tree)

    • Compute maximum flow and find bottleneck in a network

Visualization​
​

Capable of visualizing and analyzing data by Tableau. Capable of performing the following tasks.

​

  1. Clean data by Alteryx & Tableau Prep

  2. Choose which graph to use based on certain needs/data

  3. Understand visualization principals and aesthetic theories

  4. Create all kinds of charts such as bar chart, line chart, pie chart, map, scatter plot, gantt chart,  bubble chart, histogram chart, heat map, highlight table, and treemap by Tableau

  5. Create dashboards that includes multiple charts by Tableau

  6. Create stories that includes multiple charts or dashboards by Tableau

Queueing​
​

Capable of building a queueing model by R and analyzing the following elements.

​

  1. Expected number of customers in the system, in the queue, and in service

  2. Probability that all servers are idle

  3. Probability that all servers are busy

  4. Expected time spent respectively in the system, in the queue, and in service

  5. Number of servers

analytics
data science

Data Science

​

What I can do for you

Machine Learning / Deep Learning / AI modeling

Model selection, interpretation, evaluation

Web scraping

Data cleansing

Relational database modeling

Data warehouse/data mart modeling

ETL(extraction/transformation/load)

Interact with database by SQL

Create ER diagrams, relational schemas, and star schemas

​

Details

Machine Learning​

​

Understand the following concepts and capable of writing relevant codes for modeling and generating results by R

​

  1. Linear Regression

    • simple linear regression, multiple linear regression, knn regression

  2. Classification

    • logistic regression, Linear Discriminant Analysis, Quadratic Discriminant Analysis, knn classification

  3. Resampling:

    • Cross-Validation (Leave-One-Out Cross-Validation, k-Fold Cross-Validation)

    • Bootstrap

  4. Linear Model Selection and Regularization

    • Subset Selection (Forward and Backward Stepwise Selection)

    • Shrinkage Methods(Ridge Regression, Lasso)

    • Dimension Reduction Methods (Principal Components Regression, Partial Least Squares)

  5. Non-linear Modeling

    • Polynomial Regression

    • Step Functions

    • Basis Functions, Regression Splines, Smoothing Splines, Local Regression

  6. Tree-Based Methods

    • Regression Trees

    • Classification Trees

    • Random Forests

    • Bagging

  7. Support Vector Machine

  8. Unsupervised Learning (in studying)

    • Principal Components Analysis

    • Clustering Methods (K-Means Clustering, Hierarchical Clustering)

    • association analysis

​
Web Scrapping

 

Perform basic web scrapping (based on "html", "json", or "xml") by "requests" and "BeautifulSoup" on python.​

​

Artificial Intelligence​

 

Understand the following concepts and capable of writing relevant codes for modeling and generating results by "keras" on python based on GPU

​

  1. Natural Intelligence

    • Genetic Algorithms

    • Simulated Annealing

  2. Neural Network (Deep Learning) (in studying)

    • Classification​

    • Regression

  3. Convolutional neural network (in studying)

    • Image classification​

  4. Recurrent Neural Network (in studying)

    • Text sequences​

    • Sequence classification

Database Management

​

Understand the logic of database and capable of implementing the following tasks by relevant tools such as SQL.

​​

  1. Database requirements

    • Define database requirements

    • Build and visualize conceptual database model by ER modeling using ERDplus

  2. Database modeling ​

    • Build relational database model that is implementable by DBMS​

    • Visualize relational model by ERDplus

  3. Database Implementation

    • Use SQL to create, modify, or delete database structures.​

  4. Database Deployment

    • Populate the database with initial data​

  5. Database Use

    • Use SQL to implement insertion, modification, deletion, and retrieval of the data in the database system.​

  6. Analytical database

    • Create data ware houses and data marts by dimensional modeling

    • Implement ETL by Alteryx

    • Visualize star schema by ERDplus

  7. Perform data cleansing by Alteryx

Badges I earned from IBM

IBNM.JPG

Soft Skills​

​

What I can do for you

Team Management

Leadership

Professional negotiation

Decision making

Communication

Chinese (native), English (fluent), Japanese (conversational)

Video editing

Website design

Piano

[see my Organizations & Leadership certificates]

​

SOFT

What Softwares I Can Use

ppt.JPG
mproject.JPG
TABLEAU.JPG
erdplus.JPG
python.JPG
alteryx.JPG
excel.JPG
R.JPG
mysql.JPG
gurobi.JPG
bottom of page