- Researched the major factors affecting premium in an M&A process int eh Pharmaceutical industry.

      - Utilizing Excel VBA to construct Time-series regression for the data analysis

      - Researched the major factors influencing premium in the M&A process using Excel.

      - Conducted Altman Z Analysis 

      - Analyzed historical operation performance in GAAP standard and conduct adjusted financial analysis in non-GAAP basis

      - Based on financial statements, conducted ROE and Financial Position analysis

      - Conducted a 3-year forecast on Kimberly-Clark Corporation

      - Calculated cap-weighted active forward return and sector-based price-to-book ratio z-score, natural log cap z-score for each security

      - Run cross-sectional regressions of 1000 securities in 60 months' period to calculate sector premium Lambda for factors like Beta, sector-based P/B z-scores, and natural log cap z-score

      - Counted the number of significant P-values of each months' regression by positive or negative effects on return factors have a higher positive return significance will be potential Alpha

      - Conducted sensitivity regression of Lambda against JAMCX fund's active return and used regression R square as the indication of unsystematic risk-taking

      - Obtained fund's MTE benchmark using Excel Solver by minimizing its volatility difference against presumptive benchmark indexes

      - Compared fund's average active return and information ratio with those indexes in order to determine the fund benchmark

      - Applied time-series analysis to test the fund style's consistency

      - Determined pairs of stocks that have high correlation and fundamental Similarity    

      - Using 20 days moving average, volatility, and price-relativity to construct a pair trade signal 

      - Conducted a pair trade profit and loss table to analyze the performance of the trade using Excel

      - Increased the return of the trade by optimizing the trade signal threshold 

      - Optimized the return by adding fund allocation strategies

• Managed Salesforce Database for the organization; Maintained and upgraded the data structure across 10+ objects and 300+ data fields with proper validation, workflow, process, and so on; Optimized staff data entry interface; Implemented Lightning interface
• Data Mining: explored and restructured raw client data; Transformed it into analyzable data form in order to get the most information
• Conducted data research on questions raised by program teams
• Set up Python Jupyter Notebook server using AWS services; Implement Salesforce SQL for fast data query and analytics; Built Python program to automate daily reporting and data monitoring
• Built statistics model to predict program performance and optimized client target groups

• Developed a series of client service metrics that are still being used to measure Chamber client needs
• Responsible for gathering CRM information and developing a comprehensive report once a month for management
• Assisted in developing several database procedures that made CRM research significantly easier
• Utilized Salesforce to update data, import external data, generate report; optimized data structure; designed internal data report process
• Extracted Salesforce data into other data warehouse and perform further analysis using Python, and SQL, query, create, integrate, ETL, concatenate, interleave, merge datasets
• Designed Python bots to automate data gathering and cleaning processes

- Took the responsibilities to plan the firms marketing and business development resource allocation and risk management strategies
- Review financial statements and analyze sales revenues, costs, expenses, and tax rates
- Cost Management: Estimated project cost using the bottom-up estimating technique; Conducted cash flow analysis to determine periodical working capital, and decided reinvestment rate
- Identified the detail of operation, compliance and reputation risk that the firm may bear, prepared risk documents and calculated yearly VaR based on quantitative models, determined optimized target client niche
- Developed comprehensive reports, abstracts, and charts to present data and guide investment strategies; Create and deliver presentations, providing recommendations on short- and long-range ROI.
- Tracked project progress and ensured internal communication using Trello; Prepared internal marketing and risk management documents
- Improved operational efficiency of financial systems through the implementation of streamlined data-management procedures by Salesforce and Mycase legal database.

• Implemented Pair Trading strategy on securities market trading; designed Python program to screen high correlated stock pair to trade; Yielded stable spread returns

• Utilized Python programs to calculate stock Beta, correlation, z-score, and Technical Analysis indicator to show stock’s trending   

• Explored other trading opportunities by screening momentum stocks and analyze stock mean reversion and calculated its half-life for trading

- Calculated short term and long term VaR for the firm equity, fixed income, and future market portfolio; Reported to the Manager to make sure enough capital reserve
- Calculated daily Beta and Delta exposure on the firm's equity market portfolio
- Assisted in testing and adjusting PD, EAD and LGD models under the Basel III framework on fixed income instruments
- Assisted in conducting Monte Carlo simulations to forecast daily VaR on security portfolio using Python
- Optimized risk management practice by accounting for Time Decay on options contracts, and Mark to Market on future contracts; Deployed Tailing the Hedge technique to determine hedging ratio
- Cooperated with the trading team to monitor foreign currency risk exposures on a daily basis

Key coursework: Mathematics in Finance Application, Statistics, Financial Modeling, Portfolio Management, Fixed Income management, Monte Carlo Simulation, Equity & Equity Derivatives Trading, Global Financial Market

Key Courses: Human Resource Management, Methods of Social Survey, Casework Consult, Group Work, Community Work, Anthropology, Social Psychology

Key Courses: Calculus, Algorism Design, C++, Discrete Data Structure, Data Structure

• Online certification courses through Coursera
• Key coursework: R Programming, Getting and Cleaning Data, Regression Model, Exploratory Data Analysis, Reproducible Research