Learn Data Skills
Beta
Aaron Bauer

Aaron Bauer

Financial Analyst

EQT Corporation

Technologies

My Portfolio Highlights

My New Course

Understanding Data Science

My New Workbook

PostgreSQL Summary Stats and Window Functions

My New Course

Understanding Data Science

Data maestro, orchestrating analytical melodies for data-driven decisions.

My Work

Take a look at my latest work.

course

Understanding Data Science

DataLab

Analyzing unicorn company data

DataLab

PostgreSQL Summary Stats and Window Functions

course

Understanding Data Science

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Understanding Data Science
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

EQT Corporation | Nov 2023 - Present

Lead Business Specialist - Commercial Strategy

N/A

EQT Corporation | Aug 2020 - Oct 2023

Lead Business Specialist - Corporate Finance

• VBA: Developed several macros used in our corporate model. One of these, triggered by closing the file, automatically logs key changes made (along with a name/file/time stamp) with a delta of key metrics to the last saved version. Another example is a macro that changes the view and print settings of our key output data based on the intended user (i.e. high level for the BOD or more detail for other users) with the click of a button. • Dashboarding/BI: Customized workflow dashboard and built reports in Salesforce. Currently creating extensive financial dashboard in PowerBI. • Capital Allocations: Key analyst supporting the decision and execution of our comprehensive capital allocation strategy including fixed dividends, debt, equity repurchases, and ongoing analysis of shareholder returns. • M&A Analysis: Modeled various scenarios and provided pro forma forecasts to the executives and advisers resulting in our $8bn acquisition of Rice Energy in 2017. Assessed the accretion/dilution effects and corporate impacts of various upstream and midstream asset purchases. Provided similar analytical support for other acquisitions including Chevron Appalachia (~$1 bn value), Alta Resources (~$3 bn value), and Tug Hill & XcL Midstream (pending FTC approval; ~$5 bn value). Built a merger model to quickly evaluate combinations with a list of peers.
Show More

EQT Corporation | Aug 2017 - Aug 2020

Senior Business Specialist

• Corporate Planning: Created a comprehensive forecast charts model, which compares multiple scenarios, to generate slides regularly used in communications with the executives, the board of directors (BOD). • Financial Modeling: Managed or co-managed the company’s corporate model for four years. Duties included updating the forecast, running sensitivities, evaluating corporate impacts of transactions, building out functionality, and improving model efficiency. • Executive Communication: Led the company Business Plan coordinating with the business units’ FP&A functions. Presented the Plan to the executives who in turn presented to and received approval from the BOD. • Competitive Analysis: Ran various decision analysis projects for the CEO/ CFO on an ad hoc basis. • Valuation: Analyzed and presented alternatives for monetizing the general partner of EQM. Produced a DCF valuation model, shared with the banks, ultimately resulting in the IPO for EQGP ($7bn valuation, $700mm in proceeds). Also constructed a valuation model used to estimate returns for midstream business development opportunities (some being > $100mm). • Capital Markets: Managed the due diligence process for multiple bond offerings including a recent $1.8bn issuance. Conducted make-whole premium analysis and provided support for $1.5bn in redemptions. Analyzed financing options leading to a $1bn term loan. Other capital markets responsibilities included cost of capital and liquidity analysis, MLP distributions, and credit ratings.

EQT Corporation | Feb 2016 - Aug 2017

Business Specialist

N/A

EQT Corporation | Aug 2014 - Feb 2016

Business Analyst

N/A

EQT Corporation | May 2014 - Aug 2014

MBA Intern

N/A

KKR | Jun 2011 - Jul 2013

Manager

Manager, 2013 Senior Accountant, 2011 - 2012 • Cash Management: Reviewed daily liquidity with treasury and initiated capital calls/distributions totaling more than $1 billion in cash flows for 16 private equity funds. • Leadership: Led communications with our accounting administrator, based in India, which provided accounting services, investor reporting and support for our data analysis of our alternative investment funds. Leveraged the administrator to produce high quality deliverables within tight deadlines for our regular discussions with the CFO. • Analytical Skills: Prepared analytical presentations on fund performance for senior management. Topics included updates on deployable capital, compliance with investment mandates and key metrics such as IRR.

Rothstein Kass | Oct 2007 - Jun 2011

Senior Associate

Senior Associate, 2009 - 2011 Associate, 2007 - 2009 The company is now part of KPMG Leadership • Managed engagement teams performing financial statement audits including budgeting, planning and reviewing work performed by staff. Communicated with hedge fund managers, brokers and attorneys. • Led the audit of an energy hedge fund client which had more than $2bn in assets under management. • Recruited, trained, supervised and evaluated 10 other professionals. Analytical Thinking • Recalculated investor economic allocation models to ensure proper allocation of P&L items to hundreds of investors (both institutional and high-net-worth individuals).

vSpring Capital | May 2006 - Jul 2006

Summer Intern

Venture capital firm now known as Signal Peak Ventures. • Financial Analysis: Improved the financial forecast of one of the firm’s technology portfolio companies. The forecast was used by the executives and capital providers for a $10mm Series B round of financing.

My Education

Take a look at my formal education

MBA in Strategy, Finance, Organizational BehaviorCarnegie Mellon University - Tepper School of Business | 2015

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free