Search
Kevin L.'s Photo

Data Science, R, Python, Excel, VBA, SQL and SAS + Native Mandarin
Kevin L.

4.9 (132 ratings)

535 hours tutoring

Your first lesson is backed by our Good Fit Guarantee
Hourly Rate: $50
Contact Kevin
Response time: 5 hours
Kevin L.'s Photo

Data Science, R, Python, Excel, VBA, SQL and SAS + Native Mandarin
Data Science, R, Python, Excel, VBA, SQL and SAS + Native Mandarin
Kevin L.

4.9 (132 ratings)

535 hours tutoring

Your first lesson is backed by our Good Fit Guarantee
4.9 (132 ratings)

535 hours tutoring

Your first lesson is backed by our Good Fit Guarantee

About Kevin

Bio

I have tutored students in math and statistics since my days at Ohio State university. I like to see my students succeed and be better prepared for their next step of education or career. I have tutored my colleagues on R, Python, VBA, and SQL programming at workplaces as well since I have built various financial models, automation and analytics tools at the companies I worked for and earned good reputation.

Finally, I have also advised many friends on career, especially on quantitative...

I have tutored students in math and statistics since my days at Ohio State university. I like to see my students succeed and be better prepared for their next step of education or career. I have tutored my colleagues on R, Python, VBA, and SQL programming at workplaces as well since I have built various financial models, automation and analytics tools at the companies I worked for and earned good reputation.

Finally, I have also advised many friends on career, especially on quantitative finance and how to break into financial service industry with an IT and software engineering background. I have done it through CFA and FRM designations and master degree in computational finance from Carnegie Mellon University with years of experience at risk management and investment management firms.

In my college and graduate school education, I completed math / statistics courses such as Calculus, Differential Equation, Linear Algebra, Complex Analysis, Real Analysis, Stochastic Calculus, Probability, Stat Inference, Multivariate Regression, Time Series Analysis and Simulation. Homework assignments were often completed using either Matlab or R. In my professional career, especially at Federal Reserve Bank of New York and TIAA, my work often involved using R to do some analysis on financial data. I am currently working at a large consulting firm focusing on financial instrument valuation & modeling and data analytics.

I am a native Chinese speaker who grew up in Taiwan and finished high school education there. I have also frequently posted comments in Chinese on various online news outlets and shared short fictional stores in Chinese on certain forums.

I am a CFA charter holder since 2013 with more than 6 years of real financial service industry experience in risk management and investment management.

I learned SQL while I studies for my bachelor's degree in Computer Science Engineering at Ohio State University. I have used MS SQL Server and Oracle at various software, internet and financial services companies I worke

Read more

Education

4 years The Ohio State University
Computer Engineering
Unversity of Southern California
Masters
Carnegie Mellon Iniversity
Masters

Policies

Schedule

Loading...

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Approved Subjects

Business

Finance,

Finance

I am a CFA and FRM Charter holder and earned MS in Computational Finance from Carnegie Mellon University. In addition, I have more than 6 years of experience in risk management and investment management including investment analyst at Carnegie Mellon Investment Office and risk analytics associate at Federal Reserve Bank of New York. Currently, I am working on investment risk and strategy team at a large investment management firm. In my spare time, I also help students prepare for CFA exam.
Microsoft Excel

Microsoft Excel

I used excel extensively at work whether it is complicated INDEX / MATCH, VLOOKUP/HLOOKUP functions or excel with VBA. In addition, I have built several financial models which require passing parameters from excel to R and invoke R functions directly from excel. I also have experience building Monte Carlo simulation and constrained optimization with excel. Last but not the least, I have successfully built an alternative risk analysis reporting system for real asset classes (i.e., energy / infrastructure, agriculture/ timber and commercial real estate investment) using Tableau with excel as the data source.

Computer

Microsoft Excel,

Microsoft Excel

I used excel extensively at work whether it is complicated INDEX / MATCH, VLOOKUP/HLOOKUP functions or excel with VBA. In addition, I have built several financial models which require passing parameters from excel to R and invoke R functions directly from excel. I also have experience building Monte Carlo simulation and constrained optimization with excel. Last but not the least, I have successfully built an alternative risk analysis reporting system for real asset classes (i.e., energy / infrastructure, agriculture/ timber and commercial real estate investment) using Tableau with excel as the data source.
Python,

Python

I have used python quite often during the last twos years. I have used Python numpy, scipy and pandas packages to re-write my proof-of-concept risk models originally written in R and put the models into production. The models are used to set limits and guideline for TIAA's $240B general account. In addition, I have tutored college students in Python via external referral.
R,

R

During my MS in Computational Finance program at Carnegie Mellon University, R was used extensively to solve multivariate regression, machine learning, time series analysis, simulation and optimization problems. When I worked at Federal Reserve Bank of New York, I used R to develop analytical tools to monitor P/L and risk sensitivities data submitted by large banks. In addition, R was the choice of language at my current job for implementing Gaussian Copula model on credit portfolio tail loss calculation.
SAS,

SAS

I have done more than 3 projects using SAS at my full-time job. Topics include but not limited to random sampling, exploratory data analysis, t-test / ANOVA, multi-variate linear regression and logistic regression.
SQL,

SQL

1. BSE in Computer Science Engineering and MS in Computer Science with 7+ years of SQL experience and 1+ years of teaching experience 2. I am familiar with Microsoft SQL server and have experience with MySQL and Oracle SQL.
Visual Basic

Visual Basic

Visual Basic was used extensively to build administrative tools while I worked at Federal Reserve Bank of New York. The reason was primarily due to the fact that most of my colleagues had a business background and were familiar with VBA, which was syntactically similar to Visual Basic. The sample modules written in Visual Basic are as follows: 1. GUI interface to interact with R functions 2. SQL database related functions: read, update, delete and write 3. File management and manipulation

Corporate Training

Finance,

Finance

I am a CFA and FRM Charter holder and earned MS in Computational Finance from Carnegie Mellon University. In addition, I have more than 6 years of experience in risk management and investment management including investment analyst at Carnegie Mellon Investment Office and risk analytics associate at Federal Reserve Bank of New York. Currently, I am working on investment risk and strategy team at a large investment management firm. In my spare time, I also help students prepare for CFA exam.
Microsoft Excel,

Microsoft Excel

I used excel extensively at work whether it is complicated INDEX / MATCH, VLOOKUP/HLOOKUP functions or excel with VBA. In addition, I have built several financial models which require passing parameters from excel to R and invoke R functions directly from excel. I also have experience building Monte Carlo simulation and constrained optimization with excel. Last but not the least, I have successfully built an alternative risk analysis reporting system for real asset classes (i.e., energy / infrastructure, agriculture/ timber and commercial real estate investment) using Tableau with excel as the data source.
SQL,

SQL

1. BSE in Computer Science Engineering and MS in Computer Science with 7+ years of SQL experience and 1+ years of teaching experience 2. I am familiar with Microsoft SQL server and have experience with MySQL and Oracle SQL.
Statistics

Homeschool

Statistics

Math

R,

R

During my MS in Computational Finance program at Carnegie Mellon University, R was used extensively to solve multivariate regression, machine learning, time series analysis, simulation and optimization problems. When I worked at Federal Reserve Bank of New York, I used R to develop analytical tools to monitor P/L and risk sensitivities data submitted by large banks. In addition, R was the choice of language at my current job for implementing Gaussian Copula model on credit portfolio tail loss calculation.
Statistics

Most Popular

Statistics

Other

Finance

Finance

I am a CFA and FRM Charter holder and earned MS in Computational Finance from Carnegie Mellon University. In addition, I have more than 6 years of experience in risk management and investment management including investment analyst at Carnegie Mellon Investment Office and risk analytics associate at Federal Reserve Bank of New York. Currently, I am working on investment risk and strategy team at a large investment management firm. In my spare time, I also help students prepare for CFA exam.

Summer

Statistics

Examples of Expertise

Kevin has provided examples of their subject expertise by answering 1 question submitted by students on Wyzant’s Ask an Expert.

See all of Kevin ’s answers ›

Ratings and Reviews

Rating

4.9 (132 ratings)
5 star
(122)
4 star
(5)
3 star
(3)
2 star
(1)
1 star
(1)

Reviews

Knowledgeable and thoughtful!

I absolutely enjoyed my lesson with Kevin. I highly recommend him if you want to learn R, Python, Data Science, and Statistic. He is a true expert, and also very thoughtful to explain the subject matters that I am not familiar with. He is a great teacher.

Yeri, 1 lesson with Kevin

Planned how to help me before starting

Kevin L is super fast. I thought this was going to take at least twice as long. He seemed to have all the info I needed ready before we started. I feel really insecure any time I get lost and I have a hard time focusing when sleep deprived but he made it really simple for me. I got help in Python.

Alana, 1 lesson with Kevin

Awesome tutor!

Kevin was very knowledgable about Python pandas and super patient. He helped me solve my problem quickly. I will definitely work with him again and I highly recommend him to anyone doing data analysis.

Olivia , 1 lesson with Kevin

Really helped me understand coding concepts and steps

Kevin is a great tutor. He was patient and explained step-by-step how to work through coding problems. He teaches with a good balance of theory and practice. If I need more help with stats or coding I will definitely reach out to Kevin again.

Renata, 2 lessons with Kevin

Could not ask for better: passionate and knowledgeable

R programming assignments. Great person to have as a mentor/teacher. Not only is Kevin knowledgeable in this field (and many others), he is also very passionate about teaching.

Tokumori, 2 lessons with Kevin

Very helpful!

Kevin is knowledgeable, kind and patient. He answered all my questions and advised me the best way to go forward with my studies. I will definitely use Kevin again.

Ted, 1 lesson with Kevin

Very helpful!

Kevin was extremely helpful and kind. He showed me how things worked in another software that I knew better which helped me understand how things worked in the new software I had questions about. This approach really worked well for me, and he also explained it well even without the visual.

Mary, 2 lessons with Kevin

Math Tutor

Kevin L. responds right away to messages and is very knowledgeable and has helped me with Statistics this semester! I recommended him.

Anonymous, 4 lessons with Kevin

Extremely knowledgeable and helpful!

Kevin taught me how to use R, and was always willing to provide extra help outside of our scheduled time. He is extremely knowledgeable about R and was able to help with any problems I was having with the software. 10/10 would recommend him.

Janine, 5 lessons with Kevin

Math Tutor

Kevin L. responds right away to messages and is very knowledgeable and has helped me with Statistics this semester! I recommended him.

Anonymous, 4 lessons with Kevin
Hourly Rate: $50
Response time: 5 hours
Contact Kevin