A professional achiever in Data mining Analytical

LETICIA DELOS REYES ALIOTO

Pleasanton, CA ***** / Tel#925-***-**** / Email:*******@***.***

7+ years of strong, International Business Systems Financial Analysis, Accounting-Banking, manufacturing operations experiences including company-wide budget preparation, procurement/P2P, AP/Invoicing/ billings, sec reporting, entities consolidation, revenue recognition, internal audits.

GL Accts. EDI-Reconciliation, Month-end closing, costing, retail banking operations.

Recovery of revenue on capital assets, aging stale A/R collections, A/P, Telecom billings. G&A allocations. Creating audits trails on fixed assets-capitalization during conversion.

Reconciled aging A/R, charge-backs &Contract Administration, recovered millions of dollars. Implemented business process improvement in reducing costs. Team up with Projects Managers, making sure all trans data is in compliance, valid & within the budget.

6+ years of SAP experience including: data retrieval, participated in company’s systems conversion.

7+ years of experience with accounts payable, accounts receivable and general ledgers.

Analyzed Project Capital Expenditure costs in terms of budgeting; forecasting; actual on SO/PO expenses.

Responsible in handling & analyzing information on IT software equipment AP required for payments from customers/ vendors & supplier globally. Monitored work in progress completion (WIP).

Responsible in supporting a multinational IT Procurement organization.

Performed root cause analysis on problems and resolved; supporting partners across the enterprise and working in a complex systems environment.

Performed technical analysis on systems configurations; example XML versus DTD & etc.

Highly familiar with project management work involving financial analyst/costs/CIP expenses/relocation.

GAAP and SOX policies and procedures. Experience in merging/acquisition, on goods; products; or offices.

Bachelor of Science in Business Administration – Major in Finance-Banking and Accounting/Analysis

Industries: Pharmaceutical, Telecommunication, High Tech, Biotech/Healthcare, Financial, Real Estate, Energy Gas &Oil. CPA Candidate in process.

Ongoing training with GAAP and Sarbanes Oxley’s’ principles, procedures and policies in progress.

Technical Summary:

GAAP, FASB, GASB, MS Office-Excel, Word, PowerPoint, Lotus 123, AmiPro, Freelance, Access, Lawson, Crystal Reporting, PeopleSoft V8.9, Oracle 1V, JD Edwards, Peachtree, New Solution, SAP R/3, EPICOR, Hyperion Essbase, FRX, Fixed Assets module, Solomon, ADP, ERP, New solution, Peachtree, Timberline, Platinum SQL, Focus/Tso, Monarch V7, IBIS, AS400, MAS-90, Arriba, MRP/Inventory QAD Mfg. Production system, QuickBooks pro, NetSuite, Lotus 123, Word Perfect, Paradox, IBIS, CICS Mainframe.

Education:

Bachelor of Science, Business Administration, Holy Angel University, Angeles City, Philippines (Graduated)

Continuation on Professional Education (CPE) In Budgeting Intelligence; Forecasting; Capitalization

Rec’d 2014-Certificate of Completion/Fraud Control Training/Field Of Study-Regulatory Ethics (CPE Credits-2.0) at KP.

Detailed Experience:

Employer: FINEZA Consulting Agency May 2015 - November 2016

Client: PG&E San Francisco, CA

Senior Accountant/ Financial Analyst Project mgmt./ Dept. Electric Assets Mgmt.-Financial Operations

Prepare 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;

DG Interconnection; Wholesales Distribution. Guiding/ supporting all the Projects Manager in Engineering Electric dept., & etc. Great business interaction & communication with upper management

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

Assist with construction project analysis and reporting

Create and manage purchase orders for capital projects

Ensure compliance for all internal audit requirements

Employer: Rose International, Consulting, April 2014 to –April 2015

Client: Kaiser Permanente (contract), Oakland, CA,

Senior Accountant / Research Data Finance Analysis

Fixed Assets Management-Capital Property Accounting/Financial Reporting.

Responsible for analyzing account transactions, preparing complex account reconciliations, resolving reconciling items, and preparing accounting statements and report.

Plans, coordinates and resolves accounting matters with other accounting team members, departments, and business units.

Develops solutions to accounting problems of moderate scope and complexity.

Assists with audit requirements and is responsible for information requests.

Identifies and communicates opportunities for change to improve performance.

Identifies and communicates system problems to management.

Reviews posting of automated, system-generated entries.

Utilizes tools such as system queries and download, Excel functions (pivot tables and Vlookup) and Access database.

Facilitates productivity, system and procedural changes to streamline processes and increase productivity.

Participates in departmental projects and initiatives. Participates effectively in a team environment.

Participates in Finance area projects as needed.

Ensures that general ledger and sub-ledger are reconciled and reconciling items are resolved.

Prepares schedules, supporting documents, and variance analyses for management.

Prepares account reconciliations for moderate to complex accounts.

Communicates issues and resolutions to management and affected areas/departments. Coordinates solutions to problems of moderate complexity with other departments and business units.

Monitors work for proper internal controls and SOX requirements and recommends improvements.

Employer: AMERIT Consulting, Inc., October 2013 to February 2014

Client: Pacific Gas & Electric Corporation (contract), San Francisco, CA, Business Analyst/ Accounting Systems

(Project complete) 94 % PGE goal, but 96% was achieved above beyond.

Accounting, Analysis, and Reporting-Banking; Wire Transfers Cash

Analyzes and reconciles various AP general ledger (GL) liability accounts: Vendor liability, Goods Receipt/Invoice Receipt (GR/IR) clearing, Sales & Use Tax, Garnishment, etc.

Analyzes and prepares monthly past due blocked PO invoice report for distribution with roll-up to officer levels for different Line of Business.

Responsible before payment in validating, analyzing; processing on banking cash wire transfers request from upper management.

Prepares monthly cost repost charge-back accounting entries and reporting for AP Manager and Payment Services Director.

Analyzes and runs ad-hoc reports for clients and AP management as needed.

Audit, Controls

Audits the daily potential duplicate report reviews completed by clerical staff.

Updates AP desk procedures and AP website information to include revisions as needed.

Provides technical analysis and support for various audit responses.

Environment: SAP R3, Taulia - Cockpit Vendors Systems; MS Office-Excel, Access, Word, PowerPoint

Employer: MODIS Staffing, February 2013 to September 2013

Client: Kaiser Permanente (contract), Oakland, CA, Business Financial Analyst Consultant

Analyze/study the overall business and information needs of an organization in order to develop solutions to business and related technology problems. Analyze match exception data for buy–to-buy transactions across KP.

Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats. Works closely with clients to identify business needs and the costs/benefits of implementing a computing solution.

Analyzing requirements; constructing workflow charts and diagrams; studying system capabilities; writing specifications. Improves systems by studying current practices; designing modifications.

Recommends controls by identifying problems; writing improved procedures. Defines project requirements by identifying project milestones, phases, and elements; forming project team.

Monitors project progress by tracking activity; resolving problems; publishing progress reports; recommending actions. Contributes to team effort by accomplishing related results as needed.

Actively seeks to streamline crossover of data between multiple ERP – SAP, Oracle R12, database and accounting systems. Track payments, and troubleshoot issues.

Environment: MS Office-Excel, Access, Word, PowerPoint

Employer: R & D Technologies, March 2012 to December 2012

Client: RH USA Inc. (contract), Livermore, CA, Senior Financial Analyst / General Accounting (project complete)

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

Responsible in finance & accounting overall general operations

Environment: MS Office-Excel, Access, Word, PowerPoint

Employer: Nelson Associates, March 2011 to November 2011

Client: Dolby Laboratories (contract), San Francisco, CA, Accountant (project complete)

Balancing; Analyzing validating of international cash account reconciliation on General Ledger items and banks statements.

Preparing journal entries, quarterly B/S financial reports for all accounts.

Assisting in monthly/ quarter-end close and special projects assign in accounting/finance.

Responsible in creating new files for Balance sheet reconciliation on general ledger accounts of company’s foreign offices.

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

Employer: Ascent Technologies, January 2009 to December 2010

Client: Chevron Energy, Oil and Gas, Financial Analyst- AP/Invoicing- IT Procurement ( Consultant), San Ramon, CA,

IT Procure to pay/Procurement, utilizing SAP and Arriba/Oracle

Used JDE accounting system to introduce, enter vendors file maintenance profiles as follows their names, addresses, payment terms, for SAP accounting systems to read and makes funds available for valid vendors/suppliers, purpose for activation & validation for payment processing & etc.

Analyzed Project Capital Expenditure costs in terms of budgeting; forecasting; actual on SO/PO expenses.

Responsible in handling & analyzing information on IT software equipment accounts payables required for payments from customers/ vendors & supplier globally.

Managed/reconciled huge suppliers globally such IBM, CompuCom & others that entries, taxes issues are being resolved & free from errors.

Responsible for problem solving presented by business partners, in providing service satisfaction.

Responsible for managing SAP-entering/ analyzing on PO’s if funded properly by buyers, before payments.

Responsible for processing vendors invoices in Arriba system-accounting interfacing SAP accounting.

Responsible in general ledger reconciliation and ad hoc reporting.

Accomplished/contributed to accurate analysis, timely, reconciled and efficient invoice processing,

Successful in making recommendations to increase efficiency and reduce process time.

Responsible in supporting a multinational Procurement organization, analyzing; solving problems and supporting partners across the enterprise and working in a complex systems environment.

Environment: SAP, Arriba, Oracle, JDE accounting system, MS Office

Employer: Nelson Associates, June 2007 to August 2008

Client: Signature Properties (contract), Pleasanton, CA, Senior Finance Analysis/Accounting/AP/Fixed Assets

Senior Accountant /Financial Analyst – Entities Consolidation Corporate Real Estate, utilizing JDE/Oracle

Hyperion Essbase Oracle operating system / work experience/ knowledge.

Responsible for preparing the monthly consolidate financial reporting schedules on Balance Sheet Statement, such as Receivables; Notes; Due to (due from); Other liabilities; Other Assets & Income Sheet Statement; such as Interest/other Income/Expense & Political Contribution.

Managed Fixed Assets Inventory Management System & produced monthly analysis reports.

Processed various journal entries for all entities and reconciling Accounts Payables.

Daily run reports from system Budgetrac to update JDE database plus maintaining records on WFB website regarding checks issued. Responsible for system update & validation through careful analysis of all various activities transactions.

Prepared and loaded all bank’s entries like cash receipts; deposits; wire transfers & withdrawals for all entities. Responsible for nationwide vendors set up maintenance requests; billings & etc.

Participated & assisted in validation of all the company’s entities general ledgers accounts before system conversion, through reconciling and mapping.

Analyzed charts of accounts created successful transition into JDE (Oracle)-accounting system.

Analyzed, prepared and calculated company tax insurance.

Prepared tax extension check request payment.

Environment: Hyperion Essbase Oracle operating system, Balance Sheet Statement, Fixed Assets Inventory Management System, Budgetrac, JDE database, MS Office

Employer: Ajilon, October 2006 to March 2007

Client: Sirna Therapeutic/Merck Pharm (FTE), San Francisco, CA, And Corporate Senior Accountant

Analysis of new products or name brand acquired from pharmaceutical companies, their P&L

Accounting, Research & Development.

Performs monthly fixed asset analysis, review and reporting.

Process capitalization, depreciation, transfers, retirements, etc.

Prepare JV’s on journal entries regarding re-class to expense, CIP (construction in progress).

Update FAS; create new assets after careful analysis on capitalization.

Review, approve & prepare receipts of PO’s on AP vendors invoices before payments.

Conducts random reviews and audits. Prepares findings for submission to management.

Works with large volume of data on a day-to-day basis. Undertakes other projects related to fixed assets. Reconciliation of FA, employee expense relocation, prepaid rent, amortization and insurance. Loading & analyzing of Balance Sheet in Solomon (General ledgers accounts) balances on NBV, depreciation & adjustment, etc.

Environment: fixed asset analysis, MS Office, Balance Sheet

Employer: Accountemps, July 2006 to October 2006

Client: West One Financial Group (contract), Livermore, CA, Senior Accountant

Analyzing, preparing, and creating audit trails of all the fixed assets captured as of years 2004-2005 & 2006.

Responsible in heavy reconciliation of all frozen ledgers, open items, matching them before system conversion.

Responsible in creating templates with explanation for all assets ID # on capitalization of past book transactions.

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: fixed assets, frozen ledgers, open items, accounts payables

Employer: Safeway Companies (FTE), Pleasanton, CA, Senior Accountant IV, March 2004 to June 2006

Financial Reporting, utilizing Lawson/ Crystal Reporting

Utilized MS Access in tracking (Real Estate Access Systems), constructions vendor’s activities during work in progress (WIP/CIP), and tag the office or building equipment as capital assets upon 98% completion of the project then release the retention fees to the vendors. Creating, producing an accurate fixed assets inventory reporting for distribution to upper management & Property development department at month end closing.

Analysis of capital expenditure costs in terms of budgeting; forecasting; actual & commitment on various projects.

Record expense portion of prepaid, accrued, deferred, on –operating rent & taxes.

Analysis; preparation of financial statement accounting – reporting on fixed assets (sales; purchases; repurchases, capital spending; nonop) general ledger transactions accounts on Real Estate at month end closing.

Analysis; capitalization of Construction in process (CIP/CAM) on projects with 95% completion.

Preparing various monthly, quarterly and year-end financial reporting schedules requirement on Fixed Assets.

Make appropriate accounting entries 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 support of new accounting system.

Provide support to management and perform other task as needed & etc.

Environment: Lawson, Crystal Reporting, budgeting, forecasting, financial statement accounting, fixed assets, REAS (Real Estate Access Systems)

Employer: Ajilon, January 2004 to March 2004

Client: Franklin Templeton companies LLC (contract), San Mateo, CA, and Senior Accounting Analyst

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.

Environment: SEC filings procedures, Oracle, PeopleSoft

Employer: Core-Mark International (direct contract), San Francisco, Treasury Analyst,

July 2003 to December 2003

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

Employer: Union Bank of California (FTE), San Francisco, CA, Technical Accounting Supervisor,

September 1999 to March 2003

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.

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.

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: GL journal entries, Access, Excel

Contact this candidate