Resume

• 2015

  Chinese

  English

  Korean

  Japanese

  Georgia State University - J. Mack Robinson College of Business

  B.B.A.

  •\tGraduated Cum Laude\n•\tMember of Beta Alpha Psi (an honorary organization for accounting

  finance and information systems students)

  Beta Gamma Sigma (an honor society for business students)

  and The National Society of Leadership and Success (one of the largest college leadership honor societies)\n•\tMember of Portfolio Management Team of The Finance Society: \n \tActively involved in equity trading; analyzed fundamentals of companies and gave presentations of analyses then provided a rating of stocks to other teammates\n\tCreated and managed PMT’s portfolio financial model which performed daily price updates of holdings in the portfolio

  calculate beta and dividend yield of the portfolio

  and store historical data of the portfolio’s holdings

  Accounting and Finance

  Beta Alpha Psi

  Beta Gamma Sigma

  and Finance Sociality

  Master of Science (M.S.)

  Mathematics with a concentration in Statistics

  Georgia State University

  LINEAR STATISTICAL ANALYSIS I

  STOCHASTIC RISK MGT MODELS

  Introduction to Derivative Markets

  BAYESIAN DATA ANALYSIS

  APPLIED NONPARAMETRIC METHODS

  APPLIED MULTIVARIATE STATISTCS

  SAS PROGRAMMING

  MONTE CARLO METHODS

  Fundamentals of Valuation

  FINANCIAL ECONOMETRICS

• VBA

  SQL Server

  HTML

  Matlab

  Data Modeling

  Financial Accounting

  Personal Finance

  Database Design

  JavaScript

  SQL

  SAS

  Microsoft Excel

  Statistics

  LaTeX

  Access

  Trade Finance

  Python

  R

  Economics

  Visual basic.net

  Wang

  Seeking for full-time career

  Chun Wei (Benny)

  Wang

  Learning and Tutoring Center at Georgia Perimeter College

  SunTrust

  Georgia Power Company

  Georgia State University

  Southern Company

  Southern Company

  Greater Atlanta Area

  Statistical Quantitative Analyst

  SunTrust

  Dunwoody

  GA

  •\tAssisted students with Accounting

  Computer Science

  Economics

  Finance

  Managerial Science

  Mathematics

  and Statistics Courses\n•\tEducated students on financial formulas such as: ROE (DuPont)

  annuity

  and many others \n•\tTutored more than 50 students and improved their grades to an A in classes each semester \n•\tTutored students in Microsoft Excel and Access; elevated their understanding concepts of spreadsheets and/or databases\n•\tElucidated concepts and course materials for students

  Tutor for Higher Education

  Learning and Tutoring Center at Georgia Perimeter College

  •\tInvolved in developing a database application for Wholesale Financial Model; performance during development led to full-time employment\n•\tProvided technical supports; Microsoft Access

  Excel

  and many other applications; programmed codes in Python and VBA for amortization process\n•\tCreated 5 years pro forma budget models for a department with 100+ personnel; models included projections of macro and micro level of cost within the department\n•\tAnalyzed and reported budget for a project costing $192.2 million

  Budget Analyst Intern

  Greater Atlanta Area

  Southern Company

  Greater Atlanta Area

  Graduate Student Instructor

  Georgia State University

  •\tForecasted short-term and long-term of company's sales and total energy by using regression time-series analysis under multiple economic scenarios data with EViews

  MatrixND and Analysis Toolpak add-in of Microsoft (MS) Excel\n•\tBuilt linear and Polynomial Distributed Lags (PDL) regression model to find weather impact of energy supply; apply Autoregressive (AR) to remove noises of input data.\n•\tCreated and maintained economic chronological heat maps (Real GDP

  Unemployment Rate

  and more) using MS Excel conditional formatting and VBA to apply or remove indicted recession periods\n•\tAutomated forecast processes using Visual Basic for Applications (VBA) in Microsoft Excel and C#.NET\n•\tExtracted and analyzed economic data from Moody’s Data Buffet then create processes to feed data into multiple economic models\n•\tAutomated and provided earnings call information (Total Employment

  Total Retail Sales

  and many other economic and Company data) via dashboards \n•\tWrite summary reports of economic indicators; such as

  Fed’s Beige Book

  Jobless Claim

  Job Opening and Labor Turnover Survey

  and etc. \n•\tCreated MS Excel models with VBA codes to support specific needs

  Forecast Analyst

  Greater Atlanta Area

  Southern Company

  Greater Atlanta Area

  -Lead implementation of PD

  Prepayment

  and Loss models to the CECL requirement for all the portfolios.\n-Develop analytical estimates of mean reversion.\n-Work with various functions to implement \n-Create detail and summarised reports for business to state financials internal and external.\n

  Model Implemenation Engineer

  SunTrust

  •\tLed development of database applications; programmed forms using MS Access VBA

  Structured Query Language (SQL)

  ActiveX Data Objects (ADO) queries

  and Visual Basic.NET (VB.NET) to cut the elapsed time of the major procedure of the process from one day to less than one minute\n•\tDesigned the fundamental processes of database applications by developing complex queries\n•\tDeveloped interfaces from an Oracle database or server databases to local MS Access databases\n•\tCreated and automated controls for validating data with SQL queries

  MS Excel

  and etc; and generate reports of the controls\n•\tGathered business requirements from end users to start development and engage end users in a user acceptance testing\n•\tProvided technical supports; MS Access

  MS Excel

  and many other applications; programmed codes in Python and VBA

  Developer/System Analyst

  Greater Atlanta Area

  Georgia Power Company

  member

  American Mathematical Society