Trevor Lofton

**** ***** *******, #*** / ******, Texas 75219 / 469-***-**** (Mobile/Voice Mail)

Experience:

Accounts Payable

Bank Reconciliations / Wire Transfers

Accounts Receivable

Financial Analysis

Credit/Collections

Cash Flow Analysis

Joint Interest Billing

Lease Contracts

Purchase Orders

Lease Proposals

Master Data Integrity

Budgets

Employment History:

Atos (contract assignment), Financial Analyst 10/15 –3/16

Retrieved financial data (Profit & Loss, Balance Sheet, and other Key Financial Indicators) from JDE Edwards and Hyperion Essbase into MS Excel.

Manipulated data using MS Excel, and filling out web forms and / or MS Excel workbooks in order to transmit financial data to Corporate HQ in France. Included doing currency conversion for all multiple foreign business units.

Assisted with budget preparation and balance sheet projects as needed.

Mimi’s LLC (Contract assignment), Food Cost Analyst 5/15 –8/15

Prepared cost of recipe’s for review by the Culinary, Marketing and Executive team to ascertain if the company should proceed with creating a new menu item.

Processed daily sales and traffic reports using Essbase for distribution to the daily distribution.

Reported monthly and quarterly, system-wide sales reports and distributed to the area and regional managers.

FASTSIGNS International, Inc., Accounts Specialist 12/11 –5/15

Second tier collections on Franchise partners 3+ months delinquent in royalties. Negotiated and created payment plans and secured note accounts. Sent Limited Services warning letters if no resolution.

Drafted the Limited Services warning letter template for both domestic and international accounts.

Reported monthly, system-wide sales reports and posted them to the shared site Managed end of the month sales data to create reports for the Field Business Consultants.

Entered Franchise Partners P&L and Balance Sheet information and prepared Financial Analysis for use by the Field Business Consultants. Oversaw the year-end financial survey project receiving 500+ financials and processing them for the CFO to create the year end results.

Participate in weekly meetings with the CFO and Executive Vice President to discuss accounts that needed further escalation or to receive Limited Services letters.

Eagleridge Operating LLC, Accounting Manager 4/08 –3/11

Managed on average 250 invoices per week in Wolfpak. Coded and submitted all field invoices for approval. I approved all rents, utilities, benefits and vehicle payments. Posted JIB payments to their respective accounts and made journal entries to the G/L as required. Processed payroll using Onesource software. Set up new property numbers and AFE’s. Reconciled all bank accounts on a daily basis as to reflect current available cash.

Process all incoming and outgoing wire transfers. Opened new bank accounts as needed.

Built positive, working relationships with external customers, as well as internal personnel, to resolve past due invoices. This included traveling to meet with the vendors to achieve this goal.

Established policies for the department pertaining to expense reports, company credit cards and requests for checks without invoices.

Participate in weekly meetings with the CFO and President/Owner to discuss cash forecasting, check runs and vendor discrepancies. Prepare aging for the monthly board book.

McKesson Corp., Sr. Credit Analyst 12/03 – 4/08

Review all request for credit from private Doctors offices to Major Hospitals using D&B, Biz Info, E-RAM and Experian. Based on information obtained would make the decision to extend credit and assess a credit limit and terms within McKesson guidelines. Approved and submitted request for address changes offsets and refund requests. Assisted the credit manager with other special projects as needed

Managed all enrollment programs ensuring that all criteria and business rules are met while meeting the department service level agreements.

Support three McKesson distribution centers including their new loads, complete deletes and processing general maintenance while building positive, working relationships with the Sales Administrators and DC Management.

Received and processed external files from multiple drug manufactures to enroll McKesson customers into their membership network code.

Wrote Standard Operating Procedures (SOP’s) for desk processes that saved time, steps and expenses.

Trained new coordinator on processing of Medicis accounts, contract lead request and MSTX maintenance while keeping up the excellent relationship that was developed with these business partners. I also serve as backup for this position.

Contract Assignment. Credit Analyst 8/02-1/03

Worked contract assignment while seeking permanent employment in the Dallas Metroplex.

Weatherford international., Accounts Payable/Sr.Credit Analyst 11/98 –2/02

Reviewed customer applications to determine credit worthiness and establish credit limits using D&B, C.I.D. and verifying business/financial references.

Managed a 15 million dollar portfolio of major customer including Shell, Texaco, Enron, Chevron and Hess. Built positive, working relationships with these customers, as well as internal departments, to resolve past due accounts in a timely manner to reduce DSO. This included traveling to meet with the customers to achieve this goal.

Enforced collection policies including placing accounts on credit hold, cash in advance status, 10-day demands and lien filling, as allowed by law.

Processed on average 500 invoices a week. Coded invoices for payment and then verified approval. Followed up with approver to ensure timely turnaround. Prepared weekly cash forecast as well as check run. Processed checks and attached backup and mailed accordingly while maintaining filing. Assisted the Accounts Payable Manager as needed.

Skills:

Windows Versions 98, Vista, 7, 8

Excel

Word for Windows

SAP

Essbase

Oracle - IRIS

Wolfpak Accounting Software

AS 400

Luminate – Financial Analysis Software

Contact this candidate