Manager Assistant

Arvin L. Tapia

Mineola, NY 516-***-**** ************@*****.***

PROFESSIONAL EXPERIENCE

Senior Accountant, Astoria Bank, Lake Success, NY 2014 – Present

Promptly submit monthly Balance Sheet, Income Statement, Stockholders Equity and variance analysis pages for Board package

Meticulously prepare Consolidated Financial Statements for Holding Companies (FR Y9C), Reports of Condition and Income (Call Report) and the Bank Holding Company Report of Insured Depository Institutions' Section 23A Transactions with Affiliates (FR Y-8)

Diligently prepare and review SEC reports 10Q and 10K, including Cash Flow

Perform SOX testing

Process general ledger entries, sub entities accruals and billings; reconcile inter-company accounts

Carver Federal Savings Bank, Brooklyn, NY 2011 – 2014

Consultant, Accounting Department

Efficiently performed Sageworks administrator role

Prepared and assisted Allowance for Loan and Lease Losses (ALLL) reporting

Upgraded/Downgraded loans per credit evaluation. Inform loan operation of risk rating changes that are needed in the loan system and confirm that the changes are applied

Updated loan charge-offs and recoveries schedule in Sageworks and reconcile to general ledger

Updated ASC 310-10-35 (FAS 114) classified loans in Sageworks and Discounted Cash Flow (DCF) schedule as required

Updated ASC 450-20 (FAS 5) qualitative factors per credit department assessment and run different ALLL scenarios

Assistant Vice President /Senior Accountant

Directed corporate level accounting activities for 63 year old largest African-American operated bank in United States

Punctually submitted monthly Profit and Loss reports for Board and Management review, in addition to Quarterly Actual vs. Budget results

Accurately computed P&L and Balance Sheet reports for all division heads, while directly improving process by working figures at General Ledger Account level, to management summary level

Manually reclass assets, liabilities, revenues and expenses to proper department to reflect accurate performance

Efficiently reviewed and prepared Annual and Quarterly 10K and 10Q reports, while maintaining XBRL classification, and stringently complying with law and regulations, promptly uploading to Webfilings-SEC

Proficiently gathered data for the Asset Liability Management report which was the basis for Portfolio accounting and reporting generated by Raymond James-Morgan Keegan.

Developed and provided report for Management Investment Committee (MIC) covering loans, investments, borrowings, liquidity, deposit levels, and borrowing potential

Strategically analyzed and detailed Quarterly Budget Variance Reports for departments

Processed accounts payable expenses

Citigroup, New York, NY 1998 - 2010

Vice President, Municipal Securities Division / Citibank Community Capital / Product Control (2008-2010)

Progressed through increasingly responsible positions from Assistant Manager, Manager, Assistant Vice President, and Vice President, for international financial conglomerate

Evaluated and prepared monthly asset data and reports for Basel II, Liquidity reporting such as: Market Access Reports (MAR), Special Asset Pool, and Risk Adjusted Assets Principles (RAP)

Reviewed and processed Management Adjustments (MA) in System Management Accounting Regulatory Tax (SMART) and General Ledger (GL) entries

Adeptly organized weekly asset data for Balance Sheet Analysis and Reporting Tool (BART)

Efficiently reconciled and maintained data integrity for applications such BART, SMART, Solar, Strategic Technology for Analysis and Reporting (Star), and Pearl

Assistant Vice President, Citibank Community Development / Financial Control (2005-2007)

Recognized and recipient, On the Spot Award, Performance and Leadership, September 2005

Effectively supervised daily Profit and Loss (P&L) estimate, loan balances, and loan revenue estimate

Successfully performed 3rd party review for client loan releases, and coordinated fund transfers

Compiled and analyzed monthly Flash and Actual P&L, staffing levels, and expense reports

Systematized monthly reports for Executive Management Report (EMR) deck

Computed and managed Budget and Forecasting process from data generation to management approval

Integral figure in developing and coordinating design of new management reporting system

Assessed data integrity and systems checks before system deployment, as component of user acceptance testing (UAT)

Demonstrated expertise preparing Ad-hoc reports, as needed

Assistant Vice President, Strategy and Planning (2002-2004)

Efficiently generated EMR Report deck covering P&L, staffing levels, and expenses analysis

Instrumental in implementing information security policy as Business Information Security Officer (BISO) and Field Security Coordinator (FSC)

Developed entitlement reviews, and maintained Critical Vendor list, Application Inventory, and Enterprise Entitlement Review System

Proactively prepared reports including Application Compliance Questionnaire and Business Compliance Questionnaire

Successfully performed business website administrator functions

Processed and maintained Organizational Hierarchy structure and expense-code roll up

Formulated Budget, Forecast, and Expense Allocation figures for Budget system

Manager, FX & Structured Products (2000-2001)

Organized and maintained data warehouse in Hyperion Essbase cube

Analyzed and prepared management performance reports (MPR) encompassing P&L, assets, expenses, and staffing levels

Assistant Manager, Financial Control / Derivatives (1998 –2000)

Generated monthly reports for GAAP and RAP Assets, Expenses, and Staffing levels

Formulated MCO reports as part of Liquidity Risk Reporting

Examined and passed GL entries and allocated assets, expenses, and revenue from (ETOF) business

EDUCATION AND TRAINING

M.B.A., Finance (International Business), 1997

Fordham University, Graduate School of Business, New York, NY

Awarded merit-based research position under Professor of Finance

B.S., Business Administration, Concentration: Finance, 1990

Fordham University, College of Business Administration, Bronx, NY

TECHNOLOGY SKILLS

W-desk, Synergy, Fed Reporter, Sageworks, Excel, PowerPoint, Word, Smartwin, Smart Java, Smart II, Solar, Budget Admin Tool, GCIB Forecast, Stat Allocation System, Hyperion Essbase, Oracle People Soft, P2P (Procure to Pay), Financial Reporting System Crystal Reports, Pearl Business Objects, Artemis, McCracken, GARS-Global Account Reconciliation, OSI, I-Magic, I-Research

Contact this candidate