Operational Modeling and Data Analytics Leader

Geoffrey T. Brooks

**** *. ******** **. ********, OR 97203

**********@*****.*** 503-***-****

US Citizen

Professional Profile

Ten years’ experience in operational modeling, analysis, monitoring, reporting and compliance with data requests and reporting

Experienced in risk analysis, monitoring, reporting and management

Ability to manage and prioritize multiple tasks and projects easily and efficiently

Strong conflict resolution and negotiation skills to build consensus

Ability to identify, analyze and implement process and procedure improvements.

Skilled in data base management, using Endur, ZaiNet Aligne, WebTrader, SQL, and Access Create data bases through primary and secondary data collection, including multiple statistical analysis programs, transferring, importing, merging data in from a variety of formats and programs while maintaining data integrity

Skilled in statistical, modeling and coding programs, including SPSS, Matlab and Aurora, VBA (Visual Basic for Microsoft), SPSS, C#, and C++

Develop technical reports for company executives, including data collection and analysis, researching root causes of variances, and translating technical data into clear and concise messages and results

Experience in research design, research writing, pretesting, surveying, content analysis, field research, primary data gathering, and secondary data acquisitions

Experience in statistical analysis (confidence intervals, significance, Uni-Variant / Multi-Variant analysis, analysis of variance (ANOVA), Chi-square test, correlation, factor analysis, as well as Mann- Whitney U.)

Professional Experience

Net Power Costs Specialist (E16) / March 2021 to May 2023

PacifiCorp / Portland, OR 97232

Hrs. 45+/wk; $109,000/yr up to +12% Bonus

Ramon Mitchell, 503-***-****, you may contact

Duties:

Develop regulatory filings, including testimony, exhibits and supporting documentation

Compile data while maintaining data integrity into workpapers and reports

Prepare & defend Net Power Cost in regulatory filings, including general rate cases, transition adjustment mechanisms and power cost adjustment mechanisms

Prepare and analyzed production cost model simulations utilizing Aurora model, both for internal use and for distribution to external parties as part of regulatory filings.

Prepare and analyze production cost model simulations utilizing Aurora model, both for internal use and for distribution to external parties as part of regulatory filings

Responsible for Aurora model maintenance, including maintaining current resource attributes and updating data series inputs

Analyze and validate the impact of changes to modeling inputs and support changes to department management

Research relevant data, evaluate complex situations, develop creative alternatives, provide recommendations to management, and negotiate and influence outcomes

Assist in representing and supporting the company’s Net Power Cost initiatives to regulators and their staffs, key community and customer groups, and other company departments

Prepare and review final responses to Discovery Requests

Interpret rules and regulations to internal and external parties

Provide regular reports on pending and anticipate activities to my supervisors

Risk Manager / April 2011 to July 2019

Avangrid Renewables / Portland, OR

Hrs. 40+/wk; $53,040/yr

Koo Dickson, 877-***-****, you may contact

Duties:

Over 8 Years of Operational Analysis and Compliance Reporting through Daily Position Report, Daily Position email, ad-hoc reporting for violations of Risk Procedures

All Reports including Daily, Monthly, Quarterly, Yearly, and Ad-Hoc processes must be continually updated & periodically rebuilt as I find more efficient ways to structure the reporting processes.

Monitoring of power and gas positions against risk policy limits

Monitored proprietary trading Profit & Loss against monthly and annual stop-loss limits

Monitored the tenor of the trader’s positions against the Delegation of Authority limits

Monitored the trading instruments used against those allowed in the Delegation of Authority

Completed daily check of deals (etags / zkeys) for compliance with Delegation of Authority and risk procedures for the notional value of renewable energy credit deals and the overall positions of the renewable assets

Reviewed and presented accrual data to back office at the beginning of each month

Created and maintained Position Reporting for Origination for California Bucket Deals (REC Reporting Carbon Credits (Bucket 1 & Bucket 2))

Reviewed reconciliations of broker data to Avangrid Renewables data for financial controls

Entered cash adjustments for Settlements department

Performed reconciliations for FERC EQR (Total Company Quarterly Generation).

Provided ad-hoc reports as needed as needed for execution consumption or operational decision-making

Earlier Professional Experience & Achievements

Momentum Marketing Intelligence SPSS data Analysis and Integration with SQL database, and MS Excel dynamic reporting.

Consumer Opinion Services work focused on marketing data collection/data-cleaning/consolidation and reporting. Supervised up to 8 team in offsite data collection. Verified accuracy of team data.

Key Professional Development

Certifications from Northwest Power Pool:

oEIM 101: Overview of the CAISO Energy Imbalance Market

oEIM201: Balancing Area Operation within the CAISO EIM

oEIM 202: EIM and the NWPP Reserve Sharing Program

oTransmission Service

oInterchange Scheduling

oSpace Weather

oSystem Protection 101

PacifiCorp Training:

oControls 101

oUnconscious Bias

oIntroduction to Electric Utility System

oRisk Management Policy Review and Certification

oFERC Standards of Conduct

oEquipping Bystanders

Energy Exemplar; Aurora Core Certification

Education

Bachelor of Science in Sociology, Portland State University, Portland, OR

Technical Skills

Software

oMicrosoft Office

Word

Excel (advanced skill)

Macro

Data Importing & Formatting

Power Pivot & Pivot tables

Indexing, lookups, if statements, …

Graphical representation of Data

oTables, Charts, …

PowerPoint

Outlook

MS Teams

Access

oEnergy Exemplar

Aurora

Model Setup

Data Inputs

Data Extracts

oIBM

SPSS

Statistical Models

Plotting

Mapping

oMatLab

oSharePoint

o Endur

oZaiNet Aligne

oWebTrader

Coding

oVBA (Visual Basic for Microsoft)

oC#.Net

oC++

ohttp

Contact this candidate