Financial Analyst Resume
Pleasanton, CA
SUMMARY:
- Accounting/Finance Professional with background in financial business processes and analysis of financial data to leverage financial and technical expertise.
- Proficient and hands - on experience (15+ years) in Accounting, Financial planning and analysis experience.
- Financial expertise in Government, Manufacturing, Semiconductor, Software, Telecom, and Retail verticals.
- Technical discipline is in Government contracts (FAR 31&Far 52-215-2) (CASB Pub.L91-379)(GAAP)(SOP78-10, 97.2)(GASB 22, 23, 29)(FASB-109)(SOP 98-1)(EITF 08-1, 21)(ASC )Payroll ADP process.
- Six years of Fixed Asset Management, Project management, Capital leases, & process improvements.
- Ten years of G/L and Activity Based Costing, Sox & Consolidation experience, financial modelling, project support, allocation of headcount and expense ratios, variance analysis and 10K & 10Q documentation.
- Utilize pivot tables, formulas, handling large amounts of data and organizing data of the A/R, A/P customer database. Maintained the Payroll and Sales incentive compensation systems and financial reporting..
- OEM Approval process, OEM Spec and standards library, OEM Product Life cycle, technical and sales force SharePoint data. Documenting the process of work, resolve issues, ensure accuracy of submittals.
- Generated management reports, analyze financial trends. Monthly journal entries and annual audit schedules.
ACCOUNTING SOFTWARE:
Oracle 11i, R12 CFAS, Oracle E-Business Suite, Lawson Financials, Deltek Cost-Point, SAP-R3 4.7, Hyperion-ESSDB, Great Plains, Cognos, Business Objects/Warehouse, JDE Access Sales force, Quick Books, Excel, Word, Concur, Share-point, Hyperion, ESSBASE, and Budgeting & Forecasting. Active Secret Clearance.
PROFESSIONAL EXPERIENCE:
Confidential, Pleasanton, CA
Financial Analyst
Responsibilities:
- Responsible for the timely, accurate, entry and maintenance of trade promotions in SAP-R3 Trade Promotions.
- Forecast and track marketing and sales trends, analyzing collected data. Hyperion Essbase, Cognos, Ariba.
- Drive sales results through strong verbal and written communication and issue resolution. SAP Project (PPM).
- Maintain a strong control environment with Monthly accruals, Contract approvals and verifications. R2R, P2P.
- Create an inclusive and cherishing environment with leadership management skills. PO creation and analysis.
- Forge strong relationships with key constituents and cross-functional partners.
- Excel-V-lookups, Pivot tables. SQL scripts, Ad-Hoc analysis and reporting.
- Performed FP&A tasks such as: Metric modeling, Root cause analysis, Supply Chain management, highlighting deviations from budget / forecasts and discuss action plans. Invoice processing, financial modeling, ASM contact data base according to GAAP/SEC Process documentation.
- Business Intelligence, Operational/Financial audits.ACH, Wire Transfers, Cash Deposits/Management, Treasury and Sales Incentive compensation system.
- Provided analytical and planning support to senior management as well as to the finance team.
- Drafted, verified and reviewed Food and Beverage contracts.
- Our streamed lined business cases would show Operational drivers, Service issues, and Cost and implementation milestones, automated reconciliations systems, IT Asset/License Management, compliance reporting.
Confidential, Hayward, CA
Financial Analyst
Responsibilities:
- Successfully managed Order to Cash count transfer from their Hayward to their Fremont Warehouse.
- Transacted O2C, R2R, P2P, billing data into their SAP-R3 module, PO creation and Analysis. Excel-V-lookups
- Worked with firm’s guidelines regarding vendor review, project coordination, timeline Management, Operational/Financial audit analysis.
- Drafted, verified and reviewed hardware/software component contracts, which portrayed Operational drivers, Service issues, Cost implementation milestones and new Product costing, inventory management, variance analysis and financial modeling.MS Access, Outlook, data analysis and creating queries. Reconciled Standard costing variance in construction projects.
- IT Asset Management reporting.
Confidential, San Francisco, CA
AR/Financial Analyst
Responsibilities:
- Successfully managed and reduced Day Sales Outstanding (DSO), executed Intra-company process for intra-company billing. Supply Chain Management. Budgeting and forecasting. O2C, R2R Process assessment.
- Invoice processing, Contract verifications, solved issues with suppliers, Supply chain management, Ariba.
- Utilized QuickBooks, SAP-R3, PO creation and analysis, Salesforce.com, Lynx, Sox Compliance, Clarity
- Automated reconciliation system in SAP-R3 A/R sub-ledger monthly, Month end closing. Hyperion Essbase. ACH, Excel: Lookups, Pivot tables, Macros, Wire transfers, Cash Deposit MS Access, Outlook, Concur experience,
Confidential, Berkeley, CA
Senior Cost Accountant
Responsibilities:
- Directed Financial reporting/General ledger, pre-paid, received not vouchered, credit cards.
- Transacted period end journal entries and account analysis for Payroll, Receivables, Payables and Accruals. Supervised MEC, reconciled balance sheet accounts. Sales & Use tax, Inventory, P2P, O2C R2R. Audit Compliance, compiled data from Business Objects/Warehouse, SharePoint and SQL data analysis.
- ROI & payback analysis. Interfaced with Suppliers for cost expenditures, Access, Clarity and WIP.
- Initiated accrual journal entries, and variance analysis. (GAAP), RMA’s Hyperion Essbase, Cognos, Ariba.
- Utilized ORACLE11E-Business Intelligence Enterprise, data valuation, Excel, Macros, V-lookups, Pivot tables. Inventory management, product costing, purchase close process, facility headcount, PPV and COGS.
- Prepared Concur expense reporting. MEC, Salesforce.com, Business Warehouse FP&A reporting.
Confidential, San Ramon, CA
Financial Budget Analyst
Responsibilities:
- Management of Capital budgets-approve, write, track, transfer job totaling hundreds of millions, Financial analysis, large project management across multiple partner firms.
- Analyzing data regarding Budget status produced daily, weekly, monthly reports for senior management.
- Managed project status, risks and achieved intended results, sourcing and contract management.
- Resolve spend categories. Transacted procure to pay, Inventory and telecom accounting, Financial modeling and Salesforce.com. Excel V-lookups, Pivot tables.
- Procure to Pay, billing, cash applications, and record to reports on a daily and weekly basis. ROI analysis.
- Utilized ORACLE Hyperion security11i, R12, Business Intelligence Enterprise, SQL, Google docs, Vertex, Cognos, (GAAP), Word, Share-point, and Budgeting & Forecasting.
- Maintained supplier DB for new projects, rebate analysis.
- Drafted, verified and reviewed sustaining enterprise, Network engineering, IT, Migrated and Ethernet contracts for cost variances, Compliance reporting, tracked software/hardware usage.
- Analysis of F/A shells, retirements, WIP, A/P, P/O Analysis, BOM, Inventory, capitalization, depreciation methods.
- Supervised M/E and project accounting. Supply chain management. Worked closely with suppliers, Metric/Root Cause analysis, OEM Spec and standards library, OEM Product Life cycle, technical and sales force SharePoint data. Automated reconciliations in Oracle 11i, resolve issues, ensure accuracy of submittals.
- FP&A analysis, process and procurement, Consolidated programs related to PO’s, in tracking sourcing.
Confidential, SC
Fixed Asset Accountant
Responsibilities:
- Initiated monthly & annual journal entries and annual audit schedules.
- Executed Journal & Cash disbursement transfers.
- Utilized Oracle 11i, R12, Cognos BI, (IFRS)
- Directed evaluations on projects, $10 million (Financial management) Budgeting, Forecasting.
- Oversaw cost allot for R&D, Sales, RMA’s, G&A, Labor & O/H. Access & Excel V-Lookups, Macros, Pivot tables
- Utilized SAP-R3 Hyperion ESSDB, Business Warehouse reporting, F/A, A/P A/R, P/O, & G/L modules, prepaid & accruals.
- Prepared custom presentations and sales collateral. SEC, International Accounting reconciliations.
- Resolved variances and budget allocations, SEC 10K & 10Q documentation. Sourcing for manufacturing devices, specifications, and cost and market analysis and executed contracts.
- Earned Value Management in SAP-R3.
- Reconciliation between SAP-R3 and Hyperion, Created financial reports for revenue, expenses and transacted P&L by profit center.
- Supervised F/A schedules, created Roll-forward F/A & Capital leases. SOP-97-2.
- Consolidations, Sox and (GAAP) compliance. Revenue Recognition, Capital leases ASC-840 .
- Worked on both SAP BPC Consolidation and Budget configuration and process.
- Focus on Internal Audit experience, Test key Controls, SAP Business Data Ware House and using the SAP BI to support SEM-BPS/BPC planning and simulation.
- OEM Approval process, OEM Spec and standards library, OEM Product Life cycle, technical and sales force SharePoint data. Documenting the process of work, resolve issues, ensure accuracy of submittals.
Confidential
Senior A/P Analyst
Responsibilities:
- Managed analysis and accurate internal M/E utilizing ORACLE 11i, Hyperion & Cognos resolved all Property tenant issues.
- Executed semi-monthly payroll journal entries, Multi-state. ADP, Pay Force, QuickBooks, (GAAP) Six Sigma metrics, Def. Rent, V-Lookups, Pivot tables and Macros.
- Analyzed Bank Recs. & Cash disbursements for the M/M, P/R, General accounts, MEC.
- Initiated monthly & quarterly M/E & P/R related asset &liability accounts. (Two contracts)
- Oversaw re-class, accrual & reversal journal entries & STD variance analysis.
Confidential, Hayward, CA
Senior Accountant
Responsibilities:
- Directed A/P, A/R, Bank reconciliation's, Cash Deposits, Management, ACH, Wire Transfers, Treasury, FA schedules and Depreciation.
- Compliance reporting, It Asset Management, tracked Hardware/software usage.
- Interfaced with President regarding billing, credit & collection issues and variance analysis.1099 reporting.
- Reengineered yearly tax and audit schedules for CPA auditors. QuickBooks Enterprise (GAAP).
Confidential, Hayward, CA
Senior A/P/Accountant
Responsibilities:
- Supervised monthly balance sheet flux variance analysis for management reporting. M/E close, Access & Excel. JDEdwards to Lawson Financials-Hyperion-ESSDB. Sox Compliance experience, JD Edwards: AP, GL, PO.
- Complied with U.S. (GAAP) worked with Software team in GL, BS, coding issues & reporting. Financial modeling.
- Designed the development & maintenance of the account reconciliation process, Excel. Created reclassification accrual journal entries, Internal Audit scope development, Tested key Controls,. Macros, V-Lookups
- Integrated solutions and strategies within Confidential 's customer environment based on analysis business goals.
Confidential, Fremont, CA
Senior Fixed/Cost Accountant
Responsibilities:
- Implemented Sarbanes-Oxley 404 internal documentation, researched accounting treatments related to contracts and presented findings to auditors and upper management.
- Budgeting & Forecasting.
- Procurement, sourcing and contract management.
- Reconciled Standard Costing variances in new construction projects.
- Directed Fixed Asset accounting, Interco-transfers and variance analysis (GAAP).
- Managed roll forward F/A & Cap. Exp. Standards & metrics for evaluation, created J/Es for M/E close, SOX & Consolidation experience, (FASB-109), Business Objects, Cognos, (IFRS). BPC.
- Utilized SAP-R3, Earned Vale Management. Hyperion-Concur expense reports, P/O, A/P, G/L BOMS billings.
- Worked on both SAP BPC Consolidation and Budget configuration and process.
- Focus on Business Intelligence Centric Data Warehouse and SAP BI to support BPC planning and simulation.
- OEM Approval process, OEM Spec and standards library, OEM Product Life cycle, technical and sales force SharePoint data. Documenting the process of work, resolve issues, ensure accuracy of submittals.
Confidential, San Francisco, CA
A/P Analyst
Responsibilities:
- Researched duplicate Accounts Payable payments from . Cognos
- Oracle 11i-Hyperion Security, Essbase (GAAP) AP, GL, and PO Modules, Sox & Consolidation experience.
- Streamlined monthly review of financial results, journal entries and variance analysis.
- Designed quarterly and yearly tax and audit schedules for CPA auditors. Concur expense reporting.