Management Analyst

BRENT SAMUEL

**** ***** ***** *** * Duluth Georgia 30096 Cell:804-***-**** **********@*****.***

EXECUTIVE SUMMARY:

Progressive combined experience over a period of 10 years in advanced financial modeling, access database creation, vba

programming, hedging and risk management, portfolio management, commodity trading, verbal and communication

skills, dealing with a variety of counterparties, staff members and employees. Self-motivated; relish taking the initiative

and efficient at setting challenging priorities and take instant decisions and apply them to meet given deadlines. Adjust

easily to innovative concepts and tasks.

HIGHLIGHTED SKILLS:

Complex financial modeling and forecasting Hedging and risk/loss management

Budgeting and variance analysis Financial reporting and analysis

Creating multiple Excel based macros to embedded for reports and analysis

COMPUTER KNOWLEDGE:

Advanced knowledge of Microsoft Office Suite

Advanced modeling skills using Excel for business applications

Advanced Database creation and management skills using Access for business applications

Functional knowledge VBA Programming

SQL programming knowledge for data base queries for generating reports

Experience with OBIEE, Hyperion Essbase, SAP and Oracle structures

PROFESSIONAL EXPERIENCE:

October 2013– February 2014

Forecasting Analyst. Verizon- Contractor

Atlanta Georgia

Forecasting

Responsible for the retrieving of data across functional groups to construct the template structures for various forecasting

models.

Projects and Achievements:

• Re-engineered multiple spreadsheet forecasts into one multipurpose cross functional document that updated

automatically

• Designed various queries in OBIEE and extracted the data and allowed for automated report generation.

August 2012– September 2013

Procurement Pricing and Forecasting Analyst. RockTenn Company

Atlanta Georgia

Price Control and Forecasting

Responsible for the designing, developing and maintaining the Access database for centralizing the price control function

for the entire company. Heavily involved in creating the process through which all the companies purchasing prices are

verified and loaded into the system of record and part of the team that successfully achieved $47 Million of cost saving.

Working with Analytics, Category managers and Pricing control group on the process of taking items from the RFP stage

through being maintained and updated in JDE

Projects and Achievements:

- Manage a constantly expanding portfolio of products/commodities controlled by the Strategic Procurement group

and maintain internal control of all prices and contractual price changes within a database currently encompassing

60,000 individual items and 84 different vendors

- Responsible for the forecasting for all the natural gas usage and electricity consumption for that vast majority of

our mills and plants.

- Responsible for managing pricing terms and price triggers within legal purchase agreements and create product-

specific models to generate expected price movements and monthly price forecasts

- Responsible for researching supporting materials for any pricing changes including contract pricing tables, market

indices, communication with suppliers and Category Managers and ensure materials are properly documented and

filed

- Ensure all approved pricing changes are effectively communicated, uploaded to the purchasing system and

accurately reflected in forecasts/budgets

- Maintain a calendar of contractual pricing dates as well as contract renewal dates, and ensure that each date is

addressed by the Category Managers and all systems are updated appropriately

- Conduct research on key supply markets using full-spectrum of information sources market indices, on-line

databases, print sources, trade associations, and supplier information as inputs and supplemental data for pricing

forecasts

- Generate monthly price forecasts and annual price budgets for submission and upload to Hyperion

October 2011– June 2012

Senior Enterprise Risk Analyst. Enterprise Risk Management, Alpha Natural Resources

Bristol, Virginia

Enterprise Risk Management

Responsible for the management of the company wide Enterprise Risk system. Involved in the setting of the risk

thresholds, constantly monitoring and updating risk metrics, and alerting senior management when thresholds were being

approached and involved in the development of strategies to mitigate risks. Supported the Hedging department for the

company wide hedge program.

Projects and Achievements:

• Sole responsibility of the risk management system and implementation of the CURA risk software, taking it from

the testing phase into the production phase.

• Building out and maintaining the database for all the Enterprise Risk Management, worked with the various

department heads in quantifying risk, setting metrics and developing the risk thresholds for the entire company.

• Developed extensive financial models through which data for all the departments were analyzed and risks were

quantified and mitigated.

• Executed transactions for the hedging program for the diesel, jet fuel, explosives and natural gas portfolios,

maintained the databases for tracking the transactions and maintaining the mark to market exposure reports.

August 2011 – October 2011

Financial/Business Analyst II. Mckesson, Medical Surgical. Six Sigma Group . Contractor

Richmond, Virginia

Financial/Business Analyst

Responsible for creating various reports and presentations for sales managers. This included running the SQL queries,

analyzing the data and preparing the item analytics and storyboard presentations.

Projects and Achievements:

• Produced various cost saving sale presentations for sale managers

• Ran the various queries in SQL and extracted the data and compiled various reports.

• Utilized various data sources to complete item analytic cost saving measures by generating reports designed to

improve the cost basis of products McKesson offers and distributes.

October 2002 – June 2011

Financial Analyst. Dominion Retail Gas Operations, Dominion Resources, Inc.

Richmond, Virginia

Trading and Portfolio Management

Responsible for the daily management and operation of a Local Distribution Natural Gas Pool. Dealt with the

appropriation, scheduling and financial transactions in attempts to optimize the value and efficiency of the assets in the

Pool.

Projects and Achievements:

• Produce and maintain margin forecasting and risk position reports

- Daily valuation and reporting on all natural gas physical and derivative positions

• Executing all the planning, gas procurement and trading for those market areas approximately 120,000 natural gas

customers in Ohio, and Pennsylvania.

• Primary point of contact between Retail Gas Operations Group and Enterprise Risk Management Group for issues

on trade, position, and valuation changes

• Re-engineered and automated Margin Forecast Report, reducing report production time from 3 days to 2 hours.

• Primarily responsible for the majority of reports generated for monthly gas accounting closing reports.

• Exclusive management of the monthly process for updating Dominion Retail Gas Operations book of business for

all of our customer base fluctuations.

• Interacting with the marketing department and translating and analyzing customer changes as it affects and drives

the future revenue streams.

• Responsible for updating and analyzing Dominion Retail’s Natural Gas Storage portfolio; capturing and

evaluating the financial impact of all of the groups’ storage related activity and the affects on the group’s daily

mark to market valuation and risk position.

• Extensive presentation experience to senior management, including other business units.

• Technical training, development and mentoring of team members.

February 2002 – May 2002

Associate Gas Accountant, Texas Utilities. Oncor Group

Dallas, Texas

Natural Gas Accounting

Worked in the Gas Accounting group recording monthly transactions to the general ledger. Provided timely information

for the reconciliation of various accounts to daily gas purchasers. Worked on the development of systems to analyze,

reduce and account for Lost and Unaccounted for Gas (LUG). Responsible for overseeing all of the accounts receivable

that runs through the FIM Accounts Receivable module for the LSP (pipeline) business segment. Reconciliation of FIM

A/R module accounts to general ledger accounts and month estimates and current month actual figure for natural gas

volumes in industrial purchases and storage.

Projects and Achievements:

• Weekly system monitoring to ensure that FIM Account Receivables tables are in balance and that

invoices/deposits have posted to the general ledger.

• Run system queries/reports and analyze receivable activity. Reconciliation of receivable accounts on the general

ledger.

• Assist in the analysis, reconciliation and reporting of current daily activity recorded in the cashbook to provide

senior management and the trading front office daily updates.

June 2001 – December 2001

Financial Analyst, Enron Energy Services (EES)

Houston, Texas

Deal Management, Underwriting and Structuring.

Structured energy deals involving Natural Gas and Electricity, including modeling deals with customized structures.

Responsible for analyzing and formatting raw data in structures. Provided accurate timely information on a daily basis to

the Risk Analysis group that dictated the positions Enron traders take in the energy market.

Projects and Achievements:

• Developed Structures for over $2,283,895 worth of Power and Natural Gas deals and closed $ 345,845 worth of

margin on deals that involved 904,890 MWH of electricity.

• Part of the group that was responsible for the daily updating and management of structured Energy deals.

• Developed and maintained a pricing matrix for Industrial and Manufacturing Mid Market customers.

• Cultivated relationships with upstream and downstream organizations, including originators, legal representatives,

credit analyst, risk analyst and commodity analyst.

EDUCATION:

MOREHOUSE COLLEGE: Atlanta Georgia. B.A Degree awarded May 2001, majoring in Finance.

Contact this candidate