Overview
Powerex is an energy trading company that trades electricity across WECC in the day-ahead and real-time markets, along with natural gas and environmental credits. I joined the Front Office Analytics team, where I built quantitative tools and analyses to support traders on the power and gas desks and helped manage the LCFS credit portfolio. This was a good chance to use my technical skills in a financial industry setting.
Technical Contributions
Financial Modeling & Automation
- Built Excel-based discounted cash flow models used directly in trading decisions.
- Automated forecasting workflows with SQL to cut down on manual spreadsheet work.
- Built a custom optimization solver to figure out optimal battery capacity by region.
- Put together ML models in Python for forecasting.
Trading Desk Support
- Streamlined scenario analysis workflows so traders could iterate on strategies faster.
- Integrated LCFS forecasting models into the desk’s regular workflow, improving decision-making speed.
Key Skills & Tools
- Software: Python, SQL, Excel, ML modeling.
- Finance: DCF modeling, scenario analysis, LCFS credits.
- Optimization: Battery capacity solver, forecasting automation.