We provide IT Staff Augmentation Services!

Accounting Manager/business Analyst Resume

Irvine, CA

SUMMARY:

  • Financial Analyst and Business Analyst with several years of working experience.
  • Adept with financial systems, business process analytics, budget development, budget performance, variance analysis, GAAP financial reporting, cost analysis, tracking project costs, business case development, capital budgeting, journal entries, general ledger accounting, reconciliations and analysis.
  • Proven ability to drive results and always willing to rise to a challenge.

TECHNICAL SKILLS:

Microsoft Office: Advanced Excel (Pivot Tables, V - Lookups, Macros/VBA, Linking, Conditional Formatting, Formulas), Advanced PowerPoint, Word, Advanced Access including SQL Queries; SharePoint, Outlook and Lotus Notes. SAP (FICO, BW, BPC), Business Intelligence, Business Objects, BEX Analyzer. Oracle Hyperion Financials, Oracle Essbase, Oracle Smart View, Cognos EDW Enterprise Data Warehouse, Oracle JD Edwards E1, PeopleSoft Financials, nVision, ARIBA/APIQ Procurement Systems, Oracle R12, MicroStrategy On Line Reporting.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Accounting Manager/Business Analyst

Responsibilities:

  • Data analysis and reporting on number of claims and dollar amounts paid to support the tax department, regulatory reporting, IPA reporting and multi-state sales tax reporting using Claims Management System EDI data, Access (SQL) database queries and Excel reports.
  • Journal entries to record revenue, cost of goods sold, gross margin for plans, intercompany entries, financial statements, accounts reconciliations, SOX and financial reports utilizing PeopleSoft Financials, nVision, Essbase, and Excel.
  • Access SQL Queries, Excel Reports, PeopleSoft Financials and Essbase.
  • Documented processes.

Environment: Microsoft Office: Excel, Word, PowerPoint, Access, SharePoint, and Outlook. Oracle Hyperion Financials, Oracle Essbase, PeopleSoft Financials, nVision, Oracle R12, MicroStrategy On Line Reporting.

Confidential, Carlsbad, CA

Financial Analyst/Business Analyst

Responsibilities:

  • Operated as Financial Analyst on a financial systems team that develops and supports Hyperion Planning, HFM and Cognos.
  • Handled data maintenance and data integrity of Cognos EDW as it relates to the other systems.
  • Ad hoc data pulls and projects.
  • Executed accounting month end close support and integration activities.
  • Managed data reconciliation and variance analysis between EDW Cognos, HFM, SAP, E1, and Essbase.
  • Documented processes and driving process improvements through automating manual processes.
  • Worked with IT to ensure data integrity by developing effective controls, identifying issues and fixing at source system.
  • Developed Excel models with over a million rows of data and advanced formulas.

Environment: Microsoft Office: Excel, Word, PowerPoint, Access, SharePoint and Outlook. SAP, Business Objects, Oracle Hyperion Financials, Oracle Essbase, Oracle Smart View, Cognos EDW Enterprise Data Warehouse, Oracle JD Edwards Enterprise 1 (JDE E1), SQL Queries.

Confidential, Long Beach, CA

FP&A Consultant

Responsibilities:

  • Populated Excel 2015 Budget Templates utilizing advanced Excel formulas and VBA/Macros, foreign currencies translation, budgeting by branch by country for export/import shipping company.

Environment: Microsoft Office: Excel, Word, PowerPoint and Outlook.

Confidential, San Clemente, CA

Project Manager/Excel Finance Data Analyst

Responsibilities:

  • Managed project focused on outsourcing the Accounts Payable process to an outside vendor.
  • Functioned as the Excel Data Analyst technical expert in the export and transfer of files from SAGE100 to the outside vendor’s system in the required text file format with pipe delimiters.
  • Documented process, account assignment matrix, a test system.

Environment: Microsoft Office 365: Excel 2013, Word, PowerPoint and Outlook. Sage100/Mas 90.

Confidential, Norwalk, CA

PMO Analyst/Business Analyst

Responsibilities:

  • Training Developer developed training materials including Web Based Training modules, job aids, worked with the client SMEs and Application Development Team.

Environment: Adobe Captivate, Microsoft Office: Excel, PowerPoint, Word, SharePoint and Outlook.

Confidential, Irvine, CA

Business Analyst/Senior Accountant Analyst

Responsibilities:

  • Handled asset reconciliations for institutional accounts.

Environment: Microsoft Office: Excel, Word, SharePoint and Outlook.

Confidential, LaJolla, CA

Business Analyst/Financial Analyst

Responsibilities:

  • Accomplished 2014 budget development for business units using Cognos planning models, SAP, Business Objects and Excel.
  • Resolved invoice issues with vendors and reduced the accounts payable accrual by 60%.
  • Prepared monthly close accruals and reports; variance reports and analysis.
  • Reviewed contract terms on a major deal and identified to business development that invoices were not received per the terms of the agreement; requested the invoices and calculated the correct amount of the accrual.
  • Tracked project costs on deals and license agreements using Business Objects, SharePoint and Excel.
  • Accomplished contract/purchase requisition review for payment terms and conditions, purchase order maintenance, reporting and closure for expense projects.
  • Communicated and coordinated with Operating Managers, Human Resources, Finance/Accounting, Procurement and Accounts Payables departments in US and in India.

Environment: Cognos budget/forecast models, SAP, Business Intelligence, Business Objects, BEX Analyzer, ARIBA/APIQ Procurement Systems, Snapshot Portfolio Projects Planning System, Metastorm Business Planning Models for Clinical Trials Budgets, Microsoft Office: Excel, PowerPoint, Word, SharePoint and Outlook.

Confidential, Universal City, CA

Business Analyst/Data Analyst/Financial Analyst

Responsibilities:

  • Prepared weekly financial reporting and journal entries for operating managers using Excel pivot tables, Access, and SAP.
  • Used SAP to find items expensed that should have been capitalized.
  • Tracked spending on projects using SAP Project Builder WBS system.

Environment: SAP, Business Intelligence, Business Objects, BEX Analyzer, Comshare, Microsoft Office: Excel, PowerPoint, Access, Word, and Outlook.

Confidential, Downey, CA

Business Analyst/Data Analyst/Financial Analyst

Responsibilities:

  • Used Excel pivot tables to analyze payroll and benefits data.

Environment: Microsoft Excel, PowerPoint, Access, Word, Outlook and PeopleSoft Financials.

Confidential, Orange, CA

Business Analyst/Data Analyst/Financial Analyst

Responsibilities:

  • Developed the 2013 budget development for the Confidential corporate office in Orange involved budgeting for several branch offices.
  • Prepared and updated budget templates: sales by customer, sales budget by branch, headcount budget, capital budget, balance sheet budgets, consolidations, executive summaries and the budget presentation.
  • Used Access, Excel, PowerPoint and Word; loaded the budgets in PeopleSoft and sent out budget reports.
  • Developed monthly financial reporting; prepared presentations on P&L items and balance sheets; prepared variance reports and analysis.

Environment: Microsoft Excel, PowerPoint, Access, Word, Outlook and PeopleSoft Financials, nVision.

Confidential, San Clemente, CA

Business Analyst/Financial Analyst

Responsibilities:

  • Developed budgets for several multi-million dollar San Onofre divisions on matters relating to labor for hundreds of employees, materials, service vendor costs and travel.
  • Budgeted fixed costs including fees and leases.
  • Used budget templates in Excel.
  • Loaded the budgets in SAP and coordinated budget revisions.
  • Worked with SAP to generate budget reports and actual versus budget monthly reports.
  • Met with division managers on a monthly basis and provided detailed budget variances explanations.
  • Made recommendations regarding revisions and cost improvements.
  • Provided analysis, recommendations and reports.
  • Collaborated with division personnel to complete ad hoc analysis and reports and gather data and information for budget and cost analysis.
  • Prepared monthly executive business flash reports.
  • Prepared Board meeting presentation slides and monthly close and actual vs. budget variance analysis.
  • Created monthly reports on labor, material, contract and other costs by division.
  • Generated staffing reports; journal entries, accruals.
  • Developed financial forecasts and documented policies and procedures.
  • Tracked and reported project costs.
  • Tested Business Objects reports.
  • Gathered and communicated requirements as end user.

Environment: SAP, Business Intelligence, Business Objects, BEX Analyzer. Microsoft Office: Excel, Access, PowerPoint and Word; Lotus Notes.

Hire Now