Ryan Hekl Email & Phone Number

Winter Garden, Fl, Us

Remote

Manage a team of data Subject Matter Experts tasked with the data harmonization effort as part of the Bank’s Finance Transformation Project. In a data factory setting, the Control Tower reviews the decomposition efforts related to the bank’s various data repositories and current population of existing Finance, Regulatory, Treasury and Risk based reports. Based on the decomposition workflow, the team aligns the lowest level data attributes to the banks conceptual data model. Working with the various Pods within the project, the team is expected to make final decisions surrounding authoritative data sources, opine on key design decisions and take ownership of the Conceptual Data Model. During this time of change, the team continues to support the banks Commercial data needs related to the FRY-14 schedules, Treasury Modeling and Accounting Policy (CECL Allowance).

Winter Garden, Florida, United States

Manage a team of Commercial Banking Subject Matter Experts (SMEs) for the Finance Department of M & T Bank. In this role, the team acts as an intermediary for the Commercial Banking Department, Finance Department and Central Technology with a focus on the CCAR FRY-14Q Commercial Wholesale Schedules. Primary responsibilities include, analyzing published Federal Reserve Board (FRB) instructions for the FRY-14Q Wholesale Schedules and working with the Commercial Bank, Finance Department and Central Technology teams to assure compliance. Perform quarterly second line of defense data validation prior to schedule submission to the FRB. Manage, Document and Remediate all data related inconsistencies as a result of system limitations resulting in data gaps in the FRY-14Q reporting (Schedules Q.H.1 & Q.H.2).

Winter Garden, Florida, United States

Acted as a Commercial Banking Subject Matter Expert (SME) for the Commercial Credit Risk Department of M & T Bank. Managed all Commercial data related to the bank's seven Commercial Loan Accounting systems (AFS, SHAW, CLC, WMS, ZET, LCI and IDS), two Financial Spreading applications (CROWE and nCino), Commercial Relationship Management system (ERM) and the Commercial Bank's Origination System (nCino). In this role, I was tasked with bridging the gap between the published Federal Reserve Board (FRB) instructions for the FRY-14Q Wholesale Schedules (Schedules Q.H.1 & Q.H.2), the data output from the many Commercial Systems and the generation of the wholesale schedules. Performed quarterly second line of defense data validation prior to schedule submission to the FRB.

Wilmington, Delaware

Primary Tasks Include: Prepare specific impairment calculations for the companies Acquired and Legacy Commercial Loan Portfolios (Group Credits greater than $1MM in Exposure). This analysis is in adherence to SOP03-3, FASB 141 and FASB 114 guidelines. Responsible for the Lifetime Loss Re-Estimations for each of the companies acquired portfolios. Act as unit’s systems liaison for all accounting templates, Forms & Databases. Retain and maintain the unit’s historical data via the use of complex Excel Macros (Extractions and Updating) and Access Databases. Commercial Banking Monthly and Quarterly reporting as it pertains to Portfolio Expected Lifetime Loss, Specific Reserves and Acquired Bank Projected Cash Flows.

Manage five teams totaling 22 staff members responsible for regional banking transactional processing and reconciliation. These duties include the oversight of 180 quarterly reconciliations as well as 30 daily reconciliations. Supervise the processing of Maintenance Transactions, All Inter Bank Participation Activity, Non Accrual and Charge-Off Processing as well as Customer Payments and Advances as they pertain to Dealer Services, Commercial Banking and Retail Banking. Each day, we maintain positive relationships with both our internal and external clients by ensuring timely and accurate processing.

Preparation of Management reports to assist in the assessment of risk associated with the Commercial Banking Loan Portfolio. Primary responsibilities include analysis of the Commercial Loan Real Estate Composition, Commercial Banking Loans by Industry, Over Ten Million Relationship Concentration and Analysis of Cash Flows by Entity. Additional Tasks: Reconciliation of our Shaw Commercial Accounting Software to the General Ledger system, Quarterly reconciliation of all Commercial Loan Loss Reserve Accounts and satisfying internal and external audit requests.

Manage workflow of all payments, advances, participation processing and funding requests in accordance to Wilmington Trust’s Commercial Banking Service Standards. Assists team members on research issues and problem resolutions concerning payments and advances. Mentor and train team members in efficiencies in Processing and error resolution. As directed by the Lending Staff, research billing issues relating to our Customer's Commercial Loan Accounts. Recalculate interest accruals on Commercial Loans and make necessary adjustments to the Commercial Loan system and General Ledger system. On a yearly basis, prepare and deliver Performance Evaluations to current Loan Accounting team members.

Analysis of monthly and quarterly profitability data to explain income, expense and balance sheet variances on a period-specific and year to date basis. This will include statistical and financial analysis related to income/fee sources, balance composition, capacity utilization and unit costs. Fully assists Senior Management in the implementation and analysis of any approved recommendations. Standardized, prepared and distributed monthly financial performance reports to Commercial Banking Department and Divisional Managers on a monthly basis. Upon request, I performed various Ad-hoc reporting as directed by the company’s Commercial Banking Division managers.

Wilmington, Delaware, United States

Wilmington, Delaware, United States

Wilmington, Delaware, United States

Wilmington, Delaware, United States