Download PDF

Work experience

Sep 2013Present

Senior Financial Analyst

Conn's

Models:

  • Roll Rate Model of Credit Portfolio
  • Credit Collections Staffing Model
  • Credit Granting Staffing Model
  • New Store 3 Year Projection Model to drive Board decisions on the new market locations
  • 5 Fiscal Year Projection Model for all locations to dynamically include new stores & closed stores
    • Includes Discounted Cash Flow valuations
    • Presented to Board of Directors and banks to verify covenants

General:

  • Facilitated analytics & data for:
    • Follow on stock offering, valued at $170MM
    • $250MM bond offering
    • Strategic Alternatives
  • Prepare presentations for Earnings call & Investor Relations website. Also prepared other reporting documents posted to IR website for call, & comprehensive sheet, by segment, of all pertinent data for previous 4 fiscal years. Prepare Financial Review section of the BoD book for each quarterly meeting

BI Implementation:

  • Developed and designed application for monitoring all incoming credit applications, by day, & tracking their progress through the system
  • Developed and designed application for retail end users that allowed view of sales data, including things like sales per square foot, by market, etc., & allowed the review of categories down to the invoice level
  • Developed several applications to replace manual reports that save, on average, 20 man hours per month
Aug 2011Sep 2013

Financial Analyst

Conn's
  • Develop financial forecasting models,including
    • Roll Rate Model of Credit Portfolio
    • Identified valuable customers in certain FICO bands that would drive interest income & reduce risk at lower levels than previously thought
    • Increase of over $1MM in additional revenue
  • Developed Excel sheet to validate the new algorithm & decisioning system during the roll out period
  • New Store 3 Year Projection Model to drive Board decisions on new market locations
  • 5 Fiscal Year Projection Model for all locations to dynamically include new stores & closed stores
  • Prepare presentations for Earnings call & Investor Relations website. Also prepared other reporting documents posted to IR website for call, & comprehensive sheet, by segment, of all pertinent data for previous fiscal years. Prepare Financial Review section of the BoD book for each quarterly meeting
  • Retrieve data from AS/400 system, analyze, & prepare for distribution
  • Prepare, review, and distribute regular financial analysis & reports to management
  • Developed credit incentive template that will save $25,000 per year in labor costs by significantly lowering time to completion
  • Lead Financial Analyst on team tasked with identifying and implementing a BIDW platform for enterprise
    • Reviewed solutions from multiple vendors and made recommendations to executive leadership
    • Identified data sources needed to be replicated in data warehouse and helped create ETL logic
Jun 2007Aug 2011

Financial Analyst

Catholic Diocese of Beaumont

Employs approximately 1000 people in eastern Texas with 52 parishes, 6 schools, and $25-50M in yearly revenue.;

  • Analyze processed financial information to determine present and future financial performance at both the Diocesan and Parish levels.
  • Analyze financial information detailing assets, liabilities, capital, revenue and expenses and other reports to summarize current financial activity and ascertain the accuracy of the data.
  • Direct preparation of studies, analysis and recommendations in areas such as budgets, forecasts, financial plans, governmental requirements, statistical reports and business forecasts.
  • Conduct financial analysis of trust funds and corporate funds as needed by Chief Financial Officer.
  • Problem solving and troubleshooting for the end users of accounting software and for the end users of budget models.
  • Written and oral reporting to the Chief Financial Officer regarding budgets, investments, and other ad hoc projects.
  • Internal audits of parishes - including verification of internal controls, accounts payable, cash control, risk management, and budget analysis.
  • Responsible for the installation and maintenance of the document archiving and management software which will be used to increase the productivity of the Financial Service, Accounting, and HR departments.
  • Created user manual for implementation of Employee "Dashboard" system to be utilized by all locations in an effort to centralize all data pertinent to employees.
  • Teach biannual course on Accounting and Donor Management software systems, and provide local technical support through the year.

Education

Skills

Microsoft Excel
Microsoft Word
PowerPoint
SQL
AS400
R
QlikView Development
Qlikview Designer
VBA
Modeling
Forecasting
Investor Reporting
Financial Reporting
Presentations
Financial Analysis
Budgets
Variance Analysis