Ryan Sheller Email & Phone Number

Primarily responsible for the accounting of financial instruments as assigned. Thisincludes investments, discount notes, regular debt, derivative debt, mortgage loans, mortgage-backed securities, advances, capital stock, cash accounts, member deposits, AHP programsand derivatives.Specific duties: Performs accounting activities including, but not limited to, transaction verification, reconciliation and journal entry preparation. Preparation of monthly and quarterly data for reporting to the Office of Finance and Federal Housing Finance Agency. Also responsible for the completion of schedules required to support the Bank’s SEC and board reporting process. Adhere to daily/monthly close schedule and internal / external reporting deadlines. Responsible for ensuring compliance with GAAP, FHFA directives, Sarbanes-Oxley requirements and the Bank’s accounting policies. Includes complete, accurate and timely performance of assigned controls. Assist in resolving inquiries from the external auditors, internal auditors and FHFA examiners, including preparation of schedules. Maintain accurate and complete procedures for assigned duties. Serve as a liaison between Systems Development staff, external software vendors and the Financial Control division to facilitate the resolution of system issues. Implement system upgrades and modify reports to accommodate versions of new software releases. Participate in the determination, implementation and automation of proper accounting procedures and internal controls for emerging or evolving financial products. Proactively work with management and peers to achieve department and Bank strategic initiatives. Complete special projects as assigned. Provide backup support for various functions, as assigned.

Primarily responsible for the accounting of financial instruments as assigned. This couldinclude investments, discount notes, regular debt, derivative debt, mortgage loans, mortgage-backed securities, advances, capital stock, cash accounts, member deposits, AHP programsand/or derivatives. Serves as a primary support position for the Financial Accounting Managerand provides backup support to other accounting functions.Specific Responsibilities: Perform accounting activities including, but not limited to, transaction verification, reconciliation and journal entry preparation. Preparation of monthly and quarterly data for reporting to the Office of Finance and Federal Housing Finance Agency. Also responsible for the completion of schedules required to support the Bank’s SEC and board reporting process. Adhere to daily/monthly close schedule and internal / external reporting deadlines. Responsible for ensuring compliance with GAAP, FHFA directives, Sarbanes-Oxley requirements and the Bank’s accounting policies. Includes complete, accurate and timely performance of assigned controls. Assist in resolving inquiries from the external auditors, internal auditors and FHFA examiners, including preparation of schedules. Maintain accurate and complete procedures for assigned duties. Serve as a liaison between Systems Development staff, external software vendors and the Financial Control division to facilitate the resolution of system issues. Implement system upgrades and modify reports to accommodate versions of new software releases. Participate in the determination, implementation and automation of proper accounting procedures and internal controls for emerging or evolving financial products. Proactively work with management and peers to achieve department and Bank strategic initiatives. Completed special projects as assigned. Provide backup support for various functions, as assigned.

• Review monthly and quarterly financial statements and consolidations. prior to submission.• Quarterly preparation of Federal Reserve and Office of Thrift Supervision reporting.Reports include: FR Y-9C, FR Y-9LP, FR Y-11 , FR Y-10, FR Y-8, FR Y-6 & H(b}-11• Audit and investor liaison for informational requests.• Review' audit reports and tax returns for accuracy.• Review monthly bank reconciliations.

• Preparation of monthly and quarterly financial statements.• Prepare and review annual budgets.• Reconcile bank statements to checkbook and general ledger.• Update audit wolk-papers and fixed asset system monthly.

• Accounting for properties with bond financing and .construction in progress.• Monthly reporting and analysis of REIT properties and roll-forward calculations.• Monthly reconciliation of intercompany account balances.• Provide support during the yearly budget preparation.• Assist with the 'training of new Financial Accountants.• Prepare year-end audit packages and respond to all auditor inquiries.

• Responsible for the reporting and analysis of financial information for a portfolio of apartmentcommunities.• ·Maintain general ledgers and bank accounts for assigned portfolio of communities.• Prepare and analyze monthly operating statements for internal users, lenders, and governmentagencies (HUD. SEC, and various state agencies).• Monitor all debt, tax, and other related· payments.• Prepare year-end audit workpapers for independent CPA firm; respond to auditor inquiries, reviewdraft annual'.audited financial statements, and re~on(l to HUD correspondence regarding thefinancials.

• Responsible for converting a variety of unique loans from files to computer networks.•.Directed .the Work of Loan Examiners assigned to my portfolio of loans.

• Reviewed file documentation to insure all government guidelines had been followed.• Calculated interest charges for borrowers.• Assisted a variety of other departments under the Mentor Program.

Bachelor'S Degree, Accounting And Finance

Master Of Business Administration (Mba), Business Administration And Management, General