Lead model buildup, model review and model support activities to help clients make key decisions and drive strategic outcomesInitiated Oil and Gas Analytics service using PowerBI, SQL, Alteryx to provide insights into clients’ reserve and operational dataLead financial model reviews for more than 20 projects from both client side and internal valuation team

• Performed financial analysis to evaluate 60+ acquisition opportunities and assisted firm to acquire upstream oil and gas properties worth $55+ million; and conducted quantitative valuation in Excel to get various economic parameters - price differential, gas shrinkage, fix and variable cost in order to set up DCF model in PHDWIN• Conducted sensitivity analysis to determine the impact on NPV and IRR under different scenarios; applied cash flow look-back method to back test the valuation models• Built PE Fund Waterfall Distribution Models for current 3 funds to conclude rate of returns and Market Metrics parameters by projecting future cash flows and by researching comparable E&P transactions• Built Access Database for asset management using SQL Queries to efficiently manage acquired properties from different aspects – well info, production, revenue and expense• Streamlined the procedure of semi-annual Reserve Reporting for 3 portfolios and created Excel template to calculate all parameters for valuation which greatly enhanced efficiency and accuracy• Participated in the analysis and execution of commodity hedging strategy after acquisitions