Gary Galow

**** ********** **.

Macungie, PA ****2

484-***-****

acerf9@r.postjobfree.com

SUMMARY:

Successful analytics professional with proven track record of delivering results and exceeding expectations. Achieved over

$100,000,000/annually in increased profits/revenues by exploiting opportunities in the data. Knowledgeable in regression and

time series analysis, data mining techniques, programming, and data warehouse management. Experienced manager

comfortable with building new departments and growing existing departments as well as mentoring and developing

employees.

WORK HISTORY:

PPL EnergyPlus August 2011 – Present

Manager-Business Analytics

• Manage group consisting of analysts and programmers: supervise employee development and budgeting

• Developer of Market Analytics function

o Designed and oversaw development of market analytics report portfolio

Primary tools for Executive and Marketing staff

• Automated desktop tools that update in real time

o Analytics have increased profitability $2,000,000 annually

• Co-leader of multi-departmental pricing analytics initiative with Marketing Staff

o Driving organization toward new pricing philosophy

Devised pricing protocol that aided in growing business and profitability

Authored optimized pricing program to target profitable customers using regressions and campaign

data

• Duties, responsibilities, and areas of influence

o Maintain and update variety of databases, queries, and tables (Oracle, Access)

o .NET and cloud computing training. Programming in VBA.NET and C#.NET

o Automating all reports to update in real time (VBA, Excel, .Net)

• Notable analytics accomplishments

o Originate and maintain in-house data mining and nonparametric models

Including neural network, non-parametric regressions (Gaussian regression), frequency

decomposition, cluster analysis, support vector machines

o Developed pricing tools to optimize corporate pricing capabilities

Historical pricing model – establishes historical accuracy of pricing methods

• Analyzes pricing accuracy by component and by customer type

Vector Autoregressive spot pricing model

o Created customer analytics program

Find trends and patterns to profitably exploit in market data

Search company data to project customer retention utilizing regression analysis

o Econometric Analyses of pricing data

Consultant May 2009 – August 2011

• Provided consulting services in forecasting, quantitative analysis, database management, and risk management

• Created demand forecasting model for electricity trading company

o Econometric model combined system and economic factors to forecast demand

o Forecast included error bands and economic analysis of errors

Econometric model finds economically optimal demand forecast

Gary Galow acerf9@r.postjobfree.com 484-***-****

o Designed several trading models

Built virtual trading model using factor analysis and vector autoregressive model

o Built Principle Components Analysis (PCA) trading model to trade commodity futures for Hedge Fund

o Worked with corporate management to build new risk management and analytical functions

Development of risk management plans, procedures, and protocol

• Quantified risk management requirements using state-of-the-art analytics

Uses regression analysis to determine trading opportunities

• Contracted with Intelometry to consult and install company software for third party clients

Alliant Energy Madison, Wisconsin Oct 2006 – Apr 2009

Manager - Hedging Strategies

• Built analytics and programming operations. Created $100,000,000 annually in increased profits.

o Increased programmers’ productivity by integrating function into business process

• Developed daily market analytics report and related meeting. Increased profitability by $10,000,000 annually

• Drove significant increases in profitability through analytics

o Optimized Alliant Energy’s participation in the Day Ahead (DA) MISO market for generation assets. Have

increased Alliant Energy electric profits by $30,000,000 annually.

Built econometric/time series supply/demand forecast. Identified driving market factors for valuation

Designed user-friendly spreadsheet model to aid traders in implementation of strategy.

o Developed ARR/FTR program that brings $25 million annually to shareholders.

Implemented SAS model which developed a strategy that maximizes expected profit for a given risk

o Structured product and oversaw development of wind generation bidding strategy, regression model, and user

interface to optimally bid wind into DA model saving shareholders $5 million annually.

• Notable achievements

o Managed Risk Management for electricity and natural gas. Ensured compliance and optimized position.

Performed day-to-day hedging operations to maintain compliance and optimize position.

• Added $15,000,000 in profit without increasing risk

Built and automated reports from risk database (SQL, VBA, SAS)

o Built Supply/Demand forecasting model used for “what-if” analysis

o Championed new database warehouse project

Designed specs and initial layout for database

Worked with vendors to ensure on-time completion of project

o Obtained Lean Six Sigma Green Belt Certification

NextEra Energy, North Palm Beach, Florida Jan 2002 – Sep 2006

Manager-Modeling and New Product Development

Manager-Valuation and Structured Products

• Managed a staff of professionals including PhDs and quantitative analysts

o Handled quantitative modeling, development, upgrades, and maintenance, Sarbanes-Oxley reporting

• Group priced 2,000 wholesale deals annually and 200 retail electric RFP/auction bids annually

• Led several large acquisition studies ($100,000,000 +) including physical assets and financial contracts

o Managed data and presented results to executive steering committee

• Created indicative pricing model used by Origination staff designed for speed and ease of use

• Led product development effort as well as developing models for pricing and risk management including barrier options,

fixed price guarantees and portfolio generation guarantees

• Designed and developed models to improve returns and risk reporting including:

o Ad-hoc analyses for both electricity and natural gas

o Development of quantitative trading strategies

Gary Galow acerf9@r.postjobfree.com 484-***-****

Enron Corporation, Houston, Texas Jan 2001 – Dec 2001

Manager-Utility Risk Management

• Co-Developer of Retail Price Index

o Provided values and commentary to market

• Co-Developer of Hedgemaster

o First risk management service for utilities and load providers

• Built and implemented efficient rate frontier model

o Identifies significant pricing/costing components (factor model)

Targets customers to lower portfolio costs and increase portfolio profit

Identifies customers in danger of becoming more expensive to serve

o Identifies most significant customer characteristics to manage profits

• Developed visualization software for rate frontier model

o Graphically displayed difficult concepts to facilitate understanding for executives and customers

• Co-Leader of 20 person group managing multi-billion dollar retail electric portfolio

o Created base product menu

• Managed 5-person group that owned the Interest Rate Hedge model.

o Automated and expanded the model logic to be more accurate and user friendly

Integrys Energy, Green Bay, Wisconsin Jan 1993 – Jan 2001

Senior Quantitative Analyst/Senior Economist

• Creator of Integrys’s load forecasting system (SAS). Short-, medium-, and long-term modules satisfy all of Integrys’s

forecasting needs. Used for generation build and dispatch decisions; accuracy of forecast significantly improved fleet

profitability. Forecasts have been accepted into testimony in rate cases and Advanced Plan process.

o Critiqued by outside consultant who concluded the models are “sophisticated and very accurate” and are

“intellectual property that have value for external consulting purposes”.

• Original member Risk Management Oversight Committee. Led company into unregulated markets.

o Established analytical, trading, and risk management protocols for unregulated operations

o Monitored compliance and reported to executive staff and Board of Directors

• Built analytics for Demandside Management (DSM) programs. Enabled Integrys to surpass state goals

o Built nested probit (discrete choice) model to forecast participation rates

o Built logistic regression model that uses product attributes and DSM data to forecast market share

Published paper on methodology and presented at a national conference

• Built cluster analysis (SAS) to differentiate DSM customer types

• Other accomplishments

o Created first ever market based rate for Integrys Energy customers

o Co-author of EPRI technical report. Report set national standards for generation care and safety.

o Worked with EPRI on FastForward pricing model; first ever electricity pricing model

Led process to link model to Integrys databases

o Worked with Northbridge Consulting on Real Option Valuation model for nuclear asset valuation

Used model on $100,000,000 generation repair/abandonment decision

• Other Analytics/Models

o Developed market-based Monte Carlo simulation methodology that is used to obtain market value of

projects

Bootstrapping method allowed model to keep important characteristics of data series

o Built econometric supply forecast using econometric methods (SAS)

o Built non-liner regression model for next day electric dispatch

o Valued derivative contracts for FASB 133.

American Family Insurance, Madison, Wisconsin

Gary Galow acerf9@r.postjobfree.com 484-***-****

Financial Analyst/Actuarial Analyst I / II August 1988 – December 1993

• Completed and published monthly and quarterly property/casualty loss reserve reports

• Designed and built earthquake damage simulation in @Risk

o Led survey of sample homes. Built database and entered data.

o Formulated conclusions and business plan. Presented results to executive and senior claims staff.

• Passed calculus and statistics actuarial exams

Graduate School of Economics, University of Wisconsin-Madison

Teaching Assistant August 1986 – May 1987

EDUCATION:

PhD Courses (Analytical Finance) – Econometrics (2 semesters), time series analysis, mathematical methods,

microeconomics, macroeconomics, current topics course (stochastic optimization and chaos theory), stochastic processes

M.B.A. – Finance / Investment Major, University of Wisconsin – Madison, May 1988

• Included: Advanced Financial Theory, Econometrics, Time Series Analysis, Contingent Claims Analysis, Stochastic

Processes, Investment Theory

B.A. – Economics and Mathematics Major, Macalester College - St. Paul, Minnesota, May 1983

• Included: Differential Equations, Calculus, Numerical Methods

Gary Galow acerf9@r.postjobfree.com 484-***-****

Contact this candidate