Accounting Data Analyst

SUMMARY

A self-motivated Financial Professional with over 5 years of experience supporting Accounting, Finance, Manufactures, and Investment Services. Sound skillsets in Financial Analysis, Excel Financial modeling, identifying variances and performing Balance sheet account reconciliations, reviewing the P&L statements based on historical data and recent trends, supported the month end closing processed.

General ledger accounts experience, using GAAP, JDE, SAP, Oracle, PeopleSoft Financial 9.2

Ability to work in a fast-paced environment, Proven ability to handle multiple projects and deadlines, excellent organizational, analytical and planning skills

Strong interpersonal skills to work with people at all levels within and outside the organization in a professional manner. Attention to detail and willingness to roll-up sleeves to get the job done

Understanding of GAAP accounting- Advanced MS Excel experience, ability to perform (Pivots, charts, VLOOKUPs, intricate formulas, conditional formatting, macros, data tables and PowerPivot).

Prepared monthly financial reports, reconciled complex fixed assets accounts, and balance sheet accounts reconciliation.

EDUCATION:

Keller Graduate School of Management of DeVry University Columbus, Ohio. 10/2010

Master of Business Administration (MBA)

Master’s Degree in Accounting and Financial Management (MAFM). 10/2008

Franklin University Columbus, Ohio 08/2000

Bachelor of Science in Accounting (BSc)

Areas of Strength & Expertise:

Reconciliation and Reporting

Budgeting and forecasting

Variance analysis

Proficiency in Excel spreadsheet

Strong Analytical experience

Financial analysis of the general ledger accounts

SAP Financial

Experience

Hyperion

Oracle

JD Edwards

PeopleSoft Financial

SQL

Balance sheet account reconciliations

MS Access

General Ledger accounts analysis

Excel financial modeling

Fixed Assets Maintenance

AP/AR experience

Professional Experience

Simonton Window, Columbus, OH Oct 2017 – May 2018

Financial Consultant

Handled general accounting functions, including journal entries preparation and reviewed, general ledger accounts reconciliations, balance sheet reviewed, fixed assets maintenance, and detailed account activities analysis.

Handled federal, state, and local tax. Researched and provided financial analysis on complex tax issued

Performed monthly tax reconciliations and booked accruals

Participated in the monthly accounting closing processed, including the preparation and reviewed of monthly, quarterly and year-to- date account variance analyses

Assisted in the preparation of quarterly and annual GAAP financial statements. Managed accounts by analyzing costs and revenues. Monthly analysis of department operational expenses

Reviewed monthly financial statements for reasonability and identifying any inconsistencies on balance sheets, income statements & cash flow products and business

Royal Building Products, Inc., Columbus, OH Feb 2017 – Jun 2017

Financial Accountant (Contract)

Prepared journal entries, monthly accounting closings processed, bank reconciliation, fixed assets maintenance and general ledger reconciliations

Records fixed asset acquisitions, dispositions, and transfers in the accounting system

Tracked project costs into fixed assets accounts

Reconciled the balance in the fixed asset subsidiary ledger to summary account in the general ledger

Reviewed system calculated depreciation for all fixed assets

A/P Invoices posting and weekly check generation

Performed analysis of sales, and Use tax issued

Performed monthly reviewed of asset additions, issued Capital project number, retirements and transferred

Reviewed fixed asset clearing accounts and ensured proper coding to fixed asset accounts

OhioHealth Corporation, Columbus, OH Aug 2016 – Dec 2016

Financial Coordinator (Contract)

Performed balance sheet accounts reconciliation, revenues and expenses analysis

Collecting, manipulating, comparing and analyzing data of various health plans- data includes but is not limited to revenue, expenses, and projections. Handled all forecasting and reconciliations for internal accounts. Performed monthly reconciliation of fixed assets to the general ledger for four hospital chains

McDonald Corporation, Columbus, OH Apr 2016 – Aug 2016

Financial Accountant (Contract)

Assisted with month end closed, including processing accrual journal entries and month end reporting for Canada and US

Prepared standard journal entries to ensure the general ledger is correct throughout the month and during month end. Analyzed variances on the P&L to ensure reasonableness and book entries as needed

Prepared bank reconciliations to balance store deposits with Bank Accounts

Prepare Balance Sheet reconciliations and take any action needed to assure account balances are corrected. Provided accounting support for closed stores.

IGS Energy, Dublin, OH Aug 2015 – Apr 2016

Data Analyst

Proposed solutions to improve system efficiency and reduce total expenses

Validated data and interpretations using statistical techniques

Presented findings and data to team to improve strategies and operational efficiencies

Abbott Laboratories, Columbus, OH Oct 2014 – Jul 2015

Financial Analyst II (Contract)

Performed financial analysis by extracting data from multiple systems and generating reports.

Prepared daily journal entries and verified entries for accuracy in SAP.

Reviewed the Profit and Loss Statements and performed balance sheet accounts reconciliations

Managed the general ledger accounting activities and performed the month-end closing.

Sonoco Mar 2014 – July 2014

Data Analyst (Contract)

Developed new databases and features to the existing databases

Supported enhancements to the SQL server

Performed maintenance and troubleshooting using Microsoft Access, Excel and Word

Cardinal Health, Inc., Dublin, OH May 2013 – Jan 2014

Accountant (Contract)

Performed sales-based accruals including rebates, royalties, deferred revenue, warranty, and associated fees. Recorded general and accrual journal entries

Assisted with month end closing

Battelle Memorial Institute Jul 2012 – Apr 2013

Financial/Business Analyst (Contract)

Performed balance sheet accounts reconciliations, analyzed cost sheets, AP, AR, Billing, and GL accounts. Managed the month-end closing processed and generated management reports

Performed financial analysis of highly complex data sets using excel tool such as Pivot table, VLOOKUP, SUMIF

Action for Children Sep 2011 – Jun 2012

Database Specialist (Contract)

Defined system and user requirements through interviews and analysis.

Converted Excel spreadsheet to Access Database and converted Access Database to Excel Workbooks.

Modified and developed new databases. Analyzed and discussed business requirements with clients, defined objectives, and formulated systems to parallel overall business strategies.

JP Morgan Chase, Columbus, OH Jan 2010 – Aug 2011

Accountant (Contract)

Updated investment records (Fixed Income Products) in database warehouse, performed analysis on fixed income products, and generated accounting statements for Portfolio managers.

Monitored cash, investment values and income activity.

Ensured journal entries properly recorded on Oracle general ledger accounting system.

Citigroup, Inc., Columbus, OH Mar 2006 – Nov 2009

Investment Accountant

Performed reconciliations of cash, portfolio and investment trades including trade capture and position

Researched and resolved portfolio holding variances between custodian bank and fund accounting system

Analyzed income and expense accruals, partner/shareholder allocation calculations and financial statements preparations to ensure accuracy

Analyzed broker records to the Citigroup internal accounting records

Prepared journal entries performed financial analysis and reconciliations

Contact this candidate