Manager Customer Service

Rafael Guzman

*** **** **** ****** *** ****, New York, NY 10018 347-***-**** ****************@*****.***

Objective:

To be part of a reputed organization that offers diversified exposure to challenging tasks in finance. Moreover, utilize my data analysis and research skills, to contribute to the success of the business as a member of the Finance Department.

Education

CUNY Baruch College, Weissman School of Arts and Sciences, New York, NY Bachelors of Arts Degree in Economics, September 2014

Work Experience:

Frank Recruitment Group, Inc. May 2015 – August 2016

Accounts Receivable (Credit Control)

●Exported client information onto Excel from Sage 50 Accounts to generate a debt management report.

●Organized and manipulated the exported data, utilizing VLOOKUPs, Trim function, Max/IF array formulas, and SUMIF formula to classify debt.

●Created and sent a weekly debtors report to the CFO and Operations Manager, tracked weekly receivables, monthly receivables, projection of expected receivables, and variance of current projection against record month.

●Reconciled account discrepancies by investigating documentation; payments, adjustments, or incorrect payment allocations (including reconciliations of foreign exchange transactions).

●Created and monitored sales invoices and credits.

●Resolved valid or authorized deductions to invoices by entering adjustment entries.

●Researched and applied unallocated funds.

●Assisted in financial management and analysis, as requested.

●Facilitated swift payment of invoices by sending bill reminders and contacting clients with outstanding accounts.

●Went on bank runs for checks received (cash receipts), and reported receivables to the CFO and Accounting Department.

●Assisted management accounts on month-end closing procedures; made sure all receivables were allocated to finalize bank reconciliations; and ensured invoices were generated promptly and sent to clients.

●Prepared customer payment wires, and routed them for approvals before sending payment requests to our A/P manager.

●Interpreted and analyzed the language of contracts with clients, in order to negotiate payment plans, enforce financial obligations, and resolve client disputes on fees.

Google, Inc. (Contract) Oct 2014 – Apr 2015

Finance Assistant (Payables)

●Created requisitions for the Security Department, utilizing Google software, with regards to purchase of new office space and required security staff.

●Created purchase orders for all security services, office space, and other vendor related expenses.

●Updated the purchase order and invoice logs.

●Utilized a combination of VLOOKUPs and Index and Match, to locate purchase orders for specific offices and reported the remaining funds to the security manager.

●Monitored all purchase orders remaining funds to prevent delays on invoice payments.

●Reconciled account statements received from vendors.

●Read the accounts payable aging report using Google PIVT to organize and check estimated payment dates of all unpaid or partially paid invoices.

●Processed invoices and reviewed invoices for approval, dollar amounts, and G/L account coding.

Skills

●Microsoft Excel (intermediate skills): create and utilize VLOOKUPSs, pivot tables, SUMIFs, IF functions, HLOOKUPs, Index and Match, Text-to-columns, Concatenate, Freeze panes, grouping and hiding columns.

●Excellent problem solving skills, and qualitative/quantitative communication skills.

●Stellar attention to detail and high concern for data accuracy excellent research skills and ability to multi task.

●Ability to export data from databases and generate debt reports efficiently.

●Hands-on experience in operating spreadsheets and accounting software (Sage 50 accounts, and learning Sage X3).

●Proven ability to calculate, post, and manage accounting figures and financial records.

●Customer service orientation and negotiation skills.

Contact this candidate