• Tower Rent Expense

• Create 12-month liquidity forecast (~$30B in assets), create walks and variance analysis; present in Pre-ALCO meetings w/ GMF Treasurer – help prepare management for Global ALCO.

• Create monthly interest expense forecast for YE view, create walks, and explain changes to senior management.

• Produce and run securitization and other cash flow models that feed into the main forecast.

• Produce interest expense runoff; ~10-year outlook for GMF debt portfolio; feeds into GM 10K.

• Run monthly testing on floating securitizations to ensure it mirrors SOFR outlook.

• Assist in Long Term Planning (LTP) budget, create analysis and report liquidity positions, debt, and interest expense for 10-year outlook w/ GM.

• Prepare monthly servicer certificates for both private and public GM automobile leasing securitizations.

• Work with GMF structured finance team by interpreting lender loan agreements with new servicer certificates.

• Using TOAD Oracle SQL - confirm new deals are inserted in database, insert data from certificate for other teams to analyze.

• Completed projects:

  1. Created a VBA macro that automated the preparation of files - improved timeliness by 2 hours.

  2. Securitizations deal level analysis; created a report that consolidates securitization information, insert data into table via SQL, the table connects to SharePoint Power BI site for management to view. Closed interest expense variance by $9M; yearly interest expense on P&L is ~$2.8B. 

• Promoted to the ‘Corporate Finance Analyst’ role within 3 months of employment.

• Report directly to the VP/Treasurer; update the executive dashboards which include: capital structure, max fire power leverage and deployable cash forecast, M&A activity, corporate credit rating, debt structure, and other financial activities/analysis.

• Generate the weekly operating cash flow forecast and submit a detailed variance analysis. Improve and retest the forecast by spotting trends and comparing to FP&A.

• Perform financial statement analysis on potential project partners - assessing credit worthiness and analyzing any future FX currency swaps.

• Report the daily cash to executive management which summarizes both, current day transactions and provide a MTD liquidity position. 

• Review changes to the credit agreements and complete debt covenants for bank compliance. Calculate compliance EBITDA for current quarter and a pro forma forecast.

• Assist the treasurer in reviewing cash disclosures for the drafted 10-K/10-Q by confirming treasury activities and any impact to liquidity. 

• Assist trade finance by creating analytical summaries, accruals, and fee reconciliation on the surety bonds and the portfolio of L/C's.

• Execute month-end activities: prepare back-office settlements, exposure reporting, and trades for balance sheet hedges. Monitor changes and provide company-wide FX and LIBOR rates. Prepare reporting for the IR swaps and debt facilities.

• Completed projects:

  1. Redesigned the daily cash process and improved the timeliness by 4-6 hours.

  2. Created workflows using SharePoint and Nintex.

  3. Created a rolling 13-week liquidity forecast model and variance analysis.

• Produce weekly liquidity forecast w/ variance analysis for Finance Committee and Board of Directors, work with outside groups to improve overall forecast.

• Daily cash positioning and reporting for 19 of the major companies and subsidiaries.

• Forecast and update draws/paydowns for line of credits and notes payable, perform month end reconciliation, and work with outside groups for SEC reporting.

• Create a weekly "large forecasted" items report and provide it to the cash team for their daily positioning on major disbursements.

• Research liquidity planner, update BPC cash forecast and variance reports, and create rules to assign new incoming items through SAP. 

• Complete monthly metrics reporting to measure and monitor treasury activities. 

• Assist Cash Manager and act as a back-up on processing daily cash transactions such as: initiate and approve ACH/wires request, approve debit filters, initiate and approve positive pay exceptions.

• Member of the liquidity projects team; assist in completing major treasury projects such as:

  1. RFP Project: compare current fees w/ new bids, present proposals to management. 

  2. Cash Forecast Analysis Project: partner with Business Planning Department to discover correlations between forecast verse budget projections - Use statistical techniques.

  3. Build/improve BPC cash forecast and variance reports with SAP group.

  4. Completed multiple small to medium size projects that automated processes, provided insight, and improved internal controls.

• Execute Month-end closing for three entities - Present Income Statement and Balance Sheet results with analysis to management.

• Park and post journal entries and make corrections to prior day Point-of-Sale system transactions.

• Reconcile bank, inventory, and other Balance sheet accounts - Update monthly Master files for analysis.

• Audit GL accounts to locate discrepancies - Provide findings to management.

• Create weekly analytical summaries of store sales, employee warranties, and sales margins for different departments.

• Reconcile payroll liabilities, update employee commissions, and prepare monthly payroll accruals.

• Manage A/R and A/P accounts – Maintain vendor relations.

• Reconcile Sales Tax payable - Calculate and file monthly Sales Tax with Texas Comptroller.

• Preform bi-annual inventory reconciliations and correct or update inventory asset accounts.

• Reconcile year end property tax accounts and submit payment to tax assessor.

• Ad-hoc financial projects for annual event - BP MS-150.

University of Houston

Master of Science in Technology Project Management 

Certificate in Accountancy Program (CAP)

Houston, TX | Class of 2023

University of North Texas 

Bachelor of Arts in Economics  

Denton, TX | Class of 2017

R. L. Paschal High School

High School Diploma

Fort Worth, TX | Class of 2011

Finance/Treasury knowledge

• Financial modeling

• Operating cash flow and liquidity forecasting

• ABS and securitization reporting 

• Variance analysis

• Credit risk analysis

• Financial statement analysis

• Debt covenants and compliance reporting

• Balance sheet hedging

• FX analysis

• Trade finance

• Cash positioning

• Treasury metrics and other KPI reporting

Accounting knowledge

• Full-cycle accounting

• Month, quarter, and yearly closing

• General ledger and journal entries

• Account reconciliations

• Budget creation

• GAAP standards

• SOX compliance

Math knowledge

• Time series analysis

• Single and multiple regression analysis

• Create statistical models using T-tables and confidence intervals

• Other Statistics Knowledge: Probability, Distribution, Hypothesis testing

Technical skills

• Advance Microsoft Excel: Index & Match, macros - edit using VBA, 'Solver' & 'Data Analysis' TookPak, automated dashboards

• Microsoft Offices: PowerPoint, Access, Projects, SharePoint, Nintex workflows

• Programming languages: SQL - Microsoft SQL server, Oracle TOAD SQL

  • Further skills under development: Python and R

• Data visualization: Power BI

Other skills

• Languages: English, Spanish

• Software knowledge: Workiva Wdesk and Wdata, SAP and BPC reports, Hyperion HFM, Quickbooks

• Investment platforms: Bloomberg, Pam for Investments, CAMRA

Licensure

• Certified Public Accountant (in progress)

• Project Management Professional (in progress)