Business Analyst


Education:

M.S Industrial Engineering 2 yr merit-based scholarship
B.S & M.S Information Science and Technology Honored undergraduate thesis

Summary of Qualifications:

Experienced in: Applying Mathematics, Statistics, Simulation, Optimization and Data Mining, Finance Modeling
Proficient in: SAS, Hyperion Intelligence / Brio, Advanced Excel, SQL, Access, Arena, Language R, AMPL, Matlab
Plus: Project, Power Point, Access, Visio CFA I candidate,

Experience:

Automotive Industry 2008-Present
Business Analyst Collection Strategy Planning

  • Responsible for Auto-Loan portfolio performance evaluation and strategy analysis; managed statistics analysis process, data warehouse, and reporting, utilizing SAS, Brio, Excel(VBA) and Access etc.
  • Developed Enterprise Data Warehouse (EDW) and executive dashboard to provide performance metric of KPI (Key Performance Indicator) and of API (Association Performance Index).
  • Supported Implementation of behavior scorecards, Collection Segmentation and Recovery Strategy; Implemented Collection Champion/Challenger strategy test, monitored performance, interpreted testing results and provided recommendation report for continuous process improvement.
  • Predicted portfolio performance by building financial model to recognize fraud/loss/bankruptcy pattern and forecasted KPI and API, utilizing vintage analysis, decision tree, time series and simulation.
  • Developed daily/monthly report of collection, recovery and remarketing to track portfolio quality on different platform of SAS, Brio EIS, Access, resulting in 150,000 annual cost reductions and enhanced system accuracy.
  • Trained with background of scorecard development, validation process and strategy.
  • Identified and tracked customers with bad phones using data mining and worked with Experian for information update through MetroNet.


Research Assistant Intelligent Maintenance Systems (IMS) Center, University  2006-2008

  • Built inventory reduction program with simulation tools Arena to optimize production planning and resources.
  • Improved classification accuracy on Boston housing data, employing clustering, regression, neural network and support vector machine and simulating in R language and SAS.
  • Conducted investment analysis of new products launch, utilizing financial accounting knowledge.
  • Built and programmed linear programming model for paper review matching rate optimization, using SQL and AMPL.
  • Conducted magazine market strategy analysis, with Multi-Factors-Nested model and programmed with SAS.
  • Built an warehouse location optimization model to ensure on-time delivery and minimized cost with Excel Solver.
  • Built inventory reduction program with simulation tools Arena to optimize production planning and resources.

Publications and References Available Upon Request