David Hunter Email & Phone Number

Birmingham, Alabama, United States

Skills• Advanced Excel (including VLookup and Pivot tables)• SAS (Windows, Unix)• SAS Enterprise Guide• Microsoft Word• Microsoft Access• IBM Cognos (TM1)• SQL Developer• JIRA project management• Hyperion reporting tool• SQL Server• Monarch• Outlook • Ad Hoc ReportingDuties• Created and performed monthly reconciliations for Credit Risk Database (CRDB), BASEL database, Enterprise Data Warehouse (EDW) database and General Ledger (GL).• Compiled monthly reports for pledged loans for the Treasury Department to submit to the Federal Reserve.• Created monthly file of Small Business Administration (SBA) recoveries to be loaded into the CRDB.• Responsible for maintaining and certifying user lists of several Sarbanes-Oxley (SOX) critical databases.• Responsible for quarterly validation and approval of users of various SOX-critical databases.• Prepared reports and provided verification for auditors and regulators.• Assisted in the development, programming, and testing of the CCAR capitalization reporting.• Developed a database and reporting system to track Notes Held For Sale and Notes Sold by the bank.• Compiled Watch List and Loan Loss Reserve Adequacy Test for criticized and classified loans. • Created reports for the Credit, Loan Review, Credit Administration departments and Credit Committee. • Built and maintained databases as needed for Credit and Loan Review. • Prepared reports and provided verification for auditors and regulators.• Coordinated Credit Quality Report and upgrade to TM1 version. • Built and maintained databases of Large Pending Loans, Funded Loans over $2.5MM, Credit Analyst tracking.• Prepared data dictionary for Credit Risk database, tracing field transformations back to original source.• Extensive use of SAS, SQL, Excel, and TM1.• Ad Hoc reporting as required using CRDB, EDW, GL, and Basel databases.

Birmingham, Alabama, United States

Created and maintained accounting system and financial reporting of statement of condition for a non-profit organization, including payroll, tax reporting and preparation, and ledgers.

Birmingham, Alabama, United States

As Alabama Humanities Foundation:-Control accounting and disbursements for $950,000 annual budget-Coordinate payroll-Complete Federal, State, and Local tax forms-Train office staff on personal computer applications-Maintain local area network-Upgrade and maintain database of grants, donors, and statewide mailing list-Examine and adjust grant proposals for submission to the Board of Directors

Birmingham, Alabama, United States

Organized and maintained accounting system and financial reporting of statement of condition for a non-profit organization, including payroll, tax reporting and preparation, and ledgers.