Capital Data Reporting Analyst Resume
Buffalo, NY
SUMMARY
Corporate Finance Statistics/Data analysis Accounting Economics International Business Operations Management IT Management Systems Marketing killed Financial Analyst with over 10 years of FP&A experience and strong expertise in financial reporting, data analysis, developing financial models and forecasting. Proactive, with excellent communication skills and a track record of delivering optimized results. Directed and participated in important projects and analyses that proved essential to the organization's objectives. Other skills include
TECHNICAL SKILLS
- EXCEL, ACCESS, PowerPoint and Qlikview
- Hyperion Essbase
- Oracle Business Solutions
- Ad Hoc Reporting/Analysis
- Accounting
- GAAP proficiency
- Variance Analysis
- Budgeting
PROFESSIONAL EXPERIENCE
Confidential, Buffalo, NY
Capital Data Reporting Analyst
Responsibilities:
- Reports and Presents the quarterly FR Y14Q retail loans submission results to upper management for review and approval.
- Performs reconciliations of the FR Y14Q Retail loans schedules against the GL and the Federal submissions to the Federal Reserve.
- Uses Hyperion, Excel and the data warehouse to research any discrepancies between the large database system files, GL and Federal submission files.
- Researches and clarifies any variances found in the quarterly and monthly FR Y14Q and FRY9C reconciliation schedules.
- Responsible for evaluating and executing any changes to the FRY 14Q Federal instructions and how it may affect the data reporting.
- Implemented changes that streamlined the regulatory reporting process and design.
- Has led and successfully resolved data projects that have improved the data quality and accuracy in the department's reporting.
Confidential, Oakland, CA
Sr. Financial Analyst
Responsibilities:
- Prepares the Bank's monthly financial statement packages and other financial related reports for Board and ALCO.
- Assists in the preparation of the Bank's strategic and operating plan.
- Assists in the preparation of the Bank's quarterly call reports.
- Participates in the organization's Confidential &A evaluation and due diligence as needed.
- Designs ad hoc reports including financial models that evaluate the organization's product implementation and profitability.
- Prepares and researches variance analysis and explanations for the monthly budget to actual reports.
Confidential
Financial Analyst
Responsibilities:
- Develops the month - end Board financial reporting package.
- Actively contributes to the monthly strategic management meetings (ALCO) and is responsible for the written summary and analysis.
- Assists in the preparation, coordination and data validation of the organization's budgets and quarterly forecasts.
- Responsible for the administration, validation and management of the organization's financial data reporting software.
- Implemented Activity Based Costing models to support interdepartmental strategic pricing decisions and initiatives.
- Provides data and analytical support for the organization's Asset Liability management functions.
- Developed comprehensive EIS Reporting model to evaluate the organization's financial performance against our peer benchmark.
- Established SWOT reporting system to assess cost center profitability.
- Assisted in the implementation of Prologue as the new accounting and financial reporting system.
- Developed and designed the organization's monthly dashboard analytics.
Confidential, Walnut Creek CA
Financial Analyst
Responsibilities:
- Successfully prepared the organization's branch rent expense and income Budgets.
- Under tight deadlines, efficiently completed the accruals and variance analysis for the division's rent expense and income accounts.
- Responsible for the capitalization and amortization of loan fees and costs in compliance with FAS91 standards.
- Researched GL account discrepancies and variances by utilizing Oracle data warehouse.
- Responsible for the division's month-end reporting and analysis.
- Effectively Integrated Hyperion to improve the organization's reporting processes.
- Developed and maintained various financial models critical to the bank's reporting.
- Successfully performed branch closures project by re-classifying OPEX costs to the correct cost center.
- Supports in the monthly closing process by preparing journal entries and researching variances and discrepancies.
Confidential
Finance/Accounting Specialist
Responsibilities:
- Improved the reporting efficiency by Implementing Confidential as the main financial reporting software.
- Responsible for the administration, scrubbing and management of the organization's financial data reporting software.
- Produced and analyzed the Board's monthly financial reports and Executive Summary.
- Assisted the CFO in the preparation of the budget and quarterly forecasts.
- Prepared and analyzed the bank's Asset/Liability Risk Management reports.
- Created financial models that monitored the loan portfolio credit risk.
- Responsible for the monthly calculation of the provision for loan losses.
- Managed numerous projects and wrote analyses and forecasts that were critical to the bank's overall profitability.
Confidential
Accountant/Assistant Admin ll
Responsibilities:
- Assisted in the reconciliation of the Account Payables of 26 Confidential accounts.
- Uses EXCEL to periodically maintain, manage and research 26 Confidential accounts.
- Helps accounting in the preparation of check requests, travel advances and petty cash funds.
- Uses Peoplesoft software to prepare cost transfers, payroll transfers and other financial journals as needed.
- Assists management on the preparation and distribution of grants and subgrants.
- Frequently researches and resolves vendor payment issues as needed.
- Performed various Administrative duties like order of supplies and others as needed by management and other members of the staff.
