Work History

Work History
Sep 2013 - Present

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 2011 - Sep 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 2007 - Aug 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

Education
Aug 2006 - Dec 2007

MBA

Lamar University

Concentration in Financial Management

Skills

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