We provide IT Staff Augmentation Services!

Capital Data Reporting Analyst Resume

4.00/5 (Submit Your Rating)

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 sub­grants.
  • 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.

We'd love your feedback!