SUMMARY

• A professional achiever in Data mining, areas as Senior Accountant; Financial Business Analyst with Bachelor’s Degree in Finance/ Accounting/Banking from Holy Angel University, I have good experience in test coordination, Production Support, Requirements Gathering System Enhancement Request Management, Managing status Project Costing (ALM) Considerable years of experience working for large corporations like, PG&E, Kaiser & Chevron.
• Preparing and managing companywide budgets, business finance, cost model accounting, etc. has full grasped on supporting Project management and their programs improving existing processes, Excel VBA program. A proficient with Excel using Pivot tables, Vlookups, and data analysis. Also well versed with SAP, Hyperion, Oracle 12, PeopleSoft and the use of SharePoint, JD Edward & One Link - , Click View, Taulia, SQL Loader, Data warehouse
• 8 + years of strong, International Accounting, Business Systems Analysis, Financial/ Banking, manufacturing operations experiences. Liaison with auditors likes Ernst &Young/Price Water/ Deloitte on various control test work implementation such as SAAS, in compliance, SEC, regulatory procedures, etc.
• Responsible, perform budgeting, forecasting, internal auditing and financial analyses. Work with minimal supervision, reporting to VP of Finance & Accounting.
• Analyze, reconcile and prepare elements of balance sheets, profit and loss statements and other formal financial reports on a scheduled basis: Experience working with batches & UAT, during systems migration.
• Prepare and monitor budgets for assigned business units
• Analyze to predict future revenues and expenses to support quarterly forecasting and annual budgeting
• Analyze expenses/spending/trends, develop budgets in support of labor, overhead, capital, headcount, sales and inter-company transactions and monitor actual versus budget variances on a monthly basis
• Perform account reconciliation for fixed assets, other assets, inventory, liability and equity
• Perform all capital asset related tracking, accounting and financial reporting schedules
• Complete monthly financial and/or financial reporting narratives, schedules and budgets including ad hoc reports
• Complete monthly management report reviews including maintenance of schedules and databases
• Maintain high quality of work by reviewing output and ensuring accurate distribution of information
• Perform other duties as assigned

TECHNICAL SKILLS

• GAAP
• IFRS
• FASB
• GASB
• MS Office-Excel
• Word
• PowerPoint
• Access
• Lawson
• Crystal Reporting
• SQL Loader; PeopleSoft
• Oracle 12
• Catalyst
• ARIBA/XML
• JD Edwards
• SAP/ERP-FICO/BW/R/3
• EPICOR
• Hyperion Essbase
• Financial Management (HFM)
• BI Enterprise (creating mgmt./ building Hierarchy report)
• FRX
• Fixed Assets module
• Solomon
• SAAS
• ADP
• ERP
• Timberline
• S400
• MAS-90
• MRP/Inventory QAD Mfg. Production system
• CICS Mainframe/MIDAS
• Peachtree
• Tableau
• Taulia
• Backline
• Concur
• DBW
• Coupa
• Quickbooks
• SharePoint
• Click view

PROFESSIONAL EXPERIENCE

Confidential

Senior Financial Analyst Cost Project

Responsibilities:

• Responsible in huge data analysis retrieved from systems, preparing Financial Liability Reporting on costing to upper management. Assisting Projects Manager: Responsible for Assisting in managing the EGI process; DG & Transmission Departments.
• Reviewing WD Study, close out projects order # (PO’S) in the electrical interconnection for customers.
• Responsible for preparation of management reporting, analyzing, DS reconciliation, handling customers refunds, billings. Work/support various groups in the organization to achieve results plus productivity.
• Researched and problem solved in various areas such as accounting and finance.
• Responsible for supporting various departments/units within the organization such as Corporate Accounting: Business Finance; Transmissions;
• Responsible for overseeing the accounting details related to the projects by functioning as the primary financial contact to the project management team
• Responsible for reviewing, tracking & reconciling construction expenditures
• Communicate with project managers, vendors, and external parties to ensure information is communicated timely between all parties
• Assist in the development/enhancement of Standard Operating Procedures (SOP) around project reporting and reconciliations.
• Created managed PO’s for capital projects
• Ensure compliance for all internal audit requirements

Environment: Data warehouse, SQL, Oracle 12, Hyperion Financial Mgmt. ERP (HFM); ARIBA, SAP FICO- BI, ERP; MS Office-Excel, Access, Word, PowerPoint/ARIBA/XML, SharePoint ( users archived/ share reports).

Confidential, Oakland, CA

Senior Research Financial Data Analysis (direct contract)

Responsibilities:

• Responsible, Review, Prepare account reconciliations for fixed assets, cash accounts and other balance sheet accounts as assigned.
• Responsible, prepare monthly journal entries for a variety of general accruals.
• Responsible, manage, prepare the accounting entries fixed assets including the preparation, capitalization, FA reporting
• Work with operations to ensure disposal and impairment are accurately reflected.
• Assist in the implementation of a monthly process to account for capitalization costs on office & building equipment & worked with IT
• Responsible, prepare monthly allocations to support management reporting.
• Manage corporate credit cards payments and follow up as needed.
• Responsible, resolving any issues or discrepancies on payments with the accounts payable team on the employee expense reimbursements.
• Interacts, work with AP to properly account for pass through expenses to third parties.
• Responsible, manage any applicable sales tax reporting for various states and entities.
• Responsible, prepare, on the monthly and quarterly balance sheet and income statement analytics, 10Q/10K/P&L.
• Conduct internal audits/ support external auditors on annual audit by preparing and overseeing certain tasks for business process improvement.
• Worked extensively in developing and maintaining finance and accounting operations and controls.
• Managed, resolved accounting matters with other accounting team members, departments, and business units.
• Managed Accounting, Analysis, and Reporting-Banking; Wire Transfers Cash
• Prepared reconciles various AP general ledger (GL) liability accounts: Vendor liability, Goods Receipt/Invoice Receipt (GR/IR) clearing, Sales & Use Tax, Garnishment, commission, etc.
• Interacts, work with AP to properly account for pass through expenses to third parties.
• Responsible, manage any applicable sales tax reporting for various states and entities.
• Responsible, prepare, on the monthly and quarterly balance sheet and income statement analytics, 10Q/10K/P&L. Conduct internal audits/ support external auditors on annual audit by preparing and overseeing certain tasks for business process improvement. Prepares monthly cost repost charge-back accounting entries and reporting for AP Manager and Payment Services Director. Audits the daily potential duplicate report reviews completed by clerical staff.
• Responsible in training director’s assistants in reconciling transactions entries to match Purchasing orders against invoices variances.

Environment: SAP, ERP, MS Office-Excel, Access, Word, PowerPoint, AP Accounting Systems, Tableau, Concur

Confidential, Oakland, CA.

Business Data Analyst Financial - Supply Chains Procurement Contract Pricing

Responsibilities:

• Recommends controls by identifying problems; writing improved procedures. Defines project requirements by identifying project milestones, phases, and elements; forming project team.
• Actively seeks to streamline crossover of data between multiple ERP - SAP, Oracle R12, database and accounting systems. Track payments, and troubleshoot issues.
• Responsible in finding resolution on contract pricing discrepancies due to systems implementation errors
• Assisted and identified systems rejects, led to a new created systems redesigned, it was successful.
• Responsible in month-end and year-end closing and preparation of reports to Directors
• Performs detailed financial statement analysis and creates effective reporting
• Prepares and assists with audit related issues and projects as defined by the Controller
• Actively seeks to streamline crossover of data between multiple ERP, database and accounting systems
• Assists Controller in preparation of annual budget, incorporating forecasts, volume projections and capital needs
• Prepares and generates monthly balance sheets, income statements, and ad hoc reports as directed by the Controller
• Suggests and drives efficiencies in the reporting systems
• Reviews & analyzes department expenses
• Balancing; Analyzing validating of international cash account reconciliation on General Ledger items and banks statements. Prepared 10Q /10K, journal entries, quarterly B/S financial reports for all accounts.
• Responsible in creating new files for Balance sheet reconciliation on GL accounts of company’s foreign offices.

Environment: SAP, Oracle, General Ledger, B/S financial reports, MS Office, Access, Data warehouse, SQL

Confidential, San Ramon, CA

Financial Analyst- AP/Invoicing

Responsibilities:

• Analyzed Project Capital Expenditure costs in terms of budgeting; forecasting; actual on SO/PO expenses.
• Managed/reconciled huge suppliers globally such IBM, CompuCom & others that entries, taxes issue are being resolved & free from errors. Analysis on tariffs tax, if applied to right locations & if not, trouble shoot the problem.
• Responsible for managing SAP-entering/ analyzing on PO’s if funded properly by buyers, before payments.
• Accomplished/contributed to accurate analysis, timely, reconciled and efficient invoice processing,
• Responsible for preparing the monthly consolidate financial reporting schedules on BS Statement, such A/R
• Managed Fixed Assets Inventory Management System & produced monthly analysis reports.
• Responsible for nationwide vendors set up maintenance requests; billings, Tax preparation extension & etc.
• Prepared capitalization, depreciation, transfers, retirements, managed FAS, created new assets capitalization.
• Review, approve & prepare receipts of PO’s on AP vendors invoices before payments.
• Reconciliation of FA, employee expense relocation, prepaid rent, amortization and insurance.
• Prepared created audit trails of all the fixed assets captured as of years 2004-2005 & 2006..
• Responsible in creating books as audit procedures of all the expenses-FA to be utilized by upper management.
• Analyzing of all fixed assets on accounts payables and categorizes them what went to building, leasehold & etc.

Environment: Yardi, fixed assets, frozen ledgers, open items, accounts payables

Confidential, Pleasanton, CA

Senior Accountant IV-Construction Capital- Fixed Assets/ Property Development Accounting Reporting

Responsibilities:

• Worked maintained MS Access in tracking (Real Estate Access Sys), constructions vendor’s activities WIP (WIP/CIP), tag office or building equipment as capital assets upon 98% completion of the project
• Analysis of capital expenditure costs in terms of budgeting; forecasting; actual &
• Analysis; preparation of financial statement accounting - reporting on fixed assets (sales; purchases, etc.
• Analysis; capitalization of Construction in process (CIP/CAM) on projects with 95% completion.
• Responsible, prepare monthly journal entries for a variety of general accruals.
• Responsible, manage, prepare the accounting entries fixed assets including the preparation, capitalization, FA reporting
• Work with operations to ensure disposal and impairment are accurately reflected.
• Assist in the implementation of a monthly process to account for capitalization costs on office & building equipment & worked with IT
• Prepare account reconciliations for fixed assets, cash accounts and other balance sheet accounts as assigned.
• Preparing various monthly, quarterly and year-end financial reporting schedules requirement on Fixed Assets.
• Make appropriate accounting entries created batches and maintain supporting schedules.
• Close out construction projects and set up inter-company rent billing.
• Process payments for fixed and percentage rent/ processing heavy load of vendors accounts payables.
• Make deposits and appropriate accounting entries; post journal entries to REAS and Lawson.
• Assist in implementation and UAT support of new accounting system,
• Prepared, completed financial consolidated reporting for all entities, following SEC filings procedures.
• Responsible for auditing, organizing, reconciling, analyzing, preparing the general ledgers certifications for external auditors to review. Utilized Oracle/PeopleSoft.
• Treasury Analyst Senior/ nationwide Systems EDI Analysis /Banking Deposits Validation
• Analysis, reconciliation of entire company EDI transmitted EFT versus banking deposits (A/R) credits before & after system conversion from Wells Fargo Bank to JP Morgan Chase. Input wire transfer into direct line system.
• Performing capital A/R recovery on revenues and validate transactions, analysis/balancing of EDI-General Ledgers entries. Environment: A/R, EDI-General Ledgers, Access, banks deposits reconciliation audits research

Confidential, San Francisco, CA

International Technical Accounting Supervisor

Responsibilities:

• Assistant to the Vice President in preparing Loans financial accounting management reports & general accounting
• Maintained accurate Financial Statement Consolidated Management & SEC reporting worked with internal/external Auditors due to this process finance/accounting received very good audits yearly. Assumed the Union Bank New York Office customers accounts during the September 11 due to lost records.
• Analyzed, monitored, reviewed the daily trial balance for all GL journal entries input, checked audits exception.
• Supervising, auditing daily staffs work process, in Int’l Accounting-Operation/Finance & Mgmt. Reporting Dept.
• Reviewed and approved the accuracy of all daily and monthly federal reports, expenses, and journal entries processed by staff. Reviewed daily exception report on released batches items transactions, if any issues, do search and resolve on problems pertaining on input against out put. Items data
• Analyzing, auditing, reconciling and producing reports on timely basis such as schedules, memos on bank’s general allocation expenses for all U.S. & Overseas branches.
• Implemented daily internal audit controls, following rules and guidelines in according to the General Accepted Accounting Principles.
• Produced accurate consolidated monthly International Management System Statewide Outstanding reports on various customer loan accounts. Analyze monthly profitability reports before circulation.
• Responsible in analyzing all clearing, suspense and GL accounts balances, assisting and directing staff in tracing open items to the appropriate department.
• Monitored inter-company and accounts payable expenses for valid approval. Assist with special projects assigned. Assisted in new systems migration, before production by monitoring items rejects during UAT
• Prepare account reconciliations for fixed assets, cash accounts and other balance sheet accounts as assigned.
• Responsible, prepare monthly allocations to support management reporting.
• Manage corporate credit cards payments and follow up as needed.
• Responsible, resolving any issues or discrepancies on payments with the accounts payable team on the employee expense reimbursements.
• Reviewed and approved all the daily GL’s reconcilements and GL’s monthly proofs certifications prepare by staff, for U.S branches.
• Helped in merger / acquisition of new offices nationwide, Analysis of Capital versus expenses.
• Responsible in adding data on new offices acquired during merger booking the data into the Financial Statement, once the acquisition project complete.

Environment: Midas, CICS, Mainframe, Crystal Reporting-SQL, GL journal entries, Access Excel, Data Warehouse,SQL