We provide IT Staff Augmentation Services!

Data Analyst Resume Profile

4.00/5 (Submit Your Rating)

CT

Summary:

  • With International work experience and passing CPA Exam from United States, I am well versed in General accounting Financial Analysis and Data analysis. Expertise includes solid understanding and application of GAAP Accounting principles, month end closing, accrual accounting, account analysis, aging statements, comparative financial statements, Management charts and reports. Prior experience encompasses preparations of Income Statement, Balance Sheet, Statement of Cash flows and other financial statements and reports to Executive Management and different States.
  • Skills and tools: ERP - SAP Financial Accounting and Logistics module, Oracle financials PeopleSoft
  • Advance Excel like V-Look ups, Pivot tables and Macros MS Access, MS SQL

Professional Experience

Confidential

Data Analyst

  • Develop and maintain Data using MS Access, Hyperion, Advance Excel and SQL.
  • Perform queries for regular and Ad hoc reports to management, cost analysis, man power utilization
  • Prepare charts and reports to the management using advanced excel techniques by center, model etc.
  • Prepare product wise comparative statements, reports and charts to present to the management.
  • Weekly and monthly metrics to the management that helps with decision making.
  • Forecasting and projections of man power requirements by location and by program.
  • Management resource planning, budgeting and month end reports to management.

Confidential

Financial Analyst

  • Provided the management with various comparative revenue and expense reports by customer, geographical area, sales representative, products and other options
  • Analyzed financial statements by month evaluated data and advise management of any changes or corrections to be made.
  • Created budget schedule for various departments and projected income statement and balance sheet for the next year. Used advanced excel for forecasting techniques and financial modeling.
  • Monthly payroll reconciliation and Property tax schedules.

Confidential

Analyst

  • Fixed issues and paid over 3M to various suppliers on overdue, disputed and overbilled invoices.
  • Effectively communicated with various suppliers to resolve disputes and negotiate payments.
  • Worked on transition from PeopleSoft to SAP Trained employees on SAP Accounts payable module.
  • Identified and resolved issues with suppliers of Southern CT Gas company to expedite payment
  • Suggested process improvements in purchasing and accounts payable to remove backlog and make timely payments to suppliers.

Confidential

Finance Specialist

  • Payroll accounting for around 100 to 125 employees handled weekly payroll independently.
  • Accounts payable Made timely payments to different Vendors after verification monthly accruals
  • Journal entries Month end close Maintain prepaid and payable ledgers account reconciliations
  • Maintain Union dues file and Ledger. Interpret data using Advance excel. Maintain payroll database in MS Access.
  • Handled employee relations and workmen's compensation maintain employee Payroll files safeguard confidential information Initiate the new hire process Verify employee eligibility

Accountant

Confidential

  • Prepared quarterly financial statements Balance sheet, Income statement, Statement of cash flows, statement of retained earnings by legal entity, for different states revenue of 300M to 500M.
  • Ensure the Accuracy of the financial information provided to the state. Review monthly and quarterly financial reports and statements for completeness and compliance with the accounting principles.
  • Prepare and submit Management Discussion and Analysis to the states.
  • Improved the manual process of financial statement preparation to one that was virtually automated. This considerably reduced the time and effort required in financial statement preparation.
  • Monthly accrual of fees and expenses, routine re-class entries and correct mapping errors.
  • Monthly and Ad hoc reports Intercompany transactions.
  • Detailed aging of claims reserves and claims paid. Prepare aging schedule for premiums receivable.

Confidential

Staff Accountant

  • Daily reconciliation of cash and sales ledger. Posting daily cash transactions
  • Prepare Journal entries. Maintain Ledgers of certain Balance Sheet Accounts like Prepaid expense Deferred Revenue and Receivable
  • Involved in Month end closing for allocation of expenses, revenue recognition, Accrual of expenses, Bad debts, Amortization etc Prepare Monthly aging reports.
  • Maintain SOX Sarbanes-Oxley controls for Journal entries and General Ledger Accounts. Decide proper handling of financial transactions. Maintain chart of accounts.
  • Interact with different department heads and consultants regarding budget and accruals. Maintain unapplied cash ledger and resolve discrepancies.
  • Prepare monthly profitability statements by product line and Expense Analysis for various departments
  • Prepare Monthly Bank Reconciliation and Reconciliation of Royalty Data-Base to General Ledger
  • Assist in preparing Annual Budgets and forecasting
  • Monthly review of inter-company transactions and confirmation of month end balances.

Software/Applications

  • Advance MS Excel, MS Access, Power point, SQL
  • Oracle, Hyperion, Crystal reports
  • People soft
  • SAP

We'd love your feedback!