Prepare daily reports for pricing trading dataEnsure accurate pricing dataCreate Excel reports for Mid and Back officeUse Endur Trading Platform

Aided different departments in creating budgetsReported monthly differences to budget and forecastsAided departments in changing forecastsCreated models as needed for different Utility issuesAided with data requestsRan and updated models as needed

Created models to forecast natural gas demandCreated models to calendarize natural gas usageUpdated monthly financial models

Built statistical models to forecast monthly natural gas usage to within 2% margin of error Created long term budgets for capital budget planning Updated calculations of demand billing units from state mandated tariffsDeveloped, monitored, analyzed, and communicated budget and forecast information Aided in fulfilling data requests ensuring compliance with regulatory agencies Provided data, information and analyses for rate cases and rating agencies Created analyses to determine reasonability of weather hedges

Ad hoc statistical queries and analysis of data. Created and ran regression models to analyze pricing tests.Used SAS to pull data from database to analyze.

Evaluated and ensured correct accounting of structured transactions for traders Executed and evaluated daily asset management models; updated with new data as needed Ensured pricing and evaluation of transactions were performed to the satisfaction of the Marketing group Created and updated daily reports for trading group to track budgets Interacted with Information Technology group to create reports as needed for traders

Reviewed and updated Value @ Risk models for energy and energy related commodities Ensured daily Value @ Risk model outputs were within operational boundaries Interacted with Marketing, Legal, Structuring, Mid- and Back-Office groups as needed to review Structured Transactions; aided in mark to market and market to model accounting of transactions Involved in identifying and quantifying risks associated with Structured Transactions Reviewed models (including simulations, options pricing tools, and asset models) on a continuing basis; ensured updates were accurate Interacted with Project Development and Research teams to keep informed about new and developing projects and products Integrated statistical models into existing systems, evaluated insurance/reinsurance products, built various risk models using MS Excel and Visual Basic

Designed and developed logistics - supply chain and routing - systems for clients (Europe and U.S.), using customized programming language Trained users to use logistics systems, aided in tracking budgets for projects, transitioned custom software systems to central support Developed, maintained, and updated logistical software applications Aided testing, support, and training (internal and external) to learn new software