Modeled long-term power price, load and production for the ERCOT power market using Enelytix, Python, and other tools.Developed EV load forecast, retirements, and CAPEX assumptions for the Winter 2024 ERCOT long-term forecast.Performed detailed research and analysis on Texas electric-vehicle (EV) electricity demand and enhanced the existing EV-load forecast model in Python.

Modeled and delivered long-term power price and production forecast using AURORAxmp and other tools for the Ontario power market and Capital Power's assets for the Budget and LTP on a semi-annual basis.Provided fundamental market analysis and modeling for ad hoc requests from Business Development and Regulatory. Delivered macroeconomic variable forecasts and commentary for the Budget and LTP on a semi-annual basis.Performed detailed fundamental analyses on impacts on Capital Power’s assets and financial performance of various government environmental policies and regulations as well the Ontario Independent Electricity System Operator (IESO)’s Market Renewal Program.Highlights of technical skills involved: created complex SQL queries to extract and manipulate large datasets from various databases; developed a Python-based model to forecast the imputed gross margin for Capital Power’s thermal assets; used EXCEL VBA to fully automate the optimization of battery economics in the real-time and day-ahead market, and automatically generate daily settlement analysis and summarize results for Capital Power’s thermal assets.

Delivered long-term conventional oil and natural gas production and drilling activity forecast for the annual provincial budget forecasts and quarterly updates.Conducted economic evaluations for conventional oil and natural gas royalty program applications.Calculated Alberta Capital Cost Index (ACCI) and engaged in industry consultation on an annual basis.Provided data, research, and in-depth quantitative analysis for ad hoc requests from internal and external stakeholders. Led or engaged in various key projects and cross-branch/ministry coordination and communication by providing analytical support, e.g., C* (drilling and completion cost allowance) recalibration, gas royalty deposit, municipal tax review, methane emission abatement regulation, Critical Mineral Royalty Review, and CCUS development for oil sands projects.

Independently developed regression-based forecast models for conventional oil and gas production and drilling activity, and Python-based models for ACCI calculation and royalty estimation for different hydrocarbon products.Led the development of Alberta’s Activity and Competitiveness Report and the C* recalibration project and engaged in cross-branch or cross-ministry coordination and communication to resolve issues related to the project.

Conducted economic evaluations for oil sands project applications.Independently developed multiple cash flow models for the evaluation of applications for different royalty programs and conducted economic evaluations for numerous projects.Assisted in Energy Diversification Advisory Committee (EDAC)’s evaluation of an integrated refinery/upgrader-petrochemical complex in Alberta in 2017 by providing analytical support and cost-benefit analysis for multiple refineries and petrochemical projects.

Conducted economic evaluations for oil sands project applications.Provided monthly updates for oil sands royalty rate, Bitumen Valuation Methodology (BVM) components, and the long-term bond rate.Provided research and analysis for ad hoc requests from internal or external stakeholders. Contributed to the 2016 royalty review process by providing analytical support, e.g., ran regression analysis to calibrate the drilling and completion cost allowance (C*) formula for conventional oil and gas, formulated the C* multiplier for multilateral wells, and provided analysis and write-up for the new Enhanced Hydrocarbon Recovery Program.

Delivered long-term power price forecasts for Alberta and the US Northeast markets twice per year using AURORAxmp.Designing and conducting scenario/sensitivity analysis to assist the cross-functional teams in assessing market conditions using AURORAxmp and other tools.Cooperated with team members to enhance the AURORAxmp model by adopting new functionalities, developing better assumptions, and performing various tests and analysis.Recognized the inefficiency and error-proneness in the old assumption-entering process. Designed a new Excel input template that incorporated all the key assumptions and standardized the format for inputs. Created AURORAxmp input templates that simplified the process of transferring assumptions from Excel into AURORAxmp. This improvement considerably reduced the time spent on collecting and inputting assumptions from multiple to less than one day and eliminated potential errors and confusion.Developed econometric models to improve the forecast accuracy and efficiency of the AURORAxmp model, e.g., isolated Alberta by modeling its flows with neighboring regions externally using an ARDL-GARCH model. The forecasted flows were then inputted into AURORAxmp as a time series vector and then adjusted in case of supply shocks. This improvement reduced the turnaround time by 3/4 and allowed for more efficient analysis of data and results. Achieved and exceeded the efficiency targets set for all the markets in the Northeast model in less than one year after taking over the position.

Prepared and implemented class lesson plans for 3rd year undergraduate classes with 50-60 students. Communicated with students one-for-one after class to help them understand economic concepts and prepare for exams. Adjusted the content and structure of the lectures and the teaching methods according to feedbacks from the students. Successfully resolved issues of student plagiarism and/or cheating while still adhering strictly to university policies.

Developed and conducted comprehensive computer labs for undergraduate and graduate students for four semesters. Utilized relevant statistical software to complete weekly lab assignments, and showed students in class the methods and techniques for the successful completion of assignments. Assisted supervisor in collecting and compiling data and ran preliminary regressions using software such as STATA and SHAZAM for her research.