Lauren C. Hinton, MBA
**** ***** *******, **** **** - Chicago, Illinois 60610 - 708-***-**** – ********@*******.***
SUMMARY
Experienced Financial Analyst looking for a finance role in a fast paced, growth environment. Experience includes areas
of corporate strategy, corporate finance, operations and sales. Experience in business model and scenario building,
forecasting revenue streams for multiple products, compiling sales metrics and disseminating customer data in user-
friendly format. Recent experience includes conducting in-depth industry research and disseminating trend information to
executive leadership. Strong PC/spreadsheet, multi-tasking and organizational skills, and proven ability to deliver results
under strict deadlines. Enjoy being a member of a strong team with the ability to work independently.
SKILLS
• • •
Industry Trend Research Database Management, Testing Process Mapping and
• and Development Improvement
Forecasting/Trend Projection
• •
• Sales Reporting Tool Logic Business Case Building, New
Financial Model Development
Development Market Development
• Revenue and Gross Margin
• •
Metrics Reporting Variance Analysis
Reporting
WORK EXPERIENCE
Exelon Corporation, Chicago, IL
Senior Strategy Analyst, Corporate Strategy Group - Sept 2008 – Present
Support analysis and development of strategic issues and options
o Collaborate with team to prepare materials for executive review on trends or advances within the energy
industry that have potential to affect the organization
o Perform quantitative modeling and analysis on long-term costs of new and existing technologies
o Develop / maintain relationships with subject matter experts throughout the organization to determine
possible impacts of different strategic directions
Survey external industry data and stay current on industry trends / developments of
importance to the company
o Follow multiple industry dailies, papers, and blogs to keep advised of current events
o Stay current on new company or industry reports issued by major research institutions and sell-side analysts
Constellation NewEnergy, Chicago, IL
Finance Associate, Strategic Finance Group - Aug 2007 – Sept 2008
Build business cases for new products and entry into new markets
o Forecast revenue streams, market share, cash flows, and operating expenses
o Run multiple scenarios and summarize results to assist senior management with decision making process
Core Finance support contact for different product lines, including new Sustainability
product group (Renewable Energy and Demand Response Programs)
o Compile quarterly sales and expense forecasts
o Complete detailed G&A monthly variance analysis
o Provide support for any adhoc strategic finance requests
Create reporting logic for new company wide sales reporting tool
o Work closely with programmers to offer business person support to reporting requirements
Finance Analyst, Regional Finance Team - Jan. 2005 – Aug 2007
Provide quarterly financial forecasts to corporate finance team, reporting more than $1
billion in annual revenue for more than 10,000 customer accounts in three states
Compiled weekly sales metrics and sales team scorecard, including gross margin and
volume sold
Built dynamic revenue forecasting model currently utilized in quarterly forecast process
Lauren Hinton Resume Page 2
Streamlined gross margin forecasting process from cumbersome manual spreadsheet model to dynamic
o
web based model
Administer development and maintenance of automated revenue forecasting model
o Main business contact during development of forecasting model, included mapping all product’s revenue
streams, all relevant contract information and verifying account usage information
o Manage data flow used in financial reporting and revenue forecasting for all accounts, contracts, and prices
on a daily basis
o Revenue forecasting subject matter expert on major systems implementation project (Accenture)
Run various budget scenario reports due to changing market conditions
Prepare thorough month end financial reports, including revenue and cost reporting
Created Dashboard report utilized by region leaders to track progress of business and assist in
decision making process
Operations Analyst - Sept. 2004 – Jan. 2005
Handled Utility Accounts Payable, $1,000,000+ payable daily
o Streamlined Accounts Payable process from 3 hrs/day to 30 min/day process
Provided support to all areas of Operations staff in order to understand and master all tasks
related to the successful billing and collection of customer accounts
Consulted on processes within the Operations Department in order to improve efficiency
Account Manager - Aug. 2003 – Sept. 2004
Managed 4 person sales team, supporting 1,300+ customer accounts
Analyzed pricing outputs, which include margin levels, pricing term, and usage data, before
explaining and communicating pricing to customers
Prepared forward electric budgets and historical savings analysis for customers with
multiple accounts, which resulted in sustained customer satisfaction and business
Managed incoming broker invoices for my sales team and oversaw multi-step process to payout, which included
checking usage data, contract dates, and terms, as well as the confirmation of broker agreements
Handled customer care calls and obtained resolution on a variety of issues with appropriate manger and/or department;
this involved working with multiple departments
Participated in a multi-departmental Customer Relationship Manager (CRM) Task Force that focused on process
improvement, resulting in numerous enhancements in the cash-to-order process of, and relating to, the CRM database
EDUCATION
DePaul University, Chicago, IL
Masters of Business Administration, with Distinction - June 2007
Concentration in Finance
University of Illinois, Urbana-Champaign, IL
College of Business, Bachelor of Science in Finance – May 2003
ADVANCED COMPUTER SKILLS
Microsoft Office, Word, Excel, Access, and Power Point; Hyperion (OutlookSoft)
ACTIVITIES
LaSalle Private Residences, Board Member – January 2009 - Present
• Member of eight person condo board in 230 unit building
• Help manage $1,000,000+ annual budget